Associate Software Automation Engineer

RAVALIKA KOTHA E-mail: *****************@*****.***

Sr. QA Automation Engineer Phone: +1-469-***-****

QA Automation Engineer with 7+ years of experience Sterling OMS, Blue Yonder OMS, Manhattan OMS analyzing, review and understand business requirements and skill enough to prepare Test Plans, Test Scripts, Test Scenarios, Test Cases and generates result reports. Expertise in executing test cases manually as well as generate automated scripts for TDD, BDD, API Testing using tools like Selenium, Cucumber, Postman, Soap UI, and frameworks like TestNG while serving clients in various domains such as Retail and E-Commerce.

Professional Summary

●7+ Years of experience in Software Quality Assurance, which includes experience in Web Automation, Web Services/API, in domains like Retail, Logistics/Supply Chain and Ecommerce, Client/Server, Database applications.

●Expert in STLC (Software Testing life cycle) and SDLC (Software Development life cycle) including Agile Methodology/SCRUM, Waterfall and TDD and developed Test scenarios, Test Suites, Test cases, Test Data, Test procedures, Test reports and documenting manual and automation tests.

●Extensive experience in Manual, Functional, Automation Testing and API testing of Retail Domain applications

●Strong knowledge on Sterling OMS, which includes Order capture, Sourcing and Fulfillment, Inventory management, Fraud management, Reverse Logistics, Customizations etc.

●IBM Sterling OMS testing with over 7+ years of experience in implementing IBM's sterling commerce multi-channel fulfilment solution suite.

●Experience in working on REST web services in OMS.

●Led the different phases of IBM Sterling OMS V9 Implementation which includes - Requirements Gathering, Detail Design & Interface Discussion, Analysis, Store Fulfillment, Configurations.

●Worked on Order Capturing, Payments Authorizations, and settlements with different tender types

●Maintained the issue tracker for tracking SIT defects and coordinated with parallel UAT execution for daily

●Standup meetings

●Created a presentation with workflow, schedule, and strategy for the application kickoff meeting.

●Executed Black box, White box, Regression, Integration, Negative, User Acceptance Testing (UAT). Reported and tracked bug status using Jira

●Experience in Automation Testing using Selenium.

●Experience in developing in Core java programming using OOPS concepts.

●Proficient skill set in Sterling OMS DevOps Product Support, Consultant, Testing/QA.

●Expertise in JMeter Automation testing

●Handled the special mouse events and selected the options from the tab menu using Selenium Action class, mouse hover, and wrote selenium script for taking screen shot for failed test cases.

●Created POM to store the project data and configure their details using Maven to build the project.

●Used MAVEN to build and run the Selenium automation framework, used Jenkins to send the automation reports over email.

●Expertise in Smoke, Functional and Regression Testing.

●Highly involved in Requirement Analysis with the development team and the client.

●Having good exposure in Agile Methodology – Scrum Activities.

●Have worked in more than 25 sprints in Scrum within 1 year.

●Worked on Ad hoc testing some sprints based on defects.

●Proficient in Functional testing, Regression testing, Integration testing, Database testing, User Interface & System testing.

●Experience in highly available business applications for enterprise customers like WCC, IBM Sterling OMS, TIBCO, Kibana, CCUI, RSUI, MDM and E-Commerce.

●Experience Order Management System having tested Sterling Order Management System and its Integration with Other Retail Systems. Well-versed in Retail and Supply Chain Concepts and all Integration points with Sterling OMS.

●Responsible in developing Test Cases with QAC & Test Rail using it as a Test Management Tool

●Developed the common utilities and web driver utilities for automation framework. Involved in creating and maintaining object repository.

●Good knowledge on Data Driven, POM and TestNG.

●Experience in creating Requirements Traceability Matrices to ensure comprehensive test coverage of requirements.

●Extensive experience with Test Documentation (Test Scenario, Test Case, Test Data, Defect Report, and Test Metrics).

●Expertise in Bug Reporting & Tracking Process, Bug Reporting and Tracking using Bug tracking tools as JIRA.

