Selected work

Internal tools built for a UK food manufacturing operation. Descriptions below are deliberately anonymised — no company names, server names or credentials — but the problems and tech stacks are real.

Production · Data integration

Production Database Integration Platform

Unified three separate production databases — a legacy DSN-based product catalogue and two SQL Server systems accessed through stored procedures — into a single Django reporting interface for products, production runs and customer orders.

DjangopyodbcSQL ServerBootstrap
Product launches

New Product Launch Tracker

Full-stack app for managing new product launches end to end — every SKU tracked from initial spec through to production readiness, with Excel and PDF export for sign-off packs.

DjangoopenpyxlReportLabPillow
Operations portal

Multi-Module Operations Portal

Company-wide portal spanning HR (staff costs, rotas, tablet clock-in), Health & Safety (incident and area audits, driver records) and production reporting (cut trials, cost analysis) with role-based admin and printable PDF reports.

Next.jsReactTypeScriptPDF generation
Production planning

Production Planning & Forecasting System

Merges live stock data from SQL Server, order data from an ERP OData feed, Excel-based demand forecasts and manual intake entries into one rolling weekly production plan.

ReactVitePythonODataopenpyxl
Internal tooling

Project Management Dashboard

Lightweight internal tool for tracking projects and tasks across teams — a single dashboard replacing a scattered mix of spreadsheets and email threads.

Next.jsReactTypeScript
Livestock management

Multi-Site Livestock Management System

Desktop application covering every stage of a livestock operation — hatchery, rearing, parent stock and layer flocks, plus factory allocation — with role-based logins, built-in compliance rule checks and automatic database backups.

FlaskSQLiteElectronPyInstaller
Seasonal peak trading

Seasonal Campaign Production Dashboard

Built for a major seasonal trading peak — imports production plans from Excel and live actuals from SQL Server to give real-time KPI tracking, a day-by-day pack schedule and kill-plan tracking in one place.

DjangopandasopenpyxlSQL Server
Stock planning

Cooked Stock Planning Tool

Tracks cooked stock through every stage — raw goods sent out to a co-packer, finished goods booked back, and allocation against customer forecasts — with automated Excel forecast import.

FlaskSQLiteopenpyxl
Forward planning

Livestock Forward Planning Model

Models flock growth against breed-standard curves and prior-year actuals, generating forward projections plus mortality and compliance tracking per flock.

DjangoChart.js
Training & e-learning

Interactive Excel Training Platform

Self-contained browser-based training course with hands-on mini-spreadsheet exercises, a live trainer dashboard tracking trainee progress in real time, and automated PDF certificate generation on completion.

Vanilla JSPythonopenpyxlpython-pptx

Want to talk about a project?

I'm always happy to chat about internal tooling, dashboards or automating something that currently lives in a spreadsheet. Get in touch via the newsletter or find more about me on the about page.