Share this content

Case study: Prudential creates a single view of the customer using Trillium Software

1st Jun 2005
Share this content

Prudential used the Trillium Software System® to create a single view of customer data residing in 4 different systems. Now it uses the system daily to refresh this single view, standardising, correcting, and matching new and updated records fed from the existing customer databases. The results have included improved customer satisfaction, increased call centre effectiveness, and improved compliance.

Project Type:
Data Integration
Single Customer Views

Financial Services

Software AG ADABAS
Unisys DMS II
Oracle 9i

Fragmented customer data
Diverse source systems
15.5 million legacy records
Variable quality and formats

Customer Service

One of the top life and pensions providers in the United Kingdom, Prudential UK has over eight million customers and is the leading provider of individual annuities. The company was recently voted Best Pension Provider by the readers of What Investment magazine. Its extensive customer service operation has call centres locally in Reading, Stirling, and Belfast as well as in Mumbai, India. Some 1000 agents handle 3.5 million calls per year.

One of Prudential’s major customer service goals has been to satisfy the needs of individual customers during their initial call whenever possible. The company calls this its “first contact resolution rate."

“We wanted to improve our first contact resolution rates to improve the experience of our customers and also the effectiveness of our call centres,” explained Jackie Lindsay, Head of Voice, Customer Services at Prudential.

Fragmented customer data

As a result of mergers, acquisitions, business consolidations, and a product-centric sales history, Prudential UK found itself with 26 policy management systems. Agents were having problems servicing customers effectively. Because there was no uniform means of access to policy information, agents were often forced to keep their customers on hold while they switched between systems searching for the right policies. In addition, customers with more than one policy had sometimes to make separate calls to different units.

Single views needed
To remedy this situation, it was proposed that call centres should have a single view for each customer. A single view would give agents quick access to information on multiple policies held by one customer. Agents would also be able to drill down into individual policy details. In addition, general customer information, like address or contact data, for a customer with multiple policies would only need to be entered once to update all policies.

Long-Term CRM Goals

Prudential’s board also recognised that single customer views would support its long-range plans to establish Customer Relationship Management (CRM) practices and to shift the focus of sales and marketing from products to customers. The company determined that the single view of the customer should support sales and marketing initiatives across the enterprise, not just the servicing call centres. It charged the IT services division, PruTech, with designing and delivering the central customer repository.

Automated solution needed

It was a complex problem. Simply migrating millions of records from multiple sources was not the answer. The company knew it needed a way to fully analyse millions of records and confidently match them to individual customers. The source systems had differing data formats, which required standardisation before matching could occur. What’s more, there were significant data quality issues, such as postal address errors, variations in the spelling of names, missing data, and other inconsistencies and anomalies. Clearly the solution would have to be an automated one.

Enterprise-wide Solution

Following an extensive selection process, Prudential selected the Trillium Software System as its enterprise data quality solution and Informatica’s Extract, Transformation and Load (ETL) tool to migrate appropriate elements of the matched records to the single-view customer database.

"We considered the Trillium Software System mainly because the analyst firms Gartner Group and Forrester rated it positively as an enterprise-scale solution. We selected the Trillium Software System because it offers excellent functionality and scored highest when formally evaluated against a number of its competitors. It was also recommended by our data integration partners, Wipro Technologies, which had had positive experiences working with Trillium Software in large-scale data integration projects," explained Ally Thomson, Lead Application Architect at PruTech, Prudential’s IT Services Division.

Initial migration with ETL tool

The Trillium Software System processed records in parallel with Informatica during the data migration, thereby reducing the overall time and cost required for the project. The data quality system standardised the diverse data formats. To ensure accurate name and address data, it also corrected and enriched the information based on built-in country-specific business rules and the Royal Mail Postcode Address File (PAF). The system then matched records based on Prudential’s own criteria, which included forename, surname, postcode, national insurance number, date of birth, and gender.

The Trillium Software System initially processed some 15.5 million policy records and 13 million customer records from four key source systems that held policies for pensions, insurances, and bonds. (It subsequently processed records from further systems as well). It then compiled 8.8 million unique customer records as single views for loading into the Oracle-based single view database.

Prudential found that learning to use the Trillium Software System was fairly easy: “We needed just a few days of product training from Trillium Software. Although the solution is powerful and sophisticated, it is very intuitive and easy for any information professional to master,” said Jan Bastable, Support Team Leader for the single customer view.

Nonstop data quality

The role of the Trillium Software System did not end when the customer database went live. Every day the call centres handle some 16,000 new and updated customer records. Agents need only make changes once, in the single view, to update customer information across multiple policies. They also need only enter partial new customer address data, for the Trillium Software System to complete and enrich fields in real time. This is making life much easier for both agents and their customers.

“Customer’s now have one contact number and our processes are more efficient and consistent across all products and transactions. Mis-directed calls and call transfers are significantly reduced, and customer satisfaction has improved. The Trillium Software System is a contributory element within the broad project that has delivered this success”, said Lindsay.

Each night, about 25 megabytes of customer information from the day’s new and updated files is extracted from the company’s legacy source systems. In about 15 minutes, the Trillium Software System processes the information in batch in Prudential’s parallel processing environment and then matches it to records in the single-view database and updates them.

“The Trillium Software System is sophisticated yet extremely robust,” said Bastable. “On the few occasions we’ve sought support, Trillium Software has been excellent. The online service team responds with detailed guidance within one business day.”

Compliance, a welcome plus

The Trillium Software System has also contributed to compliance with the UK Financial Services Act 1986: The company can now more accurately and rapidly match customer records against lists of banned individuals such as known terrorists, money launderers, and other criminals.

Towards Total Data Quality

Prudential is looking ahead to expanding its data quality initiatives. Under consideration by the company’s board over the next few years are further investments in CRM, customer profiling, marketing analytics, and other decision-support systems. All can leverage the investment in the Trillium Software System in an enterprise approach to customer data quality and single customer views. The company knows it can confidently build on the foundation of business rules and connections established during its first data quality project to expand the amount of high-quality customer-centric data that their systems and users can access.


About Trillium Software

Trillium Software®, a division of Harte-Hanks, provides businesses with Total Data Quality solutions -- the full complement of technologies and services to profile, cleanse, enhance, and link global data for e-business, customer relationship management, enterprise resource planning, supply chain management, data warehouse, and other enterprise applications. Use of the Trillium Software System® by many of the world's largest and most successful companies has made Trillium Software the leader in its marketplace. For more information about Trillium Software and its offerings visit


Replies (0)

Please login or register to join the discussion.

There are currently no replies, be the first to post a reply.