Experienced Logistics Sourcing Coordinator skilled in data extraction, modeling, automation, and spend analysis. Proficient in Advanced Excel, Macros & VBA, SQL, SAP, and database management. Strong focus on optimizing processes and enhancing operational efficiency to deliver data-driven insights for strategic decision-making in procurement and logistics.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Logistics Sourcing Coordinator
DOW Chemical International Pvt. Ltd.
Navi Mumbai
05.2024 - Current
Manage data in Oracle Transportation Management (OTM) for carrier selection, freight rates, and transit times for all the material moving across Europe.
Resolve invoice discrepancies and rate variances through Price Agreements, Quotations, Tenders, and direct discussions with carriers.
Lead the final stages of RFQs and E-Auctions, integrating results into data management tools to improve efficiency.
Processed Accessorial Monthly Fuel Surcharges for Turkey and quarterly for other European lanes, ensuring compliance with Shell's fuel rate guidelines.
Handle ad hoc requests for supplier data changes, including updates to payment terms, geographic details, bank information, and onboarding new customers.
Generate monthly OTM reports across all transportation modes, providing actionable insights for logistics decision-making and strategy.
Collaborated with internal stakeholders to develop purchasing plans that align with business objectives.
Senior Procurement Analyst
ZYCUS INFOTECH PVT. LTD.
Pune, India
11.2021 - 04.2024
Led the implementation of a Spend Analytics solution, enhancing visibility and control over a $12 billion expenditure portfolio.
Managed two major operational projects, overseeing expenditures of $10 billion with 6 million data points and $1.5 billion with 5 million data points.
Directed end-to-end project execution, data analysis, and timely deliverables, achieving significant financial and strategic outcomes for the organization.
Configured products across Development, Staging/UAT, and Production environments, ensuring seamless integration and improved product quality.
Executed comprehensive deployments, excelling in requirements gathering, process configuration, and detailed process flow documentation.
Led UI customization, user and supplier onboarding, and critical testing support to ensure successful deployment.
Collaborated with customer stakeholders and cross-functional teams (ETL, R&D, Product, COE) to improve efficiency, address customer needs, and deliver on time, fostering strong relationships.
Enhanced vendor data through AI-driven normalization and categorization using custom and UNSPSC taxonomy, improving procurement efficiency and cost optimization.
Marketing Intern
Aespaes Pvt. Ltd.
Pune, India
02.2020 - 05.2020
Conducted research on malls, educational institutions, hospitality, hotels, and other sectors to effectively pitch AR, VR, and 3D hologram services.
Redesigned the company website to enhance product visibility and user experience.
Utilized SEO tools to optimize digital marketing efforts.
Compiled and maintained a database of target audiences for strategic outreach.
Assisted in planning and executing successful product launch events.
Conducted market research to identify target audiences and optimize marketing strategies for the Audio Visual industry.
Education
PGPM - Marketing And Finance
ICFAI Business School
Pune, India
01.2021
Bachelor of Business Administration - Commerce
SRMCM
Lucknow, India
01.2019
Skills
Data Modelling
Database Management
SQL
Macros & VBA
Advanced Excel
SAP
Accomplishments
L2 implementation certified and L3 operations certified by Zycus.
Recognition for Streamlining multiple projects.
Certification
Excel: Macros and VBM for Beginners
Excel: Power Query for Beginners
Introducing Robotic Process Automation
Data Quality Fundamentals
PostgreSQL Bootcamp
MS Excel: Data visualization, excel charts and graphs
Timeline
Logistics Sourcing Coordinator
DOW Chemical International Pvt. Ltd.
05.2024 - Current
Senior Procurement Analyst
ZYCUS INFOTECH PVT. LTD.
11.2021 - 04.2024
Marketing Intern
Aespaes Pvt. Ltd.
02.2020 - 05.2020
Excel: Macros and VBM for Beginners
Excel: Power Query for Beginners
Introducing Robotic Process Automation
Data Quality Fundamentals
PostgreSQL Bootcamp
MS Excel: Data visualization, excel charts and graphs
PGPM - Marketing And Finance
ICFAI Business School
Bachelor of Business Administration - Commerce
SRMCM
Similar Profiles
Shalaka JoshiShalaka Joshi
Supply Chain Specialist at DOW CHEMICAL INTERNATIONAL PVT. LTD.Supply Chain Specialist at DOW CHEMICAL INTERNATIONAL PVT. LTD.
Associate Hardware Discipline Engineer at Dow Chemical International Pvt LtdAssociate Hardware Discipline Engineer at Dow Chemical International Pvt Ltd