Portfolio - ALPANA SINHA

ALPANA SINHA

Data Aspirant

Resume

1

Excel Project

3

PowerBI Projects

About Me

Hello!👋 I'm Alpana Sinha, a dedicated data enthusiast on a journey to become a skilled data analyst. With a solid foundation in mathematics, I'm actively honing my skills in tools like Excel, PowerBI, MySQL, and Python to leverage data and drive informed decisions.

Why Choose Me?

📊 Analytical Mindset: My experience in banking and customer data analysis helps me approach complex problems with clarity.
🛠️ Data Tools Enthusiast: I stay updated with the latest data analysis tools and industry trends.
🧮 Problem-Solver: I enjoy solving real-world challenges through data-driven solutions.
🔍 Detail-Oriented: My keen eye for detail ensures accurate data interpretation and reporting.
🌟 Passion for Growth: I'm committed to continuous learning and improvement.

Key Skills

SQL

PYTHON

STAKEHOLDER MANAGEMENT

EFFECTIVE COMMUNICATION

PROBLEM SOLVING

My Projects

Excel-Sales and Finance Analytics Project of AtliQ Hardwares

Domain/Function: Sales and Finance Analytics

AtliQ- Business Insights--360

Domain/Function: AtliQ- Business Insights--360

AtliQ--Hospitality Analytics

Domain/Function: AtliQ--Hospitality Analytics

Shield - Insurance

Domain/Function: Shield - Insurance

My Experience

Banking, HDFC BANK, Bangalore April 2022-Oct 2023

• Analyzed customer behavior using Excel, Power BI, and SQL, generating in-depth analytical reports and detecting fraud.

• Created detailed fortnightly reports on Temporary Overdraft (TOD) analysis, Large Transactions Report (LTR), and Banking Office

account activities.

• I Identified and filed Suspicious Transaction Reports (STRs), ensuring compliance and enhancing operational oversight.

Banking, ICICI BANK LTD, Bangalore Jan 2019 – March2022

• Enhanced service delivery and achieved operational excellence through workflow optimization and continuous improvement efforts.

• Specialized in establishing and sustaining long-term customer relationships, providing accurate information and superior service.

• Assisted in ETL development, testing, and troubleshooting of ETL issues.

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/alpanasinha

Call Me

+91 9538733842

GitHub

https://github.com/alpanakislay/Alpana-Sinha

Excel Project

Excel-Sales and Finance Analytics Project of AtliQ Hardwares

Domain/Function: Sales and Finance Analytics

The objective of this project is to offer in-depth analysis of the company's financial health and its standing in the market. It involves generating a range of reports such as "Customer Net Sales Performance" and "Market Performance vs. Target" using a combination of fundamental and advanced Excel.

View Project
Engagement

View Project
on GitHUB

The Customer Performance Report displays the yearly net sales performance for each customer.

This report allows stakeholders to evaluate the country's performance over multiple years and compare it to the established targets.

Project Details

In this project, I have created a sales report utilizing Excel pivot tables. This report serves as a valuable tool for businesses to determine optimal customer discounts, streamline negotiation processes, and identify opportunities for expanding into promising markets. The reports I've crafted offer actionable insights to assist businesses in enhancing their sales strategies, enhancing customer satisfaction, and increasing revenue.
Throughout this project, I have acquired expertise in the following areas:
1. Utilizing pivot tables
2. Harnessing the capabilities of Power Query
3. Grasping the fundamentals of DAX (Data Analysis Expressions)
4. Enhancing data presentation through conditional formatting
5. Improving the visual appeal of reports
6. Gaining insights into sales-related metrics
Overall, this project revolves around equipping businesses with the tools and knowledge necessary to enhance their sales efforts. By delving into sales data, businesses can uncover growth.

PowerBI Project

AtliQ- Business Insights--360

Domain/Function: AtliQ- Business Insights--360

AtliQ Hardware faced challenges managing data within Excel. Objective: Shift from Excel to Power BI for better comprehension. Goal: Achieve insights into finance, sales, and supply chain areas. Data Volume: 1.8 million entries. Tools Used: SQL, Power BI, Excel, DAX Studio.

View Project
Engagement

View Project
on GitHUB

All the views of the dashboard : finance view, sales view, marketing view, supply chain view, executive view and support View

The finance view filters according to region market, customer segment and fiscal years filters.

Project Details

This project, which combines Power BI, SQL, and Excel, centers around addressing operational issues at AtliQ Hardware, a prominent global consumer electronics company. The company's heavy reliance on Excel for data analysis has led to significant losses in some regions. To rectify this, senior management aims to initiate a data analytics project, leveraging data from the previous year to enhance performance and drive improvements.
💼Finance View: shows profit and loss statement like GM,NP,NS etc. and performance over time chart w.r.t to key metrices.
📣Sales View: Shows customers and product performance , unit economics and performance matrix by NS and GM%
📣 Marketing View: Shows region and product performance , unit economics and performance matrix by NS and GM%
🚚 Supply Chain View: shows forecast accuracy, Net Error, trends and key metrices by customers and product.
👨‍🎓 Executive View: shows market share of competitors, trends,revenue by division and channel, top 5 customer

Project video

Live Interactive Dashboard

PowerBI Project

AtliQ--Hospitality Analytics

Domain/Function: AtliQ--Hospitality Analytics

This project serves as a prime example of how data can bring about a significant transformation in the hospitality sector. It accomplishes this by delving into essential metrics like Revenue, ADR, RevPAR, Occupancy%, Realization%, Cancellation%, DBRN, DSRN, and more.

View Project
Engagement

View Project
on GitHUB

Occupancy % city: Occupancy % is high for the Delhi followed by Hyderabad, Mumbai and Bangalore.

Data Modelling for the AtliQ--Hospitality Analytics Project

Project Details

AtliQ Grands, renowned for its chain of five-star hotels across India, boasts a rich 20-year history in the hospitality sector. Nevertheless, they currently grapple with diminishing market share and revenue in the luxury and business hotel segment, attributed to competitive pressures and less effective management choices. In response to this challenge, the managing director of AtliQ Grands is embarking on a strategic initiative to integrate "Business and Data Intelligence" into their operations. The primary aim is to recapture market share and bolster revenue.
ACHIEVED OBJECTIVES
1. Formulated metrics in accordance with the provided metric list.
2. Designed a dashboard aligning with stakeholder-provided mock-up.
3. Generated valuable insights extending beyond the specified metric list and mock-up dashboard.
UTILIZED SKILLS
4. Leveraged Power BI
5. Employed SQL
6. Harnessed Excel
7. Utilized DAX Studio

Project video

Live Interactive Dashboard

PowerBI Project

Shield - Insurance

Domain/Function: Shield - Insurance

Explored Shield Insurance customer behavior & sales trends using Power BI in a data analytics bootcamp by Codebasics. Completed an end-to-end project during my data analytics internship, analyzing provided CSV files.

View Project
Engagement

View Project
on GitHUB

Home page :3-page report- 1. General View 2. Sales View 3. Age Group Analysis:.

This general view provides a snapshot of revenue and customer trends, enabling exploration of key insights.

Project Details

Employed Power BI for an in-depth analysis of Shield Insurance. Explored revenue, customer behavior, city trends, sales modes, and age group dynamics. Generated a comprehensive report leading to strategic decisions and actionable recommendations. Contributed to an 8-10% revenue growth projection and expanded market presence via data-driven insights.