Engineer Sql Server

D elower Jahan Cell

P hone: 631-***-****

Arlington, VA Email:

D ******.*******@*****.***

Objective:

Over S ix years of experience in the IT Industry as a QA Analyst / Engineer / Tester and

d iversified experience in manual and automated of Web and C lient /Server applications on

U nix and W indows environment to secure a position of Software Test Engineer/Analyst t o

u tilize my expertise and further knowledge.

Summary:

• In depth knowledge in all phases of S DLC (Software development Life Cycle)

and its methodologies such as Waterfall, I terative, Agile and also M obile

A pplication Development .

Expert

● in reviewing Requirement D ocument, Design Document, Functional

R equirement Specifications and System Requirement analysis experience.

H ighly Certified in wri ting, documenting and updating T est Plan, Test cases, Use cases

●

and R TM .

Expert in both M anual and A utomation testing on H P’s Quick Test Pro, Quality

●

Center/Test Di rector/ALM and as well as I B M tool such as R ational Test Manager,

C lear Case.

H ighly qualified in wri ting both Manual and A utomation test scripts for F unctional,

●

R egression, I ntegration, System, Smoke, Ad hoc and Usability testing.

Experienced in B lack box testing, Regression testing, Functional testing, Boundary

●

t esting, I ntegration testing, System testing, User acceptance testing, Ad hoc

t esting, Sanity testing .

Knowledgeable in diverse database testing and equally experienced in wri ting SQL

●

q ueries to retrieve data.

Proficient

● in analyzing Software Requirement Specifications, Functional

R equirement Specifications and both GAP and P roject M ilestone Report .

Performed User Acceptance Testing (UAT) and i nteracted with client/ end-users to

●

support UAT sessions.

Accustomed to working with the PMO’s, Business Analysts to understand both C lients and

●

B usiness Requirements as well an overall Project infrastructure .

Experience in the H ealth I nsurance I ndustry across segments l ike H IPAA, M edicare

●

and C laim Management .

Strong Knowledge of E D I t ransaction types, Claims processing and H IPAA regulations.

●

Experience in M obile Testing on I OS, Android, Blackber ry and K indle mobile

●

operating systems using Browser Stack.

H ighly analytical and innovative to improvise and implement new ideas as well as tweaking

●

conventional methods.

Have strong

● knowledge of d ifferent types of I nvestments, M ortgage Payment,

T ransactions & P rocess for H ome Mortgage and Servicing Application, P reservation

a nd Mediation .

A Leader and equally a T eam player t o r ise above any obstacles and also in delivering

●

g roup efforts.

A person of strong character to distinguish between p rioritizing and stagnating efforts.

●

Worked with the developers and Testing Team members to resolved technical and end user

●

issues.

T echnical Skills:

Testing Tools Quality Center/ALM/Test Director, QTP, Rational Suite,

SOAP-U I

Bug Tracking Tools Quality Center/ALM/Test Director, PVCS Tracker, JIRA

Operating Systems Windows, UN IX

Languages SQL, PL/SQL, C, Java, J2EE, ASP, C++, Visual Basic.

RDBMS Oracle, MS SQL Server, DB2

GUI Tools Visual Basic, Toad, SQL Developer 2008, Oracle Express

10/11g

Internet HTM L, DHTML, XML, VBScript, Java Script

Web Servers Web Logic, SOA, Web Sphere, Windows 2000 server, I IS and

A pache Tomcat

Project Management PVCS, VSS, MS Office, MS Project, MS Visual Studio

Tools

Professional Experiences:

Wells Fargo, Des Moines, IA

System QA Analyst,

Collection and Home Preservation SQA Team

February 2013 to Present

Project Description: I nvolved in verifying and v alidating t he functionalities of new

Home Mortgage Servicing applications.

Responsibilities:

Prepared and contributed in creating T est plan and T est Strategy a long with wri ting

●

and executing T est C ases for H ome Mortgage, Home Preservation and

Collection Team.

Performed F unctional, System I ntegration, System and R egression t esting, Black box

●

testing for the different types of customer’s L oan, Mortgage Payment, T ransactions &

P rocess for H ome Mortgage and Servicing Application .

Used H P Quality Center (ALM) for requirement management, planning, scheduling &

●

r unning tests, also t racking & managing defects in the D efects module.

Provide feedback and recommendations to developers on Software

● Usability and

F unctionality for d ifferent type of B ankruptcy, Non-Bank ruptcy, Preservation and

M ediation Letters.

Worked with multiple a pplications/systems on projects of high complexity within one or

●

more Q uality Assurance environments & cycles.

Analyzed M anual Test Cases w ith QA Team for most important & high priori ty

●

Requirements for conversion t o A utomated Test Scripts using H P Q uickTest

P rofessional (QTP) for Home Mo rtgage system and platform.

Enhanced the scripts by creating Actions, Checkpoints, Synchronization points,

●

P arameterization and Modular test in QTP .

Make H ome Mortgage Loan condition in M SP M ainframe Framework as a Collection

