Codebasics Logo

Powered by
Codebasics DA Bootcamp

Home

About

Projects

Experience

Certificates

Contact

Hello, I am

Rachana Hadke

Data Aspirant
Resume

1

Excel
Project

3

PowerBI
Projects

1

SQL
Project

1

Python
Project

About

Me

Hi! I’m Rachana Hadke, an aspiring data analyst who loves finding the stories in numbers.
I focus on turning raw data into useful insights that help make smarter and quicker decisions.

Whether I’m diving into complex datasets or crafting visually compelling dashboards, I thrive on solving real-world problems with data.
I’ve worked on projects across finance, retail, and sports, where I’ve helped identify trends and improve strategies using data.

I’m also a lifelong learner—constantly upskilling through certifications and challenging projects, pushing the boundaries of what data can achieve.
If you’re looking for someone who can not only analyze data but transform it into a competitive advantage, let’s connect!

Key

Skills

Excel

PowerBI

Effective Communcation

Stakeholder Management

Problem Solving

My

Projects

Sales Analytics
Sales Analytics

Domain/Function: IT Hardware Sales Analysis

This project focuses on analyzing the company's sales performance and market standing. The insights provided by advanced Excel techniques such as Pivot Tables and Power Query, help the sales team optimize strategies, improve customer relationships, and track market goals effectively.

Business Insights 360
Business Insights 360

Domain/Function: IT Hardware

AtliQ Hardware faced challenges managing data in Excel, limiting insights into key areas. My objective was to transition the company to Power BI, enabling better analysis of finance, sales, and supply chain, utilizing a substantial dataset of 1.8 million entries for informed decision-making.

Sports Insights
Sports Insights

Domain/Function: Sports Analysis

This IPL Cricket Analysis project dives into match data to uncover trends and insights. The goal is to evaluate player performances, team strategies, and match outcomes, helping teams and fans understand the game better and make informed predictions for future matches.

Promotion Effectiveness Insights
Promotion Effectiveness Insights

Domain/Function: Retail Analytics

This project analyzes the impact of promotional campaigns on AtliQ Mart's branded products during Diwali 2023 and Sankranti 2024. By evaluating sales data and customer response, we aim to identify successful strategies and provide actionable insights for future marketing efforts.

Data analysis in Hospitality Domain using Python
Data analysis in Hospitality Domain using Python

Domain/Function: Hospitality Domain

Analyzed booking data for AtliQ Grands, a hotel chain, using Python to uncover key insights into occupancy rates, revenue trends, and customer behavior. Delivered actionable recommendations to optimize hotel performance, boost revenue, and market share.

Data analysis in consumer goods domain using SQL
Data analysis in consumer goods domain using SQL

Domain/Function: Consumer Goods

AtliQ Hardware Sales Analysis: Analyzed sales and operational data to uncover insights on customer segments, product performance, and trends. Used SQL for analysis, Power BI to create impactful visualizations, and applied data storytelling techniques to enhance decision-making.

My

Experience

Analyst - Capgemini, Mumbai
Nov 2020 - Dec 2022

  • Data-Driven Operations: Analyzed and resolved over 2 incidents per day. Used SQL and Excel to identify patterns to prevent future issues, significantly improving service reliability.
  • Collaboration & Communication: Worked closely with the development and operations teams to analyze system performance, share insights, and implement data-driven solutions to improve business outcomes.

Awards

& Certificate

CB Cert

Excel: Mother of Business Intelligence

CB Cert

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

CB Cert

Python: Beginner to Advanced For Data Professionals

CB Cert

SQL Beginner to Advanced For Data Professionals

Google Data Analytics Certification

Google Data Analytics Certification