A small packet mail operations sorter is highly automated and can process 10,000 packets an hour. Resources are needed to load packets such that the labels can be read, so resourcing (numbers, proficiency, assignment) have a high degree of influence on output. Several scanning technologies are used to read packet labels, such as barcodes [...]
Data Aggregation for The Department of National Defence’s Strong Secure Engaged Defence Policy
Sarah Vickers2024-01-24T11:09:58-05:00The tool which was used in the preceding capital forecasting exercise took roughly 4 hours to compile project data for capital forecasting purposes. The Alteryx tool which was developed by Bronson completed a full project load from start to finish in less than 10 minutes, and could develop modified scenarios in less than 5 [...]
Data Analytics Support to the Indigenous Community-Based Climate Monitoring Program
Sarah Vickers2023-08-02T13:54:00-04:00Bronson provided support to CIRNA’s ICBCMP by analysing data management tools, guiding work planning and developing program management guidance. As a new program, the support and tools provided to the ICBCMP allowed them to plan their work and effectively provide funding to Indigenous communities for long-term, community-based climate monitoring projects. “Bronson [...]
Data Entry Services for Employment and Social Development Canada
Sarah Vickers2022-01-12T21:36:29-05:00Bronson provided data entry services for Integrity Services Branch (ISB) of ESDC for a three year period (2017 to 2020) and captured data from over 2 million Record of Employment and Request for Payroll Information forms. The data capture was performed according to detailed specifications and was subject to an acceptable error rate of [...]
Financial Security Data Review for the Bank of Canada
Sarah Vickers2024-01-27T12:18:00-05:00The Bank of Canada uses securities-related data from various external sources to monitor financial markets and perform associated research. To make this data usable, staff must spend vast amounts of time manually “cleaning”—organizing and preparing—the information they receive. The goal of this challenge was to discover innovative ways to clean data and to surpass [...]
Data Transformation for Canadian Radio-Television Telecommunications Commission Analysts
Sarah Vickers2023-08-02T13:53:27-04:00ETL pipeline in Tableau Prep. Finely tuned to suit CRTC short and long-term needs. Proof-of-concept for automating ETL with larger datasets. "For the CRTC, Bronson's efforts included aligning measurement unit data discrepancies using a matrix to present all relevant data in a single dataset." Project Description Bronson [...]
Annual Support to NRCan’s ENERGY STAR Initiative
Sarah Vickers2022-01-13T14:27:51-05:00Bronson has assisted NRCan for 10+ years with annual updates to the ENERGY STAR Savings Calculators and Cost-Savings Examples posted to the Procurement section of the ENERGY STAR website. The ENERGY STAR Savings Calculators comprise 7 product categories, which include 48 product types and 167 product sub-types. The ENERGY STAR Savings Calculators demonstrate savings [...]
Annual Program Management for Fisheries and Oceans Canada
Sarah Vickers2023-08-28T10:45:47-04:00Bronson has assisted DFO for 20+ years for mandated departmental reporting on energy consumption and GHG emissions under the Federal Sustainable Development Strategy and Greening Government Strategy (and previous reporting frameworks).Bronson works closely with DFO’s Office of Environmental Coordination to report on over 160 facilities, an on-road fleet of 1,500+ vehicles and a National [...]
Data Management Strategy for Ottawa MacDonald-Cartier International Airport Authority
Sarah Vickers2023-08-25T12:06:33-04:00Developed a 3- to 5- year roadmap with 17 activities to mature YOW data management to a level aligned with industry trends. Made recommendations to make specific data FAIR (findable, accessible, interoperable and re-useable) to authorized users. "Bronson was engaged in understanding the data sources and capabilities at YOW to provide [...]
Push to Document Indian Residential Schools Drives Creation of the Largest Digital Repository in Canadian History
Martin McGarry2024-01-24T11:09:26-05:00Truth and Reconciliation Commission of Canada, Indigenous and Northern Affairs Canada, & Library and Archives Canada Over 10 million pages reviewed. Over 3.5 million records digitized (collected database of 5 million records). Project involved several teams working simultaneously at archive sites across Canada. Project involved all LAC national sites, including a large [...]