SAS/SQL Programmer Remote

********@*******.***

Choi Lai

Experience

**/****-******* ********** ********** at St. Louis, School of Social Work St. Louis,MO

Data Analyst II (Health Communication Research Lab)

• Assist with experimental design and research paper write up

• Provide parametric and non-parametric data analysis

• Extract data with ad-hoc queries and macro

• Produce statistical analysis reports including tables, listing and graphics

• Assist with sample size calculation and power analysis for grants

• Provide GIS (geospatial data analysis) and spatial analysis for epidemiological studies

7/2011-5/2012 Anolinx Bountiful,UT

Consultant SAS Programmer (Telecommute)

• Extract claim data from. Genentech’s Database remotely

• Provide tables, listing and graphics with large dataset - GE, GPRD, and Marketscan (Medicare, Medicaid) - using SAS in Unix

• Write ad-hoc queries, macros, reports for clinical trial data and check data discrepancy

11/2009-5/2011 University of Arkansas for Medical Science, School of Medicine Little Rock,AR

Biostatistician (Psychiatric Research Institute) – onsite & remote

• Write ad-hoc queries, macros and ODS using SAS

• Provide graphics, tables and data support for research teams

• Assist with experimental design and data modelings

10/2008-05/2009 University of Arkansas, School of Education Fayetteville,AR

Graduate Assistant (Office of Research, Measurement and Evaluation)

• Write SAS macros and procedures to extract, transform and load data from a large database system

• Provide data supports to the educational research teams

2007-2008 University of Arkansas, Math & Tutoring Center Fayetteville,AR

Computer Support Specialist I

Provide ad hoc queries, data analysis and reports for the research team in the Math department

Participate academic research and development projects

2005-2007 University of Arkansas, Registrar’s Office Fayetteville,AR

Computer Support Specialist I

Provide data supports and assist with database cleanup

Assist with data dictionary, documentation, and build database

Write VB programs to update the university’s academic calendar

• Help with academic auditing, e.g. course substitution, class schedule report, enrollment report and D-Petition report.

• Provide documentation for programming codes and provide maintenance to email listserves

Maintain data integrity, help with patches and fixes and provide computer supports for the department.

2000-2002 Pang’s IT Consulting

New York,NY

Developer

Develop database using Oracle and Access for small and developing companies

Write, test and debug PLSQL and SQL codes

Develop database modeling architect

Work as liaison between customer and administrative staff

Computer Skills

• Microsoft Access, Excel, Word, PowerPoint

• Statistical tools: SAS, R, STATA, Mplus and SPSS

• Programming skills: SQL, PL/SQL, VBA, C, Java

• Operation Systems: Unix, Microsoft 2000, XP

• Database system: DB2, Oracle, and SAS

• Certified Oracle 8i Administrator

• GIS (geospatial information system) Statistics Skills

• Data imputation and non parametric data analyses

• Categorical data analysis

• Multivariate data analysis

• Simple & Multiple Regression modeling

• Longitudinal data analyses and cluster analyses

• Experimental design

• EFA, CFA, and SEM with mplus

• Survival Analysis

Education

1/2012-present Washington University in St. Louis St. Louis, MO

Certificate in geospatial information system. Expect Fall 2013.

8/2007-12/2009 University of Arkansas, Graduate School of Art and Science Fayetteville, AR

Master in degree of science, GPA: 3.6/4.0, major in Statistics

8/1995-5/1999 Columbia University of NY, School of Engineering and Applied Sciences New York, NY

Bachelor in degree of science, GPA: 3.5/4.0, major in Operations Research with minor in Economics

Publication

Fortney J, Kaufman C, Pollio D, Beals J, Lai C, Edlund C, Novins D. Geographical access and use of biomedical and traditional healing services in two American Indian tribes. (Publication in process).

Hoo J, Kreuter M, Lai C, Fu J. Breast cancer messages and negative emotions. Journal of Communication. 2012.

Kreuter M, Corcoran H, Clarke C, Gardiner G, Gillham S, Casey C, Nelson S, Moy L, Luke D, Lai C, Kaphings K, Fu Q. Increasing voter understanding of evidence-based tobacco control: A transdisciplinary and translational approach that work. (Publication in process).

Caburnay C, Luke D, Cameron G, Cohen E, Fu Q, Lai C, Stemmle J, Paulen M, McDaniels-Jackson L, Kreuter M. Evaluating the Ozioma cancer news service: A community randomized trial in 24 U.S. cities. (Publication in process).

Kreuter M, Eddens K, Alcaraz K, Rath S, Lai C, Caito Nikki, Greer R, Bridges N, Purnell J, Wells A, Fu Q, Walsh C, Eckstein E, Griffith J, Nelson A, Paine C, Aziz T, Roux A. If you refer them, will they call? Use of cancer control referrals by 2-1-1 callers. (Publication in process).

Kim Health Literacy Surveillance. (in process)

Alcaraz K, Lai C. Call volume 2-1-1 (in process)

Contact this candidate