Mengdi Fu

* *** ***** **., ********, IL ac3fne@r.postjobfree.com 312-***-****

EDUCATION SAS Base Certified Programmer

MS Statistics, Miami University, Oxford, September 2014 - May 2017 BS Statistics, Miami University, Oxford, September 2011 - May 2014 BS Management, Dongbei University of Finance and Economics, September 2008 - July 2011 SKILLS

Programming Skills: SAS (9.4 Macro), R (Rstudio), SQL (MySQL), JMP, Microsoft Word, Excel, PowerPoint, SPSS, MATLAB

Specialization: Exploratory Data Analysis, Statistical Inference, Data Visualization (ggplot2, plotly) Language Skills: Fluent in English and Mandarin Chinese SUMMARY

I have spent seven years studying the field of Statistics at both Dongbei University of Finance and Economics and Miami University and I have graduated in May, 2017. I’ve six years’ experience of utilizing SAS and R. In-depth knowledge of SAS programming, data processing, data collection, hypothesis testing, predicting modeling, quantitative and qualitative data analysis. Good programming experience with various SAS procedures, SAS functions, data manipulation and statistical techniques such as PROC SORT, PROC FORMAT, PROC CONTENTS, PROC REG, PROC GLM, PROC LOESS, PROC PRINT, PROC TRANSPOSE DATA STEP, PROC SCORE, PROC FREQ, PROC LOGISTIC, etc. Deep experience on R programming, simulation, utilized R packages such as shiny, tidyverse, tidyr, lubridate, ggplot2, dplyr, stringr, TSA, datasets, tseries, forecast, fGarch, WeightedPortTest, Hmisc, rstan, etc. Ability to handle multiple tasks simultaneously. EXPERIENCE:

Business Analyst, Benxi Iron & Steel America Ltd., July 2017 – present 1. Identifying proactively opportunities to deliver and drive value, by analyzing internal data such as sales history and pricing information, as well as forecasting marketplace and competitor trends. 2. Visualizing the analysis and predictions

3. Tool: SAS, R, Excel

Data Visualization Intern, Information Technology Services, Miami University, Oxford, Ohio, February 2017 - present

1. Designed and programmatically developed rich, interactive graphics, data visualizations of "large" amount of structured data.

2. Designed reports, web-pages, and presented information using clear language, graphs and charts 3. Extracted, transformed, and loaded data using web services and statistical software 4. Gathered and analyzed a broad range of internal and external current and historical data in order to provide information for planning and decision making to management

5. Worked closely with product and process teams to identify and answer important questions 6. Tool: SQL, SAS, R, Microsoft Excel

Shiny App for Flight Delay and Cancellation for Common Carriers in U.S., Miami University, Oxford, Ohio, Fall 2016

1. Developed functions and loops to read in the data files since the raw data was collected and recorded monthly. 2. Programmed a web page based app for users to test the variables of their interests. 3. Selected appropriate visualizations for Delay Reasons, Delay Trends, and Cancellation Trends for airline carriers. 4. Users can select carriers, departure and destination locations, as well as a time range for further interests. 5. Presented our app and provided data reading code for reproducing similar app programming. 6. Tool: R (Shiny App)

Analysis of how Chronic Health Conditions Impact Health Care Choice of the Respondents to BRFSS Survey, Miami University, Oxford, Ohio, Fall 2016

1. Investigated the geographic, demographic and health care related variables in the data set. 2. Analyzed the chronic health conditions and health care choices. Observed that individuals with more chronic health conditions tend to have higher health care coverages. 3. Performed high quality report and advanced plots to potential clients. 4. Tool: SAS, R, Microsoft Excel and PowerPoint

Study of Students’ Retention Rate of Miami University, Miami University, Oxford, Ohio, Fall 2014 1. Conducted data analysis using logistic model for the information of students who enrolled in Miami University in 2012 and 2013, discovered the significant factors to the retention rate. 2. Utilized cross-validation technique to select best model for retention rate by comparing the mean squared errors for each model, used R packages including ggplot2, dplyr, stringr, TSA, datasets, tseries, forecast. 3. Predicted the first-to-second year retention rate by using the best model we chose 4. Produced written report and poster to interpret our analysis processes and outcomes 5. Tool: R, Microsoft Excel

Statistical Consulting Center, Miami University, Oxford, Ohio, September 2013 - May 2015 1. Met with clients, and provided statistical consultation such as analysis, modeling, predicting 2. Implemented survey methodology to increase response rate 3. Additional duties included writing technical reports and making presentations based on survey data (provided by clients)

4. Tool: SAS, R, JMP, SPSS, MATLAB, Tableau, and Microsoft Word, Excel, PowerPoint

Archive Master Grad 1, University Archives, Miami University, September 2015 – April 2016 1. Developed, arranged and described archival collections in accordance with accepted standards and practices 2. Created online finding aids using Archivesspace 3. Advised and assists researchers in the use of archival materials in research activities; interprets requirements and consults on archival information

4. Tool: Archivesspace

LEADERSHIP ACTIVITIES:

Communication Chair of Chinese American Culture Association, Miami University, September 2012 – May 2013 1. Planed traditional holiday activities of China to American students and explained American holidays to Chinese students. 2. Hosted activities for Chinese students and American Students getting to know each other’s cultural histories.