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 — an ECD platform and a community health platform — into a clean, tested reporting layer serving over 4,000 practitioners and 16,000 children and clients across South Africa. And what it actually 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 production RAG assistant for product team workflows
A deployed AI assistant that lets the internal product team query 35+ feature modules in natural language — reducing manual overhead during sprint planning and QA cycles. Built with the Claude API, BM25 retrieval, and R Shiny.
AI · RAG · Claude API · Production deployment
Coming soon