KISHORE KADIRVEL

PROJECT: FCIO FINANCE - tPACE -5726

Domain: Banking.

Client: Standard Chartered Bank, Chennai.

RESPONSIBILITIES:

• Understand the Project Scope and Functional requirements as per the ISD Document.
• Create test cases to perform Frontend UI Testing, Sanity, Functional, Regression, Database and ETL Testing.
• Creating complex dynamic SQL as per the business transformation logic in the mapping document which also reduce the test execution time by 50%.
• Executing Test cases in SAPHANA DB tool in SIT Environment and also in LAB, UAT, PRE-PROD Environments if needed.
• Involving in End-to-End Testing with the help of Redwood BPA Automation run tool
• Executing Test cases in DB Visualizer tool to perform Source File Validation
• Creating Java script to perform UI Automation testing and execute Test cases in Database With the help of Java Automation tool
• Involved in Downstream Extract and MSTR Report testing.
• Analyze the data flow based on the mapping logic and identify the gaps.
• Log the Bug/Defect in Azure DevOps tracking tool and follow up till closure.
• Creating Test plans in ADO tool and updating the Test logs and test cases for smoother pipeline run and Release activities
• Involved in Test closure, Traceability Matrix and Test Summary report preparation to get sign off from AO & PO
• Involving in Smoother Deliverables and managing stress, time and supporting weekends.
• Created automation test script to validate the Fiori frontend UI which also helped in Regression testing by reducing the 60% of the testing timelines.

PROJECT: SUNTRA_QA_QC

Domain: Investment Banking.

Client: SUNTRA INVESTMENT BANK

RESPONSIBILITIES:

• Develop complex SQL queries for querying data against different data bases for data validation process.
• Developed ETL test scripts based on technical specification / Data design document and Source to Target mappings.
• Worked into various ETL schema architectures like Fact table, Dimension table and Star schema.
• To take care of Functional, Smoke, Regression and Integration Testing.
• Created test cases, test sceneries and test scripts in Oracle and SQL databases as per the mapping sheet.
• Involved peer - peer validation of test cases and test scripts before the extension.
• Involved SCD2 Table validation to test the data which are loaded in incremental load.
• Involved creation TSR while closing the testing.
• Created Bug in JIRA application to track the bug till the closure and also communicate the status about the bug to the developers.

PROJECT 2: DR_21_QA

Domain: Investment Banking.

Client DRUMMOND INVESTMENT BANK.

RESPONSIBILITIES:

• Analyze the business requirements of new changes request and enhancement from client.
• Test a number of complex ETL mappings and reusable transformation for data loads.
• As per AGILE process attending all meetings includes Scrum and Retrospective meeting.
• Used UNIX Commands to test the files and Tables to the comparison of data.
• Created SQL to validate the various transformations as per the mapping sheet.