BCBS 239 Data Governance Masterbook · Kai London
Risk Data Lineage, Aggregation Controls, Reporting Accuracy and Supervisory Evidence
A supervisor points at one number in your risk report. Can you prove where it came from and that it is right?
No downloads, no subscriptions, nothing extra to buy: every numbered item in this book is printed in full and completed for a worked organisation, so you can adapt it to your own organisation straight from the page.
Premium Practitioner Edition. A complete working reference, not a quick read: practitioner chapters with sixty completed artefacts, a field toolkit of case studies, labs and templates, and a reference section with practice questions, failure patterns, an executive summary and an operating model you can adopt.
A supervisor points at one number in your risk report. Can you prove where it came from and that it is right?
Most BCBS 239 programmes can describe their framework and cannot prove it. This book gives you an evidence-led method for showing that every Tier 1 risk report and supervisory return is complete, accurate, timely and reproducible, and for disclosing honestly what is not yet true.
Twelve chapters follow the order in which a framework is built and then put under load: scope and tiering, ownership and accountability, critical data elements, golden sources and reconciliation, lineage and interfaces, completeness, accuracy, timeliness and adaptability, stress and ad hoc readiness, control testing and break management, data architecture, supervisory returns, remediation measurement and a worked multi-entity case.
Sixty numbered artefacts, RD-01 to RD-60, are printed in full for one fictional UK banking group with a ring-fenced bank, a markets entity, an Irish subsidiary and an asset finance company. Twelve are critical reporting data maps, nineteen are aggregation controls with SQL, formulas, tolerances and test cases, and twenty-nine governance and evidence items make up a supervisory evidence pack: attestations, walkthroughs, break records, decision records, scorecards and an evidence index.
Inside you will find:
• Sixty complete risk data artefacts: maps, aggregation controls and evidence pack items
• SQL, formulas and thresholds tied to CET1 tolerance, ready to adapt to your own bank
• Lineage, reconciliation and break rules that survive an unannounced supervisory review
• Two case studies, ten labs, fourteen templates, maturity metrics and a 90-day plan
• A crosswalk, six tabletop exercises, sixty questions and thirty failure patterns
Part II is a field toolkit: two case studies at other fictional banks, ten hands-on labs, fourteen completed and annotated templates, a nine-dimension maturity model with twenty-eight metrics for the annual assessment and a ninety-day implementation plan.
Part III adds a standards and regulatory crosswalk, six timed tabletop exercises, a sixty-question practice bank with explanations, thirty failure patterns with recovery and prevention, and a guide to evaluating lineage, data quality and reconciliation tools. Every chapter examines a real enforcement case or supervisory publication, sourced in an appendix.
Who it is for: bank risk data directors, chief data officers, regulatory reporting leads, model risk and credit risk data owners, and the second-line and internal audit teams who test their work.
Part of the Professional Validation Library by Professor Kai London: practical books that turn standards, technology and regulation into work you can evidence. The print editions include twelve framework figures, key takeaways for every chapter, consolidated checklists, a glossary, self-test answers, a RACI matrix, a quarterly maturity scorecard mapped to the Part II nine-dimension model, a 90-day plan and a full index.
Professor Kai London