Back to Case work

Data Quality Validation Framework


Background

Obtaining adequate data quality (DQ) is one of the key challenges the banking Industry faces. The Tier 1 UK Banking Client engaged ACS to design and implement a suitable data quality validation framework for Group Risk and regulatory reporting purposes. . It is critical that data is generally processed efficiently through appropriate checks and cleansing processes to ensure that the data warehouse is both complete and contains data that reflects the true business facts, thus adequately supporting stakeholders in the decision making process.

Given the huge number of DQ checks that occur in most data warehousing processes, the proposed solutions needed to be both effective and reusable.

Solution

A Validation Framework solution was proposed and implemented by ACS. This not only addressed the inherent data quality issues across Group risk and Regulatory reporting but also provided a scalable and reusable solution that could be integrated with any Business Intelligence tool for Dashboard Reporting purposes (e.g. OBIEE, Crystal Reports, Business Objects etc.)

Benefits

  • Performs all data quality validation.
  • Performs the Business rules validation which, depending upon the severity of data quality, classifies the issues either in warnings or blockers.
  • Dashboard reporting using BI tools.
  • Minimal time required to implement new business rules.
  • Reduced overall project costs since there is no need to write code for project specific validations and most of the rules are reusable across various work streams.
  • Supports multiple databases (Oracle, SQL Server etc).
T

For more information about how we can help you please contact us

Vijay Jadhav

Vijay Jadhav

Managing Consultant
BI Architecture

contact-icon-email-greysocial-linkedin-small-grey

contact-icon-phone

Recent Case Studies

Delivery that counts

Our track record for end to end delivery speaks for itself. In our short history, we have delivered some of the most complex business and IT change across some of the worlds largest organisations. Our people are happy and so are our clients. If you would like to know more about a career in ACS please click here.

Sapace

Leave a comment

Leave a Reply

Your email address will not be published. Required fields are marked *

Thank you for posting blog.