Previous projects
21 projects, written up in full.
These 21 are the ones I've written up, from more than 50 delivered. Across fintech, EdTech, mobile gaming, e-commerce, creative agencies, and enterprise. Each walks through the problem, the architecture, and the numbers.
Showing all 21 projects
The weekly trading report that writes itself
The Monday trading update took a day and a half by hand and sometimes quoted a figure that no longer matched the model. An assisted-reporting layer drafts it now; a person reviews and sends.
The numbers reconcile before anyone is awake
Orders, payments and fulfilment lived in four systems that quietly disagreed. A nightly agent reconciles them and posts only the exceptions to Slack.
Ask the model what the metric means
Three teams quoted three different completion rates. A copilot over the semantic layer answers what a metric means, grounded in the live model.
From spreadsheets to BI for an investment platform
Whisky and wine investment platform with no centralised analytics. Built the foundations from zero, working daily with the CEO, CFO, and CPO.
The ARR model the board runs on
ARR pieced together from billing exports and disagreeing across teams. Built a from-scratch, net-portfolio ARR model finance and the board now run on.
Automating leadership reporting into Slack
Leadership wanted the key numbers in Slack every morning. Four scheduled bots now post them automatically.
Killing a payment experiment in time
A proposed cost saving: drop a high-fee wallet from checkout. The experiment showed it would lose multiples of what it saved - so it stayed.
What predicts a loyal member
Early-tenure churn at an all-time high. Found the activation aha moment, the drop-off cliff, and the behaviours that predict a member who stays.
Creating an interactive reporting hub
Online learning platform serving 350M users across 35 countries. Replaced slow, inconsistent dashboards with one centralised hub.
Which marketing actually moved pipeline
Marketing's OKRs were vague and its impact unprovable. Built the account-based attribution model that ties campaigns to pipeline on agreed definitions.
Building a unified data warehouse
Critical business data scattered across Greenhouse, Hubspot, Salesforce, Jira, Freshdesk and more. Pulled it all into one place.
Restructuring AB testing processes
Cumbersome AB testing setup with long runtimes and limited insights. Rebuilt the framework end to end.
Creating an automated YouTube analytics dashboard
12 YouTube channels reported by hand in Excel. Replaced it with a fully automated, interactive dashboard on a unified data model.
Building a data-driven culture
Multinational with data scattered in text and Excel files, inconsistent KPIs across regions. Migrated everything to a real warehouse and rebuilt the metric language.
Product strategy backed by data
Product team missing targets, with no data behind the strategy. Ran a series of analyses that completely pivoted the company's monetisation approach.
Data automation and dashboard implementation
Creative and digital agency in the Middle East drowning in manually-updated Excel reports. Replaced the lot with automated dashboards.
Data infrastructure optimisation for an online pharmacy
Spanish online pharmacy with data scattered across SharePoint and limited BigQuery retention. Built a future-proof infrastructure with custom segmentation.
Leading a company-wide Looker transition
Mobile gaming company moving from Tableau to Looker for self-service analytics. Joined to manage the transition and act as lead analyst.
Unified data tracking setup across Android, iOS, and web
Online learning platform with inconsistent event tracking across platforms. Built a unified taxonomy and rolled it out without disrupting live ops.
Mobile game launch data flow setup
Worldwide game launch with no production events to test against. Designed the tracking and validation flow from scratch so analytics worked from day one.
Data-driven marketing strategy
Paid campaigns running with broken tracking. Fixed the foundations, then built the analytics on top.