Clinical SAS programming

VAIBHAV R. JAIN

Email: ***********@*****.***

Contact: 970-***-****

Objective

To join a highly reputed and professional Clinical research work environment and apply my best data analysis practices and experiences to gain excellent advancement in my career.

Synopsis

Working as Clinical SAS Programmer at IQVIA.

Certified BASE SAS Programmer.

Experienced Working on Generating Discrepant SAS listings as per Specification from Data Management team, Data Transfer Programming-Import and Export Programming.

Experienced Preparing Data Transfer Document such as Data Coding Guideline, Data Transfer Guideline, Data Transfer Specification etc.

Experienced Coordinating with Data Management Team resolving issue with regards to SAS listing requirement over call.

Knowledge in BASE and Advance SAS programming, SAS/STAT, Report creation by Proc report, Proc tabulate etc., Graph generation, UNIX.

Knowledge in SQL query writing, Do loops, Arrays and SAS Macros.

Experience working as Clinical Data Manager on Study Setup, Conduct and Closeout phase.

Experience automating DM Manual check, Third party reconciliation, SAE reconciliation, Global physician report in SAS to save DM reconciliation time and Validating SAS output working as Data Manager.

Experienced working on 5 priority study of the projects on conduct phase and has also worked as Primary data manager on Study set up Phase.

Possess good clinical data analysis skills providing high quality.

Received good client feedback and manager feedback.

Experienced attending client calls for the study and building good client relationship.

Work experience

Current organizantion: IQVIA (QuintilesIMS)

Current designation: Associate Clinical SAS Programmer

Experience: Since Sep 2014 till date.

Previous organizantion: Cognizant technology solution.

Previous designation: Junior data analyst.

Experience: Since August 2014 till Sep 2017

Internships

Institute: Tech Data Slution, Kurla.

Period: 1 Feb 2017 to 30 Jun 2017 (5 Months.)

Milestones in career

Working as Clinical SAS Programmer at IQVIA on Inform/Oracle and RAVE Study .

Have worked on generating SAS listing as per specification provided by DM team.

Worked on creating Data Transfer Programming:

oImport Programming: Converting Vendor data in SAS format.

oExport Programming: Converting the Production dataset from RAVE or Oracle/Inform in Excel format/SAS format.

Have worked on vendor data reconciliation such as SAE, Central LAB, Local Lab and other vendor data.

Knowledge in Base SAS programming-Using different function in SAS, Proc step procedure, Data step Procedure .

Creating and manipulating SAS data sets using Data step proceudre, Designing Reports using Proc report. Tabulate etc. based on client’s requirement.

Known with accessing data from MS excel and MS access, Txt files, MS word.

Expertise in using various SAS Procedures such as Proc print, Proc Append, Proc Tarnspose, Proc Contents, Proc Sort, Proc Report, Proc Datasets, & Proc Tabulate, SAS/ODS etc and Functions such as Tranwd, Substr, CATX, CATS, COMPRESS,ROUND, CEIL etc.

Writing Query in Proc SQL. Knowledge in all three types of SQl query DML,DRL,DDL

oDRL(Data Retrieval Language)-Using statements such as Select, From, Order By, Group By, Having clause etc.

oDML (Data Manipulation Language)-Using statements such as Insert, Update, Set, Case when, Delete etc.

oDDL(Data defination Language)- Using statements such as Create, Alter, Drop.

Knowledge in Do loops and Arrays to save time in wiritng lengthy SAS programs.

Macros expertise-Creating Macros, Invoking macros, creating macro variable by % Macro, Call symput, %Let statements. Familiar with syntax-% index, %eval etc.

Unix expetise: Creating Folder, Creating file(Txt, SAS program,Xls) in folder, Writing SAS program using VI editor, Running SAS program via Unix and Scheduling Jobs via Unix.

Genrating Conclusion and Graphs based on hypothesis using SAS/STAT which include using procedure such as Proc reg, Proc corr and Proc Univariate etc.

Have Also Worked as Clinical Data Manager working on all 3 Phases of CDM-Setup, Conduct and Closeout.

Experience Handling RAVE studies.

Experiencing In Vaildating SAS output as DM.

Worked on studies for all 3 Phases of Clinical trials.

Have worked on 5 RESPIRATORY conduct studies till date and 1 Set Up Study as Primary data manager.

Have received organization manager and client appreciation.

Experienced performing various data management activities Like Raising query in EDC, performing recon on Excel, Creating data management Documents etc.

Academic profile

Qualification

Institute/university

Year of Passing

Grade/class

SSC

AFAC SCHOOL/MUMBAI

2008

FIRST CLASS

69%

HSC

AFAC Jr. COLLEGE/MUMBAI

2010

FIRST CLASS

67%

BACHELOR IN PHARMACY

Oriental College of Pharmacy (OCP)

2014

FIRST CLASS

68%

IT Proficiency

Certified with Basic Computer Operation from Academy of Fine Arts & Crafts.

Certified BASE SAS Programmer.

Personal Dossier

Date of Birth: 4th May 1993.

Languages known: English, Hindi, Marathi.

Marital Status: Single.

Address: Block No. 3, D/7 Nandadeep building, Chembur Mumbai-400 071.

Hobby and Interest

Watching movie, Playing football, Dancing and Travelling.

Contact this candidate