Training Academy & Field Operations Platform
One platform covering two businesses: a vocational training academy with paid courses and certification, and the field operations behind a specialist contracting firm — leads, site visits, quotations, work orders and HR.
Discuss a Similar ProjectProject Details
Client
A specialist contractor and training academy (confidential)
Industry
Specialist Contracting / Vocational Training
Technologies
Project Overview
The client ran a training academy and a contracting business from the same brand, on a hosted database backend that had stopped keeping up. Course enrolment, customer leads and field scheduling each lived in separate places, and none of them reconciled.
We migrated the system onto a relational database and rebuilt it as a single platform. The academy side handles applications, enrolment, paid digital courses and certification. The operations side handles lead capture through to completed work order, with an HR and payroll module for the field team.
The Challenge
Existing data lived in a document store that had grown organically, and had to be migrated into a relational schema without losing historical records.
Students, staff and mobile app users all needed authentication, but with strictly separate privileges — a staff token must never grant access to student data.
Leads arrive with an address, not a team assignment, so routing work to the right crew depended on turning postcodes into serviceable coverage areas.
Certificates and ID cards had to be verifiable by a third party after issue, not just printable.
Course content needed access gating by purchase and subscription tier, including video.
What We Built
Migration from the previous document store to a relational schema, with the legacy system kept readable during transition.
Three separate authentication schemes — session-based admin, token-based SPA, and an independently keyed student scheme — so privilege boundaries hold by construction.
Geocoding-backed lead routing that converts postcodes to coordinates and caches serviceable coverage areas, with automatic assignment.
Full field pipeline: lead capture, assignment and status history, site visits with rescheduling, quotations, and work orders.
Academy features: workshop applications, printable admit cards, digital courses with gated video, and subscription tiers.
Publicly verifiable certificates issued against a unique identifier, so an employer can confirm one independently.
Payments with tax-compliant invoicing and receipt generation.
Push notification system with broadcasts, scheduled sends and per-message delivery logging.
HR and payroll: employees, attendance, leave balances and requests, payslips and exit records.
Delivered
Two businesses that had been run from separate, non-reconciling systems — course enrolment, customer leads and field scheduling — now run on one platform, from lead capture through to payroll.
Migrated off an outgrown document store onto a relational schema without losing historical records, with the legacy system kept readable throughout the transition.
Certificates and ID cards became independently verifiable: an employer can confirm one against its unique identifier without contacting the academy.
Leads route themselves — postcodes resolve to cached serviceable coverage areas and assign to the right crew, instead of being triaged by hand.
Three separate authentication schemes keep student, staff and mobile-app privileges apart by construction, so a staff token cannot reach student data.
A 52-table schema and 318 application routes across 11 modules span academy, field operations, catalog, content and HR.
Role-based access control with audit logging across administrative actions, and scheduled background jobs delivering notifications independently of user requests.
Building something similar?
Tell us what you are trying to ship and we will map out scope, timeline and a transparent estimate.
Book a Strategy Call