Professional Summary

• Over 9 years' working experience on projects with solid experience in statistical analysis, testing, sampling, predictive modeling, data mining and reporting, Macros, SAS and SQL experience, 5.5 years' experience in R
• SAS certified Base and Advanced Programmer for SAS 9 Certification
• Experience on SAS setup, coding, development, analysis, debugging, implementation and maintenance as a Programmer/Analyst with experience in Windows or UNIX or PC
• Strong Unix scripting using Shell and Unix experience for 6 years
• Finished many statistical reports using SAS, R on Unix or Windows, these projects covered many Statistical analytic areas including Clinical Trials and pharmacy, Business and Finance, Marketing
• Solid Skills on SAS components such as SAS/Base, SQL, Macro, Graph, Stat, ODS, SAS JMP, Report
• Good at extracting data from databases, Excel files using SAS/Base and SAS data steps
• Solid experience on SAS programming for data analysis, especially in data preparation such as cleansing, creating, integrating, sampling, and analyzing data set
• Professional Experience of importing various types of external data files into SAS dataset/SAS library, creating SAS datasets by using SAS/INFILE, SAS/IMPORT and SAS/SQL
• ETL or ELT of Extract, load and transform the data or Extract, clean, transform and load in data warehouses
• Importing/exporting data files using LIBNAME, PROC CDISC, PROC IMPORT/EXPORT, PROC COPY, Data Step programming
• Proficiency in SAS DI Data Integration , checking Data Validation on clinical trial and pharmacy, business and finance data sets with statistical procedures such as proc format, proc freq, proc means, proc univariate and SAS macros
• Used CRFs to generate reports, tables, listings and graphs TLGs using SAS codes
• Created datasets and generated reports using PROC Tabulate, PROC Report, Data Null, SAS arrays, PROC SQL and Macros, either in HTML, PDF or RTF formats according to the client's specifications
• Create graphs in formatted HTML, PDF,RTF reports by using SAS output delivery system ODS
• Using SAS procedures and statistical methods to perform STATISTICAL ANALYSES including COMPARISONS, TESTING such as T-test, F-test, Chi-quare test, signed/-ranked test , M/ANOVA, GLM, REGRESSION, BAYESIAN, UNIVARIATE/ MULTIVARIATE including Discriminant, Principal Component, Person Correlation, Factor, Cluster , SURVIVAL and LONGITUDINAL data, MCMC, Monte Carlo simulation
• Quantitative techniques such as graph, mean, sum, sample mean, median, range, variance, stdv, skewness, kurtosis, using these methods on random variables and standard/normal variables about discrete variable or continuous variables
• Using SAS to perform the predictive modeling, select the fitted model and check its Goodness of Fit
• Predictive Modeling including Risk Modeling, Linear, Logistic, Mixed, GLM, Nonlinear, Generalized Gamma, Time Series forecasting, Modeling Comparisons and Diagnostics and selection, Variable Selection
• SAS procedures including proc sql, sort, transpose, print, import, export, gchart, gplot, tabulate, report, summary, means, freg, univariate, transreg, reg, glm, anova, lifereg, lifetest, genmod, mcmc, phreg, logistic, catmod, nlin, mixed, probit, insight, factor, cluster, arima, autoreg, timeseries, SAS macros, etc
• Solid JMP knowledge of better modeling, exploring predictive analysis, statistical analyses
• Strong Database skills in Pharma and Financial domain

Technical Skills:

SAS 9, R, SAS JMP, SPSS, SQL, Oracle, Windows/PC/UNIX, Unix shell scripting, Microsoft Office Word, Excel, PPT , Notepad, Macro, DB2, Oracle Clinical Database, MS Access Database, MS SQL Database

Professional Experience

Confidential

Senior SAS Programmer/Analyst

Responsibilities:

• Collected data of commercial drugs from multiple sources such as Phase I to IV clinical trials studies or other statistical programmers to facilitate building a database, then analyzed them
• Cleansed datasets from different sources, handled their errors, and prepared them to use in SAS codes such as proc freq, data null , proc format user defined format , proc means, proc tabulate, proc univariate
• Checked the data validation using proc format or macros
• Imported datasets from Excel and flat files, created SAS datasets, put them into SAS libraries
• Produced analysis files such as customized reports, Tables, Listings and Graphs TLG using SAS data steps data null , proc report, SAS macros , proc compare, proc freq, proc tabulate, proc gplot, SAS/Graph according to the guidelines and specifications of the clients
• Created HTML, PDF and RTF reports using SAS ODS
• Contributed to integration of data across marketing research and clinical trials data.
• Work also involved some Business Analysis, and gathered Business Requirements from company management, R D, clinical and quality assurance, research associates, sales and marketing managers
• On this project I reviewed Statistical Analysis Plan SAP , Standard Operating Procedures SOP guidelines
• Experience in providing tables, figures, graphs for the Clinical Study Report along with patient data listings and technical statistical result details such as derivations, computations, statistical analyses
• Rich experience in CDISC, STDM, ADaM, ICH/FDA Guidelines, Phase I-IV

Environment: Windows, UNIX shell scripting , SAS BASE, MACRO, GRAPH, STAT, SQL, ODS, MS SQL, MS Access/Excel, Oracle

Confidential

SAS Programmer/Analyst

Responsibilities

