AI Use Cases
synvert Accel­er­at­ors
Suc­cess stories

Suva  - Source data migra­tion with auto­ma­tion of the source data connection

Go back to success stories

Brief his­tory

As an inde­pend­ent com­pany under pub­lic law, Suva is the most import­ant pro­vider of com­puls­ory acci­dent insur­ance in Switzer­land. It insures around 2 mil­lion employ­ees against occu­pa­tional acci­dents, occu­pa­tional ill­nesses and non-occu­pa­tional accidents.

For over a dec­ade, Suva has been expand­ing its data ware­house, which serves as a cent­ral hub for both internal and external inform­a­tion needs.

“Thanks to their excel­lent know-how and good social skills, the pro­ject goals can be achieved at all times.”

Reto Christen
Bereichsleiter VTI (Com­pet­ence Cen­ter Data Warehouse)
Suva
Reto Christen

“For more than ten years, synvert has been a com­pet­ent part­ner that has sup­por­ted us in all areas of BI devel­op­ment. From busi­ness ana­lysis and the devel­op­ment of com­plex ETL routes to report­ing, syn­ver­t’s con­sult­ants take on all the work. Thanks to their excel­lent know-how and good social skills, the pro­ject goals can be achieved at all times. The col­lab­or­a­tion is so easy that we can con­cen­trate on the work at all times. The col­lab­or­a­tion is a real success!”

Goals & challenges

After more than 20 years, a new claims and premium sys­tem had to be intro­duced. This changeover from the self-developed, Cobol-based insur­ance sys­tem to an industry solu­tion exten­ded for Suva (AdCubum Syr­ius) fun­da­ment­ally changed the data found­a­tion for the DWH. The DWH had to be adap­ted to the new require­ments with the fol­low­ing objectives:

  • Migra­tion of all data due to the replace­ment of the old sys­tem with a new, oper­a­tional system
  • Trans­fer of the entire database
  • Auto­ma­tion of the source data connection
  • Max­imum pos­sible fur­ther use of the exist­ing core DWH layer
  • Con­sist­ent data quality

Key points

As not all leg­acy data was trans­ferred to the new source sys­tem, a sep­ar­ate archiv­ing solu­tion was imple­men­ted as part of the data ware­house (DWH). This archive now func­tions as an addi­tional data source and enables a com­plete view of Suva’s entire data his­tory since 1918. A cent­ral com­pon­ent of the pro­ject was the use of a new BI tech­no­logy (OBIEE) to improve the ana­lysis and report­ing func­tion­al­it­ies. In addi­tion, the load­ing cycle was changed from a monthly to a daily load in order to provide the oper­a­tional reports in par­tic­u­lar with up-to-date data on a daily basis. This led to an optim­isa­tion of load­ing times and an increased need for auto­ma­tion. The imple­ment­a­tion was under great time pres­sure, as the DWH had to be adap­ted to the new source data struc­tures at the same time as the new oper­a­tional sys­tem was intro­duced. Timely com­ple­tion was there­fore essen­tial to ensure a smooth trans­ition and con­tinu­ous data availability.

Archi­tec­ture

In order to cope with the rap­idly increas­ing num­ber of source objects, a gen­eric approach is used to pro­cess muta­tions from the source sys­tem. New tables can now be registered using entries in metadata tables. A PL/SQL frame­work (GenDel) provides the deltas of the data to be pro­cessed using data­base views. Inform­at­ica Power­Cen­ter is still used for the ETL pro­cesses. The con­sol­id­ated anchor mod­el­ing of the core DWH intro­duced by synvert in pre­vi­ous pro­jects provides the ideal basis for reusing exist­ing struc­tures and also ensures the flex­ib­il­ity of extensibility.

An addi­tional BI tool, ORACLE Busi­ness Intel­li­gence Enter­prise Edi­tion (OBIEE), has been added to the exist­ing SAS infra­struc­ture. With ORACLE as the stra­tegic data­base, the strengths in the area of Online Ana­lyt­ical Pro­cessing (OLAP) can be util­ized. OBIEE is also used as a front end for oper­a­tional reporting.

Ser­vices accom­plished by synvert 

  • GenDel imple­ment­a­tion for auto­mat­ing source con­nec­tion: instead of indi­vidual ETL pro­cesses, new source tables can now be con­nec­ted much more effi­ciently and easily
  • Ana­lysis and detailed design of entire data areas in the DWH (e.g. costs, premi­ums and payroll totals)
  • Exe­cu­tion of the entire pro­ject cycle for oper­a­tional report­ing: from require­ments ana­lysis and design to imple­ment­a­tion and test­ing of the sys­tem and reports

