Title: Arial 28pt.

1
BID 213 Customer Case Study - Allianz Australia
Accelerates Business Intelligence
Nick Ward Principal Systems Consultant nickw_at_sybas
e.com August 15-19, 2004
2
Agenda

• Requirements
• Architecture
• Technology overview
• Reasons for success

3
The Enterprise. Unwired.
4
The Enterprise. Unwired.
Industry and Cross Platform Solutions
Unwire People
Unwire Information
Manage Information

• Adaptive Server Enterprise
• Adaptive Server Anywhere
• Sybase IQ
• Dynamic Archive
• Dynamic ODS
• Replication Server
• OpenSwitch
• Mirror Activator
• PowerDesigner
• Connectivity Options
• EAServer
• Industry Warehouse Studio

• Unwired Accelerator
• Unwired Orchestrator
• Unwired Toolkit
• Enterprise Portal
• Real Time Data Services

• SQL Anywhere Studio
• M-Business Anywhere
• Pylon Family (Mobile Email)
• Mobile Sales
• XcelleNet Frontline Solutions
• PocketBuilder
• PowerBuilder Family
• AvantGo

Sybase Workspace
5
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

6
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

7
Allianz requirementsFocus on the outcome!

• State Government CTP
• 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

8
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

9
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

10
Allianz analytic architectureAccelerating from
beginning to end!
Decide
Source
Design
Core Insurance System
Organise
Analyse
Integrate
11
Allianz analytic architectureAccelerating
organisation and design!
Decide
Source
Design
Core Insurance System
Organise
Analyse
Integrate
12
Allianz detailed architectureSybase
Informatica Cognos success!
Sun Solaris
Jade
Extract
INFA Repository
Staging
Informatica
PowerPlay Cube
Sybase ASE
Transformer
Windows
IWS
Report Server
PowerPlay Server
Sybase IQ
IP Network
13
Sybase IWS Allianz project based on this
approach!
14
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.

15
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

16
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

17
Allianz phase 1 paybackAccelerating
implementation with less risk!
18
PowerDesigner accelerates designIntegrating the
entire development process!
19
PowerDesigner accelerates designIntegrating the
entire development process!
20
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
21
Sybase IQ accelerates organisation Accelerate,
economise!!

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

22
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.
23
How does Sybase IQ achieve this?Unique patended
technology!

• Traditional row oriented databases
• vs
• Column oriented Sybase IQ

24
Sybase IQ is well proven Sun Microsystems says
its the best!

• Sun Microsystems
• Data Warehouse Reference Architecture

25
Sybase IQ is well proven Industry also says its
the best!

• Sybase IQ wins 22 out of 80 awards in
• decision support systems categories

More wins than Teradata, DB2, Oracle Microsoft
26
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

27
Why did Allianz choose Sybase?To accelerate the
project!

• Proven prior project success with Sybase
• Proof of concept proved business fit of over 80
• Proof of concept developed vision for analytics
  platform

Peter Rowe Infrastructure Services
Manager Allianz Australia
28
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

29
THANK YOU!
Nick Ward Principal Systems Consultant nickw_at_sybas
e.com August 15-19, 2004