Sql Server Management

SUMMARY

. ** years of experience in Application/Software Testing

. Demonstrated strong testing background through ISEB (ISTQB)

Certification

. HP Quality Center 9.2 Software Certified Professional

. HP Quick Test Professional 9.2 Software Certified Professional

. Sound understanding of SDLC, STLC including Test Design, Test

Automation, Deriving Test Strategy, Testing Methodologies and Metrics

. Positive working relationship with Analysts, Designers, Developers and

Users overall in team environment

. Experience in Manual testing using tools like TestDirector 8.0, HP

Quality Center and experience with automation tools such as QTP, and

WinRunner

. Conversant in .NET, ASP, SQL Server, Oracle, VB, SQL, XML, XSLT, Java,

JavaScript

. Proficient in Manual, automated and Performance testing on Client/Server

and Web applications.

. Functional and Non-functional test cases creation and execution, Bug

reporting, documentations, maintaining test results and reviews.

. Experience in different types of testing viz Black Box, Integration,

System and Regression and also involved in Beta II testing with clients.

. Experience in Share point Development and Testing.

. Leading Testing Team and conducting training sessions for junior testers.

. Track and report quantitative and qualitative aspects of error reporting

to ensure solutions delivered are of peerless quality.

. Experience in Setting up a new Test Environment.

. Manage defects and assign them to the developers for fixes. Evaluate the

impact of a bug on the system, prioritizing them for new build/fix.

Retest defects; pass on to the stakeholders for UAT.

. Self motivated with an abundance of energy and drive. Organized and

methodical approach.

. Expertise in analyzing business user requirements and extensive knowledge

in gathering and understanding BRD (Business Requirements Document), SRS

(Software Requirement Specifications) and Use cases.

. Exposed to Database Integrity testing, Backend testing and knowledge of

databases like Oracle, DB2, MS-Access & MS SQL Server.

. Experience in Scrum methodologies.

. Exposed to all stages of Software Development Life Cycle (SDLC).

. Knowledge in working on different operating systems like Windows

NT/2000/XP, UNIX, LINUX and Sun Solaris.

SOFTWARE

Programming .NET, Visual Basic, C#, C++, Java, XML, HTML, DHTML,

Languages: VBScript, JavaScript, ASP, Moss 2007 and share Point

Designer

Software HP Quick Test Professional 9.2, Dev Track, Version One

Testing Tools: tool, Test Partner, Test Director and HP Quality Center

Bug/Defect Bugzilla, Perfect Tracker, Team Tracker, Web Tracker

Tracking Tools:

Databases: SQ SQL Server 2000 & 2005 and Oracle 9i

Modeling Tools: Microsoft Visio, MS-Word, MS-Excel, Rational Rose

Operating Windows 2000/2003/NT/98/ME/XP

Systems:

Version Visual Source Safe 6.0

Control:

EDUCATION:

. Masters of Computer Application (Bharathidasan University, India)

. Bachelors of Science in Computer Science (Madras University, India)

PRFESSIONAL EXPERIENCE:

Client: Swiss Re, Armonk, NY

Feb 2009 to till date

Sr. QA Analyst/Lead

Project: BoF

Swiss Re BoF (Business of Future) is a web-based system, which gives

service for SwissRe in the Reinsurance Business. Its have modules like

Policy, Treaty, Underwriting, Message Management, Technical Management,

Claims, R2 Assumed, R2 Retro, R2 Quota Share, Information Exploration,

Batch Frame Work, Reports etc.

Responsibilities:

. Lead a 5 members Team

. Involved in Preparation of Test plan and Test Strategy

. Involved in QA planning, Co-ordination and implementation of QA

methodology

. Developed VB Test Scripts for automated testing using Quick Test Pro

. Creation of Test Scenario and Test Suites to ensure complete testing

. POC for offshore testing team.

. Document test activities and archives data for investigative and

historical use.

. Developed Test Scripts for manual as well as for automated testing

using Quick Test Pro

. Defined test strategies and associated scripts for the verification

and validation of the application ensuring that it meets all defined

business requirements and associated functionality.

. Coordinated and Controlled Testing Projects at every step of the

Quality Cycle from Test Planning through Execution to Defect

Management.

. Monitored all phases of the Testing process, Test Schedules and their

Execution, and Communicated Project Information.

. Performed extensive Database testing by testing the Front End,

inserting Database Checkpoints to query data, performing Load Test on

the database server.

. Tested reports for doing the business rules validations and compare

them against the source data. These reports were scheduled and were

being run after every load.

. Created and tested scenarios using positive and negative test data.

. Automated Test scenarios for GUI, Functionality, Security, Database

and Regression Testing using Quick Test Professional.

. Developed parameterize test scripts to test same functionality with

multiple sets of data using Quick Test Professional.

