Available for Opportunities

Hi, I'm Shubham
Panchal.

|

Transforming Data into Business Decisions. Helping organizations solve business problems through analytics, data visualization, business intelligence, and digital marketing.

Download Resume View Projects Contact Me GitHub LinkedIn
2.68M+
Campaign Impressions
50K+
Records Analyzed
6+
Certifications
Shubham Panchal
Shubham Panchal
Business & Data Analytics · Wright State University
SQL Python Tableau Google Ads Machine Learning Power BI HubSpot
EY
Business Analyst Intern
Dec '26
Graduation
Open to full-time roles
About Me

Bridging Business Strategy
& Data Science

I'm a Marketing Analytics & Insights graduate student at Wright State University, graduating December 2026. I hold a Bachelor of Commerce in Marketing & Accounting from Kurukshetra University.

My internship at Ernst & Young (EY) sharpened my ability to analyze large datasets, build predictive models, and deliver Tableau dashboards that drive executive decisions. At NetPuppys, I managed Google Ads and Meta campaigns, improving CTR by 20% and optimizing ad spend with A/B testing.

I'm passionate about the intersection of data science and marketing strategy — using Python, SQL, and ML to solve real business challenges and drive measurable growth.

📊
Business Analytics
SQL · Python · Tableau · Power BI
🎯
Marketing Analytics
Google Ads · Meta Ads · GA4 · A/B Testing
🤖
Machine Learning
Scikit-learn · Predictive Modeling · Pandas
📈
Business Intelligence
KPI Dashboards · Data Visualization
🌐
Digital Marketing
SEO · SEM · HubSpot · SEMrush
0
Campaign Impressions
0
CTR Improvement at NetPuppys
0
Records Analyzed
0
Professional Certifications
Skills & Expertise

Tools of the Trade

A full-stack analytics toolkit spanning programming, visualization, marketing platforms, and business intelligence.

💻Programming
Python90%
SQL88%
R70%
📊Analytics & BI
Tableau92%
Power BI80%
Google Analytics90%
Excel95%
🎯Marketing
Google Ads88%
Meta Ads85%
SEO / SEM82%
HubSpot CRM80%
Featured Projects

Work That Drives Results

From ML models to live ad campaigns — every project is built around measurable business impact.

Campaign Performance Chart
Digital Marketing · Featured · April 2025
Digital Marketing Campaign — Wright State MSLSCM

Promoted the MSLSCM program at Wright State University to students in Kathmandu, Nepal. Managed a $1,300 budget across Google Ads, YouTube, Facebook & Instagram. Discovered 87.9% of costs came from mobile — pivoted to mobile-first strategy achieving $6.76 cost-per-conversion on the best-performing campaign.

Google Ads YouTube Ads Meta Ads A/B Testing UTM Tracking GA4 Mobile-First
2.68M+
Impressions
12K+
Clicks
735K+
Engagements
$6.76
Best Cost/Conv.
Case Study GitHub
🤖
Machine Learning · Python
Customer Churn Prediction Model

Built ML models on 50K+ records using Scikit-learn to predict churn and identify key drivers, improving prediction accuracy by 18%.

PythonScikit-learnPandasSQL
GitHub Case Study
📈
AI · Python · Tableau
AI-Powered Campaign Performance Predictor

ML models predicting ad CTR and conversion probability from historical marketing data, with Tableau dashboards tracking CTR, CPC, ROAS, and conversions.

PythonSQLTableauScikit-learn
GitHub Live Demo
👥
Predictive Analytics · RFM
Customer Lifetime Value (CLV) Prediction

Built CLV prediction and customer segmentation on 50K+ records using RFM analysis to generate retention and loyalty insights with Tableau visualizations.

PythonSQLTableauRFM Analysis
GitHub Case Study
🔀
SQL · Tableau · Attribution
Marketing Attribution & ROI Analysis

Developed first-click, last-click, and multi-touch attribution models to identify high-performing acquisition channels and improve overall marketing ROI.

SQLTableauPythonAttribution Modeling
GitHub Case Study
Experience

Where I've Made Impact

From Big 4 consulting to performance marketing — real-world experience driving data-backed decisions.

May 2024 – Aug 2024
Digital Marketing Intern
NetPuppys · Gurugram, India
  • Managed Google Ads and Meta campaigns, improving CTR by 20%
  • Conducted keyword research and optimized ad creatives for higher engagement
  • Tracked performance using Google Analytics and UTM parameters
  • Supported SEO improvements through on-page optimization
Nov 2023 – Apr 2024
Business Analyst Intern
Ernst & Young (EY) · Delhi, India
  • Analyzed large datasets using SQL and Python to generate actionable business insights
  • Developed predictive analytics models for churn prediction and revenue forecasting
  • Built Tableau dashboards to track and visualize KPIs for senior stakeholders
  • Automated reporting workflows, improving operational efficiency by 15%
Jan 2025 – Present
Graduate Student — Marketing Analytics & Insights
Wright State University · Dayton, Ohio
  • Pursuing M.S. in Marketing Analytics & Insights, graduating December 2026
  • Managed $1,300 live ad campaign achieving 2.68M+ impressions and 735K+ engagements
  • Building ML models, marketing attribution frameworks, and CLV prediction systems
  • Seeking full-time roles in Business Analytics, Marketing Analytics, and BI
Education

Academic Foundation

M.S. Marketing Analytics & Insights
Wright State University · Dayton, Ohio
📅 Expected Graduation: December 2026
📍 Dayton, Ohio, USA
Currently Enrolled
Bachelor of Commerce — Marketing & Accounting
Kurukshetra University · Kurukshetra, India
📅 Graduated: 2024
📍 Kurukshetra, Haryana, India
Completed
Certifications

Industry Credentials

Validated expertise across analytics, advertising, and marketing platforms.

Google Ads Certification
Google
Google Analytics (GA4)
Google
Advanced Data Visualization ↗
Tableau · Coursera
SQL for Data Science ↗
IBM · Coursera
Technical SEO
Semrush
Inbound Marketing
HubSpot
Get in Touch

Let's Build Something
Together

Open to full-time roles, internships, and freelance projects in Business Analytics, Marketing Analytics, Data Science, and Business Intelligence. Let's connect!

✉️
Email
shubhampanchal7120@gmail.com
💼
LinkedIn
linkedin.com/in/shubhampanchal1
🐙
GitHub
github.com/ShubhamPanchal1
📍
Location
Dayton, Ohio, USA