Shivanshu Mishra

PGDM candidate specializing in Business Analytics and Marketing with hands-on experience in Python (pandas), SQL, Power BI, and Google Looker Studio. Proven ability to clean and structure large datasets, automate data extraction workflows using Selenium, and deliver actionable business insights through dashboards and visual storytelling. Actively building expertise in AI-driven analytics and ETL pipelines.

Seeking a full-time analyst role where I can apply data skills to drive measurable business outcomes.

Business Analytics Intern at Vas Ventures Pvt. Ltd. (2025-05 – 2025-07)

Pre-Sales & Lead Intelligence

• Designed and maintained a structured consultant database of 5,000+ records in Excel using advanced formulas, reducing pre-sales targeting time by 35% and improving lead quality for the sales team.
• Cleaned, validated, and segmented large datasets using Python (pandas) — handled missing values, removed duplicates, and standardized formats — raising overall data accuracy from ~72% to 90%.
• Developed Python automation scripts using Selenium WebDriver to extract structured contact data from social media groups, reducing manual data collection time by approximately 60% and processing 500+ records per session.
• Conducted exploratory data analysis (EDA) on consultant profiles and lead data using pandas and Excel pivot tables to identify high-conversion segments, contributing to a 20% improvement in outreach targeting.
• Collaborated with the pre-sales team to map data requirements, define KPIs, and align dashboard outputs with business goals — gaining hands-on exposure to cross-functional stakeholder management.

PGDM in Business Analytics & Marketing – Jaipuria School of Business, Ghaziabad (2024 – 2026)

Bachelor of Computer Applications in BCA – Amity University, Uttar Pradesh (2019 – 2023)