●Participated in Requirement review meetings, analyzed requirements, developing test plan and test cases, Requirement Traceability Matrix, Defect Management, Reporting and Tracking.

●Defect Reporting and Tracking using any Defect Management Tool (Jira, QAC (10.0)).

●Experience in API testing using SOAP UI using Postman.

●Extensively Automated REST services using Rest Assured API and Java

●Actively interacted with the development team in resolving Bugs identified from Testing.

●Hands on in SQL Queries using MS SQL Server, Oracle.

●Strong knowledge on creating and maintaining test data for regression in future releases.

●Received several accolades from clients and higher management for delivering quality tasks.

EDUCATION:

Bachelor of Technology in Computer Science Engineering, India

Technical Skills:

Testing Skills

Functional, Blackbox, Sanity, GUI, Regression, Smoke, Integration, Selenium IDE, WebDriver, Soap UI, JMeter, Java

Operating Systems:

Windows XP,7,8, GitHub, Kafka

Management Tool:

QAC, Test Rail

Automation Testing Frameworks

TestNG, BDD/Cucumber Framework, Junit, Page Object Model

Middleware:

TIBCO, Kibana

Automation Testing Tools

Selenium Web driver, JMeter

Mainframes:

AS400

Environment

Web, Client/Server

Database

MS SQL server

Defect Monitoring Tool:

JIRA, QC.10.0

Continuous Integration Tool

JENKINS

Tools Involved

WCC, IBM Sterling OMS, TIBCO, Kibana, CCUI, RSUI, MDM and E- Commerce, WMS, PKMS, Media-Saturn, Postman, Blue Yonder OMS

PROFESSIONAL EXPERIENCE:

Publicis Sapient and Blue Yonder Mar 2022 _ Till date

Client ASDA

Automation Engineer

Responsibilities:

●Worked with Product, Design and Engineering teams on requirements gathering and evaluation.

●Worked on Blue Yonder Order Management system using Luminate portal and JSON’s

●Worked on Product Reservation, Product Creation, Order creation, Shipment management, Return & Replacements

●Participate in product design reviews to provide input on functional requirements, product designs, test estimates, schedules, and potential risks.

●Performed Regression testing to ensure there are no defects for the release.

●Participated in stand-up calls on daily basis and had two- week Sprints in Agile Methodology

●Tested API JSONS using Postman Application with Kafka end points.

●Created automated script for REST-API testing, using cucumber to automate services using Rest API framework

●Developed Test Scripts to implement Test Cases, Test Scenarios, and features for BDD (Behavior Driven Development), TDD (Test Driven Development) using Cucumber in Gherkins format.

●Used GitHub to maintain and manage the build scripts, test data used, and other documents related to the project.

●Executed the scripts in Pipeline by selecting the environment and details before merging the code into Main.

●Validate the order statuses, price, order line shipping charges attributes in Luminate portal and Orchestration UI

●Performed functional testing of web services using SOAPUI and RESTful web services.

Environment: Java, Selenium, TestNG, XPath, Eclipse, Data Driven and Page Object Model, Cucumber,

REST, MYSQL, Oracle, Maven, Jenkins, Agile/Scrum, Gherkin, BDD.

Publicis Sapient Media Market Saturn Aug 2021 _ Mar2022

Automation Engineer

Responsibilities:

●Worked with Product, Design and Engineering teams on requirements gathering and evaluation.

●Participate in product design reviews to provide input on functional requirements, product designs, test estimates, schedules, and potential risks.

●Performed Regression testing to ensure there are no defects for the release.

●Participated in stand-up calls on daily basis and had two- week Sprints in Agile Methodology.

●Developed the test scripts using JMeter tool

●Worked with IBM Sterling OMS

●Used JMeter to create Thread Groups and test Web Application for various loads on key business scenarios.

●Prepared and executed of test scripts using JMeter and SOAP UI tool to perform Web Services testing.

●Developed Test Scripts to implement Test Cases, Test Scenarios, and features for BDD (Behavior Driven Development), TDD (Test Driven Development) using Cucumber in Gherkins format.

