In line with industry recommendation and best practice, Kainos commissioned Datactics to perform a data quality audit, to pinpoint and address any data quality issues.
Datactics, specialist in data quality solutions, profiled, cleansed, consolidated and conducted data mining on client data supplied by Ark Life Assurance to assess the level of data quality and the effects of transformation and movement of their data. Datactics’ experienced data analysts utilized its technology to profile the data sources in order to understand their content, structures, quality and integrity. The outcome was the detection of the following hidden data quality issues:
- Missing Unique Record Number (URN)
- Unstructured data (Second name of joint account inserted in 1st line of address field)
- Duplication of client records
- Sales meeting notes associated with incorrect client account
- Duplication and inconsistency between policy relationships in both systems.
Once the poor data quality was identified, Datactics cleansed, validated, matched and consolidated over 1.3 million records. To make the data fit for business, Datactics validated the client name, policies links, prospect customers, policy names and gender.
The data quality audit discovered that 300,000 records detailing sales visits had been divorced from their accounts. As part of the data mining exercise, Datactics extracted names and contact details from unstructured free text to identify associated accounts. This proved to be a valuable exercise with 210,000 records being reconciled, maintaining sales leads.
Moreover to comply with the Life Assurance (Ireland) Act 1866, Datactics validated all assurance policies to ensure they were set up by the ’Life Assured’ not by any other person.
As part of the data quality audit, Datactics provided detailed reports highlighting errors, inconsistencies and non-compliant data. Equipped with this vital information, Kainos was empowered to create reliable and timely client data for Ark Life Assurance’s customer-facing and internal operations functions such as sales, service, marketing, business intelligence and compliance.