Post Job Free

Resume

Sign in

Quality Engineer Sql Server

Location:
Canonsburg, PA
Posted:
April 04, 2024

Contact this candidate

Resume:

Raja Nandini Kakarla

Contact No: +1-330-***-****; ad4r5v@r.postjobfree.com

Personal Statement

Professional Software Quality Engineer with 6 years of experience in the Information Technology having hands-on experience in both Manual and Automation testing. Energetic and motivating team player with a results-oriented mindset along with proven ability to effectively manage both offshore QA team and projects of long/short-term.

Skills

Programming C, Java with Eclipse IDE, HTML, SQL Server, JavaScript, XML, JSON, Gherkin.

Software Tools MS Office, Tableau, JIRA, Confluence, HP ALM, Version One, Maven, Jenkins.

Testing Tools Selenium WebDriver, Selenium IDE, Appium, SOAP UI, Perfecto, Swagger UI, See Test, POSTMAN, Toad for Oracle, Oracle, SQL Server.

Web Debugging Tools XPath, Fire Path.

Test Framework TestNG, Gradle, Karate

Processes Agile-Scrum, Waterfall

Work Experience

American Eagle Outfitters Inc (Full Time) Pittsburgh, PA. April 2022 – Till Date

Role: QA Engineer II

Responsibilities:

Comprehensive understanding of SDLC process and methodologies

Test complex web-based software and mobile applications in a cross products, platform, and browser environment.

Involve in usability, end-to-end, user acceptance and regression testing

Create test plans and test cases based upon project needs

Work on Data setup for End2End testing by understanding the Data model architecture

Design and document test scripts based on business requirements, functional and technical requirements, user stories and business use cases

Troubleshoot issues and analyze debug logs

Document, track, and validate defects in bug tracking system with clear summary, screenshots, expected behavior, actual behavior, and additional details

Ability to execute and fix scripts in Automation suite on the in-house BDD framework model.

Check-in/Rebase/Create/Review code for any script changes into GIT repository

Collaborate with cross functional teams onsite and offshore

Daily scheduled and/or on-demand deployment support

Provide QE support for Production launch.

Environment: JIRA, Confluence, POSTMAN, Selenium, Java, IntelliJ, Grafana, TestNG, Maven, XPath, Eclipse IDE.

ConnectiveRx (Consultant) Pittsburgh, PA December 2021 – April 2022

Role: QA Engineer

Responsibilities:

Test UI’s, API, and Backends.

Test applications including developing test plans and test cases and preparing test scenarios and documents.

Preparing defect reports to report defects for unexpected behavior.

Perform UI testing, API testing, Stored Procedure validation, SSIS package validation, Correspondence trigger and content validation, Database Testing, Data Feed testing, Webservice testing, ETL testing, and Mobile testing.

Perform the test in AWS Cloud base against Dynamo DB, Lambda functions etc.

Script generic DB2 SQL queries for regression validation.

Perform integration and system testing using Risk-Based testing approach.

Utilize SQL developer, JSON validator, JIRA, POSTMAN for validating the application enhancements.

Design and execution of functional test strategies for high-quality product releases.

Analyze new feature impacts and risks for release, review the test strategy and plans to certify product quality.

Develop/create test plans/ business use cases for testing.

Execute test use cases and report bugs using collaboration tools

Triage and drive bug resolution with appropriate teams

Familiar with software development cycle and quality assurance methodologies

Work closely with the development group to document and execute regression, functional, and integration tests

Work with other QA team members and developers to identify, document, resolve and add test coverage to existing defects.

Actively participate in the ongoing effort to fully automate client regression and functionality testing.

Environment: JIRA, Confluence, PractiTest, POSTMAN, SQL Server, AWS Cloud, Windows 7/10.

PNC Financial Sector Services (Consultant) Pittsburgh, PA February 2017 – December 2021

Role: Test Lead

Responsibilities:

Performing Functional, Regression, Smoke, Negative, Integration, End to End, Cross Browser testing and User Acceptance testing.

Participates in the Quality Assurance process; follows procedures to ensure that all software products and components meet company standards and client requirements.

Worked on various web-based applications in both desktop and mobile devices.

Preparing Test Strategy document and Test Results Summary Report document for every Release and reviews the documentation for completeness and adherence to standards.

Provides Test cases review, Test case execution planning time and maintaining the defect report for internal evaluation of the product.

Generating the Selenium Automation scripts and performs Functional and Regression during various phases of the application development using Selenium and maintained code versions through GIT/Bitbucket.

Continuous monitoring of jobs and analysis of failures on Jenkins environment.

Testing REST API’s manually using Swagger UI and POSTMAN.

Have experience in testing the webservices using SOAP UI and good knowledge on using BDD frameworks like Cucumber.

Preparing the test data and generating defect reports during Regression testing until the project is moved to PROD.

