Pratish Ranjan

Test scenario and test case preparation with SQL queries based on Technical design and requirement and mapping sheet /document Test case and test script preparation for Power BI dashboard and Report validation Building SQL scripts to validate Report in backend to frontend application Data validation in staging layer to DWH than RDM Power Bi Dashboard and report validation front end to back end Running the workflow in Informatica RDM to load the data respective layer in database

 Test Case preparation with SQL queries based on Technical design and  requirements  Test Scenario and Test Data preparation.  Review test cases and execute SQL queries.  Validate data from Source to Target through various transformation logics  Coordination with Developers, Business Analysts  Participated in regular project standup status meetings related to testing.  Participating agile meeting like, Scrum, Retro, Refinement.

 Validate data from Source to Target through various transformation logics  Prepared status summary reports with details of executed, passed and failed test cases  Coordination with Developers, Business Analysts and Testers.  Participated in regular project status meetings related to testing.  Reporting daily testing status report.  Prepare document for signoff

 Prepared Test Reports and submitted the bug findings to the defect tracking system.  Mobile and tablet device testing  Involved in cross browsing testing of the application on various browsers to ensure it functions.  Interact with Developers and Business Analysts to perform various types of testing throughout Software Testing Life Cycle (STLC)  Interacted with developers, Business & Management Teams and End Users.