Michael P. Email & Phone Number

Huntsville, Al, Us

Huntsville, Al, Us

San Francisco, Ca, Us

Deerfield Beach, Fl, Us

Duties: • Provide leadership and technical guidance to the ETL team • Serve as subject matter expert for ETL development • Translate functional product requirements into technical designs • Implement DDL and DML code to operationalize designs following SDLC guidelines • Design and develop automated processes to create and maintain ETL processes that support internal and external customers • Recommend areas for further data platform enhancements and process improvement • Analyze and document system flow and technical information about data, database design and system architecture • Manage sprint release process Major Projects Completed: • Created automated process to extract health care data from core systems, de-identify the protected health information (PHI) and deliver outputs to external customers • Redesigned legacy process of determining health care provider eligibility and developed new loading package that reduced the processing time from 24+ hours to 3 hours • Led development of Informatica process to verify data quality meets default or custom thresholds before loading transactional system • Created ETL process to calculate and load readmissions using Centers for Medicare & Medicaid Services (CMS) 30 Day All Cause readmission rules • Built multiple integrations with SalesForce using Oracle Data Integrator • Created process to load 837 Claims into SQL Server using vendor software, Oracle Data Integrator and T-SQL Tools Used: SQL, PL/SQL, Oracle SQL Developer, Toad for Mysql, Azure Data Studio, UNIX Shell Scripts, JIRA, GIT, Informatica, Oracle Data Integrator, Oracle, SQLServer, memSQL, VNC

New York, Ny, Us

Duties:• Develop ETL/ELT processes for integrating a wide range of external performance source data into BMI's OLTP• Develop process to load reporting structures with cleansed transactional data• Develop and maintain Oracle APEX applications used for internal business processesMajor Projects Completed: • Built APEX application to reduce manual data entry by team members, which helped reduced costs associated with maintaining a vast array of industry data and reporting needsTools Used: SQL, PL/SQL, Oracle SQL Developer, Toad, UNIX Shell Scripts, JIRA, Concurrent Versions System (CVS), IBM DataStage, Oracle, APEX

Nashville, Tennessee, Us

Duties:• Provided leadership in the technical architecture and design of Business Intelligence (BI) solutions • Worked with users to analyze business needs and design reporting data models• Developed ETL/ELT processes for the loading data warehouse and/or data marts • Created reporting solutions using Business Objects tools to satisfy end user reporting requirements. • Support functional areas such as Finance, Human Resources, Student Information and Healthcare reporting.Major Projects Completed: • Implementation of IBM’s Unified Model for Healthcare (UDMH) for Patients, Encounters and Financial Transactions • Created a Human Resources Data Mart utilizing a Star Schema for operational and monthly statistical reporting• Rewrote the Departmental Management System reporting process, which is used to track expenses and budgeting within the University and Medical Center. The development included the creation of an ETL process, a Business Objects Universe, Web Intelligence reports and Xcelsius Dashboards• Developed the ETL process and Business Objects Universe for the Ellucian University Advancement system• Developed ETL prototypes for Talend and Oracle Data Integrator for possible use within the Vanderbilt IT Department Tools Used: SQL, PL/SQL (for ETL and reporting needs), Business Objects 6.5/R2/R3/R4, Oracle SQL Developer, Toad, UNIX Shell Scripts, JIRA, Concurrent Versions System (CVS), Subversion, IBM DataStage, Oracle (11g, 12c), DB2 10.5

Nashville, Tennessee, Us

Duties:• Provided leadership in the technical architecture and design of Business Intelligence (BI) solutions • Worked with users to analyze business needs and design reporting data models• Developed ETL/ELT processes for the loading data warehouse and/or data marts • Created reporting solutions using Business Objects tools to satisfy end user reporting requirements. • Support functional areas such as Finance, Human Resources, Student Information and Healthcare reporting.Major Projects Completed: • Implementation of IBM’s Unified Model for Healthcare (UDMH) for Patients, Encounters and Financial Transactions • Created a Human Resources Data Mart utilizing a Star Schema for operational and monthly statistical reporting• Rewrote the Departmental Management System reporting process, which is used to track expenses and budgeting within the University and Medical Center. The development included the creation of an ETL process, a Business Objects Universe, Web Intelligence reports and Xcelsius Dashboards• Developed the ETL process and Business Objects Universe for the Ellucian University Advancement system• Developed ETL prototypes for Talend and Oracle Data Integrator for possible use within the Vanderbilt IT Department Tools Used: SQL, PL/SQL (for ETL and reporting needs), Business Objects 6.5/R2/R3/R4, Oracle SQL Developer, Toad, UNIX Shell Scripts, JIRA, Concurrent Versions System (CVS), Subversion, IBM DataStage, Oracle (11g, 12c), DB2 10.5