Project Test Cases

Sirisha

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

Phone :- 847-***-****

Career Summary:

. Around 6 years of experience in QA testing,requirement analysis,

software development, design, System Integration testing and (OAT)

Operational Acceptance Testing, implementation and supporting

applications in Ab Initio, UNIX, Tivoli, and Windows environments

. Worked on SIT, UAT,OAT and on ETL tool Ab-Initio (GDE Versions 1.15,

3.0.2) (Co>OP Versions 2.15, 3.0)

. Good experience on creating Test Plans, Test Cases, Test Scripts,Test

Data and raised defects to provide solutions for applications.

. Good experience on HP Quality Center(ALM) and Clear Quest

. executed test plan and test cases and

. Worked on waterfall and Agile methodology.

. Extensive experience in ETL/Data warehouse backend testing

. Good experience on OAT testing and SIT testing and pre-production

activities.

. Good knowledge in creating Test plans,Test cases Test scenarios,Test lab

and Test runs

. Good Knowledge in SQL and Teradata

. Experience in developing SQL queries to validate database tables for

backend database testing

. Worked on manual Ab Initio Testing

. Creating Negative Test cases to validate the robustness of the code

. Good Knowledge in SDLC process(Analysis, Design, Testing, Implementation,

Support)

. Good Knowledge in UNIX scripting

. Worked on HP service Manager Configuration management

. Created Wrapper scripts to execute the Graphs/Psets

. Used Psets for Generic graphs and conditional components

. Good knowledge in Creating graphs using various components like Input,

Output (Table/File), Filter by expression, Rollup, Scan, Sort, Dedup

sort, Reformat and Join in Ab Initio

. Good knowledge in multi file system and partition and De-Partition

components

. Worked on the enhancements of the design without affecting the Existing

Code

. Extensive knowledge and working experience in version controlling and

managing Metadata using Ab Initio EME

. Extensively involved in critical production support project with time

bound SLAs

. Good experience in working in Tivoli work load scheduler on composer and

conman commands

. Knowledge on control M scheduler

. Good Knowledge in Agile Methodology

. Good communication and written skills

Skills:

Platform Sun Sparc, x86, IBM Compatible PC

family

Operating Systems LINUX, UNIX, Solaris 2.6, MS-DOS,

and Windows NT, XP, 2003

Languages C/C++, .Net, SQL

SQL & RDBMS Oracle 9i/11g, Teradata

Tools Ab Initio, TRMC,

Scheduling Tool Tivoli/Control M scheduler

Other UNIX Shell Scripting, Vi, MS

Office, MS Excel, Power Point, MS

Word

Employment History:

Nlb services.

2014 November - Till date

Ab Initio Tester

Project: - Retail banking : National checking

Description: Capital One is of the largest bank in USA. Capital One has

been expanding its retail banking operations with savings and checking

accounts, mainly through acquisitions of other banks. ING Direct's

acquisition is a big move, and customers are concerned that the approach

Capital One has taken with its credit card customers will extend to

customers of the former ING Direct(Capital one 360).

The purpose of this project is Migrating data from ODW oracle to Dataware

House(Teradata). After integrating ING with capital one the data has to

flow through the capital one Data ware house.

Responsibilities:

. Analyzing and understanding the business requirements.

. Involved in source to target mapping discussions to write test caes.

Participating in various data cleansing and data quality exercises.

. Developed various graphs for extracting data and loading into the

database.

. Performed data cleansing and data validation by using various ab initio

functions like is valid, is defined, is error, is null, string trim etc.

. Working with Data stewards to understand the data.

. Involved In SIT and UAT testing process.

. Developed Test plans, test scripts and executed test scripts with respect

to source and target database tables..

. Involved in designing and preparing Test scenarios, Test plans, Test

cases and Test data.

. Throughout the project conducted system testing, integration testing,

unit testing, functional testing and negative testing.

. Used Application lifecycle Management for Test Plans, Test Lab and Test

run to prepare test cases and execute test cases.

. Developed SQl queries for querying data against different databases for

data verification process.

. Working in Agile methodology

. Performing the Dependency Analysis using web eme.

. Monitoring and Understanding the schedules in Control-M

Environment: Ab Initio GDE 3.1.3, Co>operating system 3.1.5, Teradata,

UNIX, Oracle, Shell Scripts.

L&T Infotech - Barclays - Mumbai, IN

2011 to 2013

Ab Initio Tester

Project: - BIS CHANGE Project

Description: Barclays is a major global financial service provider engaged

in retail banking, credit cards, corporate and investment banking and

wealth management with an extensive international presence in Europe, the

Americas, Africa and Asia.

As part of the BIS change Team we have to perform the operational

acceptance testing for every project, support the 3 production executions

and all Ab Initio code migration from one environment to another

environment. In Barclays OAT is mandatory for every project as production

entry criteria. Objective of the testing is to run the code in the

production similar environment through Tivoli scheduler and will test the

dependencies, job status and validates does the Ab Initio code designed as

per Barclays standards.

Responsibilities:

. All the code Migrations from Development to SIT, UAT, OAT and Production

and checkout of the project in SIT, UAT, OAT and production

. Understanding the high level scope of the project

. Preparing the test case document and plan

. Validating Schedule/job sheets and Production support Guide

. Tivoli changes in OAT and Production like creating new schedules,

updating existing Schedules and jobs

. Executing Ab Initio jobs through scheduler in OAT Environment

. Performing negative testing on Ab Initio jobs like whether the graph is

failing if the file is corrupted or date is not available in lookup file

etc.

. Performance testing by using large files

. Tests whether housekeeping covering all the files, log files, temp files

etc. As per the retention period

. Validating the database parameters and performance of the database load

. Validating the implementation of collect statistics

. Ensure all the projects are following best practices of Barclays

Standards

. Raising the defects towards development team and tracking the same to

resolution

Environment: Ab Initio GDE, Ab Initio BRE, Co>operating system, IBM AIX

5.2, Tivoli and Teradata, MS Office, Shell Scripts.

L&T Infotech - Barclays - Mumbai, IN

2009 to 2011

Ab Initio Tester

Project:- Barclays WEDW

Description: This Data Warehouse will provide management metrics (financial

and non-financial) and will be the source for all the information systems

of each entity.

The main objective of this project is to define the Key Performance

Indicators (KPI's) for the 'Daily Sales' phase. The KPI's are a collection

of calculations, which are used to evaluate business success. These

calculations are a combination of expressions and calculated elements.

There are 12 KPI indicators which can be used to evaluate the company

performance like new accounts, lost accounts, account attrition etc.

Responsibilities:

. Involved in gathering requirements and analysis for applications.

. Understanding all the graphs and scheduling of the project

. Validated the data movement and transformations are done correctly as per

business requirement.

. Enhancements of the graphs as per the business requirement

. Used Partition and de partition components and perform testing on multi

file system

. Enhancements of existing graphs to implement new requirements.

. Support for solution of the bugs and change request raised by onsite

. Used conman and composer scheduling commands to test scheduling

definitions and scheduling status

. Used Web Eme to see the Graph status and Latest Tags.

. Used Oracle Sql to test whether the data has loaded properly or not.

. Prepared status summary reports with details of executed, passed and

failed test cases.

. Tracked the defects using ALM(Application Lifecycle Management) and

generated defect summary reports

Environment: IBM AIX 5.2, Oracle, Ab Initio, Tivoli.

Educational Qualification:

MCA from Jawaharlal Nehru Technological University in 2007

Contact this candidate