DCA was entrusted to migrate 1.2 million items of data from 38 data sources of varying formats and technology including Oracle, SQL Server, DB2, Access, Firefox Pro and others into a single database. This was completed within deadline and without issue.
Manager National Services – Australian Health Practitioner Regulation Agency
Client Industry – Government
AHPRA is the Australian Health Practitioner Regulation Agency. It is the organisation that has supported National Boards regulating the following 14 health professions since 1 July 2010.
- Aboriginal and Torres Strait Islander Health Practitioners
- Chinese Medicine
- Medical Practitioners
- Medical Radiation Practice
- Nurses and Midwives
- Occupational Therapists
The aim of AHPRA is to help these health professionals move around the country more easily, reduce ‘red tape’, provide greater safeguards for the public and promote a more flexible, responsive and sustainable health workforce.
The business objectives of the data migration was to ensure that:
- Staff in the existing 38 organisations could continue to complete their daily duties and fulfil their obligations with minimal disruption and system down-time..
- Completed, cleansed, consistent, and de-duplicated registration data was migrated into the new core registration application from the existing source applications for the fourteen health professions to support the core operations of the new Agency by ‘go-live’ (1 July 2010).
- Core system(s) electronic legacy data, legacy file/server data, paper files (to be co-located with relevant staff) and any other relevant reference material to complement core functions were still accessible post ‘go-live’.
- Enough data was assembled from all sources to be able to generate a mailing to practitioners on 1 April 2010.
Technically, DCA had to migrate 1.2 million items of data from 38 data sources of varying format and technology including Oracle, SQL Server, DB2, Access, Firefox Pro and others into a single database using the Pivotal/NRAS data model, and upload this data into NRAS in time for a system go-live on 1 July 2010.
DCA created a data migration plan and strategy that involved physically visiting all 38 sites and liaising with key business and technical staff to gain an understanding of the systems being used.
Each of these pieces of analysis work were input to create a data mapping document for each system that described how and what data would be migrated from each of the systems. They also included the mapping of registration types and other details from the old legislation to the new legislation and other data translation required.
DCA then used its Nirvana data management software to create a repeatable and re-startable data migration and transformation process.
Key objectives of this were:
- The data migration process had to handle data in a staged manner, as each organisation’s data becomes progressively available.
- The data migration process had to handle the integration of data into an already live application.
- The data migration process had to support migration of all data from a particular application or only migrate changed data (‘delta’) since the last migration.
- Data migration activities allow for parallel execution of old and new systems.
- Manual data entry is minimised.
- End-to-end traceability of data to be provided from the legacy data extracts, through to the data in the target system..
- Exception and reconciliation reporting to be available across all stages of the migration process.
During the project DCA skills were recognised and we were also commissioned for additional work including:
- Creation of the Data Dictionary for the NRAS data model – The project to build the new registration system was running behind and the vendor was struggling to meet deliverables, one of which was to supply the data dictionary to DCA for the registration system. DCA took over this piece of work and delivered the data dictionary.
- Data Load Tool (NOODLE) – A large risk in the new registration system that was highlighted by DCA was the amount of time it would take to load the data using the data load function that was included in the product. DCA took over this piece of work and built a batch load tool that reduced the data load time from days to less than two hours.
By the 1st of July 2010 DCA had successfully migrated all the data from the various boards across Australia, into a single registration system. Achievements included:
- System outages were kept to a minimum (in some cases only included the weekend).
- No active practitioner records were lost.
- The migration process met the established minimum data set fields in the NRAS system.
- Manual processes were well managed and tracked to enable any decisions to be reviewed and audited as required.
- Data was not disclosed or leaked to any unauthorised parties.
- During the project all key milestones and deliverables were met.
Download Case Study
- BPO, Consolidation, Data Cleanse, Data Migration, DB Management, De-dupe
- eHealth, Govt.