Selected work

Case studies

Each project starts with a practical question, builds a reliable analytical foundation, and ends with an insight, recommendation, or working product.

Featured case studies

Business Intelligence & Data QualityComplete

Sole analyst & developer · 2026

Rent outpaced income, 2019–2024
19 ppRent outpaced income, 2019–2024
Official sources in one model
5Official sources in one model

Nova Scotia Housing Affordability & Rental Pressure Monitor

Did Halifax rent rise faster than people’s ability to pay it — and did supply have anything to do with it?

A Power BI report built entirely from five official CMHC and Statistics Canada sources, with every published number traceable to a source file and a documented transformation. Includes a custom Power Query parser for CMHC’s crosstab workbooks and a documented data-quality regime.

  • Power BI
  • Power Query (M)
  • DAX
  • Excel
  • Git
Spatial & Operational AnalyticsComplete

Sole analyst & developer · 2025

Transit records analysed
663,788Transit records analysed
Stops served by a single route
41%Stops served by a single route

Halifax Transit Service Equity Analysis

Where is Halifax’s transit network leaving riders underserved?

I transformed 663,788 public-transit records into a normalized PostgreSQL + PostGIS spatial database and an interactive dashboard, surfacing gaps in route access, stop connectivity, and service concentration across Halifax.

  • SQL
  • PostgreSQL
  • PostGIS
  • Python
  • Streamlit
Causal Inference & Analytics EngineeringComplete

Sole analyst & developer · 2026

Estimated regulation effect
+0.068Estimated regulation effect
Lower forecast error vs baseline
42%Lower forecast error vs baseline

F1 Regulation Impact Analyzer

Did Formula 1’s 2022 regulations actually make the competition closer?

I built a Snowflake + dbt analytics warehouse and a causal-inference framework to separate the effect of the 2022 rule change from existing team-performance trends, then forecast the 2026 regulation reset with a walk-forward model.

  • Snowflake
  • dbt
  • Power BI
  • Python
  • statsmodels
  • scikit-learn
Analytics Platform & Team LeadershipProof of concept

Project Lead (Development Director) · 2025

Cross-functional team led
10Cross-functional team led
Samples per run (target capacity)
60–90KSamples per run (target capacity)

BIOMEX Genomics Analytics Platform

How can researchers run complex genomic analysis without depending on manual engineering support?

I led a 10-person cross-functional team rebuilding a legacy desktop bioinformatics workflow into a self-service web platform for a Dalhousie faculty researcher, delivering a working DESeq2 differential-expression pipeline as a validated proof of concept.

  • React
  • Firebase
  • R
  • R Plumber
  • DESeq2

More analytical work

Simulation & Statistical ModellingComplete

Sole developer · 2025

Historical race laps modelled
86,000+Historical race laps modelled
Lap-time mean absolute error
2.6sLap-time mean absolute error

F1 Strategy Simulation & Decision Framework

Which pit-stop strategy wins a Grand Prix — and can a model show it before the race?

An XGBoost-driven race simulator that compares alternative pit strategies across a full Grand Prix, validated against the Abu Dhabi 2024 result.

  • XGBoost
  • Python
  • Flask
  • React
  • Docker
Machine Learning & DeploymentComplete

Sole developer · 2025

Single-season model accuracy
R² 0.851Single-season model accuracy
Historical pit stops analysed
2,600+Historical pit stops analysed

F1 Pit Stop Strategy Predictor

When should a driver pit? Predicting optimal pit-stop timing from race conditions.

A dual-model XGBoost system predicting optimal pit-stop lap from 2,600+ historical stops, served through a FastAPI backend with Docker and CI/CD.

  • XGBoost
  • Python
  • FastAPI
  • Docker
  • GitHub Actions