Data Analyst Engineering

Priti Vithaldas Pai *****@***.*** 213-***-****

EDUCATION

• University of Southern California, Los Angeles, USA August 2019 - Present MS in Engineering Management (Industrial Engineering) (GPA: 3.9/4) Courses: Supply Chain Management, Supply Chain Analytics, Advanced Production Planning and Scheduling, Project Management, ERP and Statistics for Engineering Managers

• University of Southern California- Marshall School of Business, Los Angeles, USA Graduate Certificate in Optimization and Supply Chain Management August 2019 - Present

• University of Mumbai, Mumbai, India

Bachelor of Engineering in Electronics and Telecommunication (GPA: 9.25/10) SKILLS

• Programming Languages: C, C++, JAVA, PYTHON

• Tools: PSPICE, Matlab, EAGLE, Proteus, PCAAD, Scilab, SAP, Tableau, MS Office, MS Project WORK EXPERIENCE

USC Advancement Operations January 2020 - Present

Data Analyst

• Analyze data from various databases such as Salesforce, CyberSource and provide immediate solutions to potential donors and alumni for customer satisfaction.

• Compiled a telemarketing report for upper management to analyze giving data across various departments in USC.

• Created and improved audit reports that are run weekly to correct data discrepancies. Shekham Fasteners, Vapi, India June 2018 – November 2018 Supply Chain Management Intern

• Reviewed open orders and drove order confirmation, coordinating with warehouse executives; collected shipment compliance documents from 2 suppliers to maintain timely shipment of parts and update of ERP system.

• Investigated quality standards of new product; ensured compliance of manufacturing process to international norms in team of 5, increasing safety by 40%.

• Daily production planning, productivity tracking, and reporting utilizing the warehouse management system to run weekly shipping reports.

• Presented analysis and suggested recommendations to the senior leadership team. PROJECTS

Forecast KPI

• Understand and validate the demand forecast data by comparing forecast against sales history.

• Develop a Forecast Accuracy Visualization using Tableau to monitor, track and report national level forecast accuracy as a KPI.

Inventory Optimization

• Inventory Visualization - Visualize inventory level & cost through product hierarchy for 5000 products using Tableau.

• Inventory Reduction Pilot - Calculate, aggregate, and drill down inventory weeks cover, holding cost, and cost of capital at 5 different levels of product hierarchy.

• Optimize inventory using inventory calculator, identify optimal inventory level and inventory cost reduction. Production Optimization

• Develop an optimization model using Open Solver for weekly Production Plan over 52 – week time horizon.

• Calculate costs impacted, safety, cycle & build stock for each scenario & compare optimized plan against EOQ. Payload Optimization

• Develop a Tableau Dashboard to visualize current state payload.

• Analyze the visualization and identify lanes for payload improvement. HEC Montreal ERP Simulation Game

• Led a team of 5 to strategize and execute an entire business process for a FMCG company in SAP ERP including Demand Planning, Forecasting, Procurement, Production, Marketing, Finance, Sales and Accounting Modules.

• Analysed data using MS Access database and MS Excel to evaluate dynamic market conditions and strategies to maximize profits and maintained productivity of 97% throughout the supply chain. LEADERSHIP

• Viterbi Graduate Student Ambassador - University of Southern California

• Event Coordinator at Association of Indian Students - University of Southern California

• Club Service Director - Rotaract Club of Bombay Powai

Contact this candidate