Post Job Free

Resume

Sign in

System Testing Sql Server

Location:
Elkridge, MD
Posted:
September 15, 2023

Contact this candidate

Resume:

Akhila Reddy

QA Engineer

adzp7f@r.postjobfree.com 443-***-****

Summary:

Over 6+ years of experience in Information Technology, with specializing in Software Quality Assurance Testing, proficient in testing Client/Server and Web based application.

Excellent understanding of the Agile Software Development Life Cycle (SDLC), STLC and the role of Quality Assurance, RUP and Agile/ Waterfall Methodologies, Agile PLM

Exposure to Manual Testing of applications developed on Windows and UNIX platform.

Expertise in Point of Sales (POS) applications, store systems, Inventory and supply management tools and systems.

Experienced in testing Client/Server and Web - Based Applications.

Proficiency in interacting with Oracle, SQL Server and DB2 databases using SQL.

Extensive knowledge of SDLC methodologies.

Experienced in developing Test Plans, Test Cases based upon the business requirements.

Extensive experience in working with E-Commerce web applications for B2C and B2B in various domains such as Retail and IT.

Experience in performing validation regarding Check-In/Check-out and cart functionality for e-commerce web-based applications.

Experienced in testing Client/Server and Web-Based Applications.

Experience with Mobile application testing

Expertise in Oracle table data manipulation using SQL queries and UNIX commands.

Good Documentation and Process Management skills with an ability to effectively understand the business requirements to develop a quality product.

Good team player with the ability to lead, manage and work independently in a time sensitive environment.

Expertise in Smoke Testing, Back-end Testing, Black-Box Testing, User Acceptance Testing (UAT), Functional Testing, Positive/ Negative Testing, System Testing, Regression Testing, GUI Software Testing, Ad-hoc Testing, Boundary Value Testing.

Expertise in documenting defects with high level of detail, accuracy, and informative recreation steps using Quality Center, JIRA.

Experience with comprehensive understanding of all phases of Test Life Cycle, including requirements gathering, test planning, scheduling, testing, defect tracking and reporting.

Expertise in back-end testing and writing SQL queries, Joins, Procedures using Oracle.

Technical Skills:

Test Tools

Quality Center, Test Director

Bug Tracking Tools

JIRA

RDBMS

MS SQL Server, Oracle, MS Access, DB2

Processes

Agile-Scrum, Waterfall.

OS

Windows XP/2000/NT/98/95, UNIX

Languages

SQL, PL/SQL

Query Tools

TOAD, MS SQL Server, My SQL

Experience

Meijer, Grand Rapids, Michigan Aug 2022-Present

Manual QA Engineer

Worked with SMEs for SUT and provided an overview and knowledge regarding various modules of application to test team members.

Work in Agile, scrum, and sprint environment in order to change the requirements and features set.

Used agile methodology to come up with test scenarios and test cases.

Performed configuration/ compatibility and user interface testing manually.

Have experience designing and writing training manual templates, design formatting, project planning and writing technical documents.

Involved in creating Test Scripts representing various Transactions, Documenting the Load Testing Process and Methodology. Created meaningful reports for analysis and integrated the Performance Testing in the SDLC.

Exported Manual test cases into Quality Center and maintained the same in the Test Plan module.

Tested the UI of the end product on mobile, PC, Android and Apple platforms to ensure that language translation and currency conversions were displaying as required.

Analyzed the Crash reports on various mobile platforms and reported to the development team.

Performed browser compatibility and configuration testing on various operating systems such as Blackberry OS, Android OS, iOS etc.

Responsible for testing of different modules of Oracle Supply chain application like Retail Merchandising System (RMS), Item Management, Purchase Order, Store Inventory, Stock Counts, Order and Inventory management etc.

Performed rigorous manual testing such Functional Testing, Smoke testing, Integration testing, UAT Testing, Backend Testing, Regression Testing, End to End Testing and System Testing.

Validate Data Grid and Data Tables for expected results during Unit Testing cycle using SQL queries.

Experience in creation of reports using Quality center, and Rally and responsible for the all opened defects till the closer.

Utilized Defect module of Quality center for Defect Management.

Arranged test case review sessions in order to ensure the 100% requirement coverage to perform various types of testing such as Functional, GUI, Interface, System and Integration, Back end, Security, Smoke/Sanity testing etc..

Managed & Tracked defects and followed upon defect to get it resolved before UAT phase of the project.

Created various test reports such as Test Execution Status, Defect Status, and Defect Injection Rate through Reports and Graphs feature of Quality center and publish them on as needed basis on the SharePoint site.

Extensive UAT Testing Manually.

Carried out GUI, Functionality, Integration and Regression testing using Quality center.

Conducted Bug Review meetings by reviewing and discussing all defects by their business severity and worked actively development and business team to perform the root cause analysis to find the resolution.

Environment: XML, Unix, Quality Center, Java, J2EE, Linux, Oracle SQL Developer, MS Office (MS Excel, MS Word, MS PowerPoint), MS Project.

NRSTPA, MA Feb 2022 – July 2022

QA Test Engineer

Create Test related documents such as Test Plan, Test Scenario, and Test Cases throughout the STLC.

Interacted with the business analysis and developers in requirements analysis, review design documents, testing and documents which are developed in to Agile, scrum, and sprint environment.

Performed rigorous manual testing such smoke testing, Integration testing, Regression Testing, End to End Testing and System Testing.

