How ceferinoal/regulatory-risk-audit-analytics works
This repository demonstrates a synthetic-data regulatory risk audit workflow: Python creates banking datasets, SQL scripts provide area-specific control tests, and Python consolidates exceptions into findings and an executive audit summary. The README documents four substantive testing domains and their outputs. The generator and consolidation scripts were sampled; SQL implementations and report contents were not, so their detailed calls and transformations are not asserted here.
Main entry points: data Banking datasets · 02_generate_audit_findings_summary.py Findings consolidator · audit_summary.md Audit summary · 01_generate_synthetic_regulatory_data.py Data generator
Components 14
Synthetic data
- Data generator
python/01_generate_synthetic_regulatory_data.py - Banking datasets
data
Audit testing
- Capital & RWA
sql/01_capital_rwa_testing.sql - ICAAP & RAF
sql/02_icaap_raf_testing.sql - ILAAP liquidity
sql/03_ilaap_liquidity_testing.sql - IFRS 9 ECL
sql/04_ifrs9_staging_ecl_testing.sql - Findings consolidator
python/02_generate_audit_findings_summary.py
Audit outputs
- Findings summary
reports/findings_summary.csv - Audit summary
reports/audit_summary.md - Capital test guide
reports/01_capital_rwa_testing_explanation.md - ICAAP test guide
reports/02_icaap_raf_testing_explanation.md - ILAAP test guide
reports/03_ilaap_liquidity_testing_explanation.md - IFRS 9 test guide
reports/04_ifrs9_staging_ecl_testing_explanation.md
Other components
- Internal auditor
Connections 13
- Data generator → Banking datasets: generates
python/01_generate_synthetic_regulatory_data.py - Banking datasets → Capital & RWA: tests
README.md - Banking datasets → ICAAP & RAF: tests
README.md - Banking datasets → ILAAP liquidity: tests
README.md - Banking datasets → IFRS 9 ECL: tests
README.md - Banking datasets → Findings consolidator: reads
python/02_generate_audit_findings_summary.py - Findings consolidator → Findings summary: writes
README.md - Findings consolidator → Audit summary: writes
python/02_generate_audit_findings_summary.py - Internal auditor → Capital test guide: reviews
README.md - Internal auditor → ICAAP test guide: reviews
README.md - Internal auditor → ILAAP test guide: reviews
README.md - Internal auditor → IFRS 9 test guide: reviews
README.md - Internal auditor → Audit summary: uses
README.md