Problem: HEE required a bidirectional integration with NHS-specific datasets.
Our team:
-Analysed and documented the NHS (Electronic Staff Register) and HEE (Trainee Information System) datasets.
-Mapped/developed transformations between NHS and HEE.
-Designed/developed ‘as-is’ and ‘to-be’ data flows.
-Created/updated schemas to standardise data inputs; identifying master data across both datasets (facilitating ‘store once/replicate’ policy for NHS/HEE interaction).
-Added validation; enforcing data structures, protecting NHS and HEE systems from each other; reducing data misalignment.
-Iteratively developed interface in collaboration with NHS/HEE SMEs; adding message/data types in stages.
Outcome: Bidirectional interface integrating NHS and HEE datasets Alpha phase completed; Beta in progress.