Professional Summary:

Having over *.* years’ experience in Functional Testing, Integration Testing, System Testing and Scrum master. During these years I have acquired a very good knowledge of Functional Testing, Integration Testing, and System Testing.

Experienced in designing test plans and test cases, verification and validating applications, documentation based on standards for software development and effective QA implementation in all phases of Software Development Life Cycle (SDLC).

Performed System Testing, Functional Testing, Black Box testing, UAT (User Acceptance Testing) and Regression Testing

strong technical knowledge and hands-on experience with ETL Testing, UI Testing and SQL and backend testing

Experience in unit testing, functional testing, user acceptance testing, integration testing, system testing, sanity testing, compatibility testing, and security testing of client/server and web-based applications.

Developing and Maintaining Test Scripts, analyzing bugs and interacting with development team Members in fixing the defects.

Exceptional ability to interact with customers and developers to interpret and analyze requirements, communicating changes in requirements, resolving conflicts and assuring project delivery on time and to report on progress to the entire team.

Working experience with defect tracking tools like Bugzilla, Jira.

Proficient in the testing database of applications developed with SQL Server, Oracle, and MS Access.

Experience in writing SQLs, Procedures and Triggers in SQL Server, Oracle and MySQL

Good knowledge of Core Java

Good knowledge of SOA and Web Service Tersting Using SOAP UI.

Strong SQL skills Hand-on experience with load transfer, data validation with different databases

Hands on experience in Black box testing, unit testing, Component testing, Integration testing, system testing, functional testing, GUI, smoke, sanity and User acceptance testing.

Developing and maintaining test scripts, analyzing bugs and interacting with development team members in fixing the defects

Good experience in working with Agile Methodology.

Experienced in the use of the MS Office suite of applications.

Excellent Analytical and Problem-solving Skills.

Good exposure to Core Processing and Functional Areas of Retail domain.

Strong knowledge of ORMS – ORACLE RETAIL MERCHANDISE SYSTEM Testing, RPM – Retail Price Management, ATG/E-Commerce - E-Art Technology Group, Strong knowledge on RLTP – Retail Logistic Transformation Programme.

Experienced in Test Estimation, RLS preparing structured and high quality documents - Master test plan.

Strong knowledge of Testing Concepts - Well conversant with Software Testing Life Cycle, necessary for executing projects.

Worked as ORMS/ORPM/ATG Having good knowledge of Quality Center 11.0 and Web-Application/ORPOS/Database QA Tester in Retail.

Good exposure to Core Processing and Functional Areas of Retail domain.

