Sas Programmer Resume
Minnetonka, MN
SUMMARY
- SAS professional with over 7+ years of experience in Analysis, Design, Development, Implementation and Testing of various clinical projects using SAS tools inInsurance(Finance), Medical Device Industry and Pharmaceutical CROinPhase II - IV.
- Expertise in SAS programming features likeBASESAS, SAS/MACROS, SAS/ STAT, SAS/ACCESS, SAS/GRAPH, SAS/CONNECT, SAS/SQL, andSAS/ODSboth onWindows and UNIXplatforms.
- Proficiencyin generating reports featuring various SAS procedures, like null, ODS, Proc Report, Proc Summary, Proc Freq, Proc Mean, Proc Transpose, Proc sort, Proc Univariate,Proc Gplot, Proc GchartandProc SQL.
- Experience in using SAS to read, write, import and export to another data file formats, includingdelimited files, Spreadsheets, Microsoft Excel and Oracle databases.
- Experience in cleaning and resolving data issues and merging data from various data sources into a single dataset.
- Excellent knowledge in creating variousglobal and local macrovariables.
- Experience in using SAS programming in analyzing theClinical Trial Dataand responsible for generatingtables, listings and graphs (TLGs).
- Strong academic background in drug development process-conducting clinical trials, collection (paper CRF, eCRF (EDC)), analyses, presentation of data and in understanding Code of FederalRegulations (21CFR) Part 11, GCP, ICH, FDA and other regulatory guidelines.
- Strong working knowledge inCDISC, WHO Drug dictionaryand MedDRA regulated environment.
- Extensive experience in creation ofSDTM datasetsand in derivation ofADaM datasetsby implementing CDISC Standards.
- Good command onODMandDefine.XML.
- Working Knowledge inIntegrated Summaries of Efficacy (ISE)andIntegrated Summaries ofSafety (ISS)according toStatistical Analysis Plan (SAP) and Protocol.
- Excellent knowledge in data flow from Raw Datasets/DM Datasets to creation of submission package i.e.CRT packages.
- Self-motivated, team-playerand goal-oriented professional with excellent communication skills.
- Therapeutic Areas (Clinical):Oncology,Blood Screening,Neurology,Virology.
TECHNICAL SKILLS
SAS Tools: SAS Base, SAS/MACRO, SAS/STAT, SAS/SQL, SAS/GRAPH, SAS/ODS, SAS/ACCESS, SAS/CONNECT,Enterprise Guide.
SAS Procedures: Univariate, GLM, Logistic, Lifetest, Freq, Summary, Means, Gplot, Gchart, SQL, Append, Sort, Format, Import, Export, Transpose, Report, Datasets, Catalog.
Databases: MS Access, Oracle Clinical, MS Excel.
Operating systems: Windows, UNIX.Others MSOffice, SQL, Core JAVA,Core HTML.
PROFESSIONAL EXPERIENCE
SAS Programmer
Confidential, Minnetonka, MN
Responsibilities:
- Creating large report datasets, combining individual datasets by macro which pulls data from various databases in one single data step for big data analysis in FIN360.
- Create SAS program that business rules and creates reports for member revenue, medical claim and pharmacy claim area in Medicare and Retirement (M&R) division.
- Develop macro programs that invoke multiple macros as well as programs that create automated tie-out process for monthly finance report in M&R.
- Create a MACRO for various projects and operational activities to support the M&R Finance Organization.
- Write SQL queries to retrieve data from multiple data sources.
- Develop SQL queries to retrieve/combine data to address business question.
Environment: SAS Enterprise Guide6.1,BASE SAS,SAS/SQL,SAS/MACRO, SAS/ODS,SAS/ACCESS, MS Excel, Unix and Windows.
SAS Programmer
Confidential, Johnstown, PA
Responsibilities:
- Successfully handleprogrammer responsibilities including gathering requirements, creating specifications, developing codes, validating and documenting programs.
- Reviewed and provided comments for statistical analysis plans and specifications for the mock shells.
- Created/validatedCDISC SDTMand ADaMcompliant datasets along with its metadata specifications.
- Created/validated efficacy as well as safety TLGs as a form of pdf and rtf for FDA submission.
- Created SAS macros for reporting of the multiple tables across studies and for the similar tables for subgroup analyses.
- Coordinated work on multiple studies simultaneously as per priorities and met all study timelines.
- Provideprogramming support for Ad-hoc analysis andreports.
- Participating in creating CRT package for FDA submission.
Environment: SAS9.3,BASE SAS,SAS/SQL,SAS/MACRO,SAS/GRAPH,SAS/ODS, SAS/ACCESS, MS Excel, Windows.
Clinical SAS Programmer
Confidential, Pleasanton,CA
Responsibilities:
- Validated source and analysis datasets using SAS procedures and standard macros.
- Dealt with large blood screening lab data (external and internal) review and analysis.
- Generated/Validated TLGsusing different SAS procedures.
- Recommended technical and process solutions that can be used or developed to increase efficiency of project work.
- Adapted to changing circumstances, policies, work assignments, and/or team members.
- Worked multiple studies at same time and deliver them on time.
- Prioritized and delegated tasks based on the importance of the deliverable andawareness of overall timelines in order to efficiently produce high quality deliverables.
Environment: SAS Enterprise Guide5,BASE SAS,SAS/SQL, SAS/MACRO, SAS/GRAPH,SAS/ODS,MS Excel, Windows.
Clinical SAS Programmer
Confidential, WA
Responsibilities:
- Contributedin study-related activities such as review of CRF,and SDTM and ADaM specification document.
- Reviewed edits check specifications to ensure data accuracy and data validity/integrity.
- Created, analyzed and summarized safety and efficacy SDTM and ADaM dataset associated with clinical studies, as per the specifications in the SAP (statistical analysis plans) at study-level and project-level.
- Performed statistical analysisusing SAS/STAT procedure.
- Generated TLGs using ADaM datasets, programming specification documents, SAP and TLG shells.
- Createdcustomized figures for clinical study reports as well as ad-hoc requests using SAS procedures Gplot and Gchart.
- Validated CRT packagesfor FDA submission.
- Modified/validated existing SAS macros to report summary as well as descriptive statistics.
- Combined data from multiple studies to create pooled datasetsfor reporting of ISS/ISE.
- Performedvalidationof SAS programs and standard macros using company guidelines and communicated findings to the programmer/ biostatistician.
Environment: SAS9.2-9.3,BASE SAS,SAS/SQL,SAS/MACRO,SAS/GRAPH,SAS/ACCESS,SAS/ODS,MS Excel, Windows.
SAS Programmer
Confidential, Canton, MI
Responsibilities:
- Utilized SAS Procedures and otherSAS applications for data updates, data cleansing and reporting.
- Identified and correct data step syntax and programming logic errors.
- Efficient in using data step programming to solve complex programs.
- Import and Export of clinical data across a variety of applications to and from SAS.
- Validated of programs and processes to extract data from Clinical data management systems, to prepare data listings, summary tables and reports using SAS.
- Provided data verification and problem resolution as and when required.
- Produced external files and reports employing variousSAS procedures.
Environment: SAS 9.2,SAS/BASE,SAS/SQL, SAS/MACRO,SAS/GRAPH, SAS/ODS, MS Excel.