Professional Work

Projects delivered in industry roles at BAT and PepsiCo.

PepsiCo

Client Health Score Model

A predictive scoring system built to proactively identify at-risk key accounts during COVID-19, enabling account managers to intervene before contracts were at risk — achieving 100% Key Account retention across the portfolio.

Python Scikit-learn pandas Excel Power BI Predictive Modelling
British American Tobacco

Geospatial Route-to-Market Optimisation

A geospatial analytics project that audited national field territory allocation, identified distribution inefficiencies invisible to conventional reporting, and redesigned routes to deliver a 16% reduction in Route-to-Market costs.

Python GeoPandas pandas Matplotlib K-Means Clustering Geospatial Analysis
British American Tobacco

Sales Compliance Detector

An unsupervised machine learning pipeline combining K-Means clustering with statistical outlier detection to identify non-compliant sales behaviour across a 300,000-outlet retail network, protecting incentive payouts and strengthening reporting integrity.

Python K-Means Scikit-learn pandas Power BI Anomaly Detection
British American Tobacco

Power BI Trade Marketing Suite

Design and automation of a multi-report Power BI suite that replaced fragmented manual reporting across ~300,000 retail outlets — resolving longstanding data discrepancies between field systems and head office, and delivering reliable self-serve intelligence to the trade marketing team.

Power BI DAX SQL Excel Data Modelling ETL