Bruce Gilham Jr.

All work · Media & entertainment

CAPS Payroll

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.

Years
2013–2015
Sector
Entertainment payroll
Role
Sole developer and rescuer
Outcome
Handed over

What was wrong

Residuals are what actors, directors, writers and crew are owed once a film or show earns after release. The existing application computed them from two sources of truth for the union rules, and the two disagreed with each other, and were both wrong in places.

What I built

Scrapped the existing application and rebuilt the engine: takes quarterly revenue per market, applies each union contract's break points and percentages, subtracts pension and health, and produces a separate statement per union. Back-fills every past quarter and writes adjustments for people who join a project late.

What happened in production

Handed over and running.

Stack

LightSwitch Silverlight C# .NET SQL Server Azure WCF RIA Services LINQ Telerik

Have a system like this one?

Tell me what it does, what it is written in, and what breaks when it goes down. I will say plainly whether I can help and how I would approach it.

Tell me what it runs on