Mohammad Rabbani

Results-oriented Data Analyst with 8+ years delivering actionable insights through automated analytics and visualizations. Expert in Python, SQL, and Power BI, Google Workspace, Excel, and LCA, program evaluation. Achieved 95% reduction in data processing time in administration related data, identified $5M+ cost savings, cut error rates from 20% to <2%, and boosted program success by 45%, directly impacting 10,000+ families in AI, financial domains.

Proven translator of complex environmental and operational data into strategic decisions for Fortune 500 clients, government agencies, and NGOs.

Data Analyst & Research Consultant - Independent Practices

(2023-05)

• Led Agricultural Emissions Meta-Analysis across 12 studies: Built custom Python/WebPlotDigitizer extraction workflow with the help Google Sheets; identified soil amendment delivering 46% GHG reduction without yield loss and created reusable analytical framework now adopted by researchers.
• Engineered automated Python (Pandas) validation system for water quality monitoring: Reduced errors from 15% to <2%, digitized 20 km river dataset, and flagged pollution hotspots exceeding legal limits by 40-60% to support enforcement.
• Delivered ESG/carbon accounting and Power BI KPI dashboards for multiple SMEs using GHG Protocol: Enabled first compliant sustainability reports with audit-ready documentation and ongoing data systems.

Senior Data Analyst - Ethisol

(2021-10 - 2023-04)

• Built Python-based ETL pipelines for multi-source data: Slashed preparation time from 6 weeks to 23 days (95% reduction), raised accuracy to 99.7%, and scaled team capacity 3× without added headcount. A vast messy data was pipelined for insights and decisions (end-to-end)
• Designed Power BI carbon-emissions dashboards: Uncovered $800K carbon-credit opportunities and drove 23% supply-chain emissions reduction for a manufacturing client.
• Standardized GHG Protocol methodologies: Achieved zero audit findings (previously 2-3 per cycle) and developed 50+ scenario models evaluating cost-effective decarbonization pathways using.

Data Analyst - Sarhad Rural Support Programme (SRSP)

(2019-01 - 2020-12)

• Created centralized database integrating scattered field data across agriculture, education, and health programs: Revealed 73% success-rate variance; redesigned follow-up processes to lift overall program success by 45% using Excel and its core funtions.
• Implemented real-time validation protocols for paper-to-digital entry: Cut data errors from 20% to <5% and reduced correction time by two-thirds.
• Automated Power BI donor reports: Reduced quarterly reporting cycle from 2-3 weeks to 2-3 days with real-time visibility into household reach and economic impact with the help of VBA.

MS - Green and Sustainable Chemistry - University of Punjab (2024 - 2025)

BS - Chemistry - University of Swat (2012 - 2015)