Data Sas

SANDEEP KUMAR +1-937-***-****

********************@*****.***

SUMMARY:

Almost 2 years of experience as a SAS Programmer of generating Statistical Analysis Files, Tables, Listings, Graphs, Validations using SAS/BASE, SAS/STAT and SAS/Macros.

Proficiency in various SAS tools like SAS/Base, SAS/Stat, SAS/GRAPH, and excellent working knowledge of SAS Procs like proc report, proc freq., proc means, proc tabulate, proc plot, proc chart, proc contents, proc dataset, proc format, proc import, proc export, proc print.

Good experience in storing and manipulating data in SAS files by Merging, Arrays, Formats, Informats, SQL Joins, Proc Datasets, Proc Sort and Proc Transpose.

Experience in Modifying existing SAS programs and creating new SAS Programs using SAS Macro to improve ease and speed of modifications as well as consistency of results.

Extensively used SAS/MACRO for creating macro variables and macro programs to modify existing SAS program for ease of modification while maintaining consistency of results and also developed SAS/ Macros for generic coding and reusable modules.

Used SAS/SQL to merge data files, combine data sets and tables, and transform data.

Extensive experience in performing different operations on SAS data sets of any size like Sorting, Merging, Concatenating, and Interleaving.

Generated EXCEL tables for non-coded Adverse Event Terms, Concomitant Medications and Medical History Terms.

Have an idea on developing SDTM data mapping and create SDTM datasets per CDISC standard for FDA.

Experienced in producing Excel, RTF, HTML and PDF formatted files using SAS ODS to produce ad-hoc reports for presentation and further analysis.

Strong communication and interpersonal skills.

EDUCATION:

Bachelors in Electrical & Electronics Engineering from Jawaharlal Nehru Technological University, Hyderabad, INDIA.

Masters in Electronics Engineering from Wright State University, Ohio.

CERTIFICATIONS:

SAS Certified Base Programmer for SAS 9.

TECHNICAL SKILLS:

Statistical Package

SAS

SAS Tools

SAS/BASE, SAS/MACROS, SAS/STAT, SAS/GRAPH, SAS/SQL, SAS/ACCESS, SAS/ODS, SAS/REPORTS

Operating Systems

Windows 98/2000, Windows XP, UNIX

SAS Procs

Print, Means, Univariate, Correlation, Regression, SQL, Report, Freq., Sort, Summary, Formats, Imports, Transpose, Compare, G-plot, G-chart.

Programming Languages

MATLAB, MS-SQL, C-Language

Office Tools

MS Word, Excel, Access, Power Point.

PROFESSIONAL EXPERIENCE:

OCEANS NINE INFOTECH SOLUTIONS Pvt. Ltd., Hyd Jul, 2013 – Dec, 2014.

Designation: SAS Programmer

Responsibilities:

Involved in Phase I and II of clinical trials and was responsible for creating, testing and maintaining SAS programs for clinical studies according to company standard procedures.

Coded programs in BASE SAS and debugged the code to ensure the required functionality.

Created datasets by processing the raw data in text files, comma separated files, and Excel spread sheets using INFILE Statement with DSD, DLM, and MISSOVER options and created SAS Macros and Graphs.

Used SAS import techniques like Proc import, infile and SAS/Access statements to import and export data from MS-Excel.

Imported ASCII text and RDBMS data using SAS PROC IMPORT and LIBNAME.

Responsible for manipulation of data by Merge, Joins, Proc Transpose efficiently.

Written Macros to make the process easy for the end users where they can get the required report just by changing dates.

Prepared data using data management methods such as if/else statement, DO grouping, SELECT, WHERE statement, ARRAY and SAS functions.

Performed edit checks on data to support clinical trial integrated reports.

Generated reports, listings, tables and graphs using SAS tools such as SAS/Macros, SAS/Graph, SAS/SQL, Merges, SQL Joins, SAS/Connect, SAS/Access and performed data transposition in SAS using PROC Transpose and created analysis datasets.

SAS/GRAPH for various types of graph for analysis and submission.

Used SAS/Stat software for Statistical Analysis, procedures and reports. Created Summary Reports and Tabular Reports using Proc Report.

Generated highly customized reports using SAS/MACRO facility, PROC REPORT, PROC TABULATE.

DATA step programming for permanently defined labels to data.

Wrote excel macros using VBA.

Extensively used Data _Null_ and SAS procedures such as Proc Print, Proc Report, Proc Tabulate, Proc Freq., Proc Means, Proc Summary and Proc Transpose for producing ad-hoc and customized reports and external files.

Extensively used SAS/ODS for generating the reports in PDF, RTF and HTML.

ENVIRONMENT: SAS 9, SAS/BASE, SAS/ Access, SAS/STAT, SAS/GRAPH, SAS/SQL, SAS/MACROS, SAS/ODS, CDISC, Windows XP/2000/7/8/10, MS-Excel, UNIX, MS-Office.

References:

Available upon request.

Contact this candidate