Reports (Publishing Dashboard and preparing Test Result Matrices.

Technical Skills

Operating Systems

Windows 9x/2000/XP, Unix

Databases

Oracle11g, Oracle9i, Oracle10g, MS - SQL Server,

Tools and Technologies

TOAD, HP Quality center, MS SQL Server, Mainframe, Mingle, JIRA, Eclipse, Core Java

Domain

Retail, Manufacturing

Highlights

Recognized with “Thanks a Zillion” Award by WIPRO for End To End Testing in SIGNING-Re-Platform and Managing streamlined delivery from Offshore.

Education:

B Tech Completed in 2012 from Sathyabhama University India.

Professional Experience:

Teleperformance

Client: Dicks Sporting Goods, Salt Lake city Utah

QA Analyst May 2020 Till date

Roles and Responsibilities:

Worked with oracle tools like CEP(Customer Experience Portal) and CVCC.

Involved in performing Functionality testing, Validation testing, Negative and Positive testing, Integration testing, testing manually on the first release of the application.

Handling Order Management and Payment issues in Production and other module as well.

Worked in the form of sprint team with business analysts and developers in agile methodology.

Analyzed, revised and created test scenarios according to business and functional requirements.

Created Test runs, Test cases, Mockups, Process Flow diagrams from the functional documents.

Created detailed Test cases according to business requirements.

strong technical knowledge and hands-on experience with ETL Testing, UI Testing and SQL and backend testing

Strong SQL skills Hand-on experience with load transfer, data validation with different databases

Used complex SQL Queries to perform back-end data base testing

Used Quality Centre and JIRA as the test management tool for the maintenance of the test cases and to track the defects.

Prepared the traceability matrices to fill the gap between the requirements and the test cases covered.

Strong conceptual knowledge on Data Warehousing and Administering Database Users (creation, granting privileges).

Having good knowledge of Quality Center 11.0.

Able to learn / grasp early and update oneself on the needed technical and functional skills for effective deliverables.

Knowledge on Defect management, Client Review calls and attending Final Sign off calls.

Excellent team player, flexible in office timings based on the support required from onsite. Conducted Session during client visits.

Environment: JIRA, SQL,Unix, HTML, XML TOAD, HP Quality center, MS SQL Server, Mingle, JIRA

Wipro Technologies

Client: Charming Shoppes Inc. Bensalem, PA

QA Analyst May 2014 to Oct 2017

RETAIL MERCHANDISE SYSTEM (RMS) – RETAIL DOMAIN

Project Description:

Charming Shoppes Inc is a specialty and plus size clothing retail holding company based in Bensalem, Pennsylvania; a suburb of Philadelphia. Its subsidiaries are Lane Bryant, Fashion Bug, Cacique and Catharine’s Plus. Clothes are sold from over 2300 retail stores in the United States, as well as numerous catalogs and online sites. Charming Shoppes was founded in 1940, went public in 1971, and was ranked 810th on the 2010 Fortune 1000.

Testing is done on the Oracle Retail Merchandising System (ORMS) and the Oracle Retail Price Management System (ORPM) application. This includes Creation and modification of the basic levels of Organization and Merchandise Hierarchy along with creation of the lower levels like Group/Class/Sub-Class. It includes placing an Order/Shipment and Receipt confirmation of the same. It also includes Creating HTS and attaching HTS to Item Level along with the Set-up of Suppliers and Partners. They Store Inventory Module includes the Creating the Inventory for Stores start from Null as the Value for Stock in Hand to greater numbers of Stock. Also, the DC Inventory (Direct Customer) is created for warehouse with the same ranges of Stock on Hand. Testing comprises the Store creation and the Stock count for Store Items and Warehouse Items along with the Item creation with and without Differentiators. It also encompasses Creation of Different type of promotions such as Simple Promotions, Threshold Promotions, Multi-BUY, Mark UP, Mark Down and Clearance promotions.

Roles and Responsibilities:

Analyzed the Sources, targets, transformed the data, and mapped the data and loading the data into Targets.

Involved In unit testing and prepared the test cases and done manual testing.

Wrote

Test Cases using Quality Center according to functional documents and requirements.

Analyzed test results and generated defect report in Quality Center.

Executed and Tested work flows to load data from HUB source system to staging area and then to Data Warehouse tables. Tested the correctness of data using SQL queries.

Involved in System Integration Testing, Data Warehousing Testing, Retesting, Regression testing.

Created and executed sessions and batches using Workflow Manager and Workflow Monitor.

Good functional knowledge on Oracle Retail Merchandise System and Oracle Retail Price Management

Analysis and walkthrough of Functional Requirements – Creation of Test Scenarios

Analysis of Functional and Technical specification Document.

Creation of System, Interface, Functional, System, End to End and Regression test cases for Oracle Retail Merchandise System (ORMS)

Creation of Stores, Items, Promotions etc.

Running of script on Putty/Batch Jobs for the Store data updation

Execution of the Test Cases.

Preparation of Requirement Traceability Matrix

Creation of Test Estimation Document, Master Test Plan.

Verifying correctness of Test Scripts and output of Tests in Database using MS SQL Server.

Preparation of Test Log after Execution of Tests

Preparation of Defect Traceability Matrix

Manually tested the application executing test cases in the Quality center.

Done Retesting and Regression Testing.

Test Management in Quality Center – Requirement Mapping/Test Case Design/Test Case Execution/Defect logging and Tracking.

Environment: HP Quality Center, Quality Center, Bugzilla, Agile, SQL, JIRA, Oracle Sql UI, SharePoint.

Client: Kohl’s Department Stores Inc – ATG, Menomonee Falls, WI

QA Analyst May 2012 to April 2014

ORACLE ATG E-Commerce- RETAIL DOMAIN

Project Description:

Kohl's Corporation is an American department store chain headquartered in the Milwaukee suburb of Menomonee Falls, Wisconsin, Operating 1,089 stores in 49 states. In 1998, it entered the S and P 500 list, and is also listed in the Fortune 500. The Chain was the 20th-largest retailer in the United States in 2011 in terms of revenue. Kohl's is the 4th largest US department store by sales, below JC Penney, and above Nordstrom.

Oracle Art Technology Group (ATG) is Oracle’s Web Ecommerce Platform which enables the user to deliver a personalized online buying experience for each customer by presenting relevant content and merchandizing, personalized search, customized marketing programs, and tailored websites. Web commerce capabilities allow the users merchandise more quickly, easily, and effectively, rapidly launch commerce sites for new brands, markets, and even single-purpose campaigns, easily create and manage both simple and complex promotions, use mobile devices and social media to drive sales, and quickly expand internationally and target new countries and segments more effectively. Built on a foundation of proven capabilities, including personalization, business user control, cross-channel support, and a flexible platform, ATG Web Commerce boosts cross-channel business growth. Advanced features help customers quickly find desired products, learn about new offerings, comparison shop, register for gifts, Preorder products, redeem coupons, and easily complete their purchases.

Roles and Responsibilities:

The basic purpose of the project is to build a BPM solution that will empower the business users to configure, administer and edit the rules for Enrollment validation, Reimbursement Claims which includes Original and Adjustment claims.

Understanding the functionality of the upcoming Requirements having Sprint wise release following Agile Methodology

Creation/Validation and Maintenance of Accounts created in Kohls.com

Analysis of Functional and Technical specification.

Creation of Test Data, Test Plan

Preparing Functional/Regression Test Cases

Extensively written many SQL scripts against Facets Enrollment tables.

Participated in Smoke Testing, Integration Testing, System Testing, Regression Testing and Performance Testing.

Maintained Requirement Traceability Matrix (RTM) to make sure that scenarios were written for all the requirements.

Involved in daily Scrum meetings for status updates of the projects.

Good knowledge of SOA and Web Service Tersting Using SOAP UI.

Client Review meetings for the correctness of Test Cases prepared.

Uploading Test Cases in HP Quality Centre.

Test Case Execution – Integration Testing(SIT)/System Testing of the various interlinked Systems/Interfaces.

Using HP Quality Centre for Test Design/Execution/Requirement Mapping and Logging/Tracking Defects in Mingle and Jira

Attending Defect Triage Calls.

Conducting Functional and Regression testing to validate online screens and management of Account for websites as Kohls.com

Order Processing in App Watch, OMS,CSC

Providing Knowledge Transition to the offshore team and mentoring new team members in understanding the Project/Concepts.

Environment: Agile, Scrum, HP ALM/Quality Center, SQL, Microsoft Office Word/Excel.

Contact this candidate