Description

A focused course, tailored for you

Aggregate Risk Reporting for Wholesale Portfolio Managers

Build the methodology, the governance layer, and the board-ready pack that holds up when the CRO asks why the numbers moved.

The aggregate risk pack reaches the Board Risk Committee and one slide gets circled. The correlation assumption looks thin. The concentration metric moved 40 basis points and the explanation is a two-line footnote. The CRO wants a re-run by Thursday. The real problem is not the data: it is that the aggregation methodology was never built to be explained under pressure, and the governance trail that should support it does not exist in a form a regulator or a senior risk officer can follow in real time.

$199 one-time

Tailored to your situation. Access within 24 hours. 30-day money-back.

Includes a hand-built implementation playbook delivered alongside course access, generated for your specific situation.

Why this course

Senior aggregate risk managers at wholesale banks hold a uniquely exposed position. They consolidate exposures that originated in dozens of desks, under different models, using different assumptions. When those exposures reach the board pack, they are expected to tell a coherent story about the whole portfolio. But the aggregation layer between desk-level data and board-level narrative is often built from bespoke models and inherited spreadsheets with no documented methodology. When the CRO questions a number, the manager has to reconstruct the rationale from scratch. When the APRA stress test submission requires a reconciliation between the aggregate risk figure and the desk-level P&L, the work goes manual. This course builds the methodology layer that makes the number defensible before it leaves the team, and the governance documentation that makes it auditable after it does.

What you walk away with

Build an aggregation methodology that names its assumptions explicitly and survives a challenge from the CRO or a regulatory examiner.
Construct the concentration and correlation analysis layer so that a movement in the aggregate number can be traced to its source in a single conversation.
Design the stress test framework so that the aggregate output reconciles with desk-level P&L without a manual rebuild.
Produce the governance documentation trail an APRA examiner needs to follow the methodology from data source to board pack.
Structure the board risk committee pack so that the aggregate risk slide answers the question the CRO is about to ask, not the one from last quarter.
Establish a version-control and sign-off workflow that makes model assumption changes visible before they surface in the output.

The 12 modules

Module 1. The Aggregation Problem in Wholesale Risk

Maps the structural challenge of consolidating risk across desks, asset classes, and geographies when each desk owns its own model. Identifies the three points where the aggregate number is most likely to break: correlation assumption inconsistency, incomplete exposure coverage, and missing reconciliation between the aggregate metric and the underlying positions. Covers the governance gap that turns a defensible number into an unexplained one when pressure arrives.

Module 2. Methodology Architecture for Aggregate Risk

Builds the documented methodology layer that sits between data ingestion and board-level output. Covers how to name assumptions explicitly, how to scope the coverage boundary so that inclusions and exclusions are intentional and auditable, and how to structure the methodology document so that a risk officer who did not build the model can follow the logic in a single reading. Template included: methodology brief with assumption register.

Module 3. Concentration Analysis: Frameworks and Thresholds

Covers the design of concentration metrics across counterparty, sector, geography, and product. Explains how to set thresholds that reflect the actual risk appetite statement rather than inherited convention, and how to document the rationale for each threshold so that a change in the risk committee's appetite can be reflected in the metric without a full rebuild. Worked example: sector concentration analysis for a diversified corporate lending book.

Module 4. Correlation Methodology and Its Documentation

Addresses the slide that gets circled most often. Covers how to choose between historical, implied, and stressed correlation inputs, how to document the choice so that it is defensible to a regulator who did not attend the modelling discussion, and how to build a sensitivity table that shows the board what happens to the aggregate number when the correlation assumption moves. Template included: correlation assumption register with CRO sign-off workflow.

Module 5. Stress Test Design for the Aggregate Portfolio

Covers the design of scenarios that work at the portfolio level, not just the desk level. Explains how to build a scenario library that maps to the bank's documented risk appetite, how to ensure the aggregate stress output reconciles with desk-level P&L without manual intervention, and how to present the scenario narrative so the board can connect the macro assumption to the portfolio impact. Covers APRA stress test submission requirements and the reconciliation documentation an APRA examiner will check.

