Sas Programmer Resume
Durham, NC
SUMMARY
- Qualified Clinical SAS Analyst/Developer with 8 years of experience in pharmaceutical and clinical research industry in Data Analysis and Reporting.
- Ability to extract and analyze Clinical trial data and generate reports, tables, listings, graphs and summaries as per client request.
- Hands on experience in SAS programming to read, write, import, export, merge and clean SAS data sets.
- Expertise in BASE SAS procedures like PROC SQL, PROC IMPORT/EXPORT, PROC PRINT, PROC SORT, PROC REPORT, PROC FORMAT/INFORMATS, PROC CONTENTS, PROC MEANS, PROC GCHART, PROC UNIVARIATE, PROC GPLOT and more.
- Well versed in accessing files from various formats like Spreadsheet, Excess and Access, and creating MACROS, preparing data for analysis.
- Highly skilled in using SAS/ODS programming to produce HTML, PDF format tables, listings or reports.
- Expertise in writing and designing complex SQL queries. Analysis and Design - Use case sequence and Activity diagram.
- Extensive programming experience in BASE/ADVANCED SAS, SAS MACROS, SAS ACCESS, SQL, SAS Enterprise Guide, SAS STAT, and SAS ODS
- Ability to review SAS coding, debug SAS compiling errors and quickly identify areas of concern.
- Experience of working with Bio-statisticians and clinical data managers to extract and analyze the data and generate reports, tables, listings and graphs.
- Excellent knowledge and understanding of drug development process, clinical trials and protocol of FDA submissions during various phases.
- Ability to work with CDISC, SDTM, ADaM standards and follow Standard Operating Procedures, and prepare efficient Statistical Analysis Plan.
- Thorough knowledge and experience of Microsoft office tools such as Word, Excel, Access, and PowerPoint.
- Effective team player with excellent analytical ability and problem solving skills.
- Strong communication, leadership and interpersonal skills with ability to interact with individuals at all levels.
TECHNICAL SKILLS
Operating System: Windows 98/ 2000/ XP/ Vista/ 7 and Mackintosh Systems
Office Tools: MS Office 2003/ 2007/ 2010 , MS-Word, MS-Excel, MS-Access, MS-PowerPoint.
SAS Tools: SAS 9.1/ 9.2, SAS/BASE, SAS/MACROS, SAS/SQL, SAS/ODS, SAS/ACCESS, SAS/GRAPH, SAS/STAT.
SAS Procedures: Proc Print, Means, Univariate, Report, Transpose, Summary, Tabulate, Freq, Sort, Gplot, Format.
Languages: SAS/SQL, HTML, JavaScript, R, Python, ORACLE/SQL
Therapeutic Areas: Reproductive Health, Infections and Infectious Diseases, Disorder, Oncology, Pathology and Endocrinology.
PROFESSIONAL EXPERIENCE
Confidential, Durham, NC
SAS Programmer
Responsibilities:
- Developed on data integration with statisticians and data management staff for efficacy and safety of drugs in trials.
- Worked on integration and validation of datasets from multiple studies as per programs requirement and specifications.
- Prepared SDTM datasets and analysis reports following the ADaM format for integrated summary of safety and effectiveness.
- Developed high quality customized tables, reports and listings using PROC TABULATE, PROC SUMMARY and PROC REPORT.
- Provided descriptive statistical analysis using tools like PROC FREQUENCY, PROC MEANS and PROC UNIVARIATE.
- Used tools such as SAS/Access and SAS/SQL to create and extract oracle tables.
- Developed and generated regression, correlation studies and analysis of variance and programmed mapping of new datasets.
- Created SAS reports of clinical trial results by using Data Null procedures and Proc Report for submissions to FDA as per user requests.
Environment: Base SAS and SAS Macros, Access, Stat, SQL, ODS, and Graph, MS-Excel, MS-Access.
Confidential, Cary, NC
Clinical SAS Programmer
Responsibilities:
- Worked on relevant statistical analysis of data from clinical trials and provided SAS programming and statistical support to studies.
- Familiarity with design and implementation of statistical report processes for data analysis of phase I, II and III clinical trials.
- Used an oracle database to extract datasets to create and maintain reports and tables with use of SAS/Access and SAS/SQL.
- Worked on multiple platforms to access external files such as MS-Word, MS-Excel etc. and store the retrieved SAS datasets.
- Developed and created new SAS programs using SQL and modified existing SAS programs for qualitative analysis of clinical data.
- Generated high quality reports using Proc Report, Proc Print, Proc Tabulate and Data Null procedures.
- Developed SAS MACROS for data cleaning and created high quality graphs using Proc GPLOT statements.
Environment: Base SAS 8.2, SAS/Macros, SAS/Access, SAS/Stat, SAS/SQL, SAS/Connect, SAS/ODS, SAS/Graph, Oracle 8i, MS Excel.
Confidential, Elkridge, MD
Clinical SAS Programmer
Responsibilities:
- Developed analysis datasets, summary tables, plots and listings for statistical analysis and efficacy data according to the specifications of the study.
- Performed validation and quality control checks on datasets received from data management.
- Worked on multiple projects at the same time involving different kinds of data including demography, adverse events, vital signs and laboratory data.
- Generated SAS customized Reports according to FDA standards using the Data Null Technique for evaluations.
- Used various SAS tools and existing Macros to create datasets and displays for the purpose of validation.
- Developed high quality reports and listings using various procedures such as PROC REPORT, PROC MEANS, PROC FREQ, PROC REPORT, and PROC UNIVARIATE.
- Performed in-depth quantitative analysis and presentation of reports.
- Worked with managers, statisticians and medical writers for abstract, manuscript and poster preparation and presentations.
Environment: SAS 9.1/ 9.2 (Base, Macros, ODS, SQL, STAT, Graph, and other SAS Functions and Procedures), Windows.
Confidential, Exton, PA
Clinical SAS Programmer
Responsibilities:
- Worked in accessing subject raw data on effectiveness of C1 inhibitor towards hereditary blood disorder and manage using SAS.
- Developed reports for therapies on a monthly basis and reports of different drugs on referral and Confidential ts.
- Worked on preparation of tables and high resolution charts and graphs using SAS/ graphs on biopharmaceutical data against subjects with autoimmune diseases.
- Extensive involvement in drill through analysis on drug referral and shipment data.
- Generation of graphical visualization reports and extensive use of SAS enterprise Guide for Ad Hoc reporting.
- Involvement in maintenance and updates of data warehouse and generation of dashboard reports.
- Worked in writing macros and organizing data files using PDF and office applications such as Word, Excel and more.
Environment: SAS Enterprise Guide 4.2/5.1, MS Access and Macros.
Confidential, New Brunswick, NJ
SAS Programmer
Responsibilities:
- Worked on SAS programming for data analysis, validation, documentation and generated reports tables, graphs and listings according to CDISC standards.
- Performed sorting and merging techniques to prepare and validate data for input datasets using SAS tools.
- Developed macros and SAS programs to perform edit checks and post data entry verification.
- Familiarity with oncology trials and validation of SDTM datasets using OPENCDSIC validator.
- Developed documentation of methods, programming with results and assisted in developing analysis plan along with summarizing reports and publications.
- Used tools to successfully perform file conversions, data imports/exports from SAS, create PK listings and reports for pediatric study.
- In depth knowledge to use Macros per protocol, statistical analysis techniques for clinical studies and generate report summaries from multiple studies and sources.
Environment: Base SAS, SAS Macro, SAS ODS, SAS SQL, SAS STAT, SAS GRAPH, Windows.
Confidential, Franklin Lakes, NJ
SAS Programmer
Responsibilities:
- Analyzed reports, determine methodologies and procedures to effectively carry out data analysis.
- Maintained and developed programs using SAS tools in a user support environment.
- Worked on importing and exporting data to prepare summaries using procedures such as Proc Freq, means, sort, print, tabulate, gplot, gchart and more.
- Performed statistical and data analysis, generated tables, listings and reports using tools such as SAS/BASE, SAS/MACRO, SAS/ACCESS and SAS/SQL.
- Used SAS output delivery system to generate formatted HTML, PDF and RTF reports.
- Familiarity with use of macro variables, and SAS functions such as character and statistical functions.
- Extensively used SAS Enterprise guise for Ad hoc reporting and analyzed reports and presentation to client.
Environment: SAS 9.1/ 9.2 (Base, Macros, SQL, GRAPH, STAT), MS-Excel, MS-ACCESS.
Confidential, Louisville, KY
SAS Developer/Analyst
Responsibilities:
- Developed high quality reports in form on listings such as HTML, PDF and RTF using SAS/ODS tool.
- Generated email notification macros and used procedures such as PROC FREQ, PROC PRINT, PROC MEANS, PROC SORT, PROC TABULATE, PROC REPORT and more.
- Familiarity with development and modification of existing SAS programs for the Quality Assurance System Rewrite Project.
- Used SAS tools such as SAS/Access and SAS/SQL to extract data and create SAS data sets for statistical analysis, validation and documentation.
- Developed and migrated reports using basic knowledge of Tableau software and ran Ad-hoc queries and reports according to user requests.
- Documented all programs and procedures to ensure accurate record of completed work on an assigned projects.
Environment: SAS/BASE, SAS/MACROS, SAS/Access, SAS/SQL, SAS/ODS, SAS/Connect, MS Excel.
Confidential
Jr. SAS Programmer
Responsibilities:
- Worked on two drugs tested for their antibiotic activity in the gastrointestinal tract of the subjects suffering from the Esophageal Reflex Syndrome.
- Retrieved the required data sets from various sources and designed graphs and charts from large data sets.
- Imported/Converted randomization data files from Excel, .CSV data files into SAS data sets for analysis.
- Produced quality customized reports by using PROC REPORT, SUMMARY and also provided descriptive statistics using PROC Means, Frequency, and Univariate.
- Designed flowcharts indicating the input data sets and the techniques that would be used (sorting, merging, etc.) to get the desired output.
- Performed SAS Edit Checks on the raw SAS data sets and developed routine SAS macros according to the given specifications.
- Wrote statistical sections of Clinical Study Reports and assisted in preparing integrated Clinical/Statistical reports and generated graphs using SAS/GRAPH and SAS Graphics Editor.
Environment: SAS/BASE,SAS/STAT and Windows.