Sql Server Testing

NAVNEET KAUR

Phone: 443-***-**** Email: **************@*****.***

Location: Cockeysville, MD Certification: Microsoft Certified SQL Server 2005 (070-450)

Summary:

• 5 years of experience in Mercury interactive testing tools Quick Test Pro 9.0, Quality Center 9.0, and

Load Runner and IBM Rational Tools Clear Quest, Jira and also SQL Server Databases 2008 and 2005.

• Experienced in Functional, Stress, Regression and Integration Testing

• Extensive knowledge of QA methodology, standards and procedures such as creating test plans, test script

generation, regression and user acceptance testing.

• Experienced in preparing test plans, test cases/scripts, test reports, defect tracking and documentation for

both manual and automated tests. Involved in developing and maintaining the requirements traceability

matrix (RTM) and knowledge of functional, stress, regression and integration testing.

• Extensive experience working with databases such as installing and configuring SQL Server 2008 and

2005.

• Wrote extensive SQL queries to automate certain QTP testing process related release.

• Strong planning, analytical and problem solving skills, dedicated team member and able to work

independently.

Technical skills:

Testing Tools Mercury Quality Center 9, Test Director 7, Load Runner, QTP

Bug Tracking Tools Quality Center, Clear Case

Applications Web Based, Client/Server

Methodologies SDLC, RAD, CMMI-2

RDBMS SQL Server 2012/2008/2005R2, MS SQL and MS Access

Programming C, SQL, HTML, XML, DHTML, JavaScript

Languages

Networking Foglight (Quest), Event Viewer and Reliability Performance

Monitoring Tools Monitor.

Reporting Tools SSRS

Installation Windows 7, DNS Server Role, DHCP Server role, WSUS, RRAS,

File Service, Active Directory service.

Operating Systems MS-DOS, Windows 98/NT/2000/Server 2003/2008/2008R2/XP sp2,

Linux, & Unix

Server Security Encryption, Kerberos Authentication, Windows permission, NTFS

permission, resource ownership.

Professional Experience:

Znergies LLC, Sterling, Virginia August 2012 to February 2013

System Tester

Project summary: Political Campaign Management System (PCMS) is a campaign management system. PCMS

features the most comprehensive set of campaign Management Software Tools on the World Wide Web. Use of

the campaign manager web application to help you create your campaign, win the campaign, then manage then

campaign! Few features to high light in PCMS are the robust search functionality, finely tuned database holding

all the individual, household and election data, ability to create a walk list, email list, task list and work list. Most

existing new feature added is the ability to do Business Analytics using the Dash Board. Packaged with these rich

features the product can be accessed from where. PCMS offers more political campaign tools than any other

competitor.

Responsibilities:

• Used SQL queries for data verification

• Developed automated Test Scripts using QTP.

• Designing Test plans, Test cases and Requirement Traceability Matrix.

• Reviewing and Approving the Test Cases prepared by the team members.

IT/ 7Eleven, LA, California

System tester/ Administrator January 2010 to July 2012

Responsibilities:

• Involved in testing all back end processes using UNIX scripts, SQL on different servers.

• Analyzing test results with QTP reports.

• Wrote and recorded VB Scripts for Automating the Functional testing procedure using QTP.

• Expertise in performing different types of testing: Black Box, Stress, Volume, System Performance, GUI,

Regression and UAT Testing.

• Conducted the load testing manually on the UNIX environment.

• Developed load testing scripts and tested the scripts using load runner.

• Managed entire quality process like creating test cases, submitting defects in Mercury Quality center 8.2.

• Used the Software Development Life Cycle SDLC and change control processes.

• Wrote SQL queries to retrieve the data from database tables and validated the data as well as the business

rules.

• Worked on Stored Procedures, Triggers, Joins, Views while preparing testing environment as well as

during all testing phases.

• Converted business and functional requirements into test cases and performed Manual Testing like

Positive Testing and Negative Testing.

NIIT, New Delhi, India June 2009 to December 2009

System Tester/Network Administrator

Responsibilities:

• Derived test plan from technical specifications and requirements.

• Developed QA test plan for covering functional, integration, and regression.

• Manually tested the whole application before going for the automated testing.

• Analyzed test results with QTP reports.

• Responsible for System Integration Testing and Regression Testing.

• Prepared the Module Test plan for my track

• Used Quality Center to track and report System Defects.

• Developed several SQL Queries to perform backend testing of the database

• Troubleshooting on installation of software, modems, and other hardware and networking problems

• Resetting user name and password using Active Directory. Gained hands-on experience on network and

server troubleshooting.

• Configuration & Troubleshooting of TCP/IP, DHCP DNS.

• Backup and restoration of data to and from servers and desktops

IT/ 7Eleven, LA, California November2007 to September 2008

System Administrator

Responsibilities:

• Performed unit, systems and integration testing(SIT), Regression testing using Black.

• Evaluated existing systems and/or user needs and make recommendations

• Familiar with a variety of the field's concepts, practices and procedures

• Manage Team of Desktop Support Specialists to imaging desktops and laptops and day to day support.

• Assisted Team of System Administrators in the build of Windows 2003 servers.

• Created and maintained user accounts and passwords.

• Responsible for remote support of traveling users and home users with secure id VPN.

• Extensive experience and judgment to plan and accomplish goals

• Managed technical service-related operations

• Configuration & Troubleshooting of TCP/IP, DHCP DNS.

ICICI Bank, Punjab, India February 2007 to August2007

Testing/ SQL Administrator

Responsibilities:

• Analyzed Requirements, design document and business rules.

• Working closely with the client leads, project leads, configuration teams, development teams, and

production support to deliver a quality release per commitment in a timely fashion and set product testing

priorities.

• Responsible for system Integration Testing and Regression Testing.

• Changed the scripts according the test scenarios.

• Done the system testing and user acceptance testing.

• Write used cases and get them approved by business.

• Created complex SQL queries.

• Analyzed stored procedures, scripts, and programs for necessary modifications.

• Assisted Team of SQL Server Database Admin for database base upgrade and backup Recovery.

• As a Database administrator, involved in the maintenance of three servers (archdb, Navis and Test

servers).

• Perform daily monitoring of the databases and database space management

• Involved in DBA activities such as creating users, roles and other database objectives.

Education and Certification:

2010- Present Pursuing Associate Degree in Network Technology (CCBC)

2005 – 2007 Bachelor’s of Computer Engineering

2002-2005 Associate Degree in Electronics and communication engineering

Certification: Microsoft Certified in SQL Server 2005

REFERENCES: Available upon request

Contact this candidate