MEET DHOLAKIA

Data Analytics & Business Intelligence Professional

Ahmedabad

Summary

Results-driven and detail-oriented recent graduate with a Master's degree in Business Intelligence & Analytics and a Bachelor's degree in Data Science. Expertise in end-to-end data processing, reporting, and visualization using SQL, Python, Power BI, Tableau, and MS Excel. Strong analytical skills aimed at enhancing decision-making processes and optimizing operational efficiency within a dynamic organization. Committed to transforming complex data into actionable insights that drive strategic initiatives.

Overview

Certifications

Work History

Data Science Intern

Bharat Intern

11.2023 - 12.2023

Developed a classification model to predict passenger survival on the Titanic using the Kaggle Titanic dataset. Achieved and accuracy of over 80%.
Performed EDA to identify key survival factors such as age, gender, and passenger class using the pandas library in Python, and plotted them in graphs using Seaborn and Matplotlib.
Handled missing data and outliers by implementing imputation techniques and feature engineering to improve model performance.
Built and evaluated multiple machine learning models, including logistic regression, support vector machines, and random forests, selecting the best-performing model based on accuracy, precision, and recall.

Education

MSc-IT - Business Intelligence & Analytics

Gujarat University

Ahmedabad, India

04.2001 -

BSc - Data Science

Indus University

Ahmedabad, India

05-2023

Skills

Data Analysis & Visualization:

Power BI, Tableau, Excel (Advanced)
SQL & Databases:

SQL, MySQL
Programming:

Python (Pandas, NumPy, Matplotlib, Seaborn)
BI & Reporting:

DAX, Power Query, Data Modeling, Dashboard creation
Business Analysis:

Requirement Gathering, KPI Analysis, Stakeholder Reporting
Statistics:

Descriptive Analysis, Hypothesis Testing, Trend Analysis
Tools:

Power BI Service, Jupyter Notebook

Academic Projects

Sentiment Analysis on COVID-19 Tweets & News Data

Performed sentiment analysis on Twitter and news datasets using Python, NLP, and machine learning techniques to analyze public opinion during the COVID-19 pandemic.
Executed text preprocessing, feature extraction, and exploratory data analysis using Pandas and NumPy to identify sentiment trends.

Exploratory Data Analysis (EDA) on AMCAT Dataset

Conducted data cleaning and analysis on candidate skills, academic background, test scores, and salary data using Python (Pandas, NumPy).
Created statistical insights and visualizations (histograms, heatmaps, pie charts) using Matplotlib and Seaborn to uncover patterns and correlations.

E-Commerce Sales Dashboard using Power BI

Developed an interactive Power BI dashboard using Power Query, data modeling, and DAX to analyze and monitor e-commerce sales performance.
Designed KPI-driven visual reports to provide actionable business insights for decision-making.

Certification

[MS Excel Pivot charts & tables ], [SkillNation]

Timeline