shrawan = {
"name" : "Shrawan Kumar",
"role" : "Aspiring Data Analyst",
"location" : "Jaipur, Rajasthan, India π",
"phone" : "+91 7296976201",
"education" : ["Data Analytics @ Fusion Software Institute, Pune (2024β25)",
"BBA @ Rajasthan University (2025β28)"],
"focus" : ["Data Analysis", "Dashboard Design", "Machine Learning"],
"motto" : "Turning raw data into actionable insights π"
}Aspiring data analyst with hands-on experience in SQL, Python, Excel, and Power BI through academic and project work. Skilled in data analysis, visualization, and building dashboards. Eager to apply analytical skills to help organizations make data-driven decisions.
| Category | Tools |
|---|---|
| Languages | |
| BI & Visualization | |
| Python Libraries | |
| Data Skills | Data Cleaning Β· Data Manipulation Β· Data Visualization Β· Data Modeling Β· DAX Β· Power Query |
Developed an interactive car sales analysis dashboard to analyze revenue trends, dealer performance, customer purchasing behavior, and product demand.
- π Analyzed sales trends by region, dealer, and vehicle type
- π Identified top-performing dealers and high-revenue segments
- π° Created revenue contribution analysis (Top 5 vs Others)
- π Built interactive visualizations for management reporting
- π― Calculated KPIs: Total Revenue, Total Sales, Avg Selling Price, Top Dealers
Power BI DAX Excel Data Modeling Power Query
Developed a predictive credit risk model to help financial institutions reduce default losses. Identified high-risk customer segments and key factors impacting default probability.
- π Calculated overall default rate and identified high-risk segments
- π Analyzed impact of loan amount and duration on default probability
- βοΈ Performed feature importance analysis to detect major risk drivers
- π Compared model performance using Accuracy, Precision, Recall, and F1-score
- π‘ Provided data-driven recommendations for reducing credit risk
Python Pandas NumPy Matplotlib Seaborn Scikit-learn
Developed a cricket analytics dashboard for player performance analysis and Final XI prediction using role-based classification and statistical comparison.
- π― Role-based player classification using batting and bowling metrics
- π Statistical comparison for Final XI selection
- ποΈ Integrated SQL queries for efficient data extraction and reporting
Python Pandas SQL Power BI
| Certificate | Issuer | Date |
|---|---|---|
| ποΈ SQL for Data Science | Newton School | Feb 2025 |
| π Data Analysis | GROWAI Edtech | Mar 2025 |
| π Microsoft Excel | Webdox Computer Institute | Feb 2025 |
| π Data Analytics | Fusion Institute for Data Analytics & Data Science | Feb 2025 |
π Jaipur, Rajasthan, India Β |Β π +91 7296976201 Β |Β βοΈ shrawandesai76@gmail.com
"Data is the new oil β and I'm here to refine it." β‘