Name: Rohith Reddy Rudraiah Gari

DOB: 15-June-2001

Age:

Address: Hyderabad, India

Skills

MYSQL 75%
PYTHON 75%
Java 65%
Data Visualization 80%
Statistical Analysis 70%
React.Js 75%

About

About Me

Recent graduate with a B.Tech. in Computer Science & Engineering from CMR College of Engineering & Technology, seeking to leverage my academic knowledge and project experience in data analysis to contribute to data-driven decisions. I am passionate about turning data into actionable insights and excited to bring my skills in statistical analysis and data visualization.

  • Profile: Data Analytics
  • Domain: Hospitality, Automotive, FMCG, E-commerce, Human Resources & Sports
  • Education: Bachelor of Technology
  • Language: English, Telugu, Hindi
  • BI Tools: Microsoft Power BI, Tableau
  • Other Skills: Excel, Git, Python (Pandas, NumPy, Matplotlib)
  • Interest: Traveling, Cricket

0 +   Projects completed

LinkedIn

Resume

Resume

Passionate about turning data into actionable insights and excited to bring my skills in statistical analysis and data visualization.

Education


August 2019 - April 2023

Bachelor of Technology

CMR College Of Engineering and Technology

Grade: First class.

CGPA: 7.51

May 2017 - April 2019

12th Board

Sri Chaitanya Junior College

Grade: First class distinction.

AGGREGATE: 93.2 %

Projects

Projects

Below are the Data Analytics projects on Excel, Power BI, MySQL & Python.

Skill 1

2

Skill 2

9

Skill 3

5

Skill 4

3  

Online Retail Performance Analysis

Domain: 

E-commerce

Skills: 

    Excel
    Power BI
    DAX

β€œAnalyzed retail data, uncovering $10.67M in revenue from 6M units sold, with $9.85M generated on weekdays πŸ“ŠπŸ’°. Identified a 30.69% revenue surge in November and a 57.68% decline in December, highlighting key seasonal trends πŸ“ˆπŸ“‰. Found top-performing customers and regions, with Customer 14646 contributing $280K, while the Netherlands ($285K) and Ireland ($283K) led in revenue πŸŒπŸ’΅. These insights help businesses optimize strategies, improve marketing efforts, and maximize sales performance πŸ“ŠπŸš€β€

GoodCabs Transportation Analysis

Domain: 

Transportation & Mobility

Skills: 

    MySQL
    Power BI
    DAX

β€œπŸš– Conducted a comprehensive analysis of city-level performance, focusing on trip volume, pricing efficiency, and passenger satisfaction. πŸ“… Identified seasonal patterns and demand variations between weekdays and weekends, while πŸ”„ exploring repeat passenger behavior and loyalty trends. 🎯 Delivered actionable insights to enhance monthly target achievements for trips and passenger ratings.”

Supply Chain Analysis

Domain: 

FMCG

Skills: 

    Power BI
    DAX
    MySql

"In a project for AtliQ Mart, I analyzed key supply chain metrics (πŸ“¦ OTD %, OTIF %, Line Fill Rate) and developed an interactive Power BI dashboard πŸ’». By leveraging advanced bookmarks, slicers, and DAX formulas, I boosted navigation efficiency by 25% πŸš€ and improved report accuracy by 15% πŸ“Š."

Electric Vehicles Analysis

Domain: 

Automotive

Skills: 

    MySql
    Power BI
    DAX

β€œThe focus was to uncover critical insights for an automotive company planning to launch EVs in India.These insights offer a data-driven foundation for launching and scaling EVs in India, helping to navigate this dynamic and fast-evolving market.” πŸ”ŒπŸš™

Insights On IPL 2024 For A Sports Magazine

Domain: 

Sports

Skills: 

    MySql
    Power BI
    DAX

β€œThe analysis explored critical cricket statistics, including aggregate runs, batting averages, bowler’s economy rates, and the percentage of dot balls. Additionally, it examined team performances over the years, providing valuable insights for both fans and experts.” πŸπŸ“Š

