Reclamation for purposes Risk Data Aggregation and Reporting
We needed a platform for managing data and adjustments in risk engines that would ensure replicability, traceability and documentation of changes. Irion’s flexibility and integrability with other technologies were key, so much so that we also used it in other areas such as financial reconciliations and data quality control. The main benefits are the flexibility of the product, the professionalism of the team, and excellent value for money. Irion is a partner I would recommend to other colleagues.
Silvia Caffi, Intesa Sanpaolo
Data Technology Office Manager
Customer since
2006
Requirements
A single, traceable and maintainable solution
Efficiency
A single, centralized solution, including all typical Data Management features
Traceability
Complete archive of correction operations (data and metadata)
Search and reporting capabilities
Maintainability
Adding new “applications” to already enabled platforms is a parameterization activity
Ability to self-adapt to changes that applications make to their data structures (tables, columns) without maintenance work
Solution
Grinding and tracking with Irion EDM®
Capabilities
Some of the Irion EDM® features used:
Metadata Driven Engine, Execution & Datastore
Data Editing & Human Task Interface
Business Workflow & Collaboration
One Click Web API
External Command & API Call
Results obtained
October 2018: Remediation Repository active
December 2018: Remediation Engine active
July 2019: Remediation Explorer active
Average E2E processing times:
20′ – 40′ for tables of 8 million records
From publication to archiving on the Remediation Registry.
Challenges
Data Editing
Integration
Differences related to the data “source” (Teradata, SAS, Oracle)
Differences related to the model of database use by the application
Metadata Complexity
Dictionary of rectifiable objects, available and not, including structure information such as columns, data types, primary Key, where condition, etc.
Data Quality
Need to introduce formal and key checks on corrected records based on metadata made available by the application