Sql Server Quality

Junayed Khan

Columbia, MD

E-mail: *************@*****.***

Phone: 443-***-****

Objective:

Perform testing of the full software development life cycle, including

requirements analysis, design, module, interface, integration, regression

and back-end testing. Tasks include but not limited to test analysis, test

planning, test case development and test execution, traceability matrix and

Reporting.

Abstract:

Over Five Years of experience in Software testing, which includes testing

Client Server and Web-based applications in both Windows and UNIX

Environments.

Experience in Health Care, Telecommunication and Banking sectors.

Thorough understanding of Software Development Life Cycle (SDLC),

Enterprise Life Cycle (ELC), and V-model and Agile methodology.

Experience in Positive testing, Negative testing, Integration testing,

Black box testing, Smoke testing, Functionality testing, User Interface

(UI) and Regression testing.

Solid experience in Mercury Interactive Test Director, Quality Center,

Quick Test Pro and SQL.

Experience in analysis of Software Requirement Specifications and

development of Test Plans, Test Scripts, Test Cases and Test Analysis

Report

Strong experience in Database/Back-end testing using MS SQL Server 2005

Management Studio, SQL Developer and SQL Plus.

Interacted with developers in resolving the defects discovered in the

application during testing.

Self-starter with strong work ethic and skills in time management, client

relationship and ability to adapt and learn new things quickly.

Organized, attention to detail, self-motivation, personable, multi-focused

and ability to meet project milestones and deliverable dates.

Excellent leadership, communication and coordination skills, Documentation

Skills, Team problem solving ability, analytical and programming skills in

high speed, quality conscious, Multitasking environment

Ability to work independently or as a member of a team successfully.

Education:

B.A in Business Administration, University of East London, UK - 2010

B.A in MIS, American International University of Bangladesh (AIUB) -

2004

Technical Skills:

Testing Tools : JIRA, Bugzilla, HP Quality Center,

Quick Test Professional

Programming Languages : C, C++, VB, SQL, JAVA

Operating Systems : Windows, UNIX

Database : Oracle DB2, and Microsoft SQL Server 2008, Oracle 10g

Server : IIS, Solaris, MS SharePoint 2007

Application Software : MS Office, Open Office

Networking : TCP/IP, Windows NT server, LAN, WAN

Professional Work Experiences:

Client: National Health Service (CMFT)

Title: Senior Consultant - System Analyst Team

Duration: 2012 - 2014

HSCARE- Health and social care is a JAVA based application to maintain

information of social care services to provide proficient support to public

health. Supported by MS SQL server database to maintain and share data with

other services.

Responsibilities:

Involved in development of Test Plan and test cases from functional

requirements, Design Specification, Report.

Developed manual test scripts to perform functional and regression testing.

Link Test Cases to Application Functional Requirements and Change Request

(CR) ensuring traceability throughout the testing process in Quality

Center.

Organize internal peer review sessions.

Create test data and test XML inbound files.

Define and track defects using Quality Center.

Assist Lead to track progress of other team members during various

Production Releases.

Present various presentations for knowledge transfer and educate internal

team members.

Help Client test team to understand, analyze and perform testing of new

changes.

Maintain bug tracking and reporting, also followed up with the development

team to verify bug fixes and update bug status.

Create XML test files, Flat files to satisfy business logics and scenarios.

Analyze and introduce new process of testing for high efficiency regression

testing.

Attend periodic meetings with different teams and clients to discuss any

issue or future changes.

Environment: JAVA, IE, Quality Center, MS SQL Server Management Studio, XML

Spy, MS Office Suite, Windows7.

Client: Hutchison Telecommunication International

Title: Consultant - Software Quality Assurance Team

Duration: 2011 - 2012

1

PAM3 - Post Award Monitoring System for 3 is used by the Hutchison 3G for

their post-grant process and Reporting. PAM3 is a custom .NET application

integrated into SharePoint. The system also utilizes a host of technologies

such as Adobe Forms, Meta Scan Anti-Virus, .NET web services, and SQL

Server 2005.

Responsibilities:

Analyze the System Requirement Specification (SRS) and design documents.

Develop Test Plan, Test Cases, Traceability Matrix, Smoke Test check list

and Entrance and Exit Criteria.

Perform back end testing using SQL scripts.

Develop Test data via SQL scripts.

Create and maintain test artifacts in share point site.

Work closely with Lead to assign defects to different Development teams.

Work closely with Development team to identify and resolve any issue.

Coordinate with UAT team and guide them over entire life cycle of UAT.

Assist new peers to understand the PAM3 system from Front End to Back End.

Attend periodic meetings with different teams and clients to discuss any

issue or future changes.

Environment: JIRA, Windows, Microsoft SQL Server 2005 Management Studio,

Share Point 2008, Adobe Life Cycle 2.5.

Client: Barclays

Title: Consultant - Software Test Engineer Team

Duration: 2010 - 2011

2

3 WM-TRAK - Wealth Management Tracking System built on C++ is an Asset

Management Client Server application

4 supported by Oracle Database and Unix Server for Barclays International.

Responsibilities:

Analyze the System Requirement Specification (SRS) and design documents.

Develop Test Plan, Test Cases, Traceability Matrix, Smoke Test check list

and Entrance and Exit Criteria.

Develop and execute detailed test cases with step by step procedures and

expected results in accordance with requirements.

Perform Integration testing and ad-hoc testing to test the functionality of

the modules.

Working with Developers and Business Analysts to define and design test

scenarios in test cases.

Communicating with Business Analysts and Development team to analyze and

clarify requirements defects

Writing SQL queries to test Data Integrity, Referential Integrity and

performed Database Testing for the application. Communicate with the DBA to

resolve any issue with the database.

Creating and refining Data using SQL Developer to fulfill prerequisites of

system testing and tracing them to scripts for future builds.

Using Mercury Quality Center as the test repository and use it for

executing the test cases and scripts, logging defects and generating

various reports and graphs for further analysis.

Perform Data Migration activities include mapping Redesign Database to

Legacy Database; validate data quality and Data validation.

Link Test Cases to Application Functional Requirements and Change Proposals

(CP) ensuring traceability throughout the testing process in Quality

Center.

Report and track defects using the Quality Center. Maintain Test Matrix for

test results information.

Follow, Develop and store templates in Project Asset Library (PAL) in every

stage of the Life Cycle to maintain software development standards.

Attend periodic meetings, formal and informal Peer Reviews, Requirement

meetings and led discussions on problem resolution.

Analyze and introduce new process of testing for high efficiency regression

testing.

Interview and train new consultants in every aspect of the project.

Environment: Windows, UNIX, Oracle 10g.

PROFESSIONAL AFFILIATIONS:

Member; The British-Bangladeshi Professional Association (BBPA)

Reference: Available upon request

Contact this candidate