• Extensive Data Analysis end to end- starting from the source system through the data warehouse up till the SSRS reports to identify the point of break in data and fix the same.• Responsible for developing complex SSRS reports out of the Enterprise Data Warehouse• Identify new columns for existing tables, new tables to be staged/marted from the source system/stage tables in order to design new SSRS reports as per user requests.• Actively involved with TSAs/BSAs to identify business and technical requirements for developing new SSRS reports and mapping the fields from source systems to data mart for effective reporting.• Handle Support for a wide range of applications including Web apps, Desktop apps, Essbase cubes, Data Warehouse reporting (SSRS).• Develop PL/SQL procedure and complex Oracle views.• Maintaining SSIS packages.• Made major modifications to a Domain Model (Nhibernate) based .Net web application.

• Modified Informatica mappings and workflows as per business requirements• Created and modified SQL Server SPs that fed the SSRS reports• Gathered requirements for the enhancements to be done to the Data Warehouse.• Created and modified SSRS reports• Maintained SSAS cubes

• Gathered requirements & analyzed various scenarios to be tested to ensure smooth migration of the SAP system• Tested various custom applications working on the SAP system • Utilized SAP for analyzing the current system and prepared scenarios for integration with new SAP system• Drove various test scenario discussion meetings with client and got a sign off on the test scripts prepared• Analyzed how the new SAP integration would work and tested the behavior of the new SAP system- creation of quotes, sales orders, invoices etc through SAP

• Responsible for overall impact/business analysis study and interacted with actual Business users to understand the kind of Customizations they needed to the basic banking product that Infosys offers• Responsible for separating out the feasible and non-feasible customization requests from the client being a SME for Finacle• Prepared Unit, Integration and SIT plans and tested the customized Finacle product as per bank requirements agreed upon in the design discussions • Ensured the business requirements are properly mapped and taken care of in the design documents and that the test plans ensure the testability of the same• Actively involved in the UAT phase of the project to help analyze the defects before assigning them to the development team• Liaison between the project team and the internal business users of the bank as well as external users in Indonesia, Taiwan and China