Test Cases Data

Kulwinder Kaur

Phone: 516-***-****

Email: acrvdz@r.postjobfree.com

Objective:

Seeking for a challenging position as QA Analyst/Tester that enables to contribute to the organization by improving quality of applications and systems where I can utilize strong analytical and testing skills in both Client/Server and Web environment on Windows and UNIX platform.

Summary:

Over 8 years of IT experience in developing Test Strategy comprising Test Plan, Test Scenarios, Scripts, Test Cases, Test Bed, automation testing of various Client/Server and Web applications.

Extensively involved in some phases of Software Development Life Cycle (SDLC).

Experienced in both manual testing and Automated testing.

Experience conducting Testing in traditional waterfall and agile environments.

Experience in collecting information from Business analysts and software developers.

Experienced in using automation testing tools, such as, Quick Test Pro and Quality Center.

Developed and implemented test suites, which includes features like Data Driven, Database Check points, GUI and Text/Bitmap checkpoints, Recovery scenario manager .

Performed web test using Quick Test Pro. For checking Page Content, Broken Links, Web Objects.

Experience in creating Test approach, work plan and designing the test Scenarios, test cases for Performance.

Creating scripts, running tests, Analyzing results in LoadRunner for Performance testing.

Developed Load Runner test scripts according to test specifications/ requirements.

Used Virtual User Generator to generate VuGen Scripts for web.

Developed and deployed test automation scripts to do end to end performance testing using Load Runner.

Develop and implement load and stress tests with Load Runner, and present performance statistics to application teams, and provide recommendations on how and where performance can be improved.

• Performed Data Driven Testing using WinRunner.

• Performed Load/Performance/Stress using Load Runner with Web (HTTP/HTML) protocol.

Used Controller to Perform Load Test, Longevity test and Stress Test.

Involved in setting up automated regression suites.

Experienced in planning, coordinating and performing of various types of testing like Black Box, White Box, Integration, Regression, Performance, Back-end, sanity and UAT.

Extensively worked on Back-end testing and has very good knowledge of writing and executing SQL queries to validate the data integrity.

Worked on all phases of Data Warehouse Development Lifecycle, from gathering requirements to testing, implementation and support.

Responsible for testing and reviewing of ETL mapping and transformation specifications based on the business requirements from various teams and the business teams.

As part of QA team was involved in implementation of ETL best practices.

Good experience in working with onsite-offshore team model projects.

Extensive knowledge in ETL process consisting of data transformation, sourcing, mapping, conversion and loading.

Executed stored procedures by passing parameters.

Experienced loading data into Oracle tables using SQL Loader, and import/export.

Migrated data between Oracle, MS Access, MS SQL Server.

Developed Unix Shell Scripts to split large flat files into different flat files depending on different criteria. Also for data transferring purposes.

Scheduled and executed jobs in Unix.

Designed and developed test cases for automated testing using Quality Center.

Documented test results and Managed Defect Tracking process, which included prioritizing bugs, assigning bugs and verifying ‘bug fixes’ using Test Director, Quality Center.

Maintained Requirement Traceability Matrices to measure the testing process and requirement progress.

Ability to prioritize and work in a team environment and also independently.

Prepared daily status report and completion for the team and management.

Good understanding of fixed income concept.

Strong analytical, problem solving, and flexible to learn new technologies in the IT industry towards company’s success.

TECHNICAL SKILLS:

Operating Systems: Linux, Windows 2000/NT/XP, MS DOS

Languages: UNIX Shell Scripts, VBScript, SQL, PL/SQL, HTML

DBMS: Oracle 10g, SQL Server 7.0, MS Access, SQL Server 2008

Testing Tools: Quick Test Professional

Network/Protocols: TCP/IP, FTP, HTTP

Bug Tracking: Test Director, Quality Center, MS Excel

Software Packages: MS Office 97/2000/2003/2007, ETL

Application Packages: .Net, J2EE, web Services

DB Schenker,NY May 2012 - Present

QA Tester

Worked as a QA Tester on projects called RDS(Rational Data Store) and Data Marts in DB Schenker. Company handles transportation and logistics services. DB Schenker Logistics supports industry and trade in the global exchange of goods: in land transport, worldwide air and ocean freight, contract logistics and supply chain management.

Responsibilities:

Involved in analyzing the business requirements.

Interacted with the Business Analysts and the Developers in various occasions for the proper understanding of the requirements

Involved in all the stages of SDLC during the projects.

Developed and maintain the test scripts to test the data ware house data.

Scheduled and led team meetings in order to review current work or delegate new responsibilities in needed.

Experienced in both manual testing and automated testing.

Generating automation test scripts, running test scripts and analyzing results using QTP.

Developed and reviewed test scripts coded in VB Script for automation test scenarios and Parameterization of test cases using Spread Sheets.

Worked on Automation framework and have good understanding of it.

Creating and using function library.

developed various functions for keyword library and BPC library.

Performing Back end testing with extensive use of SQL Queries and UNIX commands.

Extensively Queried through SQL to check the database records.

Executed and tested various Procedures and Functions.

Created the test data to test the specific requirements.

Validated the data marts data and tested various fact tables, dimension tables and aggregate tables.

Developed, Enhanced, and maintained testing scripts.

Responsible to log all the issues discovered during testing in the Issue Tracker using Quality center, Jira and excel.

