● Created test plans in Azure Devops by reviewing the product backlog and BRD documents for each release; led the test team and worked as a Team Lead which comprises of UI, DB, ETL and Data visualization testing and designed and developed sophisticated QA documentation like Test Cases and Test scenarios from business and functional requirements.● Identified the requirements and arranged stakeholder meetings, peer reviews, walkthroughs and sign off meetings. Performed SQL validation to verify the data extracts and record counts in the database tables by writing complex SQL queries.●Experience in manual testing which involves UI based application testing and testing REST APIs using Postman. Automation of ETL tests using python and pyspark in data bricks and used query surge for the ETL automation.● Created Test Case documents in MS Excel template from the Test Plan and the Business Requirements documents; prepared test cases by understanding the business requirements Data Mapping documents and technical specifications.●Used Deaver for Querying POSTGRESS and used Databricks for Querying data and coordinated with development team in system integration testing. Exported Manual Test Cases from Microsoft Excel template directly to HP Quality Center and executed all the Test Cases in Quality Center with Pass/Fail/Blocked status.● MS Power platform testing involves testing the functionality of the Power BI report. ● Used Teradata Sql assistant for Querying Teradata and coordinated with development team in system integration testing

Worked through Ravish Consulting Inc for Rogers Bank as contractorCreated test plans in Azure Devops by reviewing the product backlog and BRD documents for each release; led the test team comprised of DB, ETL and Data visualization testing; design and developed first rate QA documentation like Test Cases and Test scenarios from business and functional requirements.● Automation of ETL tests using python and pyspark in data bricks.● Identified the requirements and arranged peer reviews, walkthroughs and sign off meetings. Performed SQL validation to verify the data extracts and record counts in the database tables by writing complex SQL queries.● Experience in manual testing which involves UI based application testing, automation of ETL tests using Python; created Test Case documents in Microsoft Excel template from the Test Plan and the Business Requirements documents. Prepared test cases by understanding the business requirements Data Mapping documents and technical specifications. coordinated with development team in system integration testing.● Exported Manual Test Cases from Excel template directly to HP Quality Center and executed all the Test Cases in Quality Center with Pass/Fail/Blocked status. Worked extensively and in cross-functional ways with backend activities for testing several reports developed by BI tools and SQL Queries to verify and validate the Database Updates.

Worked for Multiple clients Design and Development of QA documentation like Test Cases and Test scenarios from business and functional requirements. Identified the requirements and arranged peer reviews, walkthroughs and sign off meetings.● Used HP Quality Center 9.0 for Test Estimation, Test Planning, Test Designing, Test Analysis, Test Execution, Defect Tracking and Test Result; performed SQL validation to verify the data extracts and record counts in the database tables by writing complex SQL queries.● Experience in manual testing which involves UI based application testing of Qlik sense dashboards and in data warehouse testing includes star schema, snowflake schema and face constellation schema. Tested the ETL mappings from Source to Target and Complex Reports in Data visualization functionalities like Slice and Dice Drill down Functions Cross Tabs Master/Detail and Formulae.● Written test cases for checking the populated data correctly into fact and dimension tables. Created Test Case documents in MS Excel template from the Test Plan and the Business Requirements documents. Prepared test cases by understanding the business requirements Data Mapping documents and technical specifications.● Used SQL developer for Querying ORACLE and used Teradata Sql assistant for Querying Teradata; coordinated with development team in system integration testing and worked on power center tools like Designer, workflow monitor and workflow manager to schedule sessions and workflows.

● Created test plans by reviewing the product backlog and BRD documents for each release; led the test team comprised of DB, ETL and Data visualization testing; design and developed first rate QA documentation like Test Cases and Test scenarios from business and functional requirements.● Automation of ETL tests and data visualization tests using python and pyspark in data bricks.● Identified the requirements and arranged peer reviews, walkthroughs and sign off meetings. Performed SQL validation to verify the data extracts and record counts in the database tables by writing complex SQL queries.● Developed power BI dashboards connecting to the data mart layer.● Worked on creating multiple worksheets and self service power BI dashboards connecting to multiple sources.● Experience in manual testing which involves UI based application testing, automation of ETL tests using Python; created Test Case documents in Microsoft Excel template from the Test Plan and the Business Requirements documents.