SUMMARY

• 7 years experience as a Clinical SAS Programmer in pharmaceutical and clinical research industry in Data Analysis and Reporting.
• 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.
• Extensively used Proc Anova, Proc Corr and Proc Reg.
• Good experience producing high resolution graphs using SAS/Graph.
• Experience working with SAS/ODS and SAS/ACCESS.
• Thorough experience in data extraction from large database/data warehouse, sorting from database like Oracle, using SQL Pass through facility, library reference statements, Proc dBload etc.
• Strong fundamentals in Business Statistics, Mathematical Statistical Analysis and financial mathematics concepts.
• Thorough hands - on experience in using SAS/ODS to generate different files including XML, RTF, MS Excel, PDF and HTML.
• 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.
• Experience in using SAS to read, write, IMPORT and EXPORT to another data file formats, including delimited files, Spreadsheet, Microsoft Excel and access tables.
• Experienced in developing SAS Procedures, Macros, SAS Formats & Informats, SAS Functions and applications for data cleaning, reporting and documentation.
• Good at creating, reviewing, retrieving, validating Datasets and to read, write, import and export to another data file formats.
• Developed programs to generate derived datasets from raw data imported from sources; modified existing SAS datasets using Data Step, Set, Modify and Merge statements.
• Knowledge of drug development process and clinical trials with strong experience of analyzing and reporting in phase I-IV of clinical trial data.
• Extensive programming experience with Proc Report, Proc Tabulate, Proc Format, Proc Transpose, Proc Print, Proc Append, Proc compare, Proc Sort, Proc Freq, Proc Import, Proc Export.
• Design reporting templates and create report mock-ups and final reports illustrating the results of analytic and programming processes
• Familiar with terminology in Biology, Cell/molecular Biology, Oncology, Chemistry and Biochemistry.
• Extensive exposure on every steps of entire project life cycle including data collection, query, modifying and analysis, summary of findings, communicating strategic insight and presentation of results and documentation of the processes.
• Developed new or modified existing SAS programs to load data from the source and create study specific datasets
• Strong ability to write SQL queries usingPROC SQL.
• Quick learner with ability to understand job requirements employs new ideas, concepts, methods, and technologies.

TECHNICAL SKILLS

SAS Tools: SAS 9.1/9.2, SAS/BASE, SAS/ACCESSSAS/GRAPH, SAS/STAT, SAS/SQL, SAS/ODS.

SAS Procedures: Proc Print, Means, Univariate, Report, Summary, Tabulate, FreqSort, Format, Copy, Compare, Gplot, Transpose.

Languages: SAS/SQL, SPSS, R

Office tools: MS office 2003/2007/2010, Word, Excel and PowerPoint.

Operating Systems: Windows XP/2000/98 and Mackintosh systems

PROFESSIONAL EXPERIENCE

Confidential, MI

SAS Programmer/Analyst

Responsibilities:

• Development and analysis of dataset specifications and SAS based utilities. Data capture design review and input into data standards.
• Has a strong understanding of the regulatory process and detailed understanding of the analysis and reporting process and implications on programming
• Ensure analysis data and programming code meet regulatory and company standards and are consistently structured to permit efficient programming and reporting
• Develop/re-use SAS programs to produce Safety and Efficacy Tables, Listings and Figures without assistance
• Ability to perform advanced level activities using application based reporting environments (including high complexity dataset creation and study specific macros) as per the intended and most efficient use of the application
• Perform comprehensiveexploratory data analyses to identify/quantify trends, correlations, andinteractions within and across data sets.
• Implementation of Credit Risk Analysis reporting system based on credit Scores and data management principles, mainly including joining data set, indexing, data aggregation, record selection, sub-setting, multiple records per case, creation and modification of views.
• Developing and designing SAS Programs/ Macros to analyze financial data. Statistical analysis files, tables, listings, and graphs.
• Generate SAS reports, creating RTF, HTML listings, tables and reports using SAS ODS for ad-hoc report generation.
• Analyzed and interpreted numerical data from various sources organized and summarized data for analysis.
• Presented numerical information in various formats. Created SAS customized reports using the DATA NULL technique.

Environment: SAS/BASE 9.3, SAS/STAT, BI, SAS/SQL, SAS/GRAPH, SAS/MACRO, SAS/EG, SAS/ODS, SAS/ACCESS and MS Access Database.

Confidential, Whippany, NJ

SAS Programmer/Analyst

Responsibilities:

• Providing clinical data management and biostatistical programming support for various phases of clinical studies.
• Activities include importing/exporting data, reformatting raw data client specified analysis standards, programming and/or validating analysis data sets, tables, listings, graphs, adhoc reports and regulatory submission deliverables such as ISS, Client, and Define documents.
• Assists Data Management and Biostatistics with developing tools and techniques for improving process efficiencies.
• Experienced in transforming raw data into datasets that are in accordance with SDTM and ADAM standards; Creation of specifications files for creating analysis datasets, TLGs / TLFs and Ad-hoc reports; Develop SDTM data mapping and create SDTM datasets per CDISC standard for FDA
• Communicates effectively within a multi-disciplinary project team to complete assigned tasks on time and within budget. Resolves issue escalation for lower level programmers.
• Reviews and makes recommendations for process development and improvement.
• Develop expertise in the use of SAS (e.g. macros, SQL, efficient programming) and other in-house reporting systems
• Prolifically generated SQL queries for the reports. Successfully identified problems within the data, produced derived data sets, tables, listings and figures, which analyzed the data to facilitate correction.
• Stratification of patients into standard and high risk categories through monthly predictive analysis of claims data to help identify patients who are likely to experience a significant health care need within the ensuing 6 to 12 months, which gave the nurse care coordinators a head start in working with those individuals.
• Developed SAS Macros for data cleaning, reporting and to support routing processing. Generated graphs using SAS/GRAPH and SAS Graphics Editor. Used PROC REPORT to generate reports.
• Experience in working closely with statisticians to provide SAS programming in analyzing clinical trials data and generating Statistical Analysis Files, Tables, Listings, Summaries, and Graphs; Performed Data Analysis validation and Created the programs to as per the specifications required to run in the SAS drug Development (SDD).
• Prepared flowcharts indicating the input data sets, sorting and merging techniques and wrote SAS code accordingly.
• Experience in Modifying existing SAS programs and creating new SAS Programs using SAS Macro to improve ease and speed of modifications as well as consistency of results.

Environment: SAS/BASEv9.2, SAS/MACRO, SAS/SQL, SAS/GRAPH, SAS v9.1.3, MS Excel, Windows NT

Confidential, Pittsburg, PA

SAS Programmer

Responsibilities:

• Experienced in validating programs and in writing competing codes to re-check the statistical values of tables.
• Extensively used SAS Data Step functions and descriptive statistical Procedures to process large amounts of customer response and sales data.
• Used PROC SQL LIBNAME and PROC SQL Pass-through methods to access data on Oracle database. Created customer mailing lists for Direct Mailing and Telemarketing using PROC Forms.
• Extensively used PROC Import and PROC Export procedures for importing and exporting PC files and Microsoft office files such as Excel Spreadsheet, Access Tables.
• Maintained and enhanced existing SAS Reporting programs using PROC Tabulate, PROC Report, PROC Print, ODS RTF, and ODS PDF for marketing campaigns.
• Proficient in indicating the input data sets, setting, sorting and merging techniques
• Generated Ad-hoc reports and browser viewable reports using SAS/ODS. Proficiency in importing different types of external files (Excel, CSV, txt, etc.) into SAS library and exporting SAS data sets as external files using Import/Export Wizard, PROC IMPORT, PROC EXPORT and SAS DATA steps.
• Macros were employed for data transformation and filling up missing values. PROC VARCLUS was used to check the colinearity among explanatory variables.
• Extensively used SQL procedure for join and union of tables. Worked on pre-existing macros for data validation by checking data distribution and comparison to standard empirical distribution.
• Transferred and migrated data from one platform to another to be used for further analysis. Generated highly customized reports in the form of listing, HTML, RTF and PDF using SAS/ODS, PROC REPORT, PROC TABULATE.
• Performed competitor and customer analysis, risk and pricing analysis and forecasted results for credit card holders on demographical basis.
• Successfully used SAS/STAT to perform ANOVA, MANOVA and Contingency Table analysis. Prepared graphs using the modified tables for analysis.
• Assisting in the Vendor Goal Setting process for the Sales Strategies Team. Calculated risk factor for individual clients based on hierarchical demographical information.

Environment: SAS/BASE, SAS v9.1.3, SAS/ODS, SAS/SQL, SAS/Connect, SAS/Access, Enterprise Guide (EG 4.0/4.2), Windows 2003, Access, Excel.

Confidential, NJ

Data Analyst - SAS

Responsibilities:

• Responsible for the development of SAS programs for clinical use. Development and analysis of dataset specifications and SAS based utilities.
• Facilitated and managed meetingsessions with committee ofSMEs from various business areas includingMortgage Servicing, Loan MonitoringandAsset Management.
• Developed data base objects like tables, views, indexes, stored procedures and user defined functions as per the business needs in SAS
• Analyzed the loan data to generate portfolio statistics report using SAS, summarizing accounts by Fico bucket, market segment and account status
• Imported data from SQL Server and Excel to SAS datasets. Performed data manipulation by merging several datasets and extracted relevant information
• Used SAS datasets to create reports using Proc Print and Reports. Also used Proc Transpose, Proc Tabulate, Proc Import, Proc Freq and Proc SQL
• Experienced in producing RTF, HTML and PDF files using SAS/ODS, well versed with creating HTML Reports for financial data using SAS ODS facility.

Environment: SAS 9.1.3, SAS EG 4.1 4.2, SAS Add-in Microsoft office, Windows SAS, SAS Management Console, SAS Web Report Studio, SAS ACCESS, TERADATA 12 13.

Confidential

SAS Analyst

Responsibilities:

• Produced quality customized reports by using PROC REPORT, SUMMARY and also provided descriptive statistics using PROC Means, Frequency, and Univariate.
• Generated graphs using SAS/GRAPH and SAS Graphics Editor.
• Developed routine SAS macros according to the given specifications.
• Imported/Converted randomization data files from Excel, .CSV data files into SAS data sets for analysis.
• Designed flowcharts indicating the input data sets and the techniques that would be used (sorting, merging, etc.) to get the desired output.
• Wrote SAS code for data management and reporting, and performed validation, including testing SAS code.
• Wrote statistical sections of Clinical Study Reports and assisted in preparing integrated Clinical/Statistical reports.

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