AI Use Cases
synvert Accel­er­at­ors
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
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.