Test Cases Web Services

NAGALAKSHMI ADLURU

Status: Green Card Holder

Email: ********.******@*****.***

LOCAL TO NC

PROFESSIONAL SUMMARY

Around 6 Years of professional experience in IT working both in development and Testing phases of SDLC.

Extensive experience working in both Agile and Waterfall methodologies.

Worked extensively in both Manual and Automation Testing using Selenium WebDriver.

ETL and BI Testing: Involved in both ETL and Reporting initiatives and extensively used SQL queries.

ETL Testing Experience: Very good knowledge on automation various ETL jobs and very good understanding of automating Test scripts to verify the database results.

Extensively involved in performing ETL testing, Reports Testing, Automation Testing and WebServices Testing.

Extensive ETL testing experience using Informatica (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager).

BI Testing: Experience in Business Intelligence testing in various reports using Cognos and Business Objects etc.

Developed web based applications using Java, Servlets, JSP, HTML, and JavaScript.

Good knowledge of various SDLC methodologies like Waterfall and Agile (SCRUM) with analyzing requirements and business needs, developing test plans for execution.

Experience in developing end to end automation using Selenium WebDriver, Junit/TestNG, Maven, Jenkins, Cucumber, Web Services (REST, SOAP).

Worked on database queries, creating test data and worked with oracle and MySQL databases.

Excellent knowledge and working experience with test planning, developing test scripts, test execution, test results analysis and reporting.

Good experience in setting up a QA environment, Installation testing and bug report generation.

Extensive experience in Unit Testing, Functional, Integration, Regression, User Acceptance, Load, Smoke, Stress and Volume Testing.

Experience in using RestAssured framework to test Rest Service calls.

Used Extent reports in BDD and have experience with TDD environment as well.

Well versed in using Fire path on Firefox in element identification and implementing actions in Selenium

Extensively knowledge of SOAP UI tool for verifying both SOAP and Restful WebServices.

Very good knowledge of using Assertions when verifying WebServices.

Worked on Cross browser testing, browsers like Mozilla Firefox, Google Chrome and IE using WebDriver.

Worked with different teams by coordinating testing efforts, running regression suite for release efforts

Excellent knowledge of Selenium Webdriver and in using various Locators such as CSS, Xpath, ID, Name etc.

Proficiency in Defect Management including creating, modifying, reproducing, tracking, prioritizing and reporting using industry standard tool like Jira, HP ALM.

Ability to take initiative, prioritize and work independently to meet deadlines.

Ability to adapt to new environment quickly, strong team player, good communication, good analytical and computation skills, enthusiastic learner, confident, sincere and committed.

Very good Knowledge on Data Warehouse concepts and ETL Testing.

TECHNICAL SKILLS

Defect/Bug Tracking Tools Jira, ALM

Testing Tools Selenium Webdriver, Cucumber, Junit, TestNG, Jenkins

ETL Tools Informatica

Programming Languages C, Java

Databases Oracle11g, 9i, My SQL

Operating Systems Windows 7 & 10, UNIX

PROFESSIONAL EXPERIENCE

Maersk Inc, Charlotte, NC Oct 2016 - Till date

Role: QA Tester

Emphasis: WebServices testing, Manual Testing, Automating Testing, Reports Testing.

Project 1 Description: Maersk Inc. provides container shipping services in the United States and Internationally. It offers dry cargo services, Refrigerated shipping containers for transporting cargo requiring temperature-controlled conditions and other cargo services that are used for transporting heavy machinery, engines and other oversized items. The Project Involves Testing of various functionalities of the application which involved Web Services Testing as well backend testing. I used extensively SOAP and Restful Web Services/ APIs and SOAP UI tool for performing the validations.

Project 2 Description

Role: QA Tester

Emphasis: Reports Testing, Manual Testing, Backend Testing, SQL Queries

Project 2 Description: The Project involved migration of various reports from Legacy tool to Cognos tool and as a Tester my role was test various reports to ensure that they were as per the Requirements and to ensure that the front end matches with that of the backend.

Responsibilities:

Involved in requirements analysis and test plan preparation for various Reports.

Involved in testing various Reports to make sure that the front end data matches with that of the backend.

Very good knowledge of Cognos reporting tool to execute the reports and to verify various scheduling requirements.

Responsible for System testing of Ad-Hoc Query Packages in Cognos which involved developing and execution of Ad-hoc reports and corresponding Test SQLs based on various join conditions and filters and calculations

Tested Web Services using SOAP UI tool and identified various automation Test cases.

Developed test design includes test data and worked on planning sessions and reviews for QA.

Created test plans, test cases management using HP ALM.

Involved in design and implementation of Selenium WebDriver automation framework for smoke and regression test suites (TestNG and Maven). Checked Log files to analyze errors experienced using Log4j during testing.

Resolved browser issues and compatibility issues while working with Selenium, TestNG.

Worked on reporting update, writing results and emailing regression results to team using Jenkins post build actions.

