Sumanth Punnati

Sas Developer @Capgemini

Having 6+ years of overall work experience in IT and 5+ Years of experience in SAS• Worked on the Ad-hoc requests raised by the clients and submitted on time.• Proficient in BASE/SAS, SAS/MACROS, SAS/SQL programming, and SAS Procedures.• Hands-on experience in SAS programming for importing and exporting huge data sets from Flat files, Excel spreadsheets, and external RDBMS (ORACLE) tables using SQL PASS THROUGH and LIBNAME facility.• Extensive programming experience with various transformations.• Creation of new data sets from raw data files using Import techniques and modifying existing datasets using SET, MERGE, and Conditional statements.• Proficient in SAS/ODS for delivering output in different formats.• Generated reports and output files in text format, HTML, PDF, and RTF format using SAS/ODS.• Prepared new Datasets from raw data files using Import.• Hand on experience in various procedures like Proc Sort, Proc Format, Proc Append, Proc Print, Proc Means, Proc Summary, Proc Copy, Proc Delete, and Proc Report.• Techniques and modified existing datasets using Set, Merge, Sort, and Update, Formats, Functions, and conditional statements.• Having good experience in generating reports using SAS EG.• Having good experience in Snowflake and Tableau.