JIA (JACKIE) LIU
2029 E Henrietta Rd Apt 6
585-354-4831 (mobile)
Rochester, NY 14623
jl0756@yahoo.com
_________________________________________________________________________________________
5-year experience in data management and analysis in CRO industry and state government;
SAS certified advanced programming skills and proficiency in SQL, Access, Excel, SPSS,GIS;
Proven skills in data interpretation and research model construction;
Committed team spirit and professional communication and presentation skills.
_________________________________________________________________________________________
EXPERIENCE
Howard M. Proskin & Associates Inc., Rochester, NY
Clinical SAS Programmer 10/05-present
Fully integrated team member of three FDA submission projects (two Phase 3 trials and one
Phase 4 trial) and primary programmer for one dental care study for two Fortune 500 companies:
(1) Read data from disparate sources into SAS with DATA steps, Proc Datasets, and Proc SQL;
validate datasets with Proc Compare; maintain datasets with DATA/Update and Proc SQL;
(2) Review clinical trial protocols, statistical analysis plans (SAP), annotated case report
forms (CRF), and edit check specifications for all assigned studies;
(3) Assist in the development and review of in-house monitoring and study status reports;
(4) Create SAS datasets, and create clinical study report (CSR) materials consisting of tables,
figures, and listings (TFL)with Macros, Data Null, SAS Arrays, DO Loops, Proc Transpose,
Proc SQL, Proc Report, Proc Tabulate, Proc Graph, SAS/ODS, and SAS/STAT.
Bureau of Justice Research & Innovation, NYSDCJS, Albany, NY
Data Analyst Consultant 05/03- 09/05
Important member in three large Federal projects and principal member for one large Federal project:
(1) Assisted in research design, conducted literature review, participated in the design and development
of the statistical analysis plans (SAP) and the construction of study surveys, and annotated study
survey forms;
(2) Collected, extracted and transformed data from multiple sources of Oracle, Access, SPSS, and
Census Data, and read them into SAS;
(3) Cleaned data by programmatic and manual checks, analyzed data with SAS/STAT, generated statistical
reports in Excel, and wrote summary reports in Microsoft Publisher;
(4) Presented New York State Elder Abuse research paper on the 2004 American Association of Criminology
conference in Nashville, TN;
(5) Initiated, designed and developed the Commissioner-approved electronic training modules on
Domestic Incident Report for New York State police departments with Macromedia Captivate.
Office of Justice Systems Analysis, NYSDCJS, Albany, NY
Technical Consultant and Data Analyst 10/00-05/03
(1) Participated in the construction of New York State youth courts dataset and conducted data
management and analysis with Access, Excel, and SPSS;
(2) Initiated, designed and developed highly effective on-line Help Screen for the TEAMYC software;
(3) Provided technical support to over 500 youth court clients nationwide and troubleshot problems
regarding the TEAMYC software;
(4) Provided on-line training and workshops to over 500 youth court clients.
_________________________________________________________________________________________
EDUCATION
Master of Arts, Criminal Justice/Criminal Statistics, State University of New York at Albany, 2002
Bachelor of Law, International Business Law, Dean’s List, University of Politics and Law of China, 1998
CERTIFICATION
SAS Base Programming (87%), 2005
SAS Advanced Programming (70%), 2005
STATISTICAL KNOWLEDGE & ATTRIBUTES
Linear Regression, Logistic Regression, Categorical Data Analysis, Time Series;
Experiment Design, Structural Equation Model, and Clinical Trial Modeling;
Field/Client Issue-Oriented;
Detail-Oriented and Innovative Statistical Modeler.
PPOFESSIONAL TRAINING
Introduction to SAS, 05/2001, University at Albany
Introduction to SQL, 04/2003, New York State DCJS
Structural Equation Model with SAS, 11/2004, University at Albany
SAS Programming I, 05/2005, SAS Institute, Inc.
SAS Programming II, 05/2005, SAS Institute, Inc.
SAS Programming III, 09/2005, SAS Institute, Inc.
SAS Macro, 08/2005, SAS Institute, Inc.
SAS SQL, 08/2005, SAS Institute, Inc.
PROFESSIONAL AFFILIATION
GVSUG (Genesee Valley SAS Users Group)
HASUG (The Hartford Area SAS Users Group)
COMPUTER SKILLS
Languages: SAS, SQL, VB, HTML
Statistics Tools: SAS (Base, Access, Macro, Stat, SQL), SPSS, Excel, ArcView
Database: Access, Oracle, ArcGIS,
Packages: Office 2003, RoboDemo, Macromedia Captivate, Dreamweaver
|
