Test Cases Project

Name: Mamata Singh

Phone: 1-630-***-****

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

Professional Summary

Over 8 + years of experience in Software Quality Assurance, Quality Control and actively involved in analysis, design and testing of Client/Server, Web-based, SOA Applications. Exposed to all stages of Software Development Life Cycle with thorough understanding of the Software Testing process.

Experienced in testing with Banking, Financial, HealthCare, and Airlines applications.

Extensive Experience in testing SOAP and Rest web services in SOAP UI and automating it using Groovy scripting steps in keyword driven framework.

Performed Test Automation by covering various requirements including field level, business capability testing and Service Virtualization of business systems behavior using SOA testing tools such as CA LISA

Experienced on SOAP over HTTP/HTTPS, XML over MQ and Database Virtualization using CA LISA tool

Experienced on QA management Tool HP QC, HP ALM, JIRA, maintained the test automated scripts in TFS and Service Automation/continuous integration testing using Team City

Extensive experience working on Web based client application testing using Selenium API’s (IDE, Web Driver)

Experience in working on TestNG, Hybrid and keyword driven framework.

Testing, debugging, diagnosing and correcting errors and faults in an applications programming language within established testing protocols, guidelines and quality standards to ensure programs and applications perform to specification

Collaborate with project teams to strategize & align solution for test automation including roadmap, tools, framework & approach

Experienced in data base concepts and used SQL server management studio 2005/2008 and oracle SQL developer for testing.

Experienced in different SDLC methodologies like Agile/Scrum, Waterfall and V Model

Designed and built Test Plans, Test Cases, developed & maintained Test Scripts, coordinated with team members in debugging effort and assisted developers in Root Cause Analysis and clarified them the results.

Experience in QA Methodologies, testing techniques and test scenarios from the requirements to create test scripts/cases.

Strong QA Automation Programming, database skills, Object Oriented Programming and development knowledge.

Expertise in Good Problem solving, Client Interaction, Training, Team building skills and solid team leading capabilities.

Excellent Team Member with good Communication and Interpersonal skills.

Technical Skills

Testing Tools CA Lisa 6.0, Soap UI 5.2, Selenium IDE 2.6.0, Selenium WebDriver,

Test management Tool HP Quality Center, HP ALM, JIRA

Programming Core Java, Groovy Script, SQL query and Unix Query

Automation Frameworks TestNG, Hybrid, Keyword and data driven framework

Source Control Team Foundation Server, TortoiseSVN, GIT

RDBMS/DBMS MS SQL server (2005/2008) and oracle SQL developer

OPERATING SYSTEMS Windows(10,7, XP, Vista),MS-DOS, UNIX

Other Tools Rally, Team City, Jenkins

Project Details

Cyber Korp Inc - Chicago, IL Nov 2016 to till date

Roles: Senior QA Analyst

Client: Alert Ops

AlertOps is web based application which provides features for On-call scheduling, escalations and integrations with other tools. It provides single platform to receive all On-call scheduling alerts, Standardize the alert message content, monitoring integrations which support auto open and auto close feature- so when monitoring system detects that the problem is fixed and sends the OK, AlertOps automatically closes the alert.

Roles and Responsibilities:

Involved in analyzing Business requirement documents, development of Test Plans, Test Cases, Test Scripts, by referring product specification and technical documents

Working on scripts to create/update existing Page Objects, Flows present in selenium webdriver

Working on automation framework components like excelUtils, database connection

Using TestNg framework model preparing the execution flow with xml file

To locate the element in web application page using Selenium IDE add-on for record and play

Execution of selenium scripts with multiple browsers like firefox, chrome, IE by using properties file

Executing the automation scripts for smoke, functional and regression testing

Verifying the data upload and mapping in oracle database

Defect tracking and generation of reports

Assisted developers in remediation of issues found in testing by analyzing various bug-tracking techniques and root cause analysis.

