Developed an Intervention Framework to aid decision-making for $27 million annual investment in primary prevention interventions to change behaviour that will positively impact health. Documented 10 As-Is and To-Be business processes using Business Process Model Notation. Projects funded under this initiative focus on innovative, integrated approaches to promote healthy living, prevent chronic disease and [...]
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 [...]
The 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 [...]
Bronson 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 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 [...]
The 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 [...]
ETL pipeline in Tableau Prep. Finely tuned to suit CRTC short and long-term needs. Proof-of-concept for automating ETL with larger datasets. Project Description Bronson used Tableau Prep to develop an ETL pipeline to transform normalized quarterly survey data into a Tableau-ready format for CRTC analysts. Business Challenge Anticipating the [...]
Bronson 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 [...]
Bronson 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 [...]
Developed 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. Project Description Ottawa/MacDonald-Cartier International Airport Authority (YOW) was at a turning [...]