Page * of *

Claire (Xiaopan) Hua

Dallas, TX, ***06 469-***-**** ac867v@r.postjobfree.com

STEM and OPT Certified; Authorized to work for any employer until 2022 EDUCATION

Southern Methodist University, Cox School of Business Dallas, TX Master of Science in Business Analytics (GPA: 3.91/4.0) Anticipated May 2019 Coursework: Applied Predictive Analytics I&II, Business Intelligence, Big Data, Data Mining, Data Visualization, Database Design Fudan University Shanghai, China

Bachelor of Arts in English & Double Major in Bachelor of Management in Accounting (GPA: 3.4/ 4.0) Jun. 2018 Coursework: Financial Management I&II, Intermediate Accounting I&II, Cost and Management Accounting, Auditing TECHNICAL SKILLS (* in progress)

•Tableau •Power BI •Alteryx • R(dplyr/ggplot2)/tydir/shiny) •Python(pandas/numPy/matplotlib/seaborn) •Knime • SPSS •SAS •Visio

•SQL •Report Builder (SSRS) •Visual Studio 2017 (SSIS) •MS Excel (v-lookup, Solver, Pivot, Decision Tree, Macros) •NodeXL*

•Google Analytics (Individual Qualification) •Spark* •Hadoop* ACADEMIC PROJECTS

Greystar Irving, TX

Practicum Business Analyst Intern Jan. 2019 – May 2019

• Works closely with Greystar to define user stories, discover business challenges, and develop conceptual design for analytics system

• Develops ETL processes through SSIS, builds a data warehouse and created KPIs in property level in SQL Server

• Analyzes and visualizes property data in the Dallas and Houston markets to identify competitors by radius, zip code and submarket

• Builds a predictive model and performs a what-if analysis on pricing by introducing external demographic and economic data

• Creates Power BI dashboards to display performance metrics, which will help Greystar to adjust pricing in a timely manner JCPenney Dallas, TX

Project Data Analyst Intern Sep. 2018 – Oct. 2018

• Cleaned over 13GB of sourcing data through Alteryx to make the dataset available for dashboard requirements

• Utilized Tableau dashboards illustrating geospatial and operation insights to identify key cost drivers in retailing supply chain

• Presented Tableau dashboards to senior managers to provide recommendations for cost optimization within the firm Database Design Project Oct. 2018 – Dec.2018

• Designed a music catalog database and developed a music recommendation mechanism using Least Mean Square Algorithm

• Analyzed database physical structure and functional requirements of virtual users

• Created the user interface Shiny using R and presented the analytics user case in the business context PROFESSIONAL EXPERIENCE

Accenture Shanghai, China

Strategy Consulting Analyst Intern Mar. 2018 – Jul. 2018

• Conducted industry research and financial analysis to help clients expand operations in the global market

• Created a regression model in R based on 5 years of data to infer the factors that influence operating income in 7 global regions

• Conducted competitive benchmarking analysis to evaluate in aspect of facilities, completed projects, funding, market distribution, etc.

• Created dashboards to drill down the regional market analysis and provided clients insights with a focus on regional business strategy Kantar Media CIC Shanghai, China

Social Media Analyst Intern Sep. 2017 – Nov. 2017

• Measured buzz volume and sentiments in Weibo, China’s largest social networking platform for luxury brand such as LVMH to evaluate the effectiveness of their marketing campaigns, helping clients achieve 7% increase in customer satisfaction during this time

• Analyzed textual and numerical social media intelligence data for the clients and generated daily operations reports (15-25 KPIs) Shanghai Pudong Development Bank Nanjing, China

Marketing Analyst Intern Jun. 2017 – Aug. 2017

• Managed the launch of a new credit card targeted at female users, attracting 4 million customers

• Segmented target customers using K-means algorithm in R and determined cluster numbers with the help of data scientists

• Improved customer profile based on different clusters’ purchase behavior and lifestyle and identified promotional business partners Deloitte Shanghai, China

Audit Intern Jan. 2017 – Feb. 2017

• Worked in a team to create annual financial statements with over $30 billion cash flow for a large securities corporation

• Prepared over 10 workpapers, checked balance sheet and performed varying audit procedures based on materiality ACTIVITIES & INTERESTS

Activities Operations & Analytics Club, Bilingual Guide in Shanghai Jewish Refugees Museum, Vice President of Technology & Education: Connecting Cultures, Volunteer Leader of TECC Summer Institute Interests Zumba dancing, swimming, musicals

Contact this candidate