• Led the team strategy, architecture and goals aligning with corporate roadmap. Overseeing a 15% increase in project efficiency • Architected multiple healthcare specific data warehouses that supported integration of data from over 15 disparate sources. New models and changes to existing models resulted in a 206% revenue increase in 2016 and then another 60% increase in 2017-2018. • Architected SQL Server data warehouses using the Kimball Star Schema methodology• Developed SQL\Snowflake ETL utilizing S3 bucket, javascript procedures and dynamic BCP scripts

• Streamlined existing load mechanisms achieving a 42% cost reduction for onboarding new clients• Migrated existing models and ELT solutions to AWS leading to 10% decrease in system downtime• Rewrote poorly written SQL Server ETL stored procedures. Efforts improved data transformation efficiency by about 15% and reduced query execution times by about 25%. Created PowerShell scripts to handle automation of pieces of the ELT process• Automated ELT/ETL processing in Amazon AWS utilizing Powershell, WinSCP & S3

• Rearchitected data warehouse ETL’s which resulted in the expansion of partnerships with GE Healthcare, Athena Health and Allscripts• Created automation scripts to handle metadata insertion which resulted in an 80% efficiency• Developed product object transfer application which enabled customers to migrate existing content from one environment to another• Architected model repository solution reducing code loss risk to near 0%

• Defined Database SDLC process improving quality assurance and reducing risk• Managed small group of onsite MS SQL Server DBA’s• Maintained database integrity between development, quality assurance, user acceptance and production• Worked closely with development resources to ensure standard design and principles of normalization. • Wrote complex SQL queries, DTS jobs, stored procedures and triggers

• Responsible for traditional database administration tasks on MS-SQL databases• Designed and implemented complex insurance rating algorithms using stored procedures• Designed, developed and delivered web interfaces which resulted in 2 client retentions and extended the life of a product that was set to be discontinued• Responsible for administration, development, integration, configuration, testing and support of implementations• Created and used various utilities to transfer data to other systems and between clients• Wrote manuals, operating procedures and internal documentation