Sql Server Data

Sunder

Phone: 408-***-****

Email: abh3vj@r.postjobfree.com

Summary

. 6 years experience of in RDBMS technologies like Oracle, Teradata,

DB2, MS SQL Server, Sybase and MYSQL.

. Experienced with Test Plan, Test Case, Test Script, Change Request and

Defect Request.

. Extensive Experience in Utility Tools like TOAD, SQL Query Analyzer,

SQL Server Management Studio, SQL Assistant, SQL Developer, SQL* Plus,

SQL*Loader and Rapid SQL

. Familiar with managing the defects through Testing Tools like Quality

Center/Test Director, Clear Quest and StarTeam.

. Extensive understanding of Business Requirments/Rules, Functional and

Technical Specifications.

. Experienced in querying the databases by developing and running SQL

and PL/SQL queries using utilities like Toad and SQL Query Analyzer.

. Extensive experience in manual testing the ETL and Business

Intelligence Applications like Informatica Power Center, Ab initio,

Cognos, Microstrategy, Business Objects.

. Experienced in kicking off ETL jobs using UNIX.

. Documentation of Requirments, Test Case, Test Scripts and Results

using Excel.

. Experienced with System, Integration, Regression and User Acceptance

Testing.

Technical Expertise:

Testing Tools Quality Center 9.2/8.0/Test Director, Clear

Quest, Manual Testing, Borland StarTeam, QTP

Databases Oracle 8i/9i/10g, DB2 8.0/7.0/6.0, SQL Server

2000/2005/2008, MySQL, MS Access, MS Excel,

Teradata V2R5/V2R6, Sybase

Utility Tools TOAD 8.5, SQL Assistant, SQL Query Analyzer, SQL

Server Management Studio, SQL* Plus, SQL*

Loader, SQL Developer, Rapid SQL

ETL Tools SSIS, Informatica 8.1/7.1./6.2/6.1/5.1

MS Office Word, Access, Power Point, Excel

Reporting Tools Cognos, SSRS, Micro Stratagy

Operating Systems Windows 95/98/2000/XP, Linux and UNIX.

Web Programming HTML, XML,JSP, Java Script

Programming SQL, PL/SQL, T-SQL, C, C++, Java

languages

Professional Experience:

US Bank, Minneapolis, MN

ETL/DWH Tester

Jan 2009 - present

Responsibilities:

. Analyzed business requirements, system requirements, and data mapping

requirement specifications interacting with client, developers and QA

team.

. Written Test Script, Test Cases, Reported bugs and tracked defects

using Quality Center.

. Performed all aspects of verification, validation including

functional, structural, regression, load and system testing.

. Experienced in data integration, metadata management, ETL, data

modeling tool sets

. Written SQL queries for data validation to verify Informatica ETL

Mapping Rules.

. Collected requirements and tested several business reports generated

from Cognos.

. Extensively test the reports for data accuracy and universe related

errors

. Used Toad to query and validate the data loaded into Oracle tables.

. Used Toad for data analysts and Sql server Management Studio to query

Sql server.

. Report defects after reviewing test results and Track discovered

defects and defect resolution in Quality Center.

. Experienced in testing Informatica transformations like joiner, lookup

and aggregator.

. Based on user requirements documented the test cases in Quality

center.

. Generated test plans, test cases and test steps in Quality Center for

Automated Testing

. Discussed QA Testing requirements in QA Team walk through meetings.

. Tested the reports like DrillDown, Drillup and pivot reports generated

from Cognos.

. Created Test input requirements and prepared the test data for Data

Driven testing.

. Tested several datamart tables in Oracle database using SQL and PL/SQL

queries.

. Involved in extensive data validation using SQL queries and back-end

testing

. Used Informatica Power Center workflow manager for session management,

database connection management and scheduling of jobs.

. Used workflow monitor for monitoring workflows and reviewing session

logs.

Environment: Informatica PowerCenter 9.0, Windows NT 4.0, Oracle 10g, SQL

Server2005, Quality Center 9.0/Test Director, SQL, TOAD, IBM DB2, Cognos,

MS Access, MySQL, Unix, Flat Files.

Cricket Communications, DTC, CO

DW ETL/QA Analyst

Jun 2008 - Dec 2009

Responsibilities :

. Analyzed business requirements, system requirements, data mapping

requirement specifications, and responsible for documenting functional

requirements and supplementary requirements in Quality Center.

. Involved in developing detailed test plan, test cases and test scripts

using Quality Center for Functional and Regression Testing.

. Tested data migration to ensure that integrity of data was not

compromised.

. Involved in Data mapping specifications to create and execute detailed

system test plans. The data mapping specifies what data will be

extracted from an internal data warehouse, transformed and sent to an

external entity.

. Tested Complex ETL Mappings and Sessions based on business user

