Accelerating Business Intelligence

1
Accelerating Business Intelligence Allianz
Australia
Nick Ward Principal Systems Consultant nickw_at_sybas
e.com August 5th, 2004
2
Allianz overviewHuge global insurance company!

• Largest insurance company in Europe
• Property, casualty, life and health insurance
• Operate in 70 different countries
• Customer base of 60 million
• Allianz Australia
• Winning major new business
• Government CTP reporting

3
Accelerating business intelligenceAllianz chose
Sybase to accelerate the project!

• Fast implementation
• 8 week implementation cycle for phase 1
• Fast performance
• Database performance becomes negligible
• Low risk
• Starting with the finished product

4
Allianz requirementsFocus on the outcome!

• Outsourced government insurance
• Monthly, quarterly regulatory reporting
• Primarily claims based
• Workcover
• Claims and payments analysis
• Short time to deliver
• 30 years of history required
• Object oriented source system
• Optimised for transaction processing, not
  reporting

5
Project outcomeThe results speak for themselves!

• On time
• Complied with government contract-mandated
  deadlines
• New initiatives previously considered too time
  consuming
• On budget
• Further phases being implemented
• New initiatives previously considered too costly
• Better communication
• Improved communication between IT and the business

6
Project outcomeThe results speak for themselves!

• From October to December we achieved the
  complete implementation of our data warehouse
  infrastructure, complete with scalability to
  support our future needs. This was probably one
  of the fastest data warehouse implementations in
  history.
• Scott Wyld, Project Manager, Allianz Australia

7
Allianz analytic architectureAccelerating from
beginning to end!
Decide
Source
Design
Core Insurance System
Organise
Analyse
Integrate
8
Allianz analytic architectureAccelerating
organisation and design!
Decide
Source
Design
Core Insurance System
Organise
Analyse
Integrate
9
Sybase IWS Allianz project based on this
approach!
IWS Methodology
BUSINESS STRATEGY CRM Healthcare Media
Telco Banking Insurance Utilities Retail
APPLICATION Cognos Integration Allianz
Defined Reports
INFORMATION ARCHITECTURE Key Measures and Events
Physical Database Schema
TECHNOLOGY Metadata Management Schema Design
10
Allianz delivery scheduleSybase IWS supports
Allianz key objectives!

• Claim Cost Control Legislation Changes
• Table showing the Number of Claimants and the
  Estimated Saving due to Legislation Controls for
  the various legislation categories for claims
  where the date of loss occurred after October
  1998
• Maximise Customer Benefits
• Table showing the Percentage breakdown for each
  Head of Damage of the Total Payment Amount for
  the YTD, PYTD along with the Total Gross Payments
  
• Reopened Claims
• Graph showing the Number of Claims that were
  Finalised in any particular month of the last 12
  months that were subsequently Reopened in the
  following month.
• Elapsed Time to Open Files
• Bar Graph showing the Elapsed Time (in Days)
  from the Date of Loss to the Opened Date of the
  Claim and the Rolling average calculated each
  month based on the total Elapsed Time for
  previous 12 months.
• File Closure Rate
• Table showing Claim Closure Rate and the Claim
  Closure Target for the current financial year and
  the previous three (3) financial years. Also, a
  graph showing Claim Closure Rates for each
  quarter within the financial years starting from
  94/95 up to the current financial year.

11
The blueprintSybase IWS matches Allianz business!
The proof-of-concept proved that Sybase IWS was
really going to help us shorten our timeframe
Karen Scroope, Services Manager Host Systems,
Allianz Australia

• Proof of concept
• 2 week timeframe
• Determine business fit
• End to end system

12
Better communicationIts good to talk!

• Sybase IWS facilitated communication between IT
  and the business, giving our business users a far
  better understanding of what we were doing, which
  was a huge help and was
• key to the success of the project.
• Scott Wyld, Project Manager, Allianz Australia

13
Allianz phase 1 paybackAccelerating
implementation with less risk!
14
Sybase IQ accelerates organisationAccelerate!

• Performance minimises impact on ETL timeframe

Sybase said IQ runs on the smell of an oily rag
so thats what we gave them. It worked. Peter
Rowe, Infrastructure Services Manager, Allianz
Australia
15
Sybase IQ accelerates organisation Accelerate,
economise!!

• Performance minimises impact on ETL timeframe
• Data Compression save money, save time, 10 x
  less storage

16
Sybase IQ accelerates organisation Accelerate,
economise, dont compromise!!!

• Performance minimises impact on ETL timeframe
• Data Compression save money, save time
• Manageability no query tuning

The entire engine is already indexed.
17
Sybase IQ at Allianz A must for all ASE
customers!

• Sybase IQ raised the awareness that a lot of the
  reporting analytics
• presently running on ASE, could be moved to a
  Sybase IQ platform,
• dramatically speeding up those original
  processes. Weve proven its very easy to do
  this, move data from ASE to IQ, and we save disk
  space as well because the compression in Sybase
  IQ is excellent.
• Scott Wyld, Project Manager, Allianz Australia

18
SummaryAllianz chose Sybase to accelerate the
project!

• Fast implementation
• 8 week implementation cycle for phase 1
• Fast performance
• Database performance becomes negligible
• Low risk
• Starting with the finished product

19
Thank you
Nick Ward Principal Systems Consultant nickw_at_sybas
e.com August 5th, 2004