SUMMARY:

• Around 12 years of experience in Testing and Development.
• Holding Canada PR and H1B Valid Visa
• Currently working as Big Data Test Lead in NV Engergy, Las Vegas.
• 2.5 year of experience in Big Data Testing. Expertise in Hive, Spark, Scala and Sqoop.
• 7 years of experience years in ETL Testing, BI report testing.
• Have achieved Cloudera Spark & Hadoop Developer, OCP (Oracle Certified Professional) and Agile Profession Scrum Master .
• Experience in building Automation Testing framework.
• 2.5 years of experience in Electric Utility domain. Have worked for PG&E, San Francisco and NV Energy, Las Vegas.
• 2 years of experience in Actimize Model (Trade Surveillance domain) testing done for HSBC Bank.
• Around 1 year of experience in Oracle CC&B testing.
• Have worked on HP ALM.
• Expertise in Creating Test Scenarios, Creating and Executing Test Cases and other Testingdocuments like Test Plan, Test Evaluation summary
• Expertise in writing complex SQL queries to validate ETL transformation and BI reports
• Possesses strong knowledge of Big Data concepts, ETL, BI reporting, PLSQL, Database concepts. Have good understanding of Data model.
• Have worked on Agile projects.
• Have good hands on Unix commands.
• Trained on various technologies like SQL, PL/SQL, Datastage, Oracle Forms, Oracle Apps 11i, C, Unix, and Visual Basic.
• Proven record in delivery of Project work through Waterfall and Agile Methodologies.
• Experience in leading teams working for sub modules in projects - offshore and onshore delivery
• Excellent analytical and problem solving skills.
• Ability to deliver multiple projects simultaneously.Roles
• Worked as a QA lead to ensure adequate quality testing is performed.
• Mentoring new QA members.
• Extensively performed ETL, BI Report Testing and Actimize model testing.
• Providing Testing Estimations, Identifying Test Scenarios, Creation and Execution of Test cases and other testing documents like Test Plan, Test evaluation Summary documents.
• Prepared test data for testing, Running the Jobs/Workflow for ETL process, Prepared test SQL queries to verify Dimensional and Fact tables and BI reports.
• Reporting Daily status report.
• Development of SQLs, PL/SQL Stored Procedures, Oracle Forms and Reports.

TECHNICAL SKILLS:

Testing: Big Data, ETL, BI report, Actimize Model testing, Oracle CC&B Testing, Database, Web Testing

Operating System: Linux, Windows, Unix

Databases: Netezza, Teradata, Oracle, DB2, SQL Server

Tools: / Utilities: Hive, Spark, Scala, SQL, PL\SQL, Toad, Putty, SQL Assitant, Remedy, JIRA, Quality Center

BI Tools: Datastage (ETL), Microstrategy ( BI Reporting)

WORK EXPERIENCE:

Confidential

QA Lead

Responsibilities:

• Analyze Business Requirements and Design Documents to prepare Test Plan.
• Extensively performed data validation.
• Sqooping data from sources to setup Test Data in testing environment.
• Develop test scenarios/cases that meet the requirements/specifications.
• Preparation of Hive and Spark SQLs.
• Write/modify test cases and get it reviewed and approved by PG&E stakeholders.
• Execute system test cases and regression test cases.
• Logging of defects encountered in the Defect management tool during System testing and regression testing.
• Providing Testing Estimations
• Prepare dashboard/reports on Test Execution Plan/Progress, Test Summary Report, Defect Status Report, etc.

Confidential

QA Lead

Responsibilities:

• Analyze Business Requirements and Design Documents to prepare Test Plan.
• Extensively performed CC&B testing.
• To setup Test Data in testing environment.
• Develop test scenarios/cases that meet the requirements/specifications.
• Prepare and review traceability matrix, selection of regression test cases and identify reusable test cases.
• Write/modify test cases and get it reviewed and approved by PG&E stakeholders.
• Execute system test cases and regression test cases.
• Logging of defects encountered in the Defect management tool during System testing and regression testing.
• Providing Testing Estimations
• Prepare dashboard/reports on Test Execution Plan/Progress, Test Summary Report, Defect Status Report, etc.

Confidential

QA Lead

Responsibilities:

• Worked as a QA lead to ensure adequate quality testing is performed.
• Extensively performed ETL and dashboard testing.
• To setup Test Data in testing environment.
• Monitored and allocated work to group of 3 QA testers and prompt status reporting to the project manager.
• Understanding the Business logic.
• Discussing the various aspects of the module with the team members.
• Daily status reporting with client.
• Analysis of Data model, Source to Target mapping document and Dashboard mapping document.
• Providing Testing Estimations, Identifying Test Scenarios, Creation and Execution of Test cases and other testing documents like Test Plan, Test evaluation Summary documents.
• Logging the bugs in bug tracking tools.

Confidential

QA Lead

