Sql Server Testing

Location:

Brampton, ON, L6P 2R3, Canada

Salary:

N.A.

Posted:

May 10, 2012

Contact this candidate

Resume:

Dipesh Patel

(***) *** - ****

Professional Summary

• Over nine years of diverse experience in the areas of Software Quality Assurance.

• Extensive experience in reviewing and analyzing Business Requirements and writing detailed Test Plans, Test Cases, and Test Scripts.

• Expertise in implementing RUP (Rational Unified Processes), Agile and SCRUM Methodology by analyzing requirement specifications and responsible for developing Test Objective, strategies, Scope, Test procedures and Test Matrices.

• Strong Experience in Coordinating with Development, Environment and Release Management Teams.

• Extensive experience in conducting different kinds of tests such as Smoke, Integration, Regression, Functional, System, Black Box ,White Box, UAT, Sanity, Load, and Stress Testing.

• Experience in working with Continuous Integration (CI) System Hudson.

• Involved in all phases of software testing life cycles and have an excellent understanding of Software Development life Cycle (SDLC).

• Expertise in Performance, Load and Stress testing for Network and Client/Server Applications.

• Experience with Web Technologies XHTML, CSS, JavaScript, AJAX and XML

• Involved in working with JUnit test runner and Eclipse.

• Extensive Experience in working with Bromine as test runner and report generator

• Experience in using Automation Tools such as Load Runner, QTP (BPT), Test Director and Quality Centre (BPT).

• Experience in web applications testing with Selenium IDE, Selenium RC, Selenium Grid and Web Driver (Selenium 2).

• Worked in database testing with database Oracle, DB2, and SQL Server.

• Proficient in writing SQL queries and strong in security backend testing using Toad.

• Extensively involved in debugging Web Application using Firebug.

• Experience in working with bug reporting tools JIRA, Bugzilla and Rally.

• Excellent Communication and Trouble shooting skills with ability to adapt to new technologies in real-time environment.

• Work output is of consistent high quality, correct and on time. Can be depended upon to complete a task even if it requires extra time/effort.

Technical Skills:

Languages: Java,J2EE,C

Scripting Language VBScript, JavaScript, Unix Shell Script.

Web Technologies: HTML, XML,CSS, DOM

Testing Tools: Load Runner 7.x/8.x/9.x, Selenium IDE, Selenium RC, Web Driver, Bromine, Quality Center , Quick Test Pro, Clear case, Bugzilla, Firebug, Yslow, Jira

Database: Oracle 8i/9i/10g/11i, SQL Server 7.0/2000/2005, DB2, PL/SQL

Operating System: Windows 95 / 98 / NT / 2000/XP/7, UNIX, Mac

Browsers: IE 6.0, 7.0,8.0, Mozilla Fire Fox, Safari

Software Methodologies : Agile, Scrum ,RUP

IDE and Utilities: TOAD, Eclipse, VM Ware , VI Editor, MS Excel, MS Power Point, MS Visio, Rational Clear Case, Rally

Certification:

Oracle – 1999

Java and Advance Java - 2000

SCJP (Sun Certified Java Programmer) - 2001

SSI,India - 2002

Professional Experience:

UBS (Cognizant), Stamford – CT. (USA) JAN 2011 to MAR 2012

Project: Bank management

Role: Sr. QA Analyst

Responsibilities

• Analyzed the Business Requirement Documents (BRD), System Requirement Specifications (SRS) and Functional Documents (FD) and responsible for creating Test Strategy, Test Plan and Test Cases.

• Involved in the preparation of Requirement Validation Matrix by identifying the various requirements and interacting with Test Lead and Business Analysts

• Involved in creating Manual test cases and automated scripts as well as identify existing test data in Mercury Quality Center.

• Developed the automated test framework using Compuware Test Partner.

• Developed and executed Load Runner scripts extensively for Performance Testing Tested Data Mapping and flow between the Front End application and the Back End of the application.

• Tests were planned and managed using Quality Center and defect tracking was done through Clear Quest and performed Manual testing.

• Create Rendezvous points using Load Runner to test application stability at concurrent load

• Prepared Defect Reports and helped in the preparation of Weekly status reports and attended Defect Report calls and Status Report calls.

• Worked on numerous Change Requests and helped incorporate them in the releases and off releases

• Involved in preparation of Test Plan, Test Data.

• Involved in Integration Testing, System Testing, Regression Testing, GUI Testing, Installation Testing, Compatibility Testing, Performance Testing and Smoke Testing.

