Lu Fan Email & Phone Number

Torrance, Ca, Us

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 and complied data sets for analysis in suitable formats- Performed data analysis and visualization based on requests… Show more 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 and complied data sets for analysis in suitable formats- Performed data analysis and visualization based on requests from stakeholders- Prepared reports on findings using necessary text, charts and graphics- Presented findings to inform and influence organizational priorities. Show less

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 comprehensive dataset containing 92 variables and their descriptive statistics (minimum/maximum/mean values, etc.), and performed data… Show more 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 comprehensive dataset containing 92 variables and their descriptive statistics (minimum/maximum/mean values, etc.), and performed data standardization using R and SQL3. Proposed using Weibull function to estimate listed companies’ probability of being acquired and successfully built the quantitative model under conditional probability4. Implemented multiple machine learning techniques for regression analysis in R, including simple linear regression, LASSO, Partial Least Squares Regression, Variable Subsample Aggregation, Random Forest, GBRT, and Neural Network, to evaluate the impact of various factors on the probability of acquisition for listed companies Show less

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 removal, and dimension reduction• Designed and built the model in R capable of… Show more • 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 removal, and dimension reduction• 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 into five types;• 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 most influential variables on car… Show more • 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 into five types;• 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 most influential variables on car price;• 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