VectorUSA
Network and infrastructure contracting · Sole developer
Field labour capture for a network contractor — technicians, approvals, pay-period rules — replacing accounting's slow Access front end.
What was wrong
A used-car buyer's reports were built on a data warehouse that was silently losing rows, and the floor ran on an unstable Microsoft Access system where two buyers could overwrite each other's work. The old system's habits had been designed into the data itself.
What I built
Fixed the replication first. Then built the production system as a desktop client over a web-service layer, following the work of the floor — quote entry with make/model filtering, appointment board, purchase and inventory detail, vehicle expenses, SMS conversations, and record locking. Rebuilt their messaging onto Twilio with push refresh.
What happened
Traced the firm's worst recurring outage to a scheduled job masking expensive SQL that was periodically driving replication out of sync — which meant the reports had been built on data that was neither live nor complete. In daily use through the last exchange.