Module 6. Regulatory Capital Linkage and the Aggregate Risk Number

Builds the explicit link between the aggregate risk metric and the regulatory capital adequacy calculation. Covers how to document the path from concentration and stress output to the capital buffer so that the risk committee and the regulator can see the connection without a verbal explanation. Addresses Basel III and Basel IV capital framework requirements as they apply to the aggregate risk function, including the internal capital adequacy assessment process documentation.

Module 7. Data Governance for Aggregation: Coverage, Gaps, and Overrides

Covers the governance of the data layer that feeds the aggregate model. Explains how to document coverage decisions, how to record and justify manual overrides, and how to build a data quality log that an APRA examiner or internal audit team can review without requiring the aggregate risk manager to reconstruct the history from memory. Includes a template for the data coverage register and the override log.

Module 8. Version Control and Assumption Change Management

Addresses the specific failure mode where an assumption changes between reporting cycles and the movement in the aggregate number cannot be explained without comparing two versions of a spreadsheet. Covers how to build a version-control workflow into the methodology so that every assumption change is logged, attributed, and visible before it reaches the output. Template included: assumption change log with pre-submission sign-off checklist.

Module 9. The Board Risk Committee Pack: Structure and Narrative

Covers the design of the aggregate risk section of the board risk committee pack. Explains how to sequence the metrics, the movement commentary, and the forward-looking assessment so that the CRO and the non-executive board members can locate the answer to the question they are forming before they ask it. Worked example: a five-slide aggregate risk section with commentary that anticipates the three most common board challenges.

Module 10. Responding to CRO and Board Challenges

Covers the specific challenge mode where a board member or the CRO questions the aggregate risk number in real time. Explains how to build the methodology so that the response is a structured walkthrough of the methodology, not an improvised defence of an inherited model. Covers how to prepare the analytical backing material that turns a 48-hour re-run request into a 4-hour documentation exercise.

Module 11. APRA and Internal Audit: What They Are Actually Checking

Covers the specific documentation an APRA prudential examiner and an internal audit team will look for in the aggregate risk function. Explains the difference between what the model produces and what the governance documentation needs to show, and identifies the four most common gaps that turn a sound methodology into a finding. Covers the APRA Prudential Standard APS 117 and APS 222 requirements that apply to aggregate market and concentration risk management at an authorised deposit-taking institution.

Module 12. Building the Implementation Playbook for Your Portfolio

Guides the aggregate risk manager through assembling the full set of documentation, methodology briefs, governance templates, and board pack structures developed across the course into a single implementation playbook specific to their portfolio. Covers how to sequence the build for a team that is doing this alongside a live reporting cycle, and how to establish a review cadence that keeps the methodology current without a full rebuild each quarter.

How this addresses your situation

Specific modules that map to what you said you are dealing with.

The CRO circles the correlation assumption slide. Modules 4 and 10 build the methodology and the response capability that turn that meeting from a crisis into a structured walkthrough.

The APRA stress test submission requires a reconciliation between the aggregate risk figure and desk-level P&L. Module 5 builds the reconciliation layer; module 11 covers what the examiner will check.

The board risk committee pack lands and the non-executive members cannot follow the movement commentary. Module 9 builds the narrative structure that anticipates their questions.

An internal audit review identifies a gap in the data coverage documentation. Module 7 builds the coverage register and override log that closes that finding before it is raised.

What you get with this course

12 written modules covering aggregation methodology, concentration and correlation analysis, stress test design, regulatory capital linkage, and board pack structure
Downloadable templates: methodology brief, assumption register, correlation assumption register with CRO sign-off workflow, data coverage register, override log, assumption change log, pre-submission checklist
Worked examples for sector concentration analysis and board risk committee pack narrative
Hand-built implementation playbook tailored to the aggregate risk function at a wholesale bank, delivered alongside course access
Access within 24 hours of purchase via the Art of Service learning environment

