Xiaofei Wang

Swan St.***, Potsdam, NY, ***** 315-***-**** addstv@r.postjobfree.com

Summary

Because of my excellent data processing ability, financial background and eager to deal with big data, my target is to use my relevant knowledge to analyze the significant big data in order to save time and decrease the cost. Education

M.S. in Data Analytics

Clarkson University, Potsdam, NY Jan. 2019 – May 2020 Major: B.S. in Financial Information & Analysis Minor: Statistics Clarkson University, Potsdam, NY Sept. 2016 – Dec. 2018 B.S. in Business Administration

Jianghan University, Wuhan, China Sept. 2013 – July 2016 Work Experience

Data Analytics Intern, Kingdee International Software Group, Shenzhen China Aug. 2019 – Sept. 2019

—Collected sales data for the past six months from a chain restaurant group with more than 100 sites.

—Utilized Python for data cleaning in order to improve the quality of the data.

—Created a predictive analytics model that helps the chain restaurant with sales volume in the next week.

—Optimized the model to an accuracy rate of 80%.

—Recommended to the client an option to decrease the cost as a result of scientifically managed procurement. Finance Intern, Kerui Petroleum Equipment (America) Corp, Houston TX July 2018 – Aug. 2018

—Utilized SAP to record the daily expenses of the company.

—Made separate statements of debt and asset for different bank accounts.

—Assisted with the reimbursement based on receipts, check collection and payment processes. Academic Projects

Inflation Prediction & Suggestion, Data Mining, Clarkson University June 2019 – Aug. 2019

—Downloaded data that influenced the Inflation index(CPI); made time serious diagrams and checked the multicollinearity.

—Built a multiple regression model with interaction effect for CPI because some variables influenced each other.

—Used Python to predicted CPI by analyzing the result of the regression model and then provided suggestions for solving inflation problem. Scooter Feasibility Analysis, Modeling For Insight, Clarkson University Mar. 2019 – May 2019

—Framed the problem and discussed the influenced diagram for our iterated models.

—Defined each variable in the model and selected appropriate distributions in the Excel.

—Used Analytic Solver to run the Monte Carlo Simulation to generate different types of graphs in order to do sensitivity analysis and genera- te actionable insights.

Technical Skills

Python, Java, R, C, Analytic Solver

Volunteer & Clubs

—Volunteered at Shenzhen Central Bookstore during summer vacations

—PingPong Club at Clarkson University

—Soccer Club at Clarkson University and JiangHan University