Xuebing Xian
********@***.*** 651-***-****
**** ***** ** ******** ********, NJ 08043
Education
University of Minnesota — Twin Cities Minneapolis, MN Jan 2017 - May 2019
B.A. Econometrics- Quantitative, Dean's List, GPA: 3.7/4.0
Qingdao University Qingdao, China Sep 2014 - Dec 2016
B.S. Business Administration, 2015-2017 University Scholarship
Certificates: CFA II Candidate (CFA Institute), Python for Data Science (IBM) 2018
Relevant Experience
Areas USA Saint Paul, MN Jan 2019 - May 2019
Data Analyst
•Pulled customer review data with Excel Power Query, and used Python emotion analysis to improve satisfaction rates.
•Created Access/Excel database structure, automated reports, and tracked monthly records to ensure modeling accuracy.
•Updated internal warehouse database, adjusted over 1000 products data flow to support IT and accounting departments.
University of Minnesota Foundation Minneapolis, MN Jan 2018 - Dec 2018
Financing and Data Specialist
•Collaborated with a close-knit team to build up alumni database with special communication skills.
•Achieved a 33% fund rising increases in evaluation model by analysis seasonality of performance data.
Erisonic Innovation Technology Kansas City, KS May 2018 - Sep 2018
Analyst
•Combined Web crawler with Python to captured national massage store data to build the initial data warehouse.
•Cleansed data with SQL Server, and performed ad hoc analyses which directly supported to CEO in strategic planning.
•Developed multiple financial models by conducting a quantitative analysis of demographic data.
•Visualized analysis in investment pitch and presented to investment groups with an estimate of 30 million financings.
Sino-German Ecopark Qingdao, China May 2017 - Sep 2017
Analyst Intern
•Supported the global business of innovation team, and provided a vital language connection within departments.
•Published research projects on the official website by analyzing technical data, also resulting in a detail-oriented report.
Industrial and Commercial Bank of China Qingdao, China May 2016 - Sep 2016
Equity Analyst Intern
•Extracted, and tracked equity market data to update the manager's evaluation model.
•Executed assistance within a fast-paced and demanding modern office, while managing multiple assignments.
Leadership Experience
College Student Innovation Competition China Jun 2016 - Jan 2017
Team Captain - Top 5% among 300 groups
•Led four students to perform fundamental industrial research and proposed investment opportunities.
College Student Entrepreneur Competition China Aug 2015 - Aug 2015
Team Captain - Second Award
•Simulated of entrepreneurship with a profitable project, led the team and practiced Virtual management.
Yilin Home China Jan 2016 - Dec 2016
Team lead
•Paired 100 autistic kids with volunteers, and provided education and weekly care.
Technical & Language Skills
Excel, Outlook, Word, PowerPoint, Access, R, STATA, Python, SQL, Tableau. Mandarin, English.