Michael Friedhoff Email & Phone Number

Addison, TX

• Concentra – January 2015 to CurrentData Engineer(healthcare)Goal:
• Strategic/Key account reporting automation.
• Marketo, CRM (MS Dynamics), and Revenue automation and integration.
• Creation of Sales center contribution analytics.Steps:
• Created detailed sales performance analysis for sales initiatives and strategies.
• Supported reporting of acquired customers to determine which customers were lost in the process.

Dallas, Texas

• Goal:
• Source data from the EDW, Wizard, Trax, Swift, and the Tibco bus to create a new dedicated data mart for the maintenance department.
• Build an analytical model in real-time while sourcing the data from multiple distinct continuous streams to track aircraft maintenance events.Steps:
• Listened to the internal Customer, aircraft maintenance, in order to obtain the needed business context and insight.
• Drove agreement between three different entities, dispatch, maintenance, and corporate modeling, so that the data and metrics told the proper story.
• Created requirement documents and source to target documents for use by the developers.

Dallas/Fort Worth Area

• Goals:
• Throughput analysis for six emergency departments in the Baylor Healthcare System.
• Populate warehouse daily (dimensional model/star) from six independent emergency department information systems.Steps:
• Built the source to target documentation that was used by the ETL developers.
• Analyzed source data from MedHost and Eclipsys.
• Defined conformed dimensions such as arrival methods and disposition locations.

Dallas/Fort Worth Area

• Goal:
• Determine why multiple source systems differed in results regarding the U-verse products sold (Data Quality).Steps:
• Designed custom one-off SQL queries to pull data directly from several different source systems, warehouses, and a dimensional database.
• Utilized Kettle (Pentaho Data Integration) to automatically generate custom Excel spreadsheets that combined data from the dimensional reporting database with the source transactional data in the warehouses.
• Discovered data structures and meaning of data in the warehouses with minimal assistance and documentation.
• Deciphered the path and systems by which orders traverse once they left the point of sale system on their way to final provisioning.