Geethika Putcha

Data Analyst

Resume

Hello, I am

Geethika Putcha.

1

Excel
Project

3

PowerBI
Projects

1

SQL
Project

About Me

Welcome to my portfolio! I'm Geethika Putcha, an aspiring data analyst with a passion for transforming raw data into actionable insights. My skill set includes advanced proficiency in Excel, Power BI, and SQL, which I've honed through hands-on experience and continuous learning. I am passionate about uncovering valuable insights from data to drive informed decision-making. My goal is to leverage my analytical skills and knowledge to help organizations transform raw data into actionable intelligence. I thrive on solving complex problems and am excited about the ever-evolving landscape of data analysis. Feel free to explore my portfolio to see some of the projects that showcase my abilities and dedication to the field.

Key Skills

SQL

Power BI

Python

Excel

My Projects

Sales and Finance Analysis Report

Business Insights 360

AtliQ Hospitality Analysis

Telangana Growth Analysis

Consumer Goods Ad-hoc Insights

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

PWC-Power BI Virtual Case Experience

TCS-Data Visualisation: Empowering Business with Effective Insights

JP Morgan: Excel Skills for Job Simulation

Appreciation Certificate for Telangana Growth Analysis Resume Challenge

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.

https://www.linkedin.com/in/geethika16/

GitHub

https://github.com/GeethikaPutcha

Excel Project

Sales and Finance Analysis Report

● Generated a comprehensive P&L report for AtliQ Hardware FY 2022, utilizing advanced features in Excel such as Pivot Tables and DAX to provide granular insights into revenue streams and expense categories. ● Automated the data cleaning using Power Query.

View Project
Engagement

View Project
on GitHUB

P & L Statement

Customer Performance

Project Details

I created a Sales and Finance Analysis Report that focuses on yearly Net Sales, Customer Performance, Gross Margin % and Profit & Loss.
Learnings:
1. Business Knowledge and terms
2. Data Cleaning and Transformation.
3. Data Modelling.
4. Using Power Query, Power Pivot and Pivot Tables
5. Creating empathetic reports.

Conclusion
This project is dedicated to delivering strategic insights to businesses, pinpointing areas of concentration and improvement to enhance sales performance. Through meticulous data analysis and tailored recommendations, we aim to empower organizations to make informed decisions and optimize their strategies, ultimately driving sustainable growth and increased sales.

PowerBI Project

Business Insights 360

AtliQ Hardware is a rapidly growing consumer electronics goods company. This company is facing challenges in its Data Analysis practices as it relied on Excel files. So to overcome challenges they decided to onboard a Data analyst team and assign them a 360 project to know 360 degrees of company.

View Project
Engagement

Home Page

View

Project Details

The main aim of this project is to create a user-interactive report for the stakeholders from the Sales, Finance, Marketing, Supply Chain and Executive departments.

Learnings:
1. Importing Data from MySQL to Power BI
2. Data Cleaning and Transformation using Power Query
3. Data Modelling
4. Using Tooltips
5. Using Bookmarks
6. Basic and Advanced DAX
7. Finance Related Terms

Live Interactive Dashboard

PowerBI Project

AtliQ Hospitality Analysis

AtliQ Grands is a well-respected name in the hospitality industry with a remarkable 20-year history. They have a strong preference in major Indian cities like Hyderabad, Mumbai, Delhi and Bangalore.

View Project
Engagement

Home Page

Visuals

Project Details

AtliQ Grands a company known for it's luxury and business hotels has been losing it's market share and revenue due to competition and poor management decisions.
To bounce back the managing director decided to onboard a Business and Data Intelligence Team as the company lacked an in-house Data Analyst. So here we need to assume ourselves as Data Analysts and present the insights to the company.
This project can help the company to look-in the areas where they need to concentrate for more profits.

By doing this project I gained Domain Knowledge, hospitality related important metrics like RevPAR, DBRN, DSRN, Occupancy%, ADR, Realisation etc and I also included all my learnings in this project

Live Interactive Dashboard

PowerBI Project

Telangana Growth Analysis

Telangana Growth Analysis Project involves the analysis of the Growth of Telangana across various districts and departments by using some data and present the insights to Telangana Government

View Project
Engagement

Home

E-Stamps View

Project Details

In this Project, I'm Peter Pandey, an aspiring data analyst, and I'm taking on a challenge to analyze Telangana's growth in various sectors using data. My goal is to provide valuable insights to the Telangana government, helping them make informed decisions to boost the state's growth.

I took on the task of exploring three datasets: Stamp Registration, Transportation, and TS-iPASS. I studied their features, categories, and the time periods they cover. My analysis involved looking for trends and patterns in each department. I aimed to find opportunities for growth and areas that require attention. Additionally, I sought correlations among these departments and used insights and visual tools like shape maps to present the overall state's growth in a clear and understandable way in my presentation

Live Interactive Dashboard

SQL Project

Consumer Goods Ad-hoc Insights

In this project, I conducted an analysis for Atliq Hardware, a prominent hardware production company. The primary objective was to provide valuable insights to the company through a SQL challenge, addressing the need for quick decision-making in their expanding data analytics team.

View Project
Engagement

View Project
on GitHUB

Other Tools

power bi

Home Page

Adhoc Request

Project Details

Conducted a strategic analysis for Atliq Hardware, a leading hardware production company, using SQL.
The aim was to provide swift insights for their growing data analytics team.
Utilized MySQL for robust querying, Power BI for compelling visualizations, Canva for polished presentations, and Loom for seamless video documentation.
Key findings include unique product count, peak sales figures, and overall gross sales, providing valuable insights for informed decision-making.
Recommendations focus on deepening customer insights, refining product recommendations, optimizing pricing and inventory, and identifying new product opportunities.
A project that aligns data analytics with Atliq Hardware's strategic goals.