Scott Ehling Email & Phone Number

Philadelphia, PA, US

Greater Philadelphia Area

• 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

Montgomeryville, PA

• 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.
• 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

Chalfont, PA

• 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.
• 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

Blue Bell, PA

• 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.

Horsham, PA

• 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

Bachelor Of Science (Bs), Information Science And Technology

Computer Science

Computer Science