Excel
Shivangani Pandey
Pune
Summary
Detail-oriented MBA (Business Analytics) student with hands-on experience in data analysis, campaign performance tracking, and business process optimization. Strong knowledge of SQL, Excel, and Power BI for data visualization and reporting. Experienced in identifying revenue-driving channels, improving conversion metrics, and supporting data-driven decision-making. Possesses strong communication and stakeholder management skills, with a focus on delivering scalable business solutions aligned with client requirements.
Overview
3
3
years of professional experience
6
6
Certifications
Work History
Business Analyst Intern
Kraf Technologies
05.2025 - 07.2025
- Worked with structured business data for analysis and understanding workflows
- Assisted in data collection, organization, and basic cleaning using Excel
- Supported the team in understanding requirements and translating them into structured information
- Performed basic data analysis and summaries to support internal decision-making
- Gained exposure to how data is used in tech-driven business solutions
- Monitored industry trends and competitor activities to provide actionable insights for business strategy.
- Collaborated with cross-functional teams to gather and interpret business requirements for system enhancement.
- Contributed to business process improvement by preparing reports and presentations using PowerPoint.
Data Analyst Associate Intern
Excelerate
05.2025 - 06.2025
- Worked with Excel for data entry, cleaning, sorting, and basic analysis
- Used SQL to query, filter, and aggregate data from structured datasets
- Performed data validation and consistency checks across sources
- Prepared datasets for analysis and reporting
- Built interactive dashboards and visualizations using Power BI
- Analyzed data trends and summarized findings in reports and presentations
- Presented insights using tables, charts, and dashboards to stakeholders
Sales & Operation Executive
Monkey Adventures
05.2022 - 08.2024
- Handled end-to-end sales for East Africa safari packages (Tanzania, Kenya, Zanzibar)
- Interacted with international and domestic clients, understanding their travel needs and budgets
- Designed customized safari itineraries including accommodation, transport, and activities
- Coordinated with ground teams, guides, hotels, and camps to ensure smooth operations
- Managed bookings, confirmations, and client documentation
- Assisted clients before, during, and after travel to ensure high customer satisfaction
- Resolved on-ground issues and last-minute changes efficiently
- Directed internal training and communication initiatives for a 4-member team, improving operational efficiency.
- Coordinated cross-departmental operations, ensuring timely execution of client deliverables.
- Managed leads, requirement gathering, and tailored email responses, suggesting the best tour options as per their plans.
- Managed and analyzed campaign datasets to identify high-performing channels and optimize lead generation efforts, improving sales conversion efficiency.
- Employee of the Month Award at Monkey Adventures.
Education
MBA - Business Analytics
Savitribai Phule Pune University
Maharashtra 04.2001 -
Bachelor of Commerce - Accountancy
Jamshedpur Women's College
Jharkhand08-2020
Skills
Requirement gathering and analysis
Documentation(BRD\FRD)
User story mapping/Use case diagram
Stakeholder Management
Agile Methodologies
Business Analysis
Interpersonal skills
Data Analysis
Wireframing
Engaging presentation delivery
Pivot tables
Problem-solving abilities
Software
Figma
Power BI
SQL
Asana
Certification
Business Analysis: Process Modelling and Requirement Gathering
Website, Portfolio and Profiles
www.linkedin.com/in/shivangani-pandey-609460316
Timeline
Business Analyst Intern
Kraf Technologies
05.2025 - 07.2025
Data Analyst Associate Intern
Excelerate
05.2025 - 06.2025
Sales & Operation Executive
Monkey Adventures
05.2022 - 08.2024
MBA - Business Analytics
Savitribai Phule Pune University
04.2001 -
Bachelor of Commerce - Accountancy
Jamshedpur Women's College