Bruce Gilham Jr.

All work · Property & infrastructure

Mason & Mason / DSM, Inc.

Thirteen years as the only developer on one firm's system: LotusScript inside their Notes estate, then Silverlight, then LightSwitch, then Esri ArcGIS cloud sites over SQL Server, each rebuild done while the previous one stayed live.

Years
2011–2024
Sector
Right-of-way appraisal and eminent domain
Role
Sole developer and architect
Outcome
Still running

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. I installed and configured the whole Esri estate myself, ArcGIS Enterprise, Portal, Web Adaptor, Desktop, licensing, SSL and the JavaScript API, and wrote the migration that lifted years of Lotus Notes records into SQL Server for the client portal.

What happened

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.

Stack

Silverlight LightSwitch Lotus Notes C# .NET SQL Server Lotus Notes / Domino LotusScript HTML5 OData Esri ArcGIS Enterprise Bing Maps IIS Windows Server

Inherited 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.

Tell me what it runs on