RISHABH CHAUHAN

Project- Finance on the cloud (ETL and DATABASE Testing)

• As test lead, reported on updates to project specifications and progress.
• Created plans and communicated deadlines to complete projects on time.
• Worked on test plan , test cases and test scripts creation and reviewing test cases and scripts of team members (Team size -3-4)
• Taking responsibility of timely delivering evidences and reports for test execution and received recognition for quality delivery
• Collaborated with business requirement team, build and design team to produce customized SQL scripts for testing requirements.
• Created spreadsheets using Microsoft Excel for daily, weekly and monthly reporting.
• Authored and maintained well-organized, efficient and successful manual test cases for entire team.
• Prepared variety of different written communications, reports and documents.

Project- - Stressed Exit for HSBC

• Collaborated with teams to define, strategize and implement test strategies.
• Kept SQL scripts and test cases updated with current requirements.
• Worked on testing of migration of data from Google Cloud (GCP) to Azure
• Worked on Google Cloud Platform- BigQuery (GCP) and Jupyter Notebook for executing SQL queries to perform data validation testing.
• Worked on end to end data validation including source to target data validation using SQL scripts, performing regression checks for balances and count of records using GROUP BY function.
• Comparing balances between Source and Output table using pivot analysis in Excel and comparing with numbers in Tableau.
• Validated reports for regulatory reporting.
• Documented testing procedures for developers and future testing use.
• Developed and maintained defect databases for known issues.

• BlueKC healthcare domain (ETL testing project)

Authored and maintained well-organized, efficient and successful manual test cases for entire team.

Tracked, prioritized and organized defects with JIRA, working with development team to facilitate timely corrections.

· Involved in execution of PowerCenter and Cloud Integration Hub (CIS) related job feeds for respective applications.

· Involved in end-to-end System and Functional testing for various change requests.

· Managing ETL testing of backend database by executing SQL queries for comparing data in Stage tables, transformation logic and data mapping.

· Involved in validation of PowerCenter target data with CIH (Cloud) target data and the data and count should match.

· Successfully validated the migration of data from Informatica database to Cloud database.

Operated under Agile and Scrum frameworks to complete releases and well-organized sprints.

Tracked, prioritized and organized defects with JIRA, working with development team to facilitate timely corrections.

• (ETL and database testing project- Datahub and TDM project)
• Authored and maintained well-organized, efficient and successful manual test cases for entire team.
• Operated under Agile and Scrum frameworks to complete releases and well-organized sprints.
• Developed and maintained defect databases for known issues.
• Tracked, prioritized and organized defects with RALLY, working with development team to facilitate timely corrections.
• Verification of synthetic and masked data which is generated through ADA (Artificial Data Amplifier) tool.
• Validated functionality, outputs and response time of applications from front end perspective where original data is replaced with synthetic data.

(Credit risk project- ZEUS)

· Involved in Business requirements Analysis, Test Scenario preparation, Test Data preparation, Test execution, Bug Reporting and Tracking till closure using Quality Center.

· Performed review of Test artifacts.

· Involved in System Integration testing Smoke testing, Sanity testing and Regression testing.

· Involved in end-to-end System and Functional testing for various change requests.

· Managing ETL testing of backend database by executing SQL queries for comparing data in Stage tables, transformation logic and data mapping.

· Managing Unix testing for upstream database system by executing unix shell script commands for loading data from source files to Stage tables and Data tables, for comparing data between source files and Stage tables.

· Responsible for updating Regression test pack based on new specifications.

· Accountable for Daily status reporting to Manager for testing progress.

Met with quality assurance, developers and project managers to assess scope and sequence of project.

Participated in available trainings to improve software knowledge.

• For Barclays bank as a client (Credit risk project- BASEL).
• Created comprehensive test plans, test scripts and use cases to support testing objectives.
• Reviewed, evaluated and identified requirements for testability.
• Analyzed test results and prepared system-level evaluation reports to verify and validate system performance.
• Managed time and test system resources to meet quality objectives and cost estimates.
• Provided technical support to development teams and debugged test systems.
• Planned, designed and performed manual and functional project testing and reported defects.
• Involved in verification of various Regulatory and Economic reports such as Cluster summary report, EC heat map report etc. based on profit center, company code
• Involved in calculation of RWA and Capital for various counterparties under both STD and IRB approach.
• Helped end users in generating UAT reports on new change requests every quarter.