Test Cases Management

KIRAN J

Phone: 647-***-**** Email: ***********@*****.***

Testing Tools: HP Application Lifecycle Management (HP ALM) Suite, HP Quick Test Professional 10(QTP), Quality Center (QC) 10, JIRA, Test Rail, IBM Rational Team Concert, Load Runner 9.0, Selenium Remote Control, Selenium Web Driver, Selenium Grid, SOAP UI

Database Tools: Oracle 10g/8i/9i, DB2, SQL Server 6.5, MS-Access, MySQL, TOAD, SQL Plus

Languages: C++, PL/SQL, JAVA, HTML, XML, Java Script, VB Script

Packages: Microsoft Team Foundation Server, Microsoft Content Management Server, Microsoft Visual Studio 2012, Microsoft SharePoint, MS-Office tools, Windows Debugger, Power Shell, TCP/IP, SOAP UI,

Operating Systems: Mainframes Z-OS (TSO, RUMBA, SUPFI, File Aid and IMS), Linux, Windows XP/Win7/Win8, Windows Server 2008/2012, MAC, Mobile Devices, Android OS and IOS.

Summary:

QA Analyst with more than 6+ years of experience in Testing of software applications in Windows and Linux Environments, using standard Waterfall, and Agile methodologies for both Back-end Database and Front-end GUI testing

Performed testing on Web based, Client Server applications using tools Quick Test Professional, Quality Center, Selenium Web Driver

Have Good experience in the creation and maintenance of Test Plan, Test Strategy, Test Scenarios, Test Cases and Test Scripts

Experience in testing databases and writing SQL statements in Oracle,SQL+, SQL Developer and TOAD

Experience in Black box testing with a complete QA cycle – from testing, defect logging and verification of fixed bugs, and extensive experience in Functional testing, Integration/System testing, Regression testing and User Acceptance testing

Experience in unit, sanity, back-end, front-end, functional, integration, regression, smoke, cross browser, cross platform, black box, exploratory, security, load, performance and stress testing

Identified defects are reported with proper priority, severity and managed defects by generating daily defect status report and participating in the defect triage meetings

Extensive experience in reviewing BRD, SRS and detail design Documents

Experience in creating Automated test suites using Data Driven Framework and Keyword Driven Frameworks

Extensive experience in creation and maintenance of automated test scripts according to the Functional and Business requirements

Experience using query tools for Oracle, DB2 and MS SQL Server to validate reports and troubleshoot data quality issues

Team Player with excellent interpersonal communication skills & technical documentation skills

Education:

Certified Tester – (ISTQB) International Software Testing Qualifications Board

Bachelor of Engineering and Technology (Computers Science) – JNTU University, India

Experience:

Aug 2015 – Nov 2015

HOLT RENFREW, ON

Right Now (Oracle Service Cloud )

QA Analyst

Holt-Renfrew has been developed an Oracle Service Cloud application integrated with web-based system, to support and manage incidents (tickets) in call center.

Incidents can be created as a result of an inbound phone call, Email, the web self-service ask a question page, a chat inquiry, or based on the results of a survey.

Right Now’s incident management functionality includes the capabilities to help Holt Renfrew manage inquiries from customers. Incident management involves the creation and management of incidents and reassignment of incidents across departments, and it may involve the management of tasks associated with these incidents

Technologies: AGILE, COTS, Test Rail, JIRA, JAVA, Microsoft Office, Oracle Cloud Server

Involved in the Right Now project as a QA Analyst and Created detailed End to End Test Cases and Test Scenarios

Documented test cases in Test Rail and configured the required test set properties for test execution

Reviewed and Reported gaps in Functional Design Document (FDD) to the Business Analysts and subject matter experts(SME)

Mapped End to end Test cases to Functional Requirements ensuring Traceability throughout the testing process

Executed end to end test cases by coordinating with all the testing teams

Reported the defects in defect tracking tool JIRA with proper Priority and Severity and providing the detail description about the bug, Screenshot, and the steps to produce the defects in the comments.

After defects are fixed, performed the regression testing and re-testing of all the test cases to ensure the defects are properly addressed if any variance reported back to the development team.

Provided daily test execution and defect status reports to the management in defect status meeting

Dec 2013 – June 2015

Ministry of Transportation, AB

PMA Delivery

QA Analyst

Transportation Infrastructure Management System (TIMS) has been developed a Web-based system, PMA Delivery that provides integrated functionality to support the tracking, planning and delivery of work under the various provincial highway infrastructure programs. TIMS Program Management Application, as a whole, will implement a broad range of automated functionality to cover capabilities currently implemented in various disparate systems, technologies, and data sources. While the PMA Delivery project will be focusing mainly on the replacement of the existing CPMS application followed by Contract Claims System (CCS) Property Tracking System (PTS) into a single system.

