Danone Sub-Saharan Africa · ~€120M revenue scope · 15+ markets · 200+ stakeholders
📍 Laval, QC · Canadian Permanent Resident · Available immediately
🔗 LinkedIn · 📧 serge.nguena1@gmail.com
I turn complex multi-market sales data into decisions. For 6 years at Danone, I owned the single source of truth for commercial performance across 15+ Sub-Saharan African markets — serving Commercial, Marketing, Supply Chain, Healthcare, Finance and HR teams from one integrated analytics ecosystem.
| Project | Description | Stack |
|---|---|---|
| 📊 Excel Commercial BI Dashboard | 8-tab BI dashboard monitoring €120M scope · 8 brands · 20 sub-brands · 200+ stakeholders | Excel · VBA · Advanced Formulas |
| ⚙️ VBA ETL Multi-File Compiler | Processes 70+ distributor files into a single database in under 4 minutes | VBA · Excel Automation |
| 🔍 SQL FDA Food Incidents Analysis | Exploratory analysis of 231K adverse event reports · GROUP BY · CTE · INNER JOIN · YoY trends | SQL · BigQuery |
| 🔷 Power BI Dashboard | 8-page interactive report · SKU-level · 6-year history · self-service data export | Power BI · DAX · Power Query |
| 💰 Revenue scope monitored | ~€120M |
| 🌍 Markets covered | 15+ Sub-Saharan Africa |
| 👥 Stakeholders served | 200+ across 6 departments |
| ⚡ Files processed by ETL | 70+ in under 4 minutes |
| 📉 Trade overspend reduced | from +30% to –5% |
| 📅 Reporting delivery | from 22nd → 2nd of month |