SUMMARY:

• About 6 + years of professional experience of SAS programming in Clinical, Biotechnological, Pharmaceutical and Software Industries.
• Experience in SAS BI components - SAS Data Integration Studio, SAS Enterprise Guide, SAS Enterprise Miner, SAS OLAP Cube Studio, SAS Web Report Studio, SAS Information Map Studio, SAS Information Delivery Portal, SAS BI Dashboard, SAS Management Console and SAS Add-In for Microsoft Office
• Experience in back-end database such as Oracle, MS-Access, SQL Server, Teradata, and DB2 .
• Extensive Experience in SAS/BASE, SAS/STAT, SAS/MACROS, SAS/SQL, SAS/CONNECT, SAS/ACCESS, SAS/ODS, SAS/ENTERPRISE MINER, SAS/ENTERPRISE GUIDE, SAS/ETL.
• Extensive experience in SAS/REPORT generating procedures like PROC SUMMARY, PROC FREQ, PROC MEANS, PROC UNIVARIATE, PROC TRANSPOSE, PROC FORMAT, PROC REPORT and PROC TABULATE etc.
• Good experience using SAS/GRAPH procedures, exclusively PROC GPLOT.
• Generated Reports, Tables, Listings, Graphs and Summaries as per company standards and in compliance with 21 CFR Part 11, FDA, NDA and other regulatory compliance.
• Interacted with senior Bio-statisticians and clinical data managers to provide SAS programming in analyzing the data, generating reports, tables, listings and graphs.
• Experience in SAS/ETL (Extraction,Transformation and Loading) with Oracle/Access connectivity
• Worked on phase II, Phase III & phase IV Clinical Trials, performed clinical data analysis and generated SAS datasets in accordance with the SOPs and guidelines
• Experience in Integrated Summaries of Efficacy (ISE) and Safety (ISS) according to Statistical Analysis Plan (SAP) and Protocol.
• Exposure to clinical trial data such as demographic data, Adverse Events(AE), Serious Adverse Events(SAE), Laboratory data (Lab data) and Vital Signs.
• Generated tables, listings, and graphs according to Statistical Analysis Plan, Standard Operating Procedures (SOPs) and departmental guidelines
• Performed data extraction from Databases and Flat files. Conversion of SAS Datasets to various file types (including Excel, PDF flat files).
• Generated Output files in RTF, HTML and PDF using SAS/ODS
• Expertise in Code of Federal Regulations (21 CFR PART 11)
• Good Experience in CDISC processes such as SDTM, ADaM, ODM
• Good experience in working with different PK/PD documents
• Strong working knowledge of FDA regulations, ICH Guidelines and GCP requirements.
• Ability to work on multiple tasks and strong interpersonal, analytical and presentation skills.
• Excellent in analytical, presentation, communication and problem solving skills and work independently as well as in a team

TECHNICAL SKILLS:
SAS Tools: SAS V8,V9.1,SAS/MACROS, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/ACCESS, SAS/CONNECT, SAS/REPORTS,SAS/ODS,SAS Enterprise Miner, SAS Enterprise Guide
SAS Procedures: Report, Print, Freq, Means, Summary, Univariate, Sql, Sort, Transpose Contents, Options, Import, Export, Format, Anova, reg, Gplot,GLM, TEMPLATE

Statistical Tools: SPSS, R, S-plus, Minitab, JMP,SPOT FIRE
Operating Systems: Windows 95/98/NT,XP 2000, UNIX.
Programming Languages: SQL, PL/SQL, MATLAB,BASIC C,ORACLE.
Web Technologies:HTML,DHTML,XML,ADOBE PHOTO SHOP
Office Tools:MS-OFFICE,MS-ACCESS,MS-WORD,MS-EXCEL.

EDUCATION:
Bachelors in Pharmacy

CERTIFICATION:
Certified Base SAS Programmer For SAS 9.

WORK EXPERIENCE:

Confidential,Cambridge, MA Oct 09 – Present
SAS Programmer Analyst – Clinical Trials

Confidential,is a biopharmaceutical company developing products designed to improve life of patients and is conducting Phase I to Phase IV clinical trails, in wide range of viruses, bacteria and parasites, and has demonstrated its ability to remove proteins, while preserving the therapeutic properties. As a SAS programmer my role is in analysis of Clinical trail data and generating required reports, listings and summaries for submission to FDA.

