ETL QA

Annie

Summary

> Over * years of extensive experience in Software Testing as Quality

Assurance/Test Analyst.

> Experience in developing Test plans, defining Test Cases, designing

Test Strategies

> Experience with Data Migration testing and strong SQL skills

> Experience Creating/Executing SQL queries with Strong understanding of

Oracle, SQL Server databases

> Extensive experience in Data Base testing using TOAD and SQL-Developer

for Oracle and Informix. Excellent experience in backend testing on

Oracle and written SQL/PL SQL queries.

> Maintain strict adherence to Organizations guidelines, policies and

procedures.

> Involved in Complete Software Development Lifecycle (SDLC) from

Business Analysis to Design, Development, Testing, Deployment and

Documentation. Excellent Knowledge in Agile,V- Model and Waterfall

methodologies.

> Responsible for preparing test data conditions for both System and

User acceptance testing

> Excellent knowledge and working experience in analyzing requirement,

writing functional test cases, creating test scenarios, executing

tests scripts and analyzing test results.

> Experience in performing different kinds of testing like Functional

Testing, GUI Testing, Backend Testing, Regression Testing, User

Acceptance Testing and Compatibility testing.

> Experienced in working with business analysts, development groups in

analyzing business specifications and in Working with other testers to

resolve technical and end-user issues.

> Good Communication, Interpersonal skills and strong Team player with

proficiency at time management, multitasking, able to meet deadlines

and handle changing priorities

> Proficient in managing multiple projects and maintaining excellent

working relationship with onshore & offshore resources, vendors and

client executives.

Educational Qualification

Bachelor of Electrical & Electronics Engineering - Avinashilingam

University Coimbatore, India

Tools and Technologies

Tools: Quick Test Pro 10.0, HP performance tester

Test Management HP Application lifecycle management(ALM),QC

tools:

Database Tools : SQL Server 2008, Oracle 9i/10g, TOAD for data

analysis

Methodologies: Agile,V-Model,Water fall model

WEB services SOAP UI

testing:

MS office tools MS Office, MS Visio, MS project

Web Technologies XML, VB Script,SQL

Mainframe IBM Mainframes - Attachmate Reflection (JCL and MVS),

CA7 Scheduler

Business Skill Set:

. Project Coordination / Resource allocation / Test Management / Defect

Tracking

. System Integration Testing

Professional Experience

Position: Sr. QA Analyst Client:

Standard Insurance, OR

Project : Claim Intake Systems Team Size: 6

Duration: June 2013 - Dec 2014

Description: Claim intake system is used by intake specialist to get

information from the claim ants to process their claims. This is a web

based application which will facilitate users to send mails with letters to

employers, employees and physicians for confirmation on the claims

submitted. Response from the above can be via email, US mail or fax based

on the response the documents will scanned and indexed using KOFAX and sent

to Filenet.

Responsibilities:

. Reviewed and Analyzed business requirement documents, technical

requirements and functional specification of various functionalities.

. Developed Test Plan and overall Test Strategy for the Application.

. Executed efficient database queries to validate test conditions.

. Developed Test Cases for System and UAT Testing.

. Extensively used SQL queries to check storage and accuracy of data in

database

. Involved in extensive data validation to confirm the data integrity

. Conducted and involved in meetings and walkthroughs with users,

developers and Business Analysts.

. Acting as overall and Primary Point of Contact (POC) for Environment

Team, Development Team, Performance Team, and UAT Users.

. Involved in creation and execution of basic sanity test suite and

Regression test suite and execution plan for the team.

. As a Quality Analyst responsible to plan and prioritize daily and

weekly deliverables and status update to QA Manager and Project manager

and actively participate in team meetings, status meetings and work

progress meetings.

. Experience in Defect Tracking, Report generation and requirement

traceability throughout the test life cycle using ALM.

. Organize status meetings and send the Status Report (Daily, Weekly

etc.) to the Client.

Position: Sr QA Analyst Client:

US Bank, OR

Project: Online Banking System (upgrade) Team

Size: 6

Duration: Oct2010 - June 2013

Description: The online Banking application of Citibank provided the

Account Lists (types of accounts), Account Summary, Account Transactions,

Fund Transfers and alerts. The application also allowed users to submit

account-related queries to the bank including ordering checks, requesting

copies of checks and statements etc.

Responsibilities:

. Understand the testing effort by analyzing the requirements and

architecture of the project.

. Estimate and obtain management support for the time, resources and

budget required to perform the testing.

. Build a testing team of professionals with appropriate skills,

attitudes and motivation.

. Acted as a single source for both Offshore and UAT team to derive test

data conditions.

. Prepared positive and negative test data conditions to validate

different scenarios

. Developed Test Plan and overall Test Strategy for the Application.

. Developed Test Cases and Test Scripts for System and UAT Testing.

