dqagent
← Solutions
Finance Bundle

DQ-Agent for Banking

BDDK audits, IFRS 9 ECL data completeness, BCBS 239's 11 principles — all in a single pipeline.

Pain points

  • !BDDK Data Governance Regulation readiness
  • !Complete and accurate loan tables for IFRS 9 Expected Credit Loss (ECL)
  • !Auditability of BCBS 239 Risk Data Aggregation principles
  • !PII column inventory and masking under KVKK

DQ-Agent answer

The Finance Bundle automatically produces BDDK + IFRS 9 + BCBS 239 + KVKK + SOX compliant reports.

Banks run DQ-Agent next to their core banking SQL Server. Profiling and anomaly detection are read-only by default, and any change to data requires an explicit approval. Compliance evidence is produced per regulation article, so audit preparation starts from facts instead of spreadsheets.

Regulations covered

BDDKTurkish Banking Regulator — Data Governance

Governance structure, ownership matrix, audit trail, lineage documentation.

  • Data ownership directive
  • Information systems audit
  • Internal control and compliance

IFRS 9Financial Instruments — Expected Credit Loss

PD/LGD/ECL data completeness, timeliness and outlier checks for loan tables.

  • ECL data completeness
  • Stage 1/2/3 consistency
  • Default event date accuracy

BCBS 239Basel Risk Data Aggregation Principles

Per-principle (P1–P11) agent-based evidence: accuracy, completeness, timeliness, adaptability.

  • P3 Accuracy + integrity
  • P4 Completeness
  • P5 Timeliness
  • P6 Adaptability

KVKKTurkish Personal Data Protection Law (Law 6698)

PII inventory, retention policies, masking and anonymization evidence.

  • Article 4 — General principles
  • Article 6 — Special categories
  • Article 7 — Retention
  • Article 12 — Data security

SOXSarbanes-Oxley — Information Controls

Encrypted 7-year audit log, role-based access, approval-gated mutations — supports SOX 302/404.

  • Section 302 — Responsibility
  • Section 404 — Internal control
  • Audit trail 7 years

Agents that do the work

SchemaDiscoveryAgent

Discovers the schema

Output: Tables + FKs + info schema snapshot

ProfilingAgent

Generates 20+ metrics per table

Output: Profiles snapshot

AnomalyDetectionAgent

Detects 22 anomaly types

Output: Anomalies snapshot

ComplianceAgent

BDDK + KVKK + BCBS 239 + IFRS 9 + SOX reports

Output: Compliance PDF/HTML

MaskingAgent

DDM scripts + k-anonymity + KVKK retention

Output: Masking + retention DDL

LineageAgent

FK + procedure dependency graph

Output: Lineage snapshot + Mermaid

ReconciliationAgent

GL ↔ subledger SUM reconciliation

Output: Reconciliation report

Example checks

  • TCKN format error — 11-digit + check digit
  • IBAN format error — TR + 24 digits + mod-97
  • Negative balance — Customer balance < 0
  • FK orphan — Transaction → missing customer
  • Finance table DELETE — Any delete
  • Reconciliation breach — GL ≠ subledger

30-minute live demo against your own schema

Not a slideshow — a live install. We profile your SQL Server connection in minutes.