Description
Mar /15 - Present Syntel Inc. Technical Specialist Mar /15 - Present Technical Lead Phoenix AZ U.S. (Client: American Express) * Designed and developed complex mappings by using Lookup Expression Update Sequence generator Aggregator Router Stored Procedure etc. transformations to implement complex logics while coding a mapping. * Written SQL Scripts and PL/SQL Scripts to extract data from Database and for Testing Purposes. * Performed performance tuning at the Mapping level as well as the Database level to increase the data throughput * Built reusable transformations and mapplets wherever redundancy is needed. * Assisted in building the ETL source to Target specification documents by understanding the business requirements * Identified areas of improvement developed automation scripts to reduce manual effort by 40% from 10hrs to 6hrs. * Improved resource utilization (reduced from 5 to 3) with the help of optimization and automation. * Provided observations of the overall system suggested automated steps to full-fill Business operations and the requirements. * Improved the Incident to Problem mapping (71.62%) by Problem management process. * Analyzing incidents/problems raised by business partners to keep system functioning as designed and to meet service level agreement provide Root Cause Analysis (RCA) for the impacted components with high business risk. * Managing offshore team and coordinating between Offshore - Onsite teams. Jul /10 - Mar /15 Infosys Limited - Sr. Systems Engineer Mar /12 - Mar /15 Sr. Systems Engineer Pune India (Client: American Express) * Providing effective resolution to client reported issues on the daily and monthly basis. * Perform root cause analysis on all processes and resolve all production issues. * Automated alert for data availability to business. * Monitored all business requirements and overall system. Monitoring Scheduled jobs in CONTROL-M troubleshooting job failures and providing timely resolution. * Attending turnover meetings for the changes and new implementations going into the production environment. Jan /11 - Feb /12 ETL Developer Pune India (Client: Pfizer Inc) * Created UNIX shell scripts to run the Informatica workflows for controlling the ETL flow. * Created new mapping designs using various tools in Informatica Designer like Source Analyzer Warehouse Designer Mapplet Designer and Mapping Designer. * Validate all data and perform routine tests on databases. * Worked with business and functional teams to extract the requirements.