Responsibilities:

• Worked as a QA lead to ensure adequate quality testing is performed.
• Extensively performed ETL and Actimize model testing.
• To prepare Test Data to generate Actimize alerts for different scenarios.
• Monitored and allocated work to group of 6 QA testers and prompt status reporting to the project manager.
• Understanding the Business logic.
• Discussing the various aspects of the module with the team members.
• Daily status reporting with client.
• Analysis of Data model, Source to Target mapping document and Actimize model requirement documents.
• Providing Testing Estimations, Identifying Test Scenarios, Creation and Execution of Test cases and other testing documents like Test Plan, Test evaluation Summary documents.
• Delegating testing tasks to junior testing Members
• Logging the bugs in bug tracking tools.

Confidential

QA Lead

Responsibilities:

• Worked as a QA lead to ensure adequate quality testing is performed.
• Ensure no UAT defects are found.
• Established myself as a single point of contact for all Quality testing related help.
• Monitored and allocated work to group of 6 QA testers and prompt status reporting to the project manager.
• Extensively performed ETL and BI Report Testing.
• Understanding the Business logic.
• Discussing the various aspects of the module with the team members.
• Daily status reporting with client.
• Analysis of Data model, Source to Target mapping document and Report Detail design documents.
• Providing Testing Estimations, Identifying Test Scenarios, Creation and Execution of Test cases and other testing documents like Test Plan, Test evaluation Summary documents.
• Prepared test data for testing, Running the Jobs/Workflow for ETL process, Prepared test SQL queries to verify Dimensional and Fact tables and BI reports.
• Delegating testing tasks to junior testing Members
• Logging the bugs in bug tracking tools.
• Reporting Daily status report.

Confidential

QA Lead

Responsibilities:

• Worked as a QA lead to ensure adequate quality testing is performed.
• Ensure no UAT defects are found.
• Established myself as a single point of contact for all Quality testing related help.
• Monitored and allocated work to group of 4 QA testers and prompt status reporting to the project manager.
• Extensively performed ETL and BI Report Testing.
• Understanding the Business logic.
• Discussing the various aspects of the module with the team members.
• Daily status reporting with client.
• Analysis of Data model, Source to Target mapping document and Report Detail design documents.
• Providing Testing Estimations, Identifying Test Scenarios, Creation and Execution of Test cases and other testing documents like Test Plan, Test evaluation Summary documents.
• Prepared test data for testing, Running the Jobs/Workflow for ETL process, Prepared test SQL queries to verify Dimensional and Fact tables and BI reports.
• Delegating testing tasks to junior testing Members
• Logging the bugs in bug tracking tools.
• Reporting Daily status report.

Confidential

Responsibilities:

• Extensively performed manual and Database Testing.
• Understanding the Business Requirement Document.
• Discussing the various aspects of the module with the team members.
• Daily status reporting with client.
• Analysis of Data model, Source to Target mapping and Report Detail design documents.
• Identifying Test Scenarios, Creation and Execution of Test cases Prepared test data for testing, à Running the Jobs/Workflow for ETL process
• Logging the bugs in bug tracking tools.
• Reporting Daily status report.

Confidential

Responsibilities:

• Extensively performed ETL and BI Report Testing
• Understanding the Business Requirement Document
• Discussing the various aspects of the module with the team members
• Daily status reporting with client
• Analysis of Data model, Source to Target mapping and Report Detail design documents
• Identifying Test Scenarios, Creation and Execution of Test cases prepared test data for testing, à Running the Jobs/Workflow for ETL process
• Logging the bugs in bug tracking tools
• Reporting Daily status report

Confidential

Responsibilities:

• Extensively performed ETL and BI Report Testing.
• Understanding the Business Requirement Document.
• Discussing the various aspects of the module with the team members.
• Daily status reporting with client.
• Analysis of Data model, Source to Target mapping and Report Detail design documents.
• Identifying Test Scenarios, Creation and Execution of Test cases Prepared test data for testing, à Running the Jobs/Workflow for ETL process
• Logging the bugs in bug tracking tools.
• Reporting Daily status report.

Confidential

Responsibilities:

• Extensively performed ETL and BI Report Testing.
• Understanding the Business Requirement Document.
• Discussing the various aspects of the module with the team members.
• Daily status reporting with client.
• Analysis of Data model, Source to Target mapping and Report Detail design documents.
• Identifying Test Scenarios, Creation and Execution of Test cases Prepared test data for testing, Running the Jobs/Workflow for ETL process
• Logging the bugs in bug tracking tools.
• Reporting Daily status report.

Confidential

Responsibilities:

• Development of SQLs, PL/SQL Stored Procedures, Oracle Forms and Reports.
• Understanding the Business Requirement Document.
• Discussing the various aspects of the module with the team members.
• Daily status reporting with client.
• Analysis of Data model.
• Unit Testing.