Executive Leadership Journey: Strategic Risk and Growth Analytics

Commercial Lending Data Assets
================================

Tables found: 8 across 3 schemas

  lending.commercial_loans         12,841 rows    Quality: 98.2%
  lending.commercial_facilities    4,219 rows     Quality: 99.1%
  lending.covenant_tracking        38,412 rows    Quality: 97.8%
  risk_analytics.commercial_pd     12,841 rows    Quality: 99.5%
  risk_analytics.commercial_lgd    12,841 rows    Quality: 99.3%
  regulatory_output.large_exposures   241 rows    Quality: 100%
  market_data.sector_indices       1,825 rows     Quality: 100%
  historical.commercial_defaults   2,104 rows     Quality: 99.8%

Key metrics available via semantic layer:
  - Commercial NPL ratio
  - Sector concentration index
  - Covenant breach rate
  - Weighted average PD
  - Expected credit loss (ECL)

Data lineage: Full traceability from source systems through
  risk models to regulatory outputs.

-- Generated by AI Agent for Elena's query
-- Sources: lending.commercial_loans (PostgreSQL) + market_data.sector_indices (Bloomberg)
 
WITH current_exposure AS (
    SELECT
        sub_sector,
        COUNT(*) AS num_facilities,
        SUM(committed_amount) AS total_committed,
        SUM(outstanding_balance) AS total_outstanding,
        AVG(pd_score) AS weighted_avg_pd,
        SUM(outstanding_balance) / SUM(SUM(outstanding_balance)) OVER() * 100
            AS pct_of_portfolio
    FROM lending.commercial_loans cl
    JOIN risk_analytics.commercial_pd cpd ON cl.loan_id = cpd.loan_id
    WHERE cl.sector = 'Real Estate'
      AND cl.status = 'ACTIVE'
    GROUP BY sub_sector
),
historical_trend AS (
    SELECT
        DATE_TRUNC('month', reporting_date) AS month,
        SUM(outstanding_balance) AS total_outstanding
    FROM lending.commercial_loans
    WHERE sector = 'Real Estate'
      AND reporting_date >= CURRENT_DATE - INTERVAL '12 months'
    GROUP BY DATE_TRUNC('month', reporting_date)
)
SELECT * FROM current_exposure
ORDER BY total_outstanding DESC;

┌─────────────────────────────────────────────────────────────┐
│              WEEKLY RISK BRIEFING                            │
│              Week of February 24, 2026                      │
├─────────────────────────────────────────────────────────────┤
│                                                             │
│  CAPITAL POSITION                                           │
│  CET1 Ratio: 12.3% (target: >10.5%)          [ON TARGET]   │
│  Change vs last week: -0.1pp                                │
│  Driver: RWA increase from new commercial originations      │
│                                                             │
│  CREDIT QUALITY                                             │
│  NPL Ratio: 2.1% (target: <3.0%)             [ON TARGET]   │
│  New NPLs this week: 3 (total: $4.2M)                      │
│  Watchlist additions: 7 accounts                            │
│                                                             │
│  FRAUD OPERATIONS                                           │
│  Fraud catch rate: 95.1% (target: >95%)       [ON TARGET]   │
│  False positive rate: 1.6% (target: <2%)      [ON TARGET]   │
│  Revenue protected this week: $1.42M                        │
│                                                             │
│  LIQUIDITY                                                  │
│  LCR: 138.7% (minimum: >100%)                [ON TARGET]   │
│  NSFR: 112.4% (minimum: >100%)               [ON TARGET]   │
│                                                             │
│  CONCENTRATION ALERTS                                       │
│  [WARNING] Real estate: 22.8% (limit: 25%)                 │
│  [OK] Top 10 borrowers: 14.2% (limit: 20%)                 │
│  [OK] Country risk: all within limits                       │
│                                                             │
│  REGULATORY CALENDAR                                        │
│  Basel III monthly report: due March 10 (8 business days)   │
│  Quarterly stress test: due March 31 (21 business days)     │
│                                                             │
└─────────────────────────────────────────────────────────────┘