Actively participated Agile and scrum meetings, review and developed test scenarios.

Followed Agile Methodology to emphasize on real time communication over written documentation.

Performed Functionality testing during various phases of the application and analyzed the results.

Worked with java based applications and C++ simultaneously: iOS and Android

Performed functional testing of individual modules (Accounts, Trading, Quotes and More) of the Application on iOS, Android, Blackberry OS operating systems.

Performed browser compatibility and configuration testing on various operating systems such as Blackberry OS, Android OS, IOS etc..

Documented Test plans, Test Cases and decided schedules for Test Case execution

Reviewed extensive SQL Queries with complex multi-table joins and nested queries.

Performed negative and positive testing manually.

Participated in conducting System testing and End to End testing manually.

Extensive UAT Testing Manually.

Performed Usability and Integration testing manually.

Tested SOA processes and methodologies used to deliver Customer order application, New Web Application for quality standards interface to meet customer expectation.

Performed UAT testing coordinating with BA, Developers, and SMEs and actively involved in Production phase testing.

Participate in Weekly Review Meetings.

Used JIRA bug tracking tool to analyze & capture bugs, track and manage dashboard any type of updates for project release.

Performed rigorous manual testing such Functional Testing, Smoke testing, Integration testing, UAT Testing, Backend Testing, Regression Testing, End to End Testing and System Testing

Environment: Java, J2EE, HTML, MS SQL Server, WSDL, XML, POS, Mobile Devices for IOS, Android OS and Blackberry OS, etc.

Accenture, Hyderabad-IN May 2018– April 2021

Role: QA Test Engineer

Create Test related documents such as Test Plan, Test Scenario, and Test Cases throughout the STLC.

Interacted with the business analysis and developers in requirements analysis, review design documents, testing and documents which are developed in to Agile, scrum, and sprint environment.

Performed rigorous manual testing such smoke testing, Integration testing, Regression Testing, End to End Testing and System Testing.

Actively participated Agile and scrum meetings, review and developed test scenarios.

Followed Agile Methodology to emphasize on real time communication over written documentation.

Performed Functionality testing during various phases of the application and analyzed the results.

Worked with java-based applications and C++ simultaneously: iOS and Android.

Performed functional testing of individual modules (Accounts, Trading, Quotes and More) of the Applications

Documented Test plans, Test Cases and decided schedules for Test Case execution.

Reviewed extensive SQL Queries with complex multi-table joins and nested queries.

Performed negative and positive testing manually.

Participated in conducting System testing and End to End testing manually.

Extensive UAT Testing Manually.

Performed Usability and Integration testing manually.

Tested SOA processes and methodologies used to deliver Customer order application, New Web Application for quality standards interface to meet customer expectation.

Performed UAT testing coordinating with BA, Developers, and SMEs and actively involved in Production phase testing.

Participate in Weekly Review Meetings.

Used JIRA bug tracking tool to analyze & capture bugs, track and manage dashboard any type of updates for project release.

Performed rigorous manual testing such Functional Testing, Smoke testing, Integration testing, UAT Testing, Backend Testing, Regression Testing, End to End Testing and System Testing

Environment: Java, J2EE, HTML, MS SQL Server, WSDL, XML.

Vestrics Solutions Private Limited, Hyderabad, IN July 2017– May 2018

Role: QA Test Engineer

Created Test Cases, Test Scenarios in Quality Center ensured traceability to Business Use Cases and according to application.

Involved in creating of Test Accounts in mainframe application according to the Business Requirements in utilization for testing.

Create testing strategies for Disaster Recovery (DR) efforts.

Involved in writing test scripts manually and tested manually as per the specification documents.

Created and executed scripts manually for Functionality testing.

Provide support and data as and when needed to the performance Team.

Created test cases manually to perform different types of testing such as positive/negative, functional/regression, interface, black box, batch testing, screen navigational testing, smoke/sanity testing, unit testing, performance testing, exploratory testing or Backend testing.

Created and Maintained Test Matrix and Traceability Matrix.

Generated Test Traceability Matrix (TTM) to show the test case execution status.

Performed Positive and Negative testing to test response of the application under test by creating Data Driven tests.

Formulated detailed Test Plan, Test Cases and Testing Procedures, which included Test Cases/Scripts, performed configuration/ compatibility and user interface testing manually.

Performed Smoke and Sanity testing.

Performed Positive and Negative Testing

Performed Security testing and Backend testing Manually.

Backend Testing using SQL and Unix Shell Scripts

Participated in conducting System testing and End to End testing Manually.

Extensive UAT Testing Manually.

Performed Usability and Integration testing Manually.

Documented bugs found out during the process of testing.

Reported Defects in Defect tracking tool of Quality Center (Mercury & HP) by assigning Defects to developments that are encountered during testing phase based on application teams.

Coordinate with Operations team to make sure that new platform has robust testing processes.

Created RTM and performed Gap Analysis to ensure the requirement coverage.

Recommend and implement naming convention for Test Cases, Test Sets and Defects.

Attended Weekly status meeting in reporting and provided a weekly report that includes test metrics consisting of status reports.

Environment: Quality Center, UNIX, Oracle, DB2, HTML. .Net, MS Office, Windows

Education:

B.Tech in Computer Science from JNTU (2013-2017), Hyderabad, Telangana



Contact this candidate