Ranjana Kaur

Houston, TX *****

adwa76@r.postjobfree.com

832-***-****

Self-directed software professional with 19+ years of core expertise on automation, manual, database and web-testing using software testing tools, methodologies, strategies, frameworks and techniques. Highly efficient in complex, Agile, Scrum, Iterative, Dynamic, and Waterfall methodologies. Proficient in analyzing and understanding business requirements, use cases, user stories, UML, wireframes, technical spec and design documents.

Worked in different Application Environments include Integration, System, UAT and Regression phase. Expertise experience with test automation and ability to lead the testing process from scratch. Test Automation Expertise through HP Unified Functional Testing (HP Win runner and UFT/QTP) for Creating, Maintaining, and debugging complex and innovative scripts for frameworks such as Data- Driven, Keyword-Driven, and Hybrid Framework.

Developed and maintained custom library, error handling, recovery scenarios, reporting methods and descriptive programming, Repository management, using QTP/UFT for Automation framework. Experience working with complex client/server and web-based applications. Experience developing and executing test cases, and test scripts using Quick Test Professional

(QTP), Selenium Web driver with Java, and Application life cycle management. Proficient in System, Functional, Integration, Regression, Progression, Security, and Production patch testing.

Experience in Bug Tracking, Root Cause Analysis, Defect Analysis and Project Documentation. Deep understanding of Software development Life Cycle (SDLC), Software Testing Life Cycle (STLC), and Bug Life Cycle (BLC).

Proficient in developing test artifacts such as Test Strategies, Test Plan, Test Case, Test Script, Test Data and maintaining the Requirement Traceability Matrix (RTM). Proficient in designing, reviewing and documenting system test plans, defining test procedures and creating test cases on the basis of product releases features, client’s requirements and related technical documents.

Excellent verbal and written communication skills in expressing ideas clearly to individuals and groups including the ability to effectively document procedures, processes and results. Experienced in Design, Develop and generate Reports using Application life cycle management

(ALM) and QC.

Proficient in writing SQL Queries to test database integrity. Understanding of application/system built with Java, .net, Web Service/API, XML, PL/SQL, J2EE, HTML, HTTP, HTTPS.

Strong Technical and Analytical skills. Mentor and Transition new Team members in the project. Team player, quick learner, attention to details and care for product quality. Authorized to work in the US for any employer

Work Experience

SQA Engineer III

