Senior Database Developer / Administrator
Resume:
Travis N. Gassmann
Powder Springs, GA 30127
******@***************.***
PROFESSIONAL EXPERIENCE
Solutions Architect / Developer / Systems Administrator Nov 2013 to Present
J & M Marketing Solutions, Inc. (dba. Performark), Hopkins, MN – Telecommute
Modeled and developed a new email generation system using TSQL stored procedures and data tables on MSSQL 2005/2016. New system had an 800% performance increase over the old system.
Contributed to a 74% reduction in operational costs by performing a data center migration to Amazon Web Services EC2 platform. Migration included the following:
oUpgrading from MSSQL 2005 to 2016.
oUpgrading Windows Server 2003 to Windows Server 2012.
oConverting client’s database coalition from a non-standard coalition to default coalition.
oCreating new AD Servers with file shares, OUs, user accounts, and security groups.
oConfiguring hybrid AD / O365 environment.
oUpdating firewalls, VPN tunnels, DCHP Reservations, and DNS.
oConfiguring Public LAMP Stack Server (Ubuntu 14 / Apache 2 / MySQL 5 / PHP 5).
oDeploying WDS and WSUS.
Modeled three web application databases using MySQL Workbench 6 and coded associated PHP websites including three WDSL PHP web services and three .NET 4.5 Framework / VS2017 (VB.NET / C#) applications to integrate with the internal data warehouse.
Developed 16 SSRS reports using VS2008/VS2015, which allowed the Client Services Team to access data from the transactional and internal data warehouse database, resulted in a 40% reduction in response time for client data requests.
Optimized production systems and increased stability and efficiency from 97% to 99.9% by tuning and indexing transactional data tables and rewriting TSQL stored procedures using MSSQL 2005.
Decreased processing time for the Address Standardization process by 66% using SSIS on VS2008/2014.
Integrated our proprietary calling system with our new client driven email marketing solution using .NET 4.5 Framework / VS2017 (VB.NET / C#).
Solutions Architect / Software Developer Feb 2013 to Nov 2013
Advantage Technical Resourcing - Contracted at Medtronic/Covidien, Plymouth, MN
Architected, Modeled and Developed a custom solution, from concept to implementation, that increased data compliance from 75% to 99.99%, while reducing data collection time by 50%. The entire solution eliminated three issues identified by an internal audit team and included the following items:
oA custom transactional data model with associated schemas, tables, views, stored procedures, functions, and triggers. Data model had to be interconnected to a 3rd party’s database with the ability to insert and update data without impact to other departments that used the 3rd party’s application.
o17 custom built windows desktop applications, windows services, and web services using .NET 4.0 Framework / VS2010 (VB.NET / C#).
o8 SSRS reports to display captured data and configuration verification.
oIntegration between two different document management systems.
oA dynamic audit trigger to track row level data changes in the underlying tables.
Authored the requirements documents, test cases, design documentations, implementation plans, and production support plans.
Added 40% additional functionality to the latest version of the custom solution than originally called for in the user requirements.
Completed the custom solution four months ahead of the schedule.
Database Support Analyst Apr 2011 to Feb 2013
United Health Group, Eden Prairie, MN
Designed a fully automated ETL process, that loaded dimensions, fact tables, indexed and optimized those tables, and performed process status notifications using MSDOS, PowerShell 4.0, SSIS, and TSQL on MSSQL 2008 Enterprise. Saved 54 hours per month of in processing time.
Supported Premium Designation Department’s 1.5 TB database with bi-weekly ETL data refresh using SSIS, TSQL, and PowerShell 4. Support included troubleshooting, analyzing, indexing, tuning and optimizing long running TSQL stored procedures, views, and tables.
Optimized 15 SSRS reports using Reporting Services 2008 and VS2008.
Modeled the control database using MSSQL 2008 / Visio 2003 and Architected a new process execution controller using .NET 4.0 Framework / VS2008 (VB.NET / C#) to standardize multiple tasks and ETL data loads across four different reporting systems, with serial and parallel/multi-thread processing and the ability to execute SSIS Packages, TSQL, DOS/PowerShell 4, UNIX Commands/Scripts, and DataStage jobs. Saved 80 hours a month of monitoring and manual execution.
Programmer/Analyst Dec 2008 to Apr 2011
Boston Scientific Corporation/Guidant Corporation, St. Paul, MN
Introduced four automated regression testing solutions and decreased required testing time by 70% for the associated mission critical production systems.
Increased performance and stability of the Manufacturing Data Warehouse platform from 75% to 99.7% with 4 weeks of joining the support team by analyzing the Informatica 7 ETL jobs, Oracle 11g tables and indexes, Ingres 9 tables and indexes, and Cognos 8 Infrastructure.
Supported multiple manufacturing systems (MES, EMDR, DMS) and the associated interconnections to global enterprise systems (ERP, CRM, ESB) using VB6, Eclipse 3, and JAVA.
Served as the Principle System Analyst for the Statistical Process Control platform and was responsible for:
oHealth and Stability of the system.
oData mapping and integration between various data file formats generated by various pieces of manufacturing equipment.
oData mapping and integration with the EMDR system.
KNOWLEDGE AND SKILLS
15 years of experience in Microsoft Server Administration.
14 years of experience developing in VB.NET, VBA, VBScript, C#, and PowerShell.
13 years of experience developing in PHP, HTML, Jquery, AJAX, JavaScript, Ruby, and CSS.
12 years of experience in developing on and supporting MS SQL Server 2008/2012/2014/2016.
12 years of experience working with Waterfall Methodology.
12 years of experience working in FDA regulated environments.
5 years of experience working with Agile Methodology.
Familiar with multiple SQL platforms including MSSQL, Oracle, PostgreSQL, and MySQL.
EDUCATION
Bethel University Graduate School, St. Paul, MN Aug 2005 to Jun 2008
MA of Organizational Leadership.
North Central University, Minneapolis, MN Aug 2000 to Dec 2003
BS of Interdisciplinary Studies.
Contact this candidate