SWASTI SRIVASTVA
469-***-**** • ******.*********@*****.*** • 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.