Ananya Deshpande — Business Analyst
Pune, Maharashtra
Business analyst two years into consumer lending, sitting between branch collections teams and the engineers who build their tools. Replaced a six-hour manual delinquency pack with a dashboard that puts the same numbers in front of 40 branch managers before 8 a.m.
Experience
Business Analyst, Sanchay Credit · July 2024 – present
Collections technology group. Works between 40 branch operations teams and a six-engineer platform squad.
- Replaced a six-hour manual delinquency pack with a SQL-backed dashboard, giving 40 branch managers their bucket-wise numbers by 8 a.m. instead of mid-afternoon.
- Analysed 180,000 repayment records to show that reminder calls placed before 11 a.m. recovered 23% more than evening calls, which redrew the calling roster across every branch.
- Wrote 34 requirements for a field-collections mobile app and ran the UAT that caught 19 defects before launch; four surfaced after release.
- Maintains the requirement traceability matrix for the group, taking scope disputes at sign-off from a weekly argument to two in six months.
Associate Analyst, Merchandising, Tarangi Retail · June 2023 – June 2024
- Built the weekly stock-cover report for 62 stores, replacing three regional spreadsheets that had each counted cover differently.
- Traced ₹18 lakh of annual markdown loss to two slow-moving categories; the reorder rule written in response cut it by 61% in two quarters.
Projects
- Repayment Propensity Model — A final-year logistic model over 40,000 anonymised loan records, scoring accounts into five risk bands.
Education
- B.Sc. Statistics · Fergusson College, Pune · June 2020 – April 2023
Skills
- Analysis: SQL, Power BI, Excel modelling, Python (pandas), Cohort analysis
- Business: Requirements gathering, Process mapping, UAT planning, Stakeholder workshops, BRD writing
- Domain: Consumer lending, Collections, Retail merchandising, Credit bureau data
Certifications
- Microsoft Certified: Power BI Data Analyst Associate — Microsoft
- Tableau Desktop Specialist — Tableau