Worked on functional testing and automation scripts development.

Executed regression testing using Jenkins by scheduling jobs frequently.

Used HP ALM for storing, maintaining the test repository, bug tracking and reporting and test plans results update.

Worked on updating automation results update to ALM through rest calls when test sets are executed.

Maintained and executed Maven build files for running automated tests.

Used Maven to help manage project’s build, report and documentation across the network.

Involved in the Continuous Integration of the automation framework with Jenkins.

Testing of web services using Rest APIs.

Assessed testing processes and implemented testing strategies in UAT phase.

Developed SQL Scripts for Backend Testing to ensure that the data is updated as per the Business Rules.

Seagate Inc. Oklahoma City, OK Mar 2015 – Aug 2016

Role: QA Tester

Emphasis: ETL testing, Manual Testing and Automating Testing

Project Description: Seagate is the global leader in data storage solutions, developing amazing products that enable people and businesses around the world to create, share and preserve their most critical memories and business data. I involved in multiple projects to create a new improved version of Seagate online store to increase the online sales and promote new products as well involved in ETL testing to ensure that the Data from various sources was integrated in to the Data Warehouse as per the Requirements.

Responsibilities:

Involved in understanding various BA and Design documents and wrote Test cases and test scripts accordingly.

Understood various Data Mapping documents created by the ETL BA and wrote Test conditions accordingly.

Worked with development leaders and architects to understand the requirements.

Designed test plans, developed test cases and test scripts.

Worked in agile environment to closely working with developers and collaborating testing activities as required.

Worked on test cases documentation, defects creation in Jira.

Conducted test plan review meetings and designed automation scripts and implemented test plan strategy.

Understood various data mapping documents of Source and Target tables and verified that the data was mapped correctly using SQL queries.

Reviewed database business and functional requirements, reviewed ETL mapping transformations

Worked with Program Managers, Requirement Analysts, Mappers, Developers, and other testers to resolve issues with requirements/mapping transformations for various ETL requirements.

Created Test Plans and test scripts, executed test scripts, and wrote Test Report Created traceability matrix and mapped requirements to Test Cases.

Developed automation scripts with Selenium, Java, Cucumber and Extent Reports. Used Jenkins for running and scheduling jobs for automation tests execution.

Interacted with developers and management to identify and resolve technical issues and creating automation scripts for production bugs.

Involved in automation of various scripts to ensure that the database was updated correctly.

Executed queries against databases to verify the correctness of various ETL mappings.

Executed smoke tests frequently and ran regression scenarios using Jenkins.

Solved day to day problems of the team arising due to functionality and validation issues.

Analyzed root cause for defects and documented them accordingly.

Kept track of defect information and follow up and automation scripts execution for fix and regression for release risk assessment and approval.

Manheim Atlanta, GA May 2012 – Feb 2015

Role: QA Analyst

Emphasis: Manual Testing, Black Box testing and Automation Testing

Project 1 Description: Manheim is North America’s leading provider of vehicle remarketing services, connecting buyers and sellers to the largest wholesale used vehicle marketplace and most extensive auction network. The project involves development of auctions reporting tool using Java, HTML, XML, CSS, JavaScript, JSP, JDBC, and MVC. Involved in resolving production issues and created support documentation.

Project 2 Description: Project involves enhancement of accounting and online payments, invoices for automotive financial services. Client Implemented bank accounts management using servlets, JSP’s, CSS, JavaScript, and HTML. As a Tester my role was to perform functionality testing of various Accounting and Online Payments modules. Used extensively Selenium Automation tool to create and execute various automation Test scripts.

Responsibilities:

Wrote, prepared and executed Manual Test Cases based on Requirements and Use Cases, and Automated Test Scripts throughout Software Development Life Cycle (SDLC)

Designed, documented and maintained moderate to complex testing strategies for use by the Quality Assurance (QA) team

Reviewed Functional Specifications Document to determine & analyze functionalities for testing and prepared Test Plan, Test Cases and Test Scenarios for various Testing Cycles

Attended in Scrum Stand-ups and Code & Design Review meetings for QA updates, defect status, priority and Test Deliverables

Involved in identifying various Test cases to automate and created Automation scripts using Selenium Webdriver.

Maintained Requirements Traceability Matrix (RTM) to measure testing process and coverage & created Test Data and Test Bed for final User Acceptance Testing (UAT)

Tested and analyzed web services and wrote detailed reports

Performed Backend Testing by writing queries in order to view successful transactions to validate the data using SQL queries in database

Reported progress on Test Case execution, Defect Remediation and Closure, and Test Planning activities on a weekly basis and as required to the upper management

Created various Defects Reports and Test Reports and reviewed with the Stakeholders before the release to set the priorities correctly.

Extensively used SQL queries for creating Test data for various testing scenarios.

EDUCATION: Bachelor of Engineering, Sri Venkateshwara University, Tirupati, India

Contact this candidate