Works on problem resolutions and reports progress to management. Plans, executes, and summarizes reliability and validating test cases, interfaces with developers on test results.

Involved in interacting with end users and investigated issues related to QA.

Leading the offshore 3 QA team members and sharing domain knowledge.

Projects: Worked on various projects under Corporate & Institutional Banking domain.

PINACLE projects: Worked on various web applications like Corporate Card, Image on Demand, Account Transfer, Credit Management and Disbursements module. I did both Manual and Automation testing for these applications using Selenium, Java, and Eclipse. I worked on testing critical defects for these applications.

Rate Rollovers project: I delivered Rate Rollovers project very successfully through various testing cycles. I did E2E validation for this project by thinking out of the box. I prepared Test Strategy and Test Results summary document for this project. This project is mainly on rolling over the loans approaching the rate maturity date for those loans without loan administrator’s assistance.

Statements project: Worked on Statements project which is having cross team dependencies. Communicated with all teams regarding the Statements validation. As part of this validation, I used SOAP UI tool to verify all the information fields in the Statements. I did database validations and ETL testing.

Commercial Experience project: I worked on this project by working on various module entitlements validation. I used different tools for validating this project like Swagger UI, POSTMAN, JSON Formatter, HP ALM on multiple scenarios. I used Selenium tool with Gradle framework for automating the scenarios on Java web application. I am also responsible for running Regression, Smoke test suites using Selenium tool. I validated this application in mobile versions using Perfecto tool.

Migrating CLASSIC application to Commercial Experience:

This project is about migrating the CLASSIC PINACLE application to Commercial Experience where I am responsible for application feature validation in both UI’s.

I am performing backend validation, REST API’s testing using POSTMAN, SOAP UI, Swagger UI, JSON Formatter tools to make sure the functionalities are working as expected. I used Selenium tool with QFaaS framework for automating the scenarios and responsible for maintaining the Regression and Smoke test suites.

Responsible for automating the API services using Karate framework for Integration and Regression testing and SPOC for representing the entire team for the application at domain level.

I validate this application in both web/mobile browsers using See Test tool.

Prepared a Requirements Traceability Matrix (RTM) for different types of transactions using various accounts as per the current state of workflow and future enhancements.

Representing the QA team in bug tracking and Defect review meetings.

Experience in developing complex SQL queries to perform backend testing in Oracle using Toad for Oracle tool. I developed queries to validate the status of the transactions across the application workflow.

Escrow Services Agiletics upgrade: Worked on validating Escrow Services application as part of code upgrade. I worked with the Mainframe crew by assisting their QA with the validation of testing cycle processes.

Environment: Java SE 8, Selenium WebDriver 3.0, Version One, JIRA, Confluence, TestNG, Gradle, Karate, XPath, Eclipse, GIT/Bitbucket, Teradata, Toad for Oracle, CSS, Oracle SQL Developer, SOAP UI 5.4.0, POSTMAN, Swagger UI, HP ALM 12.21, Windows 7/10.

Media3 International Pvt Ltd. Visakhapatnam, India June 2014 – July 2015

Role: Automation Tester

Responsibilities:

Analyzed business requirements and functional documents, to define the test environment, phases of testing, entrance and exit criteria into different phases of testing and resources required to conduct the effort.

Developed Automation test scripts to identify web Elements through locators using Fire Bug and Fire Path Firefox plugins.

Extensively worked in Regression testing using Selenium WebDriver in TestNG and performed the build and Maven dependencies using Maven build tool.

Developed methods to read test data from excel files using Apache POI.

Maintained User documentation with Selenium Output screenshots for UAT

Maintained continuous test integration and automatic build by using Jenkins and mailed the build outputs to the team.

Environment: Java SE 7, Selenium WebDriver 2.0, JIRA 6.0.8, Apache POI 3.9, TestNG, Maven, XPath, Eclipse IDE, HP ALM 11, Windows 7.

Stellent Soft, Visakhapatnam, India April 2013 – August 2013

Role: Intern

To my academic interest, I got an internship opportunity as a Business Systems Analyst, where my responsibilities included managing Sprint Backlogs, adding Testing tasks and conducting Regression testing on the product that we were working to build on.

Education

New England College (Henniker, New Hampshire) Dec 2021

Executive MBA (GPA 3.82)

Kent State University

Kent, Ohio

Master’s in Computer Science (GPA 3.44)

Dec 2016

Machine Learning, Advanced Operating Systems, Advanced Artificial Intelligence, Software Engineering Methodologies, Advanced Digital Design, Information Visualization, Software Testing Methodologies, Advanced Computer Graphics.

Jawaharlal Nehru Technological University

Visakhapatnam, India

Bachelor’s in Computer Science and Engineering (GPA 3.22)

May 2014

Certifications

Software Tester, Issued in March 2021

Accredited Software Test Automator, Issued in March 2021



Contact this candidate