Data Migration, System Integration and Database Development for Bupa Healthcare

Bupa is a leading health organisation with a turnover of £3.7 billion, operating in eight countries. Across this large organisation legacy applications stored valued data that was siloed, impacting its transparency. Access to the data was limited, and the ability to extract and analyse it was timely and costly.

We have carried out two migrations for BUPA working with two separate specialist divisions in BUPA's Manchester and London offices.

The first migration at BUPA Manchester office involved extracting large amounts of financial information from a legacy Oracle database and working closely with BUPA’s in-house team to improve data quality and migrate the data into the target system.

The second migration at BUPA’s London offices was a redesign of an MS Access database which was used for recording Health Fact Sheet Review Information. Most of the work was performed remotely except for the projects initial analysis and group presentation/workshop meetings where one to one 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 were successfully completed due to the collaborative team effort between ourselves and BUPA staff.

We also completed a successful 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 log file.

The centralisation of this data created greater operational efficiencies and allowed BUPA to bring products to market faster improving their competitiveness and ability to improve customer care.

08/10/2014