Environment: Selenium Webdriver, Selenium IDE, Xpath Checker, FireBug, Eclipse, JDK 1.7, JIRA, Oracle 11g,

Sabre Travel Technologies - Dallas, TX Feb 2015 to Feb 2016

Roles: Test Lead, QA of persistent team

Sabre’s Airline Solutions business offers a broad range of software and data solutions to help airlines market themselves, sell products, customers and operate more efficiently. It is a global distribution system which provides full suite for enterprise operations solutions like airline reservations systems, Ticketing, Airport-check-in for around 225 airlines. I Worked on various project of Airport Team: Check-in functionality of Airline Domain like Baggage check-in restriction for AB airlines, implementing check-in web services for AM airlines and AB240 migration from legacy system to new tomcat server.

Roles and Responsibilities:

Create and review Test plans, Test cases from the Functional Specifications and User Requirements documents.

Involved in executing, monitoring and reporting the monthly regressing testing performed by QA team using FitNesse Automation script for check-in services

Extensive experience of creating test scripts in Soap UI for various web services and automating it using Groovy scripts.

By following web services schema’s came up with multiple business scenarios which leads to changes in the schema level for check-in, getpassenger, IssueBagTag, updatepassengerdetails services.

Worked closely with the Product owner and created E2E test scenarios and test data and executed in the client application like Interact during end to end testing for AB,EY airlines

Web services testing on Service Oriented Architecture (SOA) enabled environment and execution of test scripts using SOAPUI tool.

Tested REST API Service testing using SOAPUI Groovy framework.

Created a keyword driven framework by utilizing existing automation framework for open system team which was used by all QA’s in the airport team

Worked as coordinator Project QA Lead for E2E testing performed by all QA’s across geo in Sabre for respective project

Identified the defects and communicated with the developers using JIRA.

Being a QA of persistent team given demo to product owner on behalf of whole team after every sprint using automation script

Worked as active QA Lead for automation upgradation done in the airport team.

Generated test execution/defects reports from Quality Center and participated in weekly/daily test execution status review meetings.

Environment: SOAP UI 5.2, HP ALM 11, JIRA, TortoiseSVN, WSDL, REST, Jenkins

HCL TECHNLOGY PVT LTD Feb 2010 to Jan 2015

Project 1: Feb 2014 – Jan 20145

Client: Commonwealth Bank of Australia (CBA) - Australia

Project: PD Tools

Role: Test Lead

PD tools involves service integration between the Comsee and FACT Details application. Comsee application used for loan lending in CBA account which has multiple screen CCL, risk profile screen which is used for customer assessment rating for loan lending. This Project involves testing of web services using Lisa tools. It consist of two web services, one web service with one operation and one request assessment with 3 operation (create, retrieve, search)

Roles and Responsibilities:

Involved in analyzing Business requirement documents, development of Test Plans, Test Cases, Test Scripts, and executing/reviewing them by referring Mapping, Functional and Technical documents

Provided estimates for the PD tools project based on the complexity of the services involved.

Creation of LISA test script for web service using Soap message and http/https transport Protocols.

Worked on Virtualization/ Stubbing of FACT end system using FACT WSDL in CA LISA tool and deployed it proxy server for testing

Automation Testing using Team City which inter configured with TFS where we place CI and SIT Test Scripts.

Tracked defects, recorded, reviewed, analyzed and assisted development team fix bugs. Also, generated required weekly defect reports

Support, co-ordination and responsibility of the testing activities which includes review of test

cases and test conditions done by the team member

Assessed the testing progress by conducting walkthroughs with QA and development team

Status Reporting (Daily/Weekly status report, Test Summary Report and Productivity sheet).

Test management and updating results in Quality Centre.

Assisted developers in remediation of issues found in testing by analyzing various bug-tracking techniques and root cause analysis.

Environment: HP QC 10, CA LISA 6.0.9, SOAP UI 5.2.0, IBM IDD, EP, WSDL, SOAP over HTTP web Services, TFS, Team City, Windows 2008 Server

