DIANICIA MATHEW

Software QA Engineer

Email: adbawk@r.postjobfree.com

Phone: +1-614-***-****

Experience Summary

** ***** ** ********** ** a Software Quality Assurance Engineer in Agile and Waterfall software development models with enterprise corporations like Rent A Center, JC Penney, Abercrombie & Fitch, ADESA, Tech Mahindra and UST Global. Strong experience in all phases of software test lifecycle including requirement analysis, test case preparation, test execution, defect reporting and tracking.

Highlights

Engaged in all phases of SDLC including project planning, scope definition, requirements gathering, scheduling, testing, defect tracking, requirements management, conflict resolution and reporting. Effectively handled all aspects of QA as the single point of contact.

Proficient in functional, negative, regression, acceptance (UAT), security, browser compatibility and integration testing, worked with geographically distributed application development and quality assurance teams.

Expertise in preparing test estimations, test strategies, test plans, requirement traceability matrix and detailed test cases for the Application under Test (AUT).

Expertise in test management tools ALM, HP Quality Center, JIRA, Clear Quest and hands-on experience with test automation tools like QTP.

Have experience in mainframes (Host Explorer tools) and ETL (Informatica tools)

Hands on experience with ETL, Batch Jobs and Migration Testing.

Expertise with Database testing using DB2 and Oracle.

Reviewed requirements/specification documents and proactively requested additional information from project managers, business analysts, and developers to successfully design functional test plans and test cases.

Worked with the development teams to determine the appropriate solution for addressing software anomalies or implementing improvements. Actively participated in defect review and root cause analysis sessions.

Excellent inter-personal abilities and a self-starter with good communication skills, problem solving skills, analytical skills and leadership qualities.

In-depth experience in E-commerce and Retail Domain.

Bachelor’s Degree in Electronics and Communication Engineering.

TECHNICAL SKILLS

OS : UNIX/Linux, Windows XP/VISTA/7/8

Testing Tools/Utilities : ALM, QTP 9.2, HP Quality Center, JIRA, Clear Quest

Languages : HTML, SQL, VB Script, XML

Database Servers : Oracle 9i/10g/11g

Other Tools/Software Used : MS Excel, SQL Developer, TOAD, Microsoft Visio, Informatica 10.1, HostExplorer

EDUCATION

Bachelor of Technology in Electronics & Communication Engineering -2007

PROFESSIONAL EXPERIENCE

Dotcom Team LLC Feb 2014 – Till date

Project 1: RMS Enterprise PO

Client: J.C. Penney (Plano, TX)

Domain: E-Commerce and Retail

Role: Software QA Engineer

J.C. Penney Corporation, Inc.is a chain of American mid-range department stores based in Plano, Texas. The company operates 1,060 department stores in 49 U.S. states In more recent years, the chain has continued to follow consumer traffic, echoing the retailing trend of opening some standalone stores, including some next door to competitors. The company has been an Internet retailer since 1998.

Project Highlights:

This project involves migration of purchase order creations in JC Penney from legacy application (POM) to Oracle RMS.

Over 150 applications got interfaced with POM legacy application which got replaced with Oracle RMS.

Roles & Responsibilities:

Created Test Scenarios and Test cases for modules under test

Involved in System, Integration and End to End and conversion testing.

Supported business in UAT testing

Create and track defects using ALM tool

Involved in conversion testing of data from legacy system to target system

Validated large volume of data after conversion testing.

Interact with business and other teams to better understand the functionality and deliver a quality product

Environment and Tools: ORMS 13.2, JIRA, MS Excel, Oracle 11g, ALM 11, Toad, Informatica 10.1, HostExplorer

Project 2:

Client: Rent-A-Center, Inc (Plano, TX)

Domain: E-Commerce and Retail

Role: Software QA Analyst

RAC provides new and used brand-named furniture, appliances, computers and electronics from brands, such as Ashley Furniture, Sony, Toshiba, Whirlpool Corporation, Dell and HP. As part of their rent-to-own business model, Rent-A-Center generally makes its items available with no down payments or long-term obligations. Customers can return an item at any time, for any reason, without penalty and have the option to re-rent the same item and pick up the payments where they left off. Delivery, pick-up, service and repair are also included in the stated rental price. Customers can also upgrade items while they are renting—the payments will change accordingly.

Project Highlights:

The agile team is responsible for supporting RMS Application and a custom automated store replenishment solution application. The team takes care of all new projects that are coming in based on business needs.

Roles & Responsibilities:

Interact with Business and development teams to better understand the functionality.

Create test scenarios for the stories assigned

Perform functional testing and Integration testing with multiple teams and track defects in ALM 11

Create QA test Reports for production move

