Analytics Engineering
dbt · PostgreSQL · Git
ECD Connect · Grow Great
Building a reporting data mart from a production app database
How I modelled raw operational data from two platforms into a clean, tested reporting layer serving over 4,000 practitioners and 16,000 children and clients across South Africa. And what it took to understand a database that was never designed to be queried directly.
Analytics Engineering · dbt · PostgreSQL · 17+ models
Read case study →
AI · RAG
Claude API · R Shiny · BM25
Building a RAG assistant for product documentation
A deployed assistant that lets the internal product team query 35+ feature modules in natural language, replacing manual spreadsheet lookups during sprint planning and QA. Built with the Claude API, BM25 retrieval, and R Shiny.
AI · RAG · Claude API · Production deployment
Read case study →
Product Strategy
Evidence Synthesis · MVP Scoping
ECD Connect
Strategic product review ahead of a platform rebuild
Synthesised six parallel evidence workstreams (product analytics, usability testing, qualitative field research with 290 participants, 608 support queries, and GA4 data) into a decision-ready recommendations document for an acquiring organisation. Covered problem definition, user group prioritisation, MVP scoping, UX principles, and a structured research agenda for unresolved gaps.
Product Strategy · Evidence Synthesis · 6 workstreams
Read case study →