Michael Monaco Email & Phone Number

Englewood, Colorado

• Developed robust ETL solutions with a holistic approach• Developed Informatica mappings/sessions to create extract files for outside vendors• Utilized Business Objects to create Universes and QAAWS for Xcelcius dashboards• Developed complex ETL that loads aggregated data for Xcelcius dashboards• Assisted in the design/data modeling of star schemas• Created DDL for dimension and fact tables• Successfully initiated/introduced/implemented Informatica versioning • Gained useful knowledge of the healthcare system• Utilized Rally software to implement an agile development life cycle

Littleton, Colorado

• Architected a streamline ETL process with Informatica to stage data for corporate wide reporting in a star schema data mart• Utilized PeopleSoft Application Designer to create tables, views and online pages• Developed Application Engines that load data into record definitions that are data sources used to send emails • Used Oracle through version 11 to create advanced SQL and PL/SQL such as triggers used for audits• Created SQR programs for mass data loads which included extensive data validation• Maintained fact/dimension tables that were the source of corporate wide reporting• Quickly gained industry experience in a team environment• Developed strong working relationships with business analysts making the developmental process much smoother and successful• Implemented major system upgrade from PeopleSoft 8 to PeopleSoft 9• Support the Data Warehouse including on-call and test support