Bronson conducted a detailed review and reconciliation of program funding awarded by IESO to Alectra, an LDC channel partner opting for incentive financing through the "Pay for Performance" (P4P) model. This review included a scrutinization of contracts, cash flows, energy savings, incentive payments, expenses, and assessment of reported totals for reconciliation process. Final payment [...]
Automation of Geospatial Data Processing and Quality Assurance Review for the CRTC
Sarah Vickers2024-01-26T10:45:42-05:00Expansion of Broadband Internet coverage is a high priority for CRTC, who has established a Broadband Fund providing $750 Million over 5 years to upgrade broadband internet access in remote regions of Canada. As a result, broadband infrastructure and coverage is undergoing rapid change. This further exacerbated the underlying requirement for timely reporting on [...]
Analytical Services and Project Management for Ottawa MacDonald-Cartier International Airport Authority
Sarah Vickers2024-05-21T14:46:59-04:00From 2018 to 2020, Bronson provided a wide-range of services to support Tableau, the Ottawa Airport Authority’s chosen tool for data analytics and visualization. Bronson provided a number of Tableau-related services in parallel including: Tableau dashboard development; Tableau maintenance and technical support; and Data strategy development. Bronson’s work with the Ottawa Airport Authority was [...]
Data Analytics and Advisory Services for Natural Resources Canada’s Audit & Evaluation Branch
Sarah Vickers2024-05-21T14:56:39-04:00Due to COVID-19 restrictions, Bronson’s training sessions were delivered virtually using Microsoft Teams. Each of these training sessions had an audience of 8-12 participants, and were designed to be interactive and encourage hands-on learning by participants. Project Description Bronson was engaged by NRCan’s Audit & Evaluation Branch to [...]
Forecasting Annual Maintenance Costs for the City of Ottawa’s Fleet Services
Sarah Vickers2024-05-21T15:02:02-04:00The City of Ottawa operates a diverse fleet of roughly 2,800 vehicles used in a wide range of services including garbage collection, snow removal, ambulance and fire response. The resulting model produced by Bronson for this project is a multi-variable model which forecasts annual maintenance costs based on vehicle data and characteristics where a [...]
Retained by IESO for Compliance Audits
Sarah Vickers2024-05-21T15:09:48-04:00At its outset, the IESO CFF Programs were to have been delivered over a five-year period from 2015 through 2020. These programs were expected to generate 6.9 TWh of energy savings, with a total budget of $1.9 Billion. The audit scope included review LDC wind-down activity for 9 separate CFF Programs which targeted a [...]
Analysis of Sales Data for Farm Boy
Sarah Vickers2024-01-26T10:45:17-05:00Farm Boy is high end chain of grocery stores focused on locally-sourced fresh produce and food products. Headquartered in Ottawa, Farm Boy currently has 40 locations throughout Ontario. "Bronson was hired by Farm Boy to analyze their sales data to improve promotions and product pricing." - Phil Cormier, CA, CPA, Senior [...]
Data Aggregation for The Department of National Defence’s Strong Secure Engaged Defence Policy
Sarah Vickers2024-05-21T15:18:38-04: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 [...]
Financial Security Data Review for the Bank of Canada
Sarah Vickers2024-05-21T15:40:02-04: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 [...]
Review of Know History
Sarah Vickers2024-05-21T15:42:40-04:00Bronson applied a customized approach to conducting an organizational review of Know History, a company specializing in historical services to assist in the research, presentation and documentation of Canada’s history. Company review required extensive document review and consultation to establish understanding of company processes, policies and systems. Final report offered observations on company strengths [...]