| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateStreet Address W 35th St NSioux Falls, SD Street Address
Phone PHONE NUMBER AVAILABLEE-mail EMAIL AVAILABLECandidate's Name
ObjectivesUtilizing my years of acquired skills and techniques along with my passion to continually improve professionally and personally to be an asset to my employer.Work experienceApril 2019 Present Payrailz Glastonbury, CTSenior Database Engineer Architect and implement stored procedures, functions and tables to enhance software functionality Build and maintain API infrastructure to further expand software capabilities Develop and enhance standards for development lifecycle (build, test, release, and deploy) to accelerate product releases and minimize defects Work with product owners and business analysts to define business requirements and translate into technical requirements Continually perform above standards to meet and exceed timelines to quickly get features to marketJanuary 2017 April 2019 MetaBank Sioux Falls, SDDatabase Developer II Developed SQL databases to facilitate the storage of various banking data for use within the organization Developed SQL Server Integration Services (SSIS) packages that were responsible for importing, transforming, normalizing and cleansing financial data from multiple vendors into an operational data store and data warehouse systems Developed database stored procedures that were responsible for integrating vendor data from multiple sources (XML, JSON, EBCDIC, CSV, Fixed Width and other files) Developed processes to import or extract data from Microsoft Dynamics CRM for operational data to and from other clients, vendors or 3rd parties to improve utilization of data and operational efficiency of sales, customer service, regulatory, and vendor relations teams. Developed SSIS ETL processes to provide report writers with data for SSRS and Power BI reports, dashboards and KPIs that were accurate and performed efficiently Developed processes to extract data from internal operational data stores, 3rd party applications and data warehouses to provide to outside 3rd parties to support business operations, compliance functions and provide financial reports to regulators Developed exception reports and extracts to provide to business users in order to clean up operational data or provide guidance to users on how to better utilize data Spearheaded expansion of source control utilization to include SQL databases and SSIS packages Developed SQL unit tests to ensure consistent conversion of data from 3rd party vendors and minimize defects and ensure business user satisfaction
Developed and expanded SQL database and SSIS standards and practices throughout the department to improve efficiencies and drive down development issues Mentored other database developers and software engineers on the design of SSIS solutions and data warehouse methodsJanuary 2014 January 2017 Sanford Health Sioux Falls, SDInterface Engineer Performed SQL database development and administration tasks necessary for ETL solutions, data warehouse operations, business applications and SSRS reports such as creating databases, building tables, stored procedures, developing indexing strategies, configuring users, and various troubleshooting tasks Design and develop complex ETL solutions to facilitate data warehouse operations and to provide internal and external customers with data primarily using Microsoft SQL Server Integration Services Design and develop data centric business applications primarily in C# implementing various methodologies including MVC, Entity Framework and others Design and develop SSRS reports based on business and user requirements Implement software development lifecycle processes which included source control, documentation, code reviews, best practices and deployment standards Mentor and guide other interface engineers in the design of ETL solutions, business applications and SSRS reportsFebruary 2013 December 2014 SDN Communications Sioux Falls, SDManaged Services Engineer Engineer, implement, document and manage complex products and data network/SaaS infrastructure for use in hosted environments (Cisco UCS, VMWare, others) Designed and developed .NET API interfaces used to facilitate data driven decisions within various SaaS platforms Mentor and guide junior level engineers and Tier 1 and 2 techniciansJuly 2006 February 2013 CHR Solutions/Martin Group, Inc Mitchell, SDSoftware Activations Technical Lead - Team Lead Developed SQL conversions to convert data from databases, flat files, and various 3rd party systems into SQL databases Developed SQL analytic processes to identify invalid data and normalize and cleanse it into usable data Developed SQL exception reports and extracts to support conversion activities in order for customers to identify product and financial errors within the data Working in the Software Activations department performing both management and technical roles within the team for local and remote staff General management responsibilities including staff mentoring and team building Developed project schedules, staffing reports, and individual and team goals for team Implemented software solutions based upon client requirements within project timelines for projects in excess of $1M Developed applications, database scripts and reports via SQL to reach desired project requirementsEducation 2000 - 2004 Dakota State University Madison, SDElectronic Commerce Major Honors Minor: Center of Excellence in Computer Information Systems Minors: Networking Computer/Network Security Computer Information SystemsVolunteer experience Friend of RedGate member (2018-Present) 605 SQL PASS SQL User Group, Co-Leader (2014-Present) SDN Great Ideas Group (2014) Dakota State University Alumni Board, Member, Vice President and President (2013-2018) Dakota State University Cyber Security Industry Advisory Board (2013-2017) CHR Solutions Prospective Leadership Program, Graduate (2012) American Cancer Society Relay for Life 2007, IT Consultant (2006 2008) Career Service Association Council, Member (2005 2006) Zimmermann Hall Resident Assistant (2002 2004) Zimmermann Residence Hall, President (2002 2002) Dakota State University Center of Excellence, Member (2002 2004) Avera Pediatric Caring for Life Golf Tournament (1999 2005) Computer Club, Executive Director and Vice President (2000 2002) |
