/Work

Case studies

Each of these is either running in production or has a public repository. Where a number appears, it was measured rather than estimated.

Architecture diagram: five REST and file sources feed a Microsoft Fabric OneLake warehouse through bronze, silver and gold layers, consumed by Power BI, an InfluxDB dashboard and a Telegram bot.

Medallion data warehouse

2026

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.

Tong Yulduzi

2026

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.

/2026AuraFlixFastAPI / PostgreSQL / Redis / SQLAlchemy 2

AuraFlix

2026

A streaming backend where the two interesting problems are getting playback to start quickly and counting views without writing to Postgres on every play.

/2026PulseFastAPI / WebSockets / Redis Pub/Sub / PostgreSQL

Pulse

2026

A realtime chat and social platform. WebSockets for delivery, Redis Pub/Sub for fan-out across processes, and an async FastAPI backend behind it.

/2026Publishing APIFastAPI / PostgreSQL / Redis / Celery

Publishing API

2026

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.

/2026E-commerce backendDjango / PostgreSQL / Django ORM / SCSS

E-commerce backend

2026

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.