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