Kamel BENMESSAOUD

Delivered end-to-end BI solutions: data collection, modeling, analysis, and reporting. Built Power BI dashboards with advanced DAX measures, semantic models, and RLS for operational and management KPIs. Modeled data using UML and star/snowflake schemas for Finance, Supply Chain, and Operations. Automated business processes (invoicing, CRM, reporting) using Power Query & Power Automate. Gathered business requirements, supported change management, and documented solutions. Collaborated with ENP R&D, contributing to a scientific article on BI applications in Supply Chain. Key Tools: Power BI, Snowflake, SQL, dbt, Excel, SAP, Python, Power Automate.

As part of the Global Integrated Business Planning (IBP) team, reporting directly to the Global IBP Lead, I contributed to the digital transformation of planning processes within Sanofi Consumer Healthcare. Key responsibilities: Automated IBP workflows using Power Automate, with live data integration via Direct Query from Snowflake. Designed and deployed a comprehensive Power BI dashboard to monitor IBP performance: forecast accuracy, revenue realization (RR), historical gap analysis, and coverage rates. Collaborated closely with cross-functional global teams (Supply, Finance, Sales & Operations) to align data-driven forecasts with business priorities. Developed DAX-based metrics and interactive visualizations to enhance strategic visibility and scenario planning. Supported monthly and quarterly S&OP cycles with actionable insights and advanced data modeling. Tools & Technologies: Power BI, DAX, Power Automate, SQL, Snowflake, Kinaxis, SAP

Context: Led the Sales & Operations Planning (S&OP) process and contributed to the digitalization of Supply Chain performance monitoring to improve coordination between production and sales teams. Key Achievements: Designed and deployed an automated Supply Chain dashboard to track key KPIs. Managed the Industrial and Commercial Plan (PIC/PDP) to align production and demand. Contributed to the digital transformation of the spare parts warehouse (PDR). Keywords: Power BI / SQL / Excel / Sage X3 / ETL / S&OP / KPI / Supply Chain

Context: Analysis of the profitability of a transition toward responsible sourcing, with a focus on economic optimization and environmental impact reduction. Key Achievements: Studied procurement costs and supply flows. Developed a profitability model for sustainable purchasing decisions. Analyzed environmental and logistical impacts to support strategic sourcing.