We provide IT Staff Augmentation Services!

Sas/sql Analyst Resume

0/5 (Submit Your Rating)

Wilmington, DE

SUMMARY

  • Over 8 years of experience as a Clinical SAS Programmer in pharmaceutical and clinical research industry in Data Analysis and Reporting.
  • Additional experience in SAS financial as SAS/SQL Correction Analyst.
  • Statistical programming related to the design, programming, implementation, maintenance, and validation of Clinical trial information for the submission to the FDA during various phases.
  • Highly skilled in Base SAS, SAS /SQL, SAS /REPORT, SAS /TABULATE and MACROS.
  • Highly skilled in using SAS /STAT procedures, UNIX SAS, and Tera Data SQL Assistant program.
  • Extensively used Proc Anova, Proc Corr and Proc Reg.
  • Good experience producing high resolution graphs using SAS /Graph.
  • Experienced in working with SAS /ODS and SAS /ACCESS
  • Hands on experience in SAS Programming activities like merging SAS datasets, developing SAS procedures, data cleaning, report writing, macros, formats, informats, functions, storing and managing data in SAS Files.
  • Experienced in using SAS to read, write, IMPORT and EXPORT to another data file formats, including delimited files, Spreadsheet, Microsoft Excel and access tables
  • Involvement in debugging the program using MPRINT and MLOGIC.
  • Knowledge of drug development process and clinical trials with strong experience of analyzing and reporting in phase I - IV of clinical trial data.
  • Experienced in Electronic Data Capture (EDC) systems.
  • Knowledge in Integrated Summaries of Efficacy (ISE) and Safety (ISS) according to Statistical Analysis Plan (SAP) and protocols.
  • Familiar with FDA regulations and ICH/GCP guidelines and requirements.
  • Familiar with terminology in Pharmacy, Pharmaceuticals, Chemistry, Biochemistry, Biology, Cell/molecular Biology, and Oncology.
  • Experienced in Phase I to III oncology clinical trials for analyses and reporting procedures.
  • Accustomed to working in challenging environments under deadlines, excellent analytical, and problem solving skills.

TECHNICAL SKILLS

  • SAS V9
  • SAS ACCESS
  • SAS SQL
  • SAS STAT
  • SAS REPORTS
  • SAS MACROS
  • SAS ODS and SAS GRAPH
  • Print
  • Append
  • Means
  • Univariate
  • SQL
  • Report
  • Freq
  • Sort
  • Summary
  • Format
  • Transpose
  • Compare
  • Contents
  • Import
  • Export
  • Tabulate
  • Gplot and Gchart
  • Tera Data
  • Image Processing MATLAB
  • Maple Soft
  • MS-Access and MS-Excel
  • Windows 98 2000 XP
  • Vista
  • Win7, 8
  • Unix and MS DOS
  • Access
  • Excel
  • Word
  • PowerPoint
  • Email and Internet

PROFESSIONAL EXPERIENCE

Confidential, Wilmington, DE

SAS/SQL Analyst

Responsibilities:

  • Experienced to business programming languages, including UNIX SAS, SQL, UNIX, MS Office tools.
  • Possessed strong analytical skills including ability to analyze data and understand database table structures.
  • Worked extensively in Tera Data and Oracle database environments with proficiency in Microsoft Excel.
  • Possessed in-depth understanding of writing and maintaining UNIX Scripts with the ability to manage multiple projects simultaneously.
  • Demonstrated a high level of initiative and creativity to rebuild existing web sites as well as build and lead development on new initiatives.
  • Assigned to multiple problems simultaneously, typically three to five problems at once.
  • Managed throughout the life cycle of a project, with specific process control procedures and documentation.
  • Possessed strong communication, strong process adherence discipline, problem solving, reasoning skills, and detailed and quality assurance oriented as a member of a larger team of Customer Account Remediation.

