David Essig Email & Phone Number

- Responsible for preparing, executing, and monitoring the migration of 1 petabyte of data from a Teradata system to an on-premises NetApp StorageGrid array.- Utilized Teradata WRITE_NOS technology to generate Parquet files, ensuring they were queryable by Teradata and compatible with any tool that supports the Parquet format.- Led the five man team to.

San Diego, California, US

Professional Services Consultant provided Technical and Team leadership. Served as a Data Engineer, an Enterprise Data Architect and a trusted advisor for Teradata clients.

- Contributed to the CMS Division of Enterprise Information Management Services (DEIMS) on the IDR Support program, specializing in ETL development and Operations and Maintenance support.- Utilized a robust technology stack, including AWS tools, Snowflake, Python, shell scripting, and Informatica DEI, to streamline data processes and enhance system.

- Supported the development and testing of ETL streams, utilizing Python, Linux shell scripting, and SQL coding within an Agile methodology in a cloud environment.- Leveraged advanced cloud technologies, including AWS S3, Cloud Tamer, Apache Airflow, and Snowflake, to enhance data management and migration processes.

Database Architect, Database Developer and Operations and Maintenance DBA for the CMS One PI program. Supported the database needs of the One PI community, maintaining the customized BDM and VDM views developed in his role as an ETL Architect and Virtual Data Mart (VDM) Developer. Key role in managing database performance for One PI users, having developed.

Data Architect for a New Jersey Taxation Data Warehouse. Developed a series of database enhancements reducing storage requirements markedly via Multi-Value Compression functionality. Supported data loading requirements, troubleshooting and correcting a series of load utilities in use for the project.

Numerous consulting roles within the government Intelligence Community and commercial clients included Enterprise Data Architect, Database Replication Manager, and Application Developer. Development employed diverse tools and languages such as SQL, Java, Perl, Powerbuilder and a number of Sybase software products.

Roles included application design, development, and technical lead for a number of clients. Numerous commendations received for the work. Tools included PowerBuilder with PowerBuilder Foundation Classes (PFC), UML technologies, ESL 4GL, C OS/2 Presentation Manager.

As as Software Developer, designed and developed an OS/2 kernel application using IBM C/2 and applicable OS/2 API calls. Revised and upgraded two separate ESL applications designed for the marketing of a reservations system. Demonstrated feasibility of ESL as a development tool for a proposed reservations system front end.

Roles included project manager, technical writer, and application developer.