•Lead in the design and development of a Qlik Sense solution in order to fully utilize water billing data dumps provided by the third-party vendor•Developed a robust data model integrating water billing history, customer details, water meter information, and geographical mapping data, allowing for a comprehensive view of data•Designed interactive dashboards enabling team members to easily access key metrics such as water consumption trends and predictive water meter replacement analysis•Successfully increased department efficiency by implementing semi-automatic solutions to streamline daily tasks and provided key support for key projects•Nominated for the city’s Golden Pylon Leannovation Award

•Scrubbed and consolidated water billing data to create a Microsoft Access database, supporting various department initiatives including the water forgiveness and water modeling projects•Analyzed water billing data to check for anomalies such as faulty water meters, duplicate billing, customer undercharges, and properties without a water meter leading to successful reclamation of revenue•Consulted with team members in order to create various VBA scripts to automate tasks and provided day-to-day support to resolving issues related to water bill analysis•Contributed to the GIS water mapping project by developing a layered system that integrated preexisting geographical points in Vaughan with corresponding billing information