Soumyadeep Dhar

Data Analyst

[email protected] +91 8902568134

Resume

Hello, I am

Soumyadeep Dhar.

2

Excel
Projects

2

PowerBI
Projects

1

SQL
Project

2

Python
Projects

About Me

Hi, I’m Soumyadeep 👋
A passionate data analytics enthusiast 📊

I turn complex data into clear, actionable insights that drive real business growth. I work at the intersection of data engineering, BI, and automation — building solutions that improve how organizations make decisions.

🛠️ Skills:
· SQL
· Python
· Excel
· Power BI
· Tableau
· AI Automation
· Data Engineering

🎯 I specialize in interactive dashboards, workflow automation, business apps, and uncovering growth insights — replacing manual, siloed processes with scalable, structured systems.

🧠 My approach:
I ask why before building — blending curiosity with best practices to deliver work that's both rigorous and impactful.

🚀 Aspiring to grow into a Data Analytics / Engineering role, expanding into cloud platforms and advanced analytics.

✨ Let's connect and build something impactful.

Key Skills

POWER BI

SQL

TABLEAU

PYTHON

STAKEHOLDER MANAGEMENT

EFFECTIVE COMMUNICATION

ANALYTICAL THINKING

ETL

My Projects

Customer Shopping Behavor Analysis

Domain/Function: Retail

Ad_Hoc Analysis of AtliQ Hardware

Domain/Function: Consumer Goods

Hotel Booking Cancellation Analytics

Domain/Function: Hospitality

Blinkit-Project

Domain/Function: Quick Commerce

Tableau Sales Performance Analytics Dashboard

Domain/Function: Sales & Marketing

UBER Mobility & Ride-Hailing Analytics

Domain/Function: Transportation & Ride-Share

Healthcare-Analytics (Patient Wait List Analysis)

Domain/Function: Healthcare

Sales and Finance Analytics

Domain/Function: FMCG

My Experience

AtliQ Technologies - Data Analyst intern (Remote)

November 2025 - Present

Completed a virtual internship, working on real-world business scenarios in Sales , Supply Chain , Finance & Insurance domains.

Gained hands-on experience in SQL, Excel & Python applying concepts like data cleaning, transformation and visualization.

Built interactive dashboards using Power BI & Tableau incorporating DAX measures, time intelligence, field parameters, and bookmark navigation to enable dynamic storytelling.

Practiced Medallion architecture to structure data flows for efficient analysis and reporting.

Applied business storytelling techniques to turn complex data into clear, actionable insights for stakeholders.

Delivered 4+ end-to-end analytics projects across hospitality, retail, and consumer goods, building Power BI dashboards and Python EDA pipelines that reduced stakeholder reporting time by ~30%.

Tata Consultancy Services -Fraud Analyst (Full Time)

June 2018 - October 2019

Process Associate – Fraud Analyst

Credit Card BPO.

Worked as a Fraud Analyst in a BPO environment, monitoring and investigating credit card transactions to detect and prevent fraudulent activity on behalf of a leading banking client. Responsible for real-time fraud detection, account verification, risk assessment, and resolving fraud disputes while ensuring compliance with banking regulations and maintaining SLA targets.

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

Data Engineering Basics for Data Analysts

Scam Awareness Course

Databricks 14 Days AI 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.

Mail Me

[email protected]

https://www.linkedin.com/in/soumyadeep-dhar-785724333/

Call Me

+91 8902568134

GitHub

https://github.com/dharsoumyadeep96

Python Project

Customer Shopping Behavor Analysis

Domain/Function: Retail

End-to-End Retail Analytics Project analyzing 3,900 customer transactions using Python, MySQL & Power BI to uncover spending patterns, customer segments, and actionable business insights.

View Project
Engagement

View Project
on GitHUB

View Project
on Power Bi

Data Analytics Project | Python • SQL • Power BI

Customer Behavior Dashboard: 3.9K customers, avg purchase $59.76, avg rating 3.75. Clothing leads revenue (104K). 73% unsubscribed. Young Adults top spenders (62K). Filterable by gender, category & shipping.

Project Details

End-to-End Data Analytics Project | Python • SQL • Power BI

