PROFESSIONAL SUMMARY

• Around 7 years of IT experience with good noledge of SDLC and Project management which includesSASprogramming, advanced statistical methodologies applied in Pharmaceutical and Biotech industries and in Verilog Requirement gathering, design, development, testing and implementation.
• Experience in Data manipulation and producing reports employing variousSASprocedures like PROC SQL, PROC REPORT, PROC TABULATE, PROC FREQ, PROC MEANS, PROC UNIVARIATE, PROC SUMMARY, and PROC CONTENTS.
• Expertise in analyzing and reporting various phases (Phase I - IV) OfClinicalTrials using tools like BaseSAS,SAS/STAT,SAS/GRAPH,SAS/SQL,SAS/MACRO,SAS/ACCESS andSAS/ODS SAS/VA in UNIX and Windows environment.
• Experience withSASBusiness Intelligence Platform:SASadd-in for Excel, Information Maps.
• Exposure to CDISC Standards, 21 CFR Part 11, GxP guidelines, Bioethics, IRB guidelines, HIPAA guidelines and Regulatory Submissions (CSR, BLA, NDA, including ISE and ISS).
• Proficient in understandingclinicaltrials study designs, study protocols, statistical analysis plans, (SAP), case report form (CRF/eCRF), annotated case report forms and company Standard Operating Procedures (SOP)
• Experience in using data steps inSASfor creating, maintaining and manipulating datasets.
• Expertise in analyzing and coordinatingclinicaltrial data, generating reports, tables, listings and graphs usingSASin accordance with teh Statistical Analysis Plan (SAP), Standard Operating Procedures (SOPs) and departmental guidelines.
• Experience with exportSASResults to different format, such as XML, Excel usingSAS/Export, SAS/ODS for reporting and presentation using SAS/VA.
• Good programming skills such as implementation of Arrays, Macros and making teh program self-explanatory using various comments and follow SOP.
• Extensive use ofSAS/ACCESS,SAS/CONNECT to connect to various databases such as development and production database (DB2 on UNIX) and experience in performing batch mode.
• Experience in using BaseSASprocedures such as Proc Freq, Means, Summary, Univariate, Format, Import, Export, Report, Tabulate, Transpose, Datasets, Copy and Print.
• Exposure to CDISC Standards, 21 CFR Part 11, GxP guidelines, Bioethics, IRB guidelines, HIPAA guidelines and Regulatory Submissions (CSR, BLA, NDA, including ISE and ISS).
• Experience in Data analysis and Reporting in health care, finance and marketing sectors.
• Experience in writing SDTM mapping specifications and ADaM specifications.
• Experience on accessing Web Reporting and Information delivery portal.
• Experience in usingSASto read, write, import and export to another data file formats, including delimited files, Spreadsheet, Microsoft Excel and Access tables.
• Experience in developing and maintaining statistical documentation, including description of statistical methods,SASprograms, results and discussion.
• Excellent experience with exportSASResults to different format, such as XML, Excel using SAS/Export,SAS/ODS for reporting and presentation.
• Experience in working withSASEnterprise Guide Software for reporting and analytical tasks.

PROFESSIONAL EXPERIENCE

SASProgrammer/Analyst

Confidential - Plainsboro, NJ

Responsibilities:

• Maintained large data sets, combining data from various sources in varying formats to createSAS data sets by using Set and Merge for generating Reports and Graphs.
• Predicting teh effectiveness of treatment and reporting them to teh clients.
• Created complex and reusable Macros and extensively used existing macros and developedSAS Programs for Data Cleaning, Validation, Analysis and Report generation.
• Extensive experience in cleaning teh raw data and deleting duplicates. Created reports in PDF, HTML, XML and RTF usingSAS/ODS statements & Data NULL techniques.
• Produced Listings, Reports, Tabulations and Summaries of teh Claim and Medical service data using procedures such as Freq, Means, Univariate, Summary, Tabulate, Report, and Transpose for statistical analysis.
• Created tables usingSASMacros,SASProc SQL, and optimizing programs by using advanced SASProgramming techniques for development.
• Independently write, maintain and runSASprograms to produce desired outputs related to one or more aspects of a clinical trial and other assigned programming tasks.
• Perform analyses of data related to product development in an R&D environment, usingSASto create and maintain tables, listings, figures (TLF), and other outputs.
• Performed data validation and edit checks on ADaM datasets and TLG's for Phase I, II and III studies using variousSASprocedures and Macro facility.
• UsedSASProc SQL pass through facility to connect to Oracle tables and createdSASdatasets using various SQL joins such as left join, right join, inner join and full join.
• Created Integrated Summary of Safety (ISS) and Integrated Summary of Efficacy (ISE) reports documenting experimental drugs, usingSAS.

ClinicalSASprogrammer

Confidential - Irwindale, CA

Responsibilities:

• Independently write, maintain and runSASprograms to produce desired outputs related to one or more aspects of a clinical trial and other assigned programming tasks.
• Perform analyses of data related to product development in an R&D environment, usingSASto create and maintain tables, listings, figures (TLF), and other outputs.
• DevelopedSASMACRO codes for data manipulation, data analysis, statistical analysis and routine report generation in batch mode.
• Created tables, figures and listings as per teh client specification using proc REPORT, proc MEANS, proc FREQ, proc FORMAT, proc GPLOT and DATA NULL for data presentations.
• Performed data validation and edit checks on ADaM datasets and TLG's for Phase I, II and III studies using variousSASprocedures and Macro facility.
• Data inform of text files were imported and created graphs using R.
• Developed SDTM datasets (CDISC standards) from raw data and ADaM datasets from SDTM datasets.
• Designed and developed code usingSAS/EG to support ad hoc requests & automated teh standard reporting withSASWeb Report Studio and Microsoft Add-in and scheduled jobs via EG.
• Developed Python batch processors to consume and produce various feeds.
• Developed internal auxiliary web apps using Python Flask framework with CSS / HTML framework.
• Extracted data from Oracle database transformed and loaded into Teradata database according to teh specifications.
• Extracted data from different sources like Oracle and text files usingSAS/Access,SASSQL procedures and createdSASdatasets.
• DevelopedSASMacro programs to create ad-hoc reports.
• Extensively usedSAS/Macro facility to create macros for statistical analysis, results reporting and data extraction.
• CreatedSASlistings and tables in PDF, RTF formats usingSASODS.

SASAnalyst/Developer

Confidential - Atlanta, GA

Responsibilities:

• Worked with business users to design and develop several ad-hoc reports and information maps using Proc Report and Proc Tabulate.
• Teh reports created include Monthly summary reports as well as detailed weekly reports.
• Developed online claims reporting system to retrieve client records and createSASProc tabulate tables, Proc Freq, Proc Means, and Proc Report.
• Extensively usedSASData Steps, Statistical models, and Flowchart Design, Listing, Graphing, Summarizing and Reporting procedures.
• DevelopPerlcontrol programs to support data load into teh new systems UsedSASProc SQL
• Pass through facility to connect to Oracle tables and createdSASdatasets using various SQL joins such as left join, right join, inner join and full join.
• UsedSASEnterprise Guide to access data, to manage data, to create reports and to validate data and data mining.
• Involved in Physical modelling on Teradata such as creation of tables, indexes and views.
• Created and delivered reports and presentations with key findings and recommendations.
• Provided technical support onSASprogramming related to data manipulation and analysis.
• Wrote macros, developed conciseSASscripting and used SQL to concatenate and join datasets from different database management systems using indexes and loops
• Created various transformation procedures by usingSASETL andSASEnterprise guide.
• SASProcedures used are Proc Append, Macros, Import and Export, Proc Transpose, Proc Datasets.
• Collected and maintained teh customer information through CIS.

SASProgrammer

Confidential -

Responsibilities:

• Cleaned data using Data Step andSASBase procedures.
• Assigned formats and labels to teh variables in analysis data sets.
• Generated tables and listings using Proc Print, Proc Report and Proc Tabulate.
• Generated summary reports and descriptive statistics using Proc Means, Proc Freq, and
• Responsible for data validation and corrections - upload and /or download data.
• Developing analysis plans including specifications for Tables, Listings and Figures
• Modification of existingSASprograms and creation of new programs usingSASMacros.
• Involved in writing codes using BASESASandSASMacros to extract, clean and validate data.
• Provided data management deliverables such eCRF specifications, Data Validation Specifications (DVS) and review teh data management plan.
• CreatedSASreports using teh Data Null technique and Proc Report for NDA submission as per FDA regulations and company standards.
• CreatedSASCustomized Reports using teh Data Null technique.
• SAS/STAT procedures such as UNIVARIATE, FREQ and MEANS were used to carry out analyses and theSASREPORT procedure is generally used to display results.
• Coded data using WHODRUG and MedDRA standards.
• Experienced in handling Terabytes of records and manipulating them throughSAS.
• Analysis included Fleet Size Analysis, Segmentation, Predictive Modelling, etc.
• Cleaned existing data and converted them into usefulSASdatasets, merged datasets and created reports based on ad-hoc requirements.
• Extracted data from Oracle database transformed and loaded into Teradata database according to teh specifications.

Jr.SASProgrammer

Confidential

Responsibilities:

• Mapped teh data from different sources performing data mining techniques for cleaning and accuracy of teh data for model executions.
• Developed statistical models from reading documentation from statisticians converting toSAScode and gathering teh requirements for data from data modellers.
• Conducted programming usingSASto meet teh challenges of advanced data manipulation, complex programming logic, and extremely large datasets from 40 to 80 M records.
• Interpreting, documenting, and communicating results/methodology with teh project team and clients.
• Performed variety of tasks including data extraction, manipulation, Analysis using claims data.
• UsedSASEnterprise Guide to access data, to manage data, to create reports and to validate data and data mining.
• Communicated with Quantitative RiskAnalystsand Financial Engineers/Modellers to understand and to document quantitative models for valuing complex securities, simulating historical, statistical and theoretical market states/scenarios, computing deterministic and stochastic security and portfolio level risk measures.
• Tested and executed marketing campaigns usingSASMarketing Automation.
• Created various transformation procedures by usingSASETL andSASEnterprise guide.
• SASProcedures used are Proc Append, Macros, Import and Export, Proc Transpose, Proc Datasets.
• Designed, developed, and tested software to implement teh models usingSAS, mathematics/statistics/financial procedures.
• Developed high quality code that is efficient, supportable, and follows industry best practices.
• Coordinated and supported teh testing of models by executing tests and providing results and supporting data.

Environment:SAS/Access,SAS/Base,SAS/Macro,SAS/Stat,SAS/Graph,SAS/SQL, Oracle, MS Office, and UNIX

TECHNICAL SKILLS

SASskills: BaseSAS,SAS/Macro,SAS/Connect,SAS/SQL,SAS/STAT,SAS/BI,SAS/ETL, SAS/Graph,SAS/IntrNet,SAS/ODS,SAS/Access,SASEnterprise Guide, Enterprise Miner,SAS Stored Processes Web Application,SASWeb Report Studio,SASInformation Map Studio,SAS Forecast studio,SASDI Studio and Management Console.

SASProcedures: Print, Transpose, Contents, Means, Chart, Plot, Tabulate, Univariate, Summary, Sort, Reg, SQL, Copy, Freq, Forms, Upload, Download, and Formats

Programming Language: SAS, SQL, C/C++, JAVA, HTML, XML, PL/SQL, VHDL / Verilog HDL, PERL, SystemC, System Verilog

Software packages: MS Word, Advanced MS Excel, MS PowerPoint, and SQL Plus

Databases: MS Access, SQL Server, MySQL, Teradata, and Oracle

Reporting Tools: BaseSASversions … SASEnterprise,SASGraph, MS-Excel,SASBI Platform, SPSS MS-Visio and MS-PowerPoint.

Operating Systems: Windows, Unix, Linux and Mac