SUMMARY:

• Seasoned professional with over 14+ Years of hands - on experience in diversified fields of the Software Development Life Cycle.
• Expert in managing testing lifecycle process end to end using Waterfall & Agile methodologies.
• 10+ years of experience as a Test Lead in multiple projects managing and delivering enterprise scale software on-time and quality with their scope intact.
• 10+ Years of experience in Executing Test Team management activities including staffing, training, team building, supervising, assessing teams and individual’s performance.
• 10 Years of experience in Executing Test Process management entailing process definition, documentation and constantly review and improve process to make it integrated, repeatable and reliable.
• Strong domain knowledge in Insurance (P&C), OPAS/AS400 Annuity Products, Banking & Financial Services, Health Care, AgriScience and Education Systems.
• Extensive experience in Manual, Automation, ETL/Data warehouse and Webservice/API Testing.
• Extensive experience in Mobile Testing working in a Mobile lab environment where Tech lead, Developer and Test Lead co located and work together closely and validate the rapid mobile apps (Native/Web Apps/Hybrid) testing functionality.
• Proficient in Black box and white box testing.
• Proven track record for providing strong leadership, vision and energy to execute and deliver on complex projects while managing and supporting productive teams.
• Attained 1 to 2 Week Early Time to Market by Proposing and Implementing Risk Based Testing Technique in Auto Insurance.
• Ability to Understand Client Problem Statements, goals and provided optimal solutions.
• Analyzed current process, challenges and practices followed within the project Team and proposed/implemented Process Improvement utilizing Best practices
• Ability to work both as a team and individual.
• Collaborative and pragmatic with strong communication and interpersonal skills as well as a keen interest in the emerging technologies.

TECHNICAL SKILLS:

Mobile Testing: Using Devices and Perfect Mobile Simulator Experience Level Total Years Last Used est Project Management Test Plan, Strategy, Design, Execution and Traceability MatrixExperience Level Total Years Last Used HP Quality Center/ALM Microsoft Test Management Microsoft Azure DevOps

Automation: Selenium WebDriver with Java, Maven, POM, Data Driven, TestNG and Cucumber BDD Framework, Jenkins

GitKraken, GitHub, git

Web Service Testing: SoapUI and Postman

API Automation Testing: ReadyAPI

ETL Testing: Oracle SQL Developer, DbVisualizer, PostgreSQL

Database Testing: Microsoft SQL Server Management Studio

NoSQL database Testing: MongoDB Compass Community

Database Testing: IBM IMSTEST, TSOA, DB2, MySQL - TOAD

ETL Big Data Testing: Cloudera Hue

Defect Management Tool: Atlassian JIRA

Defect Management Tool: HP ALM

Defect Management Tool: Rally

Defect Management Tool: Borland Star Team

Defect Management Tool: MTM and Azure

PROFESSIONAL EXPERIENCE:

Confidential, Johnston, Iowa

Senior QA Test Engineer

Roles and Responsibilities:

• Review and Analyze Business Requirements, Design Abstract, Mapping documents and determine testability for each Component of the Product.
• Developed Test Effort Estimation for each product Release based on the scope and timeline.
• Developed Test Plan and conducted walkthrough with Confidential Stakeholders.
• Derived Test strategy based on the requirement, change type from project start through implementation.
• Attend Sprint Planning, Story Refinement, Sprint Retro and Sprint Review
• Attend Daily Standup and report Test Design and Execution status and impediments.
• Performed Automation Feasibility Analysis and identify scenarios for Test Automation Development
• Developed API Automation test scripts for API layer Testing using ReadyAPI tool and groovy script as main programming language.
• Monitored and applied version control of the automation test scripts using GitKraken.
• Developed Complex SQL Prod Monitoring Scripts to automate grower compensation calculations and payments using Microsoft SQL Server Management Studio
• Attend weekly automation status meeting and provide status on Test Automation progress.
• Closely worked with the Scrum Team, QA Testers, Developers and translated user stories, process diagrams and other non-functional requirements into testable acceptance criteria using Microsoft Test Management and Azure DevOps;
• Design and documented the Test Cases in Microsoft Test Management and Azure DevOps for every sprint.
• Collaborate with Technical Lead for unit and integration testing; Reviewed unit and integration test plans/results.
• Performed Smoke, Integration, System, End to End, Regression Testing, Prod Validations, Backend Database testing, UAT Co-ordinations and logged defects in Microsoft Test Management and Azure.
• Worked on SAP Upgrade project SAP R/3 to S/4HANA and performed end to end migration testing.
• Performed Role based Security testing for the SeedPro Web application
• Coordinated Weekly Release Planning and Execution - Assessed Done Stories and Conducted Go/No-Go meeting for weekly Prod release.
• Demonstrated the features implemented in the sprint review meeting with the core project and leadership team for every sprint release.
• Mentor offshore QA team members and involved in onshore-offshore Co-ordinations.

