Bank Management
System (BMS)

Project Overview

A complete banking management system that simulates core banking operations — account management, loan portfolio tracking, branch-level analytics, and transaction history reporting — built with Python and MySQL.

The system demonstrates advanced SQL query design alongside Python for data processing and CSV-based report generation.

Core Banking Modules

• Account Management — create, update, query customer accounts by type
• Loan Portfolio — track loans by type, interest, and distribution
• Transaction Processing — monthly transaction aggregation and reporting
• Branch Analytics — deposit totals and performance by branch
• Customer Intelligence — top customers ranked by account balance

SQL Query Design

The project showcases production-level SQL — complex joins, aggregations, CTEs, and window functions for business reporting. All query outputs are exported as structured CSV files for downstream analysis.

• Average balance per account type — customer segmentation queries
• Branch-wise deposit totals — geographic performance analysis
• Interest collected per loan type — revenue analytics
• Loan distribution by type — portfolio risk assessment
• Monthly transaction volume — trend analysis and reconciliation
• Top customers by balance — high-value customer identification

Python Integration

Python connects to MySQL, executes the query suite, processes results with Pandas, and exports clean CSV reports — creating a complete data pipeline from database to business report.