Sas Programmer Data Analysis

Meeninath S Langhe

Statistical Programmer

Pune, Maharashtra.

Email – ***************@*****.***

Mobile - 992*******

PROFILE SUMMARY :-

** **** ***** ** ********** in Clinical SAS, STAT programmer, Data Analysis and Reporting (Creation of SDTM TLF ADAM)

Proficient in SAS v9.4, SAS EG/6.1 and strong experience in working with BASE SAS, SAS/STAT, SAS/SQL, SAS/MACROS.

Expertise in gathering, analyzing and documenting business requirements and developing Business requirement documents and Functional requirement specifications.

Extensively involved in data analysis and preparation of Analysis Datasets, Reports, Tables and Listings.

Good understanding of SAS functions and experience in extracting data from various data sources like (xls, csv, txt) files, Oracle, SQL Server. Ability to analyze & process data using various SAS procedures, statistical procedures.

Extensive programming experience with PROC SORT, PROC TRANSPOSE, PROC FORMAT, PROC REPORT, PROC TABULATE, PROC FREQ, PROC MEANS, and PROC SQL.

Experience in performing ad hoc queries for various reports.

Worked on Global Reports Standardization’s.

Worked on BASE SAS, SAS EG, J-Review, SQL and other programming tools.

Good experience on SAS report Programming, created SAS listings, Patient Profiles, Study specific and Global reports.

Extensive experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch including data reconciliation.

Have ability to develop new programs and modify existing programs to support various scenarios to make standard validation checks.

Good Clinical domain Knowledge and overall understanding on CDISC, SDTM and Clinical Trials Life Cycle

Professional Experience

Working as SAS Programmer 1 in ICON Clinical Research LTD., from Aug 2022 to till date

Worked as SAS Developer and SAS Programmer in TCS, Pune, Nov 2014 to Jul 2022

Worked as Analyst SAS Programmer in Cognizant,

Mumbai, Oct 2013 – Nov 2014

Worked as Statistical Programming Technician in

Quintiles, Bangalore, Aug 2010 – Aug 2012

SAS Programmer Intern in Cytel, Pune, Dec 2009 – May 2010

Tools/Methods:

SAS Tools:

SAS v9.4, BASE SAS,

SAS/MACRO, SAS/SQL,

SAS/ACCESS, SAS/STAT,

Databases: Oracle,

SQL Server.

Documentation Tools:

Microsoft Word, Excel,

PowerPoint

Education:

Master’s Degree: MBA

College NIBM (National

Institute of Business

Management) 2011 First

Class

Bachelor’s Degree:

B. Pharm, Siddhant

College, Pune University

2008, First Class

Diploma Degree:

Diploma in Pharmacy,

MSBTE, 2005, First Class

Other:

Post Graduate diploma in

Clinical Research,

Catalyst Clinical Services,

Delhi, 2007, First Class

Honors and Awards:

Special achievement award

for Phase -1 and Patient

Profile Study

Other Skills:

Estimation & Planning

Project Scheduling

Project execution

Project monitoring

Project reporting

Project reviewing

Project Information

Organization1: ICON, Bangalore

Responsibilities:

Collaborates with other analysts, Clinical Data Scientists and other roles as needed to apply standards and to develop data cleaning reports to support of the data review plan Knowledge of reporting and analytics tools that support the accuracy and integrity of study data

Analyze the data based on given requirements.

Involved in developing, testing, and writing programs and reports according to business required.

Creating the final report with client specification formats

Complies with applicable SOPs and work practices

Supports knowledge development of others on reporting and analytics tools that support the accuracy and integrity of study data

Creation of SDTM ADAM TLF

Organization 2: TCS, Pune

Responsibilities:

Worked as SAS programmer, created Data Exports as per Requirement Specifications using SAS and SQL.

Analyzing the process scenarios and client requirement

Data extraction from various RDBMS (Oracle, Teradata), using LIBNAME and PROC SQL Pass - Thru facility

Developed simple, medium, complex and Ad-hoc reports by using joins, sub-queries, analytical functions in SQL etc.

Reviewing current specification design and making suggestions for better data validation.

Experience in requirement gathering, analysis, planning, designing, coding and unit Testing.

Facilitate training and mentoring technically as well as process wise to new hires.

Worked as SME (Subject Matter Expert) involves in coordinating with study teams and resolving developer queries.

Reviews the requirement before development, requirement changes and discuss requirement finalization by collaborating with clients.

Experience in creating the report in any of the formats like HTML, XLSX, CSV and PDF formatted files using SAS

SAS EDIT Check Programming

Create TLF, SDTM ADAM Programming

Create CRT an PDF for Submission

Organization 3: Cognizant, Mumbai

Responsibilities:

Create CRT an PDF for Submission

ETL by using the SAS enterprise guide

Worked on SSDB Programming and spec creation

Creation of SDTM TLF ADAM

Organization 4: Quintiles, Bangalore

Responsibilities:

Create standard specifications and intermediate analysis data set

To Understand the study documents (Protocol, SAP, Annotated CRF, Defines and Annotated shell.)

Create study specific set up files

Macro for batch submission of TLF

Generating Standard safety listing, Tables and figures

Analyze and perform quality control checks of the generated listing and tables

Validating/Debugging the programs written by other team members

Developed standard macro for Null Report Generation

Modifying or updating the client specific macros as and when required

Provide guidance and support to team members

Communicating effectively with the client through teleconferences and emails

Report data issues to client

Worked on Patient profile studies

Organization 5: Cytel Statistical software and services, Pune Responsibilities:

Create Analysis dataset

Create SDTM Adam TLF

Ad-hoc data mining requests:

Understanding the business requirements.

Identification of sources.

Programing SAS/SQL scripts.

Data cleansing using Data step, Format, Sort and Transpose procedures.

Exporting the data to Excel flat files and provide the final output to the customer.

Responsible for standard operating procedures.

- Meeninath Langhe.

Contact this candidate