Back to Developers
Deepak Patel

Deepak Patel

Data Analyst Intern

Dhanbad, India $10/hr
85
Profile Score

About

“IIT Dhanbad Graduate | Data Analyst | Python | SQL | Excel | Power BI | Immediate Joiner”

Skills & Expertise (26)

MS Excel Advanced
7.4/10
2
Years Exp
Python Intermediate
7.1/10
1
Years Exp
Power BI Intermediate
6.8/10
1
Years Exp
Experiment Design C++ A/B testing JOINs in SQL CRUD Operations Exploratory Data Analysis (EDA) XLOOKUP VLOOKUP Data Visualizing Data Analysing Data Extraction Web Scraping Preprocessing Data Cleaning Jira Jenkins AWS Docker MS Word MS PowerPoint GitHub Git MySql

Work Experience

Data Analyst Intern

Enerjazz

Jun 2024 - Jul 2024

Collected, integrated, and standardized large primary and secondary datasets on solar panel installation companies across the Delhi NCR region, including battery demand distribution, pricing benchmarks, capacity utilization, installation scale, and operational constraints. Executed advanced exploratory data analysis (EDA), data cleaning, normalization, and feasibility modeling in Excel using Pivot Tables, VLOOKUP/XLOOKUP, conditional logic, and calculated KPIs such as demand forecasts, price competitiveness index, utilization rate, and capacity alignment metrics. Designed and delivered comprehensive Excel reports and interactive Power BI dashboards to perform trend analysis, cohort-based installer segmentation, scenario comparison, and decision-support analytics, enabling data-driven evaluation of Enerjaaz’s solar battery expansion strategy.

Education

B.Tech in Chemical Engineering - Indian Institute of Technology (ISM) Dhanbad

- 2025 · Afghanistan

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 5/15
💰 Rate 5/5
🏆 Certs 0/5
Verified 5/5
Total Score 85/100

Profile Overview

Member sinceMar 2026

Availability Details

Visa Status

Citizen

Relocation

Open to Relocation

Skills (26)

MS Excel Python Power BI Experiment Design C++ A/B testing JOINs in SQL CRUD Operations Exploratory Data Analysis (EDA) XLOOKUP +16 more