Name: Keerthi Soumya

Email: ad24ej@r.postjobfree.com

Mobile: 469-***-****

QA Analyst

Professional Summary

Dynamic and achievement-oriented Quality Analyst with 4+ years of experience in Software testing across various domains including healthcare, telecom, and e-commerce

Expertise in software testing of Web, mobile and desktop applications

Excellent knowledge and implementation skills in Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC)

Experience in System Integration testing, Functional testing, Regression testing, User Acceptance testing,, Stress testing, browser compatibility testing & Security testing of Web and Mobile Applications

Expertise in using various defect-reporting and defect-tracking tools like JIRA, Redmine, Rally, Bugzilla, and HP ALM

Excellent interpersonal skills, proven team player with an analytical bent to problem-solving and delivering in a high stress environment

Expertise in Web and mobile application testing on multiple platforms including Chrome, Firefox, Safari, Android, and iOS

Experience comprehending Business Requirement Specifications, Functional Specifications, and Design documentation and converting them into Test Scenarios and Plans

Good analytical and communication skills, and ability to work independently with minimal supervision and perform as part of a team

Experience working in Agile and Waterfall methodologies. Worked very closely with Product owners in Agile, attended different ceremonies like Sprint Planning meeting, Scrum, Backlog Grooming Sprint Review, and Retrospective.

Prepare Test Plans for each release, written Test Cases and executed them as part of Functional Testing, prepared test reports and deliverables and submitted for version releases

Performed Database/Backend testing by writing complex SQL Queries for data validation and integrity, good at writing complex Joins and knowledge in PL/SQL

Experience in extracting data from MS SQL Server and Oracle MySQL using SQL queries – group by, order by, unions, joins, and aggregate functions.

Experience writing Stored Procedures, Database packages, and Triggers.

Automated Webservices by writing groovy scripts and used assertions for data validation and performed data-driven for validating different endpoints.

Quality-oriented mind set up with Tests to Break Attitude and Tactful & Diplomatic Behavior

Technical Skills

Test Approaches

Agile/SCRUM, Waterfall, SDLC, STLC

Defect Management Tools

JIRA, Redmine, Bugzilla, HP Quality Center, HP ALM, Rally

Debugging Tools

Firebug, Fire Path, Xpath, Web developer Tools-Chrome

Programming Languages

SQL, PL-SQL

Databases

Oracle 12c/11g, SQL Server, DB2, MS Access, MySQL

Database Tools

TOAD, SQL Plus, SQL Developer

Version Control

SVN, Git, CVS, Team Foundation Server

Methodologies

Agile, Scrum, Waterfall, TDD, V-Model

OS

Windows, Linux

Professional Experience

Software QA Analyst

Alabama Department of Public Health – Montgomery, AL January 2022 to Present

Responsibilities:

Review functional and non-functional requirements and use cases from the business requirements document. Understand business logic, application requirements and technical aspects of the system.

Organize test plans during initial phase of the project, create test scenarios, test cases in line with the application.

Write Structure query language queries to check whether the data is prepopulated in the tables of the application and for the data verification whether right data is populated.

Written test cases for functional, nonfunctional, user interface testing and database testing primarily on regular bases

Expertise in both Web, Android and iOS mobile testing

Manipulated the database for the database testing using Microsoft SQL.

Have complete knowledge on different types of joins and used SQL commands for retrieving data.

Executed the store procedures to validate whether the data is saving as expected.

Used Get, Save, Update functions in stored procedures to retrieve the data.

Used Redmine ticketing system as the defect tracking tool and project management tool.

Written the Business requirement document and worked as a business analyst in a few scenarios to make sure the requirements are clearly explained to the developers.

Interacted with the developers and worked as a business analyst and quality assurance analyst to conduct various types of testing for the following software testing life cycle and bug life cycle.

Involved in all the client meetings regarding project enhancements and functionality changes for existing modules.

Have an extensive understanding of Quality center to maintain the test cases and created metrics and reporting.

Conducted Functional testing, Regression Testing using Selenium with a Data-driven framework and Key- Word driven framework.

Used Selenium Grid to run test scripts on different platforms and against different browsers in parallel to save time.

Used Jenkins to execute the test scripts periodically on Selenium Grid for different platforms like desktop, tablet, and mobile

Provided detailed demos to stakeholders on test artifacts at the end of every sprint

Upgraded the existing Test Scripts and created new scripts in PL/SQL to be able to work for new versions and patches, which improved product quality.