Confidential - Richmond, Virginia

QA Lead

Roles and Responsibilities:

• Review and Analyze Business Requirements, User Stories, Mapping documents, Design Abstract, DRT elements and determine testability for each Component of the Product.
• Test Planning and Estimation.
• Developed Test Automation Scripts using Selenium WebDriver and Java as programming language with Cucumber BDD Framework.
• Monitored and applied version control of the automation scripts using Git.
• Utilized Jenkins for Continuous Integration and Maven for Build Management.
• Developed Complex Hive (HQL) queries using Cloudera Hue and perform ETL Big data testing on Hive tables for the Historic and Incremental data load. Validation includes Data staging accuracy, dedupe logic check, Datatype conversion, null check and DDL matches as per the business requirements and mapping.
• Developed MongoDb-NoSQL Query to validate JSON data loaded from hive tables and verify the business rules and transformations applied correctly in Mongo staging and Bigcollection using MongoDB Compass Community.
• Performed Rest API testing for different HTTP request and validated the response code and JSON data as per the API specification.
• Design and documented the Test Cases in Atlassian Jira for every release.
• Collaborate with Technical Lead for unit and integration testing; Reviewed unit and integration test plans/results.
• Conducted Smoke, System, Integration, Regression Testing and logged defects in the defect tracking tool Jira.
• Conducted Defect triage meeting and be the focal point for defect management and Co-ordinated with the developers to fix the defects logged in Jira.
• Created a Daily QA status report and send it to core project team.
• Served as a SPOC for QA Deliverables between the Project Team and offshore.

Confidential, West Des Moines, Iowa

ETL - QA Lead

Roles and Responsibilities:

• Spearheaded EDM Initiative from project start through implementation.
• Review and Analyze Business Requirements, Mapping documents, Design Abstract, DRT elements and determine testability for each Component of the Product.
• Developed Test Effort Estimation for each product Release based on the scope and timeline defined.
• Developed Test Plan and conducted walkthrough with Athene Stakeholders.
• Plan the tests including selecting test approaches, estimating the time and effort, acquiring resources, defining test levels, cycles, and planning incident management.
• Developed SQL Queries in DbVisualizer and perform Data Migration Testing in different hops to make sure that data has been migrated correctly with the correct data types as per the mapping documents and matches between Source and Target.
• Ensured data structure integrity check in the target database by verifying record count match, duplicate check, insert, update, transformation, datatype, calculations, and Field length as per the data validation guidelines.
• Tested Sales f orce Application data against the Business Object report generated from the new Sales dm and ensure that data matches between the report and Sales f orce Application.
• Collaborate with Technical Lead for unit and integration testing; Reviewed unit and integration test plans/results. Reviewed the system, integration tests prepared by testers.
• Conducted Smoke, System, Integration, Production support, Regression Testing and logged defects in the defect tracking tool HP ALM.
• Conducted Defect triage meeting and be the focal point for defect management and Co-ordinated with the developers to fix the defects logged in HP ALM.
• Generated Requirement traceability, Planning traceability in Test Design phase and Test Execution Metrics, Defects report in Test Execution Phase from HP ALM and share with the core project team.
• Created a weekly QA status report and send it to all QA team.
• Provided Sign Off at each phase of testing as per the entry/exit criteria outlined in Test Plan.
• Documented Lessons Learnt and Best Practices from every project release and shared with the project team for Process Improvement and implemented them in the future effort.

Confidential West Des Moines, IA

QA Lead

Roles and Responsibilities:

