sanchay rohad

Data Analyst | Data Engineer |

[email protected] +91 8624055172

Resume

Hello, I am

sanchay rohad.

3

PowerBI
Projects

2

Python
Projects

About Me

Hello!
I'm Sanchay, currently working as R&D Software Engineer Specialist at Dassault Systemes.

A versatile professional with a strong background in real time data analysis using kibana , statistics and problem-solving, I'm here to turn complex data into clear insights.

I am passionate about diving into data, uncovering patterns, and making data-driven decisions. Aspiring to transition into a Data related role to harness my analytical skills for even greater impact.

Thanks for visiting my portfolio. Let's discover the exciting world of data side by side. Can't wait to show you what I can do!

Key Skills

sql

Python

Pandas

Data Analysis

Problem-Solving

kibana

My Projects

Most Streamed Spotify Songs 2023 Analysis

Shield Insurance Analysis

Domain/Function: Insurance

LokSabha Elections 2014 vs 2019 analysis

Domain/Function: Data Analysis

T20 WorldCup 2024 Insights

Domain/Function: Data Analysis

Skyline Analytics: Airline Data Trends

Domain/Function: Data Analysis

My Experience

Dassault Systemes - R&D Specialist Software Engineer(SDE-2) Aug 2022 - Present
• Worked on development of MakeByMe app (previously 3DByMe) for creating furniture and DIY products.

• Developed data visualizations in Kibana to analyze new user trends, error reports, and global browser usage, enhancing decision-making.

• Leveraged Grafana for performance monitoring and data visualization to support actionable insights in data analysis.

• Collaborated on developing an AI-powered PWA app, and analyzed 100,000+ data entries to optimize models for generating custom furniture designs.

• Created 10+ major features and Won Best Idea award in SolidWorks Hackathon by DS out of 250 teams..

Atliq Technologies(CodeBasics) - Data Analyst Intern Jan 2024 - July 2024
• Performed data variance analysis and debugged SQL queries to ensure 100% accuracy on data extraction from MySQL workbench.
• Applied advanced data cleaning and data normalization techniques to maintain data integrity and optimize data retrieval processes.
• Conducted ad-hoc analysis and designed customized dashboards using Power BI, improving data visualization and increasing involvement by 35%.

Awards & Certificate

Get Job Ready: Power BI Data Analytics for All Levels 3.0

SQL Beginner to Advanced For Data Professionals

Data Analytics Bootcamp 4.0: With Practical Job Placement Support + AI for Data Analysts

Microsoft Certified: PowerBI Data Analyst Associate

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

Mail Me

[email protected]

https://www.linkedin.com/in/sanchayr/

Call Me

+91 8624055172

GitHub

https://github.com/SanchayRohad

Python Project

Most Streamed Spotify Songs 2023 Analysis

Analyzed Spotify streaming data for 2023, identifying trends and patterns in over 10 million data points to determine the year’s most streamed songs.

View Project
on GitHUB

Detailed Dashboard of Analysis

Detailed Analysis on January month

Project Details

Analyzed Spotify streaming data for 2023, identifying trends and patterns in over 10 million data points to determine
the year’s most streamed songs.
• Integration of ChatGPT for enriching Spotify data with Python code.Implemented Spotify’s API to automate
retrieval of album cover image URLs, streamlining the data gathering process and enhancing data richness for user
interface designs.
• Developed interactive HTML-based dashboards with advanced data visualization, improving presentation clarity and
stakeholder engagement by 35%.
• Applied glass morphism design principles in UI backgrounds to elevate aesthetic appeal, increasing user interaction
time by 15%.
• Created KPI cards and heat maps for detailed data analysis, facilitating quicker decision-making by providing
concise, at-a-glance insights into streaming trends and patterns.

PowerBI Project

Shield Insurance Analysis

Domain/Function: Insurance

The project was part of my internship as a data analyst. I conducted a thorough analysis using a live Power BI dashboard and delivered a presentation.

View Project
Engagement

View Project
on GitHUB

General view of shield insurance analysis.

Sales mode view of shield insurance analysis.

Project Details

Objective: Conduct thorough examination of customer growth and revenue patterns at Shield Insurance Company.
Focus Areas:
Customer behavior
Revenue generation
Geographical distribution
Age group-based statistics
Goals:
Extract significant insights into the company's performance.
Provide valuable data-driven insights for informed decision-making.
Ensure Shield Insurance Company maintains its market position with reliable coverage and comprehensive protection.

Project video

Live Interactive Dashboard

PowerBI Project

LokSabha Elections 2014 vs 2019 analysis

Domain/Function: Data Analysis

AtliQ Media is a private media company and they wanted to telecast a show on Lok Sabha elections 2024 in India. Unlike other channels they do not want to have a debate on who is going to win this election, they rather wanted to present insights from 2014 and 2019 elections

View Project
on GitHUB

% Split of votes of parties between 2014 vs 2019 at state level

Top 5 constituencies of 2014 and 2019 in terms of voter turn out ratio

Project Details

Used Real Data :- https://www.eci.gov.in/statistical-reports
Used Tools and Language:- Excel, SQL, PowerBI

Live Interactive Dashboard

PowerBI Project

T20 WorldCup 2024 Insights

Domain/Function: Data Analysis

This project involved scraping detailed match, player batting, and bowling data from over 100 ESPN Cricinfo matches. I cleaned and transformed 10,00+ records using Pandas to ensure accuracy. designed 10+ interactive Power BI dashboards, leading to a 30% improvement in selecting the best playing 11.

View Project
on GitHUB

Front Page of Dashboard Showing Analysis on Openers

Player Summary Info Page Design

Project Details

• Scraped data from ESPN Cricinfo, extracting detailed match, player batting, and bowling data from 100+ matches.
• Cleaned and transformed 10,00+ data records using Pandas to ensure data accuracy and consistency.
• Designed and implemented 10+ interactive dashboards in Power BI, transforming complex data sets into actionable insights; increased
reporting efficiency by 50% and enabled data-driven decision-making across three departments..
• Analyzed player performance, match results, and team statistics, leading to a 30% improvement in selecting the best playing 11.

Live Interactive Dashboard

Python Project

Skyline Analytics: Airline Data Trends

Domain/Function: Data Analysis

This project delves into airline data to uncover insights for optimizing occupancy rates and enhancing profit per seat. Using Seaborn, Matplotlib, Pandas , SQL and Python, it includes data exploration, visualization, and recommendations for operational improvements.

View Project
on GitHUB

View Project
on Skyline Analytics: Airline Data Trends

This barchart shows number of seat for particular aircraft- code

Class wise Average Flight Prices. Given Classes:- Business, Economy And Comfort

Project Details

The Airlines Data Analysis project aims to enhance airline performance by analyzing data on flight operations, seat occupancy, and financial metrics. Key components include:

Data Collection: Gathering datasets on flights, seat usage, and finances.
Data Cleaning: Handling missing values and inconsistencies.
Exploratory Data Analysis (EDA): Using SQL and Python to identify trends and correlations.
Visualization: Creating interactive charts to present findings.
Insights and Recommendations: Offering strategic suggestions to improve occupancy rates and profitability.
The project delivers actionable insights for optimizing operational efficiency and boosting revenue.