Shagun Yadav

About

Detail-oriented data analyst with hands-on experience in data cleaning, validation, dashboarding, and sales forecasting. BBA graduate with internship experience using Power BI and Excel to support KPI monitoring and business reporting.

Experience

• Data Analyst Intern (Power BI)
  S O Infotech (P) Ltd.
  Jan 2025 – Jun 2025

  Project: Walmart Sales Forecasting

Education

• Bachelor of Business Administration (BBA)
  Maharaja Agrasen Himalayan Garhwal University (MAHGU)
  Aug 2021 – Jul 2024
• Senior Secondary Education (Class XII)
  Govt. I.C. Jahangarh Urf Daujha Bagpat
  2020 – 2021

Skills

• SQL <3 months
• Data Analysis 6 to 12 months
• Data Visualization 6 to 12 months
• Market Analysis <3 months
• Data Cleaning 6 to 12 months
• Data validation 6 to 12 months
• Sales Forecasting 6 to 12 months
• Business Strategy <3 months
• Data Storytelling <3 months
• Dashboard Reporting 6 to 12 months
• KPI Monitoring 6 to 12 months

Tools / apps / platforms

• Google Workspace software <3 months
• Microsoft Excel 6 to 12 months
• Microsoft Office <3 months
• Microsoft Power BI 6 to 12 months
• Microsoft PowerPoint <3 months
• Microsoft Word <3 months
• Salesforce.com Salesforce CRM <3 months

Languages

• Hindi Native / Bilingual Speak
• English Fluent Speak

Projects

• Salesforce CRM Workflow & Customer Lifecycle Study
  Salesforce

  Mapped CRM workflows, lead management, and pipeline tracking, and analyzed customer journey touchpoints.

• Market Trends Research & Competitive Analysis

  Conducted market research analyzing consumer behavior across multiple industry segments and presented strategic recommendations.

• Digital Marketing & Social Media Strategy Simulation
  Excel

  Prepared performance reports and Excel dashboards to track campaign KPIs and derive optimization recommendations. Segmented target audiences and executed a mock email marketing campaign using CRM principles.

Courses & certifications

• Data Analytics with Power BI · Ducat School of AI · 2025
• Microsoft Office Suite – Advanced Proficiency (Word, Excel, PowerPoint) · 2024
• Salesforce CRM Fundamentals · Self-Directed Learning · 2023
• Digital Marketing Fundamentals · Google/Online Platform Training · 2023

⚽ Extracurricular activities

• Community Volunteer & Social Outreach Coordinator

  Led community service initiatives and charity drives with local organizations.

🤝 Volunteering

• Local organizations · Community Volunteer & Social Outreach Coordinator · 2024

  Led community service initiatives and charity drives.