Back to Developers
Gunjan Kohli

Gunjan Kohli

Data Analyst

Gurgaon, Haryana 2+ yrs exp 91 · Outstanding

About

Data Analyst with 3 years of experience building data pipelines and dashboards that turn multi-source data into commercial decisions. Strong in advanced SQL and BigQuery, Python and PySpark, Looker Studio and Power BI, with domain depth in financial, commercial and market analytics. Google Cloud certified with postgraduate training in Data Science and Generative AI, skilled in cloud migration, data modelling, Key Performance Indicator (KPI) definition and stakeholder reporting.

Skills & Expertise (54)

SQL Advanced
8.5/10
3
Years Exp
Python Advanced
8.0/10
3
Years Exp
Generative AI Advanced
8.0/10
3
Years Exp
BigQuery Advanced
8.0/10
3
Years Exp
Google Cloud Platform Advanced
8.0/10
3
Years Exp
ETL Advanced
7.5/10
3
Years Exp
Pandas Advanced
7.5/10
3
Years Exp
NumPy Advanced
7.0/10
3
Years Exp
Dataflow Intermediate
7.0/10
3
Years Exp
Statistical Analysis Intermediate
7.0/10
3
Years Exp
Tableau Intermediate
7.0/10
3
Years Exp
Power BI Intermediate
7.0/10
3
Years Exp
Market Intelligence Cohort Analysis Large Language Models Prompt Engineering Retrieval-Augmented Generation AI-Assisted Development Claude Code Forecasting GitHub Copilot Dimensional Modelling Data Warehousing KPI Definition Requirement gathering Stakeholder Management Agile Scrum Jira Git GitHub Financial Analytics Apache Airflow PySpark SAS Cloud Storage Cloud Composer Cloud SQL Snowflake Databricks Postgresql MySql Cloud Migration Regression DBT ELT Data Quality Checks GitHub Actions Looker Studio LookML Advanced Excel Dashboard Design Hypothesis Testing A/B testing

Work Experience

Data Analyst

Oorja Development Solutions Pvt. Ltd.

Jun 2025 - Present

Migrated legacy spreadsheet and on-premise reporting data to Google Cloud Platform, loading 20+ source datasets into BigQuery via Cloud Storage cutting reporting latency from daily batch to near real-time. Built a centralized BigQuery data model integrating field operations, pay-per-use billing and asset-usage data for a distributed solar-energy business, using advanced SQL (window functions, CTEs, stored procedures) with partitioning and clustering to cut average query runtime by approximately 40%. Developed Python, PySpark and dbt transformations converting 5,000+ customer, metering and transaction records into version-controlled, analysis-ready tables, powering asset-utilization and unit-economics analysis that informed pricing and site-expansion decisions. Designed 5+ Looker Studio dashboards tracking asset utilization, unit profitability and debtor ageing for finance and operations leadership (5+ stakeholders), accelerating delivery with AI-assisted tooling (Claude Code).

Data Analyst

cKinetics

Sep 2024 - May 2025

Wrote advanced SQL (window functions, CTEs) and Python (Pandas, NumPy) to build reconciled market datasets from multiple external sources, tracking pricing and volume trends across clean-technology markets. Developed Power BI dashboards (DAX, Power Query) monitoring price movements and demand-supply dynamics for client market-intelligence products, replacing manual reporting and saving approximately 30 hours per month. Delivered biweekly and monthly market-intelligence reports to 3 client stakeholder groups on a fixed publication schedule.

Consultant – Data Analyst

International Institute for Sustainable Development (IISD)

Feb 2024 - Aug 2024

Built cost-benefit, regression and demand-forecasting models in Python and Excel across a 4-state, 75+ respondent primary survey, quantifying economic impact to support investment decisions. Translated government and cross-functional stakeholder requirements into KPI definitions and reporting specs; built interactive dashboards in Zoho Analytics.

Data Analyst Intern

The Council on Energy, Environment and Water (CEEW)

Jun 2023 - Sep 2023

Automated cleaning and aggregation of 75+ datasets using Python (Pandas) and SQL, reducing dataset preparation time by approximately 50%, and built district-level analytical views on large national survey data for downstream reporting.

Education

Post Graduate Program in Data Science and Generative AI - Great Lakes Institute of Management | University of Texas Austin

2025 - 2026 · Afghanistan

MA, Sustainable Development Practice - TERI School of Advanced Studies, Delhi

2022 - 2024 · Afghanistan

BA, Philosophy - Lady Shri Ram College, University of Delhi

2017 - 2020 · Afghanistan

Certifications

Google Cloud Professional Data Engineer

Google Cloud · 2025

Google Data Analytics Professional Certificate

Coursera · 2025

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 11/15
💰 Rate 0/5
🏆 Certs 5/5
✅ Verified 5/5
Total Score 91/100

Profile Overview

Member sinceOct 2026