Technologies: AGILE, Selenium Web Driver, HP Quality Center, IBM RTC, Microsoft SharePoint, JAVA, Eclipse, Oracle 11g, TOAD 10.6, Microsoft Office, XML, SOAP

Involved in the PMA Delivery project as a QA Analyst and Created detailed Test Cases by incorporating both positive and negative scenarios

Reviewed Requirements, identified gaps and reported to the Business Analysts.

Streamlined the testing process by creating Test case templates and centralized all the testing activities by storing automated test cases, records test execution and results

Automated the web applications testing tasks using Selenium Web driver

Executed Test cases for Sanity, Functional, Integration, End-to-End, Configuration, Cross Platform and User Acceptance testing

Mapped the Test cases to Application Functional Requirements ensuring Traceability throughout the testing process

Developing and executing functional test scenarios and test cases by utilizing user stories contained within Agile Sprints and facilitating test case review sessions with other Agile team member

Reported the defects in IBM Rational Team Concert with proper Priority and Severity and providing the details description about the bug, Screenshot, and the steps to produce the defects in the comments.

After defects are fixed, performed the regression testing and re-testing of all the test cases to ensure the defects are properly addressed if any variance reported back to the development team.

Jan 2013 – Nov 2013

Ministry of Infrastructure & Transportation, AB

TIMS NESS

QA Analyst

Transportation Infrastructure Management System (TIMS) has been developed a Web-based system TIMS NESS (Network Expansion Support System) to assist department staff in managing roadway infrastructure and network expansion needs. NESS application identifies roadway segments and intersections within the highway network that do not meet geometric, utilization and safety thresholds. NESS application determines current and future technical requirements in the roadway engineering and planning process, prior to the programming and construction stage.

Technologies: AGILE, Selenium Web Driver, HP Quality Center, IBM RTC, Microsoft SharePoint, JAVA, Eclipse, Oracle 11g, TOAD 10.6, Microsoft Office, XML, SOAP

Created test plan based on the project documents like project charter, project plan, project scope, business requirements and system requirements

Created test scenarios based on the requirements and use cases and provided for sign off

Documented Requirement Traceability Matrix and linked the requirements to test cases to ensure test coverage

Master Test Plan is viewed as Timeline view of the project along with milestone of the project

Monitoring test progress by constantly assessing the work assignment to each of the resources and re-balance or re-allocate them as required and resolving any delays in achieving the schedule

For the complete project the test metrics are created and published in regular intervals during the all testing phases

Documented test cases in the quality center and configured the required test set properties for test execution

Experience in enhancing automated scripts and manual test cases according to the Functional and Business requirements.

Identified and reported defects in quality center with the respective priority and severity

Used SQL queries to validate data in the database and also created and executed complex SQL queries like joining the tables and also nested queries

Retested new application builds after defect fixes and provided status reports on daily basis to the management

Analyzed, reviewed and tracked defects in quality center by generating customized reports

Jan 2012 – Dec 2012

Serves Credit Union, AB

Banking Portal Application

QA Analyst

Banking Portal Application is used by the internal and external employees of the Serves Credit union bank to access the banking products, services, rates and apply for multiple credit products offered by the bank. The banking portal application is integrated with Vignette content management, which is used for centralizing the entire content that gets published on to the application.

Technologies: AGILE, HP Mercury Quality Center 9.2, HP Mercury Quick Test Professional 9.0, HP Mercury Load Runner 9.0, Vignette Content Management System, Java, VB Script, Oracle 10g, SOAP, XML, Windows NT, MS-Office, Lotus Notes

Involved in the project as a QA Analyst in testing Banking Portal application by creating and executing Test cases for Sanity, Functional, Integration, and End-to-End

Reviewed Requirements and identified gaps and reported to the BA’s

Streamlined the testing process by creating Test Plan template and used Quality Center to centralize all the testing activities

Used Quality Center to manage the complete end to end process of testing and administered the projects from Quality Center from testing perspective

Performed Regression testing after defect fixes by retesting the functionality with Test cases and reported defects in the defects tab with proper priorities and severities

Documented detailed test cases in the test plan tab and mapped the test cases to the requirements to ensure the coverage of testing with the requirements and to ensure the traceability

Used VB-Scripts to created automation Regression suites and executed using Quick Test Professional

Ensured the Data mapping and Data validation by performing Backed End testing on Oracle database by SQL Query tools like SQL Plus.

Participated in the daily defect status and test execution status meetings

Provided Test execution and planning report to the QA Lead and QA Manager

Jan 2011 – Sep 2011

ATB Financials, AB

Online Cash Dispense System

QA Analyst

OCDS is an easy to use web based software application that controls the operation of the Wincor Nixdorf ProCash and Cash Dispensing System. OCDS is software solution for Cash Dispensing units, which can be used in any Banking environment. OCDS deals with the business requirements of using cash dispenser, by providing a secure environment for processing the cash, printing on a journal printer and storing the transaction data in an electronic journal.

