AI Use Cases
synvert Accel­er­at­ors
Scales of Justice and Hammer on Wooden Surface
Suc­cess stories

Pub­lic Sector  - Dies­el­tech Program

Go back to success stories

About

Pub­lic Sector

A mul­tina­tional law firm enhanced together with synvert its IT infra­struc­ture for track­ing and report­ing of over 400,000 cases by con­sol­id­at­ing data from vari­ous sys­tems into an Azure Data Cata­log and imple­ment­ing auto­mated ETL routines and PowerBi reports.

Ini­tial situation

A mul­tina­tional law firm had been using dif­fer­ent trans­ac­tional sys­tems to track the civil claims of one client.

Since it was a mix of class action and civil claims of over 400.000 cases, the cus­tomer dealt with 1000 law­yers on the plaintiff’s side and an addi­tional 100+ part­ner layer com­pan­ies. Track­ing all this inform­a­tion was done in dif­fer­ent sys­tems. The most import­ant sys­tems were based on a low-code plat­form, and every week new fea­tures and new integ­ra­tions were being rolled out.

The chal­lenge for the cus­tomer was to get an over­view of all data and sys­tems to both cre­ate reports and con­sume data for set­tle­ments and auto­mated pipelines.

Addi­tion­ally, the cus­tomer needed to design and imple­ment a data plat­form to con­sume the data for pipelines, extracts, and reports.

These data plat­forms needed to auto­mat­ic­ally scale on a weekly rhythm when the main trans­ac­tional sys­tem from the low-code plat­form was extended.

Archi­tec­ture

For the data cata­log, the Azure man­aged ser­vice called “Azure Data Cata­log” is used.

For the data plat­form, the tech­no­lo­gies of the cus­tomer main­tain­ing it are used. These include Microsoft SQL Server, SSIS, and PowerBI.

Apache Kafka and Kafka Con­nect are used for real-time integration.

Gen­er­ated bene­fits

The cus­tomer has been able to visu­al­ize bet­ter, ana­lyze the cases, and provide the data to partners.

Addi­tion­ally, these data plat­forms are used as an archive for revi­sion so that the trans­ac­tional sys­tems with licenses can be shut down when the cases are closed, and no costs are related to it.

Archiv­ing the data for revi­sion it goes back about 10 years. The data cata­log speeds up the pro­cess by identi­fy­ing the rel­ev­ant data and the cor­rect con­text for people cre­at­ing reports or request­ing excerpts.

Ser­vices accom­plished by synvert 

For the data cata­log, dif­fer­ent inter­views of tech­nical and func­tional experts have been con­duc­ted, and the inform­a­tion has been con­sol­id­ated and updated in an Azure Data Catalog.

The metadata from the low-code plat­form was taken and trans­formed into a Data Vault 2.0 data model for the data plat­form. synvert imple­men­ted an ETL routine that auto­mat­ic­ally loads the data com­ing from the low-code platform.

synvert also sup­por­ted the cus­tomer by cre­at­ing PowerBi Reports show­ing an over­view of the cases and identi­fy­ing issues, such as when two cases are con­sid­er­ing the same vehicle. Fur­ther­more, the synvert team has imple­men­ted extract pipelines for spe­cific brand part­ners to extract and use the data for their purposes.

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.