Data Analyst and Report Developer

XUYING (AMBER) LI

New York, NY *****

917-***-**** ******.**@*******.*** https://www.linkedin.com/in/xuying-li-2a672614b/ Professional in data analytics, RDBMS, web scraping, data visualization, ETL, statistics, and machine learning. Proficient in Python, SQL, R, Tableau, Excel, SPSS, Google Analytics. Good team-player, self-oriented, quick learner, highly focused on detail, highly responsible. EDUCATION

2017-2018 FORDHAM UNIVERSITY, GABELLI SCHOOL OF BUSINESS New York, NY M.S. Business Analytics (STEM), GPA 3.97/4.0

• Relative Courses: Database Management (Oracle &SQL), Web Analytics, Data Mining, Python, Big Data

(Hadoop), Text Analytics, R and Statistics, Artificial Intelligence 2013-2017 UNIVERSITY OF INTERNATIONAL BUSINESS AND ECONOMICS Beijing, CHINA B.S. Economics and Finance, Concentration of Finance

• Relative Courses: MS Excel, Econometrics (Stata), Calculus, Algebra, Stochastic Analysis, Statistics, Numerical Analysis (MATLAB), Game Theory, Financial Engineering, Asset Pricing, Corporate Finance CERTIFICATION

Mar 2019 Beta Gamma Sigma Membership

Feb 2019 Coursera SQL for Data Science - https://www.coursera.org/account/accomplishments/verify/Z89DHAKRMUQ5 Apr 2018 Deloitte March Data Crunch Madness - Second Prize PROFESIONAL SKILL

Data Analytics: Excel Python R SPSS Stata Alteryx PySpark Database Management: SQL MongoDB Oracle APEX

Data Visualization: Tableau QlikView Spotfire

Python-based: NumPy Pandas TensorFlow Beautiful Soup Selenium NLTK Others: Google Analytics Hadoop Text Analysis WIND & Bloomberg Terminal PROFESIONAL EXPERIENCE

Feb-Dec

2018

FORDHAM UNIVERSITY – Graduate Research Assistant New York, NY

• Conducted data analytics on enterprise performance, financial crime, automation and healthcare. Visualized data using Tableau, applied predictive analyses using machine learning

• Worked as teaching assistant for Big Data, Text Analytics course. Instructed Hadoop workshop May-Dec

2018

FORDHAM UNIVERSITY DESIGN LAB, Center of Digital Transformation New York, NY Technical Member

• Freelancer Employer Preference Research: Studied the bias of employer’s preferences due to emotional trust – by pulling 35,000 records of data from freelancing websites and finding how freelancers were hired Feb-May

2018

FORDHAM Design Lab Joint with UN PRESS OFFICE – Data Analyst New York, NY

• Evaluated web quality and user experience of UN news website using Google Analytics. Detected copyright violations based on a million records by applying outlier analysis

• Created visualized managerial reports for UN management team to improve current website Sep-Dec

2016

ACCENTURE (CHINA) CO., LTD – Project Intern Analyst Beijing, CHINA

• Programmed with SQL to extract and clean 5 GB logistics data. Created dashboards to provide insights and predictions with Excel and R

• Developed efficiency evaluation model, proved hypotheses, presented conclusions to clients PROJECT

Feb-Apr

2018

Deloitte March Data Crunch Madness New York, NY

• Predicted the bracket result of 2018 NCCA men’s basketball tournament using data up to 2017.

• Won 2nd Prize out of 27 teams, correctly predicted 80% of the games, 3 out of Final Four.

• Collected additional data sources by crawling paired city and flight time for 1027 games. Predicted game outcomes using logistic regression, SVM and KNN via R and Python. May-Dec

2018

Fashion Advertising in Twitter New York, NY

• Predicted Twitter advertisement popularity by analyzing images.

• Gathered 880 tweet contents by scraping Twitter using Python under Linux environment in virtual machine. Solved webpage infinite scroll issue.

• Applied text analysis and machine learning, extracted image feature vector.

Contact this candidate