Daniel Mauerhofer Email & Phone Number

Arlington, VA

• SQL Server 2014, Microsoft test manager, Agile, Fiserv data source, flat file data sources
• Created ETL SQL script using same requirements (row and column level mapping documents) as for EDW IBM Infosphere Information Server (DataStage) programs to validate data was properly processed at data element level.
• Loaded data to base normalized Database tables and Dimension/Fact tables.
• Participated in Daily Scrum meetings.
• Worked 100% remote for 4 months.

Washington D.C. Metro Area

• Ab Initio GDE Version 3.0.2.1 & COOP v3-0-2-5, UDB EEE, Humingbird AIX, Mainframe
• Created/implemented/documented/supported numerous Ab Initio graphs and jobs over 11 years.
• Developed ETL to process many types of data, Policy, Claims, E-Billing, Actuarial, Sales, etc...
• Sourced data from Mainframe Flat Files, XML, RDBMS, formatting data for Enterprise Data Warehouse to load into DB2 UDB DataMarts.
• Flattened ‘hierarchical data format’ data (HDF) to normalize into an RDBMS.
• Used Parallel Multi File System (MFS) processing throughout ETL processes to maximize computing resources and minimize runtime.