Project 2: Feb 2014 – Apr 2014

Client: Commonwealth Bank of Australia (CBA) - Australia

Project: FALCON IMPLEMENTATION

Role: Test Lead

In order to meet its vision and strategic priorities, the Bank has embarked on a project to replace the Global Trader (GT) and Midas systems with new fully integrated front to back system .This project will deliver a new front to back, multi-currency, multi-entity system for the Bank’s foreign exchange and money market operations. The Bank needs a core system that is tightly integrated with sales channels and pricing as a key part of achieving its overall FX/MM strategy together with payment and accounting systems The core deliverable for this project is the migration of the FX/MM products off the current GT/Midas hosts onto a new single global front to back office system. At the core of the solution is delivery of a new product system from Wall Street Systems (WSS), called WSS FX. This program will deliver an Enterprise Platform (EP) for enterprise services and business process support. BSIP platform is part of the Wealth Management and IB&M business services strategy. It provides a set of capabilities for integration based on the Tibco Active Matrix product, and is also available for FALCON to leverage. BSIP is a functional component of the Enterprise platform. Any services build with BSIP will align with the broader EP goals, including data models, platform governance and SDLC..

Roles and Responsibilities:

Identifying & preparing test conditions & test cases by referring Mapping, Functional and Technical documents for various Adapters.

Writing test scripts using iTKO LISA tool covering various scenarios based on Test cases prepared

Virtualizing end-system transactions by recording traffic (of various communication channels such as SOAP over JMS on MQ and SOAP over HTTP etc.) to and from the target interface using LISA Workstation

Writing test scripts using iTKO LISA tool covering various scenarios based on Test cases prepared

Executed iTKO LISA scripts in both test and pre-production environment and provided LISA reports

Worked on testdata files using Excel, JSON, XML and database object files.

Documented progress, defects, and performance reports on a weekly basis.

Attended periodical meetings with Developers, Project Managers, and Testers for implementing new approaches, code reviews, and techniques.

Environment: HP QC 10, LISA 6.0.9, SOAP UI, Oracle, BSIP, IBM MQ, TIBCO EMS,

Project 3: Mar 2013 – Aug 2013

Client: Commonwealth Bank of Australia (CBA) - Australia

Project: GI ROADS IMPLEMENTATION SERVICES

Role: Senior Test Engineer

The primary business goal is to in source the processing of car claims. Processing E2E Car Claims from First Notice of Loss through to recovery and salvage • Responsible for lodging the claim and ensuring the details are accurately captured in the appropriate systems. • Responsible for handling all inquiries relating to the claim, processing outstanding invoices etc.

Roles and Responsibilities:

Identifying & preparing test conditions & test cases by referring Mapping, Functional and Technical documents for various Adapters

Writing test scripts using iTKO LISA tool covering various scenarios based on Test cases prepared

Virtualizing end-system transactions by recording traffic (of various communication channels such as SOAP over JMS on MQ and SOAP over HTTP etc.) to and from the target interface using LISA Workstation

Writing test scripts using iTKO LISA tool covering various scenarios based on Test cases prepared

Executed iTKO LISA scripts in both test and pre-production environment and provided LISA reports

Documented progress, defects, and performance reports on a weekly basis.

Identified the defects and communicated with the developers using QC.

Attended weekly meetings showing progress and future testing efforts to the project manager.

Environment: HP QC, CA LISA 6.0.9, SOAP UI, BSIP, IBM MQ, TIBCO EMS

Project 4: June 2011 – Feb 2013

Client: McAfee- Santa Clara, CA

Project Name: BPM POST

Role: Senior Test Engineer

POST BPM-Application Client enterprise web application which is the replacement of the old OPA system and Details this is a new, unified, flexible, and scalable platform based on the Oracle BPM product. This system will provide support for validating and processing orders into SAP. Order entry methods for the new system include:

1) XML orders – Order received by Oracle Fusion from distribution partners and loaded in Oracle db by using XML order agent after validating the business rule

