ANALYTICS TOOLS
Designed & built centralised analytics portal for 30+ countries using PowerBI & Google Cloud Platform
✭ Showcasing Regional analytics tools
✭ 100+ monthly users
(1) STOCK OPTIMISATION MARKETPLACE
-
Developed stock analysis tool for 31 countries & 36 brands
-
User-centred with customisable toggles and filters
-
✭ Includes stock optimisation recommendations using Python - $3.5 million USD of cost savings
✭ 290 million units (400 million USD) of inventory analysed
(mockup data shown)
(2) ML FORECASTING TOOL
-
Coded AI/ML forecasting tool for predicting optimal stock production quantity monthly. Improved accuracy by 12% with annual cost savings of $1.1 million USD
-
Won TechBlazer Award for Innovation
-
Utilised SARIMAX & neural networks
(3) FORECAST ACCURACY TOOL
-
Enabled analysis of forecast accuracy, a key business KPI
✭ Automated Reporting: Enabled time savings of ~80 hours monthly
(4) DATA VISIBILITY TOOL
-
Created Data Visibility tool enabling end-to-end view of product data, significantly enhancing data utility & self service
✭ Top 1% most-viewed reports in L’oreal with >130 users
✭ Successful rapid built in <1 month with extensive data including formulas, packaging, forecast, stock, invoices