SUMMARY:

Twenty - eight years of experience in Information Technology including combined experience in DevOps, Database Design & Administration, Application Development, Team Leadership, Project Management, and Architecture.

DEVELOPMENT SKILLS INCLUDE:

TFS & VSTS Build and Release

Microsoft Powershell

IBM Urban Code Deploy

TeamCity

Database Build & Deployment Automation

MS Dynamics AX Build Automation

Agile and System Life Cycle methodologies

TFS, GIT, Perforce

REST

Chocolatey

Azure & AWS

VMWare & VirtualBox

Vagrant

Puppet

XML

VB.NET development

Linux

Java

SQL Server Database Administration

Performance Tuning & Capacity Planning

Data Security, Backup & Recovery

TSQL and Powershell scripting

Replication

Clustering

SAN Snapshot backup/recovery

Log shipping

EXPERIENCE:

Confidential, St. Paul, MN

Senior Lead DevOps Release Engineer

Responsibilities:

• Design, enhance, and maintain software builds and releases utilizing TFS/VSTS Build & Release, Powershell, and Visual Studio. Software deployments include SQL Server database updates, .NET applications, Windows Services, SSRS reports, and SSIS packages.
• Work with Development & QA teams to understand deployment requirements to non-production environments.
• Coordinate and perform production deployments.
• Continuously identify processes to improve and utilize new features of TFS/VSTS as they become available.
• Refactored all TFS/VSTS build and release definitions to utilize Confidential to simplify maintenance and increase quality.
• TFS upgrades from TFS 2012 to TFS 2015, TFS 2017, TFS 2018, and VSTS.
• Proof of concept to run automated smoke-tests on remote tablet after deployment.
• Automated process to redeploy and sync the Protocol application on remote tablets.
• Enabled QA team to perform deployments to QA environment (self-service).
• Trained offshore team on how to initiate and troubleshoot QA deployments.
• Database release process enhancements and automation of SSRS builds & releases.

Confidential, Bloomington, MN

Senior DevOps Release Engineer

Responsibilities:

• Design, enhance, and maintain software deployments utilizing TeamCity, uDeploy, Powershell, and Liquibase. Software deployments include SQL Server database updates, Java running on Tomcat and JBoss, and application configurations.
• Work with Development teams to understand deployment requirements to non-production environments.
• Perform production deployments working with Release Managers and the Advanced Technology Services team.
• Create and maintain process documentation, and lead process improvement efforts.
• Research and evaluate new automation and infrastructure technologies, including AWS, Virtualbox, Puppet, Vagrant, Packer, Rundeck, and Docker.
• Setup deployment processes for Vertex (a third-party Tax software package).
• Identified a process to reduce utilization of Confidential, and implementation of those strategies in multiple systems so far.
• Initiated and led team effort for Production Outage process improvement and documentation.

Confidential, Eden Prairie, MN

Senior Business Systems Developer

Responsibilities:

• MS Dynamics AX development lead.
• Made enhancements within AX in preparation for migrating from the current ERP system.
• Enhancements are in the areas of Procurement, AP/AR, and HR.
• Design and development work includes database, X++ classes, forms, workflow, and reports.
• Work with IT Admins on refining deployment and maintenance processes.
• Perform administration tasks in non-production environments.
• Organized deployment process from development through production.
• Automated daily development compiles/builds.
• Led the development efforts for the AX CU6 upgrade. Also worked with the application administrators to help develop their processes for the upgrade.
• Performed development for multiple enhancement projects.

Senior Database Architect

Confidential

Responsibilities:

• Performed database design, development, and performance tuning for Inview (a legal document analysis and review application).
• Performed database builds and deployments to non-production environments.
• Created pre and post validations for InView upgrade initiative.
• Enhanced DB build and release process.
• InView upgrade initiative. Designed the pre-upgrade validation, upgrade coding, and post upgrade validation.
• Was the lead engineer for the overall upgrade effort of over 1000 clients.

