PROFESSIONAL SUMMARY:

• Almost 9 years of extensive experience Worked in the technologies such as Data warehousing(ETL/BI) Testing, Big Data Testing and Web Services Testing
• Worked in domains such as Healthcare, Insurance, Travel, Retail and Banking(BFSI)
• Manage and Lead the QA team on deliverables and guide them through planning and execution phases and enable seamless coordination with development, Stakeholders and business team
• Involved in preparing Baseline estimations for the projects using Test Case Point Estimation methodology and Agile based Planning Poker methodology.
• Resource planning for optimum usage and enablement of delivery targets
• Participates in project meetings and leads the team members in delivering quality and assists them in better understanding of the project requirements.
• Act as liaison with the Client’s personnel to ensure the availability of adequate hardware, software, communication infrastructure, technical support and other resources for the team
• Participated extensively in Functional Testing, Integration Testing, System Testing, Regression Testing, Database Testing, Web services, Application/UI and Smoke/Sanity Testing
• Involved in preparation of Test Estimation, Test Strategy, Test Plan, Test Queries and Data setup, Test Design and Test Execution
• Performed functional testing using databases such as Oracle SQL Developer, Teradata SQL Assistant, IBM DB2, and Big data tools such as Mark logic NoSQL Database, Cloudera Impala, Apache Hadoop, HDFS, Sqoop and Hive
• Ensured the testing process by adopting the following tools HP Quality center/ALM, FACETS healthcare application, IBM RQM, IBM RTC, Health Edge, SOAP UI, REST Client and Beyond Compare
• Guide team members through complex technical requirements and mentoring them for their career progress.
• Acting as a SME for some of the applications.
• Actively reviewed the test deliverables and taken care on Change Requests as well.
• Monitor the overall work load and make any changes required to team size
• Innovative to enforce Automation wherever applicable.
• Technically strong enough to solve complex business scenarios efficiently.
• Handled defect triage in efficient manner and tracked the defects properly and bring to closure at right time.
• Identifying risks upfront so that they can be resolved before it becomes an issue and thereby ensuring deliverable quality is not impacted.
• Build Knowledge repository at offshore
• Continuously monitor risks, escalate issues & concerns, come up with mitigation plan and ensure on - track delivery.
• Ensure QA process adherence to the greatest precision
• Interview new candidates and hire them for my team
• Track and evaluate the performances of the resources reporting to me and make recommendations for Promotions
• Conduct knowledge transition within the team to get acquainted with existing applications and also provided training sessions on Big data Technology tools
• Encourage/Recommend team to identify new methodologies/approach to test the data without any manual intervention
• Implement effective ideas to bring in savings for various projects/initiatives using automation.

TECHNICAL SKILLS:

Hardware/Platforms: Windows XP/7/Unix

Technology: Data warehousing - ETL/BI Testing, Bigdata/Hadoop Testing, Web Services Testing

Programming Languages: SQL, XQuery, Unix

Databases: Hadoop-Hive, Cloudera Impala, Oracle 10g, Teradata, IBM DB2, Mark logic (NoSQL Database)

Tools: Hadoop HDFS, Sqoop, Jira, Jenkins, PUTTY, WinSCP, HP Quality Center, HP ALM, Beyondcompare, Toad, IBM ClearQuest, Informatica, Cognos

Web Services Tools: REST Client, SOAP UI, Postman application

Automation Tools: Selenium

Test Methodology: Agile Model, Waterfall Model, Incremental Model, Iterative model

PROFESSIONAL EXPERIENCE:

Confidential, Windsor, CT

ETL/Bigdata QA Engineer

Responsibilities: 

• Worked as Test Lead in Agile Test Methodology environment
• As part of Agile scrum team, attended Refinement calls to understand the requirements and prioritize the tasks and add the tasks to the sprint from Backlogs
• As part of Agile scrum team, attended Planning calls Involved in preparing baseline Test estimations for the Sprint tasks using Agile based Planning Poker methodology
• Responsible for creating complete test plans, test cases, test data and do Requirement Traceability Matrix in HP ALM ensuring accurate coverage of business requirements
• Responsible to provide the QA status in the Daily standup calls to Scrum master
• Responsible to validate the data by accessing the Cloudera impala database where the daily feeds are processed through HIVE and stored in the HDFS
• Test the web services data which is in JSON format using Postman or SOAP UI application
• Performed data validation testing writing complex SQL queries in Cloudera Impala
• Analyzed large data sets by running Hive queries around 15 billion records
• Validated Analytics UI application and verify the data populated as per the requirements
• Responsible to review the test cases and do the Test Execution in HP ALM
• If any deviations observed when compared to requirements, responsible to raise the defects based on severity and priority in JIRA tool and assign to responsible team and track the defects until its closure
• Responsible to prepare the Sprint reports and present in the Demo call to the Product owners and stakeholders to get the Go/No Go call
• Responsible to do the Regression testing before the cutover of UAT/Production and Sanity testing after it deployed in the corresponding environments
• Automate the regression test cases using Selenium tool
• As part of Agile scrum team, attended Retrospective calls to discuss what went right and wrong in the completed sprint