GST (T h e F r i e d k i n G r o u p - Houston, TX March 2020 to Present

Responsibilities:

Responsible to evaluate sales and marketing application's current automation tools. Debug and execute test scripts in each release or on demand. I was part of scrum meetings to go over GSM new projects in backlog to identify automation candidates.

I was responsible to improve test automation reporting and execution process from AWS services. Started using and learning AWS cloud services to use it for automation project execution from cloud. Automate, Review, Analyze Business Requirements Documents, Design Documents and communicated with Testing Manager, BAs, PM, Director, and Developer to better understand the documents and clear any confusion.

Design, Develop, and maintained test plans, test scenarios, test strategies, test cases, and test scripts for functional, integration, API from AWS and regression testing. Performing extensive automation testing on every iteration Make decisions to do automation in Java using Selenium with Webdriver and selenium grid, and TestNG/GUI framework

Analyze test results to make sure requirements has been met and existing system requirement still holds. Involved in developing and maintaining scripts and test results Perform Back-end testing and data validation utilizing AWS cloud services like S3, Lamda, Cloud watch etc.

Attended defect triage meetings between development, QA, and product management. Follow up on outstanding defects to determine the impact on maintenance releases of code and created Impact Analysis Reports. Applied Risk-Based Testing concepts to determine business and technical impacts.

Execute Functional and Regression for Sales and Marketing application. Environment: Java, Selenium, Jira, Zypher, AWS Cloud(S3, Lamda, CloudWatch, WorkDoc), SQL Developer, Oracle 11g and HTML

Senior QA Automation Engineer

JPMorgan Chase Bank - Houston, TX

October 2016 to March 2020

Responsibilities:

Automate, Review, Analyze Business Requirements Documents, Design Documents and communicated with Testing Manager, BAs, PM, Director, and Developer to better understand the documents and clear any confusion.

Designed, Developed, and maintained test plans, test scenarios, test strategies, test cases, and test scripts for functional, integration, API and regression testing. Performing extensive automation testing on every iteration Make decisions to do automation in Java or JavaScript using Selenium with Webdriver, Cucumber framework and/or Squish automation tools.

Converted manual test cases from HP ALM/QC into automated test scripts in Selenium using webdriver; Analyzed test results to make sure requirements has been met and existing system requirement still holds.

Involved in developing and maintaining scripts and test results, converted manual component into automation script in ALM.

Thoroughly tested the data synchronization module and verified transactional documents & import export reports.

Performed Back-end testing and data validation utilizing SQL in Oracle database using automated framework to retrieve data from Database using ODBC, Excel Table, XML, and Flat File. Attended defect triage meetings between development, QA, and product management. Followed up on outstanding defects to determine the impact on maintenance releases of code and created Impact Analysis Reports. Applied Risk-Based Testing concepts to determine business and technical impacts.

Executed Functional and Regression for Loan approval application. Environment: Java, JavaScript, Selenium, Squish, ALM, SQL Developer, Oracle 11g and HTML Senior QA Automation Engineer

UMB Bank - Kansas City, MO

October 2013 to August 2016

Responsibilities:

Reviewed, analyzed Business Requirements Documents, Design Documents and communicated with sr. QA lead, BA, PM, Director, and Developer to better understand the documents and clear any confusion. Designed, Developed, and maintained test plans, test scenarios, test strategies, test cases, and test scripts for functional, integration, API and regression testing. Performing extensive automation testing on every iteration Make decisions to do automation in Selenium or UFT automation tools. Converted manual test cases from HP ALM/QC into automated test scripts in HP QTP/UFT using object repository and descriptive; Analyzed test results to make sure requirements has been met and existing system requirement still holds.

Involved in developing and maintaining BPT framework, converted manual component into automation script in Quality Center.

Thoroughly tested the data synchronization module and verified transactional documents & import export reports.

Performed cross-browser and cross-platform testing (XP/IE/FF, Win7/IE/chrome/FF) Developed and maintained function library, recovery scenarios and Test Parameters in HP QC/ALM. Used Built in and User defined Environment variables as Global Variables to share the variable and data across various reusable actions and functions.

Proficient using Fiddler and creating XML scripts for automation web services using HP QTP/UFT. Executed web Test cases using Fiddler, Converted JSON to XML Using VBScript-QTP for Web Services automation Testing.

Developed QTP scripts object repository and description programming, and handled dynamic objects using VB-script and regular expression in QTP.

Performed Back-end testing and data validation utilizing SQL in Oracle database using automated framework to retrieve data from Database using ADO, ODBC, Excel Table, XML, and Flat File. Used ReportEvent Method to report test status, defect, and custom messages in the QTP result summary. Also used Excel to generate Result summary to email to the specific groups after execution is complete for scheduled jobs.

In HP Quality Center (QC) used, Business Components, Test Plan, Test Resources, and Test lab module for Automation and manual Business Process Testing. Wrote Structured Query Language (SQL) statements using Select, Inner Joins, and Outer Joins, Distinct, View and many other statements against Oracle database by SQL Developer. Supports production Environment for Release and hot patch. Executed Smoke, regression and Defect verification for every release and hot patch. Attended daily meeting with inter-team and offshore team for QA updates and Release management. Used SmartBear Complete and TFS for Reporting, tracking and maintaining defect throughout SDLC.

Attended defect triage meetings between development, QA, and product management. Followed up on outstanding defects to determine the impact on maintenance releases of code and created Impact Analysis Reports. Applied Risk-Based Testing concepts to determine business and technical impacts.

Executed smoke and Regression for Functional application. Environment: VB Script, C#, .NET, UFT, ALM, TFS, SQL Server 2008, XML, Linux, Oracle 11g and Microsoft DB.

Senior QA Automation Engineer

University of Kansas - Lawrence, KS

March 2013 to October 2013

Responsibilities:

Perform a major role as a QA Test engineer in Agile environment based on iterative and incremental development from planning to release.

Responsible to do automation using Selenium and Web driver for the Intaglio project Taking part in formal daily face-to-face communication among team members. My team report to each other what they did the previous day, what they intend to do today, and what their roadblocks are to prevent problems from being hidden.

Perform Integration testing for third party software merging with three different part of application Execute and develop new test cases and test plan for Content Builder, Educator Portal, and Test Delivery Engine projects

Login Defect for the executed test cases when required. Do Regression testing for bug fixes Environment: Agile, Windows, JUnit, TestNG, Ubuntu, Selenium\2.0, WebDriver, Oracle, XML, HTML, Rally, PostgreSql

Senior QA Engineer

Overstock.com - Salt Lake City, UT

October 2009 to February 2013

Responsibilities:

Perform a major role as a QA Automation engineer in Agile environment based on iterative and incremental development from planning to release.

Estimate user stories in poker planning process and create QA-tasks from User-Stories and Dev-tasks in Jira.

Taking part in formal daily face-to-face communication among team members. My team report to each other what they did the previous day, what they intend to do today, and what their roadblocks are to prevent problems from being hidden.

Perform Integration testing for third party software merging with overstock.com using manual and automation skills.

Drive and develop new test cases and test plan for Finance Dev(Issue Credit, Return Credit, Eyeballs, Telescope, Fraud Check), Social Media, WinBuyer, Wish List, GoogleAds, MyRecommendations, ClickSee, SiteElements, Fastship, FacebookConnect Recommendations, and Community projects in Test Link based on user stories and other provided documentation in Jira. Execute test cases in eclipse IDE using Web-driver and selenium automation tools based on user stories and provided documentation in Jira and Testlink.

Performed various testing such as functional, security, GUI and database integrity using formulated test cases breadth and deep testing approach. Test sql scripts using automation as well as manual testing skills by connecting to database. Perform Regression, Integration and then Acceptance testing from dev box to test VIP and then verify in production environments. Submit bug in Jira after it is discovered during test case is run manually or through automation. Do regression testing once it is fixed on different servers. Analysis the bug report after automation suit is ran for regression testing.

Help in deploying application from dev environment to test, and then push to stage and production. Do sanity testing in production.

Member of Automation group to improve the web-driver framework for automation scripts. Environment: Agile, Windows, Suse11.0, Selenium, Ubuntu, Oracle, XML, HTML, Jira, Shell scripting Software Test Engineer

LSI Logic Corporation - Wichita, KS

October 2007 to September 2009

Responsibilities:

Performed performance testing for storage software using LAN protocol experience in RAID level 6, 5, 3, 1, 0. Track all issues found during test, collect required details and work with both component vendors and internal development team to affect timely resolutions. Performed performance testing on Unix/Linux and window servers using shell scripting and window batch files.

Drive and develop new test cases. Automate action word and action word scripts for Storage software using Java.

Assist in low level debug of problems found during test and work closely with SW development to ensure that issues are closed in a timely manner.

Design, implement and execute test scenarios to verify the Interoperability of LSI Engenio RAID products with 3rd party components or Applications. Testing focuses on AIX and LoP platforms and includes hardware, firmware, device drivers, utilities and enterprise application software Responsible for defining and documenting System Requirement Specifications/feature requirements and supplementary requirements

Logging and tracking defects and measuring the testing effort and the quality of the software by creating reports in DefectManager

Performed manual testing considering the base line of developed test plan and test cases for Benchmarking group

Interacted with the Automation team to design test cases from the detailed use cases and the use case diagram using TestDirector. Conducted test analysis to isolate test cases that need to be automated and subsequently, automating them using TAS with java interface. Environment: Windows, Java, J2EE, XML, HTML, Quality Center, TAS(Java based automation tool), Shell scripting, Procomm, and Spreadsheet

Automation Test Engineer

Southwest Airlines - Dallas, TX

August 2006 to May 2007

Responsibilities:

As a team member, I was involved in implementation Java client/Server application’s Test scripts based on provided test cases, requirement documents and Use cases documents. Test scripts were done with and without Record/Playback

Automated Regression Test design, application analysis/programming & Sanity Checks. Performed functional, GUI and database integrity using formulated test cases breadth and deep testing approach

I was responsible for organizing and automating regression test projects associated with various application development initiatives. Execute each step of the automation test cycle, which include startup, planning, execution and reporting.

Worked closely with the developers and manual testing team to assemble data for all the test cases to perform data-driven testing

Environment: Mercury Suite (Quality Center, WinRunner 8.0, QTP 8.0) J2EE, JSP, HTML, DHTML,.Net, Oracle, PL/SQL, Microsoft office tools and Windows. QA Engineer

ZixCorp - Dallas, TX

April 2006 to August 2006

Responsibilities:

Involve in developing of Test Plan, writing the Test Scenarios, Test Cases and Test Data for secure email product

Performed System Testing, Validation Testing and Transactions Testing Performed Regression Testing & Sanity Checks

Worked closely with the department of “test-data production” to assemble data for all the test cases to perform data-driven testing

Tracked the test cases to the requirement specifications document Performed various testing such as functional, GUI and database integrity using formulated test cases breadth and deep testing approach

Parameterized test scripts to avoid code redundancy and extending the test coverage Created user loads by virtual user agent's drive through Load Runner Used shell scripting to test STMP e-secured email flow Environment: Mercury Suite (TestDirector 7.0, WinRunner 7.0, QTP 8.0, LoadRunner 7.x) Java, J2EE, HTML, DHTML, .Net, Oracle, PL/SQL, Shell scripting, and Windows. QA Analyst

CCH Incorporated - Wichita, KS

June 2002 to December 2005

Responsibilities:

As a team lncharge over 9 tester in Release and Support department, I was Involved in developing the test plan, test cases, test scripts for testing the entire application based on provided requirement and Use case documents. (Navigation, Integration Functionality, and Security testing) I was responsible for automating regression test cases using WinRunner. I have developed WinRunner and QTP Automation scripts for Global fx, Worksheet view, Forms view, Electronic Filing, and CertiTax Sales and Use products.

Used Defect Manager to track and report system defects and bug fixes. Reported over 1090 issues for Tax software application

Created and executed SQL statements to extract data from tables created in MS Access and verify output data of the report on the browser page.

Wrote Modification Request (MR) for the bugs in the application and helped developers to track the problem and resolve the user requirements

Reported over 2000 bugs and tracked the status of the bugs and assigned severity ratings. Performed regression testing for fixes and closed the defects. I was responsible for Resource allocation, Tactical Planning, getting issues resolved, managing code drop or approve, scheduling meetings with testers and developers, Training and mentoring team members. I was responsible to test Electronic Filing (ELF) application which was directly connected to IRS for tax filing purpose. ELF application was responsible for automatic direct deposit for tax refund. Also tested the Refund Anticipation loan approval application program by IRS for finance purpose with electronic return. ELF application was verifying Credit card information to pay taxes electronically. Developed a VB and MS Access based application to get dates and time for the tax systems used files. Created shell scripts to test Tax software application I was involved in Uses Acceptance Testing, End-to-End testing for worksheet view enhancement. Developed a Work reporting system in ASP for the testers for the Testing Department to inform what our group is doing.

Involved in the End-To-End test and responsible for the Quality Assurance of this application to complete in a record time

Participated in defect review meetings with the team members, provided written status reports of testing projects

Environment: Mercury Test Suit (Test Director 7.2, Winrunner 7.0, QTP 8.0), Window NT/2000/XP, Shell scripting, Oracle, ASP, Visual Basic 6.0, C++, .NET, XML Education

Master's degree in Computer Science

Wichita State University

August 2003 to June 2008

Bachelor's degree in Computer Science

Wichita State University

August 1997 to 2001

Skills

• SQL

• Software quality assurance

• JavaScript

• Java

• Test automation

• Debugging

• XML

• UNIX

• PostgreSQL

• ALMComplete(Smartbear) Protocol: TCP/IP

• Product management

• PL/SQL

• Sales

• Visual Basic

• RESTFUL Client

• Jira

• Asp.Net

• C#

• Shell Scripting

• AWS

• Triage

• ASP

• S3

• Business analysis

• Selenium

• MySQL

• Eclipse

• Microsoft Office

• Suse

• APIs

• TestNG

• Oracle

• .NET

• Linux

• C++

• Microsoft Excel

• Business requirements

• HTML5

• LoadRunner

• Marketing

• C

• JUnit

• FTP

• DHTML

• Project implementation

• Microsoft Access

• Rally

• Ubuntu

• Scripting

• Specflow and Cucumber

Contact this candidate