Case Studies
Each one follows the same shape: problem, constraints, approach, architecture, stack, outcome — and what I'd do differently now. Internal, employer-proprietary implementation detail is intentionally left out; the engineering decisions are not.
-
Materials Requisition Portal
A full-stack Go/React requisition system built around cleaning years of scattered supplier spreadsheets into one searchable product catalogue.
Go PostgreSQL React REST APIs Docker↳ What used to be several people's personal spreadsheets became one searchable, versioned catalogue of real products — full-text search across thousands of items in place of manually scanning files, and a complete, point-in-time record of every requisition that doesn't quietly drift if the catalogue changes later.
7 min read
-
Large-Scale Data Extraction & Cataloguing
A requests/BeautifulSoup/Selenium/pandas pipeline across 15+ supplier sources, normalised into a single queryable catalogue feeding BI reporting.
Python BeautifulSoup Selenium Pandas Power BI↳ Product and pricing information across all supplier sources became queryable from one place instead of fifteen-plus separate manual lookups.
6 min read
-
Automated Alerting Pipeline
Scheduled Python jobs replacing human memory for expiry and off-hire tracking, with automated email alerts before anything is missed.
Python Pandas SMTP Task Scheduling↳ Expiry and off-hire tracking stopped depending on someone remembering to check a spreadsheet.
4 min read
-
Attendance Data Consolidation Platform
A Go backend and responsive frontend consolidating fragmented attendance logs from multiple sources into a single, live source of truth.
Go PostgreSQL React REST APIs↳ Management gained a single, live, cross-site view instead of a manually reconciled report that was always somewhat out of date.
5 min read
-
Real-Time Asset Tracking Pipeline
Python and QR-code ingestion replacing a manual spreadsheet with live location and status data for physical equipment.
Python QR Codes SQL Server Pandas↳ Asset location and status became something anyone could check directly, instead of something that depended on the spreadsheet being current.
5 min read
-
Compliance & Certification Workflow System
Replaced a manual, paper-based sign-off process for compliance and certification requirements with an e-signature workflow and structured calculation records.
SQL Server VBA Power BI Business Process Design↳ Certification status became a live, queryable dashboard instead of a question someone had to go and find the answer to.
5 min read
-
Multi-Level Approval Workflow Platform
A configurable rules engine that resolves multi-level approval chains from submitted form values, replacing a fixed, hardcoded sign-off process.
SQL Server Go React REST APIs Docker↳ Approval routes could be changed by updating rule records through an admin interface, with no code deployment required.
6 min read