Hugues Froehlich

As a Data Scientist for Critical-to-Customer defect investigations:

• • Built a self-service tool in Excel to empower investigators in root-cause analysis of critical-to-customer batch defects.

• • Combined internal SAP production data with all sub-components traceability with external supplier data using Power Query, generating interpretable rules and feature importance using Python-in-Excel , resulting in insights that identified problematic component combinations now under targeted review and testing.

• • Created a datamart combining data from Salesforce, Marketing automation, web analytics and project management

• • Orchestrated data through SQL/python using Airbyte, Dbt and Dagster to ensure common metric definition across uses and track lineage.

• • Provided worksheets for users to declare fixes to apply to normalize data and bring their own manual channels data.

• • Built Power BI dashboards for yearly BU reviews and tracking omnichannel campaign operational progress.

• • Built a Power BI dashboard for strategists to see the quarterly evolution of the client database by business unit through different stages in customer journey, allowing to see which campaign impacted them.

• • Animated workshops inside EMEA marketing to define regional key driver metrics and fiscal year goals across marketing and sales funnel, and produced the monthly report.

Marketing data analyst/scientist for Marcom EMEA department.