Project Description: Eagle is a product used by CGC for there business requirement. I work on oracle pl/sql database side requirement design and development of custom stories / requirements for this project. I had worked on development of one new application called CCPS. In this application I had designed informatica workflows to load flat files into our staging tables and had designed and developed oracle PL/SQL components to further transform and load data into target tables. From these tables users view business requirement data on there user interface for cash projection etc. I had designed Autosys jobs for this application to create complete data load pipeline. I had worked on some python scripts enhancements also during development for some data pre-processing. I also support both application in production environment since both are business critical application.Role and Responsibilities:  I have been creating technical design document for database solutions for stories. I have been developing code for design I have created. I have been doing python scripts enhancements. Understanding the requirements of the customer technically and functionally. Logical and physical data modelling. Sometimes I analyse AWR / ADDM reports to diagnose performance issues and do performance testing. I do replicate scenarios and do performance testing. In some scenarios I have identified good plan for SQL queries and enforced good plan through DBMS_SPM (Stored plan management) in oracle. Partitioning strategies review for performance improvement. Communication with various client stake holders. UAT (User Acceptance Testing) Support. Impact analysis and efforts estimation. Review of all the work done by self and the junior team members. Defect Prevention and Quality control.  Post-delivery production support.

1. Project Title : Nucleus Migration Role : Database Administrator (Application side) Client : Deutsche Bank, India Employer : Infosys Limited, Pune Duration : May 2018 to Till dateIn Nucleus Migration we are migrating Trade Finance Application from Oracle 11g to Oracle 12c database (Deutsche Bank’s private cloud). In this project I am playing Database Administrator (Application side) role. As Database Administrator (Application side) I am articulating data migration strategy and character set migration approach. I am looking into end to end deliverable to make migration smooth and successful. I have been dealing with database size GBs / TBs. Roles and Responsibilities:Prepared impact analysis document to understand about interface / components getting impacted due to database Migration.Perform pre and post database migration checks to make sure migration is done successfully.Interaction with various client’s & stake holders.Team handling activities for Migration. Impact analysis and efforts estimation.Load testing support.Identifying the scenarios for the issues replication in development environment.

2. Project Title : Mantas EMEA Role : Technology Lead Client : Barclays Bank, UK Employer : Infosys Limited, Pune Duration : April 2016 to Till May 2018MANTAS product is into Anti Money Laundering domain for alert generation for Barclays Bank users on Anti Money Laundering activities. In this project we develop solution to generate feeds for MANTAS. We pull data from various source systems and prepare feeds for MANTAS in format required by MANTAS product. This is ETL kind of project where in we extract data and transform it and load it into MANTAS application. Further MANTAS product generates alerts.

2. Project Title : Collections Desktop Role : Module Lead and Senior Oracle PL/SQL Developer Client : British Telecom, UK Employer : Tech Mahindra, Pune Duration : Dec 2013 to Mar 2016 Collections desktop is credit and debt management system for British Telecom, UK. Collections Desktop receives debt feed from different source systems. Collections desktop will help agents for follow up to customer for debt recovery. This system will continue follow up journey for invoices until invoices are paid. This system will help to do restriction and re-connection in case invoices are not paid until recent period of timeRoles and Responsibilities:Development of feeds which comes from different source systems in flat files. Communication with designers for requirement understanding.Demonstration of functionality to Designers, Business and testing team after development completion.Achievements:• Awarded with Pat on the Back Award in Q1 FY15-16 for delivering critical restriction and re-connection functionality.

3. Project Title : The Insurance Application – Commercial Project Role : Module Lead and Senior Oracle PL/SQL Developer Client : Mutual and Federal, Johannesburg, South Africa Employer : Zensar Technologies, Pune Duration : Sep 2011 to Nov 2013“The Insurance Application” is an Oracle PL/SQL based application. Mutual and Federal SA uses TIA (The Insurance Application) as an administrative tool for their personal and commercial products business. Mutual and Federal has customized this TIA application as per their business requirement. TIA application is developed by Danish company ‘TIA Tech’.

4. Project Title : CISCO Deal Management Role : Team Leader and Oracle PL/SQL developer Client : CISCO (USA) Employer : Tata consultancy services, Mumbai Duration : Aug 2010 to Sep 2011The Quoting support process area takes care of the Cisco Business activities related to Cisco Deals and it also covers the worldwide sales and distributions. Cisco does business with Partners. Cisco Applications manage standard or non-standard deals and discounts for Partners primarily. And Cisco uses Cisco Commerce Workspace (CCW) application and Enterprise Discounting Management System (EDMS) application for the same. I do enhancements and support for these Cisco applications. This involves client interaction, requirement analysis, technical design, and system development and testing, post production maintenance and support.

Project Description: The Insurance Application” is an Oracle PL/SQL based application. Genworth Financial UK uses TIA (The Insurance Application) as an administrative tool for their PPI (Payment Protection Insurance) business. Genworth Financials asks for customization in TIA application as per their business requirement.Roles and Responsibilities:  Bug fixing, coding for enhancements tasks. Enhancement and maintenance of applications. Performing the Unit Testing of the system. Troubleshooting problems faced by users of TIA Application  Production Support Understanding the requirements of the customer technically and functionally.