• Drove Complex Product Launch Projects with Speed to Market strategy by reducing test time and cost without compromising end-user requirements, design specifications and development standards.
• Attend Requirements gathering meeting and review, analyze the business requirements.
• Developed Test Effort Estimation for each product Release based on the scope and timeline.
• Developed Test Plan and conducted walkthrough with Athene Stakeholders.
• Derived Test strategy based on the requirement, change type from project start through implementation.
• Performed Automation Feasibility Analysis and defined scope for automation.
• Coordinated with Automation Engineers in developing automation test scripts using Selenium WebDriver with Cucumber BDD Framework.
• Created reusable assets and growing automation regression test bed.
• Tested SOAP services using SOAP UI.
• Conducted Test scenarios review meeting with QA Manager, Tech lead, Developers, Business and Project Manager and seek approval for the same.
• Design and document the Test Cases and Test Scripts in HP ALM for each Product release.
• Developed and executed Automation Test Scripts using HP UFT 11.52
• Collaborate with Technical Lead for unit and integration testing; review unit and integration test plans/results.
• Reviewed system and integration tests prepared by test engineers.
• Conducted GUI, Integration, Smoke testing, System, Regression and Prod Support Testing and logged defects in the defect tracking tool: HP ALM.
• Conducted Defect triage meeting and be the focal point for defect management.
• Planned UAT Testing, Review UAT Scenarios, create test data and Co-ordinated with UAT team for test execution and Signoff within the UAT signoff date for different layers of the applications such as source system, middleware and downstream.
• Provided Sign Off at each phase of testing as per the entry/exit criteria outlined in Test Plan.
• Led a Team at Onsite and Offshore Co-ordinations
• Served as a SPOC for QA Deliverables between the Project Team and offshore.

Confidential, Iowa City, IA

QA Automation Engineer

Roles and Responsibilities:

• Worked with Business Users, Product Owner and analyze the objective of business scenarios and application functionality for automation script development.
• Developed and execute Automation Test Scripts using HP UFT 11.52
• Developed Functional Libraries and Create Shared Object Repository in automation testing using HP UFT 11.53.
• Exposure in developing Automation Test Scripts using Selenium Web driver.
• Executed UNIX Command in Linux OS to load Student Responses to MySQL Server DB
• Developed SQL Queries using MySQL Toad for Database Validation and maintained in HP ALM 11 Test Resources.
• Provided Sign Off at each phase of testing as per the entry/exit criteria outlined in Test Plan.

Confidential, San Antonio, TX

QA Mobile Test Lead

Roles and Responsibilities:

• Built, managed the new QA team to deliver high quality mobile software applications using simulators like Perfecto Mobile and developed automation framework using QTP.
• Test Planning & Estimations.
• Attend Daily Stand up meeting and provide QA Test Design, Execution Progress for the planned release.
• Developed and executed the Test Plan, Test Scripts and Test Cases based on Agile methodology.
• Developed and Executed Automation Test Script using Perfecto Mobile.
• Executed. IPA iOS build and .APK android builds Mobile Apps functionality testing in the local build, enterprise release build on iPhone, iPad and Android devices.
• Conducted Web-App testing for Mobile and Mobile Bowser testing.
• Executed compatibility testing on different IOS and Android OS versions whenever a new functionality is implemented.
• Collaborate with Technical Lead for unit and integration testing; Reviewed unit and integration test plans/results.
• Provided Sign Off at each phase of testing as per the entry/exit criteria outlined in Test Plan.
• Led a Team at Onsite and Offshore Co-ordinations

Confidential - San Antonio, TX

QA Test Lead

Roles and Responsibilities:

• Proposed and Implemented Risk Based Testing Technique
• Attained 1 to 2 Week Early Time to Market by Implementing Risk Based Testing Technique.
• Developed Test Plan, Test Strategy and conducted walkthrough with the project team.
• Developed Test Estimation based on the scope and timeline defined for the release.
• Conducted Test scenarios review meeting with QA Manager, Tech lead, Developers, Business and Project Manager and seek approvals for the same.
• Developed detailed Manual test cases in HP QC.
• Developed and executed Automation Test Scripts using HP QTP
• Developed Functional Libraries, Shared Object Repository for Automation Testing.
• Conducted Integration, Smoke, System, Regression, Prod Support Testing and logged defects in the defect tracking tool: Borland StarTeam.
• Conducted Defect triage meeting and be the focal point for defect management
• Coordinated with the developers to fix the defects logged in the defect tracking tool.
• Created a QA weekly status report and sent it to all QA team.
• Complete the end of release checklist.
• Complete the end of project checklist.
• Prepare the exit criteria and complete the testing workbook.
• Provided Sign Off at each phase of testing as per the entry/exit criteria outlined in Test Plan.
• Led a Team at Onsite and Offshore Co-ordinations