Responsibilities:

• Performed SAS programming on SAS Base, Macro language. Used data manipulation techniques, and statistical procedures (e.g., PROC UNIVARIATE, PROC FREQ, and PROC REPORT, PROC TABULATE, PROC SQL, PROC TRANSPOSE, PROC SUMMARY, PROC MEANS and DATA _NULL_ etc).
• Created SAS datasets to be used for the analysis programs.
• Extensively used SAS/ Macro facility to provide reusable programs that can be conveniently used time to time.
• Modified UNIX scripting for SAS batch jobs in development.
• Develop database procedures, triggers and SQL scripts for development teams.
• I have extensive experience in creating DEFINE.pdf formats in submission of docs to FDA.
• Performed Data analysis, generated reports, listings and graphs using SAS Tools – SAS/Base, SAS/Macros and SAS/Graph, SAS/SQL, SAS/Connect, SAS/Access.
• Well versed in writing UNIX korn, bash shell scripts and scheduling korn, at jobs for timely event trigger processes.
• Developed routine SAS Macros to create tables, graphs and listings for inclusion in clinical study reports and regulatory submissions and maintained existing ones.
• I have extensive experience in CDISC and SDTM.
• Experience in Integrated Summaries of Efficacy (ISE) and Safety (ISS) according to Statistical Analysis Plan (SAP) and Protocol.
• I have Experience in Annotate CRFs in accordance with CDISC published or sponsor specific guidelines with appropriate metadata to reflect case report tabulation (CRT) data sets.
• Produced accurate, precise tables and graphs for Clinical Study Reports by conducting, documenting and reporting computer validation inspections in compliance with 21 Code of Federal Regulations (21CFR) Part 11, FDA and other regulatory compliance.
• Generated tables, listings and reports of Adverse Events (AE) and Serious Adverse Events (SAE) and was also involved in validating the programs of integrated summaries of safety (ISS) and efficacy (ISE).

Environment: SAS 9, SAS/BASE, SAS/MACROS, SAS/SQL, SAS/STAT, Oracle8, Oracle Clinical, Windows NT and UNIX.

Confidential,Kansas City, MO Nov 08 - Sep 09
SAS Programmer

Confidential,is a privately held investment management firm. Their major criterion is to serve investment professionals, institutions, corporations and individual investors. More than 40 percent of American Century Investments\' profits support research to help find cures for the genetically-based diseases including cancer, diabetes and dementia. I was involved in performing complex analysis on the data.

Roles and Responsibilities

• Used PROC SQL Pass-through facility and Oracle DB Load procedure for data transfer
• Created SAS views from the tables in Oracle database using SAS/ACCESS.
• Involved in the data transfer and data conversion from one platform to the other (SAS to Oracle, Oracle to Excel) and the obtained data was used for further analysis.
• Extensively used statistical procedures like UNIVARIATE, SUMMARY, TABULATE, MEANS.
• Modified existing SAS programs using SAS/MACROS to improve the performance and enhance the data quality and developed numerous decision support reports in a distributive environment for the management department.
• Manipulated data by using MERGE, APPEND, CONCAT, SORT PROCs and generated the reports.
• Generated graphs using PROC GPLOT through SAS/GRAPH and the SAS Graphic Editor.
• Developed efficient, well-documented, comprehensible and modifiable SAS code for ad-hoc jobs using SAS/BASE and SAS/Macro facility.
• Validated data by checking data distribution and by comparing it to a standard data.
• Ran SAS report programs to generate weekly/monthly/annual reports and exported the results to Excel for further analysis.
• undertake daily administration, including monitoring system performance, ensuring successful backups, and developing/implementing disaster recovery plans.
• Environment: SAS V8, SAS/BASE, SAS/MACROS, SAS/SQL, SAS/GRAPH, SAS/ACCESS, SQL, PL/SQL, Windows 2003.

Client : Confidential,
End Client: Confidential,Richmond, VA
Title: Sr. SAS/SAS BI Developer. Dec 07 – Oct 08
Project: Student Success Predictive Model

