🇫🇷L'OréalBeauty · Retail Analytics

Retail Gold Web Application (SalesApp)

IBM · Jul 2026 — Present

✓Global rollout — thousands of users across regions
✓Near-real-time KPI dashboards replacing manual reporting
✓Global → Country → Area → Store drill-down analytics
✓Multi-country localization pipeline (Sheets → JSON → GCS)
✓Faster queries via parameterized SQL, caching & virtual scrolling
Tech Stack
Next.jsReactTypeScriptMUIReact QueryNestJSGraphQLBigQueryFirestoreGCPAzure ADPlaywrightStorybook
The Challenge

L'Oréal's retail teams — from global HQ down to individual stores — relied on fragmented, manual reporting to track sales, traffic, product, brand, service and CRM performance. They needed one near-real-time analytics platform that works across countries, languages and very large data volumes.

The Approach

Working at IBM, built full-stack features for the Retail Gold SalesApp in a modular monorepo: Next.js, React 18, TypeScript, MUI and React Query on the frontend, NestJS/Node.js APIs with GraphQL and REST integrations, and BigQuery, Firestore and GCS on Google Cloud (App Engine with autoscaling). Designed KPI dashboards (Sales, Transactions, ATV, UPT, Traffic, services; WTD/MTD/QTD/YTD and historical comparisons), Global → Country → Area → Store drill-down, and reusable Nivo, Highcharts and D3 visualizations including heatmaps and treemaps. Implemented Azure AD and Retail API authentication, SSR/CSR rendering decisions, parameterized SQL with caching, virtual scrolling for large sales lists, Playwright tests and Storybook components, plus a Google Sheets → country-specific JSON localization pipeline.

The Outcome

A global retail analytics platform used by thousands of users across regions, replacing manual reporting with centralized, near-real-time dashboards that support merchandising, staffing and operational decisions — with multi-country localization and multiple deployment environments.

Project Overview

Global retail analytics platform used by thousands of L'Oréal users across global, regional, country, area and store teams. Delivered a redesigned V2 experience across Sales, Business Analytics, Products, Services, Traffic, CRM, Control and Brand, with Global → Country → Area → Store drill-down. Built with Next.js, React 18, TypeScript, MUI and React Query on NestJS/GraphQL APIs over BigQuery and Firestore, with Azure AD authentication. Built reusable KPI dashboards (Sales, Transactions, ATV, UPT, Traffic; WTD/MTD/QTD/YTD comparisons) and Nivo, Highcharts and D3 visualizations, plus a Google Sheets → country-specific JSON localization pipeline for multi-country rollout.

Delivered At
IBM India Pvt Ltd
Senior Application Developer (Full Stack & Cloud) · Sep 2024 — Present
View role →
More from this period
🇺🇸Abercrombie & Fitch Co.
E-Commerce Frontend Modernization
Retail · E-Commerce
🇺🇸National Grid USA
MDS Consolidation EPO Tracking Application
Energy · Enterprise

Need something similar built?

Available for freelance contracts and remote full-time roles globally.

Hire Me NowAll Projects →