Project Description:   

KPMG in India one of the leading provider for Audit and Taxation .KPMG having huge farm in that basically they having huge customer base. It will be very difficult for them to take inquiry manually. We are made it design application is QPR(Quality Process Review) for collect information of the customer through Engagement Leader. Whenever Customer wants to do the Audit basically they not interact with (KPMG) directly Engagement leader are provide link of QPR application through mail. Then fill the inquiry form through engagement leader and QPR central team are review. Then it will incomplete and insufficient data they send back to the engagement leader. If there inquiry sufficient to the audit and taxation they will provide the communication.

Task Performed :

• Analyzed the Mapping sheet properly and design test case.

• Understand the data to be used for reporting, Review the Data Model, Source to target mapping

• Performance testing on data, Review the test case and store review comments in repository  

• Perform Check on Tables like Count check, Duplicate Check, Null Check before and after the transformation logic applied.

• Data flow validation from the staging area to the intermediate tables.

• Run the job using Informatica workflow manager and track all the data in workflow monitor verify session log report.

• Map the requirements vs Test case in JIRA, Execute all the test case and Resister the defect via JIRA.

• Done defect analysis and identify RCA

• Participated in scrum meeting Prepare different types of reports such as weekly report, daily status report.

Project Description:   

HSBC is UK base Company. HSBC is a third party data collection company they are having  daily transaction data into the database. They are collecting the data from different state of UK. This are collecting the data they are used for filtration process by applying ETL logics. We are checking eligibility of customer for taking loan in terms of simple interest or compound interest as per parameters candidate able to take loan also we are checking for manual count and sequel count must be match that all record from source to target moved.

Task Performed :​​​

• Understanding of SRS , Mapping sheet and Created Test Cases from it, Execution of Test Cases.

• Incremental Testing, GUI Testing, Functional Testing of Enhancements & Regression Testing of Defects. 

• Prepared Test Scenario, Test case design, and Review it.

• Performed Functionality Testing, Retesting and Regression Testing.

• Involved in the Behavioral, Input Domain, Error Handling, Calculation, Base, And Service Level Coverage.

• Resister the defect in JIRA.

• Preparation of Test Requirement Mapping and generate Test reports.

• Validating ETL transformation logics by using SQL Queries to validate Count, Duplicate, Null, String length, Data types, Constraint.

• Participation in project Scrum Meeting.