Peter Hartmann Email & Phone Number

Des Moines, Iowa, Us

• Leader for the workforce data engineering team - responsible for strategy, architecture and budget• Built governed data pipelines for enterprise wide consumption in AWS and Snowflake, centralizing data curation which currently takes up 65% of analyst time - realized 7 days time savings per quarter for Talent Analytics processes• Established patters for engineering teams, data producers and consumer connections from and to Snowflake (PowerBI, AWS Sagemaker, AWS Lambda, Snowpark)

Des Moines, Iowa, Us

• IT Architect for HR Technology, setting up technology strategy, cloud infrastructure and developer setup• Led transition from on-prem solutions (Informatica, Denodo) to AWS, enabling serverless architecture, test automation, CI/CD pipelines and version control • Developed batch interface used for >15 integrations with external vendors (AWS Lambda, AWS Step Functions, AWS S3) and event-based API integrations (AWS Lambda, AWS API Gateway)

Des Moines, Iowa, Us

Des Moines, Iowa, Us

Berlin, Berlin, De

Migration of Shipment data from Postgres to AWS:- Gathered the reporting needs together with tech teams, controlling and business units- Adapted Oracle PL/SQL procedures and export to Exasol Data Mart and packages to the new business model and new data sources- Created the project strategy, work packages and led the daily standup and project team meetings- Defined the reporting meta model and built all objects in MicroStrategy DeveloperETL for JIRA tickets in Oracle DWH:- Built an ETL that extracts XML files from the JIRA API and loads them into the Oracle DWH- ETL includes PL/SQL packages and procedures that load the dimension and fact tables and calls a - Pentaho Kettle Job for the JIRA API access, XML flattening and data stream manipulationAdhoc Process for BI Analysts- Created and documented the business process for handling data requests from business units and controlling team- Defined the Adhoc SLA for team KPI scoring- Held regular retrospectives with BI Analysts to discuss processes and best practices for adhoc and project work within the team

Berlin, Berlin, De

- Combined data from Oracle, Exasol and Postgres Databases for Adhoc requests by the business units and controlling- Created and maintained scheduled email reports using Pentaho Kettle Data Integration- Acted as the main point of contact between the BI engineers, tech teams, business units and controlling Customer Care Data Migration- Project member for the ETL creation of customer care data from Salesforce CRM into the Oracle DWH and Exasol Data Mart to replace of an MS Access database solution- Created the meta model, KPI and dashboards defined in the project scope in MicroStrategyReturns Process Process Data- Project management for the addition of return process data to the daily ETL loading data from the warehouse postgres database into the Oracle DWH- Wrote PL/SQL Procedures for the daily ETL to update dimension tables in Oracle DWH- Created new objects in MicroStrategy

Gross Berkel, Niedersachsen, De

Analyzed the business processes to determine the requirements for the use of information technology in traditional gearbox assembly. Developed a reference model that identifies all relevant elements for the integration of cyber-physical production systems for a 3 year project at Lenze.

New York, Ny, Us

Helped Elegran to create management reporting and pushed to automate processes.Tools used: Salesforce, VBA, Quickbooks, Google Analytics

Hannover, Lower Saxony, De

Master Of Science (M.Sc.), Industrial Engineering

Bachelor Of Science (B.Sc.), Industrial Engineering