← Back to work & interests

More of the work

Contribution archive.

Specific changes, projects and teaching work. Each entry links to a case study or role summary with more context.

22 contributions

Reset filters

Entries group related changes. Year filters use the case-study or project period; each story explains the scope of its results.

Kraken Technologies

2026

Operational tooling

Operational jobs platform

Built a permissioned web interface for launching Kubernetes Jobs, tracking execution and inspecting captured output.

Kraken Technologies

2026

Reliability

Concurrent execution and recovery

Used ordered row locks to prevent equivalent jobs running concurrently, with reconciliation against Kubernetes state.

Kraken Technologies

2026

Performance

Batching settlement queries

Replaced per-meter queries with batches of 1,000: 200,001 queries become 201 in the query model for 100,000 meter points.

Kraken Technologies

2026

Performance

Bounded message queries

Limited ordered inputs before combining message results; recorded SQL execution fell from about 63 seconds to 16.5 ms in the query benchmark.

Kraken Technologies

2026

Performance

Lazy pagination at scale

Replaced full-table counts and added filter indexes, eliminating timeouts on a view spanning approximately 26 million records.

Kraken Technologies

2026

Performance

Recovering production storage

Safely removed 11 redundant PostgreSQL indexes across two estates, reclaiming approximately 1.43 TB.

Kraken Technologies

2025–2026

Data integrity

Validate before submission

Blocked approximately 483,000 invalid updates per month across two enterprise clients.

Kraken Technologies

2025–2026

Data integrity

Repairing migration data

Corrected overlapping meter dates, preserved required fields and built bulk repair tooling with dry-run support.

Kraken Technologies

2025–2026

Reliability

Missing-timestamp handling

Fixed a validation defect responsible for 3.7 million application errors, adding regression tests and diagnostic logging.

Kraken Technologies

2026

Authentication

Multi-tenant authentication

Implemented and tested SSO for two organisations using OIDC, Okta and django-allauth with email-domain routing, plus signed access to a related service.

Kraken Technologies

2026

Database migrations

Staged schema migrations

Introduced a new settlement uniqueness constraint, updated application lookups, then removed the old constraint to accommodate rolling deployments.

Kraken Technologies

2026

Performance

Reusing connections at scale

Reused an S3 client instead of creating one per message in a consumer handling a reported 247 million notifications monthly.

VirtualSpeech

Nov 2024–Sep 2025

APIs

Documents into scenarios

Built file ingestion and processing, with JavaScript, HTML and CSS frontend features.

CoLab Exeter

Sep 2023–Sep 2024

Leadership

Delivering connected care

Led a team of six, translated charity requirements into features, and deployed the Django application on Google Cloud.

CoLab Exeter

Sep 2023–Sep 2024

Cloud migration

A move without interruption

Migrated the application from Google Cloud to DigitalOcean with zero downtime.

Manchester City FC

Jun–Aug 2023

Visualisation

Football in three dimensions

Built an internal Python and Three.js tool and demonstrated it at the Etihad Stadium.

Exeter Entrepreneurs

Sep–Dec 2022

Teaching

A first step with Python

Designed and taught a ten-week fundamentals course for university students.

A personal collection

An ongoing interest

Personal project

Recipes to cook from

A searchable collection of recipe flow tables with a print-friendly view.

University of Exeter

Sep 2020–Jul 2024

Education

MSci Computer Science

Completed the University of Exeter integrated master’s degree with a 2:1, September 2020–July 2024.