Mingye (Eric) Yang

Experience

• 

  家乐福中国

  Jun 2016 - Aug 2016

  Business Analyst Intern

  • Gathered and organized daily, weekly and monthly sales data of over 20 products in this supermarket using Excel.• Produced sales performance charts and analyzed sales fluctuation through communicating with the suppliers and conducting online survey.• Participated in employee training workshops to develop work efficiency, business acumen and decision making skills.

• 

  China Mobile Phones

  Jul 2017 - Sept 2017

  Data Analyst Intern

  • Collected and kept track of the business data of over 5000 users in 10 university campuses and the sales data of the 15 local branches.• Performed ad-hoc analysis and generated daily report using Excel (Vlookup, Pivot Tables, etc.) and wrote SQL queries using complex joins, nested subqueries, etc.• Collaborated with other interns to improve our service and adjusted budget allocation and increased sales by 13%.

• 

  UC Davis Graduate School of Management

  Dec 2017 - Jun 2018

  Student Research Assistant

  • Converted Pyomo (a Python-based optimization modeling tool) documentations to reStructruedText sources using Sphinx.• Wrote Python code to convert frequently appeared characters/symbols in the documentations and reduced about 20% working time.• Learned Pyomo model and labeled all code snippets for other collaborator's convenience.

• 

  Pharmacyclics, an AbbVie Company

  Sept 2018 - Apr 2019

  Data Integrity Specialist