RR

Rupal Rani

Data Analyst · Sustainability & Development Research · TISS Mumbai '26

Labour Economics Climate Finance ESG Analytics Supply Chain Python · SQL · Power BI · Tableau
⭐ GitHub 💼 LinkedIn ✉️ Email
About

Turning Data into Decisions

I'm a final-year BS Analytics & Sustainability Studies student at TISS Mumbai (Reliance Foundation Scholar) with hands-on experience as a Data Analyst at Aajeevika Bureau's India LabourLine, where I cleaned 5-year national MIS databases and built Power BI dashboards for migrant labour analytics.

My work sits at the intersection of data science and social impact — from quantifying India's gender wage gap using PLFS microdata, to building ESG benchmarking tools aligned to IFRS S1/S2 and TCFD, to mapping climate-risk hotspots from EM-DAT district-level data.

I'm actively seeking roles in Data Analytics, Climate Finance, and Development Research.

4
End-to-End Projects
180K+
Orders Analysed
5+
Power BI Dashboards
1,200+
MIS Records Cleaned

Portfolio

Projects

📦

Supply Chain Control Tower Dashboard

AUC 0.81 · 180,519 Orders · 5 Global Markets

End-to-end supply chain analytics using the DataCo dataset. Built a late-delivery prediction model and an interactive Power BI control tower dashboard. Backed by a 12,000-word academic report with 72 APA 7 references.

PythonSQL Power BIXGBoost Scikit-learn
View →
🎯

Recruitment Channel Effectiveness Analytics

ANOVA · Regression · Cost-per-Hire · Yield Ratio

Statistical analysis of sourcing channels using ANOVA and OLS regression across cost-per-hire, yield ratio, performance, and satisfaction metrics to identify the highest-ROI recruitment strategies.

PythonSQL ANOVAStatsmodels Seaborn
View →
🌿

ESG Performance Benchmarking Tool

Sector explains ~40% of ESG variance · IFRS S1/S2 · TCFD · GRI

Sector-relative ESG scoring framework for S&P 500 firms using Sustainalytics + Yahoo Finance data. Aligned to IFRS S1/S2, TCFD, and GRI. Includes a journal paper draft targeted at Finance Research Letters.

PythonSQL Power BIyfinance OLS Regression
View →
🏛️

Labour Market Intelligence Dashboard

22.5% Raw Gender Wage Gap · 99.7% Unexplained · Real PLFS Microdata

Analysis of real PLFS 2022–23 microdata (41,913 wage workers). Mincer regression finds a 10.3% return to schooling; Blinder-Oaxaca decomposition shows the gender wage gap is overwhelmingly a "returns" story, not a "characteristics" story.

PythonSQL Power BIStatsmodels Econometrics
View →

Experience

Work

Data Analyst Intern
Aajeevika Bureau — India LabourLine, Mumbai
Jun 2025 – Aug 2025

Academic & Field Research

Research

🌡️ Honours Dissertation

Loss & Damage from Extreme Climate Events in India (2000–2024)
District-level multi-hazard risk index using EM-DAT, EM-DAT spatial analysis (Moran's I) and Mann–Kendall trend tests. Supervised by Dr. Praveen Kumar, TISS.

🏠 Urban Housing Study

Kanshiram Awas Yojana, Varanasi (2024)
Mixed-methods study: 50 household surveys + 30 in-depth interviews; SDG-based assessment of housing outcomes under a state-funded scheme.

🌾 Climate-Resilient Farming

Women-Led Agriculture, Osmanabad (2023)
Ethnographic research across 12 villages on women-led agroecological practices, gender roles in climate adaptation, and rural livelihoods.


Technical Skills

Skills

Programming

PythonRSQL/MySQL PandasNumPy Scikit-learnStatsmodels

BI & Visualisation

Power BITableau Advanced Excel MatplotlibSeaborn

Data Engineering

ETL PipelinesData Cleaning Relational DBsData Validation

Research & GIS

QGISSPSS Spatial Analysis Survey DesignEconometrics