Job Ordering Process Automation
Job ordering data was captured in Excel spreadsheets on construction sites, then manually re-keyed into Zavanti ERP — a construction management platform backed by a SQL Server database. This double-handling created a two-week processing cycle requiring five staff, with a high error rate and no audit trail between field capture and the ERP record. The manual re-entry was the single biggest source of delay and data integrity risk in the operations workflow.
I built an integration layer using Microsoft Access with ODBC-linked tables connecting directly to Zavanti's SQL Server database. Excel was retained as the field capture interface — site staff were already using it, so there was no training overhead — but scripted with VBA to validate and clean data before submission. SharePoint acted as the workflow backbone: field staff submitted completed job data via SharePoint lists, which triggered Access macros to transform and write records directly into Zavanti via the ODBC connection. Manual re-entry was eliminated entirely. The solution used only tools already in the organisation's stack — no new software, no vendor engagement, no licence cost.
Job order cycle time reduced from two weeks (five staff) to three days (two staff). Throughput increased significantly without headcount. A full end-to-end audit trail was established for the first time, giving operations management clear visibility over job status from field capture to ERP entry.