A collection of analytics, engineering, and automation work — covering ELT pipelines, data modelling, BI dashboards, and more.
How I designed and built this portfolio from scratch using plain HTML and CSS, with no prior web development experience. A four-hour foundations course, version control from day one, and an iterative AI-assisted workflow.
Live
Designed and built an interactive dashboard exploring the history and evolution of LEGO sets over the past five decades, as part of the Maven Analytics 2024 data challenge series.
Live
How I replaced a manual monthly process with a fully automated ELT pipeline using GitHub Actions, Neon PostgreSQL, and Python.
Live
A three-stage SQL stored procedure pipeline that automates product hierarchy propagation, runs 80+ data quality checks, and produces a full audit trail of every change — replacing a manual Excel-based process for a global energy management company.