Senior Software Quality Assurance

Rajani Mogili

Senior Software Development Engineer in Test

Email: ********@*****.*** Ph: 703-***-****

•Experienced Senior Quality Assurance and Automation Engineer with over 14 years of expertise in test engineering, possessing extensive Agile and SAFe Agile development experience, along with proficiency across a diverse range of testing tools and technologies.

•Expert in a broad range of testing methodologies including Integration, Load, Web, Functional, Regression, White Box, Black Box, Stress, and 508 Compliance Testing.

•Experience testing in cloud-based environments.

•Extensive experience in Client/Server Testing, User Acceptance Testing (UAT), GUI Testing, and Agile Testing environments.

•Skilled in developing test strategies, test plans, test designs, use cases, test cases, test procedures, test logs, automated test scripts, and defect reporting.

•Hands-on experience with Mercury Interactive Suite tools including WinRunner, Quick Test Professional (QTP)/Unified Functional Testing (UFT), Test Director, and LoadRunner.

•Proficient in defect tracking and project management using ALM and Jira.

•Experienced in web service testing using SOAP UI PRO and ReadyAPI 1.3.1, including automated scripting with data loops for regression testing.

•Expertise in backend testing for data validation and data integrity using SQL and Oracle.

•Proficient in writing SQL Queries, working with MS Office Products (MS Project, Word and Excel). Have excellent communications and interpersonal skills.

•Developed robust automated regression test scripts using the Robot Framework with Python and Selenium WebDriver with Java/TestNG, as well as the AccelQ AI-based automation platform, ensuring high test coverage, maintainability, and efficiency across Agile releases.

•Ability to understand business operations and its functional aspects and gather user requirements.

•Developed automated testing frameworks from scratch using the AI-driven AccelQ tool, including the creation and maintenance of comprehensive Smoke and Regression test suites to ensure early defect detection and high-quality releases.

•Possess excellent written and verbal communication skills that help in easy communication with stakeholders, end users, project managers, developers and testing team members.

•Performed Smoke, Functionality, Integration, System, Regression tests based on Analysis, and understanding of the requirements, non-functional specifications, and end-user needs.

•Experienced in performing security and vulnerability testing across web and backend applications.

•Conducted end-to-end security testing on a demo web application using OWASP Top 10 guidelines. Identified and documented vulnerabilities including XSS, SQL Injection, and broken authentication.

•I currently hold Active DHS/DOD Secret security clearance.

TECHNICAL SKILLS:

Testing Tools : Quick Test Pro, Quality Center (ALM11), Postman, Ready API 1.3.1, Selenium

Selenium Webdriver with Test NG, JIRA, Robot Framework with python,

Jenkins, Git, AccelQ AI tool, Service Now.

Testing Methods

: Integration, Smoke, Web, Regression, White box, Black box, Stress testing

Client/Server Testing, User Acceptance Testing, GUI Testing and Agile Testing.

Databases

: MS SQL server, MS Access, Oracle, TOAD

Languages

: C, C++, Java, Python.

Platforms

: Windows 7, 10, XP, Mac and UNIX

Software Packages

: MS Office, Visio, MS project, Adobe Photoshop, Adobe Acrobat, Crystal Reports, SAS

GUI Tools

: Visual Basic, Photo Shop 7.0

Scripting Languages : Shell, Java Script, and VB Script, Selenium

Web Technologies : HTML, XML and UNIX Shell Scripts

EDUCATION: Master’s in Computer Science Engineering

PROFESSIONAL EXPERIENCE:

Department of State - Consular Affairs Duration: March 2022 to till date Role: Senior Automation Test Engineer

Description: Working on Consular Consolidated Database (CCD) environment. CCD contains information gathered by Department of State Consular officers and other government officials around the world including passport information on American citizens and immigrant and non –immigrant visa applicants.

Responsibilities:

•Actively participating in team Sprint planning and refinement meetings.

•Estimating QA stories and QA task in each sprint.

•Analyzing and understanding the user stories and reaching out to the team for any questions and clarification on stories.