Technologies: AGILE, HP Mercury Quality Center 9.2, HP Mercury Quick Test Professional 9.0, HP Mercury Load Runner 9.0, JIRA, Microsoft SharePoint, Java, Java Script, Oracle 10g, SOAP, XML, Windows NT, MS-Office, MS-Excel, MS-Project

Involved in the project as a QA Analyst in testing the OCDS application

Reviewed Requirements and identified gaps and reported to the BA’s

Streamlined the testing process by creating Test Plan template and used Quality Center to centralize all the testing activities

Created Test Plan and Test Case Template In Excel and imported into Quality Center

Created Test Plan, Test Scenarios and Test Cases for OCDS web based application in Quality Center

Mapped the Test cases to Application Functional Requirements ensuring Traceability throughout the testing process

Identified Test data for the Test cases by reviewing Requirements and provided data requirements to the DBA

Executed Test cases for Sanity, Functional, Integration, End-to-End, Installation, Configuration, Cross Platform and User Acceptance testing

Reported the defects in JIRA with proper Priority and Severity

Performed Regression testing after defect fixes by retesting the functionality with Test cases

Ensured the Data mapping and Data validation by performing Backed End testing on Oracle database by SQL Query tools like SQL Plus.

Provided Test execution and planning report to the QA Lead

Apr 2010 – Dec 2010

Future Shop, BC

Oracle CRM System

QA Analyst

Oracle Siebel CRM is an online CRM application used by all the stores in Canada to submit Best Buy and Future Shop customers who are willing to apply for Best Buy and Future Shop store credits. Best Buy and Future Shop FirstCRM send online feeds to HSBC credit decision department for automation approval process. Any rejected application from HSBC will be immediately displayed on the Retail POS systems

Technologies: Quick Test Professional 9.0, Quality Center9.0, HP Application Lifecycle Management (HP ALM), Microsoft Office, Oracle Siebel CRM 7.2, Java Script, XML, SOAP, HTML, DHTML,TCP/IP, Windows NT/XP, IE, Oracle 9i, UNIX.

Analyzed user functional requirements, use cases and detail design documents

Involved in the creation of both master and functional test plans based on business, functional requirements, design, IT architecture and data model documents

Using web inventory management software to remote access the reports for making approvals and decision making.

Used Quality Center to import requirements using Word add-in and imported test cases into the test plan tab using Excel add-in

Administered Quality Center by creating new users, groups, create user defined entity, project list and managed workflows

Created detailed test cases based on test scenarios and test condition by applying both positive and negative approach, equivalence partitioning, fish bone and boundary value analysis

Created test scenarios and test cases in test plan tab of quality center and mapped to the requirements using requirement coverage

Mapped all the test cases into the test lab of quality center for execution purpose

Creating an Automated UI test suites from an existing Manual Tests cases and added UI Controls and Validations

Performed sanity testing using selected critical test cases to verify the stability of the build provided by the developers for testing

Performed functional, system, integration testing by executing all the functional test cases by validating and tracking the results in mercury quality center

Performed cross-browser testing on online application by executing all the test cases on all browsers

Performed smoke testing to identify the stability of the environments by executing few end to end test cases

Performed end to end testing by coordinating with all the testing teams.

Performed retesting and regression testing using quick test professional on new builds after defect fixes

Used quality center as centralized test management and defect tracking tool

Provided test matrices like test planning, test execution and defect status reports to the management

Jan 2009 – Mar 2010

Ministry of Transportation

Data Conversion Migration

ETL Tester

As part of this project initiative all the legacy systems of Ministry are being migrated to web based online system. This project is divided into application and data migration as part of data migration the data from the legacy system will be converted using Informatica Data Warehousing tool and the data will be cleansed and will be loaded into new Oracle database that will be connected to web based applications

Technologies: Quality Center 8.0, Quick Test Professional 8.0, Oracle 8.05, PowerBuilder, Windows XP, Power Center Designer, Workflow Manager, SQL Plus, Windows NT, MS-Office

Worked closely with Test Coordinator and Project manager

Worked closely with the ETL and Development team to understand the conversion process

Performed comparative testing by validating the data from oracle database to the legacy database by comparative inquiry testing

Identified and reported data mapping, data integrity, data corruption issues to the ETL and Development teams

Reported the conversion defect issues in Quality Center with proper priorities and severities

Created test data for all software development phases to test validity of results

Regression testing was performed using QTP upon receiving new builds and updated the Scripts accordingly

Created the SQL queries to test to back-end and functionality testing, to check for data mapping, data correction and Truncation Issues.

Experience in testing XML files and validating the data loaded to staging tables

During the accessibility testing for non-text, content testing the alternative text, symbols and speech by following the Web Content Accessibility Guidelines.

Testing both foreground and background text for people with disabilities.

Used File Aid, TSO to perform data validation checks and provided daily and weekly status to Test Manager

Contact this candidate