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.