Data Analyst

Ying Xue

*****@********.*** j https://www.linkedin.com/in/ying-xue-2019/ j 206-***-****

Objective

Master of Business Analytics 8 years of professional experience in roles related to analytics and customer relationship management. Skilled at drawing insights from large datasets and communicating action- able recommendations to drive business growth and improve customer experience. Looking for role as Business/Data analyst.

Education

Seattle University Seattle, WA

Master of Science in Business Analytics (STEM Program) Sep 2018 - Mar 2020

Awards: Albers Graduate Scholarship, Dean’s List GPA 3.7/4.0

Selected Coursework: Big Data and Machine Learning, Python Programming, Econometrics, Relational Database (SQL), Methods in Statistics, Financial Modeling, Discrete Mathematics Guangdong University of Foreign Studies Guangzhou, China Bachelor of Art in International Trade Sep 2005 - June 2009

Awards: Outstanding Student Scholarship for 4 consecutive years GPA 3.8/4.0 Experience

Industrial and Commercial Bank of China Guangzhou, China Credit Risk Analyst and Product Manager Feb 2012 - Aug 2018

Conducted 6-8 monthly analytics reports to inform loan decision making with quantitative analysis of industry research and financial statement.

Data mining with CRM systems/dashboards and increased penetration rate and sales by 10%.

Teamed in a global cross-functional expert team to accomplish the first ever international guarantee project

($40M) for a listed company within 2 months

Provided product consulting services to international commodity traders ($2B annual revenue) out of 100+ products (cross-border payment, loan, risk management, E-ecommerce). Increased bank business by 20% per year, which brought me Top10 (out of 200+) Manager in the region from 2015 to 2018. Customer Relationship Manager Sep 2009 - Feb 2012

Designed form automation system to save customer 20 minutes per filling.

Provided financial service for the 2010 Asian Games in the company’s elite team (60 out of 15K+ employees). Projects

Bookstore Database Analysis and Design (SQL)

Used Amazon Bookstore database and applied cloud migration through AWS for group collaboration.

Implemented stored procedure, view, window functions and analytical query to drive business insight.

Built automated dashboards and reports through Tableau to make recommendations for stakeholders. AWS Customer Clustering and Predictive Analysis (Python and R)

Predicted customer product choice and analyzed drivers of their behaviors of 53K subscribers’ data.

Improved machine learning models by feature engineering using customer clustering.

Applied machine learning models (K-Means, random forest and decision tree) to achieve 76% accuracy. Marketing Attribution Analysis for Zillow Group Sales (R)

Integrated and transformed 7M+ source data across multiple systems for sales pipelines analysis.

Applied attribution models such as first/last/linear touch and Markov attribution model to analyze key metrics to uncover trends and root causes of successful conversion.

Delivered dashboard, reports and strategic recommendations to stakeholders. Hotel Demand Forecasting (R)

Developed and improved forecasting methodologies by applying time series models and machine learning algorithms to predicts based on 3 years of real hotel booking data.

Conveyed mathematical concepts and project results to non-experts. Skills

Query/Programming Languages: SQL, R, Python, Git

Data Visualization: Tableau, PowerBI, QuickSight

Languages: Mandarin and Cantonese (native), English (fluent)

Contact this candidate