BUSINESS SITUATION
The client was seeking support to build a data warehouse that held data from authoritative sources. We supported them in improving the accuracy of the data feeding into regulatory reporting such as BCBS239, FR2052a, SICAR reporting, etc. We also create scalable & effective automated solutions to reduce dependency on user-defined tools and manual-intensive processes.
SGA APPROACH
For A leading asset manager based in the US, the team at SGA:
- Identified and cataloged metadata from applications that fed into external reports.
- Stitched the data lineage across apps.
- Reviewed the data sources with the program/tech teams to assess if it meets the requirements.
- Identify manual processes that contribute to data quality issues.
ENGAGEMENT
- Defined and enforced RACI.
- Worked with the data owners & consumers to identify the data quality requirements.
- Defined & implemented preventive & detective data controls along with policies and standards.
- Implemented fully automated or semi-automated processes to reduce manual errors.
BENEFITS & OUTCOME
- Identified, mapped, and stitched the data lineage across 300+ apps.
- Implemented over 10000+ preventive & detective rules across applications.
- Ensured data accuracy met the compliance requirements.
- Built interactive dashboards to track development.
KEY TAKEAWAYS
- Reviewed, prioritized, and delegated the issue tickets to sources for issue closure.
- Identified trends and patterns for repeated offenders and pushed for strategic fixes.
- Governed monthly forums to identify common data quality issues.
