All projects
Data Analysis2026

Banking Risk Analytics Platform

Interactive risk analytics suite for securitised auto-loan portfolios with PD modelling, ECL, roll rates and stress testing.

PythonStreamlitSQLPower BIIFRS 9 ECL
0

Loans modelled

0+

DPD snapshots

₹0 Cr

Base ECL

0

PD model AUC

Overview

A reproducible banking-risk analytics suite built around a synthetic securitised auto-loan portfolio. It combines a Streamlit dashboard, SQL insights, baseline probability-of-default modelling, IFRS 9-style expected-credit-loss analysis, delinquency roll rates, vintage curves and scenario-based stress testing.

Features

  • Interactive portfolio overview with balance, ECL, loss and collection KPIs
  • DPD staging, delinquency roll-rate analysis and vintage loss curves
  • Baseline PD model with stratified out-of-fold evaluation and calibration diagnostics
  • IFRS 9-style PD × LGD × EAD expected-credit-loss calculations
  • Illustrative base, recession, COVID and 2008 stress scenarios
  • SQL Insights page with filtered portfolio queries and CSV export

Challenges

  • Keeping risk calculations reproducible across dashboard filters and scenario assumptions.
  • Avoiding target leakage by separating origination-time features from delinquency outcomes.
  • Presenting technical credit-risk concepts in a decision-ready dashboard experience.

Results

The platform turns a synthetic loan portfolio into a complete risk-analysis workflow: early-warning delinquency views, baseline PD diagnostics, portfolio-level ECL and scenario comparison. It is designed as a portfolio and learning project, not a production credit-decision or regulatory model.

Screenshots

Interactive banking risk dashboard
Interactive banking risk dashboard
DPD roll-rate and portfolio exposure analysis
DPD roll-rate and portfolio exposure analysis
Stress-testing and expected-credit-loss views
Stress-testing and expected-credit-loss views
How it works

Architecture

The end-to-end flow from raw data to a shipped result.

01

Ingest

Loan, DPD, loss & vintage tables

02

Model

PD, staging, ECL & roll rates

03

Stress

Scenario-weighted portfolio impact

04

Decide

Streamlit, SQL & Power BI insights

Keep exploring

Other projects