We provide IT Staff Augmentation Services!

Sas Programmer/data Analyst Resume

Scottsdale, AZ

SUMMARY

  • Base SAS Programmer with Seven Plus yearsofSASprogramming experience inStatistical analysis, Validation and Statistical report generation of HealthcareandFinancial data.
  • Extensive experience in the application of SAS tools such as SAS/BASE, SAS/STAT, SAS/GRAPH, SAS/MACROS, SAS/SQL, SAS/ENTERPRISE GUIDE and SAS/ODS.
  • Extensive programming experience withPROC SQL, PROC Report, PROC Tabulate, PROC Transpose, PROC Plot, PROC Chart, PROC Datasets, PROC Format, PROC Print, SAS/STATprocedures such asPROC Corr, PROC Reg, PROC GLM, PROC ANOVA, PROC Freq, PROC Means, PROC Univariate.
  • Experience in developing SAS Macros, applications for data cleaning and reporting and involved in preparing documentation.
  • Excellent understanding of project issues, ability to work independently or as part of a team
  • Proficiency in writing maintainable, supportable, and well - documented SAS codes.
  • Experience in developing SAS Macros, applications for data cleaning and reporting and involved in preparing documentation.
  • Generate analysis datasets based on the Data Definition Tables (DDT) and in accordance to the CDISC standard. Used SDTMmodel (3.1.1)/ ADAM for domain creation and CDISC compliant analysis datasets.
  • Involved in the process of generating Analysis datasetsbased on CDISC standards for FDA Submission with thorough knowledge of CDISC, ADaM and SDTM.
  • Thorough hands-on experience in using SAS/ODS to generate different files including XML, RTF, MS Excel, PDF and HTML.
  • Strong understanding of Clinical Trials (Phases I - IV), FDA guidelines, and GXPs (Good Clinical Practice, Good Laboratory Practice and Good Manufacturing Practice).

TECHNICAL SKILLS

SAS Tools: SASV8, V9, SAS/BASE, SAS/ACCESS, SAS/SQL, SAS/MACROS, SAS/GRAPH, SAS/STAT, SAS/REPORT, SAS/ODS

Databases: Clinic-Trial, SQL server.

Operating Systems: Windows98/2000/XP

Languages: SAS, SAS Enterprise Guide.

Office Tools: MS-OFFICE, Word, Excel, PowerPoint, HTML.

PROFESSIONAL EXPERIENCE

Confidential, Scottsdale, AZ

SAS Programmer/Data Analyst

Responsibilities:

  • Worked closely with Business System Analyst in gathering requirements from end users and developed report layouts.
  • Understanding File Layouts required for State.
  • Understanding the relationships in tables for MEDICARE and MEDICAID Claims and involved in identifying DUAL Claims.
  • Extracted data from ORACLE database through SAS/ACCESS for ORACLE and extensively used PROC SQL to manipulate data and performed joins on datasets.
  • Extensively used the SET, UPDATE and MERGE statements on SAS datasets to read and manipulate claims data.
  • Used ETL for Can handling Historic data.
  • Obtained CRO Experience in many therapeutic areas by handling various studies in parallel.
  • Used different SAS Functions like LENGTH, TRIM, PUT, INPUT, STRIP, SUBSTR, and COMPRESS.
  • Used ETL For finding Error handling, log summary and load progress easier.
  • Accessed External files and created permanent SAS data sets.
  • Extensively used SAS MACROS for code reusability and used different options like SYMBOLGEN, MPRINT, MLOGIC, SOURCE, SOURCE2, and SAS TRACE for debugging.
  • Handled Pressure Environment in CRO by taking part of the many studied at a time and by working on studies with the priority.
  • Used SAS Array temporarily for processing group of variables within a data step.
  • Analyzed data using PROC FREQ and PROC SUMMARY.
  • Used ODS features for outputting SAS data into XLS, TXT and PDF formats.
  • Involved in Unit Testing.
  • Fine tuning the code prior to moving into production and implementing the code in production.

Environment: UNIX SAS 9.1, SAS/BASE, SAS/ACCESS, SAS/CONNECT, SAS Macros, SAS ODS, ORACLE, UNIX, XWIN32, SQL Server 2000.

Confidential, Charlotte, NC

SAS Lead Programmer/ Data Analyst

Responsibilities:

  • Make the results actionable for Marketing, Campaign Planning, Strategic Planning, Finance and Sales organizations.
  • Expertise in statistical modeling and analysis on study data by utilizing appropriate statistical methods.
  • Provide insightful analytics, strategy development and reporting to support Risk analysis Operations.
  • Developed sophisticated strategies and analyze risk related to fraud by identifying and managing the risks associated with credit card customer originations, authentication and product usage.
  • Extract, transform and load datasets with basic modeling variables for each segment type Using PROC IMPORT and SQL queries, imported data from Oracle database into SAS files
  • Involved in Web-based, ad hoc reporting capabilities for additional customer and Campaign performance analysis in as needed.
  • ETL is used to Extract(E) data from multiple source systems(like RDBMS,Flat files,Mainframes,SAP,XML etc) transform(T) them based on Business requirements and Load(L) in target locations.(like tables,files etc).
  • Manipulated and updated the tables as per specifications
  • Performed data cleaning by analyzing and eliminating duplicate and inaccurate data using PROC FREQ, PROC COMP, PROC UNIVARIATE, and macros in SAS
  • Formulated action plans and presented key information regarding profit dynamics to the senior management in the Bank
  • Maintained consistency of SAS variables formats and sorted various datasets using PROC SORT and merged them using MERGE
  • Used SAS Marketing Automation in data integration for access to all vital customer data.
  • Results are performed using SAS programming and using techniques such as SAS Macro language, advanced data manipulation, and statistical procedures (e.g., PROC FREQ, PROC REPORT).
  • Extracted data from different data sources like Oracle, DB2 loaded in data ware house depends on the business logics.
  • Generated the List outputs for Marketing Teams that have the list of customers to target as part of Campaigning.
  • Prepared ad-hoc reports, documenting SAS work, and directing SAS outputs to RTF and HTML files through SAS ODS facility
  • Used base SAS and SAS/SQL to generate tables.
  • Assisting in the analysis, design, and development of tables, Excel files and ad-hoc reports.
  • Used PROC compare to compare the data before and after editing.
  • Developed various SAS reports for Survey project and involved in code reviews for all the developed reports.