●Used GitHub to maintain and manage the build scripts, test data used, and other documents related to the project.

●Performed functional testing of web services using SOAPUI and RESTful web services.

●Updating and execution of test scenarios before each release.

●Automate all manual test cases with JMeter

●JMeter framework scripts integrate with Jenkins & GitHub

●Automated scripts walkthrough with Dev, BA teams

●Performed End to End testing for business flows.

●Automated all Fulfilment types of store orders, Store fulfilments.

●By using ant plugin generating test results to integrate with Jenkins

●Develop the test cases based on country & fulfilment types.

●Attended daily Scrum call with BA, Dev, and involved in Business walkthrough and demos.

●Defect Reporting Using JIRA as a Defect Tracker.

●Track upcoming release readiness and environment readiness.

●Update and trigger Jenkins's job for covering automated functionalities.

●Maintain confluence page and share point to track execution and upload results.

Environment: Java, JMeter, XPath, Data Driven and Page Object Model, Cucumber, REST, MYSQL, Oracle, Maven, Jenkins, Agile/Scrum, BDD.

Prolifics William Sonoma Inc Feb 2019- Aug 2021

Software Engineer

Responsibilities:

●Part of the scrum team responsible for requirement gathering, planning and development of the test plan and scenarios for manual and automated testing.

●Worked on IBM Sterling Order Management system by fulfilling the orders from OMS, creating orders by using Call center & E-Commerce applications

●Worked on PKMS Application to perform the different shipments for all type of orders, Worked on DSV and Purchase order management, Store Management, Return Management.

●Worked on Descartes Application to perform the Furniture order shipments

●Validating the interface logs in Kibana and SQL, Capture the order status, Price values address validations in SQL tables.

●Worked on Production support, Appeasements, Release Regression projects

●Actively involving in the sprint planning, grooming sessions to understand the business and gain knowledge on the architecture of the project and functional requirements.

●Writing manual test cases and testing the application on local, development and QA environments

●Participated in stand-up calls on daily basis and had two- week Sprints in Agile Methodology.

●Worked on multiple applications to validate the status in all downstream systems.

●Worked on Black Box Testing like functional testing, regression testing

●Validate the Kibana interface documents with latest Payloads.

●Tested React Application with BDD framework and selenium for automation scripting.

●Implemented automation using Selenium Grid to perform testing on multiple devices.

●Handled various Alerts using different methods such as dismiss, accept, get Text in effective way depending on the requirement.

●Responsible for developing the scripts to support Jenkins (Continuous Integration) of the scripts with the build server.

●Developed Test Scripts to implement Test Cases, Test Scenarios, and features for BDD (Behavior Driven Development), TDD (Test Driven Development)

●Used GitHub to maintain and manage the build scripts, test data used, and other documents related to the project.

●Defect Reporting Using JIRA as a Defect Tracker.

●Track upcoming release readiness and environment readiness.

●Update and trigger Jenkins's job for covering automated functionalities.

●Maintain confluence page and share point to track execution and upload results.

Project1 Feb2019 - Nov2019

Project : Production Support

Role : Associate Software Engineer

Software : WCC, Sterling, E-Commerce, Tibco, RMS, MDM, CCUI, RSUI. Defecting Tool : Jira

Description: Production Support aimed to include enhancements and production bugs of Sterling, DTC, TIBCO, PKMS, RMS and MDM.

Responsibilities:

●Involved in initial Requirement Analysis phase and understanding user stories defined in Jira

●Actively involved in daily stand-up meetings for updates.

●Responsibilities include creation of test suites, creation of test cases, test case execution, defect logging, defect retesting, regression testing, staging testing and production testing

●Estimate the testing requirements and develop test plans, test approach based on the test strategy with Time Schedules.

●Defect logging in Jira.

●Followed the Agile Development process and completed the testing within the scheduled release date.

●Monitoring & reporting on standards & performance targets.

●Dealing with the Development team and resolving problems and issues, which arise.

