Data Analyst

Summary: Master of Science degree in Biostatistics. About two years of experience in healthcare database management and analysis in Rhode Island Hospital. Proficient in using R, SAS, and SQL managing different database and doing statistical analysis. Great communication and time management skills. Ability to translate data results in a manner that may be understood by who do no possess data analysis and reporting expertise. Ability to work both independently and in a team-oriented environment.

Certificates: SAS Certified Base Programmer for SAS 9; R Programming; Collaborative Institutional Training Initiative (CITI) Human Subjects Protection Course; Basic coursed of Society of Actuaries and Securities Qualification Examination

Education:

Sep 2013- May 2015; Brown University; Master of Science in Biostatistics; Expected Graduation Date: May, 2015

Aug 2010-May 2013; University of Science and Technology of China; Master of Science in Statistics

Sep 2006-Jul 2010; University of Science and Technology of China; Bachelor of Science in Mathematics

Selected Courses:Statistical Inference (I,II), Analysis of lifetime data, Practical data analysis, Causal inference/missing data, Statistical/Machine Learning; Data Science; Mathematical Analysis(I,II,III); Linear Algebra(I,II), Probability, Mathematical Statistics; Ordinary Differential Equations, Time Series, Stochastic Model, Bayesian Computation

Experience:

Sep 2013-May 2015; Brown University / Rhode Island Hospital Providence, RI

Clinical Data Analyst

Serve as primary database manager and analyst for multiple clinical studies related to behavioral interventions and screening for substance misuse and HIV, clinical trials of analgesics for acute pain, and observational studies of prescription medication use in older adults. Selected studies and roles have included:

• HIV/AIDS and HIV video testing project

• Low-dose ketamine analgesia adjunct

• Brief intervention for drug misuse in the Emergency Department

Data management and analyses performed:

• Design regression models

• Impute missing data by using statistical methods

• Do sensitivity analysis and causal effect

• Manage clouding database

• Design simulations to examine outcomes

• Report and publish outcomes as a co-author

Publications and Abstracts:

• Low dose ketamine improves pain relief in patients receiving intravenous opioids for acute pain in the emergency department: results of a randomized, double-blind, clinical trial. Beaudoin F, Lin C, Guan W, and Merchant RC.Academic Emergency Medicine. 2014;21(11):1194–1202.

• Variations in recruitment yield, costs, speed and participant diversity across Internet platforms in a global study examining the efficacy of an HIV/AIDS and HIV testing animated and live-action video among English- or Spanish-speaking Internet or social media users.Shao W, Guan W, Clark MA, Liu T, Santelices C, Cortes DE, and Merchant RC. Digital Culture & Education. 2015;7(1), 40-86.

• Does a video improve HIV/AIDS and HIV testing knowledge among a global sample of internet and social media users? Shao W, Merchant RC, Clark MA, Liu T, Guan W, Santelices C, and Cortes DE. [abstract #35819] National Conference on Health Communication, Marketing and Media, Atlanta, GA, August 20, 2014.

Getting in the circle, and out!, Guan W, He Y, The Mathematical Contest in Modeling, Meritorious Winner, Consortium for Mathematics and its Applications, 02/2007

Contact this candidate