Environment: UNIX SAS 9.2 (Base, Macros, SQL, SAS Functions & Procedures), Tera Data SQL Assistant.

Confidential, Plainsboro, NJ

SAS Programmer / Analyst

Responsibilities:

  • Maintained large data sets, combining data from various sources in varying formats to create SAS data sets by using Set and Merge for generating Reports and Graphs.
  • 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.
  • Transferred data using PROC IMPORT and EXPORT procedures
  • Extensive experience in cleaning the raw data and deleting duplicates. Created reports in PDF, HTML, XML and RTF using SAS/ODS statements & Data NULL techniques.
  • Used PROC SUMMARY, PROC MEANS, and PROC TABULATE for report generation.
  • Assisted in validation, edit checks and data review listing.
  • Created Summary Reports and tabular reports using Proc Report.
  • Worked with EDC systems in reducing the number of queries created.
  • Used RBREAK statements to obtain the sum of the values.
  • Performed One-to-One merging and Match merging.
  • Used PROC UNIVARIATE and SAS/STAT procedures for analyzing the data.
  • Used different SAS procedures in phase III trial including statistical analysis methods.
  • Strong knowledge of Statistical Analysis Plan (SAP), Standard Operating Procedures (SOP), Protocols of clinical trials.

Environment: SAS 9.2/9.3 (Base, Macros, SQL, Graph, ODS, Stat, SAS Functions & Procedures), Windows.

Confidential, Raleigh, NC

SAS Programmer/Data Analyst

Responsibilities:

  • Developed statistical summary tables, graphs, patient data listings and clinical study reports using BASE SAS procedures such as proc summary, proc tabulate, proc sort, proc freq, proc means and SAS GRAPH
  • Worked with different data management tasks such as cleaning and querying
  • Responsible for writing and debugging statistical programming, documented programming procedures and involved in coding
  • Developed new or modified SAS programs to load data from the source and create specific datasets, which are used as source datasets for report generating programs
  • Experience in complex and reusable Macros and extensively used existing macros
  • Collected requirements from statisticians, prepare requirements document, follow up and develop new macros as per statistician's request
  • Used Proc SQL to retrieve the data from database and report SAS datasets
  • Worked with different CDISC procedures such as SDTM, ADAM and in EDC systems.
  • Converted different data formats such as ASCII, EXCEL to SAS datasets
  • Expertise in working with ODS to convert the output to different formats such as PDF, RTF, HTML
  • Involved in the validation of codes written by other team members.
  • Investigated and fixed several issues and proactively suggested new output formats to satisfy the statistician's requirements.
  • Developed different complex reports using Proc Report and Data NULL
  • Experienced in identifying and solving technical problems.

Environment: SAS/BASE 9.1.2, SAS/GRAPH, SAS/MACRO, SAS/STAT, SAS/SQL, WINDOWS.

Confidential, Seattle, WA

SAS Programmer/Consultant/Analyst

Responsibilities:

  • Developed and maintained programs in SAS using SAS tools for Windows in a user support environment.
  • Designed and implemented statistical reporting processes for clinical data analysis.
  • Analyzed Phase II Clinical Trial data to determine the safety and efficacy of the agent.
  • Transformation & Loading, change the data capture. Involved in writing of clinical trial reports, analyzing and presenting trial results.
  • Performed Data analysis, statistical analysis, generated reports, listings and graphs using various SAS Tools like SAS/Base, SAS/Macros and SAS/Graph, SAS/SQL, SAS/Access.
  • Used SAS Functions such as character, statistical and truncation functions
  • Extensively used SAS/Macro facility to provide reusable programs that can be conveniently used time to time and created tables, graphs and listing reports.
  • Created SAS Customized Reports using the Data Null technique for FDA evaluations.
  • Performed Validation and QC of datasets, tables, listing and graphs.
  • Formatted HTML, PDF and RTF reports, using SAS output delivery system ODS.

