Etl Programmer
Connexin Software (Office Practicum)
Horsham, Pa
Developed ETL and data conversion scripts in Java and Delphi programming languages. Used Eclipse IDE for modifying open source ETL tools. Analyzed structure and integrity of PM/EMR software systems. Extracted data from PM/EMR legacy systems using various data access tools/techniques including ODBC drivers, SQL commands/scripts and UDFs. Developed over 50 data conversion scripts from numerous legacy systems – including Centricity, Intergy, Medisoft, Visionary, NetPractice, PCC and others – into Office Practicum (OP). Performed routine upgrade of legacy OP Data Importer software – extension of GUI, merger of Data and Image Importer applications, enhanced logging capabilities and increased speed/memory efficiency. Collaborated with customer IT professionals, legacy system programmers, state immunization registries and Connexin project managers and interface programmers to deliver data in a timely and accurate fashion. Helped organize shift from custom Delphi-based data importer to Pentaho Data Integration ETL tool by modifying and recompiling Pentaho into robust, lightweight and portable program easily deployable on client systems.