Sudhir Kumar

Data Analyst

[email protected] +91 9625769564

Resume

Hello, I am

Sudhir Kumar.

1

Excel
Project

2

PowerBI
Projects

1

SQL
Project

About Me

In the early stages of my life, I explored many interests, including my passion for sketching. While I once thought this would shape my future, my path shifted as I realized how quickly the world moves. After high school, I considered different career options, but nothing clicked until I discovered data analysis during my undergraduate studies.

In my third year, I fully immersed myself in learning about data. I completed several hands-on projects and certifications, gaining proficiency in Excel, SQL and PowerBI. Through this journey, I developed a deep passion for uncovering insights and solving real-world problems through data.

I’m eager to apply my skills to help businesses turn raw data into clear, actionable insights. With a strong work ethic, a continuous drive to learn, and a genuine enthusiasm for data, I’m ready to contribute to a team focused on data-driven decision-making.

Key Skills

problem Analysis

Project management

MS-EXCEL

POWER BI

MY SQL

DATA INTERPRETATION

DATA MANIPULATION

DATA VISUALIZATION

My Projects

From Raw Data to Business Insights

Integrated Performance Dashboard: Unveiling Business Insights Across Sales, Finance, Marketing, Executive, and Supply Chain

View other drafts Data-Driven Transformation: AtliQ Grands Reclaims its Luxury Hospitality Throne

Consumer Goods Ad-Hoc Insights

My Experience

Data Analyst Intern - Atliq Technologies (Virtual Internship) Mar2024 - Apr2024

Wavecon Telecom •

-Analyzed 5G launch impact on revenue using Microsoft Power BI.

-Identified 11.05% ARPU increase despite a slight dip in total revenue (-0.50%).

-Revealed user behavior changes: fewer active users (-8.28%), higher spending in most cities, and plan-specific variations (Plan P7 decline).

-Presented findings to company leadership with actionable insights.

Shield Insurance •

-Utilized Power BI and Microsoft PowerPoint to build the dashboard, showcasing technical skills in data loading, cleaning, modeling, and creating DAX formulas.

-Uncovered key performance insights: identified March 2023 as the peak revenue and customer acquisition month, Delhi NCR as the leading city, 31-40 age group as a key demographic driver, and offline-agent sales as the dominant customer acquisition channel.

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/sudhir-k6/

Call Me

+91 9625769564

GitHub

https://github.com/Sudhir365

Excel Project

From Raw Data to Business Insights

masterfully wield tools like VLOOKUP, INDEX-MATCH, statistical concepts, Power Query, and finance analytics to illuminate business landscapes, empowering informed decision-making.

View Project
Engagement

View Project
on GitHUB

Market Performance vs Target

Profit & Loss by Fiscal Year

Project Details

This Excel Mastery project demonstrates a comprehensive skill set, ranging from basic data cleaning to advanced financial analytics. By combining the precision of VLOOKUP and INDEX-MATCH with the analytical prowess of statistical concepts and Power Pivot, the user is equipped to transform raw data into valuable business insights, making informed decisions that drive success.

PowerBI Project

Integrated Performance Dashboard: Unveiling Business Insights Across Sales, Finance, Marketing, Executive, and Supply Chain

A testament to meticulous planning, technical finesse, and a commitment to excellence, this tool now stands as a beacon, offering stakeholders a panoramic view of organizational performance across key domains.

View Project
Engagement

Customizable filters empower users to tailor the view according to their analytical needs, offering a personalized exploration of financial data.

Data Modeling involving 15+ tables

Project Details

A stringent quality assurance process validated data integrity, verified calculations, and fine-tuned the dashboard's performance. The result is a user-friendly, comprehensive dashboard offering holistic insights into sales, finance, marketing, executive, and supply chain performance. This project not only showcased technical proficiency but also underscored the capacity to distill complex datasets into actionable intelligence, empowering stakeholders to make informed decisions with confidence.

Live Interactive Dashboard

PowerBI Project

View other drafts Data-Driven Transformation: AtliQ Grands Reclaims its Luxury Hospitality Throne

Luxury hotel chain AtliQ Grands faced declining market share and revenue due to competition and inefficiencies. To regain its footing, AtliQ turned to data analysis. By developing custom metrics, building a comprehensive dashboard, and uncovering hidden insights.

View Project
Engagement

A high-level overview of AtliQ Grands' performance, enabling users to quickly identify key trends and areas for improvement.

The tooltip shown in the screenshot provides detailed information about a specific data point in the AtliQ Grands Revenue Dashboard.

Project Details

AtliQ Grands: Regaining Luxury Hospitality Leadership Through Data

Facing declining market share and revenue, luxury hotel chain AtliQ Grands embarked on a data-driven journey of transformation. By collaborating with a skilled data analyst, they unlocked the power of their historical data, transforming it into actionable insights.

The analyst crafted custom metrics tailored to AtliQ Grands' unique objectives, built a comprehensive dashboard for clear visualization, and uncovered hidden opportunities beyond the pre-defined metrics. This resulted in:

Improved Revenue Management: Dynamic pricing strategies and targeted marketing campaigns optimized revenue generation.
Enhanced Guest Experience: Data-driven insights led to tailored offerings and services, exceeding guest expectations.
Strategic Decision-Making: Informed by data, AtliQ Grands made strategic decisions, leading to a significant increase in market share and a remarkable resurgence in revenue.

Live Interactive Dashboard

SQL Project

Consumer Goods Ad-Hoc Insights

I used SQL to answer key questions about Atliq Hardwares' data. My findings were presented visually, aiding informed decision-making for company growth.

View Project
Engagement

View Project
on GitHUB

Bar graph shows 36.33% increase in unique products sold in 2021 vs 2020. Data from MySQL query.

The top 3 high-selling products by division for fiscal year 2021, along with their total sold quantity and rank order.

Project Details

Atliq Hardwares, a major computer hardware company, needed help making better decisions using data. As a Data Analyst learner, I tackled a challenge from Tony Sharma, their data boss.

Using SQL, I answered 10 important questions about the company's data. These questions were crucial for the top bosses to understand. Then, I created an informative presentation with images to show what I found.

This project shows I'm good at understanding data and sharing it in a way that makes sense to everyone. It helps Atliq Hardwares make smarter choices and grow their business.