Data Test Cases

Vamshi P Email :

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

Phone : *10-734-

2488

Professional Summary:

. Over 7+ years of IT experience in Software testing as an Quality

Assurance, Analysis/Design, Testing, development, and implementation

of test plans, test cases and test procedures in web based

(internet/intranet).

. Highly skilled in ETL testing with Datastage, UNIX Shell Scripts,

Teradata, Oracle, SQL, PL/SQL, SQL*Loader, SQL Server.

. Enormous technical and functional expertise in Data modeling using

Dimensional Data modeling, Star Join Schema/Snowflake modeling, FACT &

Dimensions tables, Physical & logical data modeling and OLTP systems

. Superiorly well versed in the art of oral communication in

coordinating technical issues between Testers and Developers.

. Diversified experience in Manual and Automated testing; extensively

used automated Testing Tools such as Mercury Interactive Test suite in

both Windows and UNIX environment (Win Runner, QTP and Test Director).

. Expertise in QA process and different levels of testing like unit,

Functional, Regression, and Integration testing with business

scenarios.

. Proficient at performing data analysis and Excellent understanding of

data management

. Excellent understanding of SDLC. In depth knowledge of one or more

development methodologies.

. Experience with implementing and operating software control

management, automated build management and automated testing

. Experience with Agile Methodology.

. Expertise in creating Test Plan documents and developing test strategy

documents and preparing the Traceability Matrices.

. Extensively used the Load runner to develop the performance test

scripts to meet the performance testing requirements.

. Experience in all phases of life cycle, including requirements

gathering, risk analysis, project planning, scheduling, testing,

defect tracking, management, and reporting.

. Expert in Mercury Test tools (QTP) Quick Test Pro, Test Director,

Quality Center, Win Runner.

. Creation of test data and Automation of test cases for system and

analyzing bug tracking reports

. Very strong knowledge of RDBMS and Data Warehousing Design Concepts

. Involved in Sprint Planning meetings, Requirement Review meetings,

weekly Bug tracking meetings, Status meetings

. Worked on complex SQL queries for data validations and data

verification for both ETL and BI testing.

Skills Summary

Toolsets: Datastage 8.0.1,Informatica 8.6.1/8.1, SQL DTS,

Telelogic Synergy, Mercury Test Director

Database: Oracle 8i/9i/10g, SQL Server 7.0/2000/2005, Teradata

6x/5x, MS Access

Tools/Utilities: TOAD, SQL* Plus, MS Visio, Teradata SQL Assistant, Erwin,

VSS, Autosys, Control-M

Languages: SQL, T-SQL, PL/SQL, Visual Basic 6.0, VBA, Excel,

Access, C/C++, XML, XSLT, XSD

Platforms: Windows, IBM AIX, HP-UX, Linux

BI Tools: Business Objects 6.5/XIR2, Cognos 7.3/8.0 Series, SQL

Reporting Services, Crystal Reports

Bank Of America, Charlotte, NC

Aug' 13 - Till Date

Data Warehouse Tester

This project is about enhancing an existing Data Mart; user requested

enhancements, bug fixes, historical reload of data to perform testing,

automate Data Quality issues and Data Validations.

Roles & Responsibilities:

. Responsible for Business analysis and requirements gathering.

. Responsible for coordinating testing throughout both systems ODS and EDW

which were two different teams.

. Performed complex defect reports in various environments like UAT, SIT,

and QA etc to ensure the proper delivery of the application into the

production environment.

. Developed data quality test plans and manually executed ETL and BI test

cases and RTM's.

. Involved in writing the Test cases and Test scripts based on Source to

Target Mapping documents and Data Model diagrams. Developed Traceability

Matrix.

. Prepared testing strategy, testing schedule, test Cases depending upon

the Requirement documents for integration and system testing.

. Coordinated with the Developers regarding the Defects raised and Retested

them against the application.

. Wrote SQL queries for each Test case and executed in SQL Plus to validate

the data between Enterprise Data Warehousing and Data Mart Staging

Tables. Strong usage of Mercury Quality center management tool for a

centralized control over entire project.

