David Mccarthy Email & Phone Number

Oaks, Pa

Downingtown, Pa

• Act as lead database developer participating in all phases of development from planning to implementation.• Install/administer over 20 SQL Servers of various versions (2000, 2005, 2008R2, 2012, & 2014) supporting multiple environments and applications, including mission critical ERP.• Collaborate with ERP, CRM, and web developers to develop new solutions and support existing ones.• Provide training, oversight, and mentoring to junior staff members.• Develop and support complex, bi-directional data integration processes to synchronize customer account and contact data between Axapta ERP and Dynamics CRM systems.• Plan and implement HA/DR functionality for various databases via log shipping and Always-On availability group (AOAG) features.• Design and implement BI infrastructure around SQL Server Reporting Services to fulfill both internal and external reporting requirements.• Design data warehouse and develop associated ETL processes to store multi-dimensional data extracted from OLTP ERP system.• Develop automated Excel workbooks employing VBA modules to retrieve data from disparate data sources and provide users with dashboard-type views.• Lead person responsible for data migration projects to support transition of mission critical systems (ERP and CRM)

Downingtown, Pa

• Expanded SQL Server environment to include version 7.0 servers.• Developed and supported ETL processes via Data Transformation Services (DTS).• Prepared systems for Y2K compliance.

Downingtown, Pa

• Installed, configured, and supported Microsoft SQL Server 6.5.• Developed automated processes to export data sets from ERP system and load into SQL Server via BCP.• Gathered reporting requirements and developed queries to provide business users with detailed and summarized sales activity data.

Exton, Pa

• Worked with a team of developers to enhance and support a custom-built ERP system written in Advanced Revelation RDBMS.• Resolved long-standing database blocking issues saving the company approximately 150 man-hours per week of lost productivity.• Prepared company’s DOS-based ERP for transition to Windows NT 4.0 while maintaining database dependencies on Novell Netware file server.

Exton, Pa

• Responsible for developing and supporting custom-built ERP system written in Advanced Revelation RDBMS.• Recipient of Softmart Super Star Award for Commitment to Excellence in Q1, 1995.