Jovick Fotsing

• Analyzed and resolved +500 tickets/year related to internal HMI anomalies, covering 5 business areas (markets, contracts, claims, orders, invoices). Wrote advanced SQL queries to reconstruct flows, identify root causes, and verify inter-table consistency. Optimized critical SQL queries, saving several minutes per processing cycle. Implemented recurring quality controls that reduced recurrent anomalies by ~25%. Contributed to data governance: flow traceability, GDPR compliance, business rule documentation. Collaborated daily with business referents to validate fixes and facilitate understanding of anomalies.

• Designed and deployed 6+ multi-page Power BI dashboards (segments, dynamic KPIs, maps) for ~30 business pilots. Processed and transformed tens of millions of BigQuery rows through industrialized SQL pipelines. Modeled data (star schema) and enriched it using DAX and Power Query for fiber incident management. Automated incident stock monitoring, saving an estimated ~3-4 hours/week per analyst. Defined ~15 key KPIs: processing times, volumes by typology, customer service, non-compliant repairs. Wrote technical documentation and managed functional acceptance testing of BI solutions. Led agile rituals: daily stand-ups, sprint planning, retrospectives.

• Deployed Power BI dashboards monitored by 5+ strategic departments, covering over 1,500 group sales points. Automated operational reports, reducing manual processing time by 30%. Modeled relational data (star schema) and harmonized KPIs through a common business repository for group entities. Developed predictive analyses in Python/Pandas (Scikit-learn) for hardware incidents. Used SQL Server, Power Query, and Visual Basic for datamart population and reliability. Supported and trained business users on BI tools.