What you will have in hand by Day 1, Week 1, Month 1

Access to all 12 modules and downloadable templates is provisioned within 24 hours of purchase

The hand-built implementation playbook is delivered alongside course access within 24 hours

Self-paced: complete modules in the sequence that fits your current reporting cycle

Before and after

Before

The aggregate risk number reaches the board pack and the methodology behind it exists in the team's collective memory. When the CRO questions it, the response is a 48-hour rebuild. When the APRA examiner arrives, the documentation is assembled under time pressure from multiple sources.

After

The aggregation methodology is documented, the assumption register is current, and the governance trail is complete before the pack leaves the team. A challenge from the CRO or a regulatory examiner is answered from the documentation, not reconstructed from memory.

What happens if you do not address this

Each quarterly cycle that passes without a documented methodology is another cycle where the aggregate risk number is one hard question away from a full rebuild. The concentration metric, the correlation assumption, and the stress test output are all exposed to the same challenge, and the response to each one depends on the same undocumented institutional knowledge. When a key team member moves or when a regulator arrives with a specific request, the absence of the methodology layer becomes a finding, not a gap.

Who it is for

Senior managers and directors in aggregate risk, portfolio risk, and market risk at wholesale and investment banks. Responsible for producing the risk committee pack, the regulatory stress test submission, or the concentration and correlation analysis that feeds into capital adequacy reporting. Working across multiple asset classes or geographies with exposure data sourced from multiple systems.

Who this is NOT for. Retail credit risk teams whose aggregation work is confined to a single product line. Risk technology teams whose job is to build the systems, not to own the methodology. Analysts who produce one component of the aggregate picture but do not hold accountability for the consolidated view.

How it arrives

Text-based course in the Art of Service learning environment, plus downloadable templates and worked examples for every module, plus the hand-built implementation playbook delivered alongside course access.

Time investment. 12 modules at approximately 45-60 minutes each. Most practitioners work through the methodology modules (1-4) in the first week and the regulatory and governance modules (5-8) in the second, then use the remaining modules to build the board pack and implementation playbook sections in the context of their live reporting cycle.

Why $199 is the right number

The standard alternative is to engage an external risk advisory firm to document the methodology and build the governance framework. That engagement typically runs to a six-figure fee and produces a document that reflects the consultant's methodology preferences rather than the team's actual portfolio and regulator relationship. This course builds the same output from inside the team, using the team's own data and the team's own judgment about what the CRO and the APRA examiner actually care about.

FAQ

Is this relevant to a team that already has an aggregate risk model in production?

Yes. Most of the value is in the governance and documentation layer that sits above the model, not in rebuilding the model itself. The course is designed for teams that have the technical capability but lack the structured methodology documentation and board-pack narrative framework.

Does this cover APRA-specific requirements or is it generic?

Module 11 covers APRA Prudential Standards APS 117 and APS 222 specifically. The stress test design module (module 5) is written with the APRA stress testing framework as the primary regulatory context, while also covering the Basel framework requirements that feed into internal capital adequacy assessment.

How does the hand-built implementation playbook work?

After purchase, Gerard reviews the role and portfolio context provided and builds a playbook that maps the course methodology to your specific aggregation scope, regulatory context, and reporting cycle. It arrives alongside your course access within 24 hours. If you want to discuss the scope before purchase, reply to this email and Gerard will respond.

Is this suitable for a manager who does not own the modelling directly but is accountable for the aggregate output?

Yes. The course is written for the person accountable for the aggregate number and the board pack, not for the quant who built the model. The methodology documentation and governance framework modules are written from the perspective of the manager who has to explain and defend the output.

30-day money-back guarantee. If after a week of working through the materials this is not what you needed, reply to the receipt email and a full refund is processed. No questions, no forms.

Within 24 hours your account in the learning environment is provisioned and the tailored implementation playbook is delivered alongside it.