Health Shared Services BC - Business Consulting Project

Project Details

Project Client: Health Shared Services BC
Project Description: E-Procurement and Data Warehousing
Students: Anthony Wong, Ramin Nikzat, Joaquin Paniagua
Term: Spring 2014
BCIT Program: Business Information Technology Management
HSSBC is currently working on a project for integrating five separate ERP systems from the five health authorities in BC. In this integration project there is a lot of data that is migrated to a data warehouse which must be checked or validated. The current processes in place to handle the data migration to update the data warehouse are largely inefficient.

The e-Procurement and Data Warehousing (Provincial Data Management Plan) directed studies project tasked a BCIT team to do two projects. The first was a data migration validation project that compared nine different data migration validation methods to determine which method is best based on performance speed and collisions. Although there are easier ways to validate data, it would take third party software which may be costly and would be subjected to a long approval process inside HSSBC. Based on test results with a sample database of 1 million rows, the Except statement was recommended for data migration validation. This statement took about three minutes to run while the longest method took almost ten minutes. When processing a database of ten or a hundred million rows this time difference will be very significant. Additionally a report was compiled that contained pros and cons for each data migration validation method. This will be useful for the Supply Chain employee who commissioned the project to justify the BCIT team’s recommendation.

The second project was to analyze DataXpress (DX), an internal data reporting system at HSSBC, and make any recommendations for improvement if possible. After discussing DX with an employee possessing a wealth of experience in using it, the BCIT team found that many employees use DX incorrectly. This is an issue because it forces the Master Integration Maintenance team to do data validation. Several hours that could have been spent doing something more productive are spent on combing a contract of 140 items for example to find an incorrect entry that is causing errors in other HSSBC information systems. Other possible problems from not being able to pull all relevant data from DX could be ordering inventory that is already in stock or treating inactive contracts as if they were active. The recommendation provided by the BCIT team was to add a FAQs or common errors section in the DX manual to avoid preventable errors.