Environment: Base SAS, SAS/MACRO, SAS/SQL, SAS/GRAPH, SAS/STAT, MS EXCEL

Confidential, King of Prussia, PA

SAS Programmer

Responsibilities:

  • Successfully implemented statistical reporting processes for regular data collection and clinical data analysis in phase I clinical trial.
  • Developed and maintained programs in SAS using SAS tools for Windows in a user support environment.
  • Extensive experience with the SAS programming and in data step and with various SAS Procedures in Base SAS and SAS /STAT, including thorough knowledge of SAS Macro Language.
  • Performed Data analysis, statistical analysis, generated reports, listings and graphs using SAS Tools such as SAS /Base, SAS /Macros and SAS /Graph, SAS /SQL.
  • Worked with time, concentration and clinical pharmacology data and was involved in PK PD data scrubbing (removing invalid, out-of-range, missing or duplicate values), validation, data structuring and data integration.
  • Generated Ad-hoc reports for analyses using SAS tools for in the oncology therapeutic area
  • Worked with Review reporting tool to browse data from Case Report Form
  • Program documentation on all programs, files and variables for accurate historical record and for future reference.
  • Convert MS-Word documents, MS-Excel, SQL tables into data sets.
  • Extensively used SAS / Macro facility to provide reusable programs that can be conveniently used time to time.
  • REPORT, SUMMARY and also provided descriptive statistics using PROC-Means, Frequency and Univariate.
  • Formatted HTML and RTF reports, using SAS - output delivery system (ODS).

Environment: SAS 9.1.3 Windows, SAS /BASE,SAS /STAT, Macros and Windows

Confidential, Reston, VA

SAS Programmer / Analyst

Responsibilities:

  • Imported data from Database and excel sheet into SAS by using SAS Access and SAS SQL.
  • Created analysis datasets, tables, listings and graphs (TLGs) by reviewing statistical analysis plan and standard operating procedures.
  • Performed validation of datasets, tables and listings produced by other programmers.
  • Performed data cleaning using edit check programs for removing invalid data from the database.
  • Extensively used SAS BASE procedures like PROC MEANS, PROC FREQ, PROC UNIVARIATE etc. and SAS STAT procedures like PROC ANOVA.
  • Created SAS customized reports using PROC TABULATE, PROC REPORT and DATA NULL .
  • Created transport files for SAS datasets using PROC COPY.
  • Involved in creation of DEFINE.PDF for FDA submission.
  • Involved in creation of Integrated Summaries of Efficacy (ISE) and Safety (ISS) reports.
  • Created reports in RTF, HTML and PDF formats using SAS ODS.
  • Utilized standard company macros and modified SAS programs for creating tables and listings.
  • Created custom views combining data from multiple CRFs.
  • Documented the whole process for future reference.

Environment: SAS 9.1 Windows, SAS BASE, SAS MACROS SAS ODS, SAS GRAPH, SAS STAT and MS-Excel.

Confidential, Cambridge, MA

SAS Programmer

Responsibilities:

  • Imported data from Database and excel sheet into SAS by using SAS Access and SAS SQL.
  • Performed statistical analysis, generated reports, listings and graphs using SAS Tools such as SAS /Base, SAS /Graph, SAS /SQL and SAS/Macros.
  • Worked with concentration and pharmacology data and was involved in PK/PD data analysis.
  • Created analysis datasets, tables, listings and graphs (TLGs) by reviewing statistical analysis plan and standard operating procedures.
  • Extensively used SAS BASE procedures like PROC MEANS, PROC FREQ, PROC UNIVARIATE and SAS STAT procedures.
  • Convert MS-Word documents, MS-Excel, SQL tables into data sets.
  • Formatted HTML and PDF reports, using SAS output delivery system ODS.

Environment: SAS 9.1 Windows, MS-Excel, SAS BASE, SAS ODS, SAS GRAPH, SAS STAT, SAS MACROS.

We'd love your feedback!