{
  "workflow_request": {
    "title": "CRE Portfolio Stress Test - CRO Request",
    "requestor": "elena@meridian.bank",
    "priority": "high",
    "deadline": "2026-03-07",
    "scenarios": [
      {
        "name": "CRE Downturn",
        "parameters": {
          "property_value_decline": -0.20,
          "vacancy_rate_increase": 0.15,
          "rental_income_decline": -0.12,
          "cap_rate_expansion": 0.015
        }
      },
      {
        "name": "Rate Shock + Recession",
        "parameters": {
          "interest_rate_change_bps": 200,
          "gdp_growth": -0.015,
          "unemployment_increase": 0.025,
          "credit_spread_widening_bps": 150
        }
      }
    ],
    "outputs_requested": [
      "Portfolio loss projection by sub-sector",
      "Impact on CET1 ratio",
      "List of facilities likely to breach covenants",
      "Comparison to current provisions"
    ],
    "assigned_to": ["amir@meridian.bank", "rachel@meridian.bank"]
  }
}

-- Agent-generated: Early warning signal detection
-- Identifies segments with statistically significant deterioration
 
WITH segment_trends AS (
    SELECT
        sector,
        loan_product,
        DATE_TRUNC('month', reporting_date) AS month,
        COUNT(*) AS total_loans,
        SUM(CASE WHEN days_past_due > 0 THEN 1 ELSE 0 END) AS delinquent,
        AVG(pd_score) AS avg_pd
    FROM lending.commercial_loans cl
    JOIN risk_analytics.commercial_pd cpd ON cl.loan_id = cpd.loan_id
    WHERE reporting_date >= CURRENT_DATE - INTERVAL '6 months'
    GROUP BY sector, loan_product, DATE_TRUNC('month', reporting_date)
)
SELECT
    sector,
    loan_product,
    -- Current vs 6-month-ago comparison
    MAX(CASE WHEN month = DATE_TRUNC('month', CURRENT_DATE) THEN avg_pd END) AS current_pd,
    MAX(CASE WHEN month = DATE_TRUNC('month', CURRENT_DATE - INTERVAL '6 months') THEN avg_pd END) AS pd_6m_ago,
    MAX(CASE WHEN month = DATE_TRUNC('month', CURRENT_DATE) THEN avg_pd END)
    - MAX(CASE WHEN month = DATE_TRUNC('month', CURRENT_DATE - INTERVAL '6 months') THEN avg_pd END)
        AS pd_change
FROM segment_trends
GROUP BY sector, loan_product
HAVING MAX(CASE WHEN month = DATE_TRUNC('month', CURRENT_DATE) THEN avg_pd END)
     > MAX(CASE WHEN month = DATE_TRUNC('month', CURRENT_DATE - INTERVAL '6 months') THEN avg_pd END)
ORDER BY pd_change DESC;

┌─────────────────────────────────────────────────────────────────┐
│                    CRO EXECUTIVE DASHBOARD                      │
│                    Elena Vasquez | Updated: Real-time            │
├──────────────────────────────────┬──────────────────────────────┤
│                                  │                              │
│  Portfolio Health Score          │  Capital Position            │
│                                  │                              │
│       ████████████░░  82/100     │  CET1:  12.3%  ▲ +0.2pp YTD│
│                                  │  T1:    14.1%  ▲ +0.1pp    │
│  vs last month: +3              │  TCR:   16.8%  ▲ +0.3pp    │
│  vs last year:  +8              │                              │
│                                  │  Buffer over minimum:       │
│                                  │  ████████████████  7.8pp    │
├──────────────────────────────────┼──────────────────────────────┤
│                                  │                              │
│  Concentration Limits            │  Model Performance          │
│                                  │                              │
│  Real Estate  ████████████░ 23%  │  Credit PD   AUC: 0.84     │
│  Top 10       ██████░░░░░░ 14%  │  Fraud Det   AUC: 0.97     │
│  Country      ████░░░░░░░░  8%  │  LGD Model   AUC: 0.71     │
│                                  │                              │
│  [!] RE approaching 25% limit   │  All models within          │
│                                  │  validation thresholds      │
├──────────────────────────────────┴──────────────────────────────┤
│  Key Risk Indicators (trend: 12 months)                        │
│  ┌──────────────────────────────────────────────────────────┐  │
│  │     NPL Ratio          Fraud Loss Rate        VaR       │  │
│  │  3%│                  0.05%│               2.5%│        │  │
│  │    │   ╭──╮               │                   │        │  │
│  │  2%│──╯    ╰──            │  ──────────── 1.8%│────    │  │
│  │    │          ──── 2.1%   │                   │        │  │
│  │  1%│                 0.02%│────────────        │        │  │
│  │    └──────────────        └──────────────      └────    │  │
│  │     M A M J J A S O N D J F  (months)                  │  │
│  └──────────────────────────────────────────────────────────┘  │
└────────────────────────────────────────────────────────────────┘

