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.