Sr SAS Statistical programmer

SUMMARY:

Result driven attitude with Fourteen years of experience in the design and development in SAS Windows and mainframe/Unix based applications.

Advanced SAS certified programmer from SAS institute.

Sound Knowledge with CDISC conventions, i.e., SDTM and ADaM models and metadata.

Expertise in SDTM data and ADaM dataset creation. TLF, Patient profile and CRF metrics report. Sound knowledge in Breast cancer and Prostate cancer studies.

Experience in SAE Reconciliation, Vendor data, Narrative templates and visit status report in Phase III clinical study.

Sound Knowledge in Define XML like report generated thru SAS for TLF navigation.

Expertise in SAS BI technology tools, like SAS EG, SAS OLAP Cube, Info Map, Dashboard and Stored procedures STP.

Developed plenty of SAS macros in order to use Study team.

Involved in complete Software Development Life Cycle (SDLC) starting from requirement analysis, design, development, coding, testing, debugging, and implementation.

Expertise in working with SAS EG, SAS Web Report Studio, SAS Information Map Studio, SAS XML Mapper, SAS Procs, DB2.

Experience in mentoring junior/offshore team members. Ability to work independently.

Worked on Life Science vertical for the past 5 years and good knowledge about LS domain.

Good Experience in resolving the production issues in a timely manner

Ability to understand the requirement, analysis and implement the logics in application quickly.

EDUCATION AND CERTIFICATION:

Masters in Computer Science Application.

Bachelor of Science with Math specialization.

SAS Advanced Certified programmer from SAS Inc.

SAS BI content developer certification from SAS Inc.

SAS Data integration developer (ETL) certification from SAS Inc.

SAS Base 9 Certified programmers from SAS Inc.

Next Generation Prescription Service-NGPS from IMS Health.

Brain Bench certified for JCL, COBOL and VSAM.

Brain Bench Certified RDBMS Concepts, DB2 Programming.

Brain Bench certified for Project Management-2005

TECHNICAL SKILLS:

Languages: SAS, SAS Studio, BASH, PowerShell, JCL, COBOL, REXX.

SAS BI Technologies: SAS OLAP Cube Studio, SAS Information Map Studio, Web report Studio, Dashboards and SAS Portal

Samplings, ODS and Report formatting.

SAS Technologies: SAS Procedures, SAS Macros, SAS DI Studio and functions, Data

Samplings, ODS and Report formatting.

SAS Applications: SAS EG 7.1, SAS Web Report Studio 4.3, SAS Information Map

Studio4.2, SAS XML Mapper

Database: DB2, IDMS & VSAM.

Operating Systems: Windows, OS/390, UNIX.

Other: SAS Power and Sample size 3.1, SAS Universal Viewer 1.1

PROFESSIONAL EXPERIENCE:

Client: Medivation Inc., San Francisco, CA May14- Till Date

Project: Biometrics – Study Team.

Role: Sr. SAS CP Programmer/Windows/Linux

Medivation, Inc. is a biopharmaceutical company. The Company is focused on the development and commercialization of therapies to treat serious diseases like prostate cancer and in advanced breast cancer treatment options. Medivation has one commercial product, XTANDI (enzalutamide) capsules for the treatment of patients with castration-resistant prostate cancer (CRPC). This project consists of 4 phase-3 study and 7 phase-2 study and 4 Early Development studies.

Responsibilities:

As part of Study team, developed new SAS programs for creating SDTM dataset and SDTM specification review for both Prostate and Breast cancer studies.

Developed SAS Programs and macros in order to generate TLF (Tables, Listing and Figures) for study team.

Developed a SAS tool that can generate Define XML like report in xml file for Medical Affairs to navigate easily.

Worked with Data Managers for specification part and developed SAS programs for CRF metrics reports. Which are Finance report, SDV Due Report, Entry Due report, Summary report etc.,

Implemented a new metadata driven process for SDTM specification.

Created macro for Patient Profile (PP) output RTF file creation.

Created tool for converting RTF file to PDF file with index page on it.

Developed a tool in PowerShell that will converts XLSX (xml like) file created thru Proc Report into true XLS file.

Being part of Migration team, Developed bunch of BASH linux script that will convert sas datasets in windows environment to new Linux environment. So CEDA warning will be avoided.

