About Experience Projects Skills Contact Resume ↗
Shivam Kasaudhan
Shivam Kasaudhan Open to Work
Available for Data Analyst Roles

Shivam
Kasaudhan

I build end-to-end analytics solutions that solve real business problems — from raw SQL data modeling to interactive Power BI dashboards. My focus: find where the business is losing value and quantify it.

View Projects Get in Touch
5+Projects
100K+Records Analyzed
3Core Tools
🔗
Supply Chain Analytics
SQL · Power BI · Inventory Optimization
Dashboard Preview
🛒
E-Commerce Revenue Analysis (Olist)
SQL · Power BI · 100K+ Records
Dashboard Preview
✅
Olist Data Quality & Validation
SQL · Python · Data Profiling
GitHub
💳
Credit Card Transaction Analysis
SQL · Power BI · Customer Intelligence
Dashboard Preview
🧩
Customer Segmentation (ML)
Python · K-Means · Scikit-learn
Dashboard Preview
SQLPower BIPythonData ModelingDAXPandasMySQLCTE & Window FunctionsStatistical AnalysisK-Means ClusteringPareto AnalysisSupply Chain AnalyticsCustomer SegmentationBusiness Intelligence SQLPower BIPythonData ModelingDAXPandasMySQLCTE & Window FunctionsStatistical AnalysisK-Means ClusteringPareto AnalysisSupply Chain AnalyticsCustomer SegmentationBusiness Intelligence
01 — About

I don't just report data.
I find where the money is leaking.

5+End-to-End Projects
100K+Records Analyzed
B.E.Engineering (Pursuing)
3Core Platforms
Primary Tools
SQL / MySQLPower BIPythonExcel
Libraries
PandasNumPyScikit-learnDAX
Techniques
CTE & Window FunctionsData ModelingPareto AnalysisClusteringCohort AnalysisStatistical AnalysisData ValidationKPI Design

I'm a Data Analyst who builds end-to-end solutions — from raw data extraction in SQL to interactive Power BI dashboards that non-technical stakeholders can actually use.

My approach is business-first, data-second. I start with the business question — "Where are we losing revenue?" or "Which customers are we about to lose?" — then reverse-engineer the data pipeline to answer it. Pretty dashboards that don't move decisions are worthless to me.

I've worked across supply chain, e-commerce, HR, and financial datasets. My strongest work involves identifying hidden profitability leaks: loss-making logistics orders, slow-moving inventory, and high-churn customer segments that look fine in aggregate but bleed money at the row level.

Currently deepening expertise in advanced SQL, Python-based statistical analysis, and building a project portfolio that demonstrates genuine problem-solving — not tutorial reproductions.

RoleData Analyst
SpecializationBusiness Analytics · Revenue Analysis · Customer Intelligence
LocationGorakhpur, Uttar Pradesh, India
EducationB.E. — Institute of Technology & Management, GIDA (2022–Present)
Open ToData Analyst Roles · Analytics Internships · Remote & Hybrid
LinkedIn/in/shivamkasaudhan1111 ↗
02 — Project Experience

What I built
& what problem it solved.

2025 · SQL · Power BI

Supply Chain Analytics & Inventory Optimization

SQL · Power BI · DAX · Data Modeling · Inventory Analysis
  • Analyzed end-to-end supply chain data to flag stockout risks, overstock conditions, and shipment delays impacting operational efficiency.
  • Built SQL analytical views and a Power BI dashboard tracking revenue, profit, inventory turnover, and on-time delivery KPIs in real time.
  • Implemented reorder point and stockout risk logic to identify high-risk SKUs before they caused revenue loss — not after.
  • Detected slow-moving inventory and logistics bottlenecks; translated findings into concrete cost reduction and demand allocation recommendations.
  • Replaced manual spreadsheet-based inventory tracking with a structured, query-driven reporting system.
2025 · SQL · Power BI

E-Commerce Revenue & Customer Behavior Analysis

