Deposit and Loan Analytics Platform

Built a comprehensive business intelligence solution for a leading non-banking financial institution to transform how they understood their core portfolio. The challenge was clear: scattered data across multiple systems made it nearly impossible to answer fundamental questions about deposit patterns and loan performance. I architected an end-to-end data pipeline that unified information from Oracle and SQL Server databases, designing ETL workflows in SSIS that automatically cleaned and structured millions of transaction records. The real breakthrough came in creating a multi-dimensional data model that allowed stakeholders to slice their portfolio in ways they never could before—by product type, customer demographics, geographic sectors, and temporal trends. The final Power BI dashboards became the strategic nerve center for the organization. Branch managers could now see real-time deposit flows, identify high-performing loan products, and spot emerging risks before they materialized. What once required weeks of manual analysis now happened in seconds, enabling data-driven decisions that directly improved portfolio health and customer targeting strategies.