Deliv­ery / conclusion

The con­ver­sion of the DWH was imple­men­ted on sched­ule. Thanks to the neut­ral core DWH mod­el­ing, which was already based on tech­nical logic in earlier pro­ject phases, a large part of the exist­ing data model could con­tinue to be used – des­pite the com­plete con­ver­sion to a new source sys­tem – and the import­ance of the DWH within Suva was fur­ther strengthened. By using GenDel, Suva meets the grow­ing demand for auto­ma­tion of ETL pro­cesses and has a flex­ible and freely con­fig­ur­able inter­face for the simple con­nec­tion of addi­tional source data.

Categories
All
Banking
Communications, Media & Telecom
Consumer Goods & Retail
Energy & Resources
Health & Life Science
Industrials
Insurance
Public Sector
Indus­tri­als

Vehicle Data Store
Indus­tri­als

Soft­ware­Fact­ory at a lead­ing auto­mot­ive soft­ware company
Con­sumer Goods & Retail

DevX Impact at a HR-Tech Company
Con­sumer Goods & Retail

Driv­ing Inter­na­tional Expan­sion for a Lead­ing Online Car Seller
Indus­tri­als

Accel­er­at­ing Cloud-Nat­ive Devel­op­ment for a Car Manufacturer
Com­mu­nic­a­tions, Media & Telecom

Retail Com­mis­sion Dia­gnostics Anom­aly Detection
Energy & Resources

Set­ting up a Reli­able and Power­ful Platform
Com­mu­nic­a­tions, Media & Telecom

Pre­dic­tion of cus­tomer prob­ab­il­ity to churn
Indus­tri­als

Early Detec­tion of Mech­an­ical Issues
Indus­tri­als

NLP​ in Auto­mot­ive Reporting
Com­mu­nic­a­tions, Media & Telecom

Oper­a­tional Data Lake
Con­sumer Goods & Retail

Real-Time Mar­ket­ing
Indus­tri­als

Auto­matic clas­si­fic­a­tion of cars by their model
Pub­lic Sector

Dies­el­tech Program
Com­mu­nic­a­tions, Media & Telecom

Data Recon­cili­ation
Indus­tri­als

Cent­ral­ized Data Warehouse
Indus­tri­als

Data as a Ser­vice – BI & Big Data CC
Com­mu­nic­a­tions, Media & Telecom

Oper­a­tional Work/Support in Data Warehousing
Indus­tri­als

Erosion Detec­tion with Com­puter Vision
Com­mu­nic­a­tions, Media & Telecom

Devel­op­ment and Imple­ment­a­tion of a Fully Auto­mated MLOps Platform
Con­sumer Goods & Retail

Pre­dic­tion and Alloc­a­tion Optim­iz­a­tion for sta­tion­ary Channels
Com­mu­nic­a­tions, Media & Telecom

Build­ing a Near Real-Time Recom­mend­a­tion System
Con­sumer Goods & Retail

Migra­tion AWS data plat­form to Google Cloud
Com­mu­nic­a­tions, Media & Telecom

Design and Devel­op­ment of a Google Cloud-Based Data Platform
Con­sumer Goods & Retail

Refact­or­ing, shift and new devel­op­ment of Data Ser­vices in Google Cloud

Estab­lish­ment of a Mas­ter Data Man­age­ment Foundation
Indus­tri­als

Cent­ral Data Lake

Replace­ment of a com­plex IBM Data­stage structure

CRM ana­lyt­ics and lead management

Stand­ard­iz­a­tion of eval­u­ation processes

Devel­op­ment of an ERP data hub

Estab­lish­ment and fur­ther devel­op­ment of a DWH

Devel­op­ment of a group-wide BI platform

Estab­lish­ment of a new sales report­ing system

Source data migra­tion with auto­ma­tion of the source data connection

Cloud self-ser­vice BI for data-driven cor­por­ate management

Devel­op­ment of vari­ous ML use cases with AWS

Replace­ment of an in-house soft­ware development

Com­pany-wide data integration

Imple­ment­a­tion of real-time data links
Con­sumer Goods & Retail

Smart Data Catalog

Contact us

* Required fields
top

Thank you!

You will shortly receive an email to activ­ate your account.

Log in

Browse webinar videos and white­pa­pers from synvert any­time you want

Reset pass­word

For­got your pass­word? Enter your email address and you will receive a link to reset your password.

Log in

You are suc­cess­fully logged in.

Register

Thank you!

You will shortly receive an email to activ­ate your account.

Log out

You are suc­cess­fully logged out.