SmartRefi: GPA-Based Student Loan Refinance Platform
Designed a normalized MySQL database to model a GPA-based student loan refinancing system and built analytical queries to evaluate lender pricing and refinance behavior.
Tech: MySQL · SQL · Python · MongoDB · Data Modeling
Approach
- Designed a normalized relational schema to model borrowers, lenders, and offers.
- Implemented pricing logic to evaluate refinance eligibility.
- Analyzed borrower outcomes to quantify interest rate improvements.
Results
Entity-relationship model defining borrowers, lenders, offers, and refinance contracts.
System-level UML diagram showing application and data flow.
Relationship between borrower GPA and offered interest rates.
Interest rate improvement achieved through refinancing.
Lender participation and disbursement distribution.