Portfolio - Pooja Poundkar

Pooja Poundkar

Data Analyst

Resume

5

PowerBI Projects

1

SQL Project

About Me

Hi there! I'm Pooja, Even though I started with a degree in Biotechnology, I realized my passion lies within data analysis.

I'm good at using Excel, PowerBI and SQL to figure out what the numbers mean. It's like being a detective for data!

I might not have tons of job experience yet, but I've been doing real business projects. You can check them out in my portfolio – they show that I know how to make sense of data.

Leveraging my background as a Data Research Analyst, I bring a proven track record of data-driven decision-making, quantifiable achievements in engagement optimization, and adeptness with analytics tools.

Key Skills

SQL

PowerBi

Excel

Python

Devops

My Projects

BI_360

Domain/Function: Data Analytics

Business Insights 360

Hospitality Analysis

Consumer Goods Ad-hoc Insights

AtliQ Mart’s Analysis

Shield-Insurance-Analysis

My Experience

With extensive experience in contact discovery and data management, I have effectively utilized various networking sites like LinkedIn and ZoomInfo to retrieve crucial contact information of prospects and companies. My expertise lies in conducting web searches on different search engines to gather relevant business information about organizations and key contacts as per client requirements. I specialize in searching company details such as addresses, industry, and phone numbers. My skill set includes data acquisition and extraction, data management, data analysis, and verifying job titles and email IDs through pass verification.

Let's leverage my experience in data management and contact discovery to drive your business forward and achieve exceptional results together!

Awards & Certificate

HackerRank SQL (Intermediate) Certificate

Letter of Experience || Internship

Certificate of Appreciation

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.

Download Resume

Resume

Mail Me

[email protected]

https://www.linkedin.com/in/pooja-poundkar/

Call Me

+91 8788758737

GitHub

https://github.com/poojapoundkar

PowerBI Project

BI_360

Domain/Function: Data Analytics

Leverage Power BI to enhance data analytics capabilities, addressing key financial, sales, marketing, and supply chain queries from stakeholders. The project utilized an extensive dataset with over 1.8 million records.

View Project
Engagement

View Project
on GitHUB

This helps people see how well the country is doing and if it's meeting its targets.

Project Details

🔍 𝗣𝗿𝗼𝗯𝗹𝗲𝗺 𝗦𝘁𝗮𝘁𝗲𝗺𝗲𝗻𝘁 : AtliQ Technologies, a rapidly growing consumer electronics company, faced significant data analysis challenges relying solely on Excel, which proved inefficient during a major financial loss in Latin America.

📊 𝗗𝗮𝘁𝗮 𝗦𝘁𝗿𝘂𝗰𝘁𝘂𝗿𝗲 : Employed a snowflake schema to streamline data modeling, ensuring optimized and efficient data organization.

🛠 𝗧𝗼𝗼𝗹𝘀 𝗨𝘀𝗲𝗱 : SQL, Power BI Desktop, Excel, DAX Studio, ChatGPT, and Google for data analytics and troubleshooting.

𝗦𝗼𝗹𝘂𝘁𝗶𝗼𝗻
As an aspiring Data Analyst, I developed Power BI reports that deliver crucial insights for various departments—Finance, Sales, Marketing, Supply Chain, and Executive. These reports track essential KPIs, enabling

PowerBI Project

Business Insights 360

AtliQ Hardware aims for a competitive edge through Power BI analytics. This dashboard covers Finance, Sales, Marketing, Supply Chain and Executive view throughout globally.

View Project
Engagement

View Project
on GitHUB

Other Tools

excel

The homepage is like a friendly starting point where you can easily explore other pages in the dashboard.

The displays and measurements are simple for users and can adjust to show the desired results.

Project Details

Objective:
The primary objective of this project was to create a comprehensive dashboard with various perspectives, each offering insights into key financial metrics:

1. Finance view
2. Sales view
3. Marketing view
4. Supply Chain view
5. Executive view

The process includes:
1. Project Overview
2. Project Planning
3. Importing & Exploring Data
4. Data Modelling
5. Dashboard Designing
6. Project outcomes

Live Interactive Dashboard

PowerBI Project

Hospitality Analysis

This study demonstrates the enormous potential of data analytics in the hotel industry. This analytics dashboard enables AtliQ Grand to improve its hospitality offerings and make more data-driven decisions to ensure its success.

