SUMMARY

• Over seven plus years of extensive experience in SAS Programming /Analysis on different Platforms - Windows and UNIX, also worked in updating, data extraction, transformation and loading to data warehouse, data analysis, testing, trending, mapping analysis and business driven data validation.
• Experience in Data analysis and Reporting in health care, Insurance and marketing sectors. SAS experience includes detailed knowledge of statistical analysis of insurance, marketing and health care data and in the production of reports, tables, graphs and listing
• Experience in Base SAS 9.3, SAS/Macros, SAS/SQL, SAS/Assist, SAS/Connect, SAS/STAT, SAS/Access, SAS/GRAPH, SAS/ETS, SAS ETL and SAS/ODS.
• Possess excellent skills with PROC SQL, SAS DDE, SAS Arrays, SAS Base procedures, summary procedures and especially Data Step programming and reporting.
• Extraction and creation of data tables using SAS/Access, SAS/SQL from large scale databases.
• Expert in using PROC SQL, PROC REPORT, PROC ACCESS, PROC GPLOT, PROC GCHART, PROC FORMAT, PROC TABULATE, DATA MERGE, SORT to generate ad-hoc and customized reports.
• Extensive experience in SAS/STAT procedures such as PROC REG, PROC GLM, PROC FREQ (Chi-Square), PROC MEANS, and PROC UNIVARIATE.
• Developed and executed PRIDECTIVE MODELS SUCH AS REGRESSION, LOGISTIC REGRESSION, TIME SERIES to forecast quarterly revenue, customer retention /loss and volumes of packages transacted under the various products.
• Knowledge and experience in using SAS Business Intelligence tools such as SAS Enterprise Guide 4.3 and SAS Enterprise Miner.
• Knowledge of probability and statistics for engineering and sciences.
• Knowledge of Factor Analysis, Logistic Regression, K-mean Clustering and Generalized Linear Models
• Experience in modeling linear and non-linear regression and Testing hypotheses and finding confidence intervals for statistical value.
• Experience in maximum likelihood estimation, factorial experiments and designs
• Strong leadership skills with ability to work independently
• SAS Certified Base Programmer for SAS 9.

TECHNICAL SKILLS

SAS programming: SAS/Macros, SAS/SQL, SAS/Assist, SAS/Connect, SAS/STAT, SAS/Access, SAS/GRAPH, SAS/ETS, SAS ETL and SAS/ODS.

Statistical packages: SPSS, SAS, R, Tableau and Minitab.

Database: SAS SQL, Oracle, Hadoop, Spark.

Data Visualisation: SAS, R, Tableau

Statistical Courses: Machine Learning, Regression, ANOVA, Design of Experiments.

PROFESSIONAL EXPERIENCE

Confidential, Foster City, CA

SAS Programmer/Analyst

Responsibilities:

• Creation of SDTM datasets, ADaM datasets using CDISC standards.
• Generated statistical analyses and accompanying Tables, Listings and Figures on regular or Ad-hoc basis based on team requirements.
• Review of Annotated CRF as per CDISC guidelines.
• Knowledge in preparing Integrated Summaries of Efficacy (ISE) and Safety (ISS) reports.
• Created and used standard or customized macros.
• Validate standard programs and macros written by other programmers.
• Worked on annotations as per the Global Standards Tables and Listings requirements.
• Worked on annotating CRF and define.xml.
• Provided descriptive statistics using PROC MEANS, FREQ and UNIVARIATE.
• Produced quality customized reports by using PROC REPORT, PROC TABULATE and PROC SUMMARY.
• Tested and maintained SAS macros to create tables, graphs and listings for inclusion in Clinical study reports and regulatory submission.

Confidential, Sunnyvale, CA

SAS Programmer/Data Analyst

Responsibilities:

• Extensively worked on data analysis and cleansing.
• Developed and maintained SAS programs from different platforms and formats to assist internal and external clients using SAS, SQL, Intranet and Excel.
• Handled ad-hoc requests for business needs and provided high quality and accurate results.
• Developed and produced operational monthly/yearly reports using SAS/ODS, and Excel.
• Coordinated with other departments to extract data from complex sources for reports and analysis.
• Built standard reports for company presentation, provided ad-hoc query and analysis support, and created requirements documents by interacting with customers.
• Implement various statistical techniques to manipulate data (missing data imputation, principle component analysis and sampling) and build predictive models.
• Writing detailed analysis plans and descriptions of analyses and findings for research protocols regulatory reports and clinical manuscripts.
• Conducting meta-analyses and analyses of systematic reviews of medical literature
• Run linear models, Logistic regression, A/B testing, Random Forests, Decision Tree using R, Tableau and SAS for supervised and Unsupervised data.
• Successfully built models to predict of the surgery based on the pre-complications of the patient using the Logistic regression
• Data cleaning using SAS, Statistical analysis by R and reporting using Tableau.
• Worked closely with end-user clients to understand their reporting needs and provided necessary solution.
• Co-ordinated between the business team and off shore team.

Confidential, Hayward, CA

SAS Programmer/Analyst

Responsibilities:

• Provide expertise in project management with a team of data analysts to produce ad hoc analysis and reports that include descriptive statistics, test results, and data visualization
• Provided SAS programming Support and Maintenance to Statistics and Data Management applications.
• Involved in Extracting, Analyzing and Validating educational data from using SAS.
• Provided Support and Assistance to Internal data, Documented data Problems and Resolution.
• Created Ad hoc reports per requests by Statistics and Data Management teams to aid in the analysis or review of data.
• Generated SAS reports in Excel for data analysis.
• Trained new employees in SAS and data analysis.
• Created complex and reusable Macros and extensively used existing macros and Developed SAS Programs for Data Cleaning, Validation, Analysis and Report generation. Tested and debugged existing macros.

Confidential

SAS Programmer/Analyst

Responsibilities:

• Gathered user requirements to develop the business logic and analyzed and designed the packages and database solutions.
• Cleaned data using Data Step and SAS Base procedures.
• Generated tables and listings using Proc Print, Proc Report and Proc Tabulate.
• Generated summary reports and descriptive statistics using Proc Means, Proc Freq and Proc Univariate.
• Assigned formats and labels to the variables in analysis data sets.
• Responsible for data validation and corrections - upload and /or download data.
• Involved in writing codes using BASE SAS and SAS Macros to extract, clean and validate data.