Yu Zhou

Major: BBA MIS
Graduation: May 2018

Student

MIS Badge

Official Professional Achievement badge awarded by the Department of Management Information Systems

Click here to validate the recipient

Walmart_logoAbout the internship

This summer, I worked as a project management intern in Hypermarket Merchandising Department at Walmart (China) Home Office for 10 weeks. This internship program was aiming to support 2016 Mid-Autumn Festival Mooncake sales. Interns would get involve in the whole business flow from contracts signing to the end of sales in the role of assistant merchandiser. Our duties include managing commodity files in the merchandising system, supporting sales-related documents, managing orders, completing data analysis for sales reports and coordinating with suppliers to ensure shipment, goods display and promotion activities.

What I learned from the internship

During the internship, I developed detail-oriented skills, technical skills and time management skills. In the first stage, I contacted 9 mooncake suppliers in order to know their products and collect their quotations. Then using excel to enter data and set up new commodity records in the system. There may be some commodities already existed in the system which either in active status or in inactive status. I need to contrast the data and choose to update or just active the records. It is significant to ensure the accuracy of each data in the system which will directly affect the order process. In the second stage, I collected merchandise certificates, promotion plans, circular pictures and other sales-supporting documents from all suppliers. In addition, final checked all commodity records and make changes if needed. In the last stage, I assisted with order placing and started running business reports. I learned about retrieving data from the retail link system and using pivot table and vlookup to make reports which showing the sales rate and receipt rate of this year and last year. I learned to analyze the reports to discover problems and make improvements accordingly. I really appreciate to have this internship because it gave me insights to the retail industry. I have learned many marketing tools and technical tools to help market decisions.

Leave a Reply

Your email address will not be published. Required fields are marked *


Professional Achievements

  • WORK EXPERIENCE 1
  • PROJECTS 1
    • Class project Fall 2017

  • PARTICIPATION 9
    • Fox IT Career FairFall 2015

    • Other Career FairSpring 2016, Fall 2017

    • IBIT small group meeting with industrySpring 2016, Fall 2017

    • IBIT/CDI Challenge or ConferenceFall 2015, Fall 2017

    • Active AIS memberFall 2015, Fall 2017

  • ATTENDANCE 7
    • Fox IT AwardsSpring 2017

    • Active TDAP memberFall 2015, Spring 2016, Fall 2017

    • AIS professional development workshopFall 2015, Spring 2016, Fall 2017

Skip to toolbar