Microsoft SQL Server ETL developer for the Data Integration Team and Data Architecture Team. Responsible for creating and maintaining core ETL engine Visual Studio database projects. Also assist development team custom data flows to ingest incoming customer eligibility and claim data using MSSQL Server, T-SQL querying and stored procedures, SSIS. Work managed via Azure DevOps using Agile practices for large, system-wide projects and waterfall approach for client-specific work.

Started on 1yr contract; converted to full-time after 6 months.Created a database solution to manage ETL tasks between inter-company departments and intra-company business partners. Built to manage and automate the scheduling, querying/processing, QC, delivery of extracts and loads comprised of t-sql stored procedures/functions, supporting tables/views, SSIS packages and SQL Agent jobs. Solution allows management to include ETL metrics in company dashboard reports and also allows less experienced staff to create ETL data flows. Migrated legacy data flows from Access/Excel into the ETL solution.Presented and trained staff to adhere to t-sql coding standards. Assisted with the effort to define the coding standards.Used query plans to tune performance of queries identified by analyzing ETL logs, performance data and notice from DBA team of poorly performing queries.Migrated Oracle ETL queries to pull data from new SQL Server environment.Assisted with work request queue for adhoc SSRS reports resulting in SSRS reports or one-time requests for data analysis.

Established a data warehouse to ingest, manage, standardize, consolidate and disseminate enterprise data with internal and external sources and destinations. Created a data warehouse administration portal using SSRS to allow administrative staff to manage the file ingest and extract processes.Data management tasks to discover and document pre-existing and newly acquired data sources within the healthcare industry. This includes but is not limited to Health Plan Capitation/MOR/MMR/Pharmacy/Eligibility data. Data from the enterprise adjudication system (EZCAP). Third party data including Lab data, NDC Drug database and HCC modeling meta-dataCreated SQL processes to model HCC and HEDIS 5STAR scoring. These models are run daily using data warehouse data. Results are also stored in the data warehouse for dissemination to reporting services.Improved performance of data gathering activities by migrating dataflows to SQL Server and SSIS and also performance tuning of data gathering queries.Creation of automated data extracts for delivery to health plans to satisfy need for CMS ASM submissions using data warehouse functionality.Other completed efforts include some DBA duties such as upgrading SQL Server and SSRS 2008 servers to SQL 2012.Due to a significant change in membership, KMSM had it's first ever layoff in Nov of 2017. Since the data warehouse was built and junior staff were trained to administer it, I was included in that layoff.

Managed team of 4 System Operators, 4 System Administrators and 2 Desktop Support staff over 3 1/2 years. The team was responsible for the planning, procurement, deployment, administration, maintenance and all tiers of support for networks, servers, storage, software, personal computing devices for roughly 120 staff offering wide array of web-based and raw data-based products. My team was also responsible for all IT-related business continuance and compliance efforts.Responsible for and participated in rotation of 7/24/365 support of production product systems and extended business hours support of production enterprise computing systems. Improved overall uptime during my tenure from 99.2% to 99.8%. Established system uptime reporting from legacy product uptime solution into MS Excel with pivoted data for reporting to company leadership.Responsible for Business Continuance planning and testing of production and enterprise computing systems. IT representative as member of the business continuance steering committee. Worked with DBAs to define and deploy DR solution for revenue-generating systems. Completed onsite testing of DR solution at remote colocation.Responsible for Security and Compliance of systems and products.Defined annual team goals and individual objectives derived from stated company goals and objectives. Tracked and measured progress.Created reports for company leadership and VP of Operations. Created the SQL Server reporting mechanisms to provide data for a number of IT performance metrics including man hours spent, file processing stats, IT maintenance stats.Assisted VP of Operations with IT budget of roughly 500k annually.Due to merger with Marshall and Swift/Beeckh and relocation of the local data warehouse, I was included in layoffs at Dataquick in March of 2013.

