top of page
Surface Audio

Business Intelligence Consulting

GP SYSTEMS INC.

Provider of consulting services to the Software Industry in many areas including business intelligence solutions, software development management, requirement engineering, and application architecture.  Experience includes the application of both Agile and SDLC processes to software projects in Microsoft-centric environments (.NET, SQL Server, Visual Studio, TFS, etc.).

Home: Welcome

PROJECTS

A select listing of a few of my business intelligence projects.

(For a full listing of my projects, please refer to my LinkedIn profile.)

Home: Projects

BUSINESS INTELLIGENCE DATA WAREHOUSE FOR CANADIAN CITIZENSHIP

March 2017 to January 2018

Working for Immigration, Refugees and Citizenship Canada, designed a new Microsoft-based data warehouse to expose Canadian citizenship data collected by IRCC's global case management system. The project included requirements gathering and management, database design, extract, transform, and load design, and data warehouse design.

BUSINESS INTELLIGENCE INTERFACES FOR FINANCIAL MANAGEMENT SYSTEM

October 2015 to October 2016

Working for the House of Commons of Canada, designed Microsoft-based business intelligence interfaces to support the Financial Management System Renewal project, including:

  • extract, transform, and load design for automated vendor invoice import,

  • extract, transform, and load design for the extraction of payroll data, and

  • business intelligence report design for data control and management.

BUSINESS INTELLIGENCE REPORTS FOR TICKET MANAGEMENT SYSTEM

August 2013 to July 2015

Working for the Application Lifecycle Management department of Citizenship and Immigration Canada, designed a Microsoft-based reporting system based on the ALM use of Team Foundation Server as a Ticket Management System to help support CIC’s single largest project, the Global Case Management System (GCMS). The resulting well-accepted reporting system was redesigned to support multiple projects and was rolled-out branch-wide.

BUSINESS INTELLIGENCE DATA WAREHOUSE FOR CANADIAN REFUGEES

December 2009 to November 2010

Working for the Research and Evaluation department of Citizenship and Immigration Canada, designed Microsoft-based data transfer processes, data marts and data cubes for online and offline analysis, and designed reports for internal and external use for the mining of Canadian temporary resident and refugee data for the past 30 years.  Redesigned the data audit, cleansing, cubing, and presentation of the Canadian refugee data continuum.

Typing

CONTACT US

613-862-5120

  • LinkedIn

Thanks for submitting!

Home: Contact
bottom of page