Swinton
(Part of MMA Group)
"We
were impressed with Kognitio's immediate grasp of the
issues" |
|
As part of a major transformation programme,
Swinton, the private motor and home insurance intermediary,
embarked on a CRM initiative that required transferring their
customer call centre from Stockport to Manchester. This included
a move from their old technology administration system to
a new client / server based application. Swinton had carried
out some migrations in the past and understood the difficulties
a migration could present. In addition Swinton had set themselves
an aggressive timetable to complete all the migration activity
and recognised that they would need the assistance of an external
insurance migration specialist. They decided to call in Kognitio.
"We wanted to find a company
we were confident could deliver a migration to our tight timescale,
and Kognitio demonstrated they could. "
Adrian Hazeldine - Director, Swinton.
"We needed to work
with a partner who could quickly understand our business and
our data, and who offered an automated process capable of
meeting the target dates. We were impressed with Kognitio's
immediate grasp of the issues. Their track record in completing
migrations and data warehouses for other UK insurers, gave
us a high level of confidence they would deliver what we wanted
in the timescale we needed."
Alan Pearce - Business Change Manager, Swinton.
The Migration
The project to migrate the call centre data ran for six months.
In order to fit to this tight timescale Kognitio used their
Data Factory Tool Kit (DFTK), a well-established methodology,
and their experienced industry-knowledgeable team to construct
a migration engine. The DFTK toolkit was used to create the
migration code. This reduces the amount of bespoke code that
needs to be written for a migration and improves the speed
and quality of the work.
Use of DFTK meant that much of the migration
code could be automatically generated, reducing the development
time and increasing the quality of the code. It also meant
that new versions of data for testing could be turned around
very quickly. Kognitio's disciplined approach to data mapping
meant that Swinton were able to discover a way of migrating
some complex accounting data that in the previous migrations
had proved to be a real problem.
"We established a close working
relationship with the Kognitio business analysts who understood
the issues we had."
Alan Pearce
The Data
The migration transferred data for Swinton's customers, policies,
accounts and free format history information. One of the real
challenges was the fact that the new system was still under
development at the same time that the data mapping exercise
was taking place. It was necessary to accommodate the application
and database changes in parallel with the migration.
"We were impressed
at how quickly problems were solved and testing turned around."
Kelly Ogley, Project Manager, Swinton
Successful Delivery
The call centre migration transferred 3,000,000 records over
two weekends. Swinton were concerned that there should be
no impact on customer service as a result of the data migration.
This was achieved by migrating the data on a Sunday when the
call centre was not open. Successful migration of 100% of
the data in this 36 hour window took place on both occasions.
The operations staff were delighted with the quality of the
migrated data. A resounding success for all involved!
back
to case study home
back
to top