SQL · Power BI · CTEs · Window Functions · Pareto Analysis
  • Designed a normalized order-level data model from 100K+ transactional records for accurate revenue attribution and customer-level analysis.
  • Built SQL views using CTEs and window functions to track revenue trends, customer retention cohorts, and purchasing frequency over time.
  • Identified loss-making orders where logistics costs exceeded product value — a profitability leak completely invisible in summary-level dashboards.
  • Applied Pareto analysis: top 20% of customers drove 80% of revenue, enabling targeted retention and smarter marketing spend.
  • Delivered a multi-page Power BI dashboard monitoring revenue performance, customer segments, and logistics cost impact by region.
03 — Projects

Full analytics
portfolio.

All on GitHub ↗
01Featured
🔗
Supply Chain Analytics & Inventory Optimization
SQL · Power BI · DAX · Inventory Modeling

End-to-end supply chain analysis covering stockout risk, overstock detection, on-time delivery KPIs, and inventory turnover. Built reorder point logic to flag high-risk SKUs and an operational dashboard that replaced manual spreadsheet tracking entirely.

View on Github →
02Featured
🛒
E-Commerce Revenue & Customer Behavior (Olist)
SQL · Power BI · CTEs · Window Functions · Pareto Analysis

Analyzed 100K+ transactions from Brazil's Olist marketplace. Uncovered loss-making logistics orders invisible in aggregate views, identified top 20% customers driving 80% of revenue, and delivered a multi-page Power BI dashboard for business decision-making.

View on Github →
03Validation
✅
Olist Data Quality & Validation Framework
SQL · Python · Pandas · Data Profiling

Built a systematic data validation pipeline across all 9 Olist dataset tables. Performed schema checks, null analysis, referential integrity tests, duplicate detection, and business rule validation. Documented data quality issues that directly impacted downstream analysis accuracy.

View on GitHub →
04Dashboard
💳
Credit Card Transaction Analysis
SQL · Power BI · Customer Segmentation

Analyzed credit card transaction data to identify spending patterns, high-value customer segments, and transaction volume trends. Built a KPI dashboard tracking revenue, transaction frequency, and behavioral trends across customer groups.

View Dashboard →
05Dashboard
👥
HR Analytics — Attrition & Workforce Insights
Power BI · DAX · Statistical Analysis

Analyzed employee attrition patterns, performance distribution, and workforce demographics. Identified key attrition drivers by department, tenure, and salary band to surface data-driven recommendations for HR decision-making.

View Dashboard →
06ML Model
🧩
Customer Segmentation (Clustering Model)
Python · Scikit-learn · K-Means · Power BI

Applied K-Means clustering to segment customers by purchasing behavior and spending patterns. Integrated ML-generated segments into a Power BI dashboard to deliver actionable customer intelligence for targeting and retention strategies.

View on GitHub →
07Dashboard
📊
Business Performance Dashboard
Power BI · DAX · KPI Design

Developed a Power BI dashboard to monitor overall business performance across revenue, profit, and growth trend KPIs. Enabled quick identification of high-performing segments and underperforming areas for strategic realignment.

View Dashboard →
+
More Projects

SQL scripts, EDA notebooks, and additional analytics work on GitHub.

Explore GitHub →
04 — Technical Skills

Tools I work with
every day.

🗄️
SQL / MySQL
Advanced · CTEs, Window Functions
📊
Power BI
Advanced · DAX, Data Modeling
🐍
Python
Intermediate · Pandas, Scikit-learn
📋
Excel
Advanced · Pivot Tables, Power Query
🔄
Data Modeling
Star Schema · Normalization
📈
Statistical Analysis
Pareto · Cohort · Trend Analysis
🤖
Machine Learning
Clustering · Classification · EDA
🔍
Data Validation
Data Profiling · Quality Checks
05 — Education

Academic
background.

2022 — Present
Bachelor of Engineering
Institute of Technology and Management, GIDA, Gorakhpur
✦ First Class Distinction
2021 — 2022
Higher Secondary (Class XII)
R.C.C Public School, Basti, Uttar Pradesh
✦ First Class Distinction
06 — Contact
Have a data problem
worth solving?
Let's talk.

I'm open to data analyst roles, analytics internships, and serious project collaborations. If you have messy data and need someone who can make sense of it — reach out.

Send Email Download Resume ↗
📍
Location
Gorakhpur, Uttar Pradesh, India
📞
✉️
💼
🐙
📄