Sql Server Test

Jing Wang

Phone: 571-***-**** - E-mail:

*****************@*****.***

HIGHLIGHTS OF QUALIFICATIONS

* ***** ********** ** ** industry, 4 years in Database, 4 years experience

in the finance industry

Strong SQL programming experience

Database testing skills with excellent command of SQL on DB2

Progressive experience in all phases of the iterative Software Development

Life Cycle (SDLC) and Testing Life Cycle.

Skilled in using MS office applications for day to day activity, MS Visio

for drawing flow diagrams and MS Project for prioritizing and managing

individual tasks.

Demonstrated leadership skills to resolve issues, drive projects, and meet

deadlines.

Highly initiative, self-motivated and dependable with excellent

communication, analytical and presentation skills. Ability to learn quickly

new technologies and to work under minimal supervision.

TECHNICAL SKILLS

Descript Language: C, Java, JSP, HTML, CSS, JavaScript, ASP

Tools: Rational Rose RT, HP Quality Center, QTP9.2, CANTATA 3.1, HP Load

Runner11, Rational Clear Quest, Rational Performance Tester, WebsPhere5.X,

Share Point, MS Access2010

Source Control: Visual Source Safe, and PVCS

Platform: AS400, Citrix, Windows 9x/XP/NT/2000, LINUX (Red Hat), UNIX (Sun

Solaris)

Servers: Windows NT/2003 server

Database: DB2, SQL Server 2000/2005/2008, Oracle10g

PROFESSIONAL EXPERIENCE

INFOTEK

The Globe and Mail

SQL Developer Mar. 2012 - Jun. 2012

Technical Environment: Windows XP, SQL Server 2005, XML, MS Access2010

Participated Mutual Funds Web application in all phases of database

development including programming, unit testing, final delivery to the test

team, and system testing support.

Responsible for internal and customer facing database assets including

installation, configuration, optimization as well as providing operational

support.

Participated in data mining/validation exercise

Created T-SQL stored procedures, View, Triggers, and other database objects

Queried Tuning and Performance Optimization

Performed database performance analysis, database sizing, capacity

planning, reporting and configuration

BPS

United State Patent and Trademark Office

DBA

Apr.2010 - Apr. 2011

Technical Environment: Windows 7/XP, Windows NT, Rational Clear Quest, HP

LoadRunner11,Linux, SQL Server 2005/2008, XML, Excel 2010, MS Access2007

Responsible for maintenance and assisting in database design and changes to

include creating databases, triggers, views, queries and reports for EDAN

Responsible for configuring and maintaining database replication including

clusters, conducting daily backups, importing/exporting data to other

systems, reporting, and client support for TDR

Monitor and optimize database objects and SQL Server databases (2000, 2005,

2008 R2) using industry-standard tools and practices (SQL Profiler,

Analyzer, Query Plans)

Conducts performance monitoring, reporting, and tuning of MS SQL databases

Provides support and assistance to development team in the design,

development, testing, tuning and implementation of database applications,

and in the provisioning of development and testing environments

Develop and document standards and best practices for newly developed data

centric solutions.

Prepare and Execute Unit Test Plan and Unit Test Cases

Trans Union

QA and DBA

July 2007 - October 2009

Technical Environment: Windows XP, HP3000, Windows NT, DB2, Rational Clear

Quest, HP LoadRunner9.5, Linux, Auto Testing tool - NOX, SQL Server

2005/2008, XML, Excel2007

. Responsible for database monitoring, troubleshooting, performance tuning,

and high availability strategies for SQL Server

. Design Database tables Platform Evolution for Platform Evolution

. Created SQL test script in DB2 for auto testing in 'Individual

Monitoring' Project

. Wrote queries in DB2 to get test data from different tables, analyzed

data and located defects

. Created stored procedures, triggers and views for Platform Evolution

. Basic Unix commands and shell scripting

. Design and develop reports using MS Access/MS Excel, SQL Server Reporting

Services (SSRS)

. Determine ways to organize and store data and identify user requirements,

set up computer databases, coordinate modifications and test the database

systems

. Ensure the performance of the system; Plan and coordinate security

measures and data integrity

. Updated XML file for member code configuration file and new layout in

Linux

. Verify valid data change in XML for 'Transaction Document'

RBC Royal Bank

QA Analyst

Feb.2006 - Apr. 2007

