SUMMARY:

• Over 12 years of experience in programming, analyzing and reporting in various Pharmaceutical, and Healthcare and Finance using SAS on Windows, Unix and Mainframes environment.
• SAS Certified Programmer
• Extensive hands-on expertise using Informatica 8.x/9.x and Erwin Data Modeler with strong business understanding of pharmaceutical sectors.
• Worked in SAS tools such as Base SAS, SAS/Macro, SAS/SQL, SAS/ACCESS, SAS AF/SCL, SAS/Graph, SAS/ODS, SAS/Connect and SAS/STAT.
• Proficiency in writing maintainable, flexible and well-documented SAS codes using DATA step and PROC step.
• Excellent knowledge and work experience in data manipulation, data cleaning, sorting, concatenating, stacking, interleaving, merging and combining SAS datasets using SAS/Base and SQL.
• Experience on validation of reports and SAS programs Professional debugging.
• Good knowledge and experience of extracting clinical trial Phase I-IV data from Oracle Clinical or other RDBMS using PROC ACCESS, SQL pass-through facility and Oracle libname engine.
• Worked with Clinicians, Statisticians and Database Team to create analysis datasets and generate Safety and Efficacy Tables, Listings and Graphs TLGs .
• Expert in using report generating procedures like PROC CONTENTS,PROC PRINT,PROC REPORT,PROC TABULATE,PROC FORMAT,PROC FREQ,PROC UNIVARIATE,PROC SUMMARY, and PROC TRANSPOSE.
• Experience in using SAS/STAT procedures like PROC ANOVA, PROC GLM, PROC REG,PROC TTEST,PROC RANK,PROC NPAR1WAY, PROC LIFETEST, and PROC PHREG
• Worked in Mainframes, Unix and Windows versions of SAS.
• Has firm understanding of Life Science, FDA ICH-GCP Guidelines, HIPAA and 21 CFR Part 11 guidelines.
• Good working experience/knowledge of CDISC SDTM, ADaM, and define.xml
• Experience in writing Standard Operating Procedures SOPs and process documents.
• Good knowledge and experience in Systems Analysis, Design, Engineering and Programming.
• Well versed with JCL and Unix scripting languages.
• Worked SQL-Server, MS-Access, Oracle, and DB2 RDBMS.
• Working experience in SQL Plus, Toad and SQL Navigator
• Good Knowledge of Clinical Trials Data Management using Oracle Clinical 4.5.3. and OC backend tables.
• Knowledge of Database Design, GLIB, Definition, Validation Procedures, and Derivation Procedures.
• Experience performing problem troubleshooting, problem resolution, and root cause analysis for application and batch related issues.
• Excellent communication, analytical and problem solving skills.
• Highly motivated and productive.

Skills:

SAS Tools : Base SAS, SQL, Macro, STAT, Graph, Connect, Access etc.

ETL Tools : Informatica 7.x., Cognos Decision Stream, Data Stage

Data Modeling Tools: Erwin 4.x

Languages : C, PL/SQL, Java 2.0, Shell Scripts, PERL.

GUI/Tools : Developer 2000, SQL Plus, VB 6.0

RDBMS : Oracle 7.x/8i/10g, MS Access, DB2, SQL-Server 2005, Teradata

OS : Windows 95, 98/NT, MS DOS, Unix, OS/390

Internet Tools : JavaScript, Visual Interdev, HTML,VB Script

Other Tools : Cognos, TOAD 8.x/9.x, SQL Navigator 5.5 and SQL Plus Database tool

EXPERIENCE:

Confidential

Roles:SAS Developer

Responsibilities:

• Gathered and documented business requirements and managed requirements.
• Involved in Data profiling, data cleansing, developing the extraction process of data from different sources using Informatica, PL/SQL and performing transformations and finally loading the data into Oracle database for reporting.
• Creates and implements Informatica work flows in Windows environments.
• Acted as main POC for Users, Development and Testing teams for all the requirements related issues.
• Development of SAS programs for report generation.
• Created use case diagrams and use case specification documents as required.
• Created context diagrams, Business Process flows, Data flows, and required deliverables as per standards.

Environment: SAS 9 version, TOAD, SQL Navigator, SAS/BASE, SAS/MACRO, SQL, SAS/Connect, SAS/Share, Informatica 9.1, Oracle PL/SQL, MS-Office, WIN-NT etc.

Confidential

Roles: Technical Lead, SAS Developer

Responsibilities: Includes analysis, design and Architecture of existing and new functionalities of CDARS and Data Transformer applications. Worked on design, develop, testing and implementation of CDARS application which is web based system for analysis and reporting Phase I- Phase IV clinical trials, and DT application is being used to map legacy data to Pfizer Data Standards which are in compliance with CDISC standards. Daily coordinating with Off Shore Development along with Business Sponsor and End Users.

Environment: SAS 9 version, Perl, TOAD, SQL Navigator, SAS AF/SCL, SAS/BASE, SAS/MACRO, SQL, SAS/Connect, SAS/Share, Unix, MS-Office, WIN-NT etc.

Confidential

Roles: Technical Lead, Analyst, SAS Developer

