★ 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 →

Storm-to-Outage Correlation

Complete

Do severe UK storms line up with more or longer unplanned outages across generation assets? Built on public Elexon REMIT unavailability messages and NESO curtailment data, tested against a named-storm catalogue, and kept to correlation rather than causation.

Elexon REMIT NESO BOA Python pandas Permutation tests
4 parts across Energy Industry, Data Architecture, Data Engineering, Data Science
  1. 1. Storm-Outage Part 1: El Niño Is Back
  2. 2. Storm-Outage Part 2: Picking Data I Can Actually Defend
  3. 3. Storm-Outage Part 3: Building the Pipeline
  4. 4. Storm-Outage Part 4: What the Data Actually Says
Read the full series → View repo →