Regulatory Reporting
Automation for a Digital Bank
Requirement
To automate 200+ Regulatory Reports having different periodicities like Weekly, Monthly, Quarterly, Semi-Annual, and Annual
Solution Delivered
- We delivered a scalable solution where the entire mapping of report templates, their periodicity, SQL queries, etc was managed in JSON files and the workflow orchestration was done in Airflow.
Solution Framework
![framework_regulatory_reporting framework_regulatory_reporting](https://www.k2analytics.co.in/wp-content/uploads/2023/03/framework_regulatory_reporting.jpg)
- Airflow was used to orchestrate the reporting workflow and scheduling purpose
- Python was used for data ETL from the database, pushing the data in MS Excel worksheets, and storing the final report on the cloud
- Automated Testing of reports was done using PyTest
- SQL Stored Procedures were written in PostgreSQL to summarize data for report generation
- The mapping between SQL Stored Procedures, report templates and its cell references, and custom data transformation was all managed in JSON
- The reports were stored on a Cloud Server with a Month-wise folder structure and timestamp versioning for each report dump
- GitLab was used for project code management and CI-CD integration
Tech Stack
![Kubernetes-icon-color](https://www.k2analytics.co.in/wp-content/uploads/2023/03/Kubernetes-icon-color-300x291.jpg)
Kubernetes Cluster
![airflow icon](https://www.k2analytics.co.in/wp-content/uploads/2023/03/airflow-icon-512x512-tpr318yf-300x300.png)
Airflow
![Python](https://www.k2analytics.co.in/wp-content/uploads/2020/05/py.png)
Python
![postgresql](https://www.k2analytics.co.in/wp-content/uploads/2023/03/postgreSQL-2.png)
PostgrSQL
![gitlab](https://www.k2analytics.co.in/wp-content/uploads/2023/03/gitlab-300x92.png)
GitLab
Watch more videos available on our youtube channel
Machine Learning Blog Links
![customer_360](https://www.k2analytics.co.in/wp-content/uploads/2022/06/cus-360.png)
Statistics for Data Science
![data science course artificial neural network](https://www.k2analytics.co.in/wp-content/uploads/2020/05/data-science-course-artificial-neural-network.jpg)
K Means Clustering
![banking analytics workshop](https://www.k2analytics.co.in/wp-content/uploads/2020/09/5-days-banking-credit-risk2.jpg)
Logistic Regression Model Development
![data science with python](https://www.k2analytics.co.in/wp-content/uploads/2020/06/data-science-with-python.jpg)
Model Performance Measures
Phone: 8939694874
Email : info@k2analytics.co.in
©2024 K2 Analytics. All rights reserved.