I build end-to-end analytics projects that solve real business problems — turning raw data into insights that improve profitability, retention, and operational performance. Across 4 projects spanning Banking, SaaS, Retail, and Logistics, I apply the same rigorous process: SQL analysis → business insight → dashboard → actionable recommendation.
📫 LinkedIn · 📧 shrutikhandelwal1213@gmail.com
Business Problem: Evaluate the profitability of a credit card portfolio and identify where revenue is being lost through fees, rewards, and delinquencies.
- Analyzed 10,000 customers, 150,000 transactions, and 12 months of portfolio data
- Built a 5-page executive Power BI dashboard for leadership reporting
- Quantified revenue leakage from cashback, rewards, and fee waivers
- Evaluated profitability by card product and customer segment
- Analyzed delinquency trends to assess portfolio health and risk
- Delivered recommendations to improve profitability and reduce financial risk
Tools: SQL • MySQL • Power BI • Excel View Project →
Business Problem: Identify which customer segments drive revenue and understand retention patterns to improve customer lifetime value.
- Performed RFM segmentation to identify high-value and at-risk customers
- Conducted cohort analysis to measure retention over time
- Analyzed repeat purchase behavior and revenue concentration
- Built an executive KPI dashboard with segment-level insights
- Recommended strategies to improve retention and revenue growth
Tools: SQL • Power BI • Excel View Project →
Business Problem: Identify revenue concentration and churn risk within a SaaS subscription business.
- Analyzed customer engagement and subscription revenue patterns
- Identified accounts contributing the highest revenue concentration risk
- Evaluated activity trends as early indicators of churn
- Built an executive dashboard for revenue and customer health monitoring
- Proposed recommendations to improve recurring revenue and retention
Tools: SQL • Power BI • Python View Project →
Business Problem: Improve logistics performance by analyzing delivery delays, SLA breaches, and operational cost leakage.
- Evaluated delivery performance across shipment records
- Measured SLA breach rates and delay patterns
- Identified sources of operational cost leakage
- Built a logistics performance dashboard for ops reporting
- Recommended process improvements to reduce delays and improve efficiency
Tools: SQL • Power BI • Excel View Project →
| SQL | Power BI | Python | Excel |
|---|---|---|---|
| Joins & Subqueries | DAX | Pandas | Pivot Tables |
| CTEs | Power Query | NumPy | Lookup Functions |
| Window Functions | Data Modeling | Matplotlib | Conditional Formatting |
| KPI Calculations | Interactive Dashboards | Exploratory Data Analysis | Dashboard Development |
Core Expertise: Revenue & Profitability Analysis · Customer Segmentation · Churn & Retention Analysis · Operational Analytics · Executive KPI Reporting
Advanced SQL for Business Analytics · Advanced Power BI · Python for Data Analytics · Banking & Financial Analytics