# ceferinoal/regulatory-risk-audit-analytics architecture

> Architecture diagram of the GitHub repository ceferinoal/regulatory-risk-audit-analytics, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-10-05). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/ceferinoal/regulatory-risk-audit-analytics
- Repository: https://github.com/ceferinoal/regulatory-risk-audit-analytics

## Overview

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`](https://github.com/ceferinoal/regulatory-risk-audit-analytics/tree/main/data) (Banking datasets), [`python/02_generate_audit_findings_summary.py`](https://github.com/ceferinoal/regulatory-risk-audit-analytics/blob/main/python/02_generate_audit_findings_summary.py) (Findings consolidator), [`reports/audit_summary.md`](https://github.com/ceferinoal/regulatory-risk-audit-analytics/blob/main/reports/audit_summary.md) (Audit summary), [`python/01_generate_synthetic_regulatory_data.py`](https://github.com/ceferinoal/regulatory-risk-audit-analytics/blob/main/python/01_generate_synthetic_regulatory_data.py) (Data generator)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_data["Synthetic data"]
  node_generator["Data generator"]
  node_datasets[("Banking datasets")]
end

subgraph group_testing["Audit testing"]
  node_capital_sql["Capital &amp; RWA"]
  node_icaap_sql["ICAAP &amp; RAF"]
  node_ilaap_sql["ILAAP liquidity"]
  node_ifrs_sql["IFRS 9 ECL"]
  node_consolidator["Findings consolidator"]
end

subgraph group_outputs["Audit outputs"]
  node_findings["Findings summary"]
  node_audit_report["Audit summary<br/>[audit_summary.md]"]
  node_capital_explanation["Capital test guide"]
  node_icaap_explanation["ICAAP test guide"]
  node_ilaap_explanation["ILAAP test guide"]
  node_ifrs_explanation["IFRS 9 test guide"]
end

node_auditor(("Internal auditor"))

node_generator -->|"generates"| node_datasets
node_datasets -.->|"tests"| node_capital_sql
node_datasets -.->|"tests"| node_icaap_sql
node_datasets -.->|"tests"| node_ilaap_sql
node_datasets -.->|"tests"| node_ifrs_sql
node_datasets -->|"reads"| node_consolidator
node_consolidator -.->|"writes"| node_findings
node_consolidator -->|"writes"| node_audit_report
node_auditor -.->|"reviews"| node_capital_explanation
node_auditor -.->|"reviews"| node_icaap_explanation
node_auditor -.->|"reviews"| node_ilaap_explanation
node_auditor -.->|"reviews"| node_ifrs_explanation
node_auditor -->|"uses"| node_audit_report

click node_generator "https://github.com/ceferinoal/regulatory-risk-audit-analytics/blob/main/python/01_generate_synthetic_regulatory_data.py"
click node_datasets "https://github.com/ceferinoal/regulatory-risk-audit-analytics/tree/main/data"
click node_capital_sql "https://github.com/ceferinoal/regulatory-risk-audit-analytics/blob/main/sql/01_capital_rwa_testing.sql"
click node_icaap_sql "https://github.com/ceferinoal/regulatory-risk-audit-analytics/blob/main/sql/02_icaap_raf_testing.sql"
click node_ilaap_sql "https://github.com/ceferinoal/regulatory-risk-audit-analytics/blob/main/sql/03_ilaap_liquidity_testing.sql"
click node_ifrs_sql "https://github.com/ceferinoal/regulatory-risk-audit-analytics/blob/main/sql/04_ifrs9_staging_ecl_testing.sql"
click node_consolidator "https://github.com/ceferinoal/regulatory-risk-audit-analytics/blob/main/python/02_generate_audit_findings_summary.py"
click node_findings "https://github.com/ceferinoal/regulatory-risk-audit-analytics/blob/main/reports/findings_summary.csv"
click node_audit_report "https://github.com/ceferinoal/regulatory-risk-audit-analytics/blob/main/reports/audit_summary.md"
click node_capital_explanation "https://github.com/ceferinoal/regulatory-risk-audit-analytics/blob/main/reports/01_capital_rwa_testing_explanation.md"
click node_icaap_explanation "https://github.com/ceferinoal/regulatory-risk-audit-analytics/blob/main/reports/02_icaap_raf_testing_explanation.md"
click node_ilaap_explanation "https://github.com/ceferinoal/regulatory-risk-audit-analytics/blob/main/reports/03_ilaap_liquidity_testing_explanation.md"
click node_ifrs_explanation "https://github.com/ceferinoal/regulatory-risk-audit-analytics/blob/main/reports/04_ifrs9_staging_ecl_testing_explanation.md"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_generator,node_datasets toneBlue
class node_capital_sql,node_icaap_sql,node_ilaap_sql,node_ifrs_sql,node_consolidator toneAmber
class node_findings,node_audit_report,node_capital_explanation,node_icaap_explanation,node_ilaap_explanation,node_ifrs_explanation toneMint
class node_auditor toneIndigo
```

