The City of Coquitlam is one of the fastest-growing municipalities in the province of British Columbia, Canada. With over 150,000 residents, the city is dedicated to providing exceptional services for its citizens through smart city initiatives and technology-driven strategies.
With their curbside recycling and garbage collection, the city saw an opportunity to speed up service requests. The program used a third party to distribute carts, and for billing, it used various applications, including IBM Maximo and Tempest.
The city wanted to find a way to automate processing requests and creating work orders, but they also needed a solution that could automatically update residents’ utility bills.
How they made it possible – no code required
Having already implemented FME to solve diverse data integration challenges across multiple departments, the City of Coquitlam knew it could build on its success.
They created an FME workflow that parses Maximo for active service requests (such as the exchange of garbage or organics carts), and creates a work order spreadsheet that is sent to the vendor. Once updated work orders are returned from the vendor and entered into Maximo, FME automatically modifies the resident’s utility bill in Tempest to reflect changes in cost.
By fully automating integration processes and removing data silos, the City of Coquitlam sees significant improvement in data integrity and accessibility between its internal teams and external vendors. Their team is equipped with actionable insight that enables service requests to be addressed quickly while minimizing potential manual errors in billing. With FME, the time taken by staff to complete cart transactions has been greatly reduced.