Shivam Dhale
Results-driven Data Analyst with 1.5+ years of hands-on experience (internships + project delivery) in data analysis, business intelligence, and machine learning. Proficient in Python (Pandas, NumPy, Scikit-learn), advanced SQL, Power BI, and Tableau. Proven track record of delivering 10+ data-driven projects — from interactive BI dashboards and automated ETL pipelines to AI/ML systems — resulting in measurable efficiency gains and actionable business insights.
Currently deepening expertise in Big Data technologies (Hadoop, Spark) through CDAC's PG Diploma in Big Data Analytics. Eager to contribute as a Data Analyst in a growth-oriented organization.
Experience
Data Analysis with Python – Analyst Trainee
IBM SkillsBuild
- Performed end-to-end data wrangling, transformation, and exploratory data analysis (EDA) on 5+ real-world datasets with 50,000+ rows; identified and resolved missing values and outliers to improve data quality by ~35%.
- Developed 10+ production-ready visualizations using Matplotlib and Seaborn, communicating key trends and KPIs to stakeholders during weekly review sessions — improving insight delivery speed.
- Engineered Python automation scripts to eliminate repetitive data processing workflows, reducing manual effort by ~40% across the project lifecycle and enabling faster turnaround on analytical reports.
- Applied statistical techniques including descriptive statistics, correlation analysis, and hypothesis testing to validate data-driven business recommendations. Tools: Python, Pandas, NumPy, Matplotlib, Seaborn, Jupyter Notebook, Git
Power BI Developer – BI Analyst Trainee
Capgemini & ICT Academy
- Designed and deployed 3 fully interactive Power BI dashboards for sales data analysis across 10,000+ records, enabling real-time KPI monitoring and reducing decision latency for business teams.
- Implemented 15+ advanced DAX measures and Power Query transformations for multi-layered data modeling, reducing report refresh time by 30% and improving overall dashboard responsiveness.
- Established a data pipeline from MySQL databases to Power BI, ensuring clean, consistent data flow and setting a reusable template for future BI projects. Tools: Power BI Desktop, DAX, Power Query, MySQL, Excel
Data Analyst Intern
IBM SkillsBuild
- Delivered 3 end-to-end data analysis projects covering data wrangling, statistical analysis, visualization, and insight generation on structured datasets — showcasing full analytical lifecycle competency.
- Collaborated with a cross-functional team of 5 analysts to present findings and data-driven recommendations, directly contributing to improved project decision-making and stakeholder alignment.
- Authored structured data analysis reports that became reference material for onboarding junior analysts in the program cohort. Tools: Python, SQL, Excel, Pandas
Education
CDAC
PG Diploma
Coursework: Big Data, Hadoop, Apache Spark, Data Warehousing, Linux, Java, Advanced SQL, ETL Pipelines
VCET, Mumbai University
B.E.
Coursework: Data Structures, DBMS, Machine Learning, Statistics, Algorithms
Skills
PythonPandasNumPyMatplotlibSeabornScikit-learnSQLJavaCMySQLFunctionsStored ProceduresDelimitersJoinsWindow FunctionsER DiagramsPower BIDAXPower QueryData ModelingTableauExcelPivot TablesVLOOKUPAdvanced ChartsLinear RegressionLogistic RegressionDecision TreesRandom ForestClassification
K E Y P R O J E C T S
India General Election 2024 – Power BI Dashboard
- Engineered an interactive Power BI dashboard visualizing alliance-wise and state-wise election results across all 543 constituencies with drill-through filters, dynamic slicers, and export functionality.
- Built 8 dynamic report pages featuring 20+ DAX-calculated KPIs enabling analysis of 6+ alliances and 30+ states — reducing analytical research time for stakeholders by ~60%. Tools: Power BI, DAX, Power Query, Excel
Hospital Management Dashboard – Power BI
- Developed a comprehensive BI solution tracking patient flow, doctor performance, and 10+ hospital operational KPIs to support data-driven management decisions at scale.
- Reduced manual reporting effort by ~50%; dashboard was formally adopted by the institution as the standard demonstration project for Business Intelligence coursework. Tools: Power BI, DAX, MySQL, Excel
Crime Analysis & Verdict Prediction – AI/ML System
- Built an AI-powered legal analytics system achieving 85%+ prediction accuracy for IPC sections using Random Forest and Logistic Regression models trained on 5,000+ legal case records.
- Integrated Google Gemini API for automated legal text summarization and actionable insight extraction; findings published as a peer-reviewed research paper.
- View Published Research Paper Tools: Python, Scikit-learn, Gemini API, Pandas, NumPy
C E R T I F I C A T I O N S
Data Analysis with Python
Power BI for Data Analytics
Data Analyst Internship Certificate
L E A D E R S H I P & A CT I V I T I E S
Technical Head – Students Council
- Led a team of 10+ members to architect and deliver technical solutions for large-scale college events; strengthened project management, cross-functional collaboration, and stakeholder communication skills.
- Spearheaded technology planning for annual fests and seminars, coordinating with 5+ departments to ensure seamless execution and on-time delivery of all technical deliverables.