Environment and Tools: ORMS 12, SQL, Oracle 11g, ALM 11, Agile craft, Toad, CA Workload Automation

Project 3:

Client: J.C. Penney (Plano, TX)

Domain: E-Commerce and Retail

Role: Software QA Engineer

J.C. Penney Corporation, Inc.is a chain of American mid-range department stores based in Plano, Texas. The company operates 1,060 department stores in 49 U.S. states In more recent years, the chain has continued to follow consumer traffic, echoing the retailing trend of opening some standalone stores, including some next door to competitors. The company has been an Internet retailer since 1998.

Project Highlights:

JC Penney was implementing a complete, open and integrated suite of Oracle Retail solutions to streamline operations and improve the cross-channel customer experience as the company transforms its retail operations. As part of implementation of ORMS 13.2 there were 3 tracks that were going on in parallel. One was the PO, ReSA and the Item.

The RMS Base application, in conjunction with various customized screens and forms was used to set up and maintain items, including conceptual, for stores and eComm. This includes setting up: attributes of an item, item cost and retail price, supplier and ship point/sites for an item, SKUs, UPCs, Seasons, Floor set dates and ticketing information. The item information will be stored in the RMS Oracle database, and once approved, will be used by legacy systems.

Roles & Responsibilities:

Interact with Business and development teams to better understand the functionality.

Preparation of Business Flow diagrams using Visio

Defect management

Performed functional testing and used the defect tracking tool ALM 11 for reporting the defects.

Created weekly defect metrics for management and worked with App Support/BSA/DEV teams to troubleshoot and manage defects and proactively identified risks to management.

Environment and Tools: ORMS 13.2, SQL, JIRA, MS Excel, Oracle 11g, ALM 11, Microsoft Visio, Toad, Informatica 10.1

Tech Mahindra Jan 2013-Jan 2014

Client: Abercrombie & Fitch (New Albany, Ohio)

Domain: E-Commerce/Retail

Role: Software QA Engineer (Project Lead)

Abercrombie & Fitch (A&F) is an American retailer that focuses on casual wear for young consumers. It has over 400 locations in the United States and is expanding internationally.

Project Highlights

Project 1: ORMS QA for OMS

Abercrombie & Fitch was using Oracle Retail Merchandising System (Ver. 13.0.1) to support core merchandizing operations. The existing QA environment was used for Production change requests and other ongoing projects. AnF was implementing a new Order Management System which would require an entire new QA2 environment across all systems. Since the existing test environment was used for all running projects and does not want to have a conflict on OMS Project testing under the same environment.

Project 2: UAE DC

Abercrombie & Fitch was opening a new DC in UAE. The new DC, system and processes will facilitate store expansion and the management of Domestic and International Supply Chain

Processes.

This project enables efficient replenishment and supply chain activity supporting international expansion in Asia.UAE DC and Store replenishment can be done by UAE DC PO or from other international DCs inventory transfer. Merch type restrictions and modifications are given especially to the UAE related skus like Pig Leather,etc. UAE DC is operated by 3PL Aramex, DC transactions will be communicated by 3PL via ESB to RMS system

Project 3: ATLAS Price Execution Automation

ATLAS Price execution automation project is developed to achieve cost savings by reducing the amount of labor hours spent manually exporting data from SWIFT, manually transforming data, and manually imputing data into RMS. This project is implemented to avoid Legal and Compliance Risks by electronically establishing a timestamp acknowledgement of pricing data review. The scope of this project includes integrating pricing data to RMS, manage multiple price sets, ability to automatically end obsolete promos.

Project 4: RMS Automation – Phase 1

RMS Automation project - Every new DC rollout will take considerable amount of time for Supply Chain Transaction process testing. Here comes the importance of Automation project where key scenarios for Supply Chain applications can be automated and thereby reduce the time to market for the new DC rollouts. This project was planned as three Phases where Phase 1 is planned for automating regression scenarios of RMS and in Phase 2 automating SIMS and RDM.

Roles & Responsibilities:

Performed end to end QA activities including requirement analysis, test case preparation and execution, bug reporting and tracking and thereby successfully completed all the projects

Reviewed requirements/specification documents and worked with developers in order to successfully design functional test plans and test cases. Worked with the development teams to determine the appropriate solution for addressing software anomalies or implementing improvements. Actively participated in defect review and root cause analysis sessions.

Extensively used ALM and QC tools for defect management and tracking. Responsible for defining and implementing test strategy and test planning for all assigned projects. Owned test plans and documentation that communicates the standards and procedures of QA teams. Responsible for setup and maintenance of test environments

Prepared test plans, test coverage table, detailed test cases, test estimation and requirement traceability matrix and for the Application under Test (AUT).