The DFS team was responsible for developing data solutions of bulk data files (up to 1 TB of data per delivery). Data was delivered using ETL skillset and supported with Data Analyst skillset. My team was also tasked with the sales support role and would support sales teams on site responsible for up to 50% of company revenue.Designed and authored the database backend for internal workflow management tool using SQL Server and SSIS.Development lead for our team as we modified our in-house ETL platform to accommodate expanding customer needs of our data file deliveries and to enhance automation of data file delivery (TSQL, SSIS, SSAS, DOS shell scripting).Acted as sales engineer to the sales team assigned to company’s largest customers (on-site consultation, trade shows, and presentations).Mentor Cobol and visual FoxPro programmers in transition to use of VLDB and SQL Server general TSQL development.T-SQL query performance and tuning for DFS staff.Designed and coded our data security system to prevent abuse of our data.Development DBA duties including security, storage, backup and restore, performance tuning and Tier 3 troubleshooting.In October of 2009, I was promoted to manage all of IT.

Initiated and completed the effort to define and facilitate the Database Integration Engineer role. The role was crucial to the coordination of the increasingly complex and voluminous modifications to the central data warehouse and downstream data marts. All database releases were required to go through my role before they were implemented in the production environments.Defined standards for submitting and implementing database changes to production environments.Worked with database development staff to defined T-SQL coding standards to ensure readability and satisfactory performance of future database changes.Using T-SQL/DTS, developed a system that would create a subset of the warehouse to facilitate replica development environments decreasing storage needs and expediting testing activities.Performed moderate database administration tasks for the integration environments.In May 2004, I was promoted to manage the Data File Services team.

Responsible for design and development of data tier solutions. Projects consist of maintenance of existing data warehouse environment (1 terabyte of data) and with products released to the customer base. Product based projects deal with various data marts that pull data from the data warehouse.Extensive use of T-SQL to provide data tier solutions for web-based products released to public.Extensive use of T-SQL to build enhancements to existing data warehouse processes.Performance analysis and enhancement of existing product data pulls from data warehouse to data marts. Reduced CPU usage for a single data pull from 100% utilization of a 4cpu server to usage levels of < 30%.Initiated and developed a system of extracting a subset of data from the warehouse as a development/test copy for use by all technical staff. Previously, all development was done in a shared environment that resulted in many instances of overwritten code.Planned and instructed introductory T-SQL classes as part of company’s in-house education program.In Dec 2002, I changed roles to establish a new role needed because of the large shift from Cobol mainframe to MS SQL Server.

Designed, validated and implemented customizations to LASCOM products using SQL, XML, XSLT, VB and ASP.Designed customizations according to requirements data gathered directly from customer.Implemented customizations while on-site, in cooperation with customer’s staff.Validated completed implementations against customer’s acceptance criteria and requirements data.Lascom Solutions went out of business in May of 2002

Led development team of up to 5 programmers through customer defined projects and eVentures product work.Built and maintained all data service layers for all company projects and products. This included database architecture, R.I., stored procedures, and ActiveX DLL’s to provide layer of abstraction from data tier for VB/web developers.Responsible for product database design including entity modeling/relationships/attributes, business rules, views to reduce complexity and index creation.Developed DOS/SQL scripts for creation of product databases to be included in an installation program.Built ActiveX DLL’s to be included in final product that would provide data services to business layer components. This allowed VB developers to be shielded from data-centric technologies (ado, odbc, etc…).Analyzed performance and tuning data to enhance data service tier after compilation and study of benchmark data.Implemented project deliverables and optimization of eVentures products while on-site.Eventures Int went out of business in April of 2001.

2nd-tier support to product resellers. Specialized in MS SQL server configuration, installation. Developed solutions using T-SQL to resolve data corruption issues.Motiva went out of business in October of 2000.

Provided support for products and Great Plains Dynamics (all modules).Supported critical system issues on-site.Assisted with product implementations and established best practices specific to customer’s requirements including user training.Developed and maintained dynamic library of financial reports using Crystal Reports.Designed and coded all enhancements to product modules and Great Plains applets using VB5/VBA

roubleshooting and maintenance of Perl/Unix/T-SQL scripts that populated databases with 100+mb of data on a daily basis by 9am.Maintained and administered job scheduling tool used to schedule the intricate collection of over 200 separate batch processes.Jr DBA activities, including security for Sybase SQL Server and management of database resources for 13 SQL Servers.Monitored performance for Sybase SQL Server using SQL Monitor and SQL Monitor Historical Server.