Data Analyst Lean Six

EDUCATION

Mansi Sachdeva

Dallas, Texas 469-***-**** add7of@r.postjobfree.com LinkedIn

MS, Supply Chain Management, The University of Texas at Dallas, May 2020 BSc, Chemistry Honors, University of Delhi, 2016 (GPA 3.9) SKILLS

● Project Management

● Statistics and Data Analysis

● Global Logistics & Transportation

● Global Supply Chain Management

● Purchasing, Sourcing, Contract

Management & Negotiation.

● MS (Word, Access, PowerPoint)

● Advanced Excel(VLOOKUP, Pivot

Tables, Macros, VBA)

● Accounting for Managers

● Advanced SQL, Oracle

● SAP ERP, APO, SAP HANA

● Operations Management

● Tableau, Power BI, Alteryx

PROFESSIONAL EXPERIENCE

Daimler Trucks North America, Aftermarket Supply Chain Logistics Metrics Intern, December 2019 – May 2020

• Led and drove an API implementation project for 150+ suppliers to improve inbound logistics network performance by 30%.

• Built a self-sufficient BI dashboard on Tableau to report ASN Compliance by 1100+ US, Canadian and Mexican vendors and on 850, 855, 856 and 997 X12 EDI transactions and enhanced the compliance rates by 20%

• Automated daily processing of almost $30000 worth of failed IDocs by building an SAP GUI application using VBA and Python with additional savings of 51/2 hrs of daily processing time and $70000 annually on full-time job

• Designed SQL database, access forms, reporting on Tableau of API project enabling stakeholders to improve performance by 50%.

• Created and maintained documentation of the current process followed and future state based on insights gained during analysis. Ericsson, Strategic Sourcing Analyst Intern, September 2019 – December 2019

• Implemented SQL database, created queries and the SQL scripts to automate data consumption and aggregation for sourcing organization and supported the change to SAP HANA.

• Developed advanced analytics visualizations and models (in Tableau and Excel) to drive strategic decision making and savings – enabling over 10% in additional savings on projects.

• Designed & maintained the data architecture & governance by leveraging multiple scripting languages, HANA, SQL & Tableau. Steward Healthcare, Supply Chain Data Analyst Intern, May 2019 – August 2019

• Created a vendor database, executing data mining on Excel spreadsheets to deliver 5+ new supplier scorecards based on KPIs.

• Researched 6000+ suppliers and maintaining catalog accuracy adding more than 2000+ products to the database.

• Audited project documents- spend analysis reports, RFIs, RFQs, purchase orders, bidding reports and cited 20% monetary errors Indigo Airlines, Airport Operations & Customer Services Officer, Feb 2018 – June 2018

• Analyzed sales data to predict demand & supply patterns for peak & slack flying seasons for all routes using statistical regression.

• Increased efficiency, profits & minimized expenses using linear programming tools, increased revenues on certain routes by 12%.

• Utilized DMAIC, 5S & PDCA techniques of Lean six sigma to achieve strategic business goals, eliminated wastages and variations. Orient Bars & Components India, Operations Associate, July 2016 – Feb 2018

• Prepared purchase orders for raw material, reviewed specifications, matched orders to invoices, improved order accuracy by 20%.

• Communicated with over 16+ vendors, followed up on orders, improved vendor relations and maintained 90% vendor retention rate.

• Developed strategic supplier partnerships based on cost & financial analysis models, improved supplier performance by 8%.

• Managed inbound and outbound logistics, calculated order size to manage inventory levels increasing inventory turnover by 9%. ACADEMIC PROJECTS

Walmart Retail Management System, Aug 2018 – Dec 2018

• Designed database, encompassing business processes based on inventory, transactions, and vendor data, utilizing spreadsheets and transferred it to MS Access, created an entity relational database model, normalized tables and implemented SQL queries.

• Used Agile methodology by working as user incorporating incremental and taking feedback leading to increased efficiency by 8%. LEADERSHIP AND AFFILIATIONS

● SKY Club (Youth Empowerment & Skills), President, UT Dallas, 2018

● SALSS (Student Association Lean Six Sigma), Vice President, UT Dallas, 2018

Contact this candidate