Test Cases Sql Server

Name: Merlin Thomas

Contact No.: 501-***-****

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

Current Location: Houston,TX

Visa: Green Card

Relocate: Yes

Availability: Immediately

PROFESSIONAL SUMMARY:

5+ years of Experience Software Quality Assurance (QA) analyst / tester experience in testing Data Warehouse, Database (ETL & BI), Web application and Client-Server Systems

Expertise in QA Testing in distributed Unix/Windows Environment with MS SQL and Oracle databases as back end.

In depth technical knowledge and understanding of Data Warehousing, Data Validations, UNIX, SQL, PL/SQL, OLAP, XML, SQL Server, Oracle, and ETL

Solid Back End Testing experience by writing and executing SQL Queries on MS SQL and Oracle databases.

Web services Testing using SOAP UI tool

5+ years with SQL/PL-SQL and expertise in writing complex SQL Queries.

Hands on experience in SAP Business Objects Tools XI R2/XI 3.1/4.0, Informatica Power Centre 9.5,Dashboard 4.1,Tableau, Big Data, PLSQL, Unix

Good concept of ETL, Warehouse and BI applications integration.

Extensive experience in ETL process consisting of data transformation, sourcing, mapping, conversion and loading

Strong Knowledge on DW/ODS Data Modeling like Star Schema/Snowflake modeling.

Extensive reporting experience using Crystal Reports, BO Report.

Experience in using Oracle, MSSQL Server Databases.

Experience in using T-SQL in SQL Server 2000/2005/2008/2012 and 2014 platforms.

Hands on experience in Creating Star Schema and Snow Flake Schemas.

Experience with Visual Basics programming.

Tested applications on Java, Javascript, VB Script, C, C++,ASP.Net,C#

Very good experience with software methodologies like Agile and Waterfall.

Exposure to automation testing tools like QTP.

Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player.

Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.

TECHNICAL SKILLS:

Operating Systems

Windows, UNIX

Databases

Oracle 10g/11g, SQL Server 2008 R2, SQL Server 2012

BI Tools

SAP Business Objects Tools XI R2/XI 3.1/4.0, Dashboard 4.1, Tableau

ETL Tools

Informatica Power Center 9.5

Scripting

Shell Scripting

DB Utilities

SQL Server Management Utility, Toad, SQL *Plus

Programming Languages

VB, CSS, HTML, XML, Java, HTTP, OOPs

Testing Tools

HP Quality Center (ALM), JIRA, Soap UI

Design Methodologies

Logical and Physical Database Design, Database Design and Normalization, Data Modeling, 1.1 using Rational Rose.

Other Software

MS Office 2007/2010, Adobe Professional, SharePoint, Excel, Vlookup

Test Documentation

Test Plan, Test Summary Reports, Bug Reports, Weekly Status Reports

PROFESSIONAL EXPERIENCE

JSW, Houston, TX Jun 2015 - Present

Role: Software QA Engineer

Responsibilities:

Involved in preparing the Test scenario’s, Test cases for complete application Testing.

Created Test Cases based on Use Case Requirements based on Specification documentation.

Involved in all the quality assurance phases of Software Testing Life Cycle (STLC).

Interacted with developers and other QA engineers to address quality problem

Writing complex SQL queries and executing them to compare the results retrieved through online screens.

Participated in various kinds of tests like regression, integration and system testing.

Log the defects into the Test Director and tracking them and communicating with the concerned development team.

Generated reports relating to Requirements coverage.

Participating in Defect meeting and explaining the status to Project team.

Client: Relypsa, Redwood City, CA Aug 2014 - May 2015

Role: ETL Tester / QA Engineer

Responsibilities:

Analyzed the Business Requirement Document to prepare Test Cases/Test Plans

Wrote Test plans, Test cases, executed Test cases for SQL/backend test and tracked defects in Quality Center(ALM) based on the Business Requirements, Functional Requirements Business Workflows

Created test scenarios, SQL scripts using Toad and expected results

