AI Use Cases
synvert Accel­er­at­ors
View of modern business skyscrapers glass and sky view landscape of commercial building in central city View of modern business skyscrapers glass and sky view landscape of commercial building in central city

Com­pany-wide data integration

All Suc­cess Stories
View of modern business skyscrapers glass and sky view landscape of commercial building in central city
Suc­cess stories

Hel­ve­tia  - Com­pany-wide data integration

Go back to success stories

Brief his­tory

Hel­ve­tia is cur­rently in a strong third place among multi-line insurers in Switzer­land. It mainly offers life and non-life insur­ance as well as group life insur­ance. In addi­tion, Hel­ve­tia has spe­cial­ized in niches such as engin­eer­ing, trans­port, art and act­ive rein­sur­ance in the spe­cialty mar­kets seg­ment. Hel­ve­tia oper­ates in Switzer­land, Europe, Asia and North, Cent­ral and South America.

Hel­ve­tia has been oper­at­ing a data ware­house for local ana­lysis require­ments in Switzer­land for more than 10 years. This sys­tem is to be com­pre­hens­ively mod­ern­ized. This includes the cent­ral­iz­a­tion of data integ­ra­tion and the estab­lish­ment of an organ­iz­a­tional unit that sup­plies all peri­pheral sys­tems with data.

“synvert has been an import­ant part­ner in the envir­on­ment of Hel­ve­tia’s data ware­house integ­ra­tion plat­forms for over two years.”

Mar­cel Hein
Team­leiter DPS (Data Pro­vider Services)
Hel­ve­tia
Mar­cel Hein

Vari­ous roles are ful­filled in this con­text, ran­ging from the devel­op­ment of tac­tical con­cepts to the imple­ment­a­tion of entire build­ing blocks. synvert has been involved in for­ward-look­ing pro­jects such as DANTE, DANTE II, and DANECO, and over this time, the col­lab­or­a­tion has evolved from a DWH devel­op­ment part­ner to a con­cep­tual part­ner in the realign­ment of Helvetia’s integ­ra­tion plat­form. synvert takes full respons­ib­il­ity for the plan­ning, design, and real­iz­a­tion of all imple­ment­a­tion activities.

Key points

Due to restruc­tur­ing in IT dur­ing the pro­ject phase, the over­all concept and scope had to be con­stantly adap­ted. At the same time, the agreed dead­lines had to be met:

  • New require­ments from addi­tional pro­jects, such as the IFRS pro­ject, had to be incor­por­ated into the infra­struc­ture and pro­cess land­scape in par­al­lel with the ongo­ing devel­op­ment work.
  • In addi­tion to the con­ver­sion of all source sys­tems that were con­nec­ted to the old CDWH via ETI, sev­eral new source sys­tems were con­nec­ted dur­ing the project.
  • Intro­duc­tion of a new range of tools with IBM InfoSphere (Data­Stage, CDC, Busi­ness Gloss­ary, Qual­ity Stage, Inform­a­tion Analyzer)

Archi­tec­ture

A gen­eric approach with IBM Data­Stage and DWauto­matic is used for integ­ra­tion into the sta­ging area. IBM Data­Stage is used as the ETL tool. Depend­ing on the pos­sib­il­it­ies and bene­fits, gen­eric or par­tially gen­eric pro­cesses are also cre­ated at higher levels. In the long term, all ETL tools (ETI, SAS DI, SSIS) are to be replaced with IBM DataStage:

  • Con­nec­tion of exist­ing source sys­tems to the Global Sta­ging Area with a com­pletely new approach
  • Cre­at­ing a new mind­set within the team towards gen­eric devel­op­ment and processing
  • Intro­duc­tion of a busi­ness gloss­ary as part of the IFRS project

Deliv­ery / conclusion

The planned over­all archi­tec­ture was so suc­cess­ful that Hel­ve­tia set up a sep­ar­ate team that deals exclus­ively with data integ­ra­tion and can oper­ate inde­pend­ently of the DWH team. The con­nec­tion of new source sys­tems is very fast thanks to the gen­eric approach.

Categories
All
Banking
Communications, Media & Telecom
Consumer Goods & Retail
Energy & Resources
Health & Life Science
Industrials
Insurance
Public Sector
Com­mu­nic­a­tions, Media & Telecom

Con­sol­id­at­ing Big Data & BI at a Major Media Powerhouse
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 Fin­ance 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

Data plat­form and cata­log for com­pens­a­tion claims
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.