From: MATIH Platform <alerts@matih.meridian.internal>
To: Elena Vasquez <elena@meridian.bank>
Subject: Weekly Risk KPI Digest - Week of Feb 24, 2026

SUMMARY: 11 of 12 KPIs on target. 1 warning.

KPI                          Current    Target     Status
─────────────────────────────────────────────────────────
CET1 Ratio                   12.3%      >10.5%     OK
NPL Ratio                    2.1%       <3.0%      OK
Fraud Catch Rate              95.1%      >95%       OK
False Positive Rate            1.6%      <2%        OK
LCR                          138.7%     >100%      OK
NSFR                         112.4%     >100%      OK
Portfolio VaR                  1.8%      <2.5%      OK
Credit Loss Rate               1.05%     <1.2%      OK
Regulatory Report Accuracy   100%       100%       OK
Customer Acquisition Cost    $412       <$350      MISS
RE Concentration             22.8%      <25%       WARN
Model AUC (Credit PD)         0.84       >0.75      OK

ACTION ITEMS:
  [WARN] Real estate concentration at 22.8%, approaching
         25% limit. Trend: +0.6pp in 3 months.
         Recommendation: Review new origination pipeline.

  [MISS] Customer acquisition cost $412 vs $350 target.
         Trend: stable. Marketing team reviewing channel mix.

{
  "alert": {
    "name": "concentration-limit-warning",
    "type": "threshold",
    "metric": "sector_concentration_pct",
    "conditions": [
      {
        "level": "warning",
        "threshold": "limit * 0.90",
        "message": "Sector concentration at 90% of limit"
      },
      {
        "level": "critical",
        "threshold": "limit * 0.95",
        "message": "Sector concentration at 95% of limit -- origination review required"
      },
      {
        "level": "breach",
        "threshold": "limit * 1.00",
        "message": "LIMIT BREACH -- immediate escalation to Board Risk Committee"
      }
    ],
    "channels": {
      "warning": ["email:elena@meridian.bank"],
      "critical": ["email:elena@meridian.bank", "sms:elena", "slack:#risk-escalation"],
      "breach": ["pagerduty:board-risk", "email:board-risk-committee", "sms:elena"]
    }
  }
}

┌─────────────────────────────────────────────────────────────────┐
│                    SCENARIO COMPARISON                           │
│                    Meridian Bank CRE Portfolio                   │
├──────────────────────┬──────────────────────┬───────────────────┤
│                      │ Scenario 1:          │ Scenario 2:       │
│ Metric               │ Rate +200bps         │ Recession         │
├──────────────────────┼──────────────────────┼───────────────────┤
│ Portfolio PD (wt avg) │ 3.4% (from 2.8%)   │ 5.1% (from 2.8%) │
│ Expected Loss        │ $42M (from $31M)     │ $68M (from $31M)  │
│ NPL Ratio            │ 2.8% (from 2.1%)    │ 4.2% (from 2.1%) │
│ CET1 Ratio Impact    │ 12.0% (from 12.3%)  │ 11.4% (from 12.3%)│
│ Provisions Required  │ +$11M               │ +$37M             │
│ Covenant Breaches    │ 12 facilities       │ 31 facilities     │
│ Capital Buffer       │ 7.5pp above min     │ 6.9pp above min   │
├──────────────────────┼──────────────────────┼───────────────────┤
│ Risk Assessment      │ Manageable          │ Requires action    │
└──────────────────────┴──────────────────────┴───────────────────┘