Sas Programmer / System Analyst Resume
2.00/5 (Submit Your Rating)
Summary:
- 12+ years of experience in design, analysis, coding, implementation, maintenance and support as a SAS Programmer/Analyst with profound experience in Pharmaceutical and Clinical industries.
- Strong experience of SAS Base, SAS Macros, SAS SQL, SAS Stat, SAS Graph, SAS Access, SAS ODS. Good skills in applying SAS Proc, such as Tabulate, Freq, GLM, Means, Freq, etc.
- Excellent knowledge and experience in creating analysis clinical trials datasets like demographic data (DM), Adverse Events (AE), laboratory data (LB), Vital Signs (VS) and Pharmacokinetic / Pharmacodynamic (PK/PD) data.
- Good at creating NONMEM datasets for statisticians for PK modeling and generating PK plasma concentration time course plots for estimating PK parameters.
- Good programming skills with Oracle PL/SQL in creating functions, procedures, and packages to store in database. Good at creating triggers on the tables for new data loading or inserting. Creating tables, sequences, PK/FK keys on tables were part of my routine jobs when worked in Ostuka American Pharmaceutical Inc.
- Good at using Unix or Unix like operating system with C shell or K shell and writing scripts to execute commands.
- Experience in ETL with using SAS ETL studio.
- Good experiences in complementing rules in CDISC and good at converting legacy data sets to SDTM data sets to follow requirement by the FDA.
- SAS/MACROS: Extensive experience with SAS products including SAS/MACROS
- SAS/ACCESS: Able to use this SAS interface for data communication between SAS & Oracle database.
- SAS/SQL: Efficiently create Oracle tables with SAS/SQL coding skills on data created through SAS data steps or from exiting datasets.
- SAS/GRAPH: Efficient in using SAS/Graph to generate many types of graphs such as chart, maps, three dimensional graph, and Contour plot.
- SAS/BASE: Proficient in producing the customized tables, files or plots for clinical reports by applying Proc Univariate, Proc Freq, Proc Report or Data NULL, etc.
- Sufficient experience in Data Management: include cleaning the data and data QC.
- Extensive experience with Data Pre - processing and dataset preparation for particular statistical analysis, including data cleansing, validation, data integration, data transformation, etc.
PROFESSIONAL EXPERIENCE
Confidential
SAS Programmer / System Analyst
Responsibilities:
- Working on data collected by the US Census from those industrial cooperates in the America, testing SAS code from those created in StEPS I and moving them to StEPS II and then loading those SAS data sets to Oracle Tables. SAS macros were intensively used for all those processes to make the whole process text driven and beat the complexity in the data themselves. SAS coding was done with the latest version of SAS EG set in Linux with version control (SVN).
Confidential
SAS Statistical Analyst / Programmer
Responsibilities:
- Drug development and clinical trials for passing Phase II and III required by the FDA.
- Major responsibilities included (but mot limited to) writing SAS code for PK/PD analysis for drugs developed for curing diseases cause by genetic defects in blood cells compositions; data mining and cleaning, preparing data sets for statistical analysis and plotting data sets for examining PK profiles.
Confidential
PL/SQL Programmer / Analyst
Responsibilities:
- Data are stored in files with standard layouts and needed to load into Oracle tables in Staging database through control files and SQL Loader. After loading into Staging tables, join the tables in Staging and select data from those tables based on business rules to get data for Siebel EIM tables (a type of Interface table). Then run EIM process in Siebel to ship the data in EIM table into Siebel base tables.
Confidential
SAS Programmer / Analyst (contractor)
Responsibilities:
- Strong macro skills were needed for dealing with parallel treatments on dozens of datasets for the same piece of information such ethnic group and education received.