Gunturi Raja Subash Chendra

Data Analyst

[email protected] +91 9502858229

Resume

Hello, I am

Gunturi Raja Subash Chendra.

1

Excel
Project

2

PowerBI
Projects

About Me

Hey there, I’m Chandu—and I specialize in turning data into meaningful business decisions.

My passion for analytics comes from a natural curiosity: I love identifying patterns, asking tough questions, and uncovering insights that drive action. With tools like Excel, SQL, and Power BI, I dive deep into datasets to find what really matters—then turn those insights into clear, impactful visuals.

What sets me apart isn’t just my technical skills—it’s my understanding of how data fits into the bigger picture. I’ve collaborated directly with stakeholders to define KPIs, built dashboards that influence decisions, and iterated on feedback to improve the clarity and business value of every visual.

Every project I take on is a chance to solve a real problem. From trend analysis to performance tracking, I focus on making data accessible, understandable, and actionable for the people who rely on it. My work isn’t about vanity metrics—it’s about creating dashboards and reports that actually move

Key Skills

Advanced Excel

Power BI

SQL

Stakeholder Management

Effective Communication

My Projects

Sales and Finance Analytics

Domain/Function: FMCG

AtliQ Sales Insights

Domain/Function: FMCG

Business Insights 360

Domain/Function: Consumer Electronics

Awards & Certificate

Excel: Mother of Business Intelligence

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

SQL for Data Science

SPEEXX English Essentials

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/raja-subash-chendra-gunturi-693727182/

Call Me

+91 9502858229

GitHub

https://github.com/chandu7508

Excel Project

Sales and Finance Analytics

Domain/Function: FMCG

The goal of this project is to deeply understand how the company is doing financially and where it stands in the market. I have created different reports like "Customer Net Sales Performance" and "Market Performance vs. Target" using basic and advanced Excel skills.

View Project
Engagement

View Project
on GitHUB

The Customer Performance Report reveals the net sales performance of each customer over multiple years.

The Market Performance vs Target report allows stakeholders to evaluate how well the country is doing and compare it against the target.

Project Details

In this project, I've developed a dynamic sales report using Excel pivot tables, offering businesses invaluable insights into customer discounts, negotiation strategies, and untapped markets. These reports provide actionable recommendations, empowering businesses to refine sales tactics, elevate customer experiences, and maximize revenue.

Throughout this journey, I've honed skills in:

1. Pivot tables
2. Power Query
3. Basic DAX functions
4. Effective Conditional Formatting
5. Report Presentation
6. Sales Domain Metrics

The primary goal is to arm businesses with the tools and insights needed to monitor, assess, and optimize their sales efforts. By leveraging data-driven analysis, businesses can uncover opportunities for growth, adapt to market changes, and maintain a competitive edge in an ever-evolving landscape.

PowerBI Project

AtliQ Sales Insights

Domain/Function: FMCG

This project focuses on solving business visibility challenges for AtliQ Hardware by building an interactive Power BI dashboard. Using SQL, ETL, and DAX, I created sales insights reports to empower leadership with real-time, data-driven decisions.

View Project
on GitHUB

This dashboard visualizes sales performance of AtliQ Hardware across products, cities, and retailers. It helps identify top-selling items, high-perfor

This is a basic version of the sales dashboard for AtliQ Hardware, showing product, city, and retailer-level performance. It provides a foundational v

Project Details

Built a Power BI dashboard for AtliQ Hardware to address unclear and biased sales reporting.

Used SQL for initial data analysis and Power BI for ETL, data cleaning, and multi-currency standardization.

Created DAX measures to track KPIs and reveal regional performance gaps.

Designed visuals showing sales trends and market status; refined based on stakeholder feedback.

Aligned with AIMS Grid to ensure clarity of purpose and stakeholder needs.

Delivered a centralized, real-time dashboard enabling data-driven decisions

Key Skills:
SQL – for data exploration and high-level analysis

Power BI – for data modeling, visualization, and report building
ETL (Extract, Transform, Load) – to clean and prepare raw sales data
DAX (Data Analysis Expressions) – for creating custom measures and KPIs
Currency Conversion – to normalize multi-currency sales data

Live Interactive Dashboard

PowerBI Project

Business Insights 360

Domain/Function: Consumer Electronics

AtliQ Hardwares, a consumer electronics company, is growing fast but struggles to keep up with competitors who use data effectively. Most of their reports are still in Excel. My aim is to set up a smart analytics system using Power BI. This will help the company in making smarter decisions.

View Project
Engagement

View Project
on GitHUB

Finance Insights: Unveiling key financial metrics and trends from the project's analytics dashboard.

Executive ready insights to give leaders a quick overview for confident strategic choices.

Project Details

In this project, the goal is to be one report which 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.