Compliance Reporting Data Warehouse Solution
Single source of truth- One of the biggest challenges was that there were many sources of data used by different teams across information security office. A single source of truth was needed for the bank as well as the auditors.
Client Challenge
- Single source of truth- One of the biggest challenges was that there were many sources of data used by different teams across information security office. A single source of truth was needed for the bank as well as the auditors.
- Agreeing Business Rules across teams- We realized that there were multiple teams reporting on the same facts but had different understanding of the business rules. This caused a lot of discrepancies across the reports produced regularly, thereby causing confusion for the business users and the auditors.
- Data lineage and traceability- In larger size
Our Solution and Approach
- We identified the golden sources and design-develop one Datawarehouse holding historic data and business rules centrally for singular reference point for the whole of the bank entity. Well-designed ETL mappings using Informtica/BODS to pull data from the source, address data quality issues and apply transformation business logic to produce a refined data warehouse for the users to report on.
- We organized workshops with multiple and wider teams to agree on the business definitions and maintain a data dictionary on SharePoint for everyone to access. This was reviewed and maintained periodically by the central reporting and architecture team.
- We worked closely with the control owners to identify the golden sources and document the flow of data through various systems using data lineage tools.
- Automation of reporting is the most common challenge we encountered and to provide an end to end automated solution we automated the backend + ETL and the reporting various reporting and dashboarding tools like Business objects, Tableau, PowerBI etc.
In the end you should only measure and look at the numbers that drive action, meaning that the data tells you what you should do next
Alex Peiniger
Benefits we delivered to client
- Cost effective end to end automated Reporting solution for the client.
- Single source of truth within an organization helps supports effective decision support for the business users.
- Standard data integration framework pattern achieved which facilitates easy and effective maintenance of the warehouse.