Ontario Public Service · May–August 2025
Making program data easier to work with.
At the Ministry of Natural Resources, I supported program operations through dashboards, data validation, systems investigation, and workflow automation.
Read about my contribution
The business need
Monitor program submissions, application status, and regional performance, while working with inconsistent data and municipal documents in different formats.
My contribution
I developed Power BI dashboards connected to Dynamics 365 and Dataverse, and designed and tested an extraction workflow for 400+ municipal PDFs using Power Automate and AI Builder. I investigated discrepancies, documented technical processes, and presented the work to ministry management.
The work produced
Interactive reporting, a tested document-extraction workflow, and supporting documentation. The work involved consultation with ministry staff, managers, and IT colleagues.
This is a written overview of my role. Internal government data and dashboards are not published here.