requirements and business rules to load data from source flat files

and RDBMS tables to target tables.

. Maintained the test environment for Staging area, loading the Staging

area with data from multiple sources.

. Extraction of test data from tables and loading of data into Teradata

tables.

. Created ETL test data for all ETL mapping rules to test the

functionality of the Informatica Mapping

. Tested the ETL Informatica mappings and other ETL Processes (Data

Warehouse Testing)

Witten SQL queries to validate the reports generated from Microstrategy.

. Familiar with utilities Fastload, Multiload, Tpump in teradata.

. Tested different reports, graphs and pivot reports in Microstrategy

dashboards.

. Tested ETLs involving different sources and Teradata target database.

. Used SQL Assistant to query the Teradata database tables.

. Tested the ETL process for both before data validation and after data

validation process. Tested the messages published by ETL tool and data

loaded into various databases

. Responsible for testing mappings by writing complex SQL Queries using

SQL Assistant.

. Queried database using SQL and converted the results into PERL

variables.

. Worked with Data Extraction, Transformation and Loading (ETL).

. Involved in testing the dimension and fact tables in Teradata

database.

. Worked with business team to test the reports developed in

Microstrategy.

. Used Quality Center to track and report system defects

Environment: Informatica 8.1/7.1, DB2, SQL, Oracle 10g, SQL Server

2000/2005, Teradata V2R6 (MLOAD, FLOAD, FAST EXPORT, BTEQ), Teradata SQL

Assistant 7.0, UNIX, Quality Center 8.2/test director, Microstrategy

Thomson Reuters, Denver, CO

Jan 2007 - Jun 2008 ETL QA Tester

Responsibilities:

. Analyzed business requirements, system requirements, and data mapping

requirement specifications interacting with client, developers and QA

team.

. Written Test Script, Test Cases, Reported bugs and tracked defects

using Quality Center.

. Performed all aspects of verification, validation including

functional, structural, regression, load and system testing.

. Written SQL queries for data validation to verify SSIS ETL Mapping

Rules.

. Collected requirements and tested several business reports generated

from Cognos.

. Extensively test the reports for data accuracy and universe related

errors

. Used Toad to query and validate the data loaded into Oracle tables.

. Used Toad for data analysts and Sql server Management Studio to query

Sql server.

. Report defects after reviewing test results and Track discovered

defects and defect resolution in Quality Center.

. Experienced in testing SSIS transformations like join, merge, lookup

and aggregate.

. Based on user requirements documented the test cases in Quality

center.

. Generated test plans, test cases and test steps in Quality Center for

Automated Testing

. Discussed QA Testing requirements in QA Team walk through meetings.

. Tested the reports like DrillDown, Drillup and pivot reports generated

from Cognos.

. Created Test input requirements and prepared the test data for Data

Driven testing.

. Tested several datamart tables in Oracle database using SQL and T-SQL

queries.

. Involved in extensive data validation using SQL queries and back-end

testing

. Tested the different sources such as Flat Files and Oracle to load

into SQL Server data warehouse.

. Experienced with executing SSIS packages.

. Reviewed the log files for ETL package errors and reported to

developers.

. Validated SSRS reports like Drilldown and Pivot and cosmetics like

color and font.

. Written complex SQL queries to validate SSRS reports data.

. Attended QA walk through meetings with QA Lead and other testers.

Environment: SQL Server 2005, SSIS, SSRS, Windows XP Pro, Oracle 9i,

Quality Center 9.0, SQL, SQL Server Management Studio, TOAD, IBM DB2, MS

Access, Unix, Flat Files.

Apollo Hospitals, India

Jun 2004 to Jan 2007 Junior Database

Developer/Tester

. Analyzed all business functionality related to back end database.

. Developed technical specifications from business requirements.

Specifications are done according to standard specification

formats.

. Used Test Director to open change requsest and defect request.

. Used Test Director for Bug Reports and Defect Tracking.

. Worked with DBA in making enhancements to physical DB schema. Also

coordinated with DBA in creating and managing table, indexes, table

spaces, triggers, db links and privileges.

. Analyzed and designed tables based on small and large database

transactions.

. Analyzed the requirements and developed PL/SQL packages, stored

procedures, functions, Object Types and triggers.

. Utilized SQL*Loader to load flat files data into database tables.

. Responsible for SQL tuning and Optimization.

. Utilized PL/SQL developer tool in developing all back end database

interfaces.

. Developed automated Korn shell scripts to schedule the load of flat

files on daily, weekly and monthly basis.

. Responsible for performing code reviews.

. Involved in Integartion, regression and User Acceptance Testing.

. Developed test plan documents and Reviewed unit test results.

Environment: Oracle 8i, PL/SQL, UNIX, SQL* Loader, Test Director and

Windows NT.

Contact this candidate