Codebasics Logo

Powered by
Codebasics DA Bootcamp

Home

About

Projects

Experience

Contact
Hello, I am

Vipul Patil

Senior Data Analyst
Resume
Vipul Patil

2

PowerBI
Projects

1

Python
Project

About

Me

Results-driven Senior Data Analyst with 5.5 years of experience across reliability, asset management, and sports technology industries. Proven track record in scaling user engagement and retention, having grown app installs from 400 to 60k+ and active users from 370 to 9500+. Skilled in Power BI, SQL, Python, and advanced Excel, with expertise in creating comprehensive dashboards and data-driven solutions. Demonstrated success in optimizing business processes and maintenance schedules through detailed analytical insights and KPI tracking. Strong background in sports analytics and equipment reliability metrics.

Key

Skills

SQL

Python

Advanced Excel

My

Projects

AtliQ Hardware BI 360
AtliQ Hardware BI 360

Domain/Function: Manufacturing Industry

Designed a multi-view dashboard in Power BI for 6 departments (sales, finance, supply chain, executive, marketing, and products) of AtliQ hardware to understand sales trends, and facilitate data-driven decisions that scaled the business processes by 10%.

See My Work PowerBI
IPL match analysis - Venue, run rate, game changing overs
IPL match analysis - Venue, run rate, game changing overs

Domain/Function: Sports Analytics

Pre-match analysis report of match -23, CSK vs SRH of IPL 2021 at Arun Jaitley Stadium. It is a night game, CSK has started the tournament well and poses a big challenge to SRH.

See My Work Python
Zomato delivery analysis
Zomato delivery analysis

Domain/Function: E-commerce

Unpacking Zomato's Dominance: Analyzing sales, user behavior, and market trends across Indian cities. Examined millions of orders to reveal key growth drivers, identify emerging markets, and understand consumer preferences.

See My Work PowerBI

My

Experience

Data Analyst, GoPllay, Pune                                                                                                                                                   Jan 2023 - Present

●       Helped in scaling the app installs across various OS (iOS and Android) from 400 to 60k+ by analyzing the user demographics, user behavior, etc.

●       Increased the active user count from 370 to 9500+, indicates the user retention rate. This result was achieved using extensive analysis of the Google Analytics data.

●       The active user to total app installs ratio increased to 38%. This indicates that the app has sufficient features to keep the user engaged.

Associate Data Analyst, Sportz Interactive, Mumbai                                                                                                          Oct 2022 – Jan 2023

●       Created pre-match and post-match analysis reports for Sports18, India’s official FIFA World Cup 2022 broadcaster.

●       Analyzed data of 32 teams across 8 groups of around 350+ players.

Data Analyst, Asset Analytix, Pune                                                                                                                                    Jan 2022 – Oct 2022

●       Helped to optimize the maintenance schedule of various machinery in the Honda, 3M, and Ellie Lily plants.

●       Used metrics like Mean Time to Failure (MTTF), Mean Time to Recovery (MTTR), and Mean Time between Failure (MTBF) by collecting the data from the MS SQL server.

Junior Data Analyst, Ananta Infotech, Pune                                                                                                                        Jul 2019 – Jan 2022

●       Helped to create data analytics course content based on Excel, SQL, and Power BI for the company.