Involved validation of source & target mappings as table name, column name, data type,Between the environment which string the migration process.• Created validation procedure to validate the migrated data in the staging tables and also• Used the functions to validate the functional data dependency between multiple tables.• Created error log process to log the validation errors from the stage tables.• Created packages for the entire migration activities and also data copying procedure between the table-to-table load.• Used Bulk collect and Bulk bind methods to load the data in the batch by batch to the targets.• Used save exceptions to capture the exceptions and run time error while using the bulk bind.

❖ Involved preparation of test script development in ORACLE and SQL SERVER databases using the SQL query techniques like joins, Subquery and analytical functions to validate various transformation logics.❖ Involved Validation of flat files by using of the UNIX commands to check the filename, patterns and permission for the source files. ❖ Created Bug reports in the excel and reported the bugs in the JIRA application to communicate about the bug to development team and for the proper tracking of the bug till the closure.❖ As agile team member, involved attending of agile calls and updated the current status of the working JIRA in the scrum call.❖ Created test summary reports (TSR) to find the test coverage in the time of test closure.❖ Involved peer -peer validation of the test cases, test scenarios and test scripts before executing them in the SIT environment.❖ Involved Smoke testing to validate the application build for the initial, Regression for the impact of the build for the existing functionalities. ❖ Communicated to the business team to get clear about the requirement gaps and understand the functionality where ever the clarifications needed.

• Involved creation of PLSQL programs to achieve the functionalities for the new CR points.• Involved table design for the CR points and created required documents and get approval for the (TDD) Table design document before execution at in the DB.• Involved debugging of existing procedure and packages when the production or UAT bugs happens in the application.• Taken care of release activities in the agile process and also involved deployment activities.• Involved demo of computed points to the UAT people while doingsprint review.• Prepared detail design document for the reach CR, and also RCA for the priority prod issue and also impact analysis document whenever needed.

Having 5 years of experience on a software developing environment with sound knowledge in Oracle 10g/11g Creation of database objects like tables, views, synonyms, materialized views, procedures, packages using oracle tools like PL/SQL developer. Having a knowledge write a complex query by using subqueries, joints, set operators, group functions and analytical functions. Having a basic knowledge in Unix commands like cat, sed , ls, touch, cp, cut, mv, wc, tr, sort, grep, awk, more, less, uniq and vi editors comands. Handled and used the appropriate commands like procedures, functions, triggers and collections. Experienced in constraints, views, synonyms, GTT, Sequences, materialized views and Indexes. Having knowledge in data migration using ETL tool. Involved in performance tuning using explain plan and Index analysis.