Developed handouts about Azure, SAS, Databricks, R and Dataiku to instruct students to install and use these applications for data analysis.Grading database homework using Microsoft Access and answer students' questions regarding R programming.

Calculated market share for each type of business in each area and explored possible potential customers.Made slides introducing the business of the company to stakeholders

• Used SQL to performed data, calculated customer satisfication survey data based on different dimensions; • Assisted in analyzing influencing factors of the negative review rate of goods with SPSS and identifying causes for the results, and proposing optimization measures.• Created monitoring dashboard (Power BI) about commodity price fluctuations for retail department, helped to identify the most abnormal fluctuations and the unreasonable prices, and assisted in finding the key metrics help business performance. • Communicated with internal or external stakeholders to handle purchasing and selling issues through multiple measures of problem-solving, including but not limited to clarifying doubts, answering emails, identifying communication difficulties, promoting a negotiated settlement, and proposing measures to improve inefficiencies.• Responsbile for any adhoc requests from departments as needed in collecting, sorting, and analyzing customer experience data.

• Gathered customer satisfaction data, and collaborated with the after-sales department to conduct unsatisfactory cases study and generated weekly customer satisfaction dashboard • Assisted in updating weekly report to address customers’ purchase conversion rate from price, delivery date, sales service and response• Analyzed and delivered the insights in customer buying behavior and consumer psychology in the e-commerce environment.• Generated monthly sales reports to various departments using SQL and Excel.