All work · Commerce & services
Arrived to fix broken reporting and stayed six years to replace the Access system the business ran on, finding along the way that the reports had been built on data that was neither live nor complete.
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.
Fixed the data replication first, so the reports could be trusted. Then built the production system around how the floor actually works: quote entry, an appointment board, purchase and inventory detail, vehicle expenses, text-message conversations with sellers, and record locking so two buyers cannot overwrite each other. Rebuilt their messaging onto Twilio.
Traced the firm's worst recurring outage to a scheduled job that was hiding expensive SQL and periodically knocking 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.
Stack
Tell me what it does for the business, what it is written in, and what stops when it goes down. I will say plainly whether I can help.
Tell me what it runs on