Technical Environment: Windows XP, Citrix, Windows NT, GRADS Work bench,

TSO, DB2, JCL, Mercury Quality Center, J2EE, Load Runner, Main Frame

. Designed, and implemented test case for Global Receivables And

Disbursements System- DOS-Migration web version using Mercury Quality

Center, GRADS work bench and Main Frame, working under SEI CMMI

(Capability Maturity Model Integration)

. Documenting and reporting problems, meeting with the programmers to

resolve these problems, documenting test results, ensuring the integrity

of the test material, and preparing versions for release to clients

. Checking table in Database and application error message using DB2, TSO

though AS400

. Created File, Changed and submitted file for creating test data by TSO,

JCL

. Designed and executed test case in Payment, Mass Request, Client

Scheduling Facility, Electronic Payment Management function for GRADS

DOS-Migration WEB version using Mercury Test Director, working on Royal

Bank Web access Server and Citrix

. Designed Performance test case and execute the performance testing for

Add Payment, Add Mass Request function using Load Runner

Prepared and designed master test plan and functional test plan for GRADS

DOS-Migration Solution

Designed and executed shakedown testing including shakedown functional

testing, shakedown Interface Testing, shakedown U&A testing for GRADS web

version

Created paralyze testing for GRADS DOS version and web version

Generated defect report for GRADS-AML-Northbound Solution using Mercury

Test Director

Set up test environment and test data for GRADS DOS-Migration GUI, BAT and

system testing

Data analyzed and verified for GRADS-AML-Southbound Solution

Simpressions Inc.

Web Developer and Tester

Sept.2005-Jan.2006

Technical Environment: Windows 2000/XP, HTML, ASP, VBScript, IIS, SQL

Server 2000, CSS, MS Access, Test Director7.6

Developed user page, administration page, ASP page for "Helpdesk System",

E Student System and for "Human Resource Reward System", following the user

requirements

Designed the database for a "Helpdesk System" and developed an associated

user manual

Designed the test plan following the client requirement

Perform bug reporting using an automated bug tracking tool and reported

Defect to Developer

Implemented menu test for Simpressions web site

Alcatel

Software Testing Engineer

May 2005-Sept.2005

Technical Environment: C, Rational Rose RT, Oracle 9i, Windows XP, DOORS,

Lotus Notes6.0, CANTATA3.1, Load Runner, Visual Source Safe, and PVCS, UNIX

Designed the test plan following the RATPL13 requirement and system design

VOBC test ability analysis following the Rose RT model and Schematic

diagram

Analyzed the error message using fault isolation requirement, functional

diagram, Rose RT Model

Analyzed test dependant signal, test trigger using Rose RT model and

functional block diagram, LRU function database

Analyzed test dependant function and threshold using Rose RT model,

Schematic diagram, RAPTL13 level 1 fault isolation requirement and ARIC

error isolation requirement.

iVedha Inc.

Software Developer and QA

May 2004-May 2005

Technical Environment: C, Windows 2000, CANTATA 3.1, Load runner, Test

Director7.6, JAVA, JSP, HTML, JavaScript, Oracle 9I, Apache Tomcat,

WebSphere5.0

Implemented stress test (load test), functional test, integration test for

"iVedha" web site

Developed Unit tests scenarios and test cases using CANTATA testing tool

for decision coverage and code converge.

Set up the unit-testing environment according to the standards specified by

Alcatel Canada.

Analyzed requirements and transformed them into functional design for E

Student System.

Designed the database, administration web page, JSP page for E Student

System

Developed the web page, database and ASP page for "Human Resource Reward

System"

National Institute of Atomic Energy in China

Software Programmer

July 1992-Jan 2001

Technical Environment: C language

. Did front-end troubleshooting on data analysis program working with C.

. Updated and modified front end of data analysis system according to

user requirements using C on Windows95.

. Supported other team members in resolving identified defects, defining

system requirements, providing estimates and project schedule

guidelines.

. Participated in specification reviews to gain a total understanding of

new and/or changed customer requirements.

. Completed daily/weekly checklists regarding server maintenance tasks

and issues / events of significance.

EDUCATION AND TRAINING

Certified Tester Foundation Level International Software Testing

Qualifications Board 2006

Master Degree in Computer Science The University of Sheffield

2003

Bachelor Degree in Engineering Zhengzhou Institute of

Technology 1992

Contact this candidate