## Components

### Synthetic data

- [Data generator](https://github.com/ceferinoal/regulatory-risk-audit-analytics/blob/main/python/01_generate_synthetic_regulatory_data.py): `python/01_generate_synthetic_regulatory_data.py`
- [Banking datasets](https://github.com/ceferinoal/regulatory-risk-audit-analytics/tree/main/data): `data`

### Audit testing

- [Capital & RWA](https://github.com/ceferinoal/regulatory-risk-audit-analytics/blob/main/sql/01_capital_rwa_testing.sql): `sql/01_capital_rwa_testing.sql`
- [ICAAP & RAF](https://github.com/ceferinoal/regulatory-risk-audit-analytics/blob/main/sql/02_icaap_raf_testing.sql): `sql/02_icaap_raf_testing.sql`
- [ILAAP liquidity](https://github.com/ceferinoal/regulatory-risk-audit-analytics/blob/main/sql/03_ilaap_liquidity_testing.sql): `sql/03_ilaap_liquidity_testing.sql`
- [IFRS 9 ECL](https://github.com/ceferinoal/regulatory-risk-audit-analytics/blob/main/sql/04_ifrs9_staging_ecl_testing.sql): `sql/04_ifrs9_staging_ecl_testing.sql`
- [Findings consolidator](https://github.com/ceferinoal/regulatory-risk-audit-analytics/blob/main/python/02_generate_audit_findings_summary.py): `python/02_generate_audit_findings_summary.py`

### Audit outputs

- [Findings summary](https://github.com/ceferinoal/regulatory-risk-audit-analytics/blob/main/reports/findings_summary.csv): `reports/findings_summary.csv`
- [Audit summary](https://github.com/ceferinoal/regulatory-risk-audit-analytics/blob/main/reports/audit_summary.md): `reports/audit_summary.md`
- [Capital test guide](https://github.com/ceferinoal/regulatory-risk-audit-analytics/blob/main/reports/01_capital_rwa_testing_explanation.md): `reports/01_capital_rwa_testing_explanation.md`
- [ICAAP test guide](https://github.com/ceferinoal/regulatory-risk-audit-analytics/blob/main/reports/02_icaap_raf_testing_explanation.md): `reports/02_icaap_raf_testing_explanation.md`
- [ILAAP test guide](https://github.com/ceferinoal/regulatory-risk-audit-analytics/blob/main/reports/03_ilaap_liquidity_testing_explanation.md): `reports/03_ilaap_liquidity_testing_explanation.md`
- [IFRS 9 test guide](https://github.com/ceferinoal/regulatory-risk-audit-analytics/blob/main/reports/04_ifrs9_staging_ecl_testing_explanation.md): `reports/04_ifrs9_staging_ecl_testing_explanation.md`

### Other components

- **Internal auditor**

## Connections

- Data generator → Banking datasets: generates (evidence: `python/01_generate_synthetic_regulatory_data.py`)
- Banking datasets → Capital & RWA: tests (evidence: `README.md`)
- Banking datasets → ICAAP & RAF: tests (evidence: `README.md`)
- Banking datasets → ILAAP liquidity: tests (evidence: `README.md`)
- Banking datasets → IFRS 9 ECL: tests (evidence: `README.md`)
- Banking datasets → Findings consolidator: reads (evidence: `python/02_generate_audit_findings_summary.py`)
- Findings consolidator → Findings summary: writes (evidence: `README.md`)
- Findings consolidator → Audit summary: writes (evidence: `python/02_generate_audit_findings_summary.py`)
- Internal auditor → Capital test guide: reviews (evidence: `README.md`)
- Internal auditor → ICAAP test guide: reviews (evidence: `README.md`)
- Internal auditor → ILAAP test guide: reviews (evidence: `README.md`)
- Internal auditor → IFRS 9 test guide: reviews (evidence: `README.md`)
- Internal auditor → Audit summary: uses (evidence: `README.md`)
