Data Analyst Social Media

Khushi Patel

+1-216-***-**** ***********@*****.*** https://www.linkedin.com/in/khushi-patel-b7b00920b/ PROFILE SYNOPSIS

• Data Analyst professional, Graduated from Kent State University with a Masters of Science in Business and Data Analytics.

• Proficient in data analysis using tools like Power BI and Tableau, creating actionable insights through effective visualization and dashboarding.

• Skilled in using R, SQL, Python and Excel VBA for data manipulation and analysis, with a strong foundation in machine learning and deep learning techniques.

• Hands-on experience in managing academic projects involving data classification, linear model behavior analysis, and social media analytics using various data science libraries and tools.

• Experienced in managing non-relational and relational databases, implementing efficient data storage and querying strategies with MongoDB and SQLite.

• Certified in platforms like Microsoft Fabric and IBM’s Databases and SQL for Data Science with Python WORK EXPERIENCE

Data Analyst Intern – RV Solutions LLC

Delaware (remote), United States

Jan 2024 – Jun 2024

• Data Analyst responsibilities with expertise in leveraging Power BI and Tableau for creating insightful dashboards and actionable reports.

• Data preparation, ensuring accuracy through effective cleaning and transformation.

• Working on R, SQL, Python, and Excel VBA, machine learning algorithms and database management on day-to-day tasks

• Delivering impactful projects involving data classification, linear model analysis, and social media analytics.

• Reporting insights to team on aligning data driven ideas with business objectives. Data Analyst – Himani Shipping LLC

Gujarat, India

Jun 2022 – Jun 2023

• Applied Power BI for data analysis, creating insightful dashboards.

• Played a key role in data preparation, ensuring accuracy through effective data cleaning and transformation.

• Created visually compelling dashboards using Power BI for effective data representation.

• Transformed complex data into actionable insights, enhancing decision-making processes with intuitive and informative Power BI dashboards.

• Demonstrated proficiency in leveraging business intelligence tools for strategic decision-making, emphasizing continuous learning and effective communication. ACADEMIC PROJECTS

Donors Data Classification

• Conducted exploratory data analysis (EDA), addressing missing and categorical data using techniques such as hyperparameter tuning.

• Implemented classification algorithms, optimizing models with a focus on runtime and space complexity using libraries like `dplyr`, `ggplot2`, and `tidyverse`. Behavior of Linear Models

• Explored the behavior of linear models with a focus on imbalanced datasets, implementing hyperplanes for SVM and logistic regression.

• Analyzed feature importance, compared SVM and logistic regression using the SGD classifier, and visualized the impact of outliers on linear regression lines. Social Media Analytics with MongoDB

• Developed a social media analytics project, creating a MongoDB non-relational database for efficient storage management of user data.

• Applied smart queries and integrated ChatGPT data to derive meaningful insights, enhancing overall database functionality.

Database Management System with SQLite

• Analyzed SQL queries using SQLite in Python Jupyter Notebook on IMDb data, preparing queries for scenarios based on individual IDs, movie names, actors, directors, and year of release.

• Utilized libraries like `pandas` for data manipulation with data tables and mapping tables containing primary and foreign keys.

TECHNICAL SKILLS

• Power BI, Tableau

• Microsoft Fabric, Excel VBA

• R, SQL, Python

• Micrsoft Office Suite

• Data Analytics, Statistics, Data mining

• Machine Learning, Deep Learning

EDUCATION

Master of Science in Business Analytics – Kent State University Bachelor of Business Administration in Finance – Parul University

Contact this candidate