Case studies · Automation & AI

Automating the repetitive middle of analytics work

Python + LLM · GCP Cloud Scheduler & Functions · Power Automate · Excel/VBA · Segment · Mixpanel · Appsflyer

The pattern: in every team I've joined, a chunk of skilled people's time was going to manual, repeated work — pulling reports, tracking cases, formatting outputs. I find that chunk and automate it. AI tools have made this dramatically cheaper to do: scripts that once needed an engineer are now an afternoon's work.

Marketing reporting pipeline — Python + LLM on GCP

FindDoc · Growth Marketing

Weekly campaign reporting involved the same data pulls and transformations every time. I built a lightweight automation workflow — Python scripts written with LLM assistance, scheduled with GCP Cloud Scheduler and Cloud Functions — that handled the repeated processing end to end.

−30% reporting man-hours, week after week, at near-zero infrastructure cost
More consistent outputs — the pipeline doesn't have Friday-afternoon lapses

Compliance case tracking — Power Automate + Excel

Maples Group · Compliance

Sanction screening and case tracking ran on manual effort. I built Excel screening tools (XLOOKUP, pivot-table driven) that accelerated screening itself, and a Power Automate email workflow that took the manual bookkeeping out of case tracking.

Faster sanction screening through purpose-built Excel tooling
Automated case tracking — status updates flow through email without hand-copying

AI-assisted content production — repeatable SEO workflow

Preface AI · Freelance

Produced SEO-optimised content on AI technology topics by building a repeatable AI-assisted writing workflow — keyword targeting and search intent defined the brief, AI tools accelerated drafting, and human editing kept quality and accuracy. The point wasn't "AI writes articles"; it was a production system with consistent output and known quality gates.

Product analytics tracking — Segment, Appsflyer, Mixpanel

Automate App · Freelance

Report automation and tracking enhancement for a mobile product: event instrumentation through Segment, attribution via Appsflyer, product analytics in Mixpanel.

Also: Excel/VBA for analytical workflows

In my health-economics decision model, VBA automates repeated scenario runs and refreshes the visual outputs — the same automation instinct applied to a modelling context, improving reproducibility and auditability.

← Back to all work