A comprehensive retail analytics project analyzing 3,900 customer transactions to uncover spending patterns, customer segments, product preferences, and subscription behavior — translating raw data into actionable business strategy.

SQL Project

Ad_Hoc Analysis of AtliQ Hardware

Domain/Function: Consumer Goods

AtliQ Hardware, a leading computer hardware producer, faced challenges in making data-driven decisions. To solve this, they needed a comprehensive report to analyze business queries. This involved utilizing SQL for data analysis presentation with actionable insights.

View Project
Engagement

View Project
on GitHUB

View Project
on MYSQL

SQL query retrieves Atliq Exclusive's 8 APAC markets: India, Indonesia, Japan, Philippines, South Korea, Australia, New Zealand & Bangladesh — spanning developed and emerging economies across Asia-Pacific.

Top 5 India discount seekers (2021): Flipkart 30.83%, Viveks 30.38%, Ezone 30.28%, Croma 30.25%, Reliance Digital 30.25%. SQL uses AVG pre-invoice discount filtered by market & fiscal year.

Project Details

Company: AtliQ Hardwares (an imaginary leading computer hardware producer in India with a global presence)

Challenge: AtliQ Hardwares aimed to enhance data-driven decision-making by expanding their analytics team. Tony Sharma, the Data Analytics Director, devised a SQL challenge to evaluate candidates' technical and soft skills.

My Task: As a hypothetical applicant, I Reviewed 'ad-hoc-requests.pdf' with 10 business queries.
Crafted and executed SQL queries.

Approach: Utilized MySQL for data retrieval and analysis.

Outcome: This project demonstrated my ability to handle complex data queries and present findings effectively, enhancing both my technical & problem solving ability.

Project video

Python Project

Hotel Booking Cancellation Analytics

Domain/Function: Hospitality

End-to-End Python Data Analysis Project Analyzing hotel booking cancellations to reduce revenue leakage and optimize operational efficiency in the hospitality domain.

View Project
Engagement

View Project
on GitHUB

View Project
on Jupyter Notebook

City Hotels have a 41.7% cancellation rate (33,100 of 46,200 bookings) vs Resort Hotels at 27.8% (11,100 of 28,900)—a 14-point gap. Interventions must target City Hotels aggressively.

118,897 bookings show a critical 37.1% cancellation rate ($102 ADR, 3.2% repeat guests). Revenue leakage is driven by pricing, lead time & channel (47.4% OTA). Fixes: risk-based deposits, dynamic pricing, channel diversification.

Project Details

This project addresses the critical business problem of high cancellation rates affecting both City Hotels (41.7%) and Resort Hotels (27.8%). Through comprehensive data analysis of 118,897 booking records, we identify key drivers of cancellations and provide actionable strategic recommendations.

Project video

Excel Project

Blinkit-Project

Domain/Function: Quick Commerce

This detailed presentation highlights an end-to-end analytics project for the largest quick-commerce platform in India, Blinkit (formerly Grofers). From $1.20 million in sales data representing 8,523 transactions across a 12-year period (2011-2022), the analysis provides strategic insights.

View Project
Engagement

View Project
on GitHUB

View Project
on MS Excel

Insights

KPI

Project Details

The objective is to use Microsoft Excel's defined Key Performance Indicators (KPIs) and data visualizations to extract actionable insights and optimization opportunities. It focuses on creating a highly comprehensive as well as interactive report on sales and financials leveraging the advanced techniques of Excel.This detailed presentation highlights an end-to-end analytics project for the largest quick-commerce platform in India, Blinkit (formerly Grofers). From $1.20 million in sales data representing 8,523 transactions across a 12-year period (2011-2022), the analysis provides strategic insights.Conduct a thorough business intelligence analysis of Blinkit's inventory distribution, customer satisfaction, and sales performance.

Tableau Sales Performance Analytics Dashboard

Domain/Function: Sales & Marketing

A comprehensive data visualization project built with Tableau, showcasing interactive dashboards and data-driven insights through visual analytics.Analyzed sales performance across multiple product categories, achieving total revenue of $984M+ .

View Project
Engagement

View Project
on GitHUB

View Project
on Tableau