•Working on Writing detail test cases in ELM and reviewing the scenario’s covered with BA and dev lead.

•Executing the test cases and updating the status of test cases in timely manner.

•Worked on implementing Robot framework with python.

•Using Nexus to download the latest build.

•Working on running rollback and installation scripts manually by following the steps provided by dev team, to compare before and after deployment test results.

•Working on implementing acceptance test-driven development (ATDD) to meet the Test coverage stories.

•Working on implement fully automated CI/CD pipeline, from code checking to production deployment

•Performing Smoke, Functional testing and regression testing.

•Documenting bugs found during the test process using ELM and reported to development team.

•Performed backend testing by writing complex SQL query involving multiple tables using JOIN statements and validated query results against UI.

•Scheduling weekly meeting with agile teams to go through all the sprint stories and identify right candidates to automate.

•Working with agile teams to prioritizing automation stories based on deliverables to IVV team (UAT)

•Working on implementing automation framework from scratch using AccelQ AI tool.

•Working on implementing Smoke test suite and regression test suite using AccelQ.

•Working on creating test scenarios and test cases in AccelQ using inbuilt commands, Conditional statements, data list, and global properties.

•Everyday pulling the latest updates from the master branches and merging child branches to master branch after completing automating story.

•Using Jira for creating automation stories and for defect logging and tracking purpose.

•Working on API Manual testing and automating API’s using AccelQ tool.

•Supporting IVV team (UAT) to run automation test scenario’s which are handed over from internal QA team (our team).

•Working on testing API end point’s using Soap UI. Validated both request and response of API.

Environment: Robot Framework 5.0, Oracle db, Python 3.6, AccelQ, Jenkins, and Gitlab, Nexus.

CBP, Springfield Duration: September 2019 to February 2022 Role: Senior Automation Test Engineer

Description: Working on Trusted worker program project: TWP web application allows CBP Officers to create,

View and update user’s applications to one of the Trusted Worker Programs (eBadge, Bonded Facility Worker, Broker License). TWP is being developed in CBP AWS Cloud Environment to replace Global Enrollment system (GES) for processing of TWP user Applications.

Responsibilities:

•Involved in planning meetings with Project team and analyzed requirements.

•Prepared detailed Test plan, Test Scenarios and Test cases based on the functional requirements and reviewed them with BA and Business owner.

•Interacted with product owner and developers to understand product requirements.

•Actively involved in daily standup meeting and other Safe agile ceremonies like grooming, Sprint planning, retrospective and PI planning meetings.

•Performed manual testing referring to the Test cases developed and acceptance criteria of the User story and reviewed the test coverage with Business Analyst and Product Owner.

•Performed data migration testing by understanding legacy application and data mapping from source to target system. Verified and validated data migration from legacy schema (source system) to the target schema (current system).

•Identified requirement gaps and defects during testing and reported to the developers.

•Developed Page Object Model Automation framework with Selenium Web driver (JAVA) and Test NG annotations using Eclipse IDE.

•Automated new features every sprint to reduce manual testing effort and time. Expanded Test NG framework by creating reusable methods and helper classes.

•Worked on checking compatibility of the application for dynamic and static content under various cross browsers using HTML IDs, CSS selector and Xpath in Selenium.

•Worked on Understanding data modeling and performed backend testing by writing complex SQL query involving multiple tables using JOIN statements and validated query results against UI.

•Performed API testing by validating request and response of the service using Swagger UI.

•Implemented branching strategy suitable for agile development in GIT.

•Executed all the test case and report defects, define severity and priority for each defect.

•Worked on integrating test scripts to Jenkins to execute them automatically after every deployment to SIT (Test) environment.

•Worked on effectively using JIRA for logging defects, defect tracking, User Story Creation and for Agile dashboard management.

Environment: JIRA, Java, Selenium, Confluence, SQL Database, Firebug, Eclipse, XPATH, Java, HTML, CSS, Jenkins and Maven, Gitlab.