Confidential,have a 40-year track record of educational excellence and innovation to serve the needs of the citizens and strengthen the Commonwealth’s economy. The mission of the Virginia Community College System is to provide comprehensive higher education and workforce training programs and services of superior quality that are financially and geographically accessible and that meet individual, business, and community needs of the Commonwealth. The Virginia Community Colleges Policy Manual is a living document that guides the operation of all community colleges in the Commonwealth. The Chancellor and State Board for Community Colleges continuously approve changes to spur innovation and maintain the highest standards of performance across the system.

Roles and Responsibilities:

• User Interaction, Analyzed the business requirements, written the functional specifications, design, development, verification, technical/user documentation, training, and mentoring
• Created the ER Diagrams with TOAD from oracle database
• Created the SAS Data marts from Oracle Data warehouse
• Performed the ETL by using the SAS Data Integration Studio
• Written the macros, used the PROC SQL Pass through Facility and written the complex SQL queries
• Proficient in the maintenance and analysis of large data sets
• Developed the Predictive models with SAS Enterprise Miner to find the Student success/risk
• Created the OLAP Cubes with dimensions, hierarchies and measures by using the OLAP Cube Studio
• Created the Information Maps by using the Information Map Studio
• Created the static and parameter driven Reports by using the Web Report Studio
• Published the Reports to the SAS Portals
• Written and registered the Stored processes, worked on front end development using JSP, HTML, Javascript
• Analyzed, generated the ad-hoc and regular reports for various levels of users
• Performed peer reviews of work items produced at various stages of the project
• Developed Test plans, Test cases, Executed and documented the testing results

Environment: Base SAS 9.1, Macros, SAS/STAT, SAS Data Integration Studio 3.4, SAS Enterprise Guide 4, SAS Enterprise Miner 5.2, SAS OLAP Cube Studio 3.1, SAS Information Map Studio 3.1, SAS Web Report Studio 3.1, SAS Information Delivery Portal 2.0, SAS Management Console, SAS Add-In for Microsoft Office, SAS Stored process, SQL, PL/SQL Developer, Oracle 10g, VSS, Documentum, TOAD, FTP, SunOS 5.10 platform, Java, JSP, HTML, Javascript

Confidential,Princeton, NJ Sep 06 – Nov 07
Sr. SAS Developer & Tester

Confidential,is a global pharmaceutical and related health care products company whose mission is to extend and enhance human life. Bristol-Myers Squibb\'s 43,000 employees are dedicated to discovering, developing and providing innovative medicines that address significant medical needs of patients worldwide. And by living our mission and growing our company for well over a century, we are also making a difference in the lives of our shareholders, employees and neighbors.

Roles and Responsibilities

• Analyzed application requirements, provided recommended design and created application from detailed specifications
• Developed and tested the Statistical Analysis and Reporting (SA&R) Application in Unix environment
• Written the Stored processes, created detailed project outlines and application design specifications
• Worked on front end development (GUI interfaces) by utilizing ODBC to connect to the Open Architecture RDBMS (Relational Database Management Systems) such as Oracle and Sybase
• Coded, tested, debugged, documented and maintained programs
• Used the PROC SQL Pass through Facility and written the complex SQL queries
• Quality reviews of code developed by other development staff
• Developed Test plans and Test cases, Executed and documented the testing results
• Reviewed data to verify integrity and consistency for completeness, accuracy and suitability, including data adherence to protocol, data coding integrity, reliability of collection and interpretation
• Created SAS programs according to requirements specifications and followed SOPs to produce accurate and timely results
• Maintained organized, complete and up-to-date study documentation, testing and validation/quality control documents and programs in compliance with company standards.

Environment: SAS 9.1, SAS Macros, SAS/ODS, SAS ETL, SAS Enterprise Guide, SAS Enterprise Miner, SAS Stored process, SAS/Graph, SAS/STAT, SQL, Oracle, UNIX - Sun Solaris, SQL, VSS, Documentum, FTP, Java, JSP, HTML.

Confidential,Coralville, IA Jan 06 – Aug 06
SAS Programmer/Analyst

Confidential,main aim is to transform the way serious diseases are treated. Vertex’s drug discovery platform has been highly productive and is the source of key product opportunities in infectious diseases, cystic fibrosis, inflammatory disease, cancer and other areas.

