SUMMARY

• Certified SAS Programmer, more than 7yrs of experience in working with SAS and SAS tools in Analysis, Design, Development, Testing and Implementation projects of both clinical and Financial Industries.
• Experience with SAS/BASE, SAS/Macros, SAS/ODS, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/ Confidential and SAS/CONNECT.
• Worked as quality control programmer to validate SAS programs that produce analysis datasets and analyses specified in the Statistical Analysis Plan
• Developed and modified advanced SAS macros to produce standardized tables, listings and graphical summaries.
• Performed daily tasks associated with clinical programming and subsequent analysis to ensure sponsor deliverables are created per agreed timelines and to high quality standards.
• Extensively used procedures like PROC SQL, PROC FREQ, PROC MEAN, PROC SORT, PROC COMPARE, and PROC PRINT for the data validation.
• Experience in DATA summarization and creating monthly Audit and production reports of System resource (user system CPU time, elapsed time total time, memory usage statistics etc.)utilization by Using Proc SQL, SAS procedure like Proc mean, Proc tabulate, proc freq Proc sort, Proc report and ODS statements. Also enhance the code for the automatic report generation.
• Read data from Excel and Oracle into SAS.
• Good knowledge of data structures, data management principles & Retail Market study Familiar experience with Data Ware Housing concepts Data Validation¸ Data Cleansing, Data Modeling/Analysis and¸ Report generations
• Good knowledge about CDISC standards SDTM, ADAM, ODM Standards.
• Experience with complete new Drug & Device release process from IND submission to FDA approval, in compliance with 21CFR Part 11.

TECHNICAL SKILLS

Technical Tools: SAS System (v.6, 8 & 8.2, 9.1.3, 9.2) Base SASSAS/SQL, SAS/MACROS, SAS/STAT, SAS/GRAPH, SAS/ Confidential, SAS/CONNECT, SAS/ODS, Enterprise Guide, SAS/ETL, SAS/BI,HP Quality Center (v10.0).

RDBMS: Oracle, DB2, Netezza, SQL server 2000, MS Confidential, and Ms Excel.

Web Technologies: HTML

Application Package: MS Office, Power Point, EXCEL.

Operating System: UNIX, Windows NT/98/95 and XP.

PROFESSIONAL EXPERIENCE

Confidential, Bellevue, WA

Sr SAS Programmer

Responsibilities:

• Reading Data from different file source into SAS using SAS inputs like Libname, Proc import and SQL - Pass through facility.
• Collaborated with client team and business user analyzing business requirement and developed SAS program specifications as per the report analysis plan.
• By using SAS Estimated probability of risk and benefits ofmethods Alpha and Multi-Greek Letter (MGL) are widely used for development and modeling of common cause failure group basic events.
• Assisted technical team by providing various Reports including SAS application programs for the data validation, data analysis and data reporting.
• Created statistical reports to determine safety, reliability, longevity and efficiency of Microsoft products, Probabilistic Risk Assessment and Deterministic Reliability Analysis of the primary and secondary systems along with the mitigating systems.
• Compare and contrast of new method with existing methods which one is more efficient analysis for estimation of common cause of failures (CCF) modes of multi-train components.
• Extensively used BASE/SAS,SAS, SAS/STAT, SAS macros SAS/ODS and PL/SQL, for the reports generation and validation of final reports before submission
• Tested and documented each SAS application program and then reported. Also extensively used Excel and created various types of Pivot tables, Charts and Graphs for the report purpose.

Confidential, AZ

SAS Consultant

Responsibilities:

• Prepared SAS programs for the Extraction, processing and validation of the SAS data(card member, Merchant, Industries..etc), also provided ad hoc reports to the Business team.
• Extensively used procedures like PROC SQL, PROC FREQ, PROC MEAN, PROC SORT, PROC COMPARE, and PROC PRINT for the data validation.
• Experience in DATA summarization and creating monthly Audit and production reports for memory usage raw data Using Proc SQL, SAS procedure like Proc mean, Proc tabulate, proc freq Proc sort, Proc report and ODS statements. Also enhance the code for the automatic report generation.
• As part of RAMP team Conducted UAT on different SAS automation application products such as RUN parallel, Grid macro Queue, automated stored procedure Model scores etc.
• Generated Excel files and created Pivotal tables and graphs and charts for creating Reports.
• Involved in Meta data request, in order to register the table into metadata and check the table status as per the user request type.
• Generated customized reports using SAS macro facility, PROC SQL & Data Null techniques.
• Involved in code optimization as per the Business user request modified and created new code templates to enhance system performance.
• Maintained and prepared project documentation, testing and validation/quality control documents and programs in compliance with standards.
• Involved in data validation when data is mapped into SAS data from different data source by using different SAS procedure like proc sort proc freq, proc compare etc.
• As per the Business requirements and functional specification created test plan and test cases for the UAT in different SAS application, also involved in post implementation validation.