Confidential, Bloomington, MN

Senior ETL Developer

Responsibilities:

• Performed ETL development for the Confidential enterprise data warehouse using Informatica, Oracle, SQL Server, SSIS, and XML.
• Interface with business stakeholders, project managers, and business analysts during analysis, design, and development. Interface with Business, QA, Configuration Management, and Operations teams during development, testing, and implementations.
• ETL conversion from SQL Server to Oracle.
• Converted SQL Server stored procedures to Oracle for Financial Reporting migration.
• Designed and developed data integrations for multiple clients using Informatica and SSIS.

Lead SQL Server Developer

Confidential

Responsibilities:

• Led SQL Server design and development for CERTS, VTS, and Capacity Management applications including database design, enhancements, maintenance, and performance tuning.
• Performed database administration for development and test environments.
• Initiated and led the automation of SQL Server database build and delta generation using DB Ghost, VB .NET, XML, Team City, and Perforce. This saved approximately 20 hours/month in build preparation, greatly increased the reliability of deployments, streamlined development and QA processes, increased client satisfaction, and saved hours of troubleshooting for the support team.
• Transitioned the new build process to the Configuration Management team.
• Worked with Psychometricians and Product Management to design and develop a system to generate, store, and export statistics based on samples of test results using SQL Server tables and stored procedures.
• Designed and developed a solution to the complex problem of converting Test/Assessment structures from the legacy format to the new mandatory standard format, enabling our company to avoid financial penalties and take advantage of a more feature-rich Test Delivery system.
• Designed and developed additional enhancements including test result imports and test reporting enhancements.
• Led the definition of SQL coding standards and mentored other SQL developers.

Confidential

SQL Server DBA Team Lead

Responsibilities:

• Supervised and led the SQL Server DBA team of 6-8 members.
• Responsibilities included work distribution, on call schedule management, performance evaluations, staffing, mentoring, and hands on database administration, implementation, and support for over 20 companies hosting their database applications with Confidential .
• Led the team in supporting slightly over 100 SQL Server instances, including more than 300 databases for both external companies and internal departments, working with external clients’ business and technical personnel and with internal Windows, Network, Development, Storage, and Operations teams.
• Led the enhancement and standardization of database implementation and operational standards.
• Led the effort to centrally store server and database configuration data.
• Trained Associate DBAs to handle first level support incidents.

Confidential

SQL Server DBA Team Lead

Responsibilities:

• Led the SQL Server DBA team of 4-6 members.
• Responsibilities included work distribution, on call schedule management, mentoring, and hands on database administration.
• Worked closely with Windows, Network, Development, QA, Storage, and Operations teams to provide development and production support for Confidential ’s SQL server database applications
• Led the Database implementation for a newly developed 24x7 airline reservations system in a hosted environment on the Microsoft .NET/SQL Server platform.
• Developed database implementation and operational standards.
• Implemented replication for the operational reporting component of the reservations system.
• Setup and managed the development, QA, staging, training, UAT, and production SQL Server environments and databases.

Confidential

Database/Applications Team Lead

Responsibilities:

• Led and managed the development of a Business Intelligence service offering for the Confidential application service provider. The project spanned the areas of market analysis, proof of concept, budget, development, sales, training, and support. The completion of this project filled a large void in our clients’ ability to do reporting and analysis on school and student data. It also provided a new revenue stream for our business.
• Trained the Sales and Support staff on the new Business Intelligence service.
• Led the initial implementation of Confidential ’s PeopleSoft Vantive Customer Support system and multiple enhancements. These projects included package selection, definition of scope, analysis, design, application development, business intelligence development, staffing, training, and sales support. This provided our support staff with an effective means of tracking and processing customer support incidents. It also alleviated some of the call volume by providing an online knowledge base for customer self-help.
• Trained the Support staff on the new Customer Support system.
• Organized, documented, and automated (where applicable) the process for new client implementations.
• Setup and managed the development, QA, training, UAT, and production SQL Server environments and databases.