Sidhharth Solanki

Technology used: SQL, Python and its libraries (Numpy, Pandas, Matplotlib & Seaborn, Excel, Power BI, EDA, Statistics and Mathematics, Machine Learning). Tools: Jupiter Notebook, VS code.

Intern Data Analyst - ITroots Pvt, Ltd. - Pune

(2025-12)

Technology used: SQL, Python and its libraries (Numpy, Pandas, Matplotlib & Seaborn, Excel, Power BI, EDA, Statistics and Mathematics, Machine Learning). Tools: Jupiter Notebook, VS code.

• Improved data quality by cleaning and pre-processing datasets, reducing errors and inconsistencies by 30%+, leading to more accurate analysis.
• Developed and optimized advanced SQL queries, reducing data retrieval time by 25% and improving reporting efficiency.
• Performed Exploratory Data Analysis (EDA) to uncover key trends, helping identify actionable business insights that supported decision-making.
• Designed interactive Power BI dashboards to track KPIs, improving data visibility and reducing manual reporting efforts by 40%.
• Automated repetitive data analysis tasks using Python (Pandas, NumPy), saving hours of manual work per week.
• Utilized Excel tools (Pivot Tables, XLOOKUP, charts) to generate reports, enhancing productivity and speeding up analysis by 20%.
• Detected and handled missing values and outliers, improving model/data reliability and consistency.
• Created clear and impactful visualizations (Matplotlib, Seaborn), making complex data easier to understand for non-technical stakeholders.

Master of Computer Applications - Computer Applications - Savitribai Phule Pune University

Bachelor of Computer Applications - Computer Applications - Manipal University Jaipur

HSC - Maharashtra State Board of Secondary and Higher Education

SSC - Central Board of Secondary Education