PROFESSIONAL SUMMARY:

• Certified SAS Programmer with 10+years of experience in Statistical Modeling, Programming, Validation, Analysis, Reporting with SAS in Pharmaceutical/ Biotech/Financial industry.
• Proficient in SAS/BASE, SAS/SQL, SAS/MACROS, SAS/GRAPH, SAS/STAT, SAS/ODS, SAS/ACCESS.
• Extensive experience in processing datasets for data transformation including data cleaning, data profiling and applying business logic rules to incoming data.
• Experience in design, writing and debugging the macro routines and applying macro variables in a SAS program.
• Developed SAS programs that generates ADS, generate efficacy tables, Safety Tables, Listings and Figures as specified in Statistical Analysis Plan and Validate the outputs.
• Provide Statistical Programming support for Clinical trial data reporting under the general guidance of Biostatistician.
• Contribute to the development and Implementation of programming and reporting standards.
• Involved in phases I, II, II and IV of Clinical Trials as part of clinical research biostatistics and programming department requirement.
• Involved in creating SDTM, ADAM datasets.
• Contribute to the development of a macro library and optimize the programs.
• Worked on therapeutic area s such as Ophthalmology, Diabetes, Oncology, etc.
• Worked closely with data management to assure data quality and consistency.
• Experienced in Base SAS procedures such as PROC FREQ, MEANS, SUMMARY, UNIVARIATE, LIFETEST, LOGISTICS, FORMAT, IMPORT, REPORT, TABULATE, TRANSPOSE, DATASETS, COPY, PRINT and SQL.
• Generated safety and efficacy analysis datasets based on dataset specifications using SDTM, ADAM standards.
• Involved in Developing, Debugging, and validating the project - specific existing SAS programs to generate derived SAS datasets, summary tables, and data listings according to departmental standards.
• Created complex and reusable Macros and extensively used macros and developed SAS programs for Data Cleaning, Validation, Analysis and Report generation. Tested and debugged existing macros.
• Formatted HTML, PDF and RTF reports, using SAS/ODS system.
• Knowledge of ICH-GCP guidelines, 21 CFR Part 11, and CDISC standards for regulatory submissions.
• Provided input in developing specifications of analysis datasets, validation plans, and other related documents
• Creation of SAS data sets from external files using Import techniques and data manipulation of datasets using SET, MERGE and Conditional statements.
• Worked on Linear Regression, ARIMA,STATESPACE Models
• Extensive experience in using SAS Functions, Statements, Formats and Informats.
• Experience of Statistical Models for Predictive Modeling in Capital markets, Currency and Commodities.
• Modeling, Simulation of various Options Trading Strategies, Back Testing using SAS and responsible in strategy adjustments and performance tracking .
• Proficient in Excel VBA and Macros, Spread sheets preparation for various Pricing models.

SKILL:

SAS Tools: SAS/BASE, SAS/MACRO, SAS/SQL, SAS/DI, SAS/EG

Languages: R, Python, C, C++,VBA

Operating Systems: Windows, LINUX.

Databases: Oracle, MYSQL, SQL Server, MS Access

PROFESSIONAL EXPERIENCE:

Confidential, CA

SAS Programmer

Responsibilities:

• Develop SAS programs that generate Tables, Listings and Figures using SAS EG .
• Provide Statistical Programming support for Clinical trial data reporting under the general guidance of Biostatistician.
• Develop SAS codes to generate ADS, generate efficacy tables, Safety tables. Validate the outputs.
• Contribute to the development and Implementation of programming and reporting standards.
• Contribute to the development of a macro library and optimize the programs.
• Creation of SDTM datasets, ADAM datasets using CDISC standards
• Create complex and reusable Macros and extensively used existing macros and develop SAS programs for Data Cleaning, Validation, Analysis and Report generation Using SAS DI and developed SAS ETL jobs.
• Work closely with data management to assure data quality and consistency using SAS DI.
• Understand SAP and working with Biostatistician to develop Programs.
• Provide occasional analytical support under the supervision of a Biostatistician.
• Formatted HTML, PDF and RTF reports, using SAS/ODS system.
• Work as per company objectives and satisfy regulatory GCP and ICH requirements and guidelines.

Confidential, NJ

Programmer Analyst

Responsibilities:

• Creation of SDTM datasets, ADAM datasets using CDISC standards
• Perform data validation/QC of SDTM datasets and/or mapping specifications to meet FDA standards
• Programmed to generate safety and efficacy analysis datasets Tables, Listings, Figures and analyses as specified in Statistical Analysis Plans using SAS EG.
• Validated the outputs generated by other programmers.
• Created CRT (Case Report Tabulation) data sets based on CDISC SDTM Submission Data Standards version 2.0.
• Developed SAS Macros to standardize the report generation for re-use with PROC LIFE TEST, PROC REPORT, PROC PRINT, PROC GPLOT, PROC GCHART etc. Generated different tables, listings and graphs as per the request
• SAS programming using various techniques such as SAS Base, SAS Macros
• Protocol and Case Report Forms review and provide comments on the Pharmacokinetics and Pharmacodynamics sections.
• Created DI jobs in SAS DI studio.
• Extract Pharmacokinetics (PK) concentrations from Bio-analytical databases.
• Review Pharmacokinetics (PK) data and communicate the issues with Bioanalyst.
• Prepare PK Analysis dataset specifications.
• Manipulated data using interleaving, one-to-one, concatenation, merging, transpose, Datasets, and Sort.

Confidential

Senior Statistical Analyst

Responsibilities:

• Worked extensively with SAS Functions/Macros/Procedures
• Developed SAS Macros to ease the process of coding, to standardize programs, for data
• Performed SAS programming using various techniques such as SAS Base, SAS Macros in SAS EG
• Produced statistical reports for various business needs and expertise in data preparation, data cleaning, analysis, and reporting
• Developed SAS coding using various date and time to perform daily, weekly, monthly and quarterly jobs.
• Worked on Linear Regression, ARIMA,STATESPACE Models
• Created large datasets by combining individual datasets using various inner and outer joins in SAS/SQL and dataset merging techniques of SAS/BASE and SAS DI and developed SAS ETL jobs.
• Responsible for Modeling, Analysis, implementation of inter Currency Arbitrage
• Currency Arbitrage between the exchanges SGX, DGCX, CME, NSE, BSE.
• Modeling Calendar Spreads arbitrage between the exchanges SGX, DGCX, CME, NSE, BSE.
• Involved in Market making FX models in SGX, DGCX.
• Involved in design, Analysis and implementation of real time Option trading Strategies such as Vertical Spreads, Horizontal Spreads, Volatility Strategies, Sideways Strategies, Directional, Neutral Strategies.

Confidential

Senior Statistical Analyst

Responsibilities:

• Develop SAS programs that generate Tables, Listings and Figures.
• Understanding SAP and working with Statistician to develop specs.
• Performed SAS programming using various techniques such as SAS Base, SAS Macros, Data manipulation and statistical procedures to generate TLG’s.
• Creation of SDTM datasets, ADAM datasets using CDISC standards
• Perform data validation datasets and/or mapping specifications to meet FDA standards
• Involved in Developing, Debugging, and validating the project-specific SAS programs to generate derived SAS datasets, summary tables, and data listings according to departmental standards.
• Work closely with team members, Statisticians and Data Managers to generate and validate tables, listings, figures and reports for further analysis or submission to the FDA using SAS on a Windows platform
• Debugging, validating and improving existing SAS programs
• Created complex and reusable Macros and extensively used macros and developed SAS programs for Data Cleaning, Validation, Analysis and Report generation. Tested and debugged existing macros.
• Formatted HTML, PDF and RTF reports, using SAS/ODS system.
• Contribute to the development and Implementation of programming and reporting standards.
• Contribute to the development of a macro library and optimize the programs.
• Creation of SAS data sets from external files using Import techniques and data manipulation of datasets using SET, MERGE and Conditional statements.
• Understanding and the Analyzing the Business Requirement Documents .
• Executed the test cases as per the run plan and reported the defects using Quality Center.
• Prepared daily status report and weekly status report and sent it to Project Manager and also to the client.

Confidential

Senior Statistical Analyst

Responsibilities:

• Interest rate arbitrage between near and far month futures/options with hedge ratio method to trade the number of contracts to be hedged.
• Analysis and Reporting has been done on historical data and model decided. Supported in developing ATS and connected to live markets for trading.
• Involved in development and enhancements of SAS Programs.
• Creating and scheduling jobs for extracting data, applying data transformations and validation check while loading SAS data sets and SAS views.
• Worked on EXCEL VBA, SOLVER and SAS Add-in and used many functions in Excel

Confidential

Senior Statistical Analyst

Responsibilities:

• Understanding various business requirements
• Extract data from various data sources
• Testing data and preparation of data quality report to fix errors
• Join various data tables and preparation of model datasets
• Build Statistical models for respective use cases
• Test and tune the models to achieve high accuracy
• Preparation of various Ad-hoc reports as per the client requirement

Confidential

Senior Statistical Analyst

Responsibilities:

• Strategy simulations using Macro Loops, Cumulative Iterations and Statistical functions on historical data in SAS.
• Extract data from various data sources
• Testing data and preparation of data quality report to fix errors
• Join various data tables and preparation of model datasets
• Build Statistical models for respective use cases
• Test and tune the models to achieve high accuracy

Confidential

Executive Statistical Analyst

Responsibilities:

• Responsible for Trading, Check list and VAR limits of CALPAIRSPR and MMUNI-VAR trade models.
• Developing SAS Codes and Macros for data Extraction, Transformations and Loading using data Statements, Functions, Call Routines and PROC SQL.
• Documentation and Calculations for Strategies and Information Tables in Developing Spread Sheets, Applications and Web site.
• Strategy simulations using Macro Loops, Cumulative Iterations and Statistical functions on historical data in SAS.
• Studying the characteristics of several variables and fitting appropriate Statistical models as per the management requires.
• Modifying pre-defined SAS codes as per the Change requirement Documents.
• Preparing Pre-Trade and Post-Trade Analysis.
• Participating in Derivative trading with defined models and monitoring the same.