Data Integration Specialist
- Pre-processed 470,000 Building address records from Nova Scotia by cleaning and wrangling the dataset using SAS, resulting in excellent standardized data used to update the database of Canadian Buildings.- Designed strategies for record linkage to update and maintain the integrity of the Statistical Building Register and achieved a 96% linkage rate using StatsCan’s Matching Engine.- Leaded the pilot project to create dashboards and visualizations in PowerBI to display the status of… Show more - Pre-processed 470,000 Building address records from Nova Scotia by cleaning and wrangling the dataset using SAS, resulting in excellent standardized data used to update the database of Canadian Buildings.- Designed strategies for record linkage to update and maintain the integrity of the Statistical Building Register and achieved a 96% linkage rate using StatsCan’s Matching Engine.- Leaded the pilot project to create dashboards and visualizations in PowerBI to display the status of Statistic Canada’s databases and communicate complex processes to upper management.- Delivered client with 4.1 million high quality address links by cleaning and record linking addresses in an unclean dataset to the Statistical Demographic Database. Show less