. Designed structured Automated Test Cases and Test Suites for

reusability using Quick Test Professional.

. Experienced in Cod-Review and performed white box testing

. Experienced in developing scripts in Java script and VB scripts.

. Used Parameterization and Data Driven Testing in Quick Test Pro.

. Generated and executed manual and automated test scripts for the User

Acceptance Testing, Functional, System, and Integration testing.

. Experience in Using Configuration management tool using VSS.

. Participated in improving the departments QA processes and procedures.

. Actively participated in Status reporting and Defects discussion

meetings.

. Verified and tested the final output/data in the form of Reports and

Cubes.

Technologies: .NET, Visual Basic, C#, C++, Java, XML, HTML, DHTML,

VBScript, JavaScript and ASP, HP Quality Center 9.2, Dev Track, Version One

tool, SQL Server 2000 & 2005 and Oracle 9i, Windows 2000/2003/NT/98/ME/XP,

UNIX,VSS

Client: CIGNA - Health Care, PA

Jan 08 - Jan 09

Sr.QA Analyst

Project: CIGNA

The Centralized Eligibility Database (CED) is a major component of CIGNA

Healthcare's architecture system. It is the central storage area for all

eligibility information and a single source of entering, maintaining, and

tracking eligibility information on all clients, subscriber and members.

For individuals interested in receiving benefit coverage through their

employer, Cigna will request information from the clients on each

individual selecting coverage. This is done through the enrolment process.

Once eligible individuals become enrolled participants, then they are

entitled to the benefits under their employer's plan of coverage

Responsibilities:

. Reviewed technical documentation to understand the Business logic and

technical aspects system

. Analyzed the application and decided which parts to be manually

tested, and which to be tested automatically.

. Defined test strategies and associated scripts for the verification

and validation of the application ensuring that it meets all defined

business requirements and associated functionality.

. Designed Test Plan and Test cases for Acceptance, Functional and

Integration Testing using Quality Center

. Optimized QTP scripts for Regression testing of the application with

various data sources and data types.

. Involved in QA planning, coordination and implementation of QA

methodology.

. Developed Test Plan and Test Cases based on the business requirements.

. Defined Test cases and test scenarios for functional and regression

testing as per the requirements

. Used Test Director to report defects and for tracking bugs, assigned

severity to the defects those were logged on

. Enhanced the Automation Scripts in Quick Test Pro by using actions and

reusable actions.

. Automated Test scenarios for GUI, Functionality, Security, Database

and Regression Testing using Quick Test Professional.

. Developed parameterize test scripts to test same functionality with

multiple sets of data using Quick Test Professional.

. Designed structured Automated Test Cases and Test Suites for

reusability using Quick Test Professional.

. Used Parameterization and Data Driven Testing in Quick Test Pro.

. Verified if proper XML messages were generated and sent through and

received by the MSSeries server

. Involved in developing share point (MOSS ) intranet portal and

testing.

. Interact with Business Users & Application Developers during

Integration testing.

. Developed supporting test cases and scripts to validate functionality

of the application

. Conducted data validation testing using complex SQL queries, SQL

joins.

. Executed the developed tests both before and after bug fixes as a part

of regression testing

. Involved in extensive interaction with users to define acceptance

criteria

. Performed Functionality, Integration and System testing manually

. Lead & Co-ordinate with setting goals and task management with off-

shore team.

. Furnished weekly status reports to the project management team to

track project health

Technologies: .Net, Visual Basic, C#, C++, Java, Moss 2007, XML, HTML,

DHTML, VBScript, JavaScript and ASP, Test Director 7.0, QTP 9.2, SQL Server

2008, Windows 2000

Client:American International Underwriters, Texas

Oct 06 - Dec 07

Senior Test Analyst

Project: AIG- AIU- S3 CECIS Production Support

S3 is an Underwriting system for American International Underwriters (AIU),

division of American International Group of Companies. It involves

customization and production support of the S3 product for AIU.S3 includes

a set of applications that attend to various insurance business functions

like Claims Processing, Policy Underwriting, Rating, Billing, Reinsurance,

Coinsurance, Financial & Accounting, Client maintenance, Producer

maintenance, Reporting, Printing. The policy under writing caters to

Personal lines, Commercial lines and Accident & Health lines of business.

Responsibilities:

. Responsible for the specification, development & execution of manual

test scripts.

. Test design and identification of Test Conditions.

. Allocating and tracking test cases.

. Executing test cases in 3 phases, Functional Testing, System Testing

and Regression testing.

. Writing failure reports and defect escalation.

. Defect management and resolving of general default issues.

. Regression testing to ensure the stability of the system after

enhancement and defect fixing

. Performed Regression testing using QTP.

Technologies: .Net, Visual Basic, C#, C++, Java, XML, HTML, DHTML,

