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.