Santha Upadhyayula
Lombard, IL • ad1vv8@r.postjobfree.com • 331-***-**** • https://www.linkedin.com/in/santha-rku/
SUMMARY
Highly motivated and versatile supply chain analyst with 8+ years of experience in leading procurement, strategic sourcing, decision making, vendor management, project management, data analysis, inventory control, problem solving and continuous improvement operations. Excellent communicator and proactive analyst able to identify ways to reduce expenses without compromising quality. Effective team leader with strong ability to think quickly and act fast to ensure target work is completed on time.
TECHNICAL SKILLS
•SAP ECC
•SAP Ariba
•MS Excel
•Smartsheet
•MS Visio
•Power BI
•Continuous Improvement
•Vendor Management
•Project Management
•Supply Chain
•Service Now & Service Channel
•SAP Material Management
•Tableau
•JIRA
•Pro Track
•VLOOKUP
•ZMASSPO
•Verisae
•MS Access
•Matlab
•SQL
•R Studio
•MRP
EXPERIENCE
Company: Sevan Multi-Site Solutions
Client: Walgreens Deerfield, IL
Non-Merchandise Supply Chain Project Coordinator & Lead March 2021- Present
Collaborated with multiple departments to define project requirements, scope, and ensure tasks are completed within required timelines.
Act as point of contact and communicate program status to all participants, including senior leadership.
Manage and process +300 re-orders in Pro Track for new stores, remodel projects, and store touch programs.
Processed +1000 purchase orders for multiple programs.
Lead and manage Store Touch Program (+800 stores).
Perform Take-Offs by analyzing store drawings/D111, BOM validation, and release orders to warehouses and suppliers.
Host bi-weekly meetings with store touch leadership team to provide updates on in-progress remodels.
Update Service Channel on lead times, inventory levels and transportation details.
Developed safety stock report by collaborating with forecasting team by researching buying trends for STR program.
Developed material trend report using Power BI
Developed process mapping for Store Touch Program using MS Visio.
Work with project managers to determine material requirements so execution produces zero waste.
Interact with store planning for latest design updates which require additional material procurement from vendors.
Validate incoming pallets report, follow-up on ESD’s & ASN’s from vendors for Small Remodel Program (SRP).
Lead Floor tile program (+75 stores, $7M) take-offs, communicated with vendors on material availability, schedule transportation, track shipments, and confirm delivery.
Manage Walk-in/Reach-in cooler requests for +2,000 stores.
Developed Smartsheet for reach-in cooler store requests resulting in reducing processing time by 70%
Lead Kroger 1.5 cooler shelving program (+50 stores)
Tools: Pro Track, JIRA, SharePoint, SAP Ariba, Excel, Deposco, MS Access, VLOOKUP’s, Verisae, Service Channel, Supplier management, Project management, Power BI, Data Manipulation & Smartsheet
MWIDM - Supply Chain Project Coordinator April 2020- March 2021
Tracked outstanding purchase orders, communicated with vendors on updated lead times.
Processed +500 PO’s for Invoice Team for multiple programs of consolidation, supplemental, change orders and initial billing types.
Approved +300 authorized to return hardware (ATR) equipment’s requests and generated UPS labels.
Processed PO’s for all billing types using GO Cart and Skylight.
Worked with Project Accounting team on weekly bases and submitted reports on all technically completed (TECO) and Closed WBS codes.
Tools: Smartsheet, MS Excel, Service Now, Skylight, SAP Ariba, SAP ECC, Supplier Management, Project Management, Invoice Management
Northern Illinois University Dekalb, IL
Research Assistant Aug 2019 – Dec 2019
●Applied Simulated Annealing (SA) approach to minimize the makespan in Hybrid Flow Shop with batch processing machine problem.
●Developed and solved mathematical formulation in commercial solver CPLEX.
●Programmed solution approach code, construction and improvement phases in MATLAB, and compared SA and CPLEX results.
●Conducted Design of Experiments on 100 jobs with multiple parameter values and recorded the best approaches for various instances and created reports, dashboards using Tableau
Northern Illinois University Dekalb, IL
Graduate Teaching Assistant Feb 2019 – Dec 2019
●Tutored students in Tableau, AutoCAD Architecture tool and R program languages.
●Taught single, multi network facility location problems to determine best location for new facility layouts.
●Developed data visualization reports of student score cards using Tableau Desktop.
●Created visualizations such as Sankey, Sunburst, Funnel chart and Geographical maps on various datasets.
NBS My Manpower Resources Pvt Ltd Hyderabad, India
Supply chain Analyst Jun 2016 – Jan 2017
●Processed 100+ purchase orders.
●Collected voice of customers in beverage loading unit and implemented kaizen ideas, 5S methods and improved productivity by 15%
●Developed interactive reports and dashboards using Tableau.
●Organized workshops on Value Stream Mapping with Leadership team.
Genius Filters and System Pvt Ltd, Vishakhapatnam, India
Supply Chain Analyst Jun 2014 – Apr 2016
●Identified new suppliers, participated in negotiation and processed contract agreements for vendors.
●Processed +500 purchase orders.
●Generated bill of material for oil and air filters as per the requirement.
●Created Tableau dashboard reports to analyze sales trends, demand forecast, inventory levels and monthly buys.
●Participated in 100+ online bidding/auctions and 20+ projects were allocated
EDUCATION
Northern Illinois University Dekalb, IL
Master of Science in Industrial and Systems Engineering, GPA 3.7 December 2019
Alpha Pi Mu Honor Society of Industrial and Systems Engineering 2019
Swarnandhra College of Engineering and Technology JNTU-K, India
Bachelor of Engineering in Mechanical Engineering May 2014
CERTIFICATION AND BADGES
Logistics Certified
Lean Six Sigma Green belt Certified
Tableau Analyst Badge
Tableau Data Scientist Badge