Supply Planner

Venkata

Email: ************@*****.***

Mobile: +1-469-***-****

SUMMARY:

Supply chain & Business Analytics using various business applications and data analysis systems. Worked for clients across the globe in Retail, CPG and Manufacturing industry. Demonstrates effective communication, leadership, individual work process and Takes ownership of deliverable’s quality and timelines.

TECHNICAL SKILLS:

Database: Oracle 10g, 11g, MS SQL SERVER 2000/2005/2008, SQL Server Management Studio 2014

ERP Systems: SAP R/3 2.0, SAP -ECC, SAP-IBP

CRM Systems: Salesforce

Fulfillment & Shipping Software: Ship station, Net Suite & Manhattan

eCommerce Software: Magento 2.4.4

Reporting Tools: Tableau

Languages/ Utilities: SQL

Office Tools: MS: Word, Excel, Power Point

PROFESSIONAL EXPERIENCE

Lennox International (LII), Richardson, Texas Nov2023 to Jan2025

Supply Planner (Sourcing Products)

Tracking of all Shipments and deliveries requirements and Working in Expedite all PO related with Uncovered Orders and Stockout Orders

Procurement order Placing like creating STO with delivery needs (HJ) and ERP System Transactions and resolve discrepancies as needed and change a sourcing strategy for an item Planned Orders when MRP runs. As need to cancel the Planned Orders

Manage purchase orders to ensure delivery dates comply with schedule requirements and manage inbound Delivery (STO) and outbound as well.

Manage Supplier performance and Operations performance, Maintained Stock out Report, Inventory unbalance and Product Discrepancy.

Maintained the RMA Report and Process and using of WMS, TMS and LMS

Inventory Replenishment planning parameters such as designating order quantities, lot sizes, safety stock, min/max Planning and ABC Analysis.

Expedites deliveries from suppliers and work order completion as required, Manage & Updates technical information and data sets (SE16N), SE48 and LSMW

Maintain Sourcing Material data in the system (price, safety stock, Lead Time & MOQ’s etc.) with PIR’s and Source List, Involving and updating forecasting on SO99 and Planning Book on SAP-APO

Maintaining Safety Stock & Inventory Replenishment Planning Accordingly the Requirements, Updating on PIR’s on SAP-ECC & Also Transactions Master Data

Interacting with Vendor Management, Source list and working on Stock out data, uncovered PO orders and filling Racks with Targets

Samsung Electronics America (SEA), Plano Texas January 2023 to September 2023

Reverse Logistics Specialist

To manage many processes including returns refurbishment, recycling or repurpose, as well as repairs and maintenance Process and building customer loyalty and Credit.

Support Customer in managing the end-to-end end to end supply chain operations with focus on production planning, inventory management, logistics and distribution. and support in onboarding to the return process and follow up on lost/damaged freight and file claims when needed.

To create complex Excel spreadsheets by using V-Lookups and Pivot Table

Excellent computer skills and proficient in MS Office (Word, Excel, Outlook, PowerPoint)

Monitor and performance in End-to-End reverse logistics process, Participate in department projects and continuous improvement.

Maintain and communicate to the 3PL fleet like RXO and Unis the frequently landed goods list, determine RMA disposition to recover maximum net value and Develop RMA policies and procedures as required.

Maintained timely delivery of goods by optimizing loads and delivery routes, tracking freight across local and global routes.

Maintain data metrics and analyze the data to assess the current performance and implement improvements as and when required and Keep track of quantity, quality, delivery times, stock levels, efficiency, and incurred transportation costs.

Collaborate with cross-functional teams ensuring service needs are fully covered: Demand Planning, Supply Planning, Inventory Management, Operations, Support production team on all supply chain and logistics requests.

Rebel Athletics Inc, Texas March2022 to December 2022 Sr. Inventory Management Specialist

Maintains accurate daily records of goods received and shipments made in Sales Force System, Manages, and maintains inventory system; facilitates upgrades to related database and/or software under the direction of the purchasing.

Develop Daily Arrival List based on Sending List & Contact List of Items, assesses inventory reports and order patterns to identify items in need of automatic, recurring delivery.

Provides inventory reports to purchasing and inventory control manager, compiling inventory reports, addressing any problems, obstacles or challenges and Forecasting inventory requirements.

Audits the facility’s entire inventory on a regular basis and provides reports to management, Trains other employees in cycle counting and inventory control.

Conducts frequent spot and partial audits of physical inventory, maintains consistent stock of inventory, ordering new stock up to pre-authorized limit as inventory.

Files claims with manufacturers or sellers when defective goods are found in the inventory and Instructs others on how and where to return & defective goods and Coordinating and Works with other teams including sales & Marketing, shipping, and purchasing.

Handling for Batch Shipping, Fulfillment Services, Order Management, Import Orders, Manage Orders, Print Labels and Send Tracking to Selling Channels and Customers Coordinating with Product Development team and handling and Updating Magento Software and For Shipping using & Handling ship station Software, ensures that inventory counts are completed regularly and in a timely manner.

Target Inc, Texas Oct 2021 to Feb 2022

Warehouse & Merchandise Expert

Ensuring product is set, in-stock, accurately priced and signed on the sales floor. The General Merchandise and Food Sales team leads inbound, outbound, replenishment, inventory accuracy, presentation, pricing, and promotional signing processes for all GM areas of the store. This team leads Food & Beverage, and Food Service, providing a fresh and food safe experience. Experts enable efficient delivery to our guests by owning pick, pack, and ship fulfillment work.

Iceland Foods Ltd – London, UK September 2013 to June 2014 Supply chain Data Analyst