Confidential, San Francisco, CA

SAS programmer

Responsibilities:

• Worked as quality control programmer to validate SAS programs that produce analysis datasets and analyses specified in the Statistical Analysis Plan
• Performed daily tasks associated with clinical programming and subsequent analysis to ensure sponsor deliverables are created per agreed timelines and to high quality standards.
• Wrote SAS programs that adhere to SOPs, guidelines, and specifications
• Validated programs to ensure that SAS program output matches the requirements of the Statistical Analysis Plan
• Written programs to execute analyses specified in the Statistical Analysis Plan (SAP) or Report and Analysis Plan (RAP) under the guidance of the project statistician
• Take instructions and perform tasks as necessary as directed by reporting manager
• Worked with other team members to ensure outputs are correct and complete
• Analyzed information and evaluate results to choose the best solution and solve problems
• Performed programming in support of sponsor ad hoc requests
• Produced special reports to comply with regulatory requests
• Interacted directly with sponsors to facilitate project completion

Confidential, Dallas, Texas

SAS programmer

Responsibilities:

• Read data from Excel and Oracle into SAS.
• Developed and modified advanced SAS macros to produce standardized tables and graphical summaries.
• Prepared, processed and analyzed clinical data required for analysis of clinical trials for Phase II and Phase III studies.
• Generated Analysis datasets and developed Tables, Listings and Graphs for clinical studies.
• Performed statistical analysis and data management on study data by utilizing appropriate statistical methods such as regression, ANOVA etc., using SAS.
• Conducted various Programmed Edit Checks in SAS to avoid invalid or missing data.
• Prepared derived &modified variables for the analysis datasets from existing data sets using different SAS functions, data and proc steps like set merge, DATA null, IF,IF then ELSE, Where, Proc sort Proc Format, Proc Life test. Etc.
• Generated various tabular summary reports, listings and Survival graphs using Kaplan-Meier method for different populations to summarize the results of the clinical trials
• Performed Quality control checks on programs to ensure that output meets quality standards and project requirements, documented and communicated the findings in that Process.
• Extensively used of the procedures like UNIVARIATE, SUMMARY, MEANS, FREQ, TABULATE, REPORT, CONTENTS, SORT, PRINT, REG, GLM, SQL, GPLOT and GCHART for statistical and data analysis.
• Used SAS ODS to create various HTML, RTF and PDF output destination files.

Confidential, Cambridge MA

SAS programmer

Responsibilities:

• Responsible for enabling connection between SAS and other RDBMS like Oracle and MS SQL Server using SAS/Connect.
• Experienced using PROC SQL for data summarization merging data creating summary table.
• Experienced in writing SAS code using SAS/Base, SAS/Macros and SAS/SQL.
• Enabled a single point of processing for multiple input formats and provided a more consistent method for editing raw data.
• Experienced in management of missing data and used sort and merge techniques for getting required output.
• Experienced in create new macro or using existing macros for safety data analysis of clinical trials.
• Created Reports using analyses output and export them to the web to enable the customers to have Confidential through Internet.
• Experienced in analysis of clinical trial data phase I-III and created CRT for patients listing.
• Experienced in error trapping and validation by using conditional statements like put and debug statements for safety analysis.
• Validated the clinical trial data before used for final analysis for safety and efficacy from other programmer data.
• Collaborated with senior Bio-statisticians and clinical data managers to provide SAS programming for analyzing the data, generating reports, tables, listings and graphs.
• Survivor analysis for generating reports, used PROC LIFE Test, PROC G Plot and PROC Phlegm (Kaplan-Meyer curve)
• Used SAS/Macros for coding analysis listing summary reports.
• Compared SAS datasets and data variable contents using PROC COMPARE.
• Experienced in using output data statements to create HTML, RTF, PDF table listing and graphs.
• Assisted in the design and management of data sets used in different clinical trials.

Confidential, Kalamazoo, MI

SAS programmer

Responsibilities:

• Developed new or modified existing SAS Macros for report generation using as per the Report requirements.
• Experienced in development and enhancement of SAS Programs Annotated CRF’s and programmed Edit Checks.
• Experienced in development of standardized reports and customized ad-hoc reports using Data Null technique and Proc Report procedures.
• Involved in Data Extraction, Validation, Data analysis and report generation using various SAS procedures like PROC UNIVARIATE, TABULATE, FREQ, TRANSPOSE, REPORT etc.
• Experienced in development generalized utility macros to automate programs for standard reports and validation.
• Worked in using multiple linear regression modeling procedures like PROC TRANSPOSE, PROC UNIVARIATE, PROC ANOVA and PROC GLM.
• Extensively used SAS procedures in generating tables, listings and graphs for clinical study reports
• Used extensive SAS/BASE, SAS/CONNECT, SAS/ODS, SAS/STAT, SAS/GRAPH, SAS/ Confidential, SAS/MACROS and UNIX shell scripting for programming