Rami HAKKOU

• Gather and translate Supply Chain business requirements into KPIs, business rules and analytics solutions covering product prioritization, Safety Stock, Forecast Accuracy, Supply Variability and Stock Cover. • Design and maintain Power BI dashboards and transform data using dbt, SQL and BigQuery/GCP. • Implement Microsoft Fabric Write-Back workflows enabling data entry from Power BI, historization and validation of business parameters. • Manage data quality, UAT, production deployment, documentation, user training and ongoing support.

• Partnered with Transport and Purchasing teams to define KPIs, analytical dimensions, business rules and acceptance criteria. • Built data transformations and models using dbt, SQL, Jinja and BigQuery, including automated data-quality controls. • Developed Power BI dashboards covering logistics costs, service level, truck utilization, carbon footprint, inventory and the PR-to-PO process. • Coordinated with Data Engineers, architects and UX/UI teams, while managing deployment, user feedback, documentation and training across Business Units.

• Collected, cleaned and transformed data from SAP, SharePoint, Excel and CSV sources to support Sales & Operations Planning. • Developed Power BI dashboards to monitor sales, forecasts, inventory, production capacity and operational performance. • Prepared KPIs, analyses and visualizations for monthly S&OP meetings and supported capacity planning decisions with business and plant teams. • Built a Load/Capacity calculation model and contributed to process improvement and RPA initiatives through detailed functional specifications.