★ Featured Projects

← Home

The site's proof-of-work — each one starts from a real question, works through the architecture and pipeline, and ends with something live rather than just an opinion piece.

Global Shock

Complete

A real AWS pipeline — CloudFormation, Lambda, EventBridge, S3 — tracking 40 years of Brent/WTI oil prices against global shock events and a three-phase recovery model. One flagship build spanning four pillars, from the business question through to the working data product.

AWS Lambda CloudFormation EventBridge S3 Python
6 parts across Data Science, Energy Industry, Data Architecture, Data Engineering
  1. 1. Global Shock Part 1: Not again!?!
  2. 2. Global Shock Part 2: The Heating Oil Industry
  3. 3. Global Shock Part 3: It's Just One Pipeline — But You Should Still Architect
  4. 4. Global Shock Part 4: Build a Daily Oil Price Pipeline on AWS with CloudFormation and Lambda
  5. 5. Global Shock Part 5: How I Hooked Oil Prices, Shock Events, and Recovery Phases Together
  6. 6. Global Shock Part 6: What We Can Conclude
Read the full series → View repo →

Energy Asset Exposure Map

Complete

Mapping Britain's energy infrastructure — offshore wind, oil & gas, power infrastructure — against natural hazard data (storm tracks, flood zones, seismic activity) to answer one question: what's on risk, and where. Built entirely from public data, pipeline and repo open for anyone to explore.

Crown Estate NSTA OpenStreetMap Geospatial join AWS
5 parts across Data Science, Data Engineering, Data Architecture
  1. 1. Where the Risk Lives — Part 1: The news can be scarey
  2. 2. Where the Risk Lives — Part 3: Building an Energy Asset Exposure Pipeline on AWS
  3. 3. Where the Risk Lives — Part 2: Why I Chose This Architecture
  4. 4. Where the Risk Lives — Part 4: Going Live
  5. 5. Where the Risk Lives — Part 5: What the Numbers Actually Mean
Read the full series → View repo →