Life Insurance Project
Resume:
SUSHMA PALA
**********@*****.***
________________________________________________________________________
Objective
Seeking a challenging position in Software Testing/Quality Assurance and
leveraging diversified experience in software development lifecycle.
Summary:
> 5 plus years of experience in software industry with emphasis mainly on
Quality Assurance of Web based and Client Server Applications using
structured methodologies.
> Experience in testing Web and Client/Server applications.
> Participated in every phase software development life cycle.
> Provided extensive support in creating Test Strategy, Writing Test plans,
Test cases and execution of test cases in manual testing as well as using
the automation testing.
> Expertise in various testing methodologies Agile and Waterfall.
> Expertise in Querying and testing RDBMS.
> Experience in Data warehouse testing.
> Experience with Mercury Quality center and Rational Clear quest.
> Responsible for Coordination with Business and end users.
> Good knowledge of SQL and Unix commands
> Ability to effectively and professionally interact with internal
customers and all levels of management.
> Strong Communication and writing skills
> Highly motivated and resourceful team player with the ability to work
independently
Technical Skills:
Test Automation Tool: Quality center, QTP 6.5, Rational clear quest.
Languages : SQL, UNIX Shell Scripting C, C++,VB.net, Java
GUI : Visual Basic, Toad, SQL*loader
ETL Tools : Abinitio GDE1.13, Co>op2.13, Informatica.
RDBMS : Oracle 7.0/8.0/9i, SQL Server 7.0
Operating Systems : Windows 95/98/NT/00/XP, UNIX
Citizenship Status: US Citizen
Education: Bachelors in Computer Science and Information technology.
PROFESSIONAL EXPERIENCE
US Army
Aug 09 - June 10
Specialist
. Tested computer system programs
. Identify computer user problems and coordinated to resolve them
. Analyzed, edited, tested and modified computer programs
. Configured information-processing equipment
. Installing software and testing
Environment: SQL Server, Oracle, unix, Microsoft Office Suite (Word,
Excel, PowerPoint),Rational clear quest.
HANOVER INSURANCE Worcester, MA Oct
08 - July 09
Project Description
Project 1: Claims project had lines of business Auto, Property and General
Liability. Claims is for both the first party and third party loss. This
project has different modules First notice of loss, financial, exposure,
Loss details, Salvage, Claims documentations whenever a party is involved
in loss .Policy information for creation of claim is stored in Mainframe
system.
Project 2: Specialty Inland Marine project was developed for various
contractor equipment forms, account creation which are used for issuing
policy, endorsing, Cancel rewrite and reinstatement.
About Hanover
Hanover insurance began in 1852 as a property and Casualty company,
building success and respect over nearly two centuries Underwrites property
and casualty, surety, life insurance and annuity products. It offers wide
range of products through an extensive network of independent agents
Environment: Quality Center, SQL Server,VB.net, Mainframes, Microsoft
Office Suite (Word, Excel, PowerPoint)
Responsibilities:
. Analyzed the Functional and system specification documents and Field
level specification documents and prepared test data.
. Created Test Strategy and Test Plan.
. Completed the test design of various modules for the Claims project.
. Worked on different LOB testing different policies BOP- Business owner
policy, Commercial auto, umbrella and workers compensation policies.
. Wrote detailed test cases for both positive and negative sets of data.
. Conducted test case Walkthrough with the Business analysts and SME's and
received signoff's
. As a test lead validated results of test execution actual vs expected
results.
. Uploaded all test cases in Quality center and involved in the test
execution.
. Reported bugs in Quality center.
. Performed functional, integration, system and regression testing.
. Represent QA team at project meetings to discuss defects, status, testing
impact and provide input during code releases.
. Involved in the end to end and system testing.
. Provided weekend support to meet the deadlines of the project.
. Used Microsoft SQL Server 2005 for Running SQL queries and analysis of
save data and get data issues.
TRAVELERS INSURANCE Hartford, CT Jan
07-Jul 08
Project Description
Quote information warehouse which is a data warehouse that offers quotes to
customers for Line of business Auto and Home. Tested Quote information
warehouse and developed the entire regression test bed for the QIW project,
was also involved in the waves testing and provided weekend testing
support.
About Travelers
Travelers is in business over 150 years and offers a wide variety of
property and casualty insurance and services to businesses, organizations
and individuals in United states and in selected international markets.
Travelers was the first company to issue the first auto policy in 1897.
Environment: Quality Center, SQL Server7.0, Mainframes, Microsoft Office
Suite (Word, Excel, PowerPoint)
Responsibilities:
. Analyzed the Data model and flow of data across the tables.
. Analyzed the Mapping rules document and understood the source to target
mapping.
. Created Test strategy based on project specifications.
. Created Test plans for different waves.
. Prepared application flow document and presented it to the entire team.
. Created test case document and Wrote test cases based on the technical
specification and business requirements document.
. Developed Test data matrix for test cases.
. Developed regression test bed for monthly regression testing.
. Tested the flow of data from source to target.
. Wrote SQL queries for testing the transformation and target tables.
. Executed and updated SQL Queries to ensure that Transactions are working
properly.
. Performed mainframe testing to validate the source
. Used Quality center for writing test cases, executing them and logging
defects.
. Testing Interactive Voice Response (IVR) application.
. Performed testing in different environments Acceptance, Development,
Model office and production.
. Categorized bugs based on the severity and interacted with developers to
resolve them.
. Performed Regression testing after the bugs were fixed
. Extensively used Microsoft Office Suite of products for documentation and
data interpretation.
PHOENIX LIFE INSURANCE Hartford,CT Oct 04
- Dec 06
Project Description
Admin server's phoenix generation universal life insurance application was
developed to offer various life insurance products for creations of policy
and investment of funds, Loans, checking the status of policy and
performing various transactions.
About Phoenix
Phoenix Life Insurance can provide coverage for entire life (as opposed to
a specified term).Permanent life insurance offers tax-defined accumulation
and income tax free death benefit. Universal, variable universal and whole
life insurance are all forms of permanent life insurance.
Environment: Test Director 8.0, J2EE and XML Script, QTP 6.5 Oracle 9i,
Win XP, Microsoft Office Suite (Word, Excel, PowerPoint)
Responsibilities:
. Converted business requirements and design documentation into test design
products: Test Scenarios, Test Cases.
. Involved in developing an Integrated Test Plan covering the main
functions of the designated parts of the application.
. Tested various life products like Term, Variable and universal.
. Executed and updated SQL Queries to ensure that Transactions are working
properly.
. Worked on different interfaces for generation of policies
. Wrote Test Scripts and executed test scripts using QTP.
. Created check points in QTP test scripts.
. Performed System, Integration and Regression testing
. Categorized bugs based on the severity and interacted with developers to
resolve them.
. Used Test Director for reporting defects
. Support User Acceptance Testing (UAT).
Contact this candidate