Sustainability Data Analyst & Research Assistant
I turn environmental, climate and scientific data into evidence: carbon accounting, life cycle assessment, meta-analysis, data validation and reporting, using Python, SQL, Power BI and Excel.
Every featured project is reproducible and tested automatically on GitHub Actions (Python 3.11 and 3.12). Datasets are seeded, so every number can be regenerated and checked.
| Project | What it shows | Status |
|---|---|---|
| meta-analysis-nitrogen-inhibitors | MetaWin/metafor-style meta-analysis: REML + Knapp-Hartung, meta-regression, publication bias (Egger, trim-and-fill); validated against metafor's BCG benchmark | |
| lca-beverage-packaging | ISO 14040/44 comparative LCA, IPCC AR6, 10,000-run Monte Carlo, break-even and sensitivity analysis | |
| carbon-accounting-sbti | GHG Protocol inventory (Scopes 1-3, dual Scope 2), SBTi target tracking, LMDI decomposition | |
| esg-emissions-tracking | TCFD-aligned tracking: Scope 1-2 metrics, 2030 target path, carbon-price exposure, data-quality checks | |
| ghg-carbon-dashboard | Scope 1-3 dashboard with supplier scenario and marginal abatement cost curve | |
| water-quality-validation | Rule-based and statistical data validation (precision 93.3%, recall 90.1%) | |
| emissions-etl-pipeline | ETL from CSV, Excel and JSON sources with reconciliation checks | |
| ngo-report-automation | Automated donor reporting with significance testing | |
| tree-survival-tracker | Kaplan-Meier survival analysis with log-rank tests |
- Pakistan-climate-analysis: climate vulnerability trends, 1981-2023
- Pakistan-air-quality-modeling: spatial-temporal PM2.5 analysis
- churn-intelligence: XGBoost, SHAP, SQL and Power BI churn analytics
- academic-reference-heatmap: citation-overlap mapping for literature reviews
- SQL-Global-Deforestation-Analysis: deforestation vs CO2 emissions in SQL
Runnable notebooks: kaggle.com/rabbani0123
Tools: Python (pandas, NumPy, SciPy, matplotlib) · SQL · Power BI · Excel/VBA · WebPlotDigitizer · MetaWin