Sql Server Test Cases

Career Summary

About * years of experience in Software Quality Assurance and Testing in different environments and platforms including Data Warehousing and Client –Server applications.

Extensive experience in Software Development life cycle such as Agile Scrum, Waterfall, V-model

Extensive experience in writing Test plans, Test cases and Test Execution.

Solid Experience in Black box testing techniques which includes Integration, System, Functional, Regression Testing.

Solid Back End Testing Experience by writing and executing SQL Queries.

Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL server, MS Access and Flat Files.

Extensively strong on databases including Oracle 11g/10g/9i/8i, MS SQL Server 2000/7.0, Teradata and DB2.

Worked on Web Services Testing using SOAPUI 4.0

Performed Backend Database testing on Oracle and MS SQL Server databases, used SQL, PL/SQL queries, triggers & procedures.

Worked on various Operating Systems which include Windows 95/98/2000/NT/XP and Linux (RedHat), UNIX (Sun Solaris 9.0/8.0/7.0, IBM AIX, HP UX 11i v1.5/1.6/2.0).

Strong knowledge in writing SQL Queries, Stored Procedures, Functions, Triggers,packages utilizing PL/SQL

Teradata experience using Teradata SQL Assistant and data load/unload utilities like B-TEQ, FastLoad, MultiLoad, FastExport, and TPump.

Good experience in data sources, data profiling, data validation, developing low level design patterns based on the business and functional requirements.

Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.

Involved in Design and Development of test plans based on high-level and detailed designs.Analyzed the user/business requirements and functional specs documents.

Experience working in an agile environment for many different projects for different domains.

Responsible for execution of Batch jobs and population test data for other teams

Strong interpersonal skills, ability to interact with individuals at all levels, excellent communication and presentation skills.

Technical Skill set:

Databases: Oracle 11g/10.2/9i/8i,sybase12.5, SQL Server, IBM DB2, Teradata

V2R6

Change Mgt Tools: ALM 11, Quality Center 10/9.2/8.2, Test Director 8.0, Rational Clear

Quest.

Data Warehouse Tools: Informatica 8.6/8.1/7.1/6.2/5.1.

Functional Test Tools: WinRunner 7.0, Quick Test Pro 8.2/8.0, Load Runner 8.0

BI Tools: Business Objects XIR3/XIR2& Cognos 8.0 Series

Languages: PL/SQL, T-SQL, SQL,, Shell Scripting

Office Tools: MS Office Suite, MS Project, Microsoft Share Point

Operating System: UNIX, LINUX, Windows, MS-DOS

Rational Tools: Requisite Pro, Clear Case, Clear Quest 7.1

Standards: VSTF 2008, METAL, SQL Server Analysis Server

Tools: TOAD 9.2, Win SQL, Teradata SQL Assistant, SQL Developer,

Bugzilla, JIRA, SOAPUI,NICE Actimize,Toad 12.5.1.1

Project Management Tools : VersionOne, JIRA

Technologies: XML, HTML, JavaScript, VBScript, Unix Shell Scripting, SAS

Qualification:

Bachelors in Mechanical Engineering, DVR College of Engineering, Andhra Pradesh, India.

Professional Experience:

Client: Standard & Poor's, New York

Jun 2014 - Till Date

Global Financial Crimes Compliance

Team Size: 12

Environment And Tools : SQL, Unix, Oracle 11g, ALM 11, Putty, Toad 12.5.1.1,Informatica, Nice Actimize

Role: Sr.ETL Tester

The purpose of the project is to perform sanctions screening on the data that has been collected in the form of flat files from all the different source systems and load them into Crimes Compliance DB(Oracle) for Actimize processing.

Roles And Responsibilities:

Responsible for testing the criteria in the requirement by validating the data provided by QA Team.

Prepared Test Plans and presented them to the Project Team

Documented Test Cases for all the scenarios and reviewed them with the broader team

Prepared the different SQL scripts for the test scenarios to compare source to target transformations.

Used WinSCP and Putty for source file navigations

Used Unix commands to validate the data in the source feed files.

Prepared test data to cover all the test scenarios.

Used Informatica for checking the logs to validate the ETL executions.

Tested the Nice Actimize application for sanctions screening.

Used ALM for Documenting the test cases and logging the Defects.

Executed test steps in Test Lab Module.

Used Toad to query Oracle database by executing the SQL scripts.

Attended Project Status meetings to represent QA Team and update the progress.

Participated in End to End testing of the Applictaion.

Client: JPMorgan Chase, Wilmington, DE

Jun 2013 - Mar 2014

Risk Execution - Portfolio Management

Team Size: 15

Environment And Tools : SQL, UNIX, Oracle 11g, ALM 11, Teradata 14, TSYS, PUTTY 0.62, SQL Developer, Teradata SQL Assistant, Tivoli Job Scheduling console, JIRA

Role: UAT Tester

This department deals with the process that involve with the credit line increase, credit line decrease, identifying fraud transactions, issuing rush cards to customers and various other applications that involve the risk on the Credit Cards.

Roles And Responsibilities:

Worked on the UDBA Controls, BAU and Enterprise wide applications.

Worked on QABATCH and DISCOV2B unix servers

Ran Unix shell scripts and made sure the processes ran end to end without any errors.

Responsible for testing the criteria in the requirement by validating the data provided by QA Team.

Prepared test plans and created test cases and raised the defects in the ALM.

Used TIVOLI (Job scheduling console) to schedule the jobs and validated to make sure jobs are running as scheduled.

Perform regression testing to ensure data is valid and requirements are met.

Provide ISQA with data conditioning criteria for UAT validation.

Perform validations on the data meeting the requirements.

Writing SQL scripts on the databases and loading data that meet the test criteria to the UAT databases.

