I am passionate about leveraging data analytics, business intelligence, and process excellence to solve real-world business problems and enable data-driven decision-making.
My portfolio demonstrates end-to-end analytical projects using SQL, Python, Tableau, Statistics, and Six Sigma, covering customer analytics, operational analytics, feature engineering, statistical analysis, process improvement, and interactive dashboards.
| Category | Skills |
|---|---|
| Programming | SQL, Python |
| Databases | Google BigQuery |
| Data Analysis | Pandas, NumPy |
| Visualization | Tableau, Matplotlib, Seaborn, Advanced Excel |
| Statistics | EDA, Probability, Confidence Intervals, Central Limit Theorem, Hypothesis Testing, ANOVA, Chi-Square Test, Bootstrapping |
| Process Excellence | Six Sigma Green Belt, Six Sigma Yellow Belt, DMAIC, SIPOC, Pareto Analysis, Fishbone Diagram, 5 Whys, Control Charts |
- Target Business Analysis
- End-to-end SQL analysis using Google BigQuery
- Customer behaviour, logistics, payment and business insights
- Global Superstore Sales Analysis
- Interactive executive dashboard
- Sales, Profitability and Regional Performance Analysis
- Netflix Content Analytics & EDA
- Aerofit Customer & Product Segmentation
- Walmart Customer Purchase Behavior Analysis
- Yulu Bike Rental Demand Analysis
- Delhivery Logistics Feature Engineering & Delivery Performance Analysis
These projects demonstrate:
- Data Cleaning
- Exploratory Data Analysis
- Feature Engineering
- Statistical Analysis
- Business Insights
- Data Visualization
Key focus areas:
- Process Improvement
- Operational Excellence
- Root Cause Analysis
- KPI Monitoring
- Continuous Improvement
- Six Sigma Green Belt
- Six Sigma Yellow Belt
- Machine Learning
- Predictive Analytics
- Power BI
- Advanced SQL Optimization
- πΌ LinkedIn: www.linkedin.com/in/swapnildunung
- π§ Email: swapnil.dunung@gmail.com
- π» GitHub: https://github.com/swapnildunung
"Transforming data into meaningful insights and continuous business improvement through analytics and process excellence."