FLORA FAN
202-***-**** **********@***.***
****S Eads St, Arlington, VA22202, USA http://linkedin.com/in/xiang-fan-49236b1a0 EDUCATION
THE GEORGE WASHINGTON UNIVERSITY, School of Business Washington, DC Master of Science, Business Analytics December 2020 Course taken: programming, statistics for analytics, Data management for analytics, Data mining, Time series forecasting, consulting of analysis, working with big dataset, machine learning THE JILIN UNIVERSITY, School of Economics Jilin, China Bachelor of Economics, International Economics and Trade June 2019 Course taken: Intermediate Microeconomics, Intermediate Macroeconomics, International Economics, Accounting, Probability and Statistics, Linear Algebra, Statistics, Fundamentals of University Computer RELEVANT PROJECTS
Analyze the data for UFO sighting in the Unites State Washington, DC Individual project about creating a website (using R) October 2019
Wrote code to display its distribution on map, and further, analyze UFO dataset utilizing table and plot charts using shiny of R. Thus, formed a website-style app, on which users can click and select. Link: https://flora2347.shinyapps.io/individualproject/ Shopify app store analysis Washington, DC
Group project (using AWS and SQL language) November 2019-December 2019
Project`s purpose is to analyze relationships between rating level and time, price plan. review count using the SQL code of python. As a leader, decided the general direction of analysis data set and wrangling the data. Utilized SQL to assess relationship between the rate level and review count (using contents of DML and DDL, select *) Business analysis for Gyrfalcon Agricultural Analytics Platform Washington, DC January 2020-March 2020
Analyzed how to implement technology for Gyrfalcon Ventures company in order to create the most profit in the short term and give recommendations for Gyrfalcon Ventures. Used Problem Definition Summary to identify key question and goal. Provided company question tree and task Inventory to help CEO decide and plan Titanic Machine Learning from Disaster Washington, DC May 2020-June 2020
This is a competition on Kaggle. Using known passenger's features to establish predictive model to predict what types of passenger have higher possibility of survival. Reveal the decision-making process and casualty, interpret to both non- technical consumer and highly skilled data scientist, avoid disparate treatment and disparate impact. Model used: Logistic Regression from GLM, xgboost, random forest, Monotonic GBM, Elastic Net GLM. This project is ranked top 16% for Kaggle titanic competition. Link: https://github.com/flora0710/Machine-learning-project-titanic EXPERIENCE
China Everbright Bank Investment Advisor Intern Harbin, China Fortune Global 500 company, an important bank of China January 2018-March 2018
Responsible for Know-Your-Clients (KYC) process for new customers. Made asset assessment and risk analysis for clients. Handled ad-hoc requests and research for team. Won ‘Outstanding Internship Award’ and best Teamwork Award Zigbee Algorithm-based ITS Design Project Changchun, China Internet + College Students' innovation and Entrepreneurship Competition April 2018-July 2018
Responsible for financial planning and budgeting for the whole project and market prospect analysis. Performed data cleansing, analysis, and feature engineering with MATLAB and SPSS. Developed a model based on these features to improve the pricing strategy of the product. Won the 1st place prize as a team ADDITIONAL INFORMATION
Technical Summary : R, Python, MySQL, AWS (S3, EC2,EMR) SQL, SAS, Tableau, Hadoop Leadership: Secretariat of Secretary of the student union, leader of Enactus (SIFE)