Intern Godrej Properties Limited, North Zone
Built portfolio performance analysis for North Zone customer and collection data across all projects using SQL and Power BI, improving decision-making efficiency by 30%. Conducted trend and root-cause analysis of payment behavior and outstanding balances, supporting a 50% improvement in collection efficiency.
Developed customer segmentation and prioritization models for higher-risk segments, contributing to a 19% increase in targeted collections. Designed an interactive customer lifecycle dashboard for behavior and KPI monitoring, which was received by Head Office and entered beta testing.
Created a risk-monitoring framework covering weather, pollution, regulatory, and construction factors to support proactive decision-making. Worked directly with the North Zone Collection Head and Senior General Manager to turn analysis into business recommendations.