CQRS read side. Projects loan lifecycle events into denormalized views optimized for dashboard queries.
Java 21, Spring Boot, Spring Kafka
| Table | Purpose |
|---|---|
loan_summary_view |
Flat view of all loans with repayment progress |
daily_stats |
Aggregated daily metrics (volume, approval rate, avg score) |
customer_360 |
Per-customer aggregates (total borrowed, repaid, credit history) |
Same as event-processor — Kafka poll locally, QStash HTTP push in cloud.