CAPS Payroll
Entertainment payroll · Sole developer and rescuer
A residuals calculation engine rebuilt from scratch on LightSwitch, Silverlight and SQL Server after both sources of truth for the union rules were found to be wrong.
What was wrong
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 I built
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 a desktop job-log, expense, invoicing and appraiser-scheduling system with a forty-field sales-comparable database, and a client portal where an agency saw only its own jobs. Rebuilt twice as Microsoft discontinued Silverlight and then LightSwitch beneath it, latterly as Esri-backed cloud sites. Stood up the entire Esri estate personally: ArcGIS Enterprise, Portal, Web Adaptor, Desktop, licensing, SSL and the JavaScript API. Lifted years of Lotus Notes records into SQL Server to make the client portal possible.
What happened in production
Became the firm's entire operating system and stayed in production across two platform deaths. The Silverlight and LightSwitch exits were done without stopping the firm's work.