Xuanhui (Rebecca) Liao

Dallas TX ***** 336-***-**** ac9bkm@r.postjobfree.com

EDUCATION

Southern Methodist University, Cox School of Business Dallas, TX Master of Science in Business Analytics (MSBA) (STEM certified) GPA: 3.94 May 2019 Wake Forest University, School of Business Winston-Salem, NC Bachelor of Science in Finance and Bachelor of Arts in Mathematical Statistics May 2018 GPA: 3.78, Magna Cum Laude, Dean’s List

London School of Economics and Political Science GPA: 4.0 Summer 2016 TECHNICAL SKILLS (*in progress)

SQL • Tableau • R • Python • Hadoop* • SAS* • Alteryx • KNIME • Predictive Modelling • Google Analytics*• Power BI EXPERIENCE

J.C. Penney Dallas, Texas

Workforce Analytics Project Jan. 2019-Present

• Evaluate turnover rates across stores and analyze drivers of turnover at the employee level

• Visualize relationships between work environment, market conditions, characteristics of employee and general manager, and turnover rates through Tableau

• Build logistic regression model and survival analysis in R to quantify the main factors and forecast turnover Dallas Stars Dallas, Texas

Revenue Management Project Aug. 2018-Oct. 2018

• Examined the organization’s three-season dataset; visualized purchase types’ patterns of upgrade/downgrade through Tableau; gave applicable suggestions to maximize revenue

• Incorporated external data sources, demographic data in particular, to analyze its surrounding potential market; introduced product “Family Plan” and demonstrated the reasonings and underlying revenue implications China Construction Bank (Data Management Department) Guangzhou, China Business Process Analyst Intern May 2018-July 2018

• Analyzed characteristics of different client groups to grow existing market presence; utilized SQL to segment customers to facilitate precision marketing; successfully enhanced the response rate from 3% to 18%

• Coordinated with a project team to research and construct a model to predict credit score; manipulated the credit score collected over time to discover patterns and generate insights to improve clients performance

• Explored internal and external data to evaluate the competition and risks posed by peer to peer lending platforms and minimize the loss of profits and clients

Imaging Dynamics Company Ltd. Guangzhou, China

Financial Assistant Intern May 2017-July 2017

• Led substantial financial activities including producing monthly financial statements, managing company’s social insurance account and monitoring company’s bank account

• Conducted cost trend analyses, adjusted reimbursement policies, and followed up with potential clients to facilitate employees’ efficiency and clients’ loyalty; generating over $50,000

• Improved company image by orchestrating application for “FDA Class III. Medical Device Certificate” and

“Science and Technology Innovation Giant”

GF Futures Co., Ltd. (International Department) Guangzhou, China Business Analyst Intern May 2015-July 2015

• Applied concepts and rules of Futures; processed deposits and withdrawals, answered customers’ inquiries, filed contracts, and attended weekly meetings

• Researched and analyzed information on Free Trade Zone to help management determine possible opportunities and risks in the market

• Analyzed the dramatic fluctuation of market prices during the three-month period and generated report ACADEMIC PROJECTS

Predictive Analytics

• Collected and manipulated 12 variables of 167 countries and displayed data to observe patterns

• Employed statistical models including linear, logit and quadratic regression and adjust the models based on t-tests, f–tests, and diagnostic plots to determine the most influential factors of a country’s economy

• Evaluated the fit (AIC, BIC, VIF etc.) of different models to generate model reports and future GDP forecast Predictive Analytics

• Operated and analyzed historical stock market data within a 6-year period

• Built models using Python according to a specific trading strategy to determine the optimal investment portfolio and weight of each stock moving forward

• Derived the results and compared them to CSI 300 Index to test whether the trading strategy is effective CASE COMPETITIONS

Interdisciplinary Contest in Modeling, Meritorious Winner

• Developed a comprehensive analysis of the ORD security checkpoint system to settle its congestion problem

• Derived and applied three mathematical models in R: Petri Net Model, Continuous Time Markov Chain Model, and Queuing Model to figure out bottlenecks, quantify necessary probabilities, and provided recommendations KPMG International Case Competition, Winner on Campus

• Analyzed a luxury hotel’s strategies, goals, and related datasets

• Developed innovative proposals to enhance its customers’ loyalty and grow its market presence LEADERSHIP & VOLUNTEER ACTIVITIES

International Volunteer HQ Cusco, Peru

Program Assistant December 2016-January 2017

• Arranged Christmas party at an orphanage, medical campaigns in an Andean village, and visits to an animal shelter; deepened volunteers’ social responsibility, refresh their perception of the world, and spread awareness of the medical disparities

• Improved the program operating process, resulting in a more engaging volunteer atmosphere Campus Kitchen Winston-Salem, NC

Shift Leader and Volunteer September 2015-May 2018

• Direct the redistribution of produce and grocery items to the needy, bolstering sustainability initiatives

• Oversee preparation and delivery of meals to local homeless shelters: Senior Centers, Hospitality Houses and Children’s Home

• Facilitate the packing and serving of snacks to local mentoring program, Latino Community and American Indian Community

LIT Dance Club Winston-Salem, NC

Leader and Choreographer March 2015-May 2018

• Plan, organize, and supervise practices and rehearsals for important upcoming performances and workshops

• Collaborate with other dance crews to perform at dance showcases and festival celebrations, such as World Cultural Festival and “Burn It Up”, to promote culture diversity Badminton Club Winston-Salem, NC

Treasurer and Member September 2014-May 2018

• Manage over $3000 event budget to boost club morale, establish closer ties between members, and elevate club reputation and awareness; write budget allocation reports to apply for funding each semester

• Organize Badminton Competition with Duke University once a year; design club t-shirts; attend weekly trainings HONORS & AWARDS

• Beta Gamma Sigma Business Honor Society, Member; Pi Mu Epsilon (PME) Honor Society, Member; Golden Key International Honour Society, Member

Contact this candidate