Environment: Apache Hadoop - CDH 5.0.2 - 2 clusters each 40 Nodes, HDFS, Hive, Cloudera Impala, HP ALM, SOAP UI, Selenium, Jira, Jenkins, Putty, Cloudera HUE 3.9.0, SQL and UNIX

Confidential, Charlotte, NC

ETL/Big data QA Engineer

Responsibilities: 

• Worked as Test Lead in Waterfall/Iterative Test Methodology environment
• Responsible for creating complete test cases, test plans, test data and do requirement traceability matrix to ensure accurate coverage of requirements
• Analyzing requirements and creating and executing test cases
• Involved in ETL process testing using Informatica ETL tool
• Performed Integration, End-to-End, system testing
• Involving in Functional Testing & Regression Testing
• Involving in writing SQL queries and Database Checkpoints to verify data quality and calculations, reviews
• Performed data validation testing writing SQL queries.
• Wrote complex queries in Oracle SQL developer to check the data from Source and Target
• Involved in the Data migration testing where data moved from RDBMS Oracle to Apache Hadoop HDFS using Sqoop tool
• Analyzed large data sets by running Hive queries
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica.
• Working on Quality Center/ALM for creating and documenting Test Plans and Test Cases and register the expected results
• Test Case Execution and Adhoc testing using HP ALM tool
• Organizes defect review meeting on daily basis to prioritize the defects
• Responsible to do the Regression testing before the cutover of UAT/Production and Sanity testing after it deployed in the corresponding environments
• Prepares the daily/weekly status reports and project summary reports
• Responsible to present the committed product in Demo call to the Product owners and stakeholders to get the Go/No go call

Environment: Apache Hadoop, HDFS, HIVE, Sqoop, Oracle SQL developer, WinScp, Putty and HP ALM

Confidential, IN 

Senior QA Engineer - Individual Contributor

Responsibilities:

• Worked as Individual Contributor in Agile Test Methodology environment
• As part of Agile scrum team, attended Refinement calls to understand the requirements and prioritize the tasks and add the tasks to the sprint from Backlogs
• As part of Agile scrum team, attended Planning Calls Involved in preparing baseline Test estimations for the Sprint tasks using Agile based Planning Poker methodology
• Responsible for creating complete test plans, test cases, test data and do Requirement Traceability Matrix in HP ALM ensuring accurate coverage of business requirements
• Responsible to provide the QA status in the Daily standup calls to Scrum master
• Responsible to validate the data by accessing the Cloudera impala database where the daily feeds are processed through HIVE and stored in the HDFS
• Test the web services data which is in JSON format using Postman or SOAP UI application
• Validate the Booking Analytics UI application and verify the data populated as per the requirements
• In HP ALM, the test cases are pulled to Test Lab and responsible to do the Test Execution
• If any deviations observed when compared to requirements, raise the defects based on severity and priority in JIRA tool and assign to responsible team and track the defects until its closure
• Responsible to prepare the Sprint reports and present in the Demo call to the Product owners and stakeholders to get the Go/No Go call
• Responsible to do the Regression testing before the cutover of UAT/Production and Sanity testing after it deployed in the corresponding environments
• Automate the regression test cases using Selenium tool
• As part of Agile scrum team, attended Retrospective calls to discuss what went right and wrong in the completed sprint

Environment: Apache Hadoop, HDFS, Hive, Cloudera Impala, HP ALM, Postman, SOAP UI, Selenium, Jira, Jenkins, Putty, Booking Analytics Application

Confidential

QA Test Lead

Responsibilities:

