Harsh Patel

About Harsh Patel

Expertise with SAS/BASE, SAS/MACRO, SAS/SQL and SAS/ODS (RTF, PDF, XML, EXCEL) procedures.• Expertise in SAS VA 8.5 using SAS Viya 3.5.• Well-trained in importing and exporting EXCEL files using LIBNAME, PROC IMPORT, PROC SQL, PROC EXPORT.• Well trained in PROC REPORT and PROC TABULATE.• Broadly used SAS/MACRO for creating macro variables, macro programs and Autocall macro library to modify existing SAS program for ease of modification while maintaining consistency of results.• Comprehensively prepared reports using SAS report generating procedures like PROC PRINT, PROC FREQ, PROC MEANS and PROC SQL• Working on functions LIKE SUM, ROUND, SCAN, TRIM PUT, INPUT, CALL SIMPUTX• Considerably experience in data merging, Data Subsetting with the use of PROC SQL, MERGE and SET statements• Trained on SAS/SQL for creating summary reports, Displaying query results, Generating Tables and Views, SQL joins and Set operators• Knowledge about SAS options Like KEEP, DROP, RENAME, and LINESIZE• Knowledge about reporting and graph• Knowledge about clinical data integration• Aware about SDTM, ADAM and ICH GCP GUIDLINE.• Exposure in Administrating SAS applications and User management using SAS Management Console.• Well trained in SAS Visual Analytics

Experience

1. Assistant Consultant

   Tata Consultancy Services

   Jan 2022 — Present · Thane, IN

Education

• Rajiv Gandhi University of Health Sciences

  Bachelor’s Degree

  2007 — 2011