Summary:

• Over 8 years of experience as a clinical SAS programmer in clinical research and statistical analysis with strong emphasis on design, implementation and development of various projects in Pharmaceutical companies and Clinical Research Organizations CROs
• Strong knowledge of clinical trial data and good experience in designing, developing and analyzing the data, debugging the errors, reviewing the SAS code
• Experience in creating and validating SDTM and ADaM datasets and in producing TLG's and summaries based on company's and the client's requirements
• Extensive experience in generating reports and creating summaries according to the specifications of Statistical Analysis Plan SAP and Standard Operating Procedures SOP
• Proficient in creating tables using Proc Report, Proc means, producing and customizing Graphs using Proc Gplot
• Part of a team for FDA e-submissions. Created Deliverables like annotated CRF and .XPT files
• Generated various SAS reports according to the 21 CFR-Part11.
• Created PDF, RTF, HTML files using SAS/ODS
• Experience in producing safety and efficacy reports-Integrated Summaries of Safety and efficacy
• Experience working with different coding dictionaries like MedDRA and WHODrug
• Designed and developed datasets as per the CDISC standards
• Good in handling multiple projects at a time and large databases to perform complex data modifications
• Excellent Collaboration and Communication skills written and verbal
• Good technical and Analytical Skills and ability to work in a team as well as independently

Technical Competencies:

• SAS Tools: SAS v.9.1, v9.2, v.9.1.3 Base, Macro, ODS, ACCESS, CONNECT, GRAPH, STAT
• Operating Systems: Windows XP/NT/2008, UNIX
• Languages: SQL, PL/SQL, C, C , SAS
• Databases: Oracle 9i/10g, MS ACESS

Professional Experience:

Confidential

Sr SAS Developer

Responsibilities:

• Formulate and define system scope and objectives for assigned projects.
• Gathering requirements and documentation, unit test case development, and defining and documenting the integration testing of new applications.
• Implement complex data file manipulation involving matching, merging, cleaning and modifying operational testing program data primarily using SAS
• Assist in setting and maintaining Incoming and Outgoing Data Quality Standards.
• Ensure that statistical analysis requirements are met for assigned projects.
• Preparation of clear detailed specifications from which programs will be written by team developers.
• Consultation with ETS Systems and Technology staff in the modification, design and implementation of systems or projects using multiple processing techniques and system technologies, database and structured design techniques.
• Analyze data Work with ETS business, and technology areas, as well as implement data and manipulation technologies and transition the support of the systems to a production environment.
• Develop and evaluate unit testing plans to ensure design requirements are met.
• Provide technical knowledge of all phases of applications systems analysis and programming and have a good understanding of the business or function for which the applications are designed.
• Responsible for contributing to the design and development of technologies for executing large and complex data analysis projects.
• Design and check complex data file manipulation rules involving matching, merging, cleaning and modifying operational testing program data

Confidential

SAS Programmer

Responsibilities:

• Responsible for handling two projects namely Update the Survey Module and Creation of new module.
• Generate a new dataset by modifying previous SAS code versions
• Updated current data to include additional variables based on the user requirements
• Incorporated the new data into the EQ module by modifying the metadata base Access ,Teradata and updating HTML/JavaScript code
• Assisted in data checks of the new data and responsible for making the final revised module live
• Analyses of requirements and datasets that produce data tables and graphs by demographics and bivariate.
• Written SAS code for each level of the module, including embedded HTML and JavaScript to build webpages and working within the SAS eBI system.
• Created a new Access database containing the metadata for the module
• Worked closely with the BES team to design a working internal site, providing a testing environment and demonstrating the site as developed.
• Completed the documentation and created the development process for the above project modules

Environment: Windows 2000, SAS 9.1, SAS9.3, SAS/ODS, SAS/SQL, MS Excel, database Oracle, SAS/ACCESS, JavaScript, SAS/EG, BASE SAS, SAS/ MACRO, SAS/ SQL.

Confidential

SAS Programmer

Responsibilities:

