Summary
Overview
Work History
Education
Skills
Websites
Accomplishments
Training
Languages
Disclaimer
Timeline
Generic
Vanshika Arora

Vanshika Arora

Bengaluru

Summary

To work in an organization which Encourage me to Learn and Grow Professionally

Overview

6
6
years of professional experience
4043
4043
years of post-secondary education

Work History

Data analyst- central

Gourmet Garden
Bengaluru
04.2023 - Current
  • Developed and managed category, supplier, and regional dashboards using Tableau / Power BI, ensuring timely refresh and stakeholder delivery and cross functional aspect

Analyzed historical and current spend data using Microsoft Excel (Pivot Tables, VLOOKUP, Power Query) and SQL to support baseline development and cost optimization

Designed and enhanced dashboards leveraging Tableau / Power BI to improve reporting efficiency and business decision-making

Checked margin accross channel of logistics Led data cleansing and transformation using Power bi , and SQL ensuring high data integrity

Collaborated with cross-functional teams using Microsoft Teams and Excel to deliver data-driven insights

Analyzed vendor financials and supported ISG & ESG reporting using Excel and Power BI for risk and compliance assessment

Provided analytical inputs for sourcing projects using Excel, SQL, and Power BI to drive process improvements , supply , procurement and pricing

Data Analyst(supply chain )

WayCool Foods
Bangalore
10.2021 - 04.2023

Analyzed supply chain data to improve inventory planning and reduce stockouts

Led demand forecasting and ensured optimal inventory levels across warehouses/stores

ollaborated with vendors to ensure on-time delivery and cost efficiency

Identified cost-saving opportunities and achieved procurement cost reduction targets

Monitored supplier performance using KPIs like OTIF (On-Time In-Full), lead time, and quality

Worked cross-functionally with logistics, finance, and merchandising teams

Handled purchase orders, RFQs, and supplier contracts

Improved supply chain efficiency by reducing delays and optimizing logistics

Created dashboards and reports for leadership to track procurement performance

  • Monthly and daily demand &planning for modern trade
  • Establishing streamline tools for better forecasting(power bi)

  • Analyzing sales and margins for every month
  • Integration with sales and procurement team for fulfilling fillrate

Management Trainee

Rebel Foods (Formerly Faasos)
Hyderabad
09.2021 - 10.2021
  • Managed their own brand delivery app-
  • Dashboard on - delivery time n customer insight
  • Assisted in managing inventory and supply chain processes effectively.

  • Analyzed customer feedback to improve service delivery and product offerings.
  • Engaged in cross-functional projects to enhance operational efficiency.
  • Fostered a collaborative environment among diverse teams within the organization.
  • Resolved customer issues efficiently to build loyalty.

Digital Marketing Intern

Khadyam Speciality Foods Pvt Ltd
Hyderabad
10.2020 - 12.2020

Project Management Intern

Janani Foods Pvt Ltd
Hyderabad
05.2020 - 09.2020

Education

Master of Business Administration -

INDIAN INSTITUTE OF PLANTATION MANAGEMENT BANGALORE
Bangalore

Food Processing & Technology - university of Allahabad

centre of food technology

Skills

  • Powerbi
  • Tableau
  • Advance excel
  • Looker
  • SQL
  • Sap
  • Google Analytics
  • Dashboard reporting
  • Data visualization
  • Data cleansing
  • Supply chain analysis
  • Demand forecasting
  • Cost optimization

Accomplishments

Owned category & supplier dashboards →30% efficiency improvement

Improved data accuracy → 35%

Automated reporting → 25% time saved

Supported RFP analytics → faster decisions

Built KPI dashboards → better supplier performance tracking

Reduction in pricing through above data

Training

Market Research and NPD, NDRI, Karnal

Languages

  • Hindi
  • Punjabi
  • Kannada
  • English, Proficient
  • Hindi, Native
  • Punjabi, Proficient
  • Kannada, Beginner

Disclaimer

I hereby declare that all the information given above is true and correct to the best of my knowledge.

Timeline

Data analyst- central

Gourmet Garden
04.2023 - Current

Data Analyst(supply chain )

WayCool Foods
10.2021 - 04.2023

Management Trainee

Rebel Foods (Formerly Faasos)
09.2021 - 10.2021

Digital Marketing Intern

Khadyam Speciality Foods Pvt Ltd
10.2020 - 12.2020

Project Management Intern

Janani Foods Pvt Ltd
05.2020 - 09.2020

Master of Business Administration -

INDIAN INSTITUTE OF PLANTATION MANAGEMENT BANGALORE

Food Processing & Technology - university of Allahabad

centre of food technology
Vanshika Arora