The Iceland Foods is a British supermarket chain based in Wales and the project is to centralized management not only its website, but its call center and order management systems, as well. Complete implementation of NetSuite’s integrated CRM/ERP system which included: defining implementation strategy; converting company’s legacy financial system, Point-Of-Sale (POS) system and internet store to NetSuite; training office, sales and warehousing personnel on the software and Merchandizing systems, Warehouse, and Order Fulfillment and Shipping operations.

Responsibilities:

Responsible for requirements gathering, analysis, detailed process flow design, user acceptance testing, and rollout of new & modified feature

Oversaw daily maintenance, response, and transaction operations for the Retail & CPG Products in Internet Department.

Relied upon to manage and troubleshoot multiple IT databases and issues, Developed, implemented and successfully managed eBay and Craigslist in sales campaign.

Created new contracts with vendors for exclusive items and promotions and brought multiple exclusive merchandise deals to Crunchyroll that were never previously attainable

Research different vendors for product purchasing opportunities and price comparisons.

Functionality deployed on the E-commerce website applications. Created screen mock-ups following the user experience requirements.

Maintained and issue inventory reporting, including inventory accuracy, cycle count metrics and scrap processing, designed a RF Picking process to move the products between WM and IM managed storage locations and Supplier negotiation and supplier selection.

FoodWorks Pvt. Ltd, Australia June 2009 to August 2013

Supply Chain Analyst

FoodWorks now has over 400 supermarkets, food and convenience stores spanning seven states and territories nationally with over 370 of these operating under the FoodWorks brand. FoodWorks now has over 400 supermarkets, food and convenience stores spanning seven states and territories nationally with over 370 of these operating under the FoodWorks brand. The project was implementation of an in-house system to help FoodWorks review its current store management system/ planning and allocation processes and design new Forecasting Model. The transactional database driven for this application is supported by an ERP system with a SQL Server backend. The ERP system ties together different aspects of the application including inventory management, OM, Shipping and Execution, Pricing, AR. The task of this project was also to build a central repository of historic data warehouse that could support the various reporting and information needs.

Responsibilities:

Worked in Procure to Pay(P2P) and Order to Cash(O2C).

Build and manage sites using the Shopify & WordPress platform and manage a team of the project managers in charge of running sites.

Operations Keep all departments up to date on fulfillment, purchasing, and inventory information and train staff members on fulfillment software and

processes.

Troubleshoot and run inventory system SKUVAULT including the entry of new purchase orders, products and kits, assigning locations, and auditing inventory for quality assurance.

Maintained customer Master, Material Master Data and vendor master and defined different business partners, customer material info records, and item proposals.

Balanced forecast and customer demand against inventory levels and negotiate production schedules and supplier shipments utilizing a Supply Chain Management System.

Processed new purchase orders and amend existing purchase orders to maintain enough inventory levels necessary to meet projected sales demands as well as determine appropriate warehouse destination and order quantities.

Tec Aero Pvt. Ltd, India June 2007 to January 2009

Inventory & Supply Chain Engineer

Tec Aero Devices is a Customized solution Provider & Leaders in Indigenization of Aerospace Standard Parts-Fasteners, Test Rigs - NSE, Electro - Mechanical Systems, GHE and GHES and Tooling, Jigs & Fixtures and Precision Assemblies.

Responsibilities:

Demand Forecasting based on the dispatch plan on monthly. Inventory control on the shop floor and calculating the Inventory Rate Accuracy in accordance with BOM (Bills of Materials).

Assisted with monthly inventory counting and reporting and Work with distribution and shipping receiving personnel to maintain inventory accuracy.

Involved in preparing schedule for requirement of materials, raising purchase requisition, sending request for quotation. Preparing comparative statements with vendors.

Involved Request for Quotation, Quotation. Purchase Orders: STO, Automatic, Subcontract, Consignment, stock Transport. Outline Agreements: Contracts, Scheduling Agreement.

Create 3D models and extract 2D fully dimensioned drawings with information to support fabrication & continuously seek ways to improve the design process and communications.

Support the Project from receipt of order, fabrication, and shipment and participate in design review in-house and with customer.

HBL Pvt. Ltd, India April 2005 to April 2007 Logistics & Material Control Engineer

HBL Power Systems Ltd is a listed Indian company, in business since 1977, with a focus on engineered products and services. The first products selected and successfully developed were Aircraft batteries - eventually leading to HBL offering the world's widest range of specialized batteries. Our expertise in batteries generated opportunities and ideas to diversify. The company moved into new businesses and markets that utilize our batteries, such as industrial electronics, defense electronics, and railway electronic signaling. Recent diversification, leveraging the companies engineering strengths, has led to new businesses in precision manufacturing, spun reinforced concrete and 'green' technology products.

Responsibilities:

Ensured timely unloading, receiving, storage and delivery of material to the production areas.

Maintained inventory and product loss control, coordinates timely and accurate shipping and receiving, and ensured safety/operational guidelines are met.

Material replenishment activities for the factory, ensuring that delivery of parts to production lines are done per standard work instructions.

EDUCATION

Certificate of Supply Chain Logistics and offered through Coursera in Logistics Rutgers the State University of New Jersey

Certificate of Python for Data Analysis and Visualization online Course by Jose Portilla on Udemy.

Certificate of Data Analytics & Power BI Authorized by Microsoft through MVA.

Studying Salesforce Admin course on Trailhead.Salesforce.com

Diploma in Business Australian National College - Melbourne VIC, Australia 2012

Master of Engineering in Machine Designing IASE University, Rajasthan, India 2005

Bachelor of Engineering in Mechanical Institute of Mechanical Engineers (India) - Mumbai, Maharashtra 2001

Contact this candidate