Ayoub Youssoufi

𝐂𝐨𝐧𝐭𝐞𝐱𝐭: Contribution in the development of an end-to-end delivery of an SAP data migration (𝘑𝘋𝘌 𝘖𝘳𝘢𝘤𝘭𝘦 -> 𝘚4/𝘏𝘈𝘕𝘈) program using GCP (BigQuery) and leveraging a Medallion architecture with dbt 𝐊𝐞𝐲 𝐑𝐞𝐬𝐩𝐨𝐧𝐬𝐢𝐛𝐢𝐥𝐢𝐭𝐢𝐞𝐬: ➢Designed and structured staging, intermediate, and ad-hoc layers in dbt to standardize SAP data. ➢ Implemented data quality tests (dbt test) and validation rules to ensure dataset reliability. ➢Managed production RUN and resolved critical incidents in the PROD environment. ➢Developed Power BI dashboards for production and supply chain teams, focusing on production orders, batch controls, and quality management. ➢Implemented SQL best practices and styling guidelines using sqlfluff. 𝐓𝐞𝐜𝐡 𝐒𝐭𝐚𝐜𝐤: dbt, GCP (BigQuery), Terraform, Python, Git, Jira, Confluence

𝐂𝐨𝐧𝐭𝐞𝐱𝐭: Design and deploy a unified data platform to centralize sales forecast analytics, automate complex data ingestion, and eliminate manual reporting workflows. 𝐊𝐞𝐲 𝐑𝐞𝐬𝐩𝐨𝐧𝐬𝐢𝐛𝐢𝐥𝐢𝐭𝐢𝐞𝐬: ➢Designed and deployed data transformation models using dbt. ➢Created and updated Power BI dashboards dedicated to key sales metrics and KPIs. ➢Developed and optimized raw sales data pipelines using Python and SQL. ➢Built, maintained, and centralized data pipelines on Azure Pipelines, implementing automated CI/CD deployments and orchestration via Airflow. ➢Collaborated closely with Project Managers to gather requirements and design, build, and deploy new pipelines and processes 𝐓𝐞𝐜𝐡 𝐒𝐭𝐚𝐜𝐤: Python, SQL, dbt, Airflow, Power BI, Azure Pipelines

𝐂𝐨𝐧𝐭𝐞𝐱𝐭: Optimization of the parcel delivery costs to support a strategic corporate initiative targeting a 10% YoY reduction in the cost of the delivery. 𝐊𝐞𝐲 𝐑𝐞𝐬𝐩𝐨𝐧𝐬𝐢𝐛𝐢𝐥𝐢𝐭𝐢𝐞𝐬: ➢Designed and deployed a Medallion-architecture data pipeline, extracting data from AWS Redshift and executing transformation logic using Python, SQL, and dbt. ➢Developed operational dashboards in AWS QuickSight to monitor and track unit delivery costs. ➢Collaborated with Supply Chain and Finance teams to define key KPIs and ensure alignment with business requirements. ➢Configured monitoring and alerting systems via Amazon CloudWatch. ➢Developed serverless architectures leveraging AWS Lambda, Amazon SQS ➢Built multi-step processing workflows using AWS Step Functions, orchestrated and scheduled via Amazon EventBridge. 𝐓𝐞𝐜𝐡 𝐒𝐭𝐚𝐜𝐤: dbt, AWS Lambda, AWS Redshift, AWS Glue, Python, SQL, Git, Jira

𝐂𝐨𝐧𝐭𝐞𝐱𝐭: Optimization of the inventory accuracy across distribution hubs, eliminating stockouts, and improving the fulfillment rate of Process Orders. 𝐊𝐞𝐲 𝐑𝐞𝐬𝐩𝐨𝐧𝐬𝐢𝐛𝐢𝐥𝐢𝐭𝐢𝐞𝐬: ➢Management and analysis of tobacco product inventory data within SAP ERP ECC. ➢Modeling and transformation of key database tables on Microsoft SQL Server. ➢Design and deploy Power BI dashboards to track key inventory KPIs, providing real-time visibility into stock availability and significantly reducing stockout risks. ➢Manage the production RUN and resolved day-to-day technical incidents. 𝐓𝐞𝐜𝐡 𝐒𝐭𝐚𝐜𝐤: Power BI, SQL, SAP ECC, Project Management