⚡ Built with Python + AI

AI-Powered Daily Financial
Reporting & Analysis Pipeline

Automating end-of-day financial reporting for a commercial bank — from raw database exports to an interactive dashboard with AI-driven forecasting and anomaly detection.

🗄️
Source
Core Banking Database
Balance sheet, P&L, risk metrics, sector lending exported daily at EOD
→
⚙️
Parse & Transform
ETL Pipeline
3 domain parsers (BS, P&L, Risk). Validates, normalises, and computes deltas & YTD
→
📦
Persist
Time-Series History
Immutable daily ledger. Idempotent upserts — safe to re-run any day
→
✨ AI
🤖
Analyse
AI Engine
Forecasting · Anomaly detection · NL summary · Budget vs actuals
→
📊
Deliver
Live Dashboard
Static HTML + JSON. Zero framework. Served via Flask. Works on any device
✦ What AI adds to the pipeline
📈
Smart Forecasting
Bull / base / bear scenarios for full-year P&L, updated every run
🔍
Anomaly Detection
Flags unusual daily movements vs. historical baseline automatically
💬
NL Chat Interface
Ask "What drove NPL up today?" — AI answers with live data context
📝
Auto Commentary
Generates executive-ready narrative for each reporting day
🔒
Data Privacy
Sensitive data stays on-premise — chatbot runs on Ollama + custom LLM, zero data leaves the network
< 60s
Full pipeline runtime
3
Data domains parsed
100%
Automated · zero manual
∞
Historical playback
📱 Live dashboard output
Total Assets (YTD trend)
PBT YTD
●●●●●
▲ On track vs budget
NPL Ratio
●.●●%
▼ Within SBV limit
LDR
●●.●%
→ Monitor
CASA Ratio
●●.●%
▲ Improving
AI Forecast · Bull
●,●●● bio
Full-year PBT
What moved NPL today?
Group 3 loans in retail segment increased by ●●● bio due to…