Corporate Risk Management Platform
Enterprise risk management platform replacing manual paper/spreadsheet processes. Digitalizes multi-tier document approval workflows and centralized risk registers while automating risk scoring calculations, legacy data mapping, and scheduled email reminders.
// Key Challenges
- Data Inconsistency: Each analyst maintained different spreadsheet versions without a single source of truth.
- Manual Approval Bottlenecks & No Reminders: Approvals were handled manually across 4 tiers without automated reminders, stretching processing time to 10–14 business days compared to fast digital workflows.
- Manual Calculation Complexity: Risk scoring depended on manual calculations without automated tools, slowing down risk assessments and risking human errors.
- Zero Audit Trail: Lack of traceable records on who approved risk assessments when loss events occurred.
// Approach & Solutions
1. Automated Risk Calculation Engine
Custom backend engine (Django + Celery) computing risk scores instantly based on department-defined Likelihood × Impact parameters, eliminating manual calculation overhead.
2. Digital Approval Workflow & Automated Reminders
Digital 4-tier approval pipeline (Risk Owner → Dept. Head → Risk Committee → CRO) with scheduled background email reminders, SLA timers, auto-escalation after 48h, and immutable audit logs.
3. Loss Event Tracking & Analytics
Real-time incident tracking cataloging loss value, root risk event, and corrective action linked directly into monthly risk register trend dashboards.
// Tech Stack
| Technology | Reason |
|---|---|
| Django ORM | Strong ORM for complex relational data structures (Risk Register ↔ Approval Workflow ↔ Loss Event records). |
| Celery + Redis | Asynchronous task queue for risk scoring engine and instant notification dispatches without blocking UI responsiveness. |
| Celery Beat Scheduler | Automated background scheduler triggering quarterly risk reviews and SLA escalation checks. |
// Results & Business Impact
- 80% - Approval Cycle Time Reduction (Reduced from 14 days down to 2-3 business days)
- 0 - External Audit Disputes (100% immutable audit log availability)
- 100% - Real-Time Risk Register Sync (Eliminated fragmented spreadsheet versions)
- 250+ - Items Handled Flawlessly (200+ risk items & 50+ loss events in first 6 months)
// Project Gallery