• Worked in production environment for the various releases

• Involved in User Acceptance Testing (UAT).

• Back-End QA Process is done Manually Developing Query’s in Oracle Toad.

• Involved in preparation of Requirement Traceability Matrix (RTM).

• Extensively experienced on both automated and manual testing, with Mercury Quality Center, Rational Clear Quest and Quick Test Pro.

• Logged the defects generated due to mismatches in test object and run-time object properties into test JIRA.

• Created GUI maps, data-driven tests and synchronization points in Quick Test Pro to help solve key problems.

• Closely interacted with developers in resolving defects and helped them recreate the defect by explaining the steps to reproduce.

Environment: Load Runner, TOAD, Quality Center 8.2/9.0, Compuware, Quick Test Pro10, VB Script, Clear Quest, UAT, HTML, XML Spy, XML Loader, Win 2000, XP, Unix, Oracle 9i, 10G,SQL Server 00,VSS, JIRA.

Merrill Lynch , New Jersey

Project : Home Mortgage APR 2010 to JAN 2011

Role: QA Analyst.

Responsibilities:

• Validated test scripts and test cases in compliance with requirements coverage.

• Conducted Black box testing on the application to check the hyperlinks, broken links.

• Involved in Functionality testing, Integration testing, System Testing, Positive testing, Negative Testing and Regression testing.

• Configured the ordinal identifier properties used to record the object properties and enabled the smart identification mechanism for users.

• Designed and developed Functional test cases, User Interface test cases and test steps for putting the application on automated testing using QTP.

• Involved in carrying out functional, regression, component and integration level testing.

• Developed system test plans for testing future releases of the web based software applications.

• Utilized various Recovery scenarios for anticipated exceptions during the Regression Testing of various test sets using automated tool QTP.

• Generated a Shared Object Repository by recording the application in analog mode

• Tested functionality of the website by inserting various features like Standard checkpoints, image checkpoints, table checkpoints, text checkpoints, and database checkpoints.

• Carried out extensive backend testing to ensure proper backup and restoring of data using SQL queries.

• Validated sites across browsers and operating systems, verified the accuracy of links, visual presentation and its alignment with design specifications.

• Responsible in creating, execute, enhancing and maintain performance testing scripts (HTML-based, URL-based scripts) using HP Load Runner

• Logged the defects generated due to mismatches in test object and run-time object properties into test director

• Validate both functionality and automated business processes and identify bottlenecks using Test Director

Environment: Test Director/Quality center, Load Runner, Quick Test Professional, VB Scripts, HTML, XML, SQL Server

ACS, Atlanta - GA JAN 2009 to APR 2010

Project: MMIS Health Care

Role: QA Analyst

Responsibilities

• Analyzed functional requirements and documented the user specifications and business rules.

• Involved in writing Test Plans and Test cases documents.

• Designed automated test, created automated test cases and executed test using Selenium.

• Involved in Code Verification to validate the exceptions written in the code

• Developed automated script for back-end testing using Selenium IDE.

• Configure Selenium IDE for Java bromine.

• Tested compatibility of application for dynamic and static content under various cross browsers using HTML IDs and XPath in Selenium.

• Performed functional testing to identify various critical points in the application and automated it by using Selenium RC and Web Driver.

• Performed cross browser functional testing using Bromine.

• Performed Regression testing for new builds and every modification in the application using Selenium RC.

• Used TOAD explicitly to validate the database.

• Setup Hudson for continue integration.

• Validated sites across browsers and operating systems, verified the accuracy of links, visual presentation and its alignment with design specifications.

• Performed Unit testing with JUnit framework.

• Integrated Selenium RC and Web Driver with existing API to test framework

• Configured Bromine for easy running the test and store the result for analysis the test.

• Prepared a Report of all automation difficulties and test results for further application.

• Performed data accuracy, data validation and data integrity testing by querying the database using SQL queries to check the data table on server.

• Working on preparing configuration specs, branching, labeling, and merging using Mercurial and CVS.

• Used Rally tool to document requirements and test results documents. Also used Rally Tool to add and track defects.

• Worked in the form of sprint team with business analysts and developers in Agile methodology

Environment: Java, JSP, JUnit, Selenium IDE, Selenium RC, Web Driver, Selenium Grid, Bromine, Eclipse, TOAD, Rally tool, Ant, Hudson, Firebug.

PayPal, San Jose, CA SEP 2007 to JAN 2009

Project: CE2 (Consumer Experience)