RANRAN (RACHEL) GUO

** ***** ******, ******* ***, New York, New York 10032 484-***-**** ac4t7a@r.postjobfree.com EDUCATION

COLUMBIA UNIVERSITY, NEW YORK, NY May 2018

Master of Science, Biostatistics

• Relevant Courses: Statistical Inference, Randomized Clinical Trials, Linear Regression Models, Epidemiology, Probability, Data Mining, Statistical Computing with SAS CHINA UNIVERSITY OF GEOSCIENCES, BEIJING, CHINA June 2016 Bachelor of Engineering, Civil Engineering

Merit Student, First Prize Scholarship (2012 - 2015) EXPERIENCE

COLUMBIA UNIVERSITY, Data Analyst, New York, NY August 2017 – Present

• Created reusable SAS Macros and developed SAS Programs for data cleaning, validation, analysis and report generation for early childhood primary school intervention analysis

• Applied multivariate band depth on functional data and imaging statistics using R and developed new method to classify and identify outliers

TKL RESEARCH, Statistical Programmer, New York, NY September 2017 – December 2017

• Designed tables, listings and figures for statistical reporting

• Developed, tested and maintained SAS program code to perform statistical analysis and generate analysis datasets and statistical reports of clinical data

• Performed statistical QC review of source code and output developed by other staff biostatisticians for statistical reports and communicated data issues to data management staff UNITED NATIONS CHILDREN’S FUND, Intern, New York, NY June 2017 – September 2017

• Constructed data visualization figures and tables to deliver analysis results during presentation

• Performed background research for two studies and maintained documents and 13794 expenditure records in a user- friendly manner.

• Supported communication between 2 sections and 10 country offices as well organizational activities

• Created draft report of gender expenditure analysis for 7 regional offices and 28 country offices to improve the method of capturing gender expenditure, providing immediate follow-up actions as well as managing the long-term actions needed to ensure the expenditure is accurate in the new strategic plan CHINA UNIVERSITY OF GEOSCIENCES, Research Assistant, Beijing, China April 2015 – May 2016

• Executed fractographic examination and mechanical testing on the new construction material

• Utilized the Origin program and Excel to improve data collection strategy and analyzed 420 recorded data

• Developed a mathematical model revealing the influence of contents percentage on the damage characteristics and mechanical behavior of the new construction material DREXEL UNIVERSITY, Research Intern, Philadelphia, PA May 2015 – July 2015

• Collaborated with research scientists on design and analysis of a case-controlled study on 117 baseball athletes’ pitch performance compared with 3894 age-matched controls

• Cleaned raw data, carried out descriptive statistics, implemented univariate and multivariate, assessed model reliability and validity using R

• Visualized analysis results and presented to other research scientists weekly VOLUNTEER LEADERSHIP

BEIJING FOUNDATI O N OF DISAB L E D PER S O N S, Beijing, China September 2012 – March 2015

• Conducted a caring group for 28 disabled children between age 10- 18 in the Haidian and Xicheng Districts

• Tutored a child with Down’ s syndrome bi- weekly in basic living skills which resulted in significant improvement of the child’s quality of life and psychological state SKILLS

Computer: Proficient with MS Office, (Word, Excel, PowerPoint and Access) Statistical Programs: R, SAS (Certified Advanced Programmer for SAS®9), Stata, SPSS, MySQL Languages: English/Chinese

Contact this candidate