VBScript, JavaScript

and ASP,Test Director 7.0, QTP, SQL Server 2008, Windows 2000

Client: Cashnet, Boston

July 06 - Oct 06

Quality Analyst

Project: Cashnet

Cashnet is a Campus product for online payment processing, CASHNet.com's

Cashiering, eMarket, eBill, and CASHNet SmartPay solutions integrate the

collection, processing, and posting of all commerce collected on campus.

Cashiering - Cashier over-the-counter, back office payments and

departmental deposits campus-wide. eMarket- Create web storefronts where

customers can select and pay for items in that store's catalog

eBill - Present for payment and review the bills and balances of

authenticated customers

CASHNet SmartPay Banking Option - Reduce or eliminate the cost of

credit card acceptance

Responsibilities:

. Lead a 5 member test team

. Prepared Daily and Weekly Status Reports

. Involved in preparing Test strategy and Plans, Test procedures and

test estimations

. Involved in test scripts design and test execution.

. Performed Functionality and Scenario Testing

. Co-ordination with Development team on Releases and Defect Report

Status

. Bug reporting, tracking and customer/client communication using Test

Director 8.0 and Jira

Technologies: Test Director, Jira, .NET, Visual Basic, C#, C++, Java, XML,

HTML, DHTML, VBScript, JavaScript and ASP, SQL Server, Oracle, MS

Access, Windows 2000/NT/XP

Omnex India Pvt Ltd, Chennai, India

Sep 05 - July 06

Test Analyst

Client: MRF, Chennai

Project: EWQMS

EwQMS, or "Enterprise Wide Quality Management System" is a revolutionary

software suite. Comprised of an integrated set of innovative web-enabled

software tools that encompass all aspects of your business including

modules for product planning/design, document management, internal and

supplier audits, company performance/customer requirement management,

equipment verification and calibration, management and tracking of employee

objectives, business process implementation, and equipment maintenance

management and scheduling; all tied together and all sharing a single

repository.

Responsibilities:

. Identified test cases and test scenarios for the various modules.

. Involved in test scripts design and test execution.

. Performed Functionality and Scenario Testing

. Co-ordination with Development team on Releases and Defect Report

Status

. Bug reporting, tracking and customer/client communication using Test

Director 8.0

. Enterprise tool has been used to evaluate the software performance.

.

Technologies: WinRunner and Test Director, .NET, Visual Basic, C#, C++,

Java, XML,

HTML, DHTML, VBScript, JavaScript and ASP, SQL Server, Oracle, MS Access,

Windows 2000/NT/XP

Nanda Solutions Pvt Ltd, Chennai, India

May 00 - Aug 05

Test Analyst

While working in Nanda Solutions, I was involved in several projects.

Some of them are listed below

Client: Apurva Enterprises, Chennai

Project: Integrated Trading System(ITS)

To implement a Supply Chain Management solution and to upload data to a

central repository on a daily basis in order to facilitate data warehousing

and reporting.

Client:Fine Metal Works, Chennai

Project: Manufacturing Resource Planning(MRP)

Manufacturing Resource Planning (MRP) is a widely recognized system

suitable for assembly oriented production environment. MRP offers unique

platform for the integration of Marketing, Production planning and

Control, Material Management and Quality Assurance. Marketing module

includes customer details, sales details and sales analysis. Details on

work order, shop order and material requisition are prepared under

Production Planning. Quality Assurance module focuses on raw material

inspection, component inspection and material rejection. Material

management module contains stock controls and purchase management. These

are the major modules that encompass on MRP.

Client:KG-Mart, Mumbai

Project: Assaying

Role:Tester

Assaying is a new-age Enterprise Resource Planning (ERP) Application

catering to Diamond Jewellery Manufacturing and Trading Organizations with

the State of Art Remote Management Capabilities of their workplaces

irrespective of their geographical locations. The Application is made

robust with a seamless integration of the above systems through an

Intelligent Messaging System and a workflow Management system. Interfacing

devices like Barcode Scanners, Digital Weighing Scales and Smart Card

Systems ensure perfect functionality with minimal human errors.

Roles & Responsibilities :

. Responsible for the specification, development & execution of manual

test scripts.

. Test design and identification of Test Conditions.

. Allocating and tracking test cases.

. Executing test cases in 3 phases, Functional Testing, System Testing

and Regression testing.

. Writing failure reports and defect escalation.

. Defect management and resolving of general default issues.

. Regression testing to ensure the stability of the system after

enhancement and defect fixing.

. Performed regression testing using Win Runner.

Technologies: Test Director, Win runner, .NET, Visual Basic, VBScript,

JavaScript and ASP

SQL Server, Oracle, MS Access, Windows 2000/NT/XP

Contact this candidate