Jayanti Basumallick

*** * ********* *** #**

Teaneck, NJ 07666

Phone: 301-***-****

E-mail: acc6kb@r.postjobfree.com

OBJECTIVE

A highly motivated Software QA Analyst/Test engineer with comprehensive

knowledge of software techniques and good experience of existing software

applications. I am seeking to work with a reputed company to achieve new

levels of competence.

SUMMARY

. Over 6 years of experience in software testing of Client/Server and web

based applications using structured methodologies.

. Very good experience in writing Test Cases, Test Plans, executing Test

Scripts, reporting defects and preparing Test Result reports.

. Involving experience in entire QA Life Cycle, which includes

Designing, Developing and Execution of the entire QA process and

documentation of Test Plans, Test Cases, Test Procedures and Test

Scripts for the web and Client/Server applications.

. Experienced in Manual, Integration, Regression and System Testing

using automated testing tools in the web-based applications.

. Experienced with Software Development Life Cycle (SDLC) which includes

methodologies like waterfall method and V model and Agile.

. Experienced in testing applications manually as well as using the

automated testing tools like TestDirector and Quality Center/ALM.

. Experienced with various databases like Oracle and SQL Server and used

the various SQL commands and PL/SQL statements to test the application.

. Experienced on working on SQL Single-row functions (Character, Number and

Date etc), Group functions and sub queries.

. Experienced in executing SQL queries in order to view successful

transactions of data and for validating data.

. Hands-on coding experience in scripting language- VB Scripting.

. Proficient in Functional Testing tool Quick Test Professional (QTP/UFT)

and the various frameworks in QTP/UFT.

. Experienced in giving training to the functional testers to execute Test

Cases using QTP/UFT as part of Regression Testing.

. Working experience on Data driven and Keyword driven frameworks in QTP.

. Experienced on demonstrating the Automation Framework in QTP/UFT to

client and driven project status calls with client.

. Experienced with Functional Testing, Performance Testing, Smoke Testing

and User Acceptance Testing (UAT).

. Experienced on successfully implementing Test Automation as part of

Regression Testing.

. Experienced with various web browsers like Internet Explorer, Firefox,

Safari, Chrome and Opera.

. Experienced with various programming languages like Java, ASP.Net and

other web development languages like HTML, DHTML and JavaScript.

. Highly motivated team player and ability to effectively communicate with

internal customers and other team members.

TECHNICAL SKILL

Operating Unix/Linux, Windows

System

Languages C, Java, SQL, PL/SQL

RDBMS Oracle, SQL Server, DB2, Access, Adobe

Automated ALM/Quality Center, QuickTest Professional(QTP),

Testing Tools SOAP UI

Defect ALM/Quality Center, TestDirector, Clear Quest,

Tracking Bugzilla, Team Track

Tools

Web VB Script, HTML, CSS, DHTML, XML

Technologies

PROFESSIONAL EXPERIENCE

Pfizer, Morris Plains, NJ

QA Automation Analyst

Oct, 12 - Present

Role & Responsibilities:

. Created and maintain Project Plan, Test Plan, overall Test Strategy

document and Test Scripts.

. Evaluated business risks with business analysts and code complexity with

development users to arrive at risk based testing approach and report on

business unit affected.

. Prepared Test Completion Report, executed Regression Testing, System

Testing, User Acceptance Testing (UAT), Smoke Testing & Functional

Testing.

. Analyzed business requirements, system architecture and design.

. Prepared Test Beds, Test Data planning and migrated from old source to

new system.

. Reviewed QA Test Plans, requirements and testing progress to meet quality

objectives.

. Prepared proof of concept, QA Test Strategy, detail planning effort for

automatic statement generation etc.

. Involved in User Acceptance Testing on later stages of SDLC.

. Played a lead role in developing Test Cases in a spreadsheet and uploaded

them to Quality Center Test Plan module and executed them in QC/ALM test

lab for various source systems.

. Prepared training materials for gathering materials, QC/ALM reporting,

Test Strategy QA methodologies, automation frameworks, design, defects

reporting and other QA templates.

. Conducted database testing, passing SQL queries to the Oracle database.

. Worked on SQL and PL/SQL and performed Backend validations.

. Successfully tested Data Quality layers, used data quality controls using

SQL.

. Responsible for development of new tools using QTP and VB scripts useful

for business needs.

. Enhanced Regression Test Cases to implement complex testing scenarios,

increased permeations of Functionality Testing and increased code

coverage using QTP.

. Performed GUI interface testing at client side using QTP.

. Created, updated and maintained the object repository.

. Enhanced QTP automation scripts with synchronization points, data table,

parameterization and functions.

. Performed Business Acceptance Testing (BAT), Build Verification Testing

(BVT), and Usability Testing (UT).

