Data Analyst | Climate & Sustainability Researcher | Policy Research

I build data-driven solutions for climate analytics, ESG reporting, labour market economics, and evidence-based policy research.

• 🌍 Climate Analytics – Risk assessment, loss & damage analysis, climate resilience
• 📊 ESG Analytics – Performance benchmarking, BRSR/IFRS reporting, sustainability metrics
• 💼 Labour Economics – Wage gap analysis, recruitment analytics, workforce intelligence
• 🤖 Data Science & ML – Predictive modeling, statistical analysis, econometrics
• 📈 Data Visualization – Power BI, Tableau, interactive dashboards
• 🗺️ Geospatial Analysis – QGIS, spatial statistics, climate mapping

B.Sc. Analytics & Sustainability Studies
Tata Institute of Social Sciences (TISS), Mumbai
Reliance Foundation Scholar

📍 Mumbai, India

🌱 Interested in: Climate Risk | Loss & Damage | ESG | Monitoring & Evaluation | Development Economics | Public Policy

🔬 Currently Learning: Advanced Machine Learning | Cloud Analytics (AWS/GCP) | MLOps | Causal Inference

Python • SQL • R • JavaScript (basic)

Pandas • NumPy • Statsmodels • Scikit-learn
Power BI • Tableau • Excel (Advanced)
Matplotlib • Seaborn • Plotly

Spatial Analysis (Moran's I, Mann-Kendall)
QGIS • GeoPandas • SPSS
Survey Design • Econometrics • Blinder-Oaxaca Decomposition

ETL Pipelines • MySQL • PostgreSQL
Data Validation • Data Cleaning
Linux • Git • GitHub

Multi-hazard risk analysis across India (2000–2024) using spatial statistics and climate data.

Repo: loss-damage-india
Tech: Python | Spatial Analysis | QGIS | Power BI | Mann-Kendall | Moran's I
Key Outputs: Interactive maps | Risk indices | Academic paper (Honours Dissertation)

View Repository →

End-to-end supply chain analytics with late-delivery prediction model (AUC: 0.81).

Repo: supply-chain-control-tower
Tech: Python | SQL | Power BI | XGBoost | Scikit-learn
Dataset: 180,519 orders across 5 global markets
Key Outputs: ML prediction model | Interactive Power BI dashboard | Academic report

View Repository →

Sector-relative ESG scoring for S&P 500 firms aligned to IFRS S1/S2, TCFD, and GRI standards.

Repo: esg-benchmarking-tool
Tech: Python | SQL | Power BI | yfinance | OLS Regression
Key Findings: Sector explains ~40% of ESG variance
Key Outputs: ESG scorecard | Peer analysis | Power BI dashboard

View Repository →

Real PLFS microdata analysis (41,913 wage workers) — gender wage gap decomposition and labour market insights.

Repo: labour-market-dashboard
Tech: Python | SQL | Power BI | Statsmodels | Econometrics
Key Findings: 22.5% raw gender wage gap | 10.3% return to schooling
Key Outputs: Mincer regression | Blinder-Oaxaca decomposition | Interactive Power BI dashboard

View Repository →

ANOVA and regression analysis of sourcing channels optimizing for ROI and hiring funnel metrics.

Repo: recruitment-channel-analytics
Tech: Python | SQL | ANOVA | Statsmodels | Seaborn
Analysis: Cost-per-hire | Yield ratio | Channel performance
Key Outputs: Statistical models | Comparative visualizations | HR dashboard

View Repository →

Jun 2025 – Aug 2025

• Cleaned and standardized a 5-year national workforce MIS database (1,200+ inconsistent records corrected)
• Automated ETL and reporting workflows — reduced turnaround from days to same-day delivery
• Built 5+ Power BI dashboards tracking workforce operations across migrant labour corridors
• Presented analytics findings to leadership and external funders (Azim Premji Foundation)

District-level multi-hazard risk index using EM-DAT, spatial analysis (Moran's I), and Mann–Kendall trend tests.
Supervised by Dr. Praveen Kumar, TISS

Mixed-methods research: 50 household surveys + 30 in-depth interviews; SDG-based assessment of housing outcomes.

Ethnographic research across 12 villages on agroecological practices, gender roles, and climate adaptation.

• Supply Chain Resilience in Global Markets – 12,000-word academic paper (Supply Chain Control Tower)
• ESG Performance in S&P 500 Firms – Journal paper draft (ESG Benchmarking Tool)
• Gender Wage Gap in India: Evidence from PLFS – Research note (Labour Market Dashboard)

• 🏆 TISS Reliance Foundation Scholar
• 📊 4+ End-to-End Analytics Projects with production Power BI dashboards
• 🔍 180,000+ records analyzed across supply chain, ESG, and labour datasets
• 📈 5+ Power BI dashboards deployed for operational decision-making
• 📝 1,200+ MIS records cleaned and validated (Aajeevika Bureau internship)

• 📧 Email: rupalrani2303@gmail.com
• 🔗 LinkedIn: Rupal Rani
• 🌐 Portfolio: rupalrani.github.io
• 📂 GitHub: github.com/rupalrani

GitHub Profile Structure

├── 📂 Climate Analytics
│   └── loss-damage-india
│
├── 📂 ESG Analytics
│   └── esg-benchmarking-tool
│
├── 📂 Labour Analytics
│   └── labour-market-dashboard
│   └── recruitment-channel-analytics
│
├── 📂 Supply Chain
│   └── supply-chain-control-tower
│
├── 📂 Data Science
│   └── [ML Projects - Coming Soon]
│
├── 📂 Power BI Dashboards
│   └── [Dashboard Templates]
│
├── 📂 GIS & Spatial Analysis
│   └── [Geospatial Projects - Coming Soon]
│
└── 📂 Portfolio
    └── rupalrani.github.io

• Climate Risk Dashboard – Real-time climate and weather data
• SDG Progress Tracker – UN Sustainable Development Goals analytics
• Carbon Footprint Calculator – Emissions tracking and visualization
• ESG Report Generator – Automated BRSR/IFRS report generation
• India Economic Dashboard – GDP, inflation, employment trends

This GitHub reflects my work as a Data Analyst and Sustainability Researcher focused on:

• Evidence-based policy analysis
• Climate resilience and risk assessment
• Labour market equity
• ESG and sustainability metrics
• Reproducible research and data storytelling

I believe in clean code, thorough documentation, and using data for social impact.

Last Updated: July 2026
Built with: ❤️ for Data, Climate, and Sustainability