Mentored and trained new QA associates on business functionality, QA methodologies and best practices.

Environment and Tools: SQL, ALM, Quality Center, QTP, VB scripting, Oracle 10g/11g, Toad

UST Global Inc. June 2008 - Oct 2011

Project 1:

Client: ADESA US (IN, US/Chennai, India)

Domain: E-Commerce and Retail

Project: Toyota Dealer Direct

Role: Senior Software QA Engineer

Project Description: ADESA provides a simple and efficient way for dealers to return (ground) the leased vehicles and buy the grounded vehicles or it can go for internal and live auction based on the vehicle’s return status. A user can bid or buy the grounded vehicle. The system will send outbid, winner and other mails to the users and other configured mail ids. User and dealer can view different types of reports regarding their activities.

This project includes software quality assurance activities for ADESA US/Canada Retail websites for Nissan, Infinity, Hyundai, Kia, Toyota, Lexus and ADESA.com which includes web and extensive database testing and application support.

Roles & Responsibilities:

Responsible for defining and implementing test strategy and test planning for all assigned projects.

Performed extensive functional, negative, regression, acceptance (UAT), security, browser compatibility and integration testing of all the web sites in QA, Stage and Production.

Worked with development and QA teams in multiple geographic locations and coordinated release and deployment activities. Actively participated in requirement & design review sessions and evaluated requirements & design docs from a quality test standpoint

Prepared the requirement traceability matrix, test coverage table and test estimations.

Interacted with the Development teams and Analyst teams to understand the functionality to test it effectively. As part of the UI testing, recreated the bugs in the test database and helped the development teams to fix the reported issues and take it to closure.

Responsible for all deliverables to meet the standards & guidelines specified by the company. Actively participated in System & Integration test meetings, defect reviews, root cause analysis and test completion meetings.

Performed database testing using SQL in order to ensure the validity and integrity of the application data with respect to the database.

Mentored and trained new QA members on business functionality, QA methodologies and best practices.

Environment: SQL, PL/SQL, QTP 9.2, UNIX, IBM Clear Quest, Oracle 10g/11g, SOAP UI,

Project 2:

Domain: Information Technology and IT services provider

Role: Software QA Engineer

Project Description: This was a SharePoint deployment which made the company organize its data and collaborate between offices spread across 8 countries. The problem in front of the organization was to capture the knowledge residing in their associates' mailboxes. Desktops/laptops, file servers, disparate systems etc, which was making it impossible to retrieve and use the data when required. Once the owner of some crucial data leaves the organization the new employees had a difficult time getting up-to-speed on their teams. And as a result the information was cluttered, inconsistent and undependable. From an IT team's standpoint, information archival in this kind of a situation is near impossible and the company ended up spending a great deal of money on information retention mechanisms. On the other hand the UST Global has presence in over 8 countries, which made it very important to collaborate and share information in a real-time manner. And to resolve all these issues, an intranet portal using SharePoint is deployed.

Roles & Responsibilities:

Worked with development and QA teams in multiple geographic locations and coordinated release and deployment activities.

Interacted with the Development teams and Analyst teams to understand the functionality to test it effectively. As part of the UI testing, recreated the bugs in the test database and helped the development teams to fix the reported issues and take it to closure.

Responsible for all deliverables to meet the standards & guidelines specified by the company. Actively participated in test meetings, defect reviews, root cause analysis and test completion meetings.

Performed database testing using SQL in order to ensure the validity and integrity of the application data with respect to the database.

Environment: SQL, Windows Server 2008, ASP.net, Sharepoint

Project 3

Client: WellPoint (CA, US/ Chennai, India)

Domain: Insurance

Role: QA Intern

Project Description: WellPoint is one of the largest publicly traded health care companies serving the needs of 34 million medical members in US. The project (Enterprise Customer Care Desktop) provides a customer care desktop where the medically insured customers can retrieve their information regarding the benefit details available to them. Technically, Enterprise Customer Care Desktop takes the input in the form of XML and based on the input, it produces the output in the form of XML, retrieving the data from the database, describing the product mentioned in the input. This is related to the Insurance to help the customer care executive to provide the information to customer base on their product id.

Roles & Responsibilities

Responsible for preparation and execution of test cases and actively participated in reviews of functional requirement specification and test cases, system & integration test meetings and test completion meetings. Prepared the traceability matrix and test coverage table.

Performed Functional, smoke, compatibility and regression testing of web applications.

Worked as an individual contributor and responsible for all deliverables to meet the standards & guidelines specified by the company.

Recreated the bugs in the test database and helped the development teams to fix the reported issues and take it to closure.

Environment: Core Java, Oracle 9i (Back end), Java Script, HTML, QC, IBM MQ

Contact this candidate