. Performed Functional, Screen flow and Work flow test scripts as per the

user requirements.

. Developed data integration scripts and resolved data related issues

during initial loads from different sources.

. Worked with DataStage Director for monitoring performance statistics of

each stage.

. Developed Excel models and templates to verify results and performed

extensive data analysis and reconciliation.

Environment : IBM Websphere DataStage 8.0.1, Erwin, SQL, PL/SQL, DB2, XML

files, DOM, Oracle 11g/10g, TOAD, Windows XP Professional, DB2, Teradata V2

R5, Business Objects UNIX Shell Scripting.

BlueCross and Blue Shield of NE, Omaha, NE

Aug '11 - Jul'13

ETL Test Engineer

Roles & Responsibilities:

. Written complex SQL queries to validate the data against the target based

on ETL mapping specifications.

. Tested complex mappings and SCD type-I, Type-II and Type III mappings in

Informatica to load the data from various sources using different

transformations like Source Qualifier, Lookup (connected and

unconnected), Expression, Aggregate, Update Strategy, Sequence Generator,

Joiner, Filter, Rank and Router and SQL transformations. Created complex

mapplets for reusable purposes.

. Performed backend testing in Oracle /SQL Server My SQL database and

analyzed the log files for different error codes for ETL processing.

. Wrote many SQL/PL-SQL scripts to verify data in the DB and verify

consistency with Web Portal BI reports.

. Extensively coordinated with the Engineering team/Product team/QA team to

discuss challenging issues/bugs/features faced while testing the product.

. Responsible for developing test plans, testing strategy, test cases and

execution of the complete test cycle for the backend for ETL and BI

needs.

. Wrote many SQL/PLSQL scripts to verify data in the DB and verify

consistency with ETL mapping

. Interacting with developers and trying to track/verify bugs in the

corporate Bug database and ensure smooth progress and completion of the

QA cycle

. Involved in testing universes and reports for correct mapping of the

objects and data correctness.

. Experience in documenting Functional, Technical Specifications and Test

Cases.

. Wrote SQL Statements to extract Data from Tables and to verify the output

Data of the reports

Environment: Informatica PowerCenter 8.6.1, Informatica Power Exchange,

Oracle 10g, MS SQL Server 2005, Oracle, windows, Mainframe, HP Quality

Center 10.0, Rational Clear Quest, XML Files, XSD, XML Spy 2011, Business

Objects XIR3

T-Mobile, Seattle, WA

Feb'10- Jul '11

QA Analyst

Responsibilities:

. Involved in creating source target mappings based on the Technical Design

requirements.

. Involved in Business analysis and requirements gathering.

. Assisted in creating fact and dimension table implementation in Star

Schema model based on requirements.

. Tracked defects through Quality Center and Clear Quest.

. Develop ETL test plans based on test strategy. Created and executed test

cases and test scripts based on test strategy and test plans based on ETL

Mapping document.

. Tested design strategy of the Extract, Transform and Load for various ODW

tables.

. Tested mappings with the Design Documents and also performed testing for

various sample data.

. Created test suites for functional and regression testing using QTP.

. Worked with all Teradata load utilities.

. Use Quality Center for all test phases as a repository, test management,

test execution, and test reporting activities

. Preparation of technical specifications and Source to Target mappings.

. Extensively used SQL programming in backend and front-end functions,

procedures, packages to implement business rules and security

. Experienced using query tools for Oracle to validate reports and

troubleshoot data quality issues.

. Solid testing experience in working with SQL Stored Procedures, triggers,

views and worked with performance tuning of complex SQL queries.

. Developed scripts, utilities, simulators, data sets and other

programmatic test tools as required executing test plans.

. Effectively communicate testing activities and findings in oral and

written formats.

. Extensively used Informatica power center for extraction, transformation

and loading process.

. Worked with ETL group for understating mappings for dimensions and facts.

. Extracted data from various sources like Oracle, flat files and SQL

Server.

. Designed and developed UNIX shell scripts as part of the ETL process,

automate the process of loading, pulling the data.

. Validated cube and query data from the reporting system back to the

