Supply Chain Analyst

DARSHAN RANA

St. Paul, MN,*****, USA adikl6@r.postjobfree.com 203-***-****

EDUCATION:

Master of Science - Engineering Management [3.68 GPA] Aug 2016 – May 2018 San Jose State University, USA

Bachelor of Engineering - Mechanical Engineering [3.24 GPA] July 2011 - May 2015 Gujarat Technological University, India

Technical and Analytical Tools:

ERP: SAP ECC – SCM modules, Tableau, Google Data Studio, SQL, MS Excel, MS Office, IBM Sterling – B2B Integrator. Certificate:

Lean - Six Sigma Green Belt, Data Visualization with Tableau WORK EXPERIENCE:

Supply Chain Analyst (3M Corporation by Megatrendz Media, St. Paul, Minnesota) Aug 2019 – Present

Owned end to end Order to Cash (OTC) cycles. Worked as SAP – subject matter expert in MM/WM modules. Maintained and Configured Master Data in Material Master, Vendor Master, Purchase Info Record, Source List and Bill of Material (BOM).

Configured Stock Put-away and Stock Removal Strategies as per business requirements and tested them in Material Master.

Conducted Vendor performance review and categorized based on performance and quality.

Maintained and documented stock placement for Quality Inspection and Blocked Stocks as per standard business requirements. Maintained Negative Stocks in SAP order to respond to time sensitive manufacturing operations.

Configured split valuation of material to accommodate same material with different prices based on its procure location.

Owned good movements procedures in IM such as stock transfer between Plant to Plant, Storage Location to Storage Location, Material to Material and Bin to Bin as per business requirements.

Conducted for the Physical inventory and Cycle counting in facilities, keep close track of inventory discrepancy and reconciliation.

Conducted business matrices / KPI monitoring such as Fulflment time, Transition time, Total Cycle time, Transmission misses, Fulfilment misses, Quality Performance Percent (QPP), etc. Supply Chain Operations Analyst (Google Inc. by SMX, San Jose, California, USA) Oct 2018 – April 2019

Optimized Supplier’s performance metrics such as Average Lead Time per product family, Actual vs ETA performance, Confirming Items vs non-confirming performance per supplier per component and increased transportation lead time by 26%.

Managed Manufacturing and Sub-contracting Supply Chain and logistics operations for Manufacturing facilities located in China.

Responsible for end to end Quota Arrangement, RFQ (bidding), Contract Agreement, Scheduling Agreement, Subcontracting, Consignment and Split Valuation Processes for material planning aligned to production scheduling.

Owned Procure to Pay Cycles in SAP. Worked closely with Material Master, Vendor Master, Purchase Requisition, Purchase Order, Inventory management and Invoice verification processes in SAP – MM.

Maintained data integrity in Material Master, Vendor Master, Purchase Info Record, Source List, Bill of Material (BOM), and Routing in SAP.

Responsible for managing Quality Management Processes for raw material and finished products. Owned quality inspections of finished products’ acceptance sampling procedure. Maintain return deliveries and sub-sequent deliveries for non-confirming items.

Re-engineered fulfilment operations by using lean and kaizen principles and increase On-Time fulfillment rate for 22% on an average.

Managed inventory operations for the warehouses located in France and USA. Conducted customization of SAP WM to accommodate stock placement strategy and stock removal strategy for finished products.

Used detail SQL queries and advanced excel functions for performance monitoring of 3PL career matrix such as Fill Rate, POP %, CPMO, OT% and Late Orders. Created interactive KPI dashboards in Google Data Studio to measure internal and external performance. Operations Analyst Intern (Microvention-Terumo Inc., Tustin, California, USA) Jun 2017 - Aug 2017 Logistics and Operations Analyst (Arrow Digital Private Limited, India) Jun 2015 – Jun 2016 Manufacturing – Quality Engineer Intern (Supernova Engineers Ltd, India) May 2014 – Dec 2014

Contact this candidate