Environment: SAS 9.0, SAS/Base, SAS/Macro, SAS/SQL, SAS/OLAP, SAS/STAT, Web Reports Studio, MS-Excel and Windows XP/7, SASGRD1.

Confidential, Sunnyvale, CA

SAS Programmer

Responsibilities:

  • Analyzed the Phase II to Phase IV of the Clinical Trials.
  • Created datasets according to CDISC SDTM standards
  • Mapping and integrating study data to a CDISC-compliant proprietary analysis data system.
  • Created SAS reports using the Data Null technique and Proc Report for NDA submission as per FDA/ICH regulations and CDISC SDTM standards.
  • Extensively written SAS programs using SAS BASE and SAS Macros to parse and convert legacy data in Excel files into a standardized format required by the warehouse.
  • Extracted data from Oracle, using SQL pass through facility of SAS/ACCESS, for further analysis.
  • Prepared tables, listings and graphs according to the Statistical analysis plan.
  • Participated in designing, coding, testing, debugging and documenting SAS Programs and developed SAS Programs for Data Cleansing, Validation, Analysis and Report generation.
  • Tested and debugged existing macros.
  • Created ad-hoc reports for safety and efficacy of the clinical studies, as per the Specifications that is provided by the Statisticians.
  • Implemented data management plans designed to meet project and protocol deadlines.
  • Formatted HTML, RTF and PDF reports, using SAS output delivery system ODS.
  • Generated various Listings, Tables and Summaries for Efficacy, Safety and Adverse Events of the clinical studies, using procedures such as FREQ, MEANS, UNIVARIATE, TABULATE, REPORT and TRANSPOSE.

Environment: SAS9.1,BASE/SAS,SAS/STAT,SAS/ACCESS,SAS/CONNECT, SAS/GRAPH, SAS/PLOT, MS-Excel, Oracle and Windows 2000/NT.

Confidential, Exton, PA

SAS Programmer

Responsibilities:

  • Wrote edit check programs to ensure data quality.
  • Performed Data Extraction to generate Ad-Hoc TLs
  • Performed output review to validate reports
  • Generated safety tables, reports and listings related to demographics, adverse events, lab, study completion and study discontinuation
  • Thorough knowledge of Drug Development Process and Clinical Trials
  • Performed data analysis, statistical analysis, generated reports, listings using SAS Tools, SAS/MACROS
  • Performed sorting and merging techniques on the input data sets for Data Preparation.
  • Extensively used SAS/Macro to provide reusable programs that can be conveniently used from time to time
  • Produced quality customized reports by using Proc Tabulate, Proc Report, and Proc Summary and also provided descriptive statistics using Proc Means, Proc Frequency and Proc Univariate
  • Created Statistical tables and listings specifications
  • Performing in-depth quantitative analysis and data analysis
  • Extensively used procedures like Proc SQL, Proc Print and Proc sort
  • Coding SAS programs with the use of SAS/BASE and SAS/MACROS
  • Analyzed Specification and production and reporting deliverables
  • Performed program documentation on all programs, files and variables for accurate historical record and for future reference by using CDISC
  • Designed SAS programs to access, validate and summarize data, including validation of derived variables

Environment: SAS/BASE 9.1, SAS MACROS, Windows XP, SAS/Reports, SAS/STAT, SAS/SQL, SAS/ODS.

Confidential

Clinical SAS Programmer

Responsibilities:

  • Involved in the analysis of Phase I - II of clinical trials and handled data validations and populating analysis datasets.
  • Created and extracted Oracle tables from SAS and within Oracle by using SAS/ACCESS and PROC SQL.
  • Used CDISC SDTM to convert the tabulations in company’s standards to FDA standard tabulations.
  • Used SAS datasets functions, formats, statements and procedures like PROC FORMAT and to map the variables to the customer needs.
  • Performed data validation and data cleaning on clinical data using procedures like PROC FREQ, PROC MEANS and PROC UNIVARIATE.
  • Wrote SQL queries to check data for different conditions like duplicate values and missing values.
  • Created HTML and RTF reports using SAS ODS.
  • Reviewed SAPs, protocols and generated tables, listing and graphs using PROC REPORT.
  • TABULATE and PROC GPLOT.
  • Created SAS MACROS and modified the existing ones related to multiple studies.
  • Used DATA NULL FILE and PUT statements to create the customized reports.
  • Involved in documentation of newly developed SAS code and participated in testing/validating SAS code with specifications.
  • Involved in writing code using Base SAS and SAS Macros to extract clean and validate data from oracle tables.

Environment: Base SAS, SAS/STAT, SAS/GRAPH, SAS ODS, SAS Macros, SAS SQL.

Hire Now