Building a powerful data warehouse
"Imagine
if you could achieve efficient Customer Relationship Management.
This is possible with a powerful Data Warehouse from Kognitio
." |
|
The merger of two major organisations with diverse management
information systems created the need to bring information
into a single customer-centric system.
Lloyds TSB Insurance has built a new customer-centric management
information system with the help of Kognitio.
Created in 1994, through the merger of Lloyds Bank and the
Trustee Savings Bank(TSB), Lloyds TSB is one of the leading
UK-based financial services groups, with over 15 million customers
and more than 76,000 employees.
Lloyds TSB Insurance, formed from the general insurance divisions
of both banks, is one of the group's core businesses. As a
result of the merger, the organisation inherited ten or so
legacy information systems, put in place by both banks over
the preceding decade or so.
It became clear that a new management information system
was required, to aid Lloyds TSB's move towards a customer
relationship business approach. In addition, a new system
would revolutionise access to information and reduce management
information costs.
The initial priority was to create a central data warehouse
to hold customer-centric data from the separate legacy systems.
Supported by a series of departmental data marts, this would
provide managers across Lloyds TSB Insurance with a single
consistent 'version of the truth'. It was also decided to
gradually replace the systems themselves with a single integrated
solution.
To assist with this major project, the in-house IT team searched
for suitable business partners. Following a competitive tendering
process, Kognitio was selected to provide consultancy for
an initial two-year period, on the basis of its data warehousing
and data migration track record in the financial services
sector.
The first step involved the design and implementation of
a data model, (Customer and Management Information System),
that would meet the current and future needs of the business.
The next phase focused on Lloyds TSB Insurance's Loan Protection
product. Loan Protection data such as client and policy details
has been migrated to the data warehouse, while refund details
are held in a data mart. A range of sales performance analysis
reports, against a choice of variables, are also now available.
Subsequent phases will bring data from the other legacy systems
and from external data sources into the warehouse, provide
further reporting, and replace the legacy systems.
When complete, the new system will provide comprehensive
reporting and analysis, via the desktop, throughout the entire
general insurance business. Reports will range from sales
performance analysis through to customer lifetime value information,
to support efficient customer relationship management, and
increase the opportunities to win and retain satisfied customers.
back
to case study home
back
to top