• Worked as Test Lead in an Agile Test Methodology environment
• Responsible for creating complete test cases, test plans, test data and do requirement traceability matrix to ensure accurate coverage of requirements
• Analyzing requirements and creating and executing test cases
• Involved in ETL process testing using Data stage ETL tool
• Performed Integration, End-to-End and System testing. Webservices testing using SOAP UI tool
• Involved in Functional Testing & Regression Testing
• Involved in writing SQL queries and Database Checkpoints to verify data quality and calculations, reviews
• Performed data validation testing writing SQL queries.
• Wrote complex SQL queries in DB2 to check the data from Source and Target
• Used NoSQL database Marklogic to access the data by running Xquery queries
• Working on HP Quality Center/ALM for creating and documenting Test Plans and Test Cases and register the expected results
• Test Case Execution and Adhoc testing using HP ALM tool
• Organizes defect review meeting on daily basis to prioritize the defects
• Responsible to do the Regression testing before the cutover of UAT/Production and Sanity testing after it deployed in the corresponding environments
• Prepares the daily/weekly status reports and project summary reports
• Responsible to present the committed product in Demo call to the Product owners and stakeholders to get the Go/No go call

Environment: Windows 7, IBM DB2, Data stage, Mark logic NoSQL Database, SOAP UI tool, HP ALM, Putty

Confidential

QA Test Analyst

Responsibilities:

• Responsible for creating complete test cases, test plans, test data and do requirement traceability matrix to ensure accurate coverage of requirements
• Analyzing requirements and creating and executing test cases
• Performed Integration, End-to-End, system testing
• Involving in Functional Testing & Regression Testing
• Involving in writing SQL queries and Database Checkpoints to verify data quality and calculations, reviews
• Performed data validation testing writing SQL queries.
• Wrote complex queries in Oracle SQL Developer to check the data from Source and Target.
• Worked on validating the Facets application upgrade testing end to end
• Worked on Obamacare project using Facets application - Subscriber Enrollment, for CP and SHOP members who enrolled through State Exchanges and the file transmitted through EDI gateways and Billing and Subsidiary modules
• Worked with different sources like flat files, XML files
• Working on Quality Center/ALM for creating and documenting Test Plans and Test Cases and register the expected results
• Test Case Execution and Adhoc testing using HP ALM tool
• Organizes defect review meeting on daily basis to prioritize the defects
• Responsible to do the Regression testing before the cutover of UAT/Production and Sanity testing after it deployed in the corresponding environments
• Prepares the daily/weekly status reports and project summary reports
• Responsible to present the committed product in Demo call to the Product owners and stakeholders to get the Go/No go call

Environment: Windows XP, Oracle SQL developer, HP Quality Center, Facets Application, PEGA application, Putty

Confidential

QA Test Engineer

Responsibilities:

• Responsible for creating complete test cases, test data and do requirement traceability matrix to ensure accurate coverage of requirements
• Analyzing requirements and creating and executing test cases
• Involved in ETL process testing using Informatica ETL tool
• Performed Integration, End-to-End, system testing
• Involving in Functional Testing & Regression Testing
• Involving in writing SQL queries and Database Checkpoints to verify data quality and calculations, reviews
• Performed data validation testing writing SQL queries.
• Wrote complex queries in Teradata SQL assistant to check the data from Source and Target.
• Used Teradata utilities (MLOAD & FLOAD) to load the source files in to test region. And did the querying on the same data.
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica.
• Working on Test Director/HP Quality Center for creating and documenting Test Plans and Test Cases and register the expected results
• Test Case Execution and Adhoc testing using HP Quality Center tool
• Logged the defects in IBM ClearQuest and Participated in defect review meeting on daily basis to report and explain the defects to SME/BA in calls
• Responsible to do the Regression testing before the cutover of UAT/Production and Sanity testing after it deployed in the corresponding environments
• Prepares the daily/weekly status reports

Environment: Windows XP, Teradata SQL assistant 7.2, IBM ClearQuest, Test Director, HP Quality Center, WinScp, Putty, Informatica

Confidential

Programmer Analyst - QA Test Engineer

Responsibilities:

• Responsible for creating test cases, test plans, test data and do requirement traceability matrix to ensure accurate coverage of requirements
• Analyzing requirements and creating and executing test cases
• Involved in ETL process testing using Informatica ETL tool
• Performed Integration, End-to-End, system testing
• Involving in Functional Testing & Regression Testing
• Involving in writing SQL queries and Database Checkpoints to verify data quality and calculations, reviews
• Performed data validation testing writing SQL queries.
• Wrote complex queries in Oracle through Toad tool to check the data from Source and Target
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica.
• Working on Quality Center/ALM for creating and documenting Test Plans and Test Cases and register the expected results
• Test Case Execution and Adhoc testing using HP Quality Center tool
• Responsible to do the Regression testing before the cutover of UAT/Production and Sanity testing after it deployed in the corresponding environments

Environment: Windows XP, Toad, Oracle 10g, HP Quality Center, WinScp, Putty