source system.

Environment:

US Bank, Minneapolis, MN

Apr '08- Jan '10

DWH Tester (Customer Data Mart - Global Consumer Group)

Roles & Responsibilities:

. Done database testing on Oracle, SQL Server, Teradata and MYSQL databases

using SQL queries.

. Designed and executed the test cases on the application as per company

standards

. Preventing occurrences of multiple runs by flagging processed dates

. Written Test Cases for ETL to compare Source and Target database systems.

. Testing of records with logical delete using flags

. Interacting with senior peers or subject matter experts to learn more

about the data

. Modified XML files to manipulate the data to fake the web services

. Provided excellent support during QA/UAT/Beta testing by working with

multiple groups.

. Optimized the SQLs and Tested Informatica mappings which handled millions

of records.

. Parameterized the automated scripts for running multiple sets of data

. Tested different ETL mappings and transformations

. Tested different Cognos cubes (dimensions, measures) by creating analysis

on front end and verifying with SQL on backend

. Performed Functionality and Regression testing of source application,

Cognos and Data integration

. Performed Ad-Hoc Testing for Cognos tool upgrades and ETL tool upgrades.

. Performed Black Box testing for testing all the business requirements and

the System functionality

. Created test data in source application to run approved test cases

. Supported UAT Testing effort by coordinating with end users and executing

UAT test cases

. Tested re-usable components in Informatica, Oracle and UNIX

. On-Call/Production Support provided during day-time and off-hours.

. Performed Database and Text checkpoints of Quick Test Pro

. Proved accuracy in doing sanity checks, smoke tests after the install of

new scripts used by ETL.

. Read and understand the Log files to verify the processes for debugging

and/or test data verification purposes.

. Prepared ETL Test Data based on ETL mapping document

. Create Test plan and Test Cases to cover overall functionality of the

application.

. Regression Test Plan and Production Acceptance test plan for the test

releases.

. Prepare and execute Test Cases for end-to-end functionality testing.

. Generated testing reports and metrics, trend graphs according to the test

plan

. Created and executed SQL queries in ORACLE and MS SQL server

. Performed tests on various browsers for Cognos Reportnet reports.

Environment: Informatica 8.6.1, Cognos 8.0 Series, HP Quality Center 10.0,

MS SQL Server 2008, Oracle 11g (SQL, PL/SQL), TOAD, MS Access, QTP 9.2,

Teradata V2R6, Teradata SQL Assistant, XML, XML Spy 2010, J2EE, Sybase

12.5, IBM AIX 5.5, Shell Scripting

Tata Consultancy Services, Hyderabad, INDIA

Jan '07 - Mar '08

Software Engineer

Roles & Responsibilities:

. Worked on gathering requirements for loan level and pool level

amortization process.

. Prepared detailed business requirement documents.

. Reviewed the Business Requirement Documents and the Technical

Specification.

. Developed Test Cases to cover overall quality assurance testing.

. Performed manual testing on different modules of the application.

. Performed System Testing and Integrity Testing using WinRunner.

. Developed, tracked and managed Issues Log created during the test phase

using Excel.

. Prepared Test status reports for each stage and logged any unresolved

issues into Issues log.

. Coordinated the Onsite and Offshore teams to resolve issues.

. Track and report upon testing activities, including the test case

execution stage, defect status if any defects opened during execution and

the testing results status.

. Executed the UNIX shell scripts that invoked SQL loader to load data into

tables.

. Generated Reports in Front end and validated Reports in Backend to ensure

data integrity and validate Business rules.

. Maintained Traceability Matrix to track the requirements to the test

cases to ensure complete test coverage in the Mercury Quality Center.

. Prepared Test Plan from the Business Requirements, detected defects,

tracked and reported bugs using Test Director.

. Performed data integrity testing by executing SQL statements and manually

verifying the contents.

. Used SQL on UNIX platform to perform Backend Testing on databases.

. Maintain SQL scripts for creation of database objects.

Environment: SQL, PL/SQL, Autosys, Test Director, JSP, Java Script, HTML,

Windows NT/2000, UNIX

Contact this candidate