Freddie Mac, VA Duration: July 2018 to September 2019

Role: UAT Engineer

Description: Working on LPA project: Loan Products Adviser (LPA) uses the information submitted to determine superior risk assessment capabilities that help predict a borrower’s ability to repay their Loan. LPA generates feedback certificate with messages that will provide detailed information about the assessment of the loan application data.

Responsibilities:

•Analyzed and documented high level and detailed business requirement.

•Participated in facilitation of business process review and developer walkthroughs based on business requirements.

•Worked in Agile methodology and Using Version one for creating user stories and tasks.

•Actively involved in daily standup meeting and other agile ceremonies.

•Developed test scenarios & cases, created data files, executed test cases for User Acceptance Testing (UAT)

•Involved in Iteration planning meeting with Project Team to Analyze and understand the requirements.

•Developed Test Scenarios and Test cases based on the Functional requirements using the Quality Center. Worked with the business team to review the test cases and testing coverage of the Requirements and Modified and added Test Scenarios according to business feedback.

•Performed manual testing using Quality Center to develop test cases and executing the test cases and Defect Tab to logging the defects.

•Defects logged in Quality Center and Attended Defect Review meetings every week with the developers and Business team to discuss defects found during testing,

•Performed regression testing of the entire application once the bugs are fixed.

•Interacted with the Development team to resolve and follow up on development issues.

•Manually checking the important features of the application before going for automation testing.

•Implemented automation using Selenium Web Driver, Cucumber.

•Performed BDD (Behavior Driven Development) using Cucumber Features, Scenarios and Step Definitions in Gherkins format.

•Performed Data driven testing using Selenium Web Driver, JUnit functions and JDBC Connections which reads data from scripts using property and Data Tables.

•Handled various Alerts using different methods such as dismiss, accept, getText in effective way depending on the requirement.

•Developed Selenium scripts to get the data from the webpage by using the methods like getUrl, getTitle, getAttribute.

•Used Git as a source repository system to share code within the office as well as with the team in overseas.

•Worked on Capturing Screenshots on failure to analyze the test failure reason.

•Coordinated with application team to ensure resolution of all issues and completion of work on time.

Environment: ALM, Java, Selenium, Cucumber, Version one, SQL Database, Firebug, Eclipse, XPATH, Java, HTML, CSS, Jenkins and Maven.

Asurion, VA Duration: April 2014 to September 2018

Role: QA Engineer

Description: Worked on Horizon Project to automate the application developed in agile methodology. The Horizon Program is a key enabler of Asurion’s business growth objectives and addresses business needs not supported by our current state platform-iCare. Horizon Project involves in developing web-based application and Agent application (Agent Application used by Asurion Agent to handle customer calls) to facilitate the customers to submit claims, Repair and Refunds, when their phone is lost, stolen or damaged using our web application or by calling Agent.

Responsibilities:

•Involving in meetings with Technical Analysts and with Dev team to understand the requirements.

•Involving in elaboration meetings, where we discuss the about data model changes, Tibco services changes and user stories coming for that iteration and discuss about enhancements to the existing stories.

•Estimated the QA tasks during the iteration planning meeting and managed the allocation & task creation for each scrum team to meet the iteration timelines.

•Leading the team for manual test execution, creation of reports and send to the management.

•Involving in defect review meetings with the development as well as business teams.

•Used Quality Center to report bugs and created test cases in ALM, Now moved to using JIRA for defect tracking, for user stories creation and for Agile dashboard management. Updating User story status in timely manner in JIRA.

•Working on transition from Quality Center to Test link (Open Tool) to manage and maintain manual test cases across all teams in Horizon.

•Developing test scripts to automate process of testing in Selenium WebDriver and writing test code in Java language using J unit framework.

•Implementing Page Object Model Automation framework with Java, Selenium WebDriver and Cucumber.

•Used XPath and DOM to work with dynamic and static objects in Selenium.

•Involved in integrating the test suites to Jenkins to execute them automatically after every successful deployment.

