Data Migration Services – Cerner Millennium Merger


Lewisham and Greenwich NHS Trust acquired Queen Elizabeth Hospital, Woolwich in 2014. After rolling out Cerner Millennium at University Hospital of Lewisham in 2015-16, the Trust commissioned a programme of work in 2017 to merge Cerner Millennium at Queen Elizabeth Hospital into Lewisham’s instance of Millennium. Nautilus led the project management, data migration and testing workstreams. The scope included migrating patient demographics, inpatient / day case, outpatient and ED historical activity, waiting lists for inpatient / day case and outpatients, future appointments, eRS (formerly known as Choose and Book), Theatre Scheduling and RTT. The Trust had a requirement to migrate historical clinical documentation, lab and radiology results and pregnancy history, diagnosis and procedures, in addition to the standard data sets (that are supported by the Cerner migration process.

The challenges for the Trusts were significant:

  • Stringent timescales
  • Migration of Cerner clinical data sets i.e. non-standard data sets (not just PAS)
  • Build and configuration dependencies
  • Competing priorities for operational teams / staff to support project work
  • Data quality issues

Nautilus worked with the Trust in successfully developing an archive data lookup viewer that integrated with the merged instance of Cerner Millennium. This enabled creation of a ‘unified patient record for viewing and accessing current and historical clinical data.’

Key deliverables:

  • Data profiling
  • Development and delivery of data migration strategy
  • Business rules for data migration & data mappings
  • 3 x Trial Loads, FDR and Go-Live
  • Pre-load verification tool (SQL, MS Excel and SSRS based solution)
  • RTT Reconciliation tool
  • Data Migration Test Strategy
  • Data Quality and Data Cleansing plan

Nautilus led the data migration workstream that included a Data Migration Lead, Data Migration Analyst and SQL Developer. Nautilus was responsible for managing the Trust’s data migration supplier including planning data migration work, defining migration rules, developing validation processes and developing workarounds. Nautilus was responsible for highlighting and tracking data quality issues by managing a team of six Trust data quality resources (4 x Band 2 and 2 x Band 3 Bank staff).

download the full case study

“I can recall a few disastrous IT projects over the years….very pleased to report last weekend’s merger of our 2 hospital systems is NOT this category! 1 million patient records safely brought together & a new cancer system. On time, on budget, working fine. Great work team LGT”

Ben Travis, CEO, Lewisham & Greenwich NHS Trust (source Twitter)