Portfolio - Bhuvana M

Bhuvana M

Data Analyst

Resume

1

Excel Project

3

PowerBI Projects

1

SQL Project

About Me

I’m Bhuvana, a dynamic Data Analyst in the making, fueled by an insatiable passion for deciphering the language of data.
🔍 Proficient in unravelling insights with Excel and Power BI, I thrive on transforming raw data into strategic gems.
🚀 While my academic roots lie in Computer Science, I discovered my innate talent for data analysis - a journey that feels more like destiny.
💼 Despite lacking formal work experience, my portfolio showcases a series of impactful business projects where I’ve flexed my analytical muscles.
📊 Embark on an exhilarating expedition through my portfolio, where each project narrates a unique tale deciphered from data.
🌐 Eager to bring a fresh, innovative perspective to your team, I turn every data point into an opportunity for strategic brilliance. Enthusiastic, exciting to work with, and eager to learn new things. Let’s dive into the world of data together! 🚀✨

Key Skills

Problem Solving

Effective Communication

Analytical Thinking

Time Management

MySQL

My Projects

Empowering Sales and Finance Excellence

Business Insights 360

Credit Card Innovation: Mitron Bank

AtliQ Grands Market Analysis

Consumer Goods Ad-hoc Analysis

My Experience

With a strong background in teaching, and a commitment to continuous learning, my professional journey reflects a blend of practical experience and dedicated self-improvement.

Secondary Computer Teacher

- Taught computer science subjects to secondary school students, fostering a strong understanding of fundamental concepts.

- Developed and implemented lesson plans, curricula, and assessments, enhancing students' learning experiences and outcomes.

- Mentored students in practical applications of computer science, including programming and database management.

Competitive Exam Preparation, Self-Study

- Dedicated over five years to rigorous self-study in preparation for competitive exams.

- Developed strong analytical and problem-solving skills, essential for data analysis and teaching.

- Gained a deep understanding of various subjects, contributing to overall knowledge and expertise in the field.

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.

Download Resume

Resume

Mail Me

[email protected]

https://www.linkedin.com/in/m-bhuvana/

Call Me

+91 8220117521

GitHub

https://github.com/bhuvi89

Excel Project

Empowering Sales and Finance Excellence

Optimize business strategies with customer-centric insights through comprehensive Customer Performance Assessment. Drive informed decisions with Market Performance Comparison and enhance financial visibility through precise Profit and Loss Reports, both globally and segmented by markets.

View Project
Engagement

View Project
on GitHUB

This report shows the customer performance

This report shows Profit and Loss for Markets.

Project Details

In this integrated Sales and Finance Reporting Project, I utilized Excel pivot tables to provide businesses with vital insights. The sales reports offer actionable strategies for optimizing customer discounts, identifying growth opportunities in new markets. Simultaneously, in the finance realm, I developed accurate financial reports, optimizing expense analysis for efficient resource allocation, and identifying areas for profit maximization.
Skills Acquired:
• Pivot Table Utilization
• Power Query Capabilities
• DAX Fundamentals
• Conditional Formatting Mastery
• Enhanced Data Presentation
• Proficiency in Sales and Finance Metrics
• Forecasting Techniques
• Budget Analysis
The focus is on empowering businesses with essential tools for enhancing sales efforts, improving customer satisfaction, making informed financial decisions, and ensuring long-term financial stability.

PowerBI Project

Business Insights 360

Transforming AtliQ Hardware's analytical landscape with Power BI, this project dives deep into financial, sales, marketing, and supply chain domains. Unleash actionable insights for informed decisions and future success.

View Project
Engagement

View Project
on GitHUB

Data Model

Executive View

Project Details

Financial View:
 Analyze Profit and Loss statements.
 Track Net Sales Performance trends.
 Identify top-performing Products and Customers.
Sales View:
 Create Sales Trends based on Net Sales and Gross Margin.
 Build visuals for Net Sales and Gross Margin percentages.
Marketing View:
 Assess product performance using metrics like Net Sales and Gross Margin.
 Explore unit economics with COGS, Gross Margin, and Net Profit.
