Sucharitha Komati

Experience

• 

  American Express

  Jul 2012 - Sept 2013

  SAS Consultant

  • Experience in Extraction of data from Data base (DB2, Natezza, MS Excel, etc. ) into SAS. Involved in data analysis And extensively used PROC SQL, PROC FREQ, PROC MEAN, PROC SORT, PROC COMPARE, and PROC PRINT for the data validation.• Experience in Writing SAS macros for the Extracting transactional and summary data for multiple months for given merchant data, card member data and industry data etc.• Experience in creation of summary statistical reports for monthly Audit and production, based on system memory usage and time statistics, using Proc SQL, SAS procedure like Proc sort Proc freq Proc report and SAS/ODS..etc. Also enhanced the code for the automatic report generation.• As part of RAMP team Conducted UAT on different SAS automation application products such as RUN parallel, Grid macro Queue, Stored procedure Model scores etc.• Generated Excel files and created Pivotal table, Graphs and Charts for creating Reports.• Involved in Meta data request, in order to register the table into metadata and check the table status as per the user request type.• Generated customized reports using SAS macro facility, PROC SQL & Data Null techniques.• Involved in production support by providing optimized code in order to support business users and solved different types of technical issues and also involved in user management by using SMC as well.• Maintained and prepared project documentation, testing and validation/quality control documents and programs in compliance with standards. Show less

• 

  C2S Technologies, Inc.

  Sept 2013 - Dec 2013

  SAS Admin

  Created user profile and provide access permission based on roles and responsibleBy using SAS Management console deploy SAS application in Non-PROD, PROD Environment.Application monitoring & Maintenance.

• 

  JPMorgan Chase & Co.

  Jan 2014 - Jul 2014

  SAS Developer

  • Assisted to Business Analyst in Reverse engineering of the existing SAS code in order to develop new the requirement. And contribute to determination of project standards related to output design and statistical (RWA calculation)programming convention and ensure they are appropriate to support project objectives.• Extraction of data from TERADATA in to SAS format by using Proc SQL. And data manipulation and validation as per the report analysis plan• Involved in creation of various Reports including SAS application programs for the data validation, data analysis and data reporting as per the Business requirement and specifications.• Developed new SAS program as per the various new requirements to Basel II and Basel III new logics and calculations.• Involved All phases of testing to make sure that the end product meets business expectations.• Generated customized SAS reports by using different SAS tools and macro• Involved in creation of enhanced macro for all types of Product codes for BASEL II and BASELIII, place into common location, tested and well documented and this can be call for all RWA calculations.• Experience in data analysis, Compared SAS datasets and data variable contents using PROC COMPARE.• Involved In data analysis from data extraction, Exclusion/selection criteria, calculation, and aggregation for BASEL III. Show less

• 

  Citi

  Apr 2015 - Dec 2015

  SAS Programmer Analyst

  As part of CITI Retail Services, CITI initiated the Macys conversion using Best Buy as reference to support portfolio strengthens for Macys created the FDR reports.Part of FDR (First Data Report) followed the same standard and layouts as Best Buy, design & developed and created the MIS reports such as exceptional report, error reports, long-term validation, deferral reports.

• 

  AIM Specialty Health

  Dec 2015 - Mar 2022

  QlikView/QlikSense BI Developer & Lead
• 

  HCA

  Apr 2022 - now

  Application Engineer HCA