• Performed Database Testing and optimization of Store Procedures.• Analyzing requirements and creating and executing test cases.• Create the Test plan, get it reviewed and approved/ signed-off by the relevant stakeholders.• Test Estimation: Estimate the test effort and team (size, skills, attitude and schedule).• Review the test cases and test data generated by the Software Test Engineers and get them to address the review comments.• Track the new/ updated requirements in the project and modify testing artifacts accordingly.• Test Case Execution and Adhoc testing.• Involving in Functional Testing and Regression Testing.• Involving in writing complex SQL queries to verify data from Source to Target.• Performed data validation testing writing SQL queries.• Experienced in retest the existing test cases with the different kind of source systems for different periods of data.• Updating and tracking of execution of test cases on JIRA.• Updating and tracking of defects on JIRA.• Preparing documentation for some of the recurring defects and resolutions and business comments for those defects.• Handling of daily status call with the onsite project coordinator and clients.

.

Strong hands-on DB/ DWH testing experience in a database development/ testing environment. Proficient in SQL code writing on MS SQL environment.Basic knowledge of core java