Case Study: City of Richmond BC achieves faster community payment distribution and better program insights with Information Builders' WebFOCUS

WebFOCUS Strengthens Community Ties in the City of Richmond

The City of Richmond, serving about 200,000 residents, faced a challenge after deploying an online registration system (Class): the system tracked registrations and payments well but could not properly transfer financial data into the City’s PeopleSoft financial system, complicating timely distribution of funds to the many community associations that run recreation programs.

Information Builders implemented WebFOCUS (with iWay) to extract, transform and load registration payments into PeopleSoft, and to generate daily reconciliation reports plus an intuitive dashboard for recreation staff. The solution—built in three weeks—sped up payment turnaround, increased transparency and exception handling, strengthened relationships with community partners, and gave managers actionable insight to run programs more efficiently.

City of Richmond BC

David Ince

Coordinator