SUMMARY

• Over 7 years of experience in Manual & Automation testing on web based, Client/Server, Database, API testing, ETL, RPA and data warehousing applications.
• Having good experience in Power BI tool.
• Certified SAFe Agile - Practitioner & SAFE DevOps.
• Experienced as a Lead in working with onshore/offshore model.
• Well versed with all the phases of the Software Testing Life Cycle, Software Development Lifecycle (SDLC) and Test Methodologies
• Sound Knowledge and Experience with Waterfall, V-Model and Agile/Scrum & Software Engineering Methodologies.
• Expertise and experience in performing various phases of testing such as smoke, Black box, GUI, functional, regression, Database, Usability, Compatibility, integration, system testing, User Acceptance Testing (UAT) of Web and client/server applications.
• Experience in working with Selenium automation tool.
• Experience in working with API testing using SOAP UI and PostMan.
• Hands on experience onETLtools inETLprocess development,testingand in maintainingETL codes.
• Experience using query tools for Oracle, DB2, Teradata and MS SQL Server to validate reports and troubleshoot data quality issues.
• Experience testing on .Net and Java applications.
• Managed/lead/performed test planning, test execution, test data, test coordination, configuration management and defect management areas for the web based, middleware and mainframe applications
• Solid Back EndTestingexperience by writing and executing SQL Queries.
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Creation of Standard Guidelines for User InterfaceTesting
• Database/ETL/ReportstestingValidated the data derived in the target table if it is adhering to the standards and business rules
• Designed test case based on the ETL mapping document.
• Experienced in running and validating the logs in Informatica tool.
• Sound Knowledge and experience in Metadata and Star schema/Snowflake schema. Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W.
• Expertise in Business Object (BO) Reports, Tableau reports Testing.
• Experience in creating Requirement Traceability matrix (RTM) using Quality Center (HP ALM) tool, g Bugzilla, Jira Bug Tracking and Defect Reporting.
• Experience in working with Software Development team in resolving Defects, presenting the Defect Status reports, resolving requirements, and observed design inconsistencies.
• Motivated team player/contributor with professional written, verbal, documentation and presentation skills.
• Proven ability to work independently or as a member of a team. Skilled in adapting to rapidly changing work environments.

TECHNICAL SKILLS

Testing Tools: ADO, RQM, RTC, Quality Center (ALM), Selenium WebDriver, Test Director, UI pathAgility, Bugzilla, Jira, SOAP UI, WinSCP, Confluence, TFS, SharePoint, ClearQuest, VersionOne

Languages: C, C++, VBScript, Java

Web Technologies: JSP, HTML, XML, J2EE .Net, Postman

Databases: Oracle, SQL Server, Sybase, DB2

Operating Systems: WINDOWS, UNIX

Database Tool: Toad, Teradata, SQL developer, Business Objects, Informatica, OBIEE Reports

Version Control Systems: VSS, SharePoint

PROFESSIONAL EXPERIENCE

Confidential

Sr. Consultant QA/QA Lead

Responsibilities:

• Attending daily scrum meeting with the team for the updates on the current user stories.
• Prepared Test Strategy for each release.
• Working as a Lead in the Project, Point of contact to the Offshore team.
• Having experience in UAT for all functional, regression, sanity testing with real time data.
• Experience in end-to-end testing with client data through different applications.
• Communicating with BSA’s, MIS and Product Owner for requirements meetings & clarifications.
• Preparing Test scripts, Test Evidence documentation in Tosca and Selenium automation tool.
• Uploading test scripts in Agility and maintaining traceability.
• Testing the user stories once MIS team completed development.
• Validating database with respect to the tables on Teradata.
• Log the defects in Agility/ADO/JIRA for tacking
• Validating Reports in Quality Blue and running Jobs in Postman for the HICCS app.
• Having experience in Rest assured automation testing.
• Help in Developing and reviewed simultaneous SQL queries with the use of join clauses (inner, left, and right) in Power BI desktop to validated static and dynamic data for data validation.
• Communicated effectively across multiple platforms and departments by performing various QA tasks and evaluating workflow.

Confidential

QA Analyst 3/QA Lead

Responsibilities:

• Prepared Test Strategy for each release.
• Communicating with BSA’s, MIS and Product Owner for requirements meetings & clarifications.
• Having experience as a LEAD on ERA, AML, Fraud and Acimize Platform applications.
• Preparing Test scripts using Selenium automation.
• Uploading test scripts in ALM and maintaining traceability
• Communicating with Performance team for Performance testing for the releases
• Testing the user stories once MIS team completed development
• Validating database with respect to the tables & ETL validations b/w source and target tables.
• Validating data tables after running jobs in Informatica tool.
• Log the defects in ALM for tacking
• Communicating with Integration & OBIEE Projects with other systems
• Communicating with LOB team for any help for their validation during testing in QA
• Participating in Regression testing for each release
• Prepared & Discussed on Test Summary Report for User stories execution.
• Involved in Designing and implemented, monitored invoice processing utilizing UiPath savings a full time equivalent worth of work.

Confidential

Quality Analyst

Responsibilities:

• Involved in Daily Stand-up meetings with the team.
• Involved in preparing Test Plans based on Business Requirements Document (BRD) and prepared the Test cases and Test Procedures using RTC.
• Involved in Flow4 and Flow 2 data workflow as per Mapping requirement document in Oracle.
• Mapped requirements with Test Cases and executed them reporting a pass or fail status.
• Involved in UAT meetings and updating status of test cases in RQM, uploading test cases in RQM.
• Preparing Test Plans, Test execution documents, UAT document, Test results document.
• Extensively used SQL queries for data validation.
• Generated the detailed reports of the Defect and Assigned defects.
• Involved in Sprint grooming, Sprint review, Retrospective, UAT, Regression meetings.
• Writing data scripts with respect to the functional requirements for data validations and coordinating with dev team and BAs for clarification on functional requirements.

Confidential

Quality Analyst

Responsibilities:

• Involved in Multiple projects and multiple environments functional testing, KT from SME's.KT to Offshore team. Actively involved in discussion with Dev team, Database team, BA's.
• Involved in preparing Test Plans based on Business Requirements Document (BRD) and prepared the Test cases and Test Procedures using TFS, Communicating with Offshore/Onshore.
• Identified lab specific issues relating to application and interface/ Completed Integrated Testing
• Provided issues by level of severity to corporate lead team
• Mapped requirements with Test Cases and executed them reporting a pass or fail status.
• Involved in Scrum, Sprint planning, Retrospective, Regression meetings.
• Involved in functional and Regression testing. For each feature positive and negative test cases were written using TFS.
• Extensively used SQL queries for data validation.
• Generated the detailed reports of the Defect and Assigned defects
• Worked with users in understanding the business requirements and involved in creation and execution of the test scenarios and test approaches.