Smals is a government controlled Belgian ICT services organization that assists around 100 institutions in managing their IT infrastructure, services and data to help deliver public services more efficiently. Smals’ members are primarily found in the healthcare and social security sectors and include the Crossroads Bank for Social Security, the National Social Security Office, the Egov association, and the Belgian eHealth platform.
Smals’ Data Quality Competency Centre, part of Smals research department since 2004, provides guidance for its members, coaching and training for data stewards, as well as project-oriented consultancy. Data quality has always been a crucial aspect of its work and Smals needed more robust data matching and data quality capabilities to support the business objectives of its diverse range of member institutions.
“We needed a data quality solution that matched our data quality ethos and where the standards would be scalable for the very large data sets that we manage. We found Trillium’s solution to be easy to use, powerful and capable of the level of complex fuzzy matching that we needed” said Dries Van Dromme, Data Quality and Analytics Consultant, Smals. “Most importantly, though, it supported and improved the work of our diverse range of members.”
Trillium’s data quality solution was deployed across a range of Smals’ member organizations, and what follows is an investigation into the benefits delivered by Trillium’s solution to just one of those organizations: the National Social Security Office (NSSO).
Identifying financial risk, regulatory compliance issues and social fraud using sophisticated data quality techniques.
The NSSO is one of Smals’ primary member organizations, and is responsible for the correct and timely levying of contributions, ensuring the continued, healthy financing of Belgium’s extensive social security system. A key objective is therefore to reduce losses in overdue social security contributions (payments due from employers and employees active in Belgium). A sophisticated system of early warning signals allows the NSSO to help companies avoid bankruptcy.
Another key objective is the quality control of the complex system of electronic declarations, enabling the NSSO to calculate the social contributions’ due amounts, and allowing all other social security institutions to correctly determine each worker’s accumulated social rights. Last but not least, in order to ensure regulatory compliance the NSSO, together with other institutions, conduct random and informed inspection actions.
In the case of regulatory compliance, the scope extends internationally, as foreign companies sending workers to Belgium in a way that may be exempt from social security taxes, are legally bound to provide the necessary security, health and safety measures, and minimum wage, guaranteed under Belgian law.
In this context, the NSSO’s many challenges include: building an accurate picture of (the networks of) companies and individuals working in Belgium, identifying those falling short of legal standards or otherwise at risk (e.g. of bankruptcy), and informing inspection services where fraudulent activity may be likely to take place.
In the development of the solution to support NSSO objectives, Smals has encountered and addressed many data quality issues. These include a lack of standardization of registration numbers across different EU members, of missing documentation, an inability to enforce business rules within applications, overloaded and missing data fields, and inconsistencies across multiple data sources.
“In particular, the inability to accurately identify and link companies and individuals across a wide array of applications and databases had rendered a number of key processes difficult and time-consuming, and had always severely hampered previous fraud detection initiatives,” Van Dromme confirms.
The Solution and benefits
Long-standing Trillium partner IntoDQ were tasked with helping Smals train data stewards, migrate the data, and implement the Trillium Software data quality solutions within the NSSO application databases and the data warehouse hosted by Smals. In a series of migration projects and re-engineerings, Trillium was used to profile, cleanse and match data sets, which greatly improved data quality standards and entity resolution.
Smals’ own productivity benefited from the Trillium solution. Data migration became up to 10 times faster than before the Trillium solution had been available. For example, one data migration project that would have taken about 100 man-days to accomplish, several years ago, was re-done in 10 days.
“Previously we had functional analysts performing ad hoc coding throughout the data migration process. It’s slow, frustrating work and not the best use of our data stewards’ time. Now armed with Trillium, the ability to predict conflicts that will arise when migrating data to a new and improved data model, helps to avoid much re-work and yields more robust applications. As Smals performs two or three projects of this scale every year, we may be able to save somewhere between two and three hundred man-days a year through the implementation of Trillium,” said Van Dromme.
The improved entity resolution and fuzzy matching yielded benefits more immediately apparent for the NSSO’s fraud detection objectives.
“Trillium’s solution for identity matching has undoubtedly helped NSSO’s agents of various services by improving precision and recall of directed search queries. Furthermore, the improved ability to reliably establish links across databases yielded more accurate risk models and fraud predictions. This means agents and inspectors can prioritize their investigations, stepping in to help the parties that are most at risk, making for far more efficient working processes. We’ve been told that certain types of targeted investigations have improved their hit rates significantly, to about 80%. Bottom line is, with Trillium data quality our data, and hence our results, are much more trustworthy. Without it we’d still be stumbling in the dark,” said Van Dromme.
Trillium Software, A Harte Hanks Company, is a global enterprise data quality solutions provider. Trillium’s data quality specialists help organizations achieve increased business from their data management initiatives and existing business-critical processes by providing enterprise data profiling and data cleansing software and services.
IntoDQ, which started as a reseller of Trillium Software in 2001, offers their clients advice, consultancy and implementation support in areas where a data quality perspective is required. Their experience, knowledge and expertise with specialized technology prove invaluable to their wide customer base.
20 en 21 november 2017 Praktische tweedaagse workshop met internationaal gerenommeerde spreker Alec Sharp over het modelleren met Entity-Relationship vanuit business perspectief. De workshop wordt ondersteund met praktijkvoorbeelden en duidelijke, h...
22 en 23 november 2017 Praktische tweedaagse workshop met internationaal gerenommeerde spreker Alec Sharp over datamodelleren in situaties met meer complexiteit. De workshop wordt ondersteund met praktijkvoorbeelden en duidelijke, herbruikbare richt...
30 november 2017Een uniek seminar waarin kritisch en onafhankelijk de populaire Hadoop, NoSQL en Big Data ontwikkelingen onder de loep worden genomen door database- en datawarehousespecialist pur sang Rick van der Lans. Een verhelderende sessie van e...
6 en 7 december 2017 Correcte informatie die in de juiste vorm en op het gewenste moment beschikbaar is lijkt een vanzelfsprekendheid. Dit doel kan alleen worden bereikt met een consequent beleid, dat doordacht alle fases van de levenscyclus va...
11 en 12 december 2017 Vergaar nieuwe databronnen en benut analytics en machine learning om de concurrentie een stap voor te blijven. Er wordt gekeken hoe machine learning en advanced analytics technieken zoals tekst-analyse, sentiment a...
30 en 31 januari 2018 De wereld van business intelligence en datawarehousing hanteert een unieke terminologie en eigen verzameling technologieën, ontwerptechnieken en producten. Voor nieuwkomers kan dit overweldigend overkomen. Wa...
20 en 21 maart 2018 We worden al jaren geconfronteerd met een niet-aflatende stroom van nieuwe technologieën, ontwerptechnieken, architecturen en ideeën, zoals Hadoop, streaming, self-service data preparation, logical datawarehouse, data lake, de...
27 maart 2018 Wat zijn de mogelijkheden van low code application platformen en hoe kunt u deze succesvol inzetten in uw organisatie? Aan de hand van Microsoft PowerApps, Flow en de Common Data Service wordt besproken maar vooral ook live getoond hoe ...