●

a nd Preservation SQA team member for Servicing Technology Group .

Followed Agile Methodology A ttained different kinds of Meeting like S tory Estimation

●

M eeting, Story Kick of Meeting, Story Tasking Meeting, Daily Standup Meeting,

S tory Tasking Meeting, Sprint Review Meeting, and Retrospective Meeting.

E nvironment: V Mware Mercury Quality Center (ALM), Quick Test Pro, M SP, Windows,

O racle, SQL Server 2008, Java.

M3 USA, Washington, DC

Software Test Engineer

May 2011 to January 2013

Project Description: I nvolved in newly added functionalities and online services in part of

Communication Network and integrating them with current system.

Responsibilities:

Analyzed the F unctional Requirements and D esign documents t o ensure that the

●

system met all the technical and business requirements of the applications.

Documented, updated and modified t est plans and t est cases corresponding to business

●

r ules and requirements. Manually performed System, Security, UAT, Functional,

R egression Testing .

Maintained and executed t est cases and t est scripts using Q uality Center .

●

Reported, exported and t racked bugs to the developers and test leads to maintain

●

sustainability in Q uality Center .

Developed and maintained automated test scripts to support regression testing and

●

participated actively in System testing and regression testing.

Extensively involved in creating regression A utomation test scripts, creating O utput

●

v alues, performing D ata D r iven Test to maintain suitabili ty for the project using Q uick

T est Professional .

Enhanced the scripts by creating Actions, Checkpoints, Synchronization points,

●

P arameterization and Modular test in QTP .

Used R eusable Actions w ith utilizing the f lexible functionalities in

● Q uick Test

p rofessional .

Testing M obile Application for the major US mobile networks on IOS, Android,

●

B lackberry and K indle mobile operating systems.

Ut ilized P VCS T racker t o store requirements and t rack defects.

●

Provided B ack End t esting for data validation using SQL Queries.

●

Performed d ata verification and validation i n the back-end of the application by using

●

SQL queries.

Used M S SQL Server (RDBMS) t o retrieve data from the application database.

●

Worked closely with

● Test Lead during the Software Testing Life Cycle (STLC ) by

ensuring full test coverage of the assigned test cases

Environment: V Mware Mercury Quality Center, Quick Test Pro, PVCS Tracker, Windows,

O racle, SQL, SQL Server, Java.

U.S. Department of Education, Washington, DC

QA Analyst

F ebruary 2009 to April 2011

Project Description: I nvolved in the IPM system, a web-based electronic and Case

M anagement System for Eligibili ty and Oversight business process that allow the receipt,

scoring and workflow management of the FSA Eligibility, audit and compliance reporting

and analysis functions.

Responsibilities:

Responsible for wri ting T est Cases for IV &V purpose and developed Test Plan & Scenario

●

base t est cases for UAT.

Wrote T est Plan for the F unctional Testing and performed various kinds of testing such

●

as F unctional testing, I ntegration testing, smoke testing, black box testing and

r egression testing.

Performed c ross browser testing using Netscape and In ternet Explorer.

●

Report and t rack defects found during the execution of manual test cases and automated

●

test run in Q uality Center .

Created and maintained log file for CR and CR versions & actions taken on CR and

●

reaction.

Writing SQL queries and statements t o test database for ret rieving information inserted

●

by the UAT users in O racle .

Coordinated with development team members for B ug t racking and testing efforts using

●

P VCS T racker . Actively attended defect reporting meeting periodically.

Responsible for weekly status reports with the clients to explain progress and C R i ssues.

●

Environment: Q uality Center, Test Director, QTP, Oracle, SQL Server, Windows, UN IX,

C++, Web logic, MS Office, PVCS Tracker.

C apital One, New York, NY

Software Tester

March 2007 to January 2009

Project Description: I nvolved in the newly added online services and integration of

f inancial data of the different banks (Chevy Chase, North Fork banks) acquired by Capital

One

R esponsibilities:

Analyzed

● B usiness Requirement Specification (BRS), Software Requirement

Specification (SRS) and User Requirement Document (URD).

Developed T est Plan and T est Approach artifact w ith resource requirements and t ime

●

estimates.

Designed and developed T est Scenarios, Test Cases, and T est steps for various Business

●

Services/methods covering both Positive and N egative testing requirements.

Involved in the project from the requirement analysis phase t ill the completion of UAT

●

(Entire Test Lifecycle).

Testing and cross-verifying the reports using SQL queries.

●

Writing SQL queries and statements to test database for retrieving information, editing

●

data and inserting the data.

Worked with the users to wri te requirements, design scripts related to the application

●

testing.

Ut ilized C lear Quest as a request t racking system for t racking the Defects and generating

●

reports.

Environment: Quick Test Pro, Test Director, .net, Windows, J2EE, UN IX, Web Sphere,

TOAD, O racle.

Education:

Bachelor of Science,

Stony Brook University, Stony Brook, NY

Work Status: U.S. Citizen

R eference: Available upon request.

Contact this candidate