Projects
Here's just a small sampling of the projects we’ve completed over the years.
-
Call Centre Data Analysis
Provided data analysis of call centre activity using SQL views and PowerBI visualizations to a S&P/TSX 60 client wishing to predict future call centre staffing requirements for their facility.
-
Cloud Migration
Migrated a suite of SQL Server Reporting Services reports from SQL2008 on-premise to SQL2016 Azure for a large, multi-national company.
-
System Migration
Managed the transition of an on-premise OLTP system into a cloud hosted SaaS environment. This included project management, stakeholder management, configuring custom reporting solutions and providing end-user training.
-
Forecasting and Reporting
Developed and implemented an automated reporting solution for calculating and forecasting the complex performance-based payment mechanism for the maintenance of a brand new 26,000 sq. m. hospital facility.
-
Data Discovery
Worked in a multi-disciplinary team to extract, transform and present financial data from a Tier-1 ERP system to meet CRA requirements, using Microsoft SQL and PowerBI desktop.
-
Database Migration
Transitioned numerous SQL-based OLTP systems, including their custom reporting stacks and ETL integrations, to new data centers for a TSX-listed company.