Financial Regulatory
Reporting automation
3' read
Problem
Financial regulation is strict and involves cumbersome data collection and long data manipulation processes before any reporting is done. Reporting is in and of itself a challenge as hundreds of KPIs are required to overviewed and monitored, multiple times per year. Resource input and manual-error are high.​
Solution
-
Designed 10+ APIs and data-connections to land data on AWS Cloud in centralized layer for normalization, quality and governance
-
Converting complex process documents into dbt / SQL scripts for automation of data transformation. Created data-lineage view of automation steps for auditing and governance.
-
Data-layer for regulatory reporting created through Databricks allowing for high-data volume manipulation
-
Dashboards to captured and analyze data in real time to accommodate regulatory SLAs
Impact
-
Consistency, integrity and timeliness of regulatory pipelines
-
Automated 60%+ of regulatory reporting process with baseline on improvement on data quality / error-reduction in final analysis
-
Governed data platform to use for future Machine Learning models and other analysis
_quality(80)_edited_edited_edited.jpg)
