CHENGJIE JIAN
Email: acy5q8@r.postjobfree.com Phone: 806-***-****
Professional Summary:
Certified SAS professional with extensive experience in Data Analysis and Clinical Trials, including data extraction, cleaning, transformation, statistical analysis, updating, testing and validation.
With R programming, Getting and Cleaning Data, Exploratory Data Analysis and Statistical Inference.
Use Minitab, SPSS, Excel (PivotTable, Data Analysis, Formulas & Functions, Charts) and Access for analysis.
Machine Learning: K-means Clustering, Support Vector Machine, AdaBoost, Bayes, Decision Tree, etc.
Expertise in SAS/STAT software to conduct and interpret complex statistical data analysis, including analysis of variance, linear and logistic regression, preparing inputs for predictive models, measuring model performance.
Strong expertise in SAS/Base, SAS/Stat, SAS/Macro, SAS/Graph, SAS/SQL, SAS/ODS in Windows environment; Efficiency in utilizing SAS techniques to minimize processing time and space required while handling large amounts of data from different sources.
Expertise in PROC REPORT, PROC SQL, PROC LOGISTIC, PROC GLM, PROC REG, PROC LIFETEST, PROC PHREG, PROC UNIVARIATE, PROC FREQ, PROC MEANS, PROC TRANSPOSE, PROC RANK, PROC CLUSTER, PROC FORMAT and PROC PRINT.
Performed metadata mapping from source (raw) data to target data (CDISC/SDTM), developed CDISC/SDTM domains, performed QC (quality control) activity on SDTM domains by developing relevant programs, and created Analysis Datasets (CDISC/ADaM) based on SDTM domains.
Experience creating and validating tables, listings, and graphs (TLGs) as well as Case Report Tabulation (CRTs), Integrated Summary of Safety (ISS), and Integrated Summary of Efficacy (ISE) as per Statistical Analysis Plan (SAP).
Identifying data issues and report findings to the appropriate team members, and interacting with other members of Statistical Programming.
EXPERIENCE
SAS Programmer/ Analyst Trainee, Rang Technologies Inc., NJ 11/16 – Current
Provided clinical programming support and validation for clinical trials in phase II-III.
Created and Validated Safety and Efficacy reports for the regulatory submissions.
Prepared Integrated Databases for Safety and Efficacy data.
Performed Oncology specific analysis for Progression Free Survival, Overall Survival and Best Overall Response
Modified existing datasets using Set, Merge, Sort, Update, and conditional statements
Used existing standardized macros to validate safety and efficacy summary datasets
Extensively used Proc Lifetest, Proc Report, Proc Phreg, Proc Means, Proc Frequency and SQL queries to generate Listings, Tables, Reports and Graphs according to requirement specifications
Private Tutor, Self Employed, TX 09/16 – 10/16
Tutoring in Statistics related courses, such as Engineering Statistics, Business Statistics, Calculus I, Calculus II, Calculus III etc.
Tutoring in Math related courses, such as College Algebra, Geometry, Linear Algebra, Differential Equations, Linear Modelling, etc.
Research Analyst, Texas Tech University, TX 08/15 – 08/16
Programming and parameter tuning of Cycle Length Iteration algorithm to detect activations of ECG signal effectively
Conducting Morphology Recurrence Analysis to identify Atrial fibrillation roughly
Identifying Atrial fibrillation further with Clustering and Classification based on Entropy and Feature Extraction of Detected Activations
Using R to measure High Reliability Organizations through Text Manipulation, Clustering for similarity and Topic Modelling, based on unstructured text documents
Risk Modelling and Simulation
Research Analyst, Texas A&M University-Kingsville, TX 06/14 – 07/15
Using Arena, an open-loop simulation model and a closed-loop simulation model for the patrol system of south Texas have been developed
With Minitab, design of experiments is carried out for factorial analysis to figure out the effect of each single factor and interaction between every two factors
Sensitivity analysis is conducted for three main manipulated variables
VBA programming is employed to manipulate the exchange of GIS data between Arena and Excel
Research Assistant, Northeastern University, Shenyang, China 03/13 – 05/14
With Cased-based Reasoning and Case-based Decision Theory, improved purchasing process of raw materials of Baosteel Stainless Steel Co.,Ltd
Simulation modelling of multi-period perishable food markdown pricing based on consumer behavior experiments
Waitress, Pingdingshan Sports Village Business Hotel, Pingdingshan, China 12/12 – 02/13
Take orders and serve food and beverages to patrons at tables in dining establishment
Check with customers to ensure that they are enjoying their meals and try to solve any problems with friendly manner
Communicate with customers to resolve complaints or ensure satisfaction
Shop Assistant, Premises Retail Store, Qinhuangdao, China 06/12 – 08/12
Give information about the features, quality and availability of different wine, alcohol and liquor
Be attentive to customers' needs and help customers find products they are looking for in the shop
Temporary Cashier when needed
Work-shift-intern, Qinhuangdao, China 06/11 – 06/12
Professional Practice in Qinhuangdao Tobacco Machinery CO.LTD
Professional Practice in Qinhuangdao China-Arab chemical fertilizer plant
Metalworking Practice in the factory attached to Yanshan University
Practice and training in Machining and CNC machine operation
TECHNICAL EXPERTISE
SAS Skills
SAS/BASE, SAS/STAT, SAS/MACRO, SAS/SQL, SAS/ACCESS, SAS/GRAPH, SAS/ODS, SAS/SQL, Enterprise guide
Other software
Matlab, R, SPSS, Minitab, Rockwell Arena, ArcGIS, Visio, C (certified), Microsoft office suites
Standards
CDISC, Six Sigma, ISO 9001:2008
Operating Systems
WINDOWS, UNIX, MS-DOS
EDUCATION
M.S.: Industrial Engineering (focus: Statistical Data Analysis) Grad Date: Dec, 2016
Texas Tech University, Lubbock, TX GPA: 3.9
Courses: Pattern Recognition, Image Processing, Principles of Optimization, Numerical Analysis I, Statistical
Multivariate Analysis, Statistical Computing and Simulation, etc.
M.S.: Industrial Engineering (focus: Simulation and Optimization) Grad Date: Aug, 2015
Texas A&M University, Kingsville, TX GPA: 4.0
Courses: Design of Experiment, Computer Simulation, Activity Scheduling, Biostatistics, GIS, Advanced GIS, etc.
B.S.: Industrial Engineering Grad Date: Jun, 2013
Northeastern University (NEU, China) GPA: 87.53/100