Sas Programmer/analyst Resume
San Antonio, TX
SUMMARY
- Certified Master SAS Programmer with over 6+ years of experience in working with SAS and SAS tools with emphasis on analysis, design, development, testing and implementation of various projects for Pharmaceutical Industry.
- Experience in extraction of data, edit checks, validation, annotated case report forms
- Involved in Three Phases (me - III) of teh Clinical Trials in different Therapeutics areas Cardio-Vascular, Anti-Epileptic and Oncology trials.
- Proficient in generations of listings, tables and figures.
- Knowledge in Integrated Summary Safety (ISS) and Efficacy (ISE).
- Experience in Data Manipulation procedures such as SAS Formats/informats, Merge, Proc Append, Proc Datasets, Proc Sort and Proc Transpose
- Knowledge in all phases of clinical trails
- Experience in review of Statistical Analysis Plans (SAP), mock up tables, and specifications.
- Knowledge of Clinical Terminology and regulatory Guidelines.
- Experience in running macros and initialize reporting data by running programs shell in UNIX environment.
- Good in validating test plans, functional requirements using mercury quality center and maintain good communication among team working on teh project and guiding teh juniors
- Experienced in producing procedures: PROC GLM, PROC REG,PROC CORR,
- Experienced in producing RTF,PDF,HTML and MS Excel formatted files using SAS ODS facility.
- Expertise in analyzing and coordinating clinical data, generating details and summary reports, and data validation
- Experienced in handling / working on multi-projects at one time.
- Knowledge in database systems-Oracle, SQL*Plus, SQL, PL/SQL and other languages including C,C++.
- Proficient in MS Access, MS Excel, and MS Word.
- Proficient in Windows operating systems- VISTA,XP,NT AND UNIX
- Quick learner and excellent team player, ability to meet deadlines and work under pressure.
- Excellent communication, analytical and problem solving skills.
TECHNICAL SKILLS
SAS Skills: SAS/BASE, SAS/ACCESS, SAS/STAT, SAS/CONNECT, SAS/PC, SAS/GRAPH, SAS/ETS, SAS/EIS, SAS/Warehouse Administrator, SAS/OLAP, SAS/MDDB, SAS/QC, SAS/MACRO, SAS/ODS, SAS/REPORTS
SAS Procedures: Copy, Corr, Format, Freq, Means, Plot, Print, Report, Registry, SQL, Summary, Tabulate, Datasets, Univariate, Import, Export, Transpose, Compare, Gplot and Gchart.
Operating systems: MS DOS, Windows NT/2000/XP.
Programming language: C, C++, SAS, SQL.
Database: Oracle 7x/8x/9i, SQL Server, SAS Access.
Application Packages: MS Office, MS Outlook, Power point (Microsoft Office Suite)
PROFESSIONAL EXPERIENCE
Confidential, San Antonio, TX
SAS Programmer/Analyst
Responsibilities:
- Analyzed teh Clinical data for Phase II and Phase III for Oncology study.
- Generated Tables, Listings and Graphs using various procedures like Proc Freq, Proc Report, Proc Tabulate, Proc Univariate, Data null, and Proc Gplot.
- Experienced in validating programs and in writing competing codes to re-check teh statistical values of tables.
- Created SAS Macros and SAS Graphs. Used Proc REPORT to generate reports.
- Successfully designed and implemented statistical reporting processes.
- Performed Data Validation and Data cleaning by Peer-Reviewing.
- Developed routine SAS macros to create tables, and listings for inclusion in Clinical study reports and regulatory submissions.
- Performed Program Documentation on all programs, files and variables for accurate historical record and for future reference.
- Produced Tables, Listings and Graphs for Integrated Summaries of Efficacy (ISE) and Safety (ISS).
- Produced highly formatted and highly customized reports using Data Null .
- Provided SAS programming and statistical support to Statisticians.
- Worked with Data Managers for ensuring teh Data Integrity and did Data Cleaning, Data Validation and produced TLG’s as per teh requirement of Clinical and Data Management Department.
- Successfully validated TLG’s and CRT’s through independent validation using Proc compare and departmental standard macros.
- Expertise in Integration (Pooling) of datasets from different studies for further analysis.
Environment: SAS 8.2 (PC, UNIX), SAS/BASE, SAS/MACROS, PROC SQL, SAS/STAT, SAS/GRPAH, Oracle Clinical.
Confidential, Bloomington, MN
SAS Programmer/ Analyst
Responsibilities:
- Responsible for data collection, management and manipulation of clinical database.
- Performed statistical analysis, wrote SAS code for data management and reporting, and performed validation, including testing SAS code.
- Prepare clinical data listings and summaries for statistical analysis and analyzed clinical data using SAS system.
- Developed efficient, well-documented, readily comprehensible and modifiable SAS code using SAS/ Base and SAS/ Macro facility.
- Used SAS for pre-processing data, SQL queries, data analysis, generating reports, graphics, and statistical analyses.
- Maintained clinical trial data base, accessed various database to gather data, performed a table lookup and translated data values for meaning and readability.
- Downloaded data from Oracle using SQL within SAS to be analyzed and exported to Excel for further analysis.
- Created and implemented statistical analysis plans and specification documents.
- Supported teh research staff for technical and programming halp. Worked with Bio statistician to analyze teh results obtained from various statistical procedures like PROC ANOVA, GLM, and T test.
- Involved in clinical trials programming of data tables and listings for reporting on safety and efficacy.
- Produced quality customized reports by using PROC TABULATE, REPORT, SUMMARY and also provided descriptive statistics using PROC Means, Frequency, Univariate.
Environment: SAS 8.2, SAS/SQL, SAS/BASE, SAS/MACROS, SAS/GRAPH, Oracle 8, PL/SQL ANOVA, Windows NT and UNIX
Confidential, Montville, NJ
SAS Programmer
Responsibilities:
- Provided programming support for teh creation and maintenance of programs used in data management, data validation, and statistical report generation.
- Evaluated and discovered new information in datasets, sampled, analyzed and modeled data using Enterprise Data Miner.
- Worked on linear and non linear, regression and correlation, Analysis of variables-test analysis and posted teh result to teh web.
- Developed SAS macros for validating teh data from CRF.
- Provided graphical user interface for data analysts using data miner.
- Involved in creating Transport-files for electronic submissions to FDA.
- Created UNIX shell scripts and FTP to access teh transport files across teh network.
- Responsible for QC and wrote test scripts for Validating clinical trial data.
- Involved in Documentation as required by FDA regulations under 21CFR Part 11(Electronic Records and Electronic Signatures)
- Involved in generation and validation of ISE analysis (Tables, Listings and graphs).
- Manage multiple development projects while concurrently providing support for highly customized software application.
- Expert in writing test cases for quality assurance mainly regression testing.
- SAS macros were successfully used to create new programs and modified existing SAS programs to make them portable as well as consistency of results.
- TEMPEffectively communicated analytic project significance and overall application to a broad business audience.
- Extracted data from different data sources like UDB/DB2, Excel sheets, Delimited text files, Comma separated files, using SQL pass through facility and different data steps respectively
Environment: UNIX (Sun Solaris), Windows2000, SAS/BASE, SAS/STAT, SAS/AF, SAS/GRAPH, Oracle Clinical.
Confidential
SAS Programmer Analyst
Responsibilities:
- Collected and analyzed data pertaining to various products using primary and secondary data collection techniques, including survey development, focus group observances, and database searches.
- Synthesized research data into written and oral reports and presented findings to senior management.
- Analyzed clinical trials data and market data using various statistical methods (used SAS for statistical analysis and report generations) and presented results including market potential, safety & efficacy levels for teh new product
- Gatheird market intelligence for company’s Global library and databases.
- Expert in writing test cases for quality assurance mainly regression testing.
- SAS macros were successfully used to create new programs and modified existing SAS programs to make them portable as well as consistency of results.
- TEMPEffectively communicated analytic project significance and overall application to a broad business audience.
- Extracted data from different data sources like UDB/DB2, Excel sheets, Delimited text files, Comma separated files, using SQL pass through facility and different data steps respectively.
- Expertise in Integration (Pooling) of datasets from different studies for further analysis.
- Created and maintained SAS Datasets dat are extracted from an Oracle Database.
- Successfully handled multi-projects /tasks at a time.
Environment: Windows NT, Proc Contents, Proc Sql, Proc Import, Proc Export, Proc Transpose, Proc Freq, Proc Means, Proc Summary, Macros, ODS Proc Print, and EXCEL.
Confidential
SAS Programmer/Analyst
Responsibilities:
- Performed relevant statistical analysis of surveys and economic data captured during Clinical Trials.
- Worked with different clinical trials data like Demographics, Adverse Event (AE), Serious Adverse Event (SAE), Laboratory and Physical Examination.
- Generated Tables, Listings and Graphs using various procedures like PROC FREQ, Proc Report, Proc Tabulate PROC UNIVARIATE, Data null, Proc Plot, and Proc Gplot.
- Performed Data Validation and Data Cleaning on Clinical data using procedures like Proc Freq, Proc Means, and Proc Univariate.
- Used SAS Macros extensively in teh creation of new programs as well as modification of existing programs to improve ease and consistency of results.
- Wrote SQL Queries to check data for different conditions like duplicate values and missing values.
- Created and implemented statistical analysis plans and specification documents.
- Integrated with Clinical, Regulatory and Data Management colleagues to coordinate collection and reporting of clinical studies.
- Developed permanent SAS formats, templates and libraries.
- Prepared list of efficacy data for statistical analysis.
- Accessed External Excel files, Stored and Retrieved SAS data sets moving data through multi platforms.
- Generated graphs using SAS/GRAPH.
Environment: SAS/BASE, SAS/MACRO, SAS/ACCESS, SAS/CONNECT,SAS/GRAPH, SAS/STAT Oracle 8,Clinical Trials.