At Employment and Social Development Canada, I analyzed semantic models and fact tables to document dimensional data structures supporting Old Age Security data processes. I also queried data with SQL to identify model gaps and translated stakeholder reporting requirements into analytics solutions.
At Global Affairs Canada and the City of Ottawa, I delivered Power BI dashboards for migration, trade, tourism, and operational reporting. Earlier, at the Department of National Defence, I built a dashboard and reporting pipeline for project risk and status data, and at the Office of the Superintendent of Financial Institutions, I automated weekly reporting with Excel VBA.
