Proof of Concept Phase

Cloud Technology Solutions provided technical assistance to determine that the aim of the project can be done technically. This was split into a few areas relating to the process of taking the data from a pensions provider ‘on-premises’ to stored in an appropriate database in the Google Cloud Platform (GCP) and the visualisations built from that. The project covered:

● File ‘Hashing’ Mechanism

○ Take data and obfuscate any personally identifiable information (PII) data.

● File Ingestion

○ Ingest data from on-premise systems to GCP.

● Blending of data

○ Ensure that the same data from different sources blends together for aggregation - for example, a customer with the same National Insurance number can be matched against, even with it having been ‘hashed’ and from different pension providers.

● Storage of data

○ Storage in an appropriate database solution for analytics, such as BigQuery.

● Display of data

○ Aggregation of data appropriately in a visualisation tool on different metrics, such as by postcode and age.

Cloud Technology Solutions provided technical assistance to determine that the aim of Project CLAIRE can be done technically.

For information on the Proof of Concept Data Security, click here.