CAPS Payroll
Entertainment payroll · Sole developer and rescuer
The engine that calculates entertainment residuals, rebuilt from scratch after both sources of truth for the union rules turned out to be wrong, so the money paid out is right.
The problem the business had
When a public agency builds a freeway or rail line, every affected parcel has to be appraised and acquired. The firm's records lived in a sprawl of Lotus Notes databases, and the first ask was one thing: a map of the Gold Line rail corridor with every parcel colour-coded by acquisition stage.
What was done
The parcel map, delivered inside the firm's existing Lotus Notes estate so that investment was not thrown away, with photographs, title reports and a dated parcel diary one click away. It grew into the firm's job-log, expense, invoicing and appraiser-scheduling system with a forty-field sales-comparable database, and a client portal where an agency sees only its own jobs. Rebuilt twice as Microsoft discontinued Silverlight and then LightSwitch beneath it, latterly as Esri-backed cloud sites. I stood up the entire Esri mapping estate personally and lifted years of Lotus Notes records into SQL Server to make the client portal possible.
What it returned
Became the firm's entire operating system and stayed in production across two platform deaths. Both exits were done without stopping the firm's work.