. Validated data at each transformation throughout the ETL process.

. Extensively used SQL queries to check storage and accuracy of data in

database table

. Performed basic testing of security features using manual testing

. Conducted manual testing for checking Black Box, Adhoc and Regression

during various phases of the development of the online application.

. Document, implement, monitor, and enforce all processes for testing as

per standards defined by the organization.

. Keep track of the new requirements / change in requirements of the

Project.

. Organize status meetings and send the Status Report (Daily, Weekly

etc.) to the Client.

. Track and prepare the report of testing activities like test testing

results, test case coverage, required resources, defects discovered

and their status, performance baselines etc.

Position: QA Tester Client: Dollar General

Corporation,TN

Project : Assortment Management Team Size: 7

Duration: Oct 2009 - Oct 2010

Description: Assortment Management Excel based tool to create detailed

consumer profiles, enabling assortment customization at the store level. By

managing a rich set of product, store and shelf attributes, with this we

can create targeted assortments that minimize the risk of lost sales. The

solution uses historic data that helps in anticipate the effect of

promotions, retain successful items, eliminate under performing products,

and create new items based on past successes.

Responsibilities:

. Reviewed and Analyzed business requirement documents, technical

requirements and functional specification of various functionalities.

. Conducted and involved in meetings and walkthroughs with users,

developers and Business Analysts to gather information about business

process.

. Validated data at each transformation throughout the ETL process.

. Prepared detailed Test Plans and Test Cases which specify testing

overview and testing approach depending on the Business and Technical

requirements.

. Involved in the test enhancements, issues tracking and issues

resolution fixes in the production environment.

. Performed Functional Testing, Regression Testing, System Testing,

Sanity Testing, Database Testing/Back-end testing, Black-box testing,

UI Testing

. Involved in writing of Complex SQL and PL/SQL queries in DB Tool SQL

Developer.

. Identified defects, bottlenecks, data errors and integration problems

and have done regression testing using to enhance the performance

before application launch.

Position: Sr QA Tester Client: Walmart, AR

Project : Assortment Management Team Size: 7

Duration: May 2008 - Oct 2009

Description: Buyer Morning Report is a static dashboard report generated

every morning, that contains key metrics, such as sales, inventory,

markdown, turns, ROI, etc. (actual, projected and budgeted), and reflects

US Wal-Mart's and its buyers' performance. "BMR - Rewrite" is a rewrite

project for the existing Buyer Morning Report of Wal-Mart US

Responsibilities:

. Reviewed and Analyzed business requirement documents, technical

requirements and functional specification of various functionalities.

. Conducted and involved in meetings and walkthroughs with users,

developers and Business Analysts to gather information about business

process.

. Validated data at each transformation throughout the ETL process.

. Prepared detailed Test Plans and Test Cases which specify testing

overview and testing approach depending on the Business and Technical

requirements.

. Involved in the test enhancements, issues tracking and issues

resolution fixes in the production environment.

. Performed Functional Testing, Regression Testing, System Testing,

Sanity Testing, Database Testing/Back-end testing, Black-box testing,

UI Testing

. Involved in writing of Complex SQL and PL/SQL queries in DB Tool SQL

Developer.

. Identified defects, bottlenecks, data errors and integration problems

and have done regression testing using to enhance the performance

before application launch.

Position: Sr. QA Analyst Client: BSNL,India (Telecom)

Project: Local Number Portability (LNP) Team

Size: 10

Duration: June 2007 - May 2008

Description - Local Number Portability which allows the subscribers to

change local service providers without changing their phone number. Service

Portability, which allows the subscriber to change from one type of service

to another. Geographic Portability, which allows subscribers to move from

one physical location to another without changing their phone numbers.In

addition to retaining their telephone numbers, consumers can also retain

their Advanced Intelligent Network (AIN) services (like caller ID, call

waiting, and alternate billing).

Responsibilities:

. Interacted with Business, System Analysts, Designers and Developers

during all phases of the project life cycle

. Analyzed and Evaluated the Business Requirement Documents,

Functional/System Requirement Documents and Use Cases for the

application, which involved a series of meetings with developers,

Systems Analysts and Business Analysts to verify the testability and

verifiability of the requirements and documented test Plan in Quality

Center

. Preparation of Test plans and Test Strategy based on system requirement

documents and mapping documents.

. Prepared and reviewed Test scripts and Requirement traceability matrix

in Quality Center.

. Prepared and reviewed Test Summary Reports for all the projects.

. Involved in attending and organizing testing and status meetings at

team level and project level on a regular basis.

. Used HP Quality Center and Rational clear quest as test management

tools in defining releases, documenting requirements and test cases and

mapping requirements with test cases, defect reporting and analyzing

test results.

. Performed Component Integration, Regression and End to End testing to

ensure readiness for user acceptance testing.

Contact this candidate