Swarali Dadhi
Pune
Summary
Business Analyst specializing in data querying, problem-solving, and business process optimization. Expertise in SQL, Excel, and Python, with a proven track record of collaborating with cross-functional teams to implement solutions that improve decision-making and operational efficiency. Skilled in converting data into actionable insights through dashboards and visualizations to drive strategic initiatives.
Overview
1
1
year of professional experience
1
1
Certification
Work History
Machine Learning & Data Science Intern
Vital Skills – Techkriti, IIT Kanpur
06.2025 - Current
- Learning and applying machine learning concepts including supervised and unsupervised algorithms.
- Gaining hands-on exposure to data preprocessing, feature engineering, and model evaluation techniques.
SQL/Database Management Intern
Brainwave Matrix Solutions
02.2025 - 04.2025
- Wrote and optimized complex SQL queries for large datasets to support business reporting needs.
- Designed normalized database schemas and indexed tables to improve query performance.
- Supported data integration and report generation using Python scripts and SQL.
Power BI Intern
Codtech IT Solutions
01.2025 - 04.2025
- Developed an end-to-end sales performance dashboard showing KPIs, trends, and category breakdowns.
- Integrated data from Excel and SQL Server using Power Query for dynamic reporting.
- Leveraged Python scripts within Power BI for custom visualizations and calculations.
Business Analytics Intern
Cognifyz Technologies
01.2025 - 02.2025
- Conducted correlation and trend analysis on investment data to identify user behavior patterns.
- Presented actionable insights via Power BI visualizations and Excel dashboards.
Data Analyst Intern
Internship Studio
08.2024 - 11.2024
- Automated reports using SQL and Excel, reducing manual effort by 60%.
- Designed ER diagrams and normalized databases for reporting automation.
- Supported UAT sessions, resolved bugs, and enhanced data pipeline processes.
Education
Bachelor of Science - Computer Science
Savitribai Phule Pune University
Nashik06.2017
Skills
- MySQL
- Python (Pandas, NumPy)
- Tableau and Power BI
- Excel and pivot tables
- Data cleaning and dashboarding
- Agile methodologies
- Problem solving
- Team collaboration
- Analytical and strategic thinking
- Workflow optimization
- Stakeholder management
- Attention to detail
- Effective communication
Certification
- Post-Graduation Certification in Data Science - IIT Kanpur| June 2025
- Advance Business Analysis - Udemy | Ongoing
- Business Analyst and Scrum Master transformation program| November 2024
- Data analysis certification - internship studio| Nov 2024
- Python programming |Feb 2023
Projects
1. Zomato restaurant dashboard using Power BI dashboard |Tools: Power BI, Excel, DAX, Power Query
- Designed a multi-page interactive Power BI dashboard to analyze global Zomato restaurant data, with drill-down capability across continent, country, and city
- Cleaned and transformed Excel datasets using Power Query, standardized city names, removed irrelevant columns, and created dimension tables for cuisines and countries
- Built key DAX measures (restaurant count, average cost/rating, cuisine count), and dynamic rating color slabs; optimized for both web and mobile viewing
2. Agent performance analysis using Power BI
- Created a Power BI dashboard to analyze insurance agent performance across demographics, product lines, and geographies, using metrics like retention ratio and hit ratio
- Computed growth rates (2006–2013), hit ratios, and performed aggregations at the agency, state, and year levels; evaluated binning strategies for enhanced segmentation
- Visualized insights through agency-wise summaries, state-wise top 10 retention ratios, and quote system analysis by product lines to support data-driven decision-making
3. Excel Sales Dashboard
- designed an interactive sales dashboard in Excel using pivot tables, charts, and user control combo boxes to analyze sales and profit trends by month, region, and product category
- Created dynamic visualizations and tables linked to combo box filters for category-wise drill-down analysis, enhancing user interactivity and decision-making
- Leveraged Data Analysis Tool Pak to compute key metrics and developed region-wise, and time-based insights for business performance monitoring
References
References available upon request.
Timeline
Machine Learning & Data Science Intern
Vital Skills – Techkriti, IIT Kanpur
06.2025 - Current
SQL/Database Management Intern
Brainwave Matrix Solutions
02.2025 - 04.2025
Power BI Intern
Codtech IT Solutions
01.2025 - 04.2025
Business Analytics Intern
Cognifyz Technologies
01.2025 - 02.2025
Data Analyst Intern
Internship Studio
08.2024 - 11.2024
Bachelor of Science - Computer Science
Savitribai Phule Pune University
Similar Profiles
Sree NidasanametlaSree Nidasanametla
Full Stack Developer Intern at E and ICT Academy, IIT KanpurFull Stack Developer Intern at E and ICT Academy, IIT Kanpur
SHIKHAR CHATURVEDISHIKHAR CHATURVEDI
Project Intern at IIT KanpurProject Intern at IIT Kanpur
Oyin MibangOyin Mibang
Students' Counsellor at IIT KanpurStudents' Counsellor at IIT Kanpur
KHUSHBOO RELANKHUSHBOO RELAN
Data Analyst Intern at LabmentixData Analyst Intern at Labmentix
AKSHAY KHAIRNARAKSHAY KHAIRNAR
Software Engineer at Josh Software Pvt.Ltd.Software Engineer at Josh Software Pvt.Ltd.