Sam Hardy | Monday, March 16th, 2020
HEE/NHS had a history of poor data synchronisation between TIS/ESR leading to multiple manual workarounds.
Our team was tasked with modelling the HEE/NHS data sets and finding/resolving issues:
-Modelled NHS data received from ESR using Neo4J; using used small datasets to refine the model.
-Modelled the permissions, users and resources from an easily accessible file in AWS to probe for security vulnerabilities
-Modelled schema and table data to highlight inconsistencies of definitions.
-Successfully predicted data issues from NHS ESR system, which were proved in pilot.
-Proved security of current AWS permission model; iteratively resolving issues.