•Responsible for integrating with Robot Framework, test script development, script enhancement, test execution, preparing test data, defect tracking.

•Writing SQL queries and using SQL reports in order to view successful transactions of data and for validating data.

•Worked in DAL (Data access Layer) team, where this team is dedicated in creating Tibco services for external teams to consume for search and locate. Performed manual and automation testing on these complex services.

•Extensively used Ready API tool for testing and automating the web services and validated the output response.

•Constantly enhancing the framework to be more robust and expanding our test coverage.

•Altered our automation folder structure to mirror Dev code repository for ease of running test suites after deployments.

•Customized groovy scripts with Xpaths to validate Find operations, graphs, projections in services automation. Extensively using Postman chrome extension to test Node JS API’s.

•Created Logger to generate log files based on step results to help debug failed tests for services automation.

•Code review template is attached to automation stories in JIRA to ensure standard process is followed.

•Scheduled KT sessions to Dev team about our QA Automation. Recorded step by step process of our automations steps and store in our QA SVN for referral.

•Using Kibana on daily basis to analyze the root cause for production issues and added detail comments of my observation in Jira production ticket and assigned to respective development team for the fix.

•Working with Production support Team – Doing thorough root Analysis for production tickets and giving my updates about the analysis to Business in Feedback meetings calls and creating DataZaps in prod environment.

•Performed Smoke, Functionality, Integration, System, Regression tests based on Analysis, and understanding of the requirements, non-functional specifications, and end-user needs

•Using Confluence on everyday basis to upload Documentation of Test process, Data models for reference.

Environment: Pega, Tibco, SQL Database, Agile Manager, Selenium WebDriver, Jenkins, Cucumber, HP ALM, JIRA. Ready API 1.3.1, TestLink, Postman, Node JS, Firebug, Eclipse, XPATH, Java, HTML, CSS.

Prime Therapeutics, MN Duration: December 2012 to March 2014 Role: Senior QA Analyst

Description: Worked with the data driven framework set up in QTP/QC for the Benefit Plan Wizard project developed in agile methodology with SCRUM. The project involves in the development of a web based front end for the client/server Rx claim application that is used to get the right medication to the clients based on their prescription as well as Health insurance coverage.

Responsibilities:

•Analyzed and documented high level and detailed business requirement and translate in use case diagram.

•Participated in facilitation of business process review and developer walkthroughs based on business requirements.

•Involved in Iteration planning meeting with Project Team to Analyze and understand the requirements.

•Develop Test Scenarios and Test cases based on the Functional requirements using the Quality Center. Worked with the business team to review the test cases and testing coverage of the Requirements and Modified and added Test Scenarios according to business feedback.

•Perform manual testing using QC to develop test cases and executing the test cases and Defect Tab to logging the defects.

•Creation of data driven automation framework in QTP and used xpath for the object identification.

•Convert manual tests to automated test scripts in Quick Test Professional, enhance the scripts by adding user-defined functions make the scripts reusable and Create test scripts with Descriptive Programming using regular expressions for handling windows with different names.

Generated Data Driven scripts that access the backend database.

•Attend Code Review meeting with QA Team. Gave Demos on Test Coverage of requirements to Project Team for every Iteration by running automated scripts.

•Automate test scenarios for GUI functionality, performed Integration, Database, Boundary, Security and Regression Testing using QTP.

•Defects logged in QC and Attended Defect Review meetings every week with the developers and Business team to discuss defects found during testing,

•Perform regression testing of the entire application once the bugs are fixed.

•Interact with the Development team to resolve and follow up on development issues.

•Manually checking the important features of the application before going for automation testing.

•Used QC to invoke the scripts and initially performed the baseline testing and organized all the scripts systematically and generated reports. Perform web service testing using SOAP UI Pro.

•Set up the nightly regression execution process to run the scripts on daily build & report bugs.

•Involve in the QA retrospectives to discuss the issues encountered, accomplishments as well as set new goals to overcome issues.

•Improve regression execution performance by including error handling & condition statements.

