Work
Everything here runs in production or has a public repository.
Five public sources, none of which agree with each other, landed in Microsoft Fabric and refined through bronze, silver and gold into a star schema that Power BI can query without a subquery.
A national children's and teenagers' newspaper moved its print operation online. I took it from an empty database to a live product, then handed it to the editorial team who run it on their own now.
A streaming backend where the two interesting problems are getting playback to start quickly and counting views without writing to Postgres on every play.
A realtime chat and social platform. WebSockets for delivery, Redis Pub/Sub for fan-out across processes, and an async FastAPI backend behind it.
A Medium-style blogging backend. Articles, tags, comments and likes, with email flows and metric syncing pushed onto a Celery worker instead of the request.
Catalogue, basket and checkout on Django over PostgreSQL, with payment and email integrations, customer reviews, and an audit log recording who changed what and when.