Documented overall testing status report for releases

Executed test cases and recorded the result in QC (ALM)

Analyzed and tested ETL Mappings, Workflows/Sessions and other DW job

Worked extensively in writing and debugging complex stored procedures, triggers, Inner Joins, Outer Joins, views and user-defined functions.

Prepared test cases to test each software component and demonstrated the business condition under test and the expected results

Provided feedback to the development team and ensured the work is carried out in accordance with the schedule and the quality requirements.

Collaborated with other team members to create, execute test scenarios and test cases and track results and log defects.

Peer reviewed other testers test scenario and recommended addition scenarios for better coverage of requirements

Reported significant defects and tracked all defects and project issues in Quality Center(ALM)

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

Created the test environment for Staging area, loading the Staging area with data from multiple sources

Reviewed the ETL mappings (Informatica) to ensure the transformation rules are applied correctly.

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

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

Contributed to the continuous advancement of current QA processes and maintain repeatable processes.

Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.

Client: Roche Diagnostics, Indianapolis, IN Jan 2014 - Jul 2014

Role: QA analyst

Responsibilities:

Prepared the system test cases based on the Business Requirements Document

Developed test cases for Functional, Regression, Load, System, backend and User Acceptance Testing(UAT)

Reviewed the test cases with the development team and updated the review comments

Executed the test cases for Web application, ETL, Report and Dashboard Components

Wrote complex SQL queries and SQL Test scripts and verifying and validating the input/output

Extensively worked on Grey Box Testing, Regression Testing and Sanity Testing.

Tracked defects using Jira and creating traceability matrix to ensure all defects are resolved.

Provided support for Customer acceptance test (CAT)

Prepared test data by modifying the sample data in the source systems, to cover all the requirements and scenarios

Ran test cases that tests the SOAP web services using SOAP UI tool and analyzed the results

Ran automated test cases that were written in QTP (UFT) and recorded the results

Coordinated with development team to prepare test beds for system testing

Participated in daily Scrum meetings to update the test execution status and any roadblocks encountered during the test execution

Conducted and actively participated in reviews, walkthroughs of test cases.

Client: Roche Diagnostics, Indianapolis, IN Feb 2013 – Dec 2013

Role: BO Developer

Responsibilities:

Performed requirement analysis from User Specific Requirements to design business object (BO) reports that map actual SQL structure in the database using Universe

Created Business Objects reports based on oracle for country manager presentation.

Converted complex Xcelsius dashboard to WEBI reports.

Created and designed Universe to be used for adhoc reporting.

Performed complex queries and analyzed the result to validate using oracle tool Toad

Co-ordinated with client for UAT

Did Knowledge transfer to the entire team

Static Electricals, Pune, India Jan 2012 – Jan 2013

Role: QA analyst

Prepared the system test cases based on the Business Requirements Document

Reviewed the test cases with the development team and updated the review comments

Coordinated with the developers to fix the show stopper bugs in order to continue the test case execution

Performed peer review and recommended the addition test cases for better coverage

Executed the test plan and reported the status to the team lead

Recorded the defects in the Quality Center (ALM) and assigned to the appropriate development team

Worked with the developers to help them understand the scenarios and reproduce the bugs

Used SQL queries to provision the test data for the test case scenarios

Worked in Agile Testing and participated meetings every day in iterative environment.

Power Electronics, Pune, India Jun 2010 to Dec 2012

Role: QA analyst

Involved in analyzing system requirements and writing test cases and test plan, Test Scenarios

Executed manual and automated test cases and verified actual results with expected results

Created and maintained detailed test cases to perform various types of testing in Test Plan module of Quality Center (ALM)

Involved in Test Summary Reports and Test Execution Metrics

Reported the testing progress to the team and the management.

References will be available on request.

Education:

Bachelors in Engineering (Electronics and Telecommunication)

Certification:

ISTQB Foundation Level.

Formal Training in SQL Oracle/PLSQL BI & DW

Contact this candidate