Lu Fan Email & Phone Number

Torrance, CA, US

Los Angeles, California, United States

Ithaca, New York, United States

STSCI 5060 - Database Management and SAS High Performance Computing with DBMS

Washington, District Of Columbia, United States

As a business data analyst at ACS, I did lots of data-driven works based on huge data sources from ACS, which include- Created Tableau Dashboards based on existing reports- Detected and fixed data issues occurring in SQL databases through Python- Updated the datasources and improved the performance of an existing prediction machine learning model- Exported.

Wuhan, Hubei, China

1. Collected all data about stock-level characteristics, macroeconomic predictors, and industry dummies of listed companies in the United States from 1970 to 2020 through Wharton research data services (WRDS) 2. Constructed such variables as the ratio of fixed assets to total assets, working capital accruals based on the data gleaned, created a.

Wuhan, Hubei, China

• Performed factor analysis and cluster analysis in R to reclassify the clients for car insurance from five dimensions, including personal traits, social features, behavioral features, etc.
• Utilized R to implement variance analysis and multiple correspondence analysis (MCA) for obtaining clients’ persona so as to identify characteristics of potential customers, involving data standardization, outlier.
• Designed and built the model in R capable of… Show more
• Designed and built the model in R capable of screening false attendance of employees according to their attendance records, which was well-recognized and adopted by the HR Department.
• Summarized, organized, and screened data in the statements, reports, and spreadsheets according to specific needs Show less

Wuhan, Hubei, China

• Utilized Tableau to preprocess a dataset of used car on sale containing 1436 records with details on 38 attributes and screen out variables closely related to price via data visualization, and classified the variables.
• Implemented Analytic Hierarchy Process with Python to reduce dimension of variables in each type, established linear regression model, and calculated correlation between variables and car price, thus identifying three.
• Implemented Analytic Hierarchy Process with Python to reduce dimension of variables in each type, established linear regression model, and calculated correlation between variables and car price, thus identifying three.
• Built a Tableau KPI Dashboard and visualized data to analyze various problems, such as the correlation between the installation of car central lock and car color;
• Attended courses on a range of topics, including data visualization, data mining, and machine learning, and learned to use Pandas, Numpy, and Scipy, Linear and logistics regression, and K-Nearest Neighbors Show less

Master'S Degree, Statistics, 87.0/100 (3.74/4.3)

Activities and Societies: Volleyball

Bachelor Of Science - Bs, Statistics, 88.0/100 (3.78/4.0)

Activities and Societies: Captain, Volleyball Team, Dept. of Math. & Stat., HUST Vice Minister, Welfare Department, Student Union of HUST