• Collected data of treatments from multiple sources including Phase I-III clinical trials studies or other statistical programmers to facilitate building a database
• Extracting the data from various internal and external databases Oracle, Excel using SAS/ACCESS, SAS/CONNECT, SAS/SQL
• Cleansed datasets from different sources, handled their errors, and prepared them to use in SAS codes such as proc freq, data null , proc SQL, proc format user defined format , proc means, proc tabulate, proc univariate used Proc Sort with nodupkeys and noduprecs options to remove the duplicate records
• Checked the data validation using proc format or macros
• Generated the datasets and TLGs for Phase I-II of clinical trials using proc compare, proc freq, proc tabulate, proc gplot and SAS/Graph Network Visualization Workshop, created the Statistical reports using Proc Report, Data null and SAS Macro
• Extensively used Proc Sort, Proc Freq, Proc Means, Proc Summary and Proc Univariate to perform data descriptive analysis
• Used proc print, proc genmod to analyze the dataset for the respiratory illness, performed the statistical analysis to assess the effect of each drug
• Developed the SAS Macros for data analysis of clinical data
• Attended technical meetings daily meetings, and worked closely with other team members to discuss and understand the issue, collect the data, analyze the data to find the critical causes
• Rich experience in CDISC, STDM, ADaM, and ICH/FDA Guidelines, , Phase I-IV, ISS
• Rich knowledge and experience of SOP, CRO, CRF, Payer Health Cares

Environment: SAS/BASE, STAT, SQL, GRAPH, MACRO, ODS, Oracle, SQL Server, Access, Windows, Unix

Confidential

SAS Programmer/Analyst

Responsibilities:

• Withdraw the raw dataset from databases, using cleansing, editing, sorting, merging, validating techniques to get the required datasets by data steps options, proc SQL
• Used SAS/BASE and SAS/SQL to extract data from Excel files, Oracle Databases, CSV, imported these external data files into SAS Datasets, SAS/libraries
• Integrated these datasets from different sources for further statistical analysis and reporting
• Produced customized reports by using proc tabulate, proc report, and proc summary
• Outputted SAS reports and SAS outputs in the RTF, PDF and HTML formats using ODS
• Performed data analysis, statistical analysis, generated reports, tables, graphs using data null and put statements, proc sort, SAS/BASE,MACRO,GRAPH,SQL,STAT
• Performed descriptive statistics using proc print, proc means/median, proc freq, and proc univariate Simple/multiple linear regression modeling using proc reg, proc gplot, proc corr,proc ttest, proc glm, proc plot, proc rank Time Series forecasting using proc timeseries, proc arima, proc autoreg, proc sgplot Marketing Research using proc nlin, proc phreg, proc transreg, proc cluster, proc factor, proc logistic, Macro
• Developed new macros using SAS/Macro as per the customer's requirements.
• Find top customers from the target lists based on sales effort
• Produced SAS Graphical reports and charts showing Trend Analysis

Environment: R, SAS/BASE, STAT, MACRO, GRAPH, ODS, SQL,DB2, MS Access/Excel, Unix, Unix shell scripting, Windows, PC, Database Warehouse

Confidential

SAS Programmer

Responsibilities:

• Used SAS extensively for merging, cleansing, data validation, and data correction
• Performed proc import/export procedures to import/export external excel files into SAS.
• Utilized data step options like KEEP, DROP, and RENAME to edit the stored data and variables
• Data set options DSD, DLD, Truncover, Missover, If, Where etc were used in reading raw data files
• Developed and designed different SAS programs and SAS macros to analyze financial data
• Do loop iteration in data step using Do-End statement
• Produced various reports like summary reports, tabular reports as per business requirements using proc report, proc tabulate, data null , proc summary, proc means, proc freq
• Extensively used procedures like proc sort, proc print, proc plot, gplot
• Handled large raw data file using FIRSTOBS, OBS, N options etc
• Programmed SAS codes to perform linear, nonlinear, logistic regression modelings, Utilized R codes to generate time series forecasting model to predict the monthly foreign exchange reserves for further investment decisions

Environment: SAS/Base, Macro, SQL, Graph, Stat, MS SQL Server,DB2, MS-Excel, and Windows, Unix, PC

Confidential

SAS Clinical Data Analyst

Responsibilities:

• Reviewed and understood the clinical protocols, SAPs and CRFs correctly
• Evaluated existing data collection systems, recommend experimental design methods for data collection, analysis, and reporting on new projects
• Wrote code using SAS/SQL, SAS/BASE to extract data from MS Excel file, Oracle Databases, prepared them for statistical analysis
• Extracted useful data from Oracle databases using SQL, demonstrated the data to clients Cleansed, managed, merged, edited raw data
• Create SAS output report to RTF, PDF and HTML format using Output Delivery System ODS .
• Produced customized reports by using proc tabulate, proc report, proc summary, provided descriptive statistics using proc means, proc freq, proc summary, proc univariate
• Involved in Phase I-IV clinical trials by providing required TLGs
• Conducted statistical analysis using SAS/STAT e.g. Proc glm, mixed, reg, freq, logistic, lifetest, ttest, rank
• Hypothesis testings: T-tests, Chi-square test, F-test, ANOVA, Wilcoxon Signed-Rank test, Fisher's Exact test, McNemar's test, non-parametric tests like Log-rank test, Signed-rank test, Rank-sum test , Cochran-Mantel-Haenszel test, linear regression, logistic regression
• Constructed the daily weekly and monthly schedules of data analysis, followed these schedules timely
• Rich experience in CDISC, STDM, ADaM, and ICH/FDA Guidelines, Phrase I-IV

Environment: Windows, Unix, SAS/BASE, MACRO, GRAPH, STAT, SQL, ODS,DB2, MS Excel, MS SQL Database