1 / 29

BID 213: Customer Case Study - Allianz Australia Accelerates Business Intelligence

BID 213: Customer Case Study - Allianz Australia Accelerates Business Intelligence. Nick Ward Principal Systems Consultant nickw@sybase.com August 15-19, 2004. Agenda. Requirements Architecture Technology overview Reasons for success. The Enterprise. Unwired. The Enterprise. Unwired.

anisa
Download Presentation

BID 213: Customer Case Study - Allianz Australia Accelerates Business Intelligence

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. BID 213: Customer Case Study - Allianz Australia Accelerates Business Intelligence Nick Ward Principal Systems Consultant nickw@sybase.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 Manage Information Unwire Information Unwire People • 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! Source Design Decide Core Insurance System Integrate Organise Analyse

  11. Allianz analytic architectureAccelerating organisation and design! Source Design Decide Core Insurance System Integrate Organise Analyse

  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. 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 ETL Integration Sybase IWS Allianz project based on this approach!

  14. Current and future phases: • Claims Analysis • Underwriting & Policy Analysis • Agent KPIs • Payments • Customer Loyalty • Sales Analysis • Marketing Campaign Analysis • Customer Care • Product Profitability • Customer Profitability • Channel Profitability • Reinsurance • Financials • HR Analysis • Customer Profiling • Customer Complaints 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. Proof of concept 2 week timeframe Determine business fit End to end system 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

  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 started here Typical development starts here • Understand Business • Gather Data Requirements • Design Data Schema • Source to Target Mappings • Build Initial Queries for Analysis • Implement • Test Resources • Gap Analysis • Refine • User Feedback • Test ??? weeks 8 weeks Time Allianz phase 1 paybackAccelerating implementation with less risk!

  18. Business Process Modelling Repository Business Analysis Analysis And Design Development / Generation UML Application Modelling Entity / Relationship Database Design RDBMS Structures Object Relational Mapping Java, .NET, XML, PB, IDE / App Server Integration PowerDesigner accelerates designIntegrating the entire development process!

  19. Java, PowerBuilder NVO, XML, WSDL Business Process Model (BPM) Object-Oriented Model (OOM) ebXML Corba, C++, C#, VB.Net, etc (Generic Generator) Conceptual Data Model (CDM) Forward Engineering Reverse Engineering Physical Data Model (PDM) Roundtrip Engineering Import/Export ODBC Sybase IQ Database SQL Script 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 that’s what we gave them. It worked.” Peter Rowe, Infrastructure Services Manager, Allianz Australia

  21. Sybase IQ accelerates organisationAccelerate, economise!! • Performance: minimises impact on ETL timeframe • Data Compression: save money, save time, 10 x less storage

  22. Sybase IQ accelerates organisationAccelerate, economise, don’t compromise!!! • Performance: minimises impact on ETL timeframe • Data Compression: save money, save time • Manageability: no query tuning = The entire engine is already indexed.

  23. Traditional row oriented databases vs Column oriented Sybase IQ How does Sybase IQ achieve this?Unique patended technology!

  24. Sybase IQ is well provenSun Microsystems says it’s the best! Sun Microsystems Data Warehouse Reference Architecture

  25. Sybase IQ wins 22 out of 80 awards in decision support systems categories Sybase IQ is well provenIndustry also says it’s the best! More wins than Teradata, DB2, Oracle & Microsoft

  26. Sybase IQ at AllianzA must for all ASE customers! “Sybase IQ raised theawareness that a lot of the reportinganalytics presentlyrunning on ASE, could be moved to a SybaseIQ platform, dramatically speeding up those original processes. We’veproven it’svery easy to do this, move data from ASE toIQ, and wesave diskspace as well because the compressionin Sybase IQ isexcellent.” – Scott Wyld, Project Manager, Allianz Australia

  27. Allianz started here Typical development starts here • Understand Business • Gather Data Requirements • Design Data Schema • Source to Target Mappings • Build Initial Queries for Analysis • Implement • Test Resources • Gap Analysis • Refine • User Feedback • Test ??? weeks 8 weeks Time 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@sybase.com August 15-19, 2004

More Related