Summary
Overview
Work History
Education
Skills
Websites
Certification
Timeline
Generic

Arpit Pandey

Sydney,Australia

Summary

Results-driven Procurement Operations & Data Analytics professional with 6+ years of experience in project operations, strategic planning, supplier evaluation, and data analytics. Adept at optimizing procurement processes, analyzing vendor performance, and implementing data-driven strategies to improve cost efficiency and supplier relationships. Strong analytical skills with expertise in Tableau, SQL, and Excel, to develop procurement dashboards and reports. Proven ability to manage multiple projects, collaborate with cross-functional teams, and drive operational excellence in fast-paced environments.

Overview

9
9
years of professional experience
1
1
Certification

Work History

Procurement Analyst

Winc Australia Pty Ltd.
Sydney, Australia
05.2023 - Current
  • Spearheaded the implementation of a new supplier evaluation system, increasing supplier performance ratings by 14%
  • Supported RFI/RFP development, partnered with business units to lead the tender process, and analyzed bid responses using multi-year financial models to determine total cost of ownership
  • Developed and managed Tableau dashboards to track vendor performance, category spend, and FX rates, enhancing visibility into procurement metrics
  • Conducted in-depth category and vendor analysis to support cost-saving initiatives, leading to improved spend control and strategic sourcing
  • Optimized supply chain operations by improving SIFOT (Supplier-In-Full-On-Time) processes and creating a Tableau dashboard, resulting in a 22% improvement in SIFOT performance and an 11% increase in product availability
  • Led vendor negotiations and coordinated contract reviews with legal teams to ensure compliance and favorable terms
  • Provided data-driven insights to support category management and pricing strategies, leading to a 160% achievement of Range Optimization targets in FY 2023-24

Sales Business Analyst

JK Tyre & Industries Ltd.
New Delhi, India
11.2016 - 11.2020
  • Built Tableau dashboards to visualize business KPIs (monthly revenue, sales), reducing manual reporting time by 10 hours per week
  • Managed procurement reporting and spend analysis for $1.38 million worth of business from channel partners and government projects
  • Implemented supply chain optimization strategies, reducing average delivery lead time by 40% using regression analysis
  • Achieved a quarterly cost reduction of $67,000 by analyzing marketing spend and eliminating high-CAC activities
  • Led cross-functional collaboration with marketing, supply chain, and engineering teams to improve product lifecycle management, reducing time to market by 25% and increasing product quality by 30%
  • Optimized demand forecasting using Excel, SQL, and SAP, driving 32% sales growth through strategic promotional and relationship management initiatives

Sales & Marketing Executive

Madhus Garage Equipments Pvt. Ltd.
New Delhi, India
02.2016 - 10.2016
  • Conducted competitor market analysis and price benchmarking using Excel and Tableau visualization tools
  • Managed advertising campaigns and developed promotional materials to enhance product visibility
  • Established strong working relationships with automobile OEMs, delivering product presentations to drive sales

Education

Master of Business Analytics -

Macquarie University
Sydney, NSW
02-2023

Bachelor of Technology - Mechanical Engineering

Amity University
Noida, India
05.2014

Skills

  • Procurement Operations
  • Vendor Management & Evaluation
  • Strategic Sourcing
  • Market Research
  • Spend Analysis
  • RFI/RFP Development
  • Tender Management
  • Contract Negotiation
  • Compliance Management
  • Data Analysis
  • Financial Forecasting
  • Tableau Dashboard Development
  • Advanced Excel
  • Pivot Tables
  • VLOOKUP
  • Macros
  • SQL
  • Data Extraction
  • Risk Management
  • Problem Solving
  • Cross-functional Collaboration
  • Communication

Websites

Certification

  • Associate Data Analyst in SQL – Data Camp
  • SQL: Data Reporting and Analysis – LinkedIn

Timeline

Procurement Analyst

Winc Australia Pty Ltd.
05.2023 - Current

Sales Business Analyst

JK Tyre & Industries Ltd.
11.2016 - 11.2020

Sales & Marketing Executive

Madhus Garage Equipments Pvt. Ltd.
02.2016 - 10.2016

Master of Business Analytics -

Macquarie University

Bachelor of Technology - Mechanical Engineering

Amity University

Similar Profiles

CREATE PROFILE
Arpit Pandey