Scott Ehling

Experience

• 

  McKesson/Verispan/Kelly Waldron

  Jan 1999 - Jan 2001

  Database Programmer/Data Analyst

  • Built and managed backend SQL and Microsoft Access databases that produced client-specific reports for pharmaceutical clients• Created high-level dashboard and scorecard reports that were delivered to upper management of numerous clients • Developed reusable quality assurance measures for ongoing projects

• 

  Meta Pharmaceutical Services

  Jan 2001 - Jan 2012

  Senior SQL Developer/DBA/Business Systems Analyst

  • Responsible for gathering and analyzing client requirements to create customized software applications and tools using advanced development, ETL and high-level coding techniques• Managed all phases of database design from coding and prototyping through system testing, integration and deployment using Microsoft SQL and Oracle platforms• Specialized in the integration of proprietary client data with third-party pharmaceutical data (IMS Health, Wolters Kluwer, MediMedia, HealthLeaders, etc.) for physician targeting, incentive compensation plans, co-pay analytics and ROI Voir moins

• 

  FirstLab/Genomind

  Jan 2012 - Oct 2012

  Database Specialist/DBA/Data Analyst/Project Manager

  • Exclusive database developer responsible for all Database Administration (DBA), ETL across heterogeneous data sources, BI development, database modeling, creation, and monitoring • Planned, scheduled and executed all stages of the construction and maintenance of software development activities, including: articulating project goals and scope, translating business needs into technical terms, prepared detailed work breakdown structures (WBS) and instilled shared accountability for achieving project milestones with geographically dispersed teams• Provided guidance, support, and mentorship to junior level associates• Designed and setup a testing and staging environment with database mirroring using VMware servers to support proper code promotion for other programmers Voir moins

• 

  Roska Healthcare Advertising/PulseCX

  Oct 2012 - Jan 2013

  Senior Database Developer/DBA/Reporting & Technical Analyst

  • Lone database programmer/DBA responsible for all production and non-production databases, ETL across varied data sources, BI development, database design and creation • Designed and implemented digital and print CRM programs for large pharmaceutical clients• Created and deployed an SSIS package that was responsible for SQL security checks, backup and disaster recovery, and query tuning on a group of applications and databases • Automated the creation of an OLAP cube by building a data warehouse using normalized tables which were populated through an SSIS package that pulled data from various production databases and external sources focusing on query performance and optimization• Developed a Windows Form application using C# that would extract data from a database, convert it to XML, and send it over to a third party vendor using a scheduled task• Worked with a team of developers to review designs and improve supporting documentation Voir moins

• 

  NorthStar Solutions Group LLC

  Jan 2013 - Jan 2015

  Senior SQL ETL Developer

  Database architect consultant for Comcast• Creating, supporting and enhancing Comcast national reporting groups call center data extracts.• Maintaining multiple SSIS packages that pull data from all of the Comcast divisional call centers into a central reporting warehouse. • Supporting nightly data loads for errors and issues. Notifying national reporting groups and vendors of errors and issues and correct as well as provide status updates.• Creating and deploying SSIS packages that are responsible for SQL security checks, backup and disaster recovery, and query tuning on a group of applications and databases• Responsible for enhancing existing SSIS packages, stored procedures, tables and views to increase performance and data accuracy Voir moins

• 

  Kantar

  Jan 2015 - Jan 2022

  • Director of Data Engineering and Analytics

    Jan 2022 - Jan 2022

  • Senior Database Architect

    Jan 2015 - Jan 2022
• 

  Dun & Bradstreet

  Jan 2022 - now

  Director of Data Engineering and Analytics