Test Cases Management

Sharon Rueben

******.*******@*****.***

Work Status: H1B

Mob: +1-980-***-****

Summary:

ETL Test lead/ Tester, QA Test Lead /Tester, Automation Tester

I have a total of 8.5 years IT experience from September 2009 – Till date(Accenture). 7.5 years’ experience in banking domain (Bank of America, PNC) and 1-year experience in Telecom domain (British Telecom)

I have expertise creating/working with Test Strategy/Test Plan, Test Estimation, Test scenarios, Test execution, Defect management(ALM/JIRA) and Test summary reports

I have expertise writing complex SQL queries to test transformations and business rules in ETL mapping document and also worked on Microstrategy reports

I have expertise in identifying automation candidates from regression pack and developing scripts in Selenium WebDriver using testNG framework

I have experience creating automation scripts in QTP

I have expertise in Scrum Agile and waterfall testing methodologies

I have worked and coordinated Functional testing,End to End integration testing, Performance testing and Automation testing in SIT, UAT and PROD environments

I am looking for a full-time employment.

Technical Skills:

Operating System:

Windows NT 4.0, Windows 9x to 2k, XP, UNIX.

Languages:

SQL, VB, Java

Database:

Oracle 9i/8i/8/7.x, SQL Server, Netezza 6, 7.

Reporting Tools:

MicroStrategy reports

Testing Tools:

ALM, Quick Test Professional, Selenium Web Driver.

Query Tools:

Toad for Data point, Toad for Data Analyst, SQL Developer

Defect Tracking Tools:

ALM, JIRA.

Professional Experience:

Accenture – PNC(Pittsburgh) Duration: Aug’17-Till Date

Description:

These are enterprise applications used by PNC bank associates. The Testing center of Excellence is responsible for SIT testing and it involves Functional testing, Automation testing and Performance testing of the enterprise applications

As a TCOE test lead I have analyzed requirements/stories and created Test Strategy, Estimation, test scenarios, test scripts, defect management and test summary report.

Analyzed the regression test suite and identified the candidates for automation based on business priority and return on investment (ROI) analysis.

Created and executed scripts in selenium web driver based on Page Object Model. Worked on Gradle Template and TestNG framework.GIT is used as the central repository to maintain code.

Created and executed SQL queries in SQL Developer as per the mapping documents.

Lead a team of 20 resources and also performed invoice review and purchase orders for the projects worked in my space.

Accenture – Bank of America(Charlotte) Duration: Nov ’15-JUL’17

Description:

This is a Data Warehouse which receives data from various applications and transforms them as per the business rules and logic. This is an authorized data source for the entire thirdparty administration space. ETL testing was carried out in 4 layers (Source stage, Subject area, Stage target, Target) and then the provisioning views which provisioned data to downstream applications.

●Analyzing the requirements by coordinating with line of business and providing Estimation.

●Preparation of Test plan and Test scenarios

●Prepared traceability matrix by mapping requirements to test cases

●Preparation of SQL Queries to test the transformation from source to target

●Testing of business rules for key business elements received from various sources

●Executing the SQL queries in UAT environment and documenting results

●Identify risks and mitigate issues

●Defect management and Metrics preparation and providing reports to stake holders

●Perform integration End to end testing in UAT environment

●Perform ETL testing in production environment

.●

Accenture – Bank of America(Charlotte) Duration: Jul‘15 - Oct’15

Description:

Ariba – This is a spend management system, coined as eRequest portal for Bank of America, provided by a third party vendor

Participated in requirement analysis of BRD and HLD and provided estimation in UAT

Prepared Test plan and Test scenarios for UAT by coordinating with business

Prepared traceability matrix by mapping requirements to test cases

Co-ordinated with offshore team in writing functional test scripts and review

Participated in E2E integration testing and execution of test scripts

Defect management and reporting

Provided suggestions to improve user interface functions

Co-ordinated Production releases for all the applications within my space

Participated in testing in production environment along with line of business

Accenture – Bank of America(Chennai) Duration: Jan‘15 - Jun’15

Description:

Biz Sim – Business simulation is the initiative which was related to dry run of the complete system of all FSR releases, before releasing it in production. This includes job runs, application’s response, network responses, in case if any Solman ticket is raised, we need to raise the defect for the same in ALM and track it till closure and before closing the issue, we need to retest the same in simulation environment. Testing team needs to follow up on the issues during Control room check point calls and provide the current status.

Responsible for raising defects in ALM for the issues raised in defect management tool - SolMan

Coordinate with developers from different components and triaged the issues and closed it.

Provided status of daily FPP file run to onshore

Prepared the FSR dashboard and sent it to different stakeholders

Accenture – Bank of America(Chennai) Duration: Aug‘10 - Dec’14

Role: Test Lead/Tester

Description:

Skire – Unifier is an application which keeps track of the projects and the financial transactions involved in the facilities by different group of users. It lets you track and manage information such as budgets, project or shell members, specifications, requests for information and shared documents.

Tax Applications: The State analytics tool, Analytical reporting tool, Tax information global repository tool provide integrated view of tax information and effectively forecast and manage tax expenses. Tax information global repository is a tool used by the Corporate tax department for gathering, processing and preparation of GL data to utilized in Federal and international Corporate tax filing.

Participated in requirement analysis of CE stories and provided estimation. Worked in AGILE scrum Methodology

Prepared Test scenarios by coordinating with business Analyst

Prepared automation test cases in QTP and executed the same

Prepared traceability matrix by mapping requirements to test cases

Participated in E2E integration testing and execution of test scripts

Defect management and reporting

Provided suggestions to improve user interface functions

Accenture – British Telecom(Chennai) Duration: Aug‘09 - Jul’10

Role: Tester

Description: One View – Based on the feasibility of placing orders (Tech checks), OneView is an application which is used to place different kind of orders like broad band, BT vision, Fiber to premises, Fiber to cabinet, PSTN, home orders etc. It also deals with the billing of different types of customers. Putty is used to check the billing of orders and File Zila is used to generate bills and letters. End to end testing is done.

Worked for BAT(Billing and assurance), FTTP and FTTC teams (Fiber to cabinet and fire to premises) and executed New functionality and regression test cases. Worked under Scrum Agile methodology.

Analyzed, created and reviewed high level/Low level scenarios for CE stories.

Conducted triage calls and involved in defect management and reporting

Supported GO-LIVE and warranty periods.

Education:

Degree

University

Year of Passing

Bachelor of Electrical and Electronics Engineering

Anna University

2009

Contact this candidate