●Ensuring all records entered and updated correctly.

●Regression testing performed after each new build of the application.

●Developing SQL Queries to perform Database testing.

●Ensuring daily status will be sent to the client on time.

Project2 Nov2019 - July 2020

Project : Appeasement

Role : Associate Software Engineer

Software : WCC, Sterling, E-Commerce, Tibco, RMS, MDM, CCUI, RSUI. Defecting Tool : Jira

Description: Appeasement aimed at When a customer is not satisfied or has had a bad experience with any of the services that were provided, you can present them with the option to appease them, after applying the appeasement on SO “Auto Policy” hold applied on the order. Removing logic to put returns triggered with appeasement on Auto Policy hold. This is due to business users being unable to make modifications to refund to customer in this phase. Sterling will automatically deduct appeasements from refund to customer. Refunding customer Refund Total minus Appeasements automatically in Sterling without business decision

Responsibilities:

●Involved in initial Requirement Analysis phase and understanding user stories defined in Jira

●Actively involved in daily stand-up meetings for updates.

●Responsibilities include creation of test suites, creation of test cases, test case execution, defect logging, defect retesting, regression testing, staging testing and production testing

●Estimate the testing requirements and develop test plans, test approach based on the test strategy with Time Schedules.

●Defect logging in Jira.

●Followed the Agile Development process and completed the testing within the scheduled release date.

●Monitoring & reporting on standards & performance targets.

●Dealing with the Development team and resolving problems and issues, which arise.

●Ensuring all records entered and updated correctly.

●Regression testing performed after each new build of the application.

●Developing SQL Queries to perform Database testing.

Ensuring daily status will send to client on time

Project3 . July 2020 - August 2021

Project : Release Regression

Role : Associate Software Engineer

Software : WCC, Sterling, E-Commerce, Tibco, RMS, MDM, CCUI,RSUI. Defecting Tool : Jira

Description: Williams-Sonoma is a retail company which deals in furniture and other household products. Release regression team is introduced to perform pre-production regression and to make sure all the major functionalities are working fine before going live.

Responsibilities:

●Updating and execution of test scenarios before each release.

●Performed End to End testing for business flows.

●Attended daily Scrum call with BA, Dev, and involved in Business walkthrough and demos.

●Defect Reporting Using JIRA as a Defect Tracker.

●Track upcoming release readiness and environment readiness

●Update and trigger Jenkins's job for covering automated functionalities

●Worked with Dev team to get the list of impacted areas before every release and cover those areas while testing

●Maintain confluence page and share point to track execution and upload results

Environment: Java, IBM Sterling, Functional Testing, Black Box Testing Selenium, TestNG, XPath, Eclipse, Data Driven and Page Object Model, MYSQL, Oracle,

Maven, Jenkins, Agile/Scrum.

Data Rakshak Technologies, India May 2016-Feb 2019

Software Engineer

Responsibilities:

●Reviewed Functional requirement and Use Cases documented.

●Developed SQL queries in Oracle.

●Involved in writing and designing templates for the Test Plans and Test cases.

●Created test scenarios and test cases based on functional documents and User stories.

●Created and executed detailed test cases with step-by-step procedure and expected results and maintained the test logs, test reports, test issues, defect tracking using Quality Center.

●Created automation test scripts to test all end-to-end components.

●Review web-based application and identify critical functionalities.

●Performed System Testing, Regression Testing.

●Select Test Cases to be automated and perform functional testing of the front-end using Selenium.

●Created tables, views, stored procedures, functions, triggers, Indexes in Oracle, and MySQL databases.

●Gathering, Understanding and Documenting Requirements.

●Develop and execute Test Plans and Test Cases from requirements and specifications documents.

●Participate and create Test Plans.

●Conducted Data Driven testing to test the application with various sets of data.

●Performed Database testing by executing SQL statements.

Environment: Java, Manual Testing, Black Box Testing XML, Waterfall testing, Eclipse, Oracle, MS Excel, MS Word, Internet explorer

Contact this candidate