SOLUTIONS > RISK DATA AGGREGATION & REPORTING

SOLUTIONS > RISK DATA AGGREGATION & REPORTING

Risk Data Aggregation
& Reporting

Corrections and traceability – BCBS 239

Risk Data Aggregation
& Reporting

Corrections and traceability

Needs

Needs
A unique, traceable and maintainable solution

Efficiency

  Unique and centralized solution including all common Data Management features

Traceability

  Complete archiving of corrections (data and metadata).

  Search and reporting features.

Maintainability

  Addition of new applications to already enabled platforms is a parameterization task.

  Ability to adapt to changes applications make to data structures (tables, columns) without maintenance.

Challenges

Challenges
Data Editing

Integration

Differences related to data “source”
(Teradata, SAS, Oracle)

Differences related to database application model.

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 controls on rectified records based on the metadata provided by the application.

Usability

Timely, massive and via script Data Editing

Orchestration

Request Response
Services

On Demand
Process Activation

Integration

Differences related to data “source”
(Teradata, SAS, Oracle)

Differences related to database application model.

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 controls on rectified records based on the metadata provided by the application.

Usability

Timely, massive and via script Data Editing

Orchestration

Request Response
Services

On Demand
Process Activation

Challenges

The solution 
Corrections and traceability with Irion EDM 

Capabilities

Some 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: Active Remediation Repository

  December 2018: Active Remediation Engine

  July 2019: Active Remediation Explorer

Average E2E processing time: 

20′- 40′ for 8 million records table  
From Remediation Registry remediation to archiving

Client testimonials

Interview: Silvia Caffi
Intesa Sanpaolo

Data Technology Information Systems Management Manager

Silvia Caffi participated as a speaker at the Irion Innovation Day
2019 event, held in Milan at the Cariplo Foundation.

Among the topics addressed: 

audit, data quality, data aggregation, reporting, risk management