Angela Mengqi Wan Email & Phone Number

Plano, TX

- Lead annual pricing adjustment initiative by triangulating product strategy, profitability, and external market factors and working closely with product management and global sales team- Manage discount threshold model based on customer segmentation, product categories, and historical bookings to achieve better margin/annuity growth by providing pricing.

- Created Power BI tool to visualize suppliers’ data for supplier selection process- Developed VBA scripts to facilitate annual budgeting process through data mapping and background calculations- Designed and conducted training sessions on Excel Macros and VBA for 30 colleagues

Greater New York City Area

- Participated in and won the Best Presentation in LV’s worldwide Ultimate Supply Chain Contest- Applied clustering, forecasting algorithm and markov chain methods to estimate products’ average weekly usage at various supply chain levels in five regions- Solely implemented the final model for end results and created metric dashboard to monitor weekly results

Greater New York City Area

- Worked with INSEAD’s professor Phil Parker and led a team of four to develop a go-to-market strategy for One Book to Graduate project by analyzing test result, conducting market research, and designing funders’ package

Phoenix, Arizona Area

- Supported Operations team to monitor performance by creating KPI metrics dashboard and workflow. Designed IT solutions in terms of automation and ad hoc reporting using Excel VBA, SQL and internal scripting languages - Managed new customer transition by integrating IT systems with upstream and downstream supply chain partners- Setting up warehouse layout.

3930 East Watkins Street #100 Phoenix, AZ 85034

- Performed operational tasks such as logging files and scanning legal documentations into internal system for each shipment- Executed accounting tasks such as tracking missing invoices, checking account receivable and paying account payable- Developed two programs using Excel Visual Basics to analyze large amount of data for managerial purposes

- Facilitated classes of more than 2000 students, documented and managed students’ grades- Taught skills for academic success and led dynamic and meaningful discussions

- Led a group of 15 Chinese students to explore England by preparing their visa application, taking responsibilities of their safety for the whole trip and dealing with any emergencies that happened- Enriched students' experience at the camp by encouraging students to engage in all the activities- Organized activities for students during their spare time.

- Translated documents and in person between Chinese and English during the meetings- Prepared and participated telephone conference for Weekly Shortage Control and Monthly Production and Supply Meeting by emailing the meeting schedules and writing meeting memo- Facilitated Nanchang plant preparing for MMOG/LE Evaluation- Assisted in developing storage.

Master’S Degree, Management Science And Engineering

Relevant Courses: Operation Consulting Business Analytics (using R) Optimization Models Stochastic Modeling Managerial Negotiations Demand.

Bachelor Of Science, Supply Chain Management, Computer Information System, International Business Certificate

Activities and Societies: Coalition of International Students, Supply Chain Management Association, Department of Information System Club.