Anass Lachkar

• ▪ Design of a mandate management solution on Microsoft Fabric (OneLake/Lakehouse), reducing data refresh latency by 35% through optimized partitioning and semantic model caching.

• ▪ Delivery of 6 Power BI dashboards (star schema, DAX, RLS) for Covivio, merging 4 data sources and reducing report generation time from 3 days to D+0, for 50+ concurrent users.

• ▪ Automation of mandate workflows via Power Automate, eliminating 40% of manual transfers across 12 business functions and reducing error rates to near zero.

• ▪ Development of a Power Apps solution replacing Stellantis' Excel tracking, reducing operational processing time by 40% and eliminating ~200 hours/year of manual data entry.

• ▪ Design of KPI dashboards (DAX + star schema) tracking 15+ supply chain metrics across Stellantis' European supplier network, enabling data-driven purchasing decisions.

• ▪ Integration of an Azure Cognitive Services AI chatbot into the reporting workflow, reducing information retrieval time by 60% and accelerating access to supply data.

• ▪ Mapping of 8 cross-functional logistics processes using VSM (Lean Six Sigma), identifying 5 waste areas and delivering a continuous improvement roadmap adopted by management.

• ▪ Creation of Power BI visual management dashboards, reducing inter-departmental reporting costs by 25% and providing real-time KPI visibility for 3 operational teams.