Kiran Reddy

Data Analyst

[email protected]

Resume

Hello, I am

Kiran Reddy.

1

Excel
Project

2

PowerBI
Projects

1

SQL
Project

1

Python
Project

About Me

Hi, I am a Data Analyst with 2+ years of experience in the finance and supply chain sectors. I'm passionate about transforming data into actionable insights, with proven skills in Excel, Power BI, SQL, Python, and Machine Learning. I hold a Master's in Data Science and Analytics. Let's unlock the potential of your data together!

Key Skills

SQL

Python

Machine Learning

Excel

Power BI

My Projects

Sales Insights

Domain/Function: FMCG

Business 360 - AtliQ Hardware

Domain/Function: FMCG

AtliQ Consumer Goods Insights

Domain/Function: FMCG

AtliQ Grands Insights

Domain/Function: Hospitality

AtliQ Grands Analytics using Python

Domain/Function: Hospitality

My Experience

Menzies Distribution, London – Data Analyst

Feb 2022 - Present

Automated data processing with Excel and SQL, enhancing operational efficiency and saving approximately 5 hours’ time weekly.
Conducted warehouse load time analysis using python to optimize loading strategies, resulting in a 40% improvement in efficiency.
Created Power BI Report enabling company to quicky identify key customer issues, and time patterns affecting service levels and customer satisfaction, leading to targeted improvements.
Analyzed warehouse workforce data to optimize staffing levels and foster a friction-free, rewarding environment, resulting in reduced costs and increased work efficiency.
Implemented machine learning models using python for stock forecasting, inventory management, optimizing warehouse space usage while ensuring high customer satisfaction.

Mashco Ltd, London – Data Analyst Intern

Apr 2021 - Jan 2022

Analyzed extensive datasets encompassing sales, stock, and more.
Produced over 50 targeted ad-hoc reports, catalyzing decisive actions to optimize stock management.
Crafted 100+ intricate SQL queries, ensuring data integrity in the generation of comprehensive reports.
Engineered an Excel data flow using Power Query, Power Pivot, and DAX measures. This streamlined business ETL Process.
Constructed dynamic Power BI dashboards unveiling insights into sales, stock, online engagement, and conversion rate.
These actionable insights facilitated data-driven decisions, resulting in an impressive 18% increase in overall revenue and garnering appreciations..

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/kiranreddy-mallidi/

GitHub

https://github.com/Kiran281197

Excel Project

Sales Insights

Domain/Function: FMCG

I have created two excel reports that generates key insights that enable business to identify top & bottom customer, identifying sales patterns and Market Performance VS Target. It also help business to maximize the profit through identifying high profitable markets, customers etc.

View Project
Engagement

View Project
on GitHUB

Market Performance vs Target: This report identifies under performing and outperforming markets through target comparison.

Customer Performance Report: This report shows yearly net sales performance of all customers, allowing users to filter by region, market and sub-zone.

Project Details

In this project, I have generated customer performance and market performance reports using excel that delivers significant insights which helps business identifying the key markets for expansion, discount negotiations based on the performance, improving customer satisfaction, optimization of cost and maximization of profit while ensuring being competitive in the market.

Key Skills:

• ETL
• Power Query
• Excel Formulas
• Power Pivot
• Data Modelling
• Pivot Tables
• DAX (Data Analysis Expressions)
• User-Focused Report Design
• Conditional Formatting

PowerBI Project

Business 360 - AtliQ Hardware

Domain/Function: FMCG

AtliQ is a hardware company supplies variety of hardware to their customers. It realized significance of data analytics with time to remain competent & profitable in the market whilst satisfying their customers. Hence, deployed data analytics into their business to enable data-driven decisions.

View Project
Engagement

View Project
on GitHUB

Other Tools

Excel

SQL

DAX

DAX Studio

Finance View: This shows Profit & Loss Statement with various filters along with dynamic slicer which enables user to compare with LastYear & Targets.

Supply Chain View: This gives insights related to sales forecast accuracy by various filters along with comparison of Last Year.

Project Details

Business 360 is an interactive Power BI dashboard delivers significant insights into Finance, Sales, Marketing, Supply Chain and Executive departments to enable data driven decision making.

Dashboard Elements:

Home Page: Landing Page meant to help users to navigate to an interested page in just a click.
Finance View: It mainly centers around business P & L Statement, KPI's and Yearly trend with various breakdowns.
Sales View: This delivers insights like net sales, gross margin and gross margin % by various breakdowns along with pre and post invoice discounts against net sales and gross margin.
Marketing View: This helps marketing team to keep track of marketing expenses and Net Profit.
Supply Chain View: It helps supply chain team to improve overall forecast accuracy by keeping track of Net Error.
Executive View: It shows business overall performance to Executive members at high level through various KPI's.

Live Interactive Dashboard

SQL Project

AtliQ Consumer Goods Insights

Domain/Function: FMCG

AtliQ Hardware, a global manufacturing company, recognized the importance of data-driven decisions to stay competitive. To address various ad-hoc queries, they established a strong data analytics team skilled in SQL.

Other Tools

Excel

SQL

These reports helps understanding product with high and lowest manufacturing cost and customer with high avg pre-invoice discount pct in 2021 India.

This report will facilitate strategic decisions by getting an idea of low and high performing months.

Project Details

In this project, I leveraged SQL to generate comprehensive reports that provide key insights into customer behavior, product performance, sales trends, and discount analysis across multiple dimensions. These reports empower stakeholders with a deeper understanding of company performance, driving strategic planning and data-driven decision-making.

PowerBI Project

AtliQ Grands Insights

Domain/Function: Hospitality

AtliQ Grands, a leader in India's luxury hotel industry for 20 years, faces declining market share and revenue due to competitor strategies and poor management decisions. To regain their edge, AtliQ is adopting Business & Data Intelligence, leveraging insights to drive smarter decisions and growth.

Other Tools

Canva

Excel

Power BI

The AtliQ Grands Insights dashboard showcases key metrics like weekly revenue, occupancy rates, city-wise performance & various property metrics.

This is the data model created for AtliQ Grands Insights dashboard with 2 fact and various dimensional tables.

Project Details

The AtliQ Grands Insights dashboard provides a comprehensive overview of key performance metrics for AtliQ's luxury hotels in India. It highlights week-over-week (WoW) revenue, occupancy rates, and average customer ratings, allowing stakeholders to track performance across major cities like Mumbai, Delhi, Hyderabad, and Bangalore.

The dashboard features detailed property performance analysis, including revenue, occupancy, ratings, and cancellation rates. It also contrasts weekday and weekend occupancy and displays booking distribution across various platforms.These insights empower management to make data-driven decisions that optimize occupancy, enhance customer satisfaction, and recover lost market share.

Overall, the dashboard serves as a vital tool for implementing effective business intelligence strategies and driving performance improvements at AtliQ.

Live Interactive Dashboard

Python Project

AtliQ Grands Analytics using Python

Domain/Function: Hospitality

AtliQ Grands is the largest hotel business in India. It has encountered sudden fall of bookings recently and business had no clue about the reasons behind it. Therefore, data analyst has been hired to make use of data wisely and provide significant insights in making data driven decisions.

Other Tools

Excel

Jupyter Notebook

Canva

This helps business understanding revenue and revenue distribution % by room class.

This chart reveals insights like booking by booking platform, room class and hotel category.

Project Details

In this project, I conducted univariate and bivariate analysis using Python to identify data uncertainties and performed data cleansing to ensure accuracy. The project involved revenue analysis to uncover patterns, occupational analysis to boost occupation rates through strategic decision-making, and booking analysis aimed at increasing overall bookings for the business across India.