1 / 10

AVIVA : Data Management and Optim

AVIVA : Data Management and Optim. 17 th September 2009. Optim at Aviva. Introduction. Andrew Crouch Team Leader and lead analyst/developer on the project which evaluated, selected and then designed, built and implemented the archiving solution

lana
Download Presentation

AVIVA : Data Management and Optim

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. AVIVA : Data Management and Optim 17th September 2009

  2. Optim at Aviva Introduction • Andrew Crouch • Team Leader and lead analyst/developer on the project which evaluated, • selected and then designed, built and implemented the archiving solution • using the IBM Optim tool at Aviva (formally Norwich Union).

  3. Optim at Aviva What issues were the Business facing? • The non direct Claims and Workflow systems had been running on the • current platform for 7 years, Policy systems for 2 years. The package had • no archiving function. • Data is being migrated/converted from old decommissioned systems. • Capacity Planning were worried about the rate of data growth and • associated costs and feel urgent action is required. • Outage costs dramatically increasing. • Feb 2000: NU – CGU Merger is announced. • Data Protection Act Compliance. • System Performance, Resilience, Recovery and Availability.

  4. Optim at Aviva The approach taken to resolving the problems. • Identified the need for a data archiving solution. • Project started to select and implement an archiving solution. • Group wide DPA compliance project started. • Good service every day project started to look at Performance, • Resilience, Recovery and system availability times.

  5. Optim at Aviva What issues and challenges did the project face? • Build vs Buy. • Complicated requirements and rules. • Tracking down all the data users. • Getting sign offs from over 50 interested parties. • We had the ERD’s available which made the Optim build simple.

  6. Optim at Aviva The Data to be archived and its inter-relationships. Workflow Policy Archiving a logical set of data. Claim Client

  7. Optim at Aviva The Solution design and where Optim fits. Optim Archive Files Archive Index Refresh New Archive Index System user Front end DB2 Tables

  8. Optim at Aviva Breakdown of The Archiving project tasks.

  9. Optim at Aviva Summary. With the continuing migration of data onto our strategic platforms either through the decommissioning of old systems or from mergers and acquisitions, managing archiving is an ongoing iterative process. • Stats. • At peak running we are removing 2 million database rows a day. • Total number of database rows archived: 525 million • Claims 206 million 19% of total Claims archived • Policy 46 million 8% of total Policies archived • Client 25 million 7% of total Clients archived • Workflow 244 million

  10. Optim at Aviva A selection of typical Questions and Answers. Q: Can data be restored? A: Yes, either selected data or a whole file can be restored. Q: Do you have to delete data? A: No, data can be archived without being deleted and in one case that was a necessary part of one of our solutions. Q: What financial benefits have you seen? A: Difficult to quantify because of the amount of changes that were implemented at the same time but 100’s of 1000’s of £ saved in reducing system recovery times. How much is brand image worth? Q: Are there performance benefits? A: Yes, where archiving is not implemented we have performance issues.

More Related