Responsibilities.

• Worked closely with the research team of scientists to analyze the data, generate the reports, and list them according to specifications.
• Involved in analyzing, writing clinical trial reports and presenting clinical trial results.
• Generated the required SAS datasets from the database using sorting and merging techniques.
• Performed Data conversions, Data corrections, Uploading/Downloading the data.
• Developed and summarized clinical trials data using SAS/STAT procedures such as PROC CORR,PROC REG, PROC ANOVA, PROC GLM and Data step programming.
• Extensively used SAS procedures such as PRINT, REPORT, TABULATE, FREQ, MEANS, SUMMARY and TRANSPOSE for producing ad-hoc, customized reports and external files.
• Created Custom reports using DATA_NULL_ and PUT statements.
• Designed flowcharts indicating the input data sets and the techniques that would be used (sorting, merging, etc) to get the desired output.
• Used SAS Macro functions to simplify the process and get consistent results.
• Using SAS/Macros, reports were updated on a monthly basis according to the schedule.
• Used SAS/ODS to create HTML, RTF and PDF outputs files in the process for producing reports.
• Developed the programs for generating Efficacy (ISE) and Safety (ISS) tables.
• Based on the specification document created CDISC-SDTM SAS datasets following all the standards.
• Involved in creating transport files as per the CDISC standards for electronic submissions to the FDA.
• Worked with validation team to validate the applications in compliance with 21 CFR Part 11 and other FDA mandatory regulations.
• Reviewed study Protocol, Annotated Case Report Form (ACRF), and performed validation of clinical trial data to identify illogical data entries.
• DoneDesign, development, testing, review (test data), integration testing, redesign, transfer program and leading the study team.
• Involved in data transmission and integrity checking of the existing and in-house clinical trial systems.

Environment: SAS V8.2, SAS/BASE, SAS/STAT, SAS/ODS, Oracle 8i, SQL, MS-Excel, Windows 2000, UNIX (Solaris).

Confidential,Hyderabad, India Jul 04 – Dec 05
Software Analyst

Confidential,is a leading research-based pharmaceutical company with a broad pharmaceutical product line and wide variety of vaccine products, over-the-counter (OTC) medicines, oral care products and nutritional healthcare drinks. As an analyst, performed relevant statistical analysis of administrative and automated claims databases, surveys and economic data, captured during clinical trials. Performed quality control (QC) checks against database to ensure correct data was entered.

Roles and Responsibilities:

• Responsible for data collection, management and manipulation of clinical database
• Performed statistical analysis, written SAS programs for data management and reporting, and performed validation, including testing SAS programs
• Downloaded data from Oracle using SQL within SAS to be analyzed and exported to Excel for further analysis
• Compared consistency of SAS variables, formats, and format codes across multiple studies
• Created standardized datasets from the existing datasets
• Created validation programs to validate the standardized datasets
• Produced quality customized reports using various procedures

Environment: Base SAS, SAS/ Macros, SAS/Access, Oracle, SQL,Excel

Confidential,Chennai, India Nov 03 - Jun 04
SAS Programmer

Confidential,are pioneers in manufacturing parental products. The innovation, knowledge and experience accumulated in organization are pivotal for getting safe and efficacious drugs.It is one of the reputed Biopharmaceutical companies in India and is involved in developing new sterile products, vials,ampoules and also parentral allopathic formulations in injections

Responsibilities:

• Worked on phase II and phase III clinical trials
• Produced derived data sets, listings, tables for data analysis.
• Worked with statisticians and data managers
• Used various BASE SAS procedures such as proc print, proc mean, proc freq, proc report
• Used SAS/ACCESS to import and export data to and from MS Access and Excel
• Responsible for choosing appropriate statistical techniques relevant for the analysis of data
• Used SAS/GRAPH to generate figures as per Statistical Analysis Plan
• Developed SAS programs to validate the data and used different validation techniques such as proc univariate, proc mean, and proc freq
• Export and import SAS datasets from and to excel

Environment: BASE SAS, SAS/MACROS, SAS/STAT, SAS/GRAPH, SAS/ACCESS, WINDOWS NT, SAS V8,SAS/SQL, ANOVA, PL/SQL.