Production Control & Shop Floor Management Platform
Freelance full-stack engineer · 2022–2023, 2025–present · Healthcare manufacturing, orthopaedics & prosthetics
A platform for overseeing and planning the manufacture of custom orthopaedic and prosthetic devices, giving live visibility of every unit's progress through the factory and automating scheduling that was previously manual.
Outcome
4 → 1
source systems, one live view
real-time
progress across all stages
automated
planning (previously manual)
In daily production use as the primary tool for production control.
Context
A manufacturer of custom orthopaedic and prosthetic devices had no single view of what was in production or how far along it was, and production dates were derived by hand from data spread across several ageing systems. The goal was one platform to track progress across all manufacturing stages and automate planning, while the existing systems stayed in service.
What was done
Full stack, sole engineer
Architected and built the whole platform alone: a NestJS GraphQL API, a Vue 3 SPA, container-backed test infrastructure and Windows deployment.
Live production tracking
Delivered progress tracking across all manufacturing stages, from station-level status capture on shared shop-floor terminals through to per-unit history.
Automated scheduling engine
Automated production-date planning with a deterministic engine of pure functions over batched lookups, recomputed each ingest cycle and unit-tested without a database.
Distributed data integration
Integrated a cluster of MSSQL databases through isolated per-database ORM contexts, migrating the data layer to MikroORM for composite-key, constraint-free legacy schemas.
Runtime-configurable views
Built a view system that persists column sets, filter trees and layouts as data and assembles the GraphQL query at runtime, so clients fetch only the fields they render.
Virtualised data grid
Rebuilt the frontend as a Vue 3 and Vite SPA on a normalised GraphQL cache, with a virtualised table using keyset pagination that stays stable under multi-column sorts and nullable columns.
Stack
Frontend
Backend
Infra