Keyur Mehta

Dallas, Texas +1-469-***-**** adb0lo@r.postjobfree.com www.linkedin.com/in/keyur-mehta

EDUCATION

M.S., Supply Chain Management, The University of Texas at Dallas May 2021 (GPA 3.67) B.E., Mechanical Engineering, DJ Sanghvi COE, India June 2017 (GPA 3.2) Certificates: Lean Six Sigma Black Belt, Advanced Excel – Pivot tables, Macros & VBA, Supply Chain Principles by Georgia Tech, Contracting, Sourcing & Negotiation, TL9000 HIGHLIGHTS

• Relevant Coursework: Operations Management, Product Lifecycle Management, Lean Six Sigma, Project Management, Procurement, Sourcing, Negotiations, Operation Analytics, Global Logistics & Transportation

• Software: Tableau, Microsoft Power BI, Advanced Excel (VLookup, Pivot tables, Macros & VBA), SQL, Minitab, Microsoft Office

• Skill Set: Spend Analysis, Problem Solver, Proactive, Attention to detail, Adaptable, Team Player, Presentation, Customer Focus, Verbal & Written Communication, Persuasive, Training & Development, Interpersonal Skills PROFESSIONAL EXPERIENCE

Zycus Infotech Pvt Ltd, Mumbai, India July 2017 – April 2019 Procurement Analyst

• Generated vendor diversity & parent child linkage reports, hence normalized & compressed the vendor base by 30 %

• Quantified potential cost savings of 11% by conceptualizing demand aggregation technique on the indirect spend data

• Delivered excellent customer service, resolved tickets & issues within service levels, thus received a CSI of 10/10

• Identified and resolved issues using root cause analysis and DMAIC methodology, reduced the issue rate by 25%

• Communicated with 15+ vendors, followed up on orders, improved vendor relations & maintained 90% retention rate

• Developed analytical visualizations & models in Tableau and Excel to drive strategic decision making & savings of 10%

• Ensured vendor performance tracking by setting appropriate KPIs and KRAs and evaluating suppliers against them

• Built taxonomy for clients by understanding their businesses, thus improved visibility across their sourcing commodities

• Streamlined & automated reporting operations by collaborating with ETL and IT teams, reduced turnaround time by 40% ACADEMIC PROJECTS AND COMPETITIONS

Purchasing, Sourcing & Contracts, The University of Texas at Dallas Aug 2019 – Dec 2019

• Formulated Total Cost of Ownership tool, analyzed bids factoring Total Landed Costs, successfully held mock auctions

• Evaluated suppliers using scorecards, analyzed different Key Performance Indices, thus created a diverse supplier base

• Analyzed inventory models based on product nature, determined Economic Order Quantity for minimized overall costs DJS Skylark - Aero Design Team, DJ Sanghvi COE, Mumbai, India April 2015 – March 2016 Technical Head

• Designed & fabricated RC aircraft, contested in SAE Aero Design East 2016, Fort Worth, TX; received 3rd rank

• Spearheaded a team of 7 members, assigned tasks and conducted daily scrums to align and track the set milestones

• Successfully organized an aero design & fabrication workshop which generated a footfall of 80+ student participants LEADERSHIP AND AFFILIATIONS

Supply Chain Leadership Council (SCLC), Industrial Relations Officer August 2019 - Present Project Management Club (PMC), Member August 2019 - Present Society of Automotive Engineers (SAE), Event Organizer April 2015 – March 2016