Xiaoxue (Ella) Duan

Green card holder 217-***-****

San Francisco, CA, 94121 ac4efg@r.postjobfree.com

SUMMARY

● 3+ years of experience in Statistical Analysis, Modeling, and Data Mining.

● Proficient skills in SAS, R, Python, SQL, Tableau, EXCEL, SPSS, Hadoop, and JAVA.

● Extensive experience in large data preparation & visualization, predicative analytics, Google analytics, machine learning techniques (regression, time series, mixed model, Bayesian methods, clustering, etc.) and operating systems such as Linux, Windows, and iOS.

● Consulting experience with clients from finance, real estate and tourism industry.

● Excellent communication skills with conference presentation and publication. EDUCATION

M.S. Statistics, University of Illinois at Urbana-Champaign (UIUC) Dec 2017 M.S. Tourism Management, East China Normal University (ECNU) July 2011 B.S. Tourism Management, Shanghai University of International Business and Economics July 2007 WORK EXPERIENCE

● Graduate Research Assistant at UIUC Business School June 2017 – Dec 2017 Translated research questions on power & status in diverse teams into hierarchical linear models, designed online surveys in Qualtrics, discussed with professors about data results and generated new findings on the relation between unbalanced status and diverse team cooperation Refined and enriched large datasets in R for research on diversity in workplace, developed regression models in Python for hypothesis testing on the minority’s perception of stereotype in the workplace Cleaned unstructured datasets on female’s career path on STEM industries, predicted female employee’ career choice based on their personal characters and organizational factors with K-means clustering in Python, and interpreted data methodology and results to Ph.D. students, professor and wider audience with non-technical backgrounds.

Conducted literature reviews on female surgeon’s career path and designed recruiting methods for interviews Weekly presentation of research progress on 4 projects with data visualizations to professors

● Modeling and Analytics Intern at State Farm R & D Center May 2016 – Aug 2016 Conducted projects independently on creating a scorecard macro model with scaling options in SAS and SQL to calculate applicants’ scorecard points via logistic regression, presented final model and its usage in credit scoring to team members and internal clients in bank department, cut costs on the license renewal of related software with application of this model in banking department

● Visiting Scholar at UIUC Department of Recreation, Sports and Tourism Jan 2013 – Aug 2014 Conducted semi-structured interviews and research on Chinese Americans’ outdoor leisure activities

● Research Associate at Zhejiang University Business School Sept 2011 – Dec 2012 Led a research team of 5 members focused on National Funding application on leisure behavior of migrant workers in urban China including conducting literature reviews and developing proposals Communicated with clients to understand their needs on tourism planning and product design in a state park, collected data via online survey and field study, and provided written report to senior management and clients

● Graduate Research Assistant at ECNU Strategy Consulting Firm Sept 2008 – June 2011 Analyzed customer behavioral patterns in tourism industry with regression models in SQL & EXCEL and presented on-demand reports on marketing strategy to clients from real estate, parks, and government agencies PRESENTATION

Duan, X. “Atmospheric Cues Of Religious Tourism: A Conceptual Model and Implications.” 2013 Leisure Research Symposium Book of Abstracts, National Recreation and Park Association, Huston