View Project
Engagement

View Project
on GitHUB

Other Tools

excel

The KPIs with more visuals attracts stakeholders to have a glimpse of dashboard

The Detailed analysis by Revenue, Occupancy, Booking and Rating.

Project Details

Context:
AtliQ Grand, a well-known hotel chain, approached us with a clear objective to improve their decision-making processes and enhance operational efficiency. They expressed a strong desire to leverage the potential of data to enhance the guest experience and increase profitability.

The Approach:
1️⃣ Data Importation
2️⃣ Data Validation
3️⃣ Data Modeling (including some transformation and cleansing using Power Query)
4️⃣Crafting Measures using DAX
5️⃣Designing a Dashboard with the right visualizations

Key Performance Indicators (KPIs):*
Total Revenue
RevPAR (Revenue per Available Room)
DSRN (Daily Sellable Room Nights)
ADR (Average Daily Rate)
Realization Percentage
Occupancy Percentage

Live Interactive Dashboard

SQL Project

Consumer Goods Ad-hoc Insights

AtliQ Hardware is one of the leading computer hardware producers in India and well expanded in other countries too. However, the management noticed that they do not get enough insights to make smart data-informed decisions. The company has presented 10 ad-hoc requests for which they want insights.

View Project
on GitHUB

Project agenda

SQL request's output

Project Details

Here As a Junior Data Analyst, My task is to write SQL queries for the Ad-Hoc request and convert them to visualization, then present them to Top-Level Management helping them to make quick and smart data-informed decisions.

In this project, I have used tools like:
1) 𝐌𝐲𝐒𝐐𝐋 - to query the database
2) 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 - to visualize the data
3) 𝐏𝐨𝐰𝐞𝐫𝐏𝐨𝐢𝐧𝐭 - to present the Insights

⭐️𝟑 𝐓𝐡𝐢𝐧𝐠𝐬 𝐥𝐞𝐚𝐫𝐧𝐞𝐝 𝐟𝐫𝐨𝐦 𝐭𝐡𝐢𝐬 𝐂𝐡𝐚𝐥𝐥𝐞𝐧𝐠𝐞:
1. Acquired advanced SQL skills including Cross Join, CTEs, Subqueries, and windows functions.
2. Mastered the art of converting ordinary Year to fiscal year, expanding my data analysis capabilities.
3. Enhanced my Domain knowledge on fiscal year, Gross Sales, Pre-invoice deduction, and channels, paving the way for more insightful data-driven decisions.

PowerBI Project

AtliQ Mart’s Analysis

Analyzed sales data to evaluate promotion effectiveness, highlighting trends and insights. Recommendations emphasized focusing on successful strategies and reconsidering less effective ones.

View Project
Engagement

View Project
on GitHUB

SQL query

Dashboard

Project Details

AtliQ Mart conducted extensive promotions across 50 stores in southern India during Diwali 2023 and Sankranti 2024. The Sales Director sought insights into their effectiveness. Peter Pandey, the data analyst, was tasked with analyzing sales trends, creating user-friendly dashboards, and presenting actionable insights. Cashback and BOGOF promotions were highly effective, while 25% and 50% off promotions showed negative impacts on revenue and sales. Recommendations include focusing on successful promotions and reconsidering less effective strategies for future campaigns. Key metrics analyzed included Sales Revenue, Incremental Revenue %, Incremental Sales Units %, and Average Sales Price.

Project video

Live Interactive Dashboard

PowerBI Project

Shield-Insurance-Analysis

Completed presentation on Shield Insurance Analysis Dashboard! Explored insurance data for strategic insights. Segmented into 3 pages for comprehensive analysis, including General view, Sales view and age group breakdown.

View Project
Engagement

View Project
on GitHUB

Policies overview and Fundamental observation

General View

Project Details

Presenting the completion of my presentation on the Shield Insurance Analysis Dashboard. Shield Insurance Services, a leading provider of comprehensive insurance solutions, aimed to leverage data insights for strategic decisions. The project addresses challenges in analyzing vast insurance data by offering a comprehensive overview. The dashboard, segmented into 3 pages, provides insights into General view, Sales view and age group segmentation. Users can dynamically explore data using filters, slicers, and drill-down features, enabling tailored analysis for informed decision-making. This project showcases my expertise in data analytics and contributes to driving innovation in the insurance landscape.