Used various Procedures like PROC Report, PROC Format, PROC Summary and PROC Means to analyze data, generate clinops-on demand reports.

Created stored procedures using SAS Enterprise guide to display Patient Profile (PP) reports in web for easy navigation for Un-blinded study.

Cleaned existing data and converted them into useful SAS Datasets, merged datasets and created reports based on study team requirements.

Environment: Windows, SAS EG7.1, SAS ETL (DI Studio) SAS Studio, Linux, Bash Script, XML, VB Script, PowerShell .

Client: Dept of Education, State of Florida, FL May12- May14

Project: Statewide Longitudinal Data System

Role: Sr. SAS Analyst/BI Developer/Windows

Florida department of education built an Educational Data Warehouse as a part of State Wide longitudinal Data Round 4(SLDS R4) Federal Grant. EDW is an integration of desperate source systems like K12 Schools, WDIS Technical Educations, and Florida College Systems. EDW is used for longitudinal Data Analysis by teachers, researchers, parents, legislatures and many more. In this integrated data warehouse each student is identified uniquely throughout the EDW by assigning a new education ID called Florida Educational ID (FLEID). Part of this grant allows public users will access all longitudinal reports in the form of SAS web reports and Dashboards.

Responsibilities:

Developed new or modified SAS programs and used SQL Pass Through and Lib name methods to extract data from the Oracle DB and created study specific SAS datasets, which are used as source datasets for report generating programs.

Developed ETL jobs by using SAS EG and SAS DI studio in order to summarize the student level data into higher level.

Build OLAP Cubes for each business area by using SAS OLAP CUBE studio and created custom measured like percentage. Build the business layer for CUBE in SAS Information map and used this map in SAS Web reports and Dashboards.

Used Multiple transformations in SAS DI like CDC, SCD type 2, Splitter, Transpose, User Written Code, Extract, Join, merge and Data Validation Etc.,

Imported raw data files in excel format in SAS and subsequently created SAS Datasets and performed data manipulations on the datasets.

Cleaned existing data and converted them into useful SAS Datasets, merged datasets and created reports based on Business requirements.

Extensively used PROC SQL and SELECT sub-queries to generate various reports by connecting to the SQL Server DB.

Used various Procedures like PROC Sort, PROC Format, PROC Summary and PROC Means to analyze data, generate reports and Create Cubes on it.

Extract the data from Flat files which district submitted for each school survey and transform the data by using business needs and load into SQL server database.

Expertise in creating ETL jobs using SAS DI to populate underline data into Data warehouse SQL server database.

Created custom defined transformations in SAS DI using SAS Macros for Complex business logic Split and merge student Records in Demographic and Course databases.

Created stored procedures using SAS Enterprise guide to display reports in web.

Environment: Windows, SAS EG4.3, SAS XML Mapper3.1, SQL, SAS/STAT, SAS Macros, SAS OLAP, SAS Information Map, Web reports, Dashboard, SAS Portal

Client: Dept of industrial Relationship, State of California, CA Oct11- Apr12

Project: DWC- Return to Work

Role: Sr. SAS Analyst/Developer/Windows

When workers in California suffer with a disabling injury at the workplace, they are usually eligible to receive worker’s compensation benefits. As part of the project, DIR will get Employment details from EDD, Injury details from WCIS and PD ratings details from DEU, then combine these info to produce study of earning loss and return to work ratio by using propensity score statistical methodology.

Responsibilities:

Analysis the current methodology of selecting counterfactual co-workers and replace it with propensity score statistical methodology. And generate earning loss study through LOGIT regression model.

Build Stored Process in SAS EG with prompt variables to generate reports in client’s server side.

Data analysis of EDD information and match with data from Dept of Workers compensation and Generate Return to work report from SAS OLAP Cube.

Migrate from polytypic data to SAS data as monotypic in order to emphasis DIR information security.

Parse the data from EDD and run it for each quarter from 2005-current to link with DEU data in order to produce return to work ratio.

Compare the propensity score counterfactuals with RAND methodology and produce various reports by using sas enterprise guide.

Analysis SAS modules for EDD-linking and DEU-linking.

SAS Coding as per requirement and implement the changes in production.

Environment: Windows, SAS EG4.3, SAS XML Mapper3.1, SQL, SAS/STAT, SAS Macros, SAS OLAP.

