Ayoub Youssoufi

Migrated legacy Oracle data structures to SAP S/4HANA analytics pipelines using dbt and BigQuery on GCP

Designed dbt staging, intermediate, and reporting layers to standardize SAP manufacturing

Built analytics dashboards delivering visibility on production, batch inspection, production network...

Implemented data quality tests and validation rules in dbt to ensure reliability of datasets

Collaborated with stakeholders in an Agile environment to define KPIs and business metrics

♦ Development and optimization of a data platform for processing sales performance

♦ Implementation, maintenance, and centralization of data pipelines with automated CI/CD to reduce deployment latency by 80%

♦ Design and deploy key analytics metrics for tracking commercial performance using, DBT for data transformation and Power BI for visualisation. Achieving +5% YTD sales improvement

♦ Translate messy files into trusted data: Create robust, repeatable processes to extract and normalize data from Excel (multi‑sheet, merged cells, header variations, hidden rows, cross‑tab layouts) and PDF documents (including OCR and table extraction), mapping to standardized schemas.

♦ Development of a data extraction pipeline orchestrated by Airflow/Docker and reducing manual intervention by 50% of the actual time

♦ Collaboration with project managers to gather requirements

♦ Optimized cost of delivery packages to the customer with scope 10% YoY in

reduction by deploying a data pipeline

♦ Built data pipeline to streamline data delivery between 3P carriers and

Amazon stakeholders

♦ Built analytics and visualizations using AWS Quicksight for conceded

deliveries. The scope 5% YTD in DPMO reduction

♦ Optimized Redshift queries processing 400M+ daily records, cutting costs by

$80K annually

♦ Automated workflow of 2 lambda Functions using Event Bridge

♦ Writing a handover documentation for the internal use of the deliverable