. Actively participated in statement redesign project in various phases

like concept & definition phase, use case preparation, proof of

concept and business requirements.

. Gathered metrics, factor with variance and publish enterprise level for

improving quality of the products.

. Performed data validation testing and validated XML data files and

Transaction log files.

. Created stored procedure to access database from various databases and

performed database checking between source and target systems.

. Prepared overall program trend analysis and suggestion to improve the

process by identifying gap in process.

. Performed role based testing and single sign on testing for the

applications.

. Prepared weekly, daily progress reports for higher management.

Environment: Windows, UNIX, Oracle, Oracle PL/SQL, SQL, Oracle Forms,

Oracle Reports, Java, VB.net, J2EE, XML, Web Logic, JSF, LDAP, Apache, EI

Server, Visual SourceSafe, ALM/HP Quality Center, UFT/QTP, MS Office, EMC,RTS, Shell Scripts, MS Project, TOAD.

Census Bureau, Suitland, MD

QA Consultant

Jan, 10 - Sep, 12

Role & Responsibilities:

. Involved in developing Test Cases from business requirements.

. Analyzed requirement documents to develop and executed Test scripts and

documented Test Cases corresponding to business rules.

. Tracked bugs using Quality Center/ALM and performed Regression Testing of

the entire application once the bugs are fixed.

. Used SQL Navigator to write queries and test the database.

. Extensively used SQL to perform Data Integrity Testing.

. Extensively used VB Scripts to write scripts for testing certain

functionalities in the unit.

. Performed testing extensively on the unit using QTP.

. Inserted verification checkpoints, synchronization points, and

parameterized data using QTP.

. Developed Automated Test Scripts for Functional Testing using QTP.

. Performed testing for broken links and tested functionality on cross

browsers.

. Identified numerous user interface and Functionality defects and caveats

in the Functional Requirements that were addressed prior to User

Acceptance Testing (UAT).

.

Participated in weekly meeting with QA, developers, analysts and management

team.

. Participated in bug review meetings on behalf of the QA team.

. Assigned web based system testing which included all of the functionality

of existing mainframe system delivers today plus enhanced vital

functionality. Involved in conduct work product reviews to ensure

requirement and quality adherence.

. Designed and applied new methods and procedures.

. Developed project plans with milestones.

. Coordinated all meetings and interface with business units, staff and

service providers.

. Scheduled meetings with developers, system analyst and testers to

collaborate resource allocation and project completion using MS Project.

. Communicated with business users to identify required data to be

extracted from the back end systems.

. Conducted JAD sessions with management, SME, vendors and other

stakeholders for open, pending and critical issues.

. Closely worked with off shore teams with different time zones.

Environment: Mainframes, COBOL, Oracle, PL/SQL, QC, QTP, Java, HTML,

Windows and MS-Office.

Best Buy, Richmond, VA

Software Tester

Mar, 07 - Dec, 09

Role & Responsibilities:

. Developed the Test Plan, Test Cases and Test Strategy for the project.

. Checked the data validity for various applications, tracking software and

specification defects and resolution using TestDirector, documenting all

phases of QA life cycle, analyze functional requirements, mapping

documents.

. Performed Test Case management and defect management using TestDirector.

. Logged bugs in the TestDirector tracking tool.

. Developed and executed SQL and UNIX scripts for validating Business Rules

and verifying the accuracy of data.

. Used SQL & PL/SQL for data validation as part of Oracle Database Testing.

. Worked with QTP to create, manage and execute Test Sets.

. Maintained QTP Test Libraries and executed Test Plans.

. Developed manual Test Script and converted to automated script using

Quick Test Professional (QTP).

. Created dynamic & efficient QTP Automation Framework.

. Performed Automation with expert use of Quick Test Pro (QTP).

. Conducted sanity testing of the application based on user requirements.

. Coordinated meetings with the development teams for appropriate handling

of the bugs and their timely resolution.

. Communicated with application developers, project managers and other team

members on application testing status on an ongoing basis when necessary.

. Closely worked with off shore teams with different time zones.

. Reported Regression Test Status to clients.

. Reviewed computer logs and reported to identify application processing

errors and possible improvements.

. Planned, implemented and followed software development process quality

standards, methods and procedures.

. Performed risk identification and mitigation activities, escalating

unresolved issues to the executive and steering committee where

appropriate to secure their timely decisions and support.

. Interacted with the team members and participated in review meeting with

developers and business analysts for understanding the requirements.

Environment: HTML, Java, JSP, EJB, Oracle, Power Builder, TestDirector,

UNIX, QTP, Robot and Clear Quest.

EDUCATION:

Finished some cources from Montgomery College,Rockville, MD

. Adult Career Development

. Oracle and UNIX(Linux)

References Available Upon Request

Contact this candidate