Srinivasa Rao Byrapudi

WORK HISTORY

EDUCATION

ABOUT SRINIVASA RAO BYRAPUDI

PNC Bank- IT professional with 11 years of experience in ETL Production support, Maintaining, enhancing projects in Data warehousing and OFSAA applications.Having more than 10 years of experience in Anit-Money laundering (AML) with Oracle product OFSAA.Data warehousing exposure with exceptional background in application support, analysis of production batch issues and providing the right solutions to fix the issues. Batch monitoring over 500+ jobs ETL and reporting jobs which run through Unix and having scheduled on CA7.Good experience with creating the SCD Type1 and Type2 mapping to load and maintain Data warehouse using Surrogate Keys.Extensively worked on various transformations like Source qualifier, Expression, Joiner, Lookup, Filter, Router, Update Strategy, Aggregator and Sequence generator.Single point of contact for a very large AML based application. Handling all the production issues for major application without any escalations.Extensively supporting Hadoop based application batch monitoring over 600+ jobs.More knowledgeable in debugging the logs for hive, sqoop and spark code and work with platform teams to fix the production issues on time.Actively involved the BC (Business Continuity & Disaster recovery) event for the application from one data center to other data center.Actively monitoring the Dynatrace tool for health check of application web-sphere and UI server and if need restarting the services on time without any user issues.Hands on experience in Informatica, Unix, Oracle, DB2, Hive and Sqoop.Over 10 years\' experience working with AML Compliance and Risk Management applications.Technology Skills:ETL - Informatica, Oracle - SQL/PLSQL, UNIXOFSAA - Oracle Financial Services Analytical Applications DB2 MainframeALM (Application Life Cycle Management)Hive, Impala and SqoopSoftware Tools:uDeploy, ArtiFactory, ServicewNow, HarvestUCC7, INFOMAN, TOAD, PUTTY, WIN SCP,OFSAA and Dynatracr monitoring.