Supply Chain View:
 Investigate forecast accuracy and Net Errors.
 Analyze Supply Chain metrics by customers and products.
Executive View:
 High-level dashboard for strategic insights.
 Identify top 5 customers and products by revenue.
 Yearly trends in revenue, Gross Margin, Net Profit, and PC Market Share.
Skills Learnt:
• Connect to various data sources.
• Cleanse, transform, and shape data using Power Query Editor.
• Create relationships between tables.
• Define calculated columns and measures using DAX.

Project video

Live Interactive Dashboard

PowerBI Project

Credit Card Innovation: Mitron Bank

Transforming banking with data insights! Explored customer demographics, spending behaviors, and market trends to shape Mitron Bank's new credit card line.

View Project
Engagement

View Project
on GitHUB

This view shows the classification of customers based on their age group, city, occupation

This view shows the usage of credit card

Project Details

In collaboration with Mitron Bank, the project aimed to revolutionize their financial offerings through data-driven insights.
•Classifying customers based on demographics (age, gender, occupation).
•Calculating Average Income Utilization % for tailored credit card features.
•Uncovering spending insights to guide targeted product development.
•Profiling high-value customer segments for strategic planning.
Skills Learnt:
1.Proficiently used Power BI to extract, analyze, and visualize intricate datasets.
2.Applied segmentation techniques to classify customers by age, gender, and occupation, unveiling nuanced insights.
3.Identified key market trends and spending patterns, enabling strategic decision-making.
4.Analyzed credit card usage across demographics, cities, and payment types, offering actionable recommendations.
5.Effectively presented complex insights to non-technical stakeholders, ensuring comprehension and alignment with business goals.

Project video

Live Interactive Dashboard

PowerBI Project

AtliQ Grands Market Analysis

Revitalized AtliQ Grands' market standing by developing a Power BI dashboard for analyzing 3 months of data. Empowered the Revenue team with insights, aiming for a 20% boost in revenue and market share in the next month.

View Project
Engagement

View Project
on GitHUB

Home Page

This view shows the revenue made by property, room class and city

Project Details

In response to market challenges, I embarked on a transformative journey, infusing Business and Data Intelligence into AtliQ Grands' operations. Leveraging historical data and statistical analysis, we delved into revenue management,occupancy dynamics,and customer behavior.
Skills Learnt:
•Proficiently analyzed complex data sets to derive meaningful insights.
•Utilized statistical methods to identify trends and patterns.
•Implemented tooltips for trend visualization, enhancing data interpretation.
•Employed visualizations for effective communication of key metrics.
•Managed multiple CSV files and diverse data sets for holistic analysis.
•Developed project timelines and milestones for efficient execution.
This project not only addressed AtliQ Grands' immediate challenges but also equipped me with valuable skills in data analytics,strategic thinking,and effective communication. It marks a pivotal moment in my journey towards becoming a data-driven problem solver.

Live Interactive Dashboard

SQL Project

Consumer Goods Ad-hoc Analysis

Conducted in-depth ad-hoc analysis using MySQL and Power BI, providing actionable insights into sales trends, product performance, and customer behavior. Enhanced data-driven decision-making and optimized inventory and marketing strategies, driving significant business improvements.

View Project
Engagement

View Project
on GitHUB

Data Model

This shows the visualization of all the Ad-Hoc Request

Project Details

• Conducted comprehensive ad-hoc analysis using MySQL and Power BI, delivering critical insights into sales trends and customer behavior.
• Analyzed sales data for "AtliQ Exclusive," identifying high and low-performing months, improving inventory management.
• Discovered a 36.32% increase in unique products from 2020 to 2021, guiding strategic product development.
• Identified top-performing sales channels and their percentage contributions, boosting targeted sales efforts.
• Developed detailed visual reports and interactive dashboards in Power BI, enhancing executive decision-making.
• Conducted segment-wise analysis of product counts, providing insights for optimized product portfolio management.
• Detected significant quarterly sales trends in 2020, aiding in strategic planning and resource allocation.
• Delivered a comprehensive report on gross sales amounts, helping to identify low and high-performing months for strategic decisions.