Xiaoping Wang Email & Phone Number

Ames,Ia

Systematically studied on design of experiments & surveys, data processing & analyzing, data mining, modeling, and forecasting Forecasted future weekly sales for Walmart stores: Analyzed sales data for Walmart stores; identified the sales trends with annual holidays and promotional events; and built a linear regression model to forecast future weekly sales Investigated severe weather trends and effects: Analyzed data related severe weather events and disasters in the US between 2002 and 2011; examined the frequency, seasonal and geographic patterns for different categories of severe weather events; examined the financial impact and the number of injuries and fatalities caused by severe weather events

Conducted market research on baby products sold on taobao.com; managed and analyzed sales data of the store using Microsoft Access and SQLCreated weekly and monthly financial reports & individual and collective sales performance reportImproved store's performance based on the analysis of sales trends, customer segmentation, eCommerce marketing metrics. With constant testing and data analysis, under-performing products were constantly eliminated and performing products kept

Ames, Iowa

Designed an experiment on a novel semi-conductor chip manufacturing process Created a set of new statistical variables to quantify microscopic surface characteristics of semiconductor wafer and the polishing pad used in the manufacturing process Developed a model to accurately predict the evolution of the characteristics of both wafer and polishing pads using the new statistical variables; the model is used to predicting wafer surface levelness via measuring the polishing pad surface to ensure continuity and high efficiency of the process

Xi'An, Shaanxi

Provided dean’s office and other school officials scheduled and ad hoc reports on issues such as student demography, academic achievements, organizations and activities, and effectiveness of policies, etc. Data was retrieved with SQL statements and reports were created using ExcelSupervised ten 30-student classes undergraduate student academic and extracurricular activitiesOrganized student events to promote interactions between students, teachers, university staffs, and societyPlaned and hosted student recruitment events at high schools in Shanxi province for Xi’an Jiaotong University; recruited fresh undergraduate student in Shanxi Province

Master'S Degree, Statisitcs

Master'S Degree, Mechanical Engineering

Bachelor'S Degree, Mechanical Engineering