Test Cases Professional Experience

Maithali Vaidhyanathan Iyer

Phone: 832-***-****

Email: *******.************@*****.***

Software QA Analyst/SQL Analyst

PROFESSIONAL SUMMARY:

●Around 4+ years of professional experience as Software/QA Analyst with 3.5 years of experience in QA and 1 year of experience in data analysis/SQL development.

● Experience in writing, testing and implementation of stored procedures, functions in Database.

● Experience in writing manual test cases using QC, automation test scripts using QTP

● ISTQB certified professional

● Experience in debugging of SQL queries.

● Basic working knowledge of Microstrategy reporting tool

● Basic working knowledge of Selenium.

● Experience in unit and integrated testing.

● Excellent communication, interpersonal, analytical skills and strong ability to perform as an individual or as part of a team.

Skills:

Operating System: Windows NT 4.0, Windows 9x to 2k, XP, UNIX

Languages: SQL (NZSQL), PL/SQL

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

Reporting Tools: Basic knowledge of Microstrategy reports development

Testing Tools: Test Director/Quality Center, Quick Test Professional, Selenium

Scripting: Visual Basic, HTML

Development Tools: Tool for Oracle Application Developer (TOAD 7.1/6.2), SSMS, MS Office, Aginity for Netezza

Education:

Master’s Degree in Mathematics

Professional Experience

Organization

Role

Period

Polaris Software Lab Ltd.

QA Analyst/SQL Developer

Jul 2006 – Nov 2009

Zillion Technologies Ltd

Netezza SQL Developer

Oct 2013 – Jun 2014

Project Details:

Kohls.com

Client: Kohls Corporation Duration: Oct ’13-Jun’14

Role: SQL Analyst

Work Location: Menomonee Falls, WI

Technology: Netezza 7.0, Microstrategy, Informatica, AutoSys, Clear Case, Clear Quest.

Description:

Kohls Corporation is a chain of specialty department store offering quality exclusive and national brand merchandise to the customer in an environment that is convenient, friendly and exciting. This project was aimed at integrating Kohls.com gift registry module for wedding/baby shower, rewards & returns data into Netezza datawarehouse.

Responsibilities

●Analyzing the data from EDW and comparing with the source.

●Writing SQL store procedures to move data from staging to EDW.

●Analyze the tables and their cardinality.

●Document all the procedures and functions involved in the process.

●Unit and integration testing of Target data.

CITI Eclipse - Oscar

Client: Citibank, Japan Duration: Jan ‘09 – Nov’09

Role: QA Analyst

Work Location: Chennai, India

Technology: SQL Server 2005/2008, JIRA, QTP 10.0

Platform: Siebel

Description:

CITI is introducing the New Platform of CRM Application – Migration from Siebel CRM to In-house CITIBANK Product Eclipse (OSCAR – One Stop Customer Activity and Resolution). The objective is to ensure User Acceptance Testing and certification for Eclipse Application.

Responsibilities

Understanding the application functionality for Oscar

Manual Testing of Siebel CRM functionality to come up with automation test scripts for OSCAR

Preparing test scenarios and writing test cases.

Preparing automation test scripts in QTP for each module.

Preparing test data for each module to cover positive and negative test scenarios

Executing automated Test scripts in QTP

Raising defects in QC and tracking defects to Closure

Actively involved in reviews of automated test scripts, maintenance of test scripts as per changes and updates in the application

Contribution to traceability matrix by mapping requirements to test cases.

CITI Japan Mobile Banking

Client: Citibank, Japan Duration: Jul’08 – Dec ‘08

Role: QA Analyst

Work Location: Chennai, India

Technology: Manual Testing, SQL Server 2005, QC

Description:

JFP is a global initiative of Citigroup to upgrade the technology that supports the Mobile banking of Citigroup. The current legacy system (Direct Access) supporting the Mobile banking offering is a Windows-based VB/COM application that will reach its End of Life soon. CBMO (Citibank Mobile) will be migrated from current legacy system (Direct Access) to new platform JFP (Java Financial Platform) in 2008.

Responsibilities

●Understanding the application functionality for Mobile banking application

●Preparing test scenarios and writing test cases.

●Used Quality Center to write Test Plans, Test Cases.

●Executing Test cases and raising Defects in Excel

●Actively involved with Knowledge Management, Walkthrough Sessions and Technical Reviews

●Categorized bugs based on the severity and interacted with developers to resolve them.

●Coordination with technical and project management team for tracking defects to Closure

CITI Prime brokerage

Client: CITI, UK Duration: May’08 – Jul ‘08

Role: QA Tester

Work Location: Chennai, India

Technology: Manual Testing, SQL Server 2005, QC, ClearQuest

Description:

The IPB application which has been in production for more than 6 years provides service to Hedge Funds, settlement activities and client reports. The primary users of this application are Client, Broker, Custodian and Sellers. CITI Group is the main Prime Broker and is also a custodian. CITI Group Prime Brokerage functionalities involve Equities, Fixed Income, Future, and Foreign Exchange.

IPB Repository is interfaced with other systems namely OLYMPIC, SOLAR.SAFE, IOWA, MERVA, OASYS, EQUAL, MATRIX, CAIRO, TAP, SEMANS, RECON.

Matrix is a global stock loan and borrows system for corporates. As a part of nightly position balance operation job, Matrix sends a feed of share and cash position changes in the international borrow and loan system to stock record processing system.

Responsibilities

●Understanding the application functionality for Matrix Application.

●Preparing test scenarios and writing test cases.

●Executing Test cases and Raising Defects in ClearQuest and tracking defects to Closure

●Created Database test cases using SQL queries

●Executed the database test cases to validate the business rules.

LTSB Internet Banking

Client: Lloyds TSB, London Duration: Dec’06 – Apr’08

Role: QA Tester

Work Location: Chennai, India

Technology: Manual Testing(Test Director),Oracle 11g

Platform: Siebel

Description:

Lloyds TSB Internet Banking project involves testing of all online services and future enhancements.Lloyds TSB's Internet banking service is the only one to win a prestigious five star rating from Computeractive. Lloyds TSB Internet Banking (LTSB IB) application receives, filters and forwards customer requests to the LTSB host systems and external systems in order to provide banking services over the Internet. It allows the customer to know the Account details and activity, Make transfer and payments, set up standing orders, overdraft, Direct debits, statements and many more. Also it provides the customer to apply for online loan, Credit cards, Travel money, home insurance, car insurance, pension, mortgages

Responsibilities

Understanding the application functionality

Preparing test scenarios and writing test cases.

Using SQL Queries to compare the results with the expected business rules.

Creating test cases in Test Director and mapping them with business requirements

Executing Test cases and raising Defects in Test Director and tracking defects to Closure

Executing Batch process using TOAD and comparing data in the database

Collecting all project related metrics and sending status reports to Client.

SJP

Client: St Jame’s Place (UK) Duration: Jul ’06 – Nov ‘06

Role: Test Engineer/Trainee

Work Location: Chennai, India

Technology: QTP 8.2, QC, DB2

Description:

The St. James's Place Group is an insurance-based company in UK, which provides various products to the customer. The St. James's Place Group provides wealth management services. The application focused on maintenance of insurance policy details over web for its customers. Testing of this application included functional testing using automation test scripts in QTP 8.2.

Responsibilities

●Preparing automation test scripts.

●Executing automation Test scripts and Raising Defects in QC and tracking defects to Closure

●Data comparison using SQL queries to compare data against UI

●Collecting all project related metrics and sending Status reports to all Stakeholders

Contact this candidate