Connecting Disconnected Systems: ERP Integration Across a Municipal Operations Stack
The municipality's ERP, CRM, and Parking Enforcement systems operated in isolation. Staff were re-keying data between platforms manually. Meanwhile, the People Analytics function was running on a legacy vendor platform that was slow, expensive, and too rigid to adapt to the organization's reporting needs.
We designed and built integration service applications connecting the ERP to the CRM and Parking Enforcement system via REST APIs, with admin views for staff to monitor and manage data flows without IT involvement. In parallel, we drove the migration of People Analytics from the legacy vendor platform to a modern stack, re-architecting the data layer for performance on large HR datasets.
Manual data re-entry across departments was eliminated. People Analytics loads that previously timed out now run reliably. The IT team regained time they had been spending on cross-system reconciliation every week.