Telangana Tourism Analysis

Domain: 

Tourism

Skills: 

    Excel
    Power BI
    DAX

β€œThe Telangana Tourism Dashboard offers a detailed snapshot of the region’s tourism, spotlighting Hyderabad, and ranks districts by growth rates. It also forecasts tourist counts and industry earnings.” πŸ“ˆ

Cricket Data Analysis

Domain: 

Sports

Skills: 

    Pandas
    Power BI
    DAX

"Utilizing data from the T20 World Cup 2022, my goal was to pinpoint the standout Batters, Bowlers, and All-Rounders, considering a range of performance categories."πŸπŸ“Š

Credit Card Financial Report

Domain: 

Banking

Skills: 

    MySql
    Power BI
    DAX

"Create an all-encompassing weekly dashboard for credit cards, offering real-time visibility into critical performance metrics and trends. This will empower stakeholders to effectively monitor and analyze credit card operations."πŸͺ™πŸ“ˆ

HR Data Analysis

Domain: 

Human Resources

Skills: 

    Pandas
    Matplotlib
    MySQL

β€œIn this HR Analytics project, I analyzed employee attrition using Python and MySQL on a Kaggle dataset. Key insights showed higher attrition among non-trained employees (53.82%) and the Executive Office (66.67%). The project explored department-wise trends, hiring patterns, and work-life balance, aiding HR in data-driven retention strategies.”

Call Centre Report - 2023

Domain: 

Customer service

Skills: 

    DAX
    Excel
    Pivot Tables

β€œπŸ“Š The 2023 Call Center Report reveals $96,623 from 1,000 calls πŸ’° over 1,498 minutes ⏱, with an average rating of 3.89 ⭐ and 307 five-star ratings ⭐⭐⭐⭐⭐. Rep R03 earned $20.9k πŸ†. Peak times were April and October πŸ“…, busiest on Wednesdays πŸ—“. Cleveland had the most male callers πŸ‘₯. Ratings were mostly 4 and 5 stars 🌟, crucial for boosting efficiency and satisfaction πŸ“ˆ.”

WPL 2024 Excel Dashboard

Domain: 

Sports

Skills: 

    Excel
    Pivot Tables

β€œAn Excel dashboard was created for the Women's Premier League (WPL) 2024 🏏, showcasing top performances with the bat and ball. The dashboard features an interactive filter, allowing users to view stats for specific teams, making it easy to analyze and compare player performances across the league πŸ”.”

Consumer Goods Ad-Hoc Insights

Domain: 

Consumer Goods

Skills: 

    SQL
    Excel
    Power Point

β€œThe Consumer Goods Ad-Hoc Insights highlights key metrics for a consumer goods company. "Atliq Exclusive" operates in several APAC countries 🌏, with a 36.33% growth in unique products πŸ“ˆ from 2020 to 2021. Notebooks and Accessories dominate πŸ’», while Desktops saw the highest growth (214.29%). Retailers contributed 73.22% of sales πŸ’°, and Flipkart led in discounts πŸ›’.”

Hospitality Revenue Analytics

Domain: 

Hospitality

Skills: 

    Excel
    Power BI
    DAX

β€œI analyzed historical data to offer revenue insights to the AtliQ Grand hotel team, with the goal of improving revenue and market share relative to other hotels.” πŸ“ŠπŸ¨

COVID 19 Data Analysis

Domain: 

Health Care

Skills: 

    Pandas
    Matplotlib
    NumPy

β€œThis project aims to provide people with insights into the COVID-19 situation in their country, allowing them to identify areas where the virus is spreading rapidly and enabling informed planning.”

Certifications

Certificates

Below are the Certifications which i gained in various technologies.

0 Accomplishments
0 Projects
0 Certifications

More projects on Github

I love to solve business problems & uncover hidden data stories


GitHub

Contact

Contact Me

Below are the details to reach out to me!

Address

Kamareddy, India

Contact Number

+91 8500536440

Resume Template

Download link πŸ”—