BUPA GLOBAL HEALTHCARE - Data Migration, System Integraton and Database Development

BUPA is a global health and care organisation with a turnover of £3.7 billion and business operations in seven different countries. To date we have carried two migrations for BUPA working with two separate specialist divisions in BUPA's Manchester and London offices.

The first migration at BUPA Manchester involved extracting large amounts of financial information from a legacy Oracle database. We then worked closely with an in-house team to clean, manipulate the data and load it into the target system.

The second migration at BUPA London was a redesign of a MS Access database which was used for recording Health Information Fact Sheet Review Information. Most of the work was performed remotely except for project group presentation/workshop meetings and initial analysis; where 1;1 contact with the Subject Matter Experts was essential in gathering the requisite knowledge as well as building good working relations with the relevant people. The front and back ends of the database were redesigned to allow the user to produce the first and subsequent reviews of a Fact Sheet on the same report. The original data was then migrated into the new database along with the new report templates which had been specified.

Both of these projects where successfully completed due to the collaborative team effort between ourselves and BUPA staff.

We also completed a data integration project for BUPA. This consisted of creating new data interfaces and amending existing ones which took data from the BUPA hospitals and loaded it into the back office administration systems. The interfaces were in the form of UNIX shell scripts which checked for new files every five minutes, once the files were present they were copied across servers and the data was loaded into the target system. The files were then archived and details were written to a logfile.