Bhavan V

Data Analyst

[email protected] +91 06381513364

Resume

Hello, I am

Bhavan V.

1

Excel
Project

1

PowerBI
Project

1

SQL
Project

1

Python
Project

About Me

I am a passionate Data Analyst with a strong foundation in Python, SQL, and Power BI, equipped with hands-on experience in data analysis, visualization, and business intelligence. With a background in Electrical and Electronic Engineering from Sathyabama University, I specialize in transforming complex datasets into actionable insights that drive business decisions. I have worked on projects involving financial analysis, supply chain optimization, and business performance improvement, delivering measurable results like increasing revenue and enhancing operational efficiency.

With a continuous drive to learn and grow, I hold the Google Advanced Data Analytics Professional Certificate and am eager to apply my skills to real-world challenges in data science and business analytics.

Key Skills

Data Analysis & Manipulation: Python (Pandas, NumPy, SciPy), SQL

Data Visualization: Power BI, Python (Matplotlib, Seaborn, Plotly)

Databases: MySQL, Microsoft SQL Server

Advanced Excel: Pivot Tables, VLOOKUP, Power Query

Statistical Analysis: Hypothesis Testing, Regression Analysis

My Projects

Sales Analytics(FMCG)

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

Finance and Supply Chain Analytics of AtliQ Hardwares

Hospitality Domain Data Analysis

My Experience

Data Analyst (Simulation) - Accenture
Mar 2024

Completed a simulation focused on advising a hypothetical social media client as a Data Analyst at Accenture.
Cleaned, modelled and analyzed 7 datasets to uncover insights into content trends to inform strategic decisions.
Prepared a PowerPoint deck and video presentation to communicate key insights for the client and internal stakeholders.

Awards & Certificate

Excel: Mother of Business Intelligence

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

SQL Beginner to Advanced For Data Professionals

Python: Beginner to Advanced For Data Professionals

Google Advanced Data Analytics

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/bhavanvs/

Call Me

+91 06381513364

GitHub

https://github.com/Bhavanvs

Excel Project

Sales Analytics(FMCG)

Created 2 reports for the sales team which will help them to evaluate customer performance and understand their market performance concerning their target.

View Project
Engagement

View Project
on GitHUB

Provides net sales performance of each customer across years

Market performance vs Target report across years: Enables stakeholders to assess the country's performance and compare it to set targets.

Project Details

In this project, I created a sales report using Excel pivot tables which will enable businesses to determine effective customer discounts, facilitate negotiations with consumers, and identify potential business expansion opportunities in promising countries. The reports generated will provide actionable insights and recommendations for businesses to optimize their sales strategies, enhance customer satisfaction, and maximize revenue generation.

I have learned the following:

1. Pivot table
2. Power Query
3. DAX (Basics)
4. Conditional Formatting
5. Report Beautification
6. Sales Domain Metrics

Overall, this project aims to empower businesses with the necessary tools and insights to monitor, evaluate, and enhance their sales activities. By leveraging sales data analysis, businesses can unlock new opportunities, drive growth, and stay competitive in the dynamic market landscape.

PowerBI Project

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

AtliQ Hardware is a consumer electronics company expanding rapidly but cannot compete with other companies using data as most of their reports still exist in Excel. My goal is to implement an advanced analytics solution using Power BI that will enable the company to get insights and make in

View Project
Engagement

View Project
on GitHUB

User-empathetic landing page as a part of dashboard design

Data modelling involving 10+ tables

Project Details

In this project, the goal is to create one report that could be used by stakeholders from sales, marketing, finance and executive team. The focus is made on the following

1. Robust Data Modeling
2. User-empathetic Report design
3. Drillable Insights

I learned the following things in this project

1. Power Query (Basic and Advanced Operations)
2. Basic and complex DAX formulas
3. Data modelling involving 10+ tables
4. Choosing the right visuals and formatting
5. Dashboard designing principles
6. Using bookmarks
7. Deploying in Power BI service
8. Stakeholder Feedback Implementation
9. Sales, Marketing, Finance & Supply Chain metrics

Live Interactive Dashboard

SQL Project

Finance and Supply Chain Analytics of AtliQ Hardwares

Transformed AtliQ Hardware's operations with MySQL analytics. Enhanced decision-making, streamlined processes, and uncovered crucial insights in sales, products, and markets. Skills: SQL functions, views, procedures, window functions, and data integrity.

View Project
Engagement

View Project
on GitHUB

Crafted monthly sales report for Croma India, empowering informed decisions & client relations.

Utilized SQL to identify top 5 markets by net sales in FY 2021, guiding strategic decisions for sales optimization & market expansion.

Project Details

Project Title: Atliq Hardware Finance & Supply Chain Analytics

Overview:Transformed finance and supply chain analytics at Atliq Hardware using MySQL. Analyzed sales, products, customers, and regional data to drive critical insights.

Focus Areas: Dynamic sales reporting, market trend analysis, customer behavior patterns, predictive supply chain forecasting.

Skills Demonstrated: Custom functions, database views, stored procedures, advanced window functions, temporary table management, database indexes, data integrity.

Key Insights: Amazon led net sales at 109.03M in FY21, followed closely by AtliQ Exclusive at 79.92M. India dominated with net sales of 210.67M, while the USA followed at 132.05M. Amazon's share of total net sales stood at 13.23% in FY21.

Outcome: Enhanced decision-making processes and streamlined operations, enabling Atliq Hardware to leverage data-driven strategies for sustainable growth.

Project video

Python Project

Hospitality Domain Data Analysis

Conducted a data analysis project for AtliQ Hotels, a luxury hotel chain, using Python and Jupyter Notebook. Analyzed business data from May to August 2022 to uncover trends in occupancy, revenue, and service quality, providing actionable insights for strategic decision-making.

View Project
Engagement

View Project
on GitHUB

Creating an occupancy percentage column in the dataset by dividing successful bookings by capacity and converting it into a percentage using Python.

Pie chart showing revenue realized per booking platform, using Python to group and sum revenue data by each platform.

Project Details

This project involved conducting a comprehensive data analysis for AtliQ Hotels, a luxury hotel chain operating in major Indian cities such as Mumbai, Delhi, Hyderabad, and Bangalore. The goal was to analyze historical business data from May to August 2022 to uncover key trends and provide actionable insights. I utilized Python and Jupyter Notebook for data import, exploration, cleaning, transformation, and analysis. The process involved removing negative values and outliers, merging and aggregating data, and applying statistical functions to extract meaningful insights. The analysis revealed higher occupancy rates on weekends, Mumbai leading in revenue generation, and consistent average ratings with areas for improvement in service quality. These findings were compiled into a detailed report and presented using PowerPoint. This project enhanced my skills in data analysis, statistical functions, and visualization using Python, highlighting the importance of data quality