Co-ordinate between QA and Business Owner / policy to ensure the process meets their expectation by providing dataset / data for their validation. ISQA will be transferring dataset / data to Business owner’s area.

Perform Post Implementation validations with respect to data.

Performed the Validations of Header, Trailer and detailer part in the file, whether they are per the requirements using UNIX and edit plus.

Performed validation on different environments UNIX, PROD and the different Databases.

Participated in final review / walkthrough meetings.

Participated in the Daily status Meetings and in the Defect Analysis Meetings.

Validation of the functional document based on the requirement.

Own / maintain Individual accesses to the databases and servers required.

Review and Participate in end-to-end testing as needed.

Client: Capital One, Richmond, VA.

Jun 2011- Apr 2013

Project name: Corporate Investment Bank Sales Data Mart

Team size: 8

Environment: SQL, PL/SQL, SQL Server 2008, Oracle 10g, DB2, Java, Quality Center 10.0, Cognos 8 Series, SOAPUI 4.0, Teradata V2R6, UNIX, VersionOne, XML, Schema, XSD, WSDL

Role: QA/SQL Back End Test Analyst

Roles and Responsibilities:

Analyzed the business requirements and functional specifications.

Worked with transformations like Filter, Router, Aggregator, Expression, Lookup,

Unconnected lookup, Update strategy, Normalizer, Sorter, Sequence generator.. etc while testing for data validation.

Extensively used Informatica Debugger to validate mappings and to gain troubleshooting information about date and error conditions

Performed data integrity testing by executing SQL statements and manually verifying the contents.

Involved in Functional and system testing.

Using SOAPUI client tested SOAP based web services.

Developed Test Cases using WSDL, Schema files which defines Web Service Request, Response, methods/operations, End Point of web service to be tested.

Created Test cases, Traceability Matrix and mapped the requirements to the test cases.

Tested the integration between various software packages to complete program Versions

Tested various Cognos reports and wrote test cases, developed data balancing techniques for several reports.

Responsible for Setting up Web Services project using WSDL in SOAPUI .

Used complex SQL to query the database and was involved in SQL optimization of existing SQL queries

Defect Reporting, Analyzing, Tracking and Report Generation, using HP Quality Center.

Performed Teradata SQL queries, creating tables and views by following Teradata best practices

Proficient in Report testing, which is developed by using Cognos Report Studio, and Analysis Studio.

Tested Crosstab and Drill-Through reports developed from Cognos Report Studio.

Compared query result sets from different database systems using UNIX diff command.

Reported the defects in Quality Center and documented the report.

Participated in migrating, UNIX code from DEV to QA environment.

Client: Bravo Health, Baltimore, MD.

Mar 2010- Jun 2011

Project name: CDM Data Mart

Team size: 6

Environment: SQL, PL/SQL, Oracle 9i, Agile, Windows, Autosys, Quality Center 9.2, QTP, UNIX

Role: QA Engineer

Roles and Responsibilities:

Created test cases and test plans for integration testing, user acceptance testing and system testing based on functional specifications.

Provided support to offshore Quality Assurance team with troubleshooting of issues.

Built complex SQL Queries and used TOAD for Oracle, WinSQL for DB2 and SQL Server BI studio for SQL Server.

Did work with co-ordination of offshore and onsite for all testing needs and change in requirements.

Tested several UNIX Shell Scripts for connecting to database and for the file manipulation of data.

Involved in analyzing SRD's for different dimensions and facts

Involved in validating mappings and workflows

Involved in understanding and updating review comments

Involved in peer review of Test case document

Designed and developed Test Cases, Test Plans and Test Scripts in HP Quality Center and executed them.

Evaluated QTP for automation & created various GUI checkpoints using QTP.

Performed manual testing on different modules of the application.

Logged defects in Mercury Quality Center and closed them once fixed.

Ensured weekly deliverables of the requirements as per the agile model.

Written several SQL queries for validating different complex data scenarios.

Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle.

Developed test scripts using QTP for Functionality and Regression Testing

Used Quick Test Pro generated various scripts for performing functional testing.

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

Validated the data in the reports by writing simple to complex SQL queries in the transactional system

Used complex SQL to query the database and was involved in SQL optimization of existing queries.

Client: Union Bank, Monterey Park, CA

April 2008- Mar 2010

Project name: ETL QA-CMDM (Customer Management Data Movement)

Team size: 6

Environment: UNIX Shell Scripting, Datastage 8.0.1, Rational Test Manager, Rational Clear quest, Sybase, Oracle

Role: QA/SQL Back End Tester

Roles and Responsibilities:

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

Performed back-end testing on the Oracle database by writing SQL queries.

Collected, analyzed and reported testing metrics, executed SQL queries.

Built and maintained effective QA test lab environments.

Responsible for source control, versioning, and configuration management of test scripts, test results, defects.

Developed Test Strategy, Test plan, Test cases, and Test scripts

Created test plan and executed test cases using Rational Test Manager

Creating test cases for ETL mappings and design documents for production support.

Setting up, monitoring and using Job Control System in Development/QA/Prod.

Extensively worked with flat files and excel sheet data sources. Wrote scripts to convert excel to flat files.

Scheduling and automating jobs to be run in a batch process.

Effectively communicate testing activities and findings in oral and written formats.

Reported bugs and tracked defects using Rational Clear Quest.

Extensively used DataStage Designer for Extracting, Cleansing, Transforming, Integrating, and loading data into different Data Marts.

Tested Datastage jobs using different stages like Transformer, Aggregator, Sort, Join, Merge, Lookup, Funnel, Remove Duplicates, Modify, Filter, Change Data Capture, Column Generator, Row Generator, etc.

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

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

Compared the actual result with expected results.

Validated the data by reverse engineering methodology i.e. backward navigation from target to source.

Contact this candidate