Responsible for Maintaining, updating and sending status reports to upper managements.

Responsible for testing and reviewing of ETL mapping and transformation specifications based on the business requirements from various teams and the business teams.

As part of QA team was involved in implementation of ETL best practices.

Extensive knowledge in ETL process consisting of data transformation, sourcing, mapping, conversion and loading

Very good understanding of ETL work flow.

Environment: Windows 7, SQL Server 2008, ETL, UNIX, Oracle10g, Sql navigator 6.5, PL/SQL, MS Excel, Quick Test Pro, Quality Center,Jira.

Celerant Technology Company, NY May 2010 – Mar 2012

QA Tester

POS was developed to offer retail management solution for a client to be deployed on company’s intranet. It allows multi store management and helps them in their analysis of Point of Sales, Inventory control, Purchasing, Vendors, Accounting, and Trend etc. It also allows individual store information to store to a central (corporate) database. This information allows the central office the ability to monitor the activities and needs of each individual store. At the individual store, it gives the ability to locate needed merchandise, or transfer items to other locations. In addition, it gives the manager’s powerful management tools and reporting capabilities to help them keep control of the business.

Responsibilities:

Spearheading the Testing effort by performing requirement analysis for both manual and automated testing.

Prepared Test Plan, Test Scenarios and Test Cases

Developed Test scenarios, Test cases, Test data and test scripts.

Developed and maintained QTP test scripts to support regression testing whenever a Change Request is completed.

Created and implemented Data Driven QTP scripts for functional and regression testing.

Created Exception handlers and user-defined functions in QTP.

Worked on Automation framework. Creating and using function library.

Converted Manual Integration tests into automated tests.

Performing Back end testing with extensive use of SQL Queries and UNIX commands.

Utilized UNIX and SQL to create test data and perform backend validation of GUI based applications.

Written complex SQL queries (Join, Sub-queries).

Used Quality Center to house all test documentation and report/track all issues and defects.

Involved with BA and developers to analyze and debug code for defects resolution.

Documented and reported the progress to the management on an ongoing basis and updated the requirement and defect status as per the current status of the testing project in Quality Center.

Involved in generating various reports for analysis and correct projection of data.

Used Quality Center to manage test scripts, requirements tracking and test case design

Performing Version management for the automated scripts.

Facilitating meetings with the development, project and business users' teams to discuss issues and suggest resolution.

Environment: Windows 2000/XP, SQL Server 2008, UNIX, Oracle, PL/SQL, MS Excel, Quick Test Pro, Quality Center.

Verizon, Albany, NY Aug 2008 – Mar 2010

QA Tester

This is an online application for Customer Accounts. The customers can login to their accounts and can make changes to their service package. They can add or remove certain features from their phone line. Customers can also review and pay their bills online. Payments can be made as one-time payment or an account with automatic deductions from a Credit Card or Checking Account can be setup.

Responsibilities:

Interacted with the Business Analysts and the Developers in various occasions for the proper understanding of the requirements.

Involved in determining test approach and scope for front-end/GUI and back-end testing.

Involved in writing Test plan Test cases.

Used QTP for automated testing for website developed using .Net.

Used descriptive programming in QTP for GUI Testing.

Modified existing QTP scripts to incorporate new features.

Developed and reviewed test scripts coded in VB Script for automation test scenarios and Parameterization of test cases using Spread Sheets.

Performed Back-end testing of database using SQL queries and verified the data integrity.

Executed and tested various Procedures, Functions.

Involved in analyzing the ETL requirements.

Very good understanding of ETL work flow.

Responsible for execution of test cases, recording results in a defect tracking tool, Generated and analyzed standard and customized reports, and documentation in Quality Center.

Extensively used Quality Center to maintain Requirements, Test plans, write Test Cases, Defects and Traceability Matrix.

Environment: Window XP, ASP.Net, Web Services, XML, Quick Test Pro, SQL Server, Quality Center

Information Builders, New York, NY Dec 2006 – Mar 2008

QA Tester

EZ_Biz is a web based Marketing Management Systems. This system maintains customer information, order entry, invoice, and remittance entry. The customer information sub module is used for creating a profile of new customer and updating the profile of an existing customer. The order entry sub module is used for orders they placed, the invoice sub module keep tracks of invoices made and remittance entry sub module is used for remittances they made.

Responsibilities:

Involved in all the stages of SDLC during the projects. Analyzed, designed and tested the new system for performance, efficiency and maintainability

Performing Back end testing with extensive use of SQL Queries and UNIX commands.

Utilized UNIX and SQL to create test data and perform backend validation of GUI based applications.

Developed UNIX shell script, loading, uploading data in various environments using FTP.

Executed UNIX commands extensively on the backend server to verify backend server logs.

Developed shell scripts to automate routine jobs

Developed UNIX shell scripts for the purpose of parsing and processing data files.

Maintained and did trouble shooting for batch processes for overnight operations.

Executed PL/SQL procedures and functions.

Participated in design walkthroughs to determine errors in the requirements, analysis and design phases.

Tested the Production trouble tickets.

Scheduled and led team meetings in order to review current work or delegate new responsibilities in needed.

Environment: Windows XP, UNIX, J2EE, Oracle, Shell Scripts, PL/SQL, Rational Clear Quest

Education: Masters of Arts in Political Science

From: Guru Nanak Dev University in 2002.(India)

Contact this candidate