Strong Revenue, Thin Margins: Total Revenue of $984.87M with 2.4M units sold, yet Total Profit is only $24.66M — yielding a ~2.5% profit margin, indicating high volume but inefficient profit conversion.

Customer Profitability Matrix: Leader (6.59%) is the star; Sage (4.14%) solid; Electricalsara (2.34%) near breakeven; Excel Stores (0.82%) low margin; Expression (-2.01%) unprofitable — dragging overall margins down.

Project Details

This project demonstrates advanced data visualization techniques using Tableau to analyze and present complex datasets through interactive dashboards. The visualizations provide actionable insights into key metrics and business performance indicators.

💡 Technical Skills Applied :

💻 Tableau Desktop
📊 Data Visualization
📈 Business Intelligence
🧮 Sales Analytics
🎯 KPI Development

PowerBI Project

UBER Mobility & Ride-Hailing Analytics

Domain/Function: Transportation & Ride-Share

This Project includes a comprehensive end-to-end Power BI analysis of Uber's business performance. It converts unprocessed ride-level data into useful insights about operations, revenue, consumer behavior, geographic trends, and strategic suggestions.

View Project
Engagement

View Project
on GitHUB

Uber Overview dashboard: 93K monthly bookings, 52M revenue, 149K completed/37K cancelled/19K incomplete rides. Auto leads revenue at 13M. Top pickup: Khandsa. Customer rating: 4.40⭐, Driver: 4.23⭐

Uber Revenue dashboard: 150K trips, 52M revenue, avg fare ₹345.64, UPI trending. MoM growth peaked in Mar (+15%). Top month: 4.57M. UPI leads payments at 23M. Top customer C7828101 at 7.7K.

Project Details

Uber is a global mobility platform that uses real-time technology to connect drivers and passengers.Using reliable data modeling and visualization, this project seeks to examine trip performance, cancellation patterns, revenue trends, and operational effectiveness.This Project includes a comprehensive end-to-end Power BI analysis of Uber's business performance. It converts unprocessed ride-level data into useful insights about operations, revenue, consumer behavior, geographic trends, and strategic suggestions.

Project video

Live Interactive Dashboard

PowerBI Project

Healthcare-Analytics (Patient Wait List Analysis)

Domain/Function: Healthcare

An intensive end-to-end Power BI analysis of healthcare patient wait list management and hospital operations. This project transforms raw patient data into actionable insights about wait times, patient demographics, specialty performance, case type distribution, and operational efficiency trends.

View Project
Engagement

View Project
on GitHUB

Dashboard Overview : 709K current vs 640K previous year waitlist. Outpatients dominate (72.49%). Top speciality: Paed Orthopaedic (264). Outpatient trend rising to 629K by Jan 2021.

Insights

Project Details

An entire Power BI healthcare analytics solution for monitoring and evaluating patient data in
various settings (day case, inpatient, and outpatient).
This healthcare analytics solution provides hospital administrators and healthcare managers
with real-time visibility into patient wait lists across different care settings, enabling data-driven
decisions to optimize patient flow and resource allocation.

Project video

Live Interactive Dashboard

Excel Project

Sales and Finance Analytics

Domain/Function: FMCG

I developed comprehensive Sales and Financial reports to give the sales team deeper insights into customer performance and market trends, helping them better assess progress against their targets.

View Project
Engagement

View Project
on GitHUB

View Project
on MS Excel

For the Customer Performance Report, I analyzed sales trends over time, while the Market Performance vs. Targets Report identified gaps and success.

Gross Margin % of quarters

Project Details

In this project, I developed a series of reports aimed at delivering in-depth insights for stakeholders:
Customer Performance Report: Analyzed sales data and growth trends to understand customer behavior over time.
Market Performance vs Sales Targets Comparison: Conducted a detailed analysis of market performance versus sales targets to identify achievements and gaps.
Profit & Loss (P&L) Reports by Fiscal Year & Months: Evaluated financial performance across different time frames to reveal profitability trends.
P&L Reports by Markets: Benchmarked market-wise financial performance against industry standards.

Developed a complete lifecycle of an Excel-based project. Automated the data cleaning and processing using Power Query, which can save around 4 hrs of repeated manual work. It’s provided a better user experience and flexibility.