Shubham Goyal

Shubham Goyal

Data Scientist

📊 Skills: Data Analysis | Data Visualization | Python | SQL | Excel | Power BI | Tableau | Machine Learning | Statistics

🎯 Interests: Business Intelligence | Predictive Analytics | Data Science | Deep Learning | Dashboard Development | Hypothesis Testing

ABOUT ME

Hello! I am Shubham Goyal, a data enthusiast with a passion for transforming numbers into compelling stories that drive smart decisions.

What Drives My Search?
I am actively seeking roles that align with my skills, present new challenges, and allow me to make meaningful contributions.

Why Consider Me?
I have a profound passion for deriving practical insights from data. My expertise lies in converting raw data into actionable insights using tools like Excel, SQL, Python, Tableau and Power BI.

Proven Real-World Skills
While I may not have followed the conventional office career path, I have immersed myself in real-world projects that showcase my capabilities and dedication to data analytics.

What Makes Me Special?
My adaptability and strong analytical skills enable me to seamlessly integrate into teams, making an immediate and positive impact. I thrive in dynamic environments and am committed to delivering high-quality, insightful data analysis.

SKILLS

Excel SQL NoSQL Python Power BI Tableau Hypothesis Testing Time Series Analysis Machine Learning Deep Learning

EDUCATION

Bachelor of Commerce (B-Tech)

Guru Gobind Singh Indraprastha University (IPU)

CGPA-8.9

High School (12th)

Kendriya Vidyalaya AFS Gogha School

Percentage-81.75%

High School (10th)

Kendriya Vidyalaya AFS Gogha School

CGPA-9.6

COURSES

Data Analyst

CodeBasics

11/2023 - 05/2024

Google Data Analytics

Coursera

07/2024 - 07/2024

Data Science Bootcamp

upGrad

06/2024 - 03/2025

CERTIFICATES

Data science course completion cert> Hackthon> Coursera Google> Sql Intermedidate HackerRank Cert> Sql Basic HackerRank Cert> Accenture> pwc> jpmorgan> Execel Code Basic> SQL> powerbiCB> IPL Project appreciation Cert>

PROJECTS

SQL Project
Conducted data analysis on a Bike Rental Shop dataset using MySQL Workbench. Performed queries to extract insights on rental trends, customer behavior, and peak usage times for data-driven decision-making.

Project
SQL Project

Performed NFT and cryptocurrency analysis using SQL to explore market trends, transaction patterns, and pricing insights. Executed complex queries to extract valuable data-driven insights for better investment decisions.

Project
HealthCare Project

Created a comprehensive healthcare dashboard in Tableau to visualize patient data, treatment outcomes, and hospital performance. Leveraged interactive features to track key metrics like patient visits, recovery rates, and operational efficiency.

Project
Sales Performance Project

Developed a Sales Performance Analysis dashboard in Tableau to visualize key metrics such as revenue, sales trends, and regional performance. Utilized filters and interactive elements to provide actionable insights for sales optimization and strategy planning.

Project
Hospitality Domain Project

Developed interactive Power BI dashboards for the hospitality domain, analyzing occupancy rates, revenue trends, and customer demographics. Provided data-driven insights to optimize operations and enhance guest experience.

Project
Diwali-Sankranti Sales Project

Analyzed Diwali and Sankranti sales data using Power BI to uncover trends, customer preferences, and revenue patterns. Created interactive dashboards for data-driven decision-making and sales optimization.

Project
IPL Insights Project

Developed interactive IPL dashboards in Power BI to visualize team performance, player statistics, and match trends. Utilized data modeling and DAX to extract key insights for cricket analytics.

Project
AdCampaign Hypothesis Analysis

Performed hypothesis testing on the effectiveness of AdWords and Facebook ad campaigns. Analyzed conversion rates, engagement metrics, and campaign performance to determine statistically significant differences in ROI across platforms.

Project
Hypothesis Testing

Conducted hypothesis testing on four different problem statements to validate assumptions and draw data-driven conclusions. Applied statistical techniques to analyze datasets and assess the significance of various factors.

Project
Netflix TSA

Performed time series analysis on Netflix data to forecast trends in viewership, content popularity, and subscription growth. Visualize and identify seasonal patterns and long-term predictions.

Project
Market Basket Anaysis

Performed Market Basket Analysis using machine learning techniques to identify associations between products in customer transactions. Applied algorithms like Apriori to uncover frequent itemsets and generate product recommendations for enhancing sales strategies.

Project
ECommerce Product Categorization Project

Developed a machine learning model to categorize eCommerce products based on descriptions using NLP techniques like TF-IDF and word embeddings. Enhanced accuracy through feature engineering and hyperparameter tuning.

Project
Sentiment Analysis Project

Developed a Sentiment Analysis model to classify text as positive, negative, or neutral using NLP techniques. Utilized machine learning algorithms and data preprocessing to analyze sentiments in real-world datasets.

Project
Text Classification and Topic Modelling Project

Implemented Text Classification and Topic Modeling to categorize and extract key themes from textual data. Leveraged NLP techniques, machine learning, and LDA for insightful analysis and automated topic discovery.

Project
Spam Detection Project

Developed a Spam Detection system using NLP techniques to classify messages as spam or not spam. Utilized text preprocessing, feature extraction, and machine learning models to accurately identify and filter unwanted content.

Project

EXPERIENCE

INTERNSHIP

MedTour Easy | 4 Week Traineeship

✅ Analyzed and Visualized Data: Cleaned and processed datasets to generate insights and create interactive dashboards.
✅ Contributed to Data-Driven Decisions: Assisted in executing analytics tasks that improved business strategies and efficiency.

AtliQ Technologies | 4 Week Virtual Internship

✅ Data Cleaning & Transformation: Processed raw data for better accuracy and usability.
✅ Dashboard Development: Created interactive dashboards for business insights.
✅ Stakeholder Communication: Designed presentations to communicate findings effectively.

PROFESSIONAL EXPERIENCE

DelhiNCR Meme Page

✅ Instagram Growth: Managed a meme page with 16,000+ followers.
✅ Content Strategy: Created viral content and increased engagement.

College Travellers

✅ Event Management: Organized 20+ trips, fostering a vibrant community.
✅ Logistics & Marketing: Managed customer relations and promotions.