2) Excel spreadsheet orders – Order received by email and loaded in Oracle DB by using Excel Load Agent.

3) Manually entered orders – These are orders that will be entered by an OE rep and directly loaded in Database.

Roles and Responsibilities:

Responsible for manual, integration and automation testing on POST client web application

Developed automation Page Objects, Flows, automation script class for Selenium Webdriver TestNG Framework.

Involved in identification and design of automation framework components like excelUtils, database connection, Json Utils, Element Actions, Broswer Utils and Automation configurations

Prepared Test scripts based on TestNG Annotations and managed the execution flow with testng xml.

To locate the element in web application page used Selenium IDE add-on for record and play

Execution of selenium scripts with multiple browsers like firefox, chrome, IE

Executing the automation scripts for smoke, functional and regression and managing the execution phases.

Wrote complex SQL query to analyze the data in the database and SQL server agent for uploading a data from MS sql server to SAP system.

Actively involved in pre & post Go-Live testing, End to End Testing performed by UAT team

Status Reporting (Daily/Weekly status report, Test Summary Report).

Assisted developers in remediation of issues found in testing by analyzing various bug-tracking techniques and root cause analysis.

Environment: Selenium Webdriver, Selenium IDE, Xpath Checker, FireBug, Eclipse, HP QC 10, SQL Server (2005,2008),SAP, Siebel, MS Biztalk SQL Adapter

Project 5: March 2010 – June 2011

Client: McAfee- Santa Clara, CA

Project Name: Trillium Cleansing

Role: Test Engineer

Trillium Software is a global leader in Enterprise Data Quality. We help our customers find and implement data quality improvements that translate intoIT and business cost savings, business process improvements and rapid return on investment for new systems.

The Trillium Software System modules work together to profile, cleanse, standardize, link, enrich and monitor global customer and business information in batch or real time.

Roles and Responsibilities:

Responsible for writing Test Scenario, Test case document and preparing the test data as well the Status report.

Involved in extracting data for customer from database for specific country in order to apply the trillium cleansing rule in the UNIX server

Executing the set of UNIX query for performing the data cleansing in UNIX server.

Running PL/SQL stored procedure for uploading the data from excel file to SQL database

Performed Integration testing to verify the cleanse data upload in the MS SQLserver databse and from there to SAP and Seibel system through biztalk sql adapter

Worked with teams located across geographies and multiple time-zones.

Mentor junior developers and provide help for Team member on their Technical issue.

Involve in pre & post Go-Live testing, End to End Testing.

Supported Stake holders/end user while UAT testing.

Environment: Trillium Software, Putty, WINSP, UNIX, SQL Server (2005,2008),SAP, Siebel, MS Biztalk SQL Adapter

COGNIZANT TECHNLOGY SOLUTION Nov 2007 to Feb 2010

Project: EMDEON-Nashville, TN

Role: Functional Tester

The major functionality of the Denali system is to receive the reports from the payers in the formats as they come in and then translate into standard xml formats. Then the xml’s are matched with the original reports to verify that all the fields are mapped correctly. Then the claims and the corresponding reports are FTPed to the UNIX box where the matching between the claims and reports are done and the CU files are generated. Some basic of kind of validations are done in the CU files and then they are loaded in a database which is used by the Reports Repository system. Whenever a payer changes his report format, some alterations or fixes must be done in the Report parser system.

Roles and Responsibilities:

Understanding of the Use cases and Business Requirements

Designing and Execution of test cases for specific functionalities

Converting the report format through shell script in UNIX servers

Performing Functional, Sanity testing and Regression Testing

Verifying the data in Oracle database using TOAD

Defect tracking and generation of reports

Involved in peer reviews

Environment: Secure FX, Secure CRT, TOAD, SQL Management studio 2008,Quality Center, UNIX

Education and Certification

Master in Science from Pondicherry University, India-2007

ISTQB Foundation Level – International Testing Qualification Board

Contact this candidate