• Analysis, design and Architecture of existing and new functionalities of Health First SAS based Datawarehousing system.
• Worked on design, develop, testing and implementation of Health First application which is built completely on SAS.
• Design the Jobs and scheduling the jobs based on dependency and load the data into warehouse and data mart.
• Coordinated UAT User Acceptance Testing created UAT Plan, Test Cases and UAT summary report as part of the standard Project deliverables documentation.
• Created RTM Requirement Traceability Matrix to associate Test Cases and requirements UAT .

Environment: SAS 9.1 Base, Macro, SQL, ACCESS, Share, Connect , SQL Server, PowerMHS, Windows etc.

Confidential

Roles: Technical Lead, Analyst, SAS Developer

Responsibilities: Includes analysis, design and Architecture of Windows based Analysis and Reporting Tool built with SAS. Worked on design, develop, testing and implementation of Analysis and Reporting tool which is SAS based application for analysis and reporting Phase I- Phase IV clinical trials. Designed and developed complex SAS programs to extract SAS views and formats from Oracle Clinical Database, SAS programs for Edit Checks and Data Cleansing, and Graphical User Interface GUI using SAS AF/SCL to view Listings, Tables and Graphs.

Environment: Base/SAS, SAS/Macro, SAS/STAT, SAS AF/SCL, SAS/ACCESS, SAS/SQL, SAS/STAT, SAS/ODS, Windows etc.

Confidential

Roles: Technical Lead, Statistical Programmer

Responsibilities: Includes programming support of research data management, and analytic requirements. Responsible for database and statistical programming, programming for standard report generation, ad-hoc queries, analyses, data manipulation, and extraction. Using Clinical Data Analysis and Reporting System CDARS application for Extraction of Oracle Clinical data and standard report generation of phase I-IV clinical trials. Provide database, analytical and statistical programming support to research protocols. Support nonstandard reporting using Pfizer Data Standards.

Environment: CDARS application, SAS/BASE, SAS/MACRO, SAS/STAT, SAS/ACCESS, SAS/ODS, SAS/SQL, SAS/STAT, Unix, MS-Office, WIN-NT etc.

Confidential

Roles: Technical Lead, Business Analyst, SAS Developer

Responsibilities:

• Involved in functional analysis and gathering the information from client as per the project requisites.
• Worked on design, develop, testing and implementation of Business Intelligence for the new systems.
• Also involved data sourcing, data profiling, data cleansing, data mapping, developing extracting process of data from different sources using SAS and performing the Transformations and load the data into SAS datawarehouse for Reports.
• Design and develop SAS programs for reporting.

Domains: Finance

Environment: SAS/BASE, MACRO, SAS/SQL, SAS/ACCESS, Unix, Shell-script, MS-Office, WIN-NT etc.

Confidential

Role: Technical Lead, SAS Developer

Responsibilities:

• Participating in the review process of study documents such as the CRF, edit specifications written by Data Management, and Statistical Analysis Plans.
• Designed and developed SAS programs for creation of Analysis SAS data sets using Eli Lilly standards which are compliance with CDISC ADaM.
• Programming data cleaning checks, as necessary, to facilitate Data Management's data cleaning activities.
• Using WHODRUG dictionary for Concomitant and MedDRA dictionary for Adverse Events and Medical History data.
• Coordinated UAT User Acceptance Testing created UAT Plan, Test Cases and UAT summary report as part of the standard Project deliverables documentation.

Domains: Clinical

Environment: SAS/BASE, SAS/MACRO, SAS/ACCESS, SAS/SQL, MS-Office, WIN-NT etc.

Confidential

Roles: Analyst, SAS Developer

Responsibilities:

• Participating in the review process of study documents such as the CRF, edit specifications written by Data Management, and Statistical Analysis Plans.
• Data extraction from Data Capture application AS/400 .
• Designed and developed SAS programs for creation of Reformat SAS data sets.
• Designed and developed SAS programs for creation of Analysis SAS data sets using Eli Lilly standards which are compliance with CDISC ADaM.
• Creation of efficacy SAS datasets.
• Creation of Safety and Efficacy SAS datasets for reporting.
• Programming data cleaning checks, as necessary, to facilitate Data Management's data cleaning activities.

Domains: Clinical

Environment: SAS/BASE, SAS/MACRO, SAS/ACCESS, JCL, TSO, MVS, DB2, OS/390, MS-Office, WIN-NT etc.

Confidential

Roles: SAS Developer

Responsibilities:

• Develop and testing and implementation of FSDR, Operations Summary, Cancel Summary, and Equipment reports built in SAS.
• Scheduling the jobs.

Environment: SAS/BASE, SAS/MACRO, SAS/ACCESS, SAS/SQL, JCL, DB2, OS/390, MS-Office, WIN-NT etc.

Confidential

Roles: SAS Developer

Responsibilities:

• Involved in functional analysis and gathering of the data as per the project requisite.
• Extracting data from SQL Server into SAS data files using SAS SQL 'Pass Through Facility'.
• Developing application for cleaning and scrubbing the data.
• Involved in development and enhancement of SAS programs.
• Generated graphs using SAS/GRAPH.

Environment: SAS/SQL, SAS/MACRO, SAS/BASE, SAS/GRAPH, SQL-Server, MS-Excel, MS-Access, WIN-NT etc.