GANGAVENKATA SWAMY

Data Aspirant

[email protected]

Resume

Hello, I am

GANGAVENKATA SWAMY.

1

Excel
Project

1

SQL
Project

1

PowerBI
Project

About Me

I am a detail-oriented and data-driven professional with a strong passion for analytics and problem-solving. Through hands-on projects such as Sales Insights using SQL, AirPure Innovations AQI Analysis, and AtliQ Mart Supply Chain OTIF Dashboard, I have gained practical experience in data cleaning, visualization, and storytelling using tools like Excel, Power BI, and SQL. I enjoy transforming raw data into meaningful insights that drive informed decision-making. My goal is to continue developing my analytical and technical skills while contributing to data-based strategies that support business growth and efficiency.

Key Skills

ExceL

Power BI

SQL

Python

Data Engineering Basics and AI automation

My Projects

Sales Analytics

Domain/Function: Sales/Data Analytics

Ad-hoc Bussines Insights in Consumer Goods Domain

Domain/Function: E-Commerce/Business Intelligence

HR Analytics Dashboard

Domain/Function: Human Resources/HR Reporting

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

Data Engineering Basics for Data Analysts

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/swamy-medidi

GitHub

https://github.com/swamy-1416

Excel Project

Sales Analytics

Domain/Function: Sales/Data Analytics

Analyzed market and customer sales data from 2019–2021 to identify performance trends and growth opportunities. Built an interactive Excel dashboard comparing actual sales versus targets, highlighting top-performing countries and customers. Applied Excel tools such as Pivot Tables, VLOOKUP, and Cond

View Project
Engagement

View Project
on Codebasics

This slide highlights key market performance insights from the sales data. It shows that India achieved ₹161.3M in 2021 but fell short of its target b

This dashboard visually presents sales performance across countries for 2021, comparing actual sales against targets. It highlights India and the USA

Project Details

This project focuses on analyzing sales performance across markets and customers from 2019–2021 to uncover business insights and growth opportunities. Using Microsoft Excel, I designed an interactive Sales Analytics Dashboard that compares actual sales against targets, highlights underperforming regions, and identifies top customers with strong year-over-year growth. The analysis helped visualize key sales metrics such as revenue trends, target achievement, and market contributions.

SQL Project

Ad-hoc Bussines Insights in Consumer Goods Domain

Domain/Function: E-Commerce/Business Intelligence

A data-driven SQL project analyzing sales, products, and customer performance for a consumer electronics brand. Extracted key insights on revenue trends, high-performing products, top customers, and market growth to support strategic business decisions.

View Project
Engagement

View Project
on GitHUB

View Project
on Codebasics

This visual represents the key markets where AtliQ Exclusive operates across the Asia-Pacific (APAC) region. Countries such as India, Indonesia, Japan

Identified the highest and lowest manufacturing cost products. AQ HOME Allin1 Gen 2 had the highest cost, while AQ Master wired x1 MS was the lowest,

Project Details

This project focuses on analyzing real-world business data for AtliQ, a global consumer electronics brand, using SQL. The analysis uncovers key insights related to sales performance, product growth, regional markets, and customer behavior. Through advanced SQL queries, the project identifies high-performing products, top customers, growing business segments, and seasonal demand patterns to support strategic business decisions and revenue optimization.

PowerBI Project

HR Analytics Dashboard

Domain/Function: Human Resources/HR Reporting

Interactive HR Analytics dashboard analyzing employee attrition, demographics, job satisfaction, and education data to provide insights for improving workforce retention and HR decision-making.

View Project
Engagement

Visual showing SQL logic along with HR dashboard metrics including total employees, attrition count, and department-wise attrition breakdown.

Combination of SQL query and HR dashboard charts showing employee counts by department and attrition rates to support HR analysis and business insight

Project Details

This HR Analytics Dashboard provides a comprehensive view of employee attrition and workforce trends. The dashboard analyzes total employees, attrition count, attrition rate, and employee distribution across age groups, departments, roles, and education levels. It also highlights job satisfaction scores and attrition patterns across age and gender categories.

Using Power BI/Excel visualization techniques, the project transforms raw HR data into actionable insights, helping HR teams identify key attrition drivers, improve employee retention strategies, and support evidence-based workforce planning.