Summary
Overview
Work History
Education
Skills
Certification
Websites
Projects
Personal Detail
Languages
Timeline
Generic

Siddhesh Parab

Mumbai

Summary

Detail-oriented Data Analyst skilled in SQL, Power BI, Python, and Excel for data visualization, modelling, and analysis. Experienced in writing complex queries, optimizing database performance, and managing ETL processes. Proficient in data wrangling, DAX queries, ETL processes and advanced analytics to transform raw data into actionable insights. Passionate about solving business problems through data-driven decision-making.

Overview

1
1
Certification

Work History

HR Data Analysis Intern

Psyliq Internship
01.2024 - 02.2024
  • Analyzed employee datasets using Excel and Power BI to uncover insights on employee demographics and income trends.
  • Developed interactive dashboards and bar charts in Power BI, improving HR's decision-making efficiency.
  • Implemented DAX formulas to analyze employee tenure, attrition trends and monthly income variations.
  • Cleaned and standardized HR data, reducing inconsistencies by 25 %, improving reporting accuracy.

Education

Data Analytics - Complete study of Data Analytics

Dvoc Institute
Mumbai
02-2025

Bachelor of Management Studies - Marketing

N. G. Acharya & D.K. Marathe College
Mumbai
04-2022

HSC - Commerce

Aryan Junior College
Mumbai
06-2019

SSC - Commerce

The Universal School
Mumbai
06-2017

Skills

  • SQL
  • Python
  • R
  • Power BI
  • Tableau
  • Advance Excel

Certification

  • Simplilearn, IBM
  • PwC Switzerland – Power BI Job Simulation – March 2025

Projects

Power BI Project - Best Restaurant Analysis

  • Designed an interactive Power BI dashboard to evaluate restaurant performance across different cities.
  • Conducted data transformation and cleansing, improving data accuracy by 30 %.
  • Created DAX measures for key metrics like average rating, cost per meal and cuisine diversity.

Power BI Project - Netflix Data Analysis Dashboard

  • Designed an interactive Power BI dashboard to analyze Netflix's movie and TV show dataset
  • Processed and visualized 8,803 titles, categorized by genre, rating, release year and country.
  • Built dynamic filters and KPIs to compare content distribution across different regions.
  • Created insightful visualizations on top genres, most popular ratings and year-wise content trends.
  • Enhanced data storytelling with DAX measures and calculated columns for key insights.

Python Project - Airline Data Analysis

  • Analyzed an airline dataset using Python for data preprocessing and exploration.
  • Used Pandas to clean, structure, and extract key statistics from the data.
  • Identified missing values and performed data wrangling for better insights.
  • Created visualizations, including pie charts, histogram to analyze demographic distributions.
  • Derived actionable insights to support data-driven decision-making in the airline industry.

SQL Project - Music Database Analysis

  • Identified the senior-most employee based on job title.
  • Analyzed invoice data to determine the countries with the highest sales.
  • Retrieved the top three highest invoice values.
  • Identified the city generating the highest revenue to plan a promotional music festival.
  • Determined the best customer based on total spending.
  • Extracted and listed Rock music listeners, ordering results alphabetically by email.
  • Identified the top 10 artists with the most Rock tracks.
  • Retrieved all tracks with a length longer than the average song duration.

Personal Detail

  • Date Of Birth: 07/08/2001
    Marital Status: Single
    Gender: Male
    Hobbies: Listening Music, Cricket, Chess

Languages

English
First Language
Hindi
Proficient (C2)
C2
Marathi
Proficient (C2)
C2

Timeline

HR Data Analysis Intern

Psyliq Internship
01.2024 - 02.2024

Data Analytics - Complete study of Data Analytics

Dvoc Institute

Bachelor of Management Studies - Marketing

N. G. Acharya & D.K. Marathe College

HSC - Commerce

Aryan Junior College

SSC - Commerce

The Universal School
Siddhesh Parab