• Understanding the Business and its Requirements
• Gathering the requirements from user
• Modified data using SAS/BASE and Macros
• Modified data for business analysis
• Creation of Data Sets on the Remote server
• Coordinating the production of monthly, quarterly, and annual performance reports for senior management.
• Extracting data from the database using SAS/Access, SAS SQL procedures and create SAS data sets.
• Creating SAS dataset from tables in Database using SAS/Access. Retrieved the MEMBERS data from flat files, oracle database and converted to SAS data sets for Analysis using SAS/STAT procedures
• Coding SAS programs with the use of Base SAS and SAS/Macros for ad hoc jobs
• Created reports for online and batch applications for various servers
• Coding SAS programs with the use of SAS/BASE and SAS/Macros for ad hoc jobs
• Retrieved ,monitored and analyzed MEMBERS DATA using MHS
• Run reporting programs and download the results into EXCEL and build pivot tables
• Moved data set across platforms from PC and Mainframe MHS
• Prepared new Datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort, and Update, Formats, Functions and conditional statements
• 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
• Attended project team meetings, worked with, Data Managers, Business Users and offshore team as appropriate
• Involved in extracting, analyzing data from the data-warehouse using SAS.
• Created SAS data sets by extracting data from Oracle tables using SAS/CONNECT.
• Used ULTRA EDIT and VSS features to connect to multiple databases for comparing views and checking syntax errors for performance tuning and quality control
• Worked with Financial departments to develop required applications for performing complicated analysis
• Used PROC SQL for ad-hoc report programming, to perform the tasks like data manipulation of multiple views in Oracle, creation of the ad hoc reports for business user, preplanning and doing ad hoc joining of multiple Oracle views.
• Created and maintained the project documentation like functional and technical specifications
• Documented the SAS project report notice ,which included the indications of purpose of the requirement, from where it is been read and written to , what kind of process it is, how the process runs and finally the installation instruction for the upgraded data dictionaries and the new or modified program
• Worked by abiding to the HIPAA Privacy regulations required by the health care providers and organizations, as well as their business associates.
• Created test plans for QA validation purposes.
• Coordinated with the offshore team.

Environment: Windows 2000, SAS 9.1,SAS9.3, SAS/ODS, SAS/SQL, MS Excel, database Oracle, IBM ASO/400 and IBM compatibles, BASE SAS, SAS/ MACRO, SAS/ SQL.

Confidential

SAS Programmer Analyst

Responsibilities

• Worked on in-house Survey project handling the responsibilities of SAS programming and QA analysis/testing
• Performed data and QA analysis, tested/completed the deliverables and presented the analyzed/output data based on the requirements understanding of business process, the data and the user.
• Transformed the statistical data in various formats excel, access into SAS data sheets. Provided statistical programming expertise in the production of QA analyses, tabulations, reports and listings.
• Derived from specifications of survey regarding editing, coding, reports, debugging etc
• Accompanied in Phase I various consulting sessions and provided support in statistical analysis including choice of experiment design, management of data, statistical procedures for analyzing experiments, interpretation of the results, statistical modeling and statistical computing.
• Developed programmes for cleaning, transforming and modifying the data daily.
• Updated documentation during the life cycle of QA testing like design processes, business specs, comments in the code, record the issues/problems and record the inputs/outputs
• Actively participated in internal QA peer reviews and managing the project folders on project shared drive and SharePoint site
• 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: Base SAS v9.2, SAS/Macros, SAS/SQL, SAS/ACCESS, SAS/STAT, Windows XP, KEDIT.

Confidential

SAS Programmer

Responsibilities

• Worked on Agile methodology
• Performed data analysis, completed the projects and presented the analyzed data. Transformed clinical data in various formats excel, CSV into SAS data sheets. Provided statistical programming expertise in the production of analyses, tabulations, graphs and listings
• Accompanied statisticians in various consulting sessions and provided support in statistical analysis including choice of experiment design, management of data, statistical procedures for analyzing experiments, interpretation of the results, statistical modeling and statistical computing
• Developed macros for cleaning, transforming and modifying the data daily
• Accomplished data manipulation on SAS data sets using techniques such as merging, appending, concatenating and sorting
• Extensively used statistical procedures like PROC FORMAT, PROC MEANS, PROC FREQ, PROC IMPORT, PROC UNIVARIATE, PROC TABULATE
• Extensively used statistical procedures like PROC FREQ and PROC MEANS to compute elementary statistical measures which include descriptive statistics based on moments, quintiles, confidence intervals, frequency counts, correlations and distribution tests
• Applied statistical techniques to analyze and validate the model implementations
• Created queries to generate HTML reports and tables using PROC SQL, PROC TABULATE and PROC REPORT to update the data daily

Environment: Base SAS v9.2, SAS/Macros, SAS/SQL, SAS/ACCESS, SAS/STAT, SAS/ODS, Windows XP.

Confidential

SAS Programmer

Responsibilities:

