- 🎓 Final year BS in Analytics & Sustainability Studies at Tata Institute of Social Sciences (TISS), Mumbai (2026) — Reliance Foundation Undergraduate Scholar
- 💼 Data Analyst @ Aajeevika Bureau (India LabourLine) — Cleaned 5-year national MIS datasets, automated ETL workflows, built Power BI dashboards presented to Azim Premji Foundation
- 🔭 Building an end-to-end analytics portfolio spanning labour economics, ESG finance, supply chain, and climate risk
- 🌱 Skilled in Python · R · SQL · Power BI · Tableau · QGIS · SPSS
- 🎯 Targeting roles in Data Analytics, Climate Finance & Social Development Research
- 📫 rupalrani2303@gmail.com | 📞 +91 7654330705
- 🌍 Based in Mumbai, Maharashtra
Programming & Analytics
Visualization & BI
GIS & Research Tools
- Cleaned and standardized a 5-year national workforce MIS database (Python + SQL + Excel), correcting 1,200+ inconsistent records
- Automated ETL and reporting workflows, reducing turnaround time from days to same-day delivery
- Built 5+ Power BI dashboards tracking workforce operations, KPIs, and complaint resolution across migrant labour corridors
- Presented analytics findings to leadership and external funders, including Azim Premji Foundation
| # | Project | Domain | Tools | Key Result |
|---|---|---|---|---|
| 1 | 📦 Supply Chain Control Tower Dashboard | Logistics & Operations | Python · SQL · Power BI · ML | Late-delivery prediction model (AUC 0.81) across 180,519 orders in 5 global markets |
| 2 | 🎯 Recruitment Channel Effectiveness Analytics | HR & Workforce Analytics | Python · SQL · ANOVA · Regression | ANOVA + regression pinpointing top sourcing channels by cost-per-hire, yield ratio & quality |
| 3 | 🌿 ESG Performance Benchmarking Tool | Sustainable Finance | Python · SQL · Power BI · Sustainalytics | Sector explains ~40% of ESG score variance; framework aligned to IFRS S1/S2, TCFD & GRI |
| 4 | 🏛️ Labour Market Intelligence Dashboard | Development Economics | Python · SQL · Power BI · Econometrics | Real PLFS microdata (41,913 workers): 22.5% raw gender wage gap, 99.7% unexplained by Blinder-Oaxaca; 10.3% return to schooling |
| Project | Tools | Description |
|---|---|---|
| 🌡️ Loss & Damage Index — India (2000–2024) (Honours Dissertation) | Python · QGIS · EM-DAT | District-level multi-hazard climate risk index integrating flood, cyclone, heatwave & drought data; Mann–Kendall trend tests + Moran's I spatial analysis |
| 🏠 Urban Housing Outcomes Study — Varanasi | SPSS · Mixed Methods | 50 household surveys + 30 in-depth interviews; SDG-based assessment of Kanshiram Awas Yojana beneficiary outcomes |
| 🌾 Women-Led Climate-Resilient Farming — Osmanabad | Ethnography · Fieldwork | 12-village ethnographic study of women-led agroecological practices and gender dimensions of climate adaptation |
- Women-Led Climate-Resilient Farming, Osmanabad (2023) — Ethnographic research across 12 villages; analysed gender roles, rural livelihoods, and SDG-linked sustainability outcomes in Maharashtra
- Urban Sustainability & Housing, Varanasi (2024) — Mixed-methods study on housing and social exclusion under Kanshiram Awas Yojana; 50 household surveys and 30 interviews
"Without data, you're just another person with an opinion." — W. Edwards Deming