•Independently develop Load Runner test scripts according to test requirements

•Using Load Runner, execute multi-user performance tests, used online monitors, real-time output messages and monitor the application response time for load applied.

•Develop and implement load and stress tests with Load Runner, and present performance statistics to Project teams, and provides recommendations on how and where performance can be improved

•Interface with developers, project managers in the development, execution and reporting of test automation results.

•Responsible for writing Startup scripts and Compiled Module Functions for front and backend validation.

•Writes and executes SQL queries in validating test results. Compare and analyze actual to expected results and report all deviations. Used Virtual User Generator to generate VuGen Scripts.

•Developed and deployed test automation scripts to do end to end performance testing using Load Runner. Create regression report to provide status of the build to the team.

•Write SQL queries to get the data from the database & verify it against the database tables of the client/server application.

•Performed Section 508 Compliance Testing with Accessibility Life Cycle and Accessibility Best Practices Library.

•Participate in QA daily standup meeting and Project daily standup meetings to provide Task status and updates to the Team.

Environment: Quick Test Professional 11, Quality Center 10, ALM-QC, SOAP UI Pro 4.5.1, Load Runner, Java based front end, GWT frame work. MS SQL, Windows XP.

KPMG LLP, NJ Duration: February 2012 to November 2012

Role: Software QA Analyst

Description: Worked on KPMG’s US firm’s Client and Engagement set-up process project (CLEAS). This project is to integrate the KPMG’s Risk Management process and tools into a single application. Each Client/ Engagement set up takes form of a “CLEAS Request” with a unique ID. My responsibilities include manual testing and automating the application by writing and testing end to end scenarios right from initiation of CLEAS request to Client Engagement setup.

Responsibilities:

•Analyzed and reviewed the requirement Documents to develop the Test Scenarios, Test Plan and detail test cases.

•Worked on Agile Methodology, participated in agile planning meetings & provided testing estimates.

•Written Test Cases in Quality center, Interacted with Developers and BA to understand application functionality.

•Performed Smoke, Functionality, Integration, System, and Regression tests based on Analysis, and understanding of system requirements, non-functional specifications, and end-user needs.

•Automated the test cases by using Quick Test Professional (QTP).

•Involved in Design and Creation of Hybrid Automation Framework.

•Involved in Creation of the Automation Test Plan and Automated Test Scripts for Functional for regression testing. Created Reusable Functions, Created and maintained the Shared Object Repository using VBScript, Developed Descriptive programming and Implemented Regular Expression as required for dynamic objects in QTP since it is a web-based application.

•Executed tests in Debug mode to make sure they run smoothly by inserting breakpoints, monitor variables and control the tests to identify and isolate defects.

•Handled exceptions in the test scripts using QTP Recovery Scenario Manager.

•Used Jira for Defect Reporting and Defect Tracking used RQM system and Regularly Checking the Status of the issue and Work closely with Developers to resolve.

•Generated the test data by using lots of SQL Queries.

•Querying the database using SQL to check out successful transactions, reporting and prioritizing software bugs according to the severity.

•Performed Database Testing using SQL, executed various DDL and DML statements. Wrote SQL queries to insert and retrieve test data from database in a test script while running test cases.

•Installed, configured SOAP UI to test web services using WSDL file given by Development team.

•Regularly Attending the Daily, Weekly Status meetings and Conference Calls and update the Status Report to Project Manager on Daily Basis.

•Logged errors in JIRA and coordinate efforts with the development team to solve issues

•Performed browser compatibility testing on IE9, Firefox, Chrome, Safari with different combinations on Windows XP, Windows 7.0 and MAC Operating Systems

•Conducted the Regression tests for already reported Bugs to test whether fix has been applied or not and also to test whether the fix causes another problem or not, Retested the application to ensure testing issues are resolved

Environment: Quick Test Professional 11, Quality Center 10, Clear Quest, .NET, MS SQL 2005 server, VB Script, Java based front end, GWT framework. MS SQL, Windows XP.

Contact this candidate