Dhiraj kumar

Data Analyst

Gurgaon, Haryana 1+ yrs exp 82 · Excellent

About

Results-driven Data Analyst with 1+ years of experience in data analysis, reporting, and business intelligence. Skilled in SQL, Excel, Power BI, Python, and Statistics for extracting insights, building dashboards, and optimizing business performance. Experienced in analyzing large datasets, ensuring data quality, and automating reporting workflows. Adept at transforming complex data into meaningful visualizations and actionable recommendations for business stakeholders.

Skills & Expertise (39)

Python Intermediate

6.5/10

Years Exp

Pandas Intermediate

6.5/10

Years Exp

NumPy Intermediate

6.5/10

Years Exp

Power BI Intermediate

6.5/10

Years Exp

Excel Intermediate

6.5/10

Years Exp

Data Cleaning Intermediate

6.5/10

Years Exp

Descriptive Statistics Intermediate

6.5/10

Years Exp

Statistics Intermediate

6.5/10

Years Exp

Data Analysis Intermediate

6.5/10

Years Exp

Data Validation Intermediate

6.5/10

Years Exp

Exploratory data analysis Intermediate

6.5/10

Years Exp

Hypothesis Testing Intermediate

6.5/10

Years Exp

Data Preprocessing Intermediate

6.5/10

Years Exp

SQL Intermediate

6.5/10

Years Exp

Web Scraping Intermediate

5.5/10

Years Exp

BeautifulSoup Intermediate

5.5/10

Years Exp

Selenium Intermediate

5.5/10

Years Exp

Docker Compose Beginner

4.5/10

AWS EC2 Beginner

4.5/10

PySpark Beginner

4.5/10

FastAPI Beginner

4.5/10

Docker Beginner

4.5/10

BigQuery Beginner

4.5/10

PyTorch Beginner

3.5/10

Streamlit Beginner

3.5/10

FAISS Beginner

3.5/10

SBERT Beginner

3.5/10

Groq Beginner

2.5/10

MLOps Beginner

2.5/10

MLflow Beginner

2.5/10

Predictive Analytics Beginner

2.5/10

Regression Beginner

2.5/10

Classification Beginner

2.5/10

Clustering Beginner

2.5/10

LLM Applications Beginner

2.5/10

RAG Beginner

2.5/10

ETL Pipelines Beginner

2.5/10

Forecasting Beginner

2.5/10

KPI Analysis Beginner

2.5/10

Work Experience

Business Analyst

Startup Stairs

Mar 2025 - Feb 2026

Extracted and structured 8–10K+ records using advanced SQL queries (JOIN, GROUP BY, aggregations), reducing manual reporting effort by 30%. Leveraged Python (Pandas, NumPy) to execute data validation and exploratory data analysis (EDA), enhancing data integrity by 30% and ensuring high-accuracy business reporting. Automated reporting workflows using Excel and Power BI dashboards, cutting weekly/monthly manual effort by 25% and improving decision turnaround time. Developed automated web scraping pipelines using Selenium and BeautifulSoup to collect, clean, and structure data for analytical reporting. Applied statistical analysis and data preprocessing techniques to improve data reliability and reporting accuracy. Partnered with cross-functional teams to convert business requirements into analytical solutions and actionable data-driven insights.

Business Analyst Intern

Bajaj Capital

Apr 2024 - Jun 2024

Analyzed investment datasets of 50+ clients to identify portfolio performance trends and behavioral patterns, enabling data-driven mutual fund recommendations. Designed and automated Excel dashboards to monitor fund performance and generate actionable sales insights. Conducted portfolio trend analysis to support informed financial decision-making and client advisory strategies.