Involved in developing Behavior Driven Development(BDD) Framework from Scratch

Involved closely with developers in the Development of UI modules using HTML, JSP, JavaScript, and CSS.

Wrote object-oriented JavaScript for a transparent presentation of both client- and server-side validation.

Shared Daily Status Reports with all the team members, Team Leads, and Managers.

Environment: JIRA, SQL Server 2016, T-SQL, MySQL, Quality Center, Manual Testing, JavaScript, Microsoft Outlook, Visio, MS Office Suite.

Software QA Analyst

Relayr, Boston, MA June 2020 to December 2021

Responsibilities:

Analyzed the business requirements and developed the Detail Test Plan and the Test Strategy

Involved in daily interactive meetings with development team to discuss project hurdles and understanding the functionality challenges.

Involved in resolving the technical challenges & in efforts estimation and Test Planning

Used Static Testing, White Box testing, Integration testing, Functional testing (GUI testing, I/P domain testing, Error handling testing, O/P on manipulation testing, Database Testing, Data Volume testing, Recovery Testing, and end to end testing) in different stages of QA process using Selenium web driver.

Developed BDD and TDD script with Cucumber and written step definition for Gherkin-based features.

Involved in the Preparation of 'Hybrid Driven Reusable Framework' using Java.

Involved in Automation Feasibility Study for Web-based applications.

Designed and developed framework using Scripting by implementing Page Object Model

Developed SQL queries to query the database for correct data for the purposes of testing, and to test the backend process of the application

Used SQL query to validate the masked data fields from DB2 and SQL server

Perform defect investigation and root cause analysis, and monitoring debugging process results

Schedule calls & actively interact with clients for various project-related items or issues on a frequent basis

Assign work to team members during the entire testing life cycle & monitor progress made on daily basis

MS-SQL server, database, and user creation/maintenance/upgrades. Own and resolve client setup and issues as needed

Identified test data and organized it in flat files scenario-wise for test input at run time.

Organized the scripts by grouping them as Smoke, Regression, and Functional and executed them from the command prompt by creating scheduled tasks.

Ensure all Testing documents/artifacts are documented and maintained as per the process.

Created WBS to allocate and track tasks to the team.

Performed SIT Testing activities (as a part of manual testing) to evaluate and support Microservices by providing end-to-end application testing and by providing technical support.

Analyze test execution results and post defects with detailed steps and screenshots.

Used HPQC for tracking defects and notifying developers.

Coordinated user acceptance testing with final users & prepared end-user documentation for the new system.

System security, workflow, integration, user interface design, migration, data integrity, and partner portals on the SFDC Unlimited edition.

Prepared and presented weekly and monthly QA Defect and Status Reports to the different Stakeholders.

Maintained bug lists for critical issues using Quality Center& reported the same in status meetings.

QA Engineer

Neustar, INC - Hyderabad, Telangana January 2018 to October 2019

Responsibilities:

Analyzing the Business Requirement Document, High-level, and Low-level design documents.

Developed manual test cases for Regression Testing based on the requirement documents.

Create and review - Test scenarios, Test suite preparation, Test Data creation, Test case execution, and Defect logging. SADF

Analyzed technical specification and business specifications and created Test plans and Test cases in Quality Center Management tool.

Performed functional, system, integration, and regression testing.

Organize weekly meetings with Client leads & Onsite manager regarding the Automation status.

Point of contact for Process related activities like Metrics reporting & Operation clarity.

Review - Defect prevention plan and Software configuration management plan.

Responsible for all aspects of project delivery (Test Design, Test Execution, and Test summary report) and management (Test metrics and Risk analysis) to client partners, offshore manager, and Onsite manager.

Organize weekly meetings with offshore managers, Onsite Coordinator & Onsite manager to discuss the Project goals and report the health of the overall project status.

Updating the application down time in Environment Tracker during the test execution phase.

Performed Integration Testing in Vendor Development environment and System Testing in SIT environment and User Acceptance Testing in Pre-Production Environment.

Involved in Preparation of Traceability Matrix and mapping the Test Cases with the requirements and

Test Metrics in Quality Center.

Reported bugs in Quality Center with server logs information from Web and DB servers.

Performed Regression Testing as part of every build.

Developed SQL Queries for testing various Database validations

Education

Masters in Information Sciences - DePaul University, Chicago, Illinois.

Bachelor of Technology in Information Technology – Jawaharlal Nehru Technological University Hyderabad, India

Contact this candidate