• This project involved experiment design to evaluate different strategies for customer retention. Integrated customer data, addressed data issues to create a clean and consistent database. Reading raw data files and manipulating the data sets
• Convert excel data files into SAS data sets.
• Creating SAS datasets by using Base SAS
• Involved in development and enhancement of SAS programs.
• Documentation ,Analysis through using SPSS and SAS
• Created plots using PROC GPLOT in SAS.
• Generating graphs using SAS/GRAPH
• Developed SAS Dataset and generated results into the excel sheets.
• Responsible for retrieving and manipulating datasets using SAS, developing and executing SAS programs in support of statistical modeling projects, coding and running SAS programs for internal process validation, and maintaining and managing teradata.
• As a SAS programmer supported Marketing Team and worked with Statisticians in analyzing the data. Tested whole process Unit, UAT .
• Validation the data using latest SAS functions.
• Used SAS/SQL to pull data out of a relational database and aggregate to provide detailed reporting based on the user requirements.
• Responsible for providing statistical research analyses and data modeling support for mortgage product.
• Analyzing credit report to determine credit worthiness and performing risk evaluations.
• Ensuring loans are structured and priced consistently with bank policy and commensurate with risk.
• Analyzing and calculating debt to income ratio for evaluating mortgagor's financial risk and provide recommendation to mortgagor to lower debt to income.
• Evaluating and recommending affordable options to mortgagor to help reduce financial loss.
• Run daily report to help determined how many loans are in foreclosure or will be in foreclosure within the next ten days.
• Researched and analyzed all required documents for accuracy such as signature, bank statement.

Environment: SAS 9.3/Base, Windows, SAS/ BASE, SAS/MACRO, SAS/SQL, SAS/GRAPH, SAS/Access, SAS/VIEW, SAS/Enterprise Guide, DB2.

Confidential

SAS Programmer

Responsibilities:

• Developed new datasets and modified the existing ones to create specific datasets as a source for generating reports in Phase I,II clinical trials
• Extracted data and generated ad-hoc reports
• Created TLG's using Proc Report, Proc Means, Proc Sql, Proc Freq, data Null as per the statistician's requirements referring to SAP
• Performed Preliminary Data validation on the clinical trial data
• Used Proc Freq, Proc Univariate and Proc Compare to identify outliers
• Also designed and developed SDTM datasets to simplify the production of CRT's Case Report Tabulations and ADaM datasets for creating statistical summaries and analysis
• Developed Macros for the reusability of the SAS code wherever required
• Responsible for handling and verifying the data to conduct statistical analyses and preparing trial reports
• Provided efficient support to all the team members.
• Imported/Converted randomization data files from Excel, .CSV data files into SAS data sets for analysis.
• Performed SAS Edit Checks on the raw SAS data sets.

Environment: SAS V8, SAS/MACROS, SAS procedures, Microsoft office 2003, Excel, Windows XP

Therapeutic Areas: Oncology, Urology

Confidential

Programmer Analyst

Responsibilities:

• Responsible for data collection, management and manipulation of clinical database.
• Performed statistical analysis, wrote SAS code for data management and reporting, and performed validation, including testing SAS code.
• Prepared clinical data listings and summaries for statistical analysis and analyzed clinical data using SAS system.
• Used SAS for pre-processing data, SQL queries, data analysis, generating reports, graphics, and statistical analyses.
• Maintained clinical trial data base, accessed various database to gather data, performed a table lookup and translated data values for meaning and readability.
• Retrieved data from Oracle using SQL within SAS to be analyzed and exported to Excel for further analysis.
• Created and implemented statistical analysis plans and specification documents
• Supported the research staff for technical and programming help. Worked with Bio statistician to analyze the results obtained from various statistical procedures like PROC ANOVA, GLM, t test.
• Involved in clinical trials programming of data tables and listings for reporting on safety and efficacy.

Environment: SAS 9, SAS/SQL, SAS/BASE, SAS/MACROS, SAS/GRAPH, Oracle 8 PL/SQL, ANOVA, Windows NT and UNIX.

Confidential

SAS Programmer

Responsibilities:

• Provided statistical and analytical support to Consumer Economics, Planned and performed load research studies and analysis.
• Prepared statistical summaries and reports on customer load usage surveys for use in regulatory hearings.
• Developed SAS macros for data cleaning and Reporting and to support routing processing.
• Developed efficient, well-documented, readily comprehensible and modifiable SAS code using SAS/ Base and SAS/ Macro facility.
• Also identified problems with the data, if there were any, and also produced derived data sets, tables, listings and figures, which analyzed the data.
• Produced quality customized reports by using PROC TABULATE, REPORT, and SUMMARY and also provided descriptive statistics using PROC Means, Frequency, and Univariate.

Environment: SAS, Oracle, Developer/2000, Reports 3.0