Case Studies

Data pipelines, backend systems and workflow automation, each analysed the same way: 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.

• Bespoke Financial Workflow Automation Suite

  Custom-built automation suite for supplier payments, subcontractor certificates (CIS/HMRC/BACS logic) and CIS payment sheets: bespoke schema, workflow engine and multi-level approval pipeline.

  Custom Data Model Workflow Engine Approval Automation E-signature System Design

  ↳ The suite eliminated a full administrative role and replaced manual approval chains with structured digital workflows, including e-signature and multi-level authorisation.

  5 min read

• Materials Requisition Portal

  Full-stack Go/PostgreSQL/React system: alias-mapped catalogue import, full-text search, JWT role-based access and a snapshot-based requisition audit trail, deployed with Docker.

  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

• Supplier Data Ingestion Pipeline (15+ Sources)

  Python ingestion pipeline (requests, BeautifulSoup, Selenium, pandas) with isolated per-source extractors, normalising 15+ supplier sources into one SQL-backed catalogue.

  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/pandas jobs that evaluate expiry and off-hire thresholds and send de-duplicated SMTP alerts — push-based monitoring replacing manual checks.

  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

  Go/PostgreSQL ingestion API normalising fragmented multi-site attendance logs at the point of entry into one schema, served to a React frontend.

  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

  Event-sourced Python/SQL Server pipeline: QR scans ingested as immutable events, with current asset location and status derived from the event log.

  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

  Versioned SQL Server data model and e-signature workflow replacing paper sign-off for compliance calculations, with a Power BI status view over the same schema.

  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

  Go/React/SQL Server rules engine that resolves multi-level approval chains from submitted values — rules as data, frozen per request, with an append-only audit log.

  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

• Sales Performance Analytics Dashboard (Power BI)

  Interactive Power BI report on a dimensional sales model: ~40 DAX measures, time intelligence, target tracking, what-if pricing and drill-down. Practice project on a public sample retail dataset.

  Power BI DAX Power Query Data Modelling

  ↳ A multi-page interactive report where KPI cards, trend lines, gauges, maps, tables and analytical visuals all read from the same shared measures, so they agree with each other under any slicer selection.

  6 min read

No case studies use that tag yet.