Client: CITI Group, Elk Grove Village, IL Oct 10- Oct 11

Project: Cards Forbearance Risk Management

Role: Sr. App Programmer/SAS/Windows

Citicards line of business has its own risk in the form of deliquesce. In order to avoid or minimize the risk Citicards introduce (adopt from Fed) the forbearance program for citi delinquent customer. As a part forbearance risk management team, generate the custom level of error report to avoid ineligible people enroll the forbs program. As a part of risk management, identify recidivism activity on UPP program. Build the initial version on of our own forbearance database in UNIX, then convert the process into SAS windows by using SAS Info Map studio & SAS EG.

Responsibilities:

Generating SAS stats reports for citicards higher management to produce monthly snapshot of loss-recovery dashboard report. Based on this report management team will produce quarterly balance sheet.

Gather the requirement specification from users, identify the source feed and estimate the time frame. Once got BRD signed off, share the work with my offshore team and validate their code/report and send to business users.

Build the new version of forbearance 2.01 database with 98% of accuracy.

Generate the custom reports collections team (ACS) for performance measures. And validate the daily cardholder file and monitor the cards activity pre-forb status.

Apply the re-age (cure) rule for the delinquent people and check their eligibility of program enrollment.

Build the vintage, performance, cure tables on monthly basis and validate them before release.

By using SAS Information Map studio, modify existing Risk analysis map and generate reports in SAS EG.

Convert the Unix process to Windows version.

Working with Off-shore and On-site model on multiple tasks by interacting with off-shore team on daily basis.

Environment: SAS, SAS EG, SAS Information Map studio, SAS Web Report Studio, SAS/STAT, SAS Macros

Client: CITI Group, Long island City, NY Nov 09 – Sep 10

Project: CPWM Data Mart

Role: Lead Programmer/SAS EG

Citigroup merged its Smith Barney brokerage unit into Morgan Stanley’s brokerage operations. However Core Citigroup maintains its own brokerage (MyFi & Nic) accounts for their clients. Due to this merger, SB will no longer provide feed files to citi system. CPWM data mart team is identifying alternate source feed files from PERSHING platform and change the whole existing MYFI & NIC citi system to point out the new feed files and fill the gaps. Generating custom reports for business users by using SAS EG Stored Process.

Responsibilities:

Analysis the SAS modules for identifying the impact of feed file changes.

Convert impacted Jobs Stream into SAS EG Stored Procedures.

Preparing the Gap analysis between SB files Vs Pershing standard files.

Find the alternate methods for filling the Gaps by using daily trading transaction file.

Involved in designing the modification of the existing tables and creating new db2 tables. Extracting the data and populating the new db2 tables. Modifying the impacted programs and stored procedures.

Generating SAS statistics reports for usage of online transaction Vs broker assisted transaction. By using this report, CITI will restructure the pricing for trading fee.

As part of Citi private wealth management, Involved in creating dynamic reporting of all TRICKED accounts split up by trading method and fee loss due to FA attrition.

Code and Implement the program which are reformat the perishing files and load into new DB2 tables.

Working with Off-shore and On-site model on multiple tasks by interacting with off-shore team on daily basis.

Environment: SAS EG4.2, SAS/STAT, DB2, MVS.

Client: IMS Health, Plymouth meeting, PA July 09- Nov 09

Project: Canada SAS Assessment

Role: Sr. Developer/SAS/Windows To Mainframe

Canada SAS Assessment project is impact analysis of SAS shut process in the client IMS-Canada and convert sas (modules / Maps & Stored Process) to appropriate alternate methods like Cybermation, Syncsort, REXX etc., In IMS-Canada application there are several audits uses SAS modules these modules will be converted to UNIX system or COBOL modules without affecting the regular monthlies and weeklies.

Responsibilities:

Analysis the SAS modules from Canada Audits.

Find the alternate methods for these SAS modules.

Code and Implement these SAS modules to COBOL/Syncsort/REXX.

Test/Compare the new modules and SAS modules.

Requirement analysis from clients and estimate time frame.

Coding the requirement and implement changes in production

Implement the new modules in Production.

Environment: SAS EG, SAS Info Map Studio3.1, SAS/STAT, REXX, COBOL, Syncsort, MVS, UNIX.

Client: IMS Health, Parsippany, NJ Feb 07-Jun 09

Project: Custom Delivery Services

Role: Sr. Developer

Custom Delivery Services (CDS-Specials) is part of Delivery Services division of service organization of IMS Health. This group services requests from customers (Like Pfizer, Lilly) that are non-standard in nature. This project is mainly an Application Maintenance Project.

IMS collects information in the form of two types of data, namely DDD data and Rx data. Rx data has the prescription and refill details while DDD is an audit in IMS system and it holds sales related information. This data is projected as per the client requirements .The purpose of this project (CDS-Specials Support) is to generate reports that require various level of customization of production reports such as DDD, Exponent etc.

Responsibilities:

Requirement analysis from clients and estimate time frame.

Coding the requirement and implement changes in production.

Delivery the various reformatted reports thru VPS, File Express & CD media.

Quintile the prescribers based on the Products/Markets and recommends who are all high valued prescriber for client products.

By Using NGPS methodology, impute the (Rx) data for non-sample outlets.

Estimate the outlet RX data by using PROC REG and do the correction.

Extracts reports from IDMS database thru OLAP Cube session and do the formats using SAS EG.

Co-ordinate with Offshore team to get the job done.

Generate the weeklies and monthlies report for IMS clients like Pfizer, Lilly etc.,

Developed number of internal tools in SAS for verification and reduce redundant work.

Implement Cognizant quality control standard, Business practices and procedures.

By using TSS-Time Sharing System for effective time management to implement the work order details of project.

Environment: SAS, SAS EG, SAS/STAT Procs, OLAP Cube, IDMS, CLIST, UNIX.

Cognizant Technology Solutions, India May 02-Feb 07

Project # 1: Custom Delivery Services

Role: Developer

Custom Delivery Services (CDS-Specials) is part of Delivery Services division of service organization of IMS Health. This group services requests from customers (Like Pfizer, Lilly) that are non-standard in nature. This project is mainly an Application Maintenance Project.

IMS collects information in the form of two types of data, namely DDD data and Rx data. Rx data has the prescription and refill details while DDD is an audit in IMS system and it holds sales related information. This data is projected as per the client requirements .The purpose of this project (CDS-Specials Support) is to generate reports that require various level of customization of production reports such as DDD, Exponent etc.

Responsibilities:

Coding the requirement given by On-site coordinator and move the code to UACC.

Quintile the prescribes based on the Products/Markets and recommends who are all high valued prescriber for client products.

Extracts reports from IDMS database thru OLP session and do the formats.

Co-ordinate with team member to verify their coding.

Generate the weeklies and monthlies report for IMS clients.

Developed number of internal tools in SAS for verification and reduce redundant work.

Implement Cognizant quality control standard, Business practices and procedures.

Environment: SAS, Base SAS Procs, COBOL, JCL, Syncsort, DYLKOR.

Project # 2: NSP - Omnicare

Role: Analyst/Developer

NSP – Omnicare project is history correction process. IMS Health collects information from various data providers. Omnicare is one of the Long Term Care (LTC) data providers to IMS. Omnicare, which had not been processed since October 2002 when Omnicare had started acquisition of NCS. Formerly, NCS had been the LTC data supplier. The scope of the project is implementing these 18 months Rx data to IDMS database.

Responsibilities:

Understanding OLP process.

Execute the jobs for OLP dump.

Review of Technical specification.

Preparation of Design documents.

Prepare and Review of Test Results.

Client interaction and support.

Environment: COBOL, JCL, Syncsort, IDMS, UNIX.

Project # 3: IDMS to DB2 conversion.

Role: Consultant/Developer

This “IDMS to DB2 conversion” project for the client MetLife, Insurance domain. MetLife decide all the IDMS tables convert to DB2. The scope of this assignment is moving all the entities from IDMS to DB2 tables with the corresponding set-relationship. And also change all the jobs instead of extracting data from IDMS changed to DB2.

Responsibilities:

Understanding IDMS set-relation process.

Understanding DB2 tables and structure.

Execute the jobs for IDMS extraction.

Execute the jobs for DB2 extraction and match with IDMS extraction.

Switch the IDMS extraction jobs to DB2 Extraction.

Prepare and Review of Test Results.

Environment: COBOL, JCL, IDMS, DB2

Contact this candidate