SWASTI SRIVASTVA

469-***-**** • ac4ve8@r.postjobfree.com • h ttps://www.linkedin.com/in/swasti-srivastva EDUCATION

The University of Texas at Dallas A ug 2016 - May 2018 M.S. in Information Technology and Management (Dean’s Excellence Scholarship) GPA: 3.84 Courses: ERP, Procurement and Contract Management, Operations Management, Lean Six Sigma, Statistics with Advance excel CERTIFICATIONS AND TECHNICAL SKILLS

Certifications: Supply Chain Analytics by MIT(Edx), Data Science Specialization by John Hopkins University(Coursera) Analytical Tools: MS Excel, MS PowerPoint, Tableau, Qlikview, SAP Predictive Analytics, SAP BObj, SAP Ariba Programming: Python, R, SQL, Java, HTML, CSS

Software: SAP APO(Demand Planning/ Supply Network Planning), RStudio, Eclipse, MS Project Databases & SDLC: MS SQL Server, MS Access, Agile, Scrum, Waterfall, JIRA Business EXPERIENCE

Tata Consultancy Services, Bangalore, Supply Chain SAP APO Analyst Oct 2013 - July 2016 (2 years 9 months)

● Analyzed the Supply Chain planning activities o f pharmaceutical and consumer product company Johnson & Johnson

● Managed Demand Planning and Supply Networking Planning using SAP Advance Planning and Optimization tool

● Responsible for ensuring requirement flow of the right products in right quantities, to right locations at the right time

● Provided support for requirement gathering & r oot cause analysis increasing the customer satisfaction metric to 94%

● Generated K PIs using S QL scripts, Excel and Tableau to provide business insights on demand, sales and inventory

● Monitored inventory levels, sales order, safety stocks, PReq conversion to PO, transportation lanes and means of transport

● Reviewed future demand using statistical forecasting methods, preventing warehouse from any possible stock outs

● Designed M acros for carrying out variety of validations on client data, performing calculations to warn exceptional messages

● Formulated UATs, functional specification and technical documents and mitigated issues in all the phases of project

● Won 5 ‘ On Spot Awards’ and ‘ Best Team Award’ for strong configuration/design skills increasing client productivity by 2 0% Tata Consultancy Services, Gandhinagar, SAP ABAP/Production Planning Intern Aug 2013 - Oct 2013 (3 months)

● Trained on SAP ABAP development and familiarized with smart forms, reports, internal tables, ALV and Script query.

● Set up Master data, work centres, Bill of Materials, Routing, Production Version, Material requirement planning

● Won the “ S tar Intern ” award for outstanding performance in the duration of training Thales USA Inc., Virginia, Procurement Analyst Intern May 2017 - Jan 2018 (8 months)

● Supplier data extraction, consolidation and analysis from various ERPs using Excel, Python and Tableau visualizations

● Developed K PIs for Supplier Rationalization, Non PO Spend, Annual Purchasing Volume, Purchasing Price Variance, Delivery Backlog and On Time Delivery to measure, control and benchmark procurement process

● Performed supplier rationalization thereby reducing the out-of- business or inactive suppliers by 35%

● Performed analysis for the S AP Ariba pilot implementation and deployment planning using Tableau visualizations

● Business P roject lead for procurement of IT services for implementation of Procurement’s Qlikview dashboard ACADEMIC PROJECTS

Kristen Cookies: Process Analysis and Improvement (Supply Chain Operations Management) Jan 2017

● Measured cycle time, flow rate, demand rate, average inventory, and resource utilization through process flow diagrams

● Analyzed and identified process bottlenecks, increased p rocess capacity by 20% using resource planning like line balancing

● Developed Gantt Chart f or project scheduling and planning ensuring 96% c ustomer order demand rate fulfillment Scotts Miracle Gro: Spreader sourcing/Make vs Buy (Purchasing, Procurement & Contract Management) March 2017

● Defined strategic risks and benefits of outsourcing production of a plant in USA to a contract manufacturer in China

● Evaluated NPV for a 5 year contract using Cost Modelling Analysis and proposed best strategy s aving $20,000 by outsourcing COMPETITION & ACHIEVEMENTS

Ericsson Operations Management Poster Competition: P articipated and secured 3rd place in a business case to improve operational efficiency and maximize the profit for a beverage manufacturing company. Implemented Six Sigma based DMAIC model and achieved 40% increase in the revenue improving stock out rate from 45% to less than 10% and with near zero expense on reverse logistics by eliminating waste from the processes.