Quality Assurance Insurance
Resume:
Madhavi Omkar
***********@*****.***
Summary:
. Over 7+years of experience in Software Quality Assurance, Software
Testing.
. Extensively worked on end-user requirements, analysis, systems study and
implementation.
. Specialized in user requirement analysis, documenting test plans,
execution of test cases.
. Experienced in documenting Test Plan, Test Objectives, Test Strategies,
Test Scripts, Test Scenarios and Test Cases.
. Verified application functionality against business requirements,
manually and by using Win Runner.
. Experience with structured QA Methodology and QA Process to ensure the
Quality Assurance Control.
. Extensive experience in working with SQL Server, Oracle 9i and DB2
Databases.
. Performed backend testing using TOAD.
. Experience generation VB scripts in using QTP.
. Strong experience in Capacity planning, load test Configuration.
. Performed Load and Stress tests using Load Runner in Web Protocols,
Database Protocols & Java Protocols.
. Expertise in Black Box, Sanity/Smoke, Integration Regression,
Performance/ Load/Stress, System and Functional Testing.
. Strong Expertise in Banking, Financial and Insurance Domain.
. Strong experience in Quality Assurance of multi-tier systems,
Client/server systems and Web Applications/Sites including testing large
enterprise software applications.
. Familiar with back end testing using SQL queries, generating reports to
ensure data integrity and validation in business rules.
. Excellent team player with strong written, communication, interpersonal
and analytical skills.
Technical Skills:
Testing Tools Win Runner 7.0/7.6, TestDirector7.8, Load Runner
8.1, IBM DB2 Tool and Quality Center10.0,
QTP9.4.
Operating Systems Windows XP, Unix (Solaris).
Languages Java, C++,J2EE, SQL, PL/SQL, COBOL
Database Oracle 11i, DB2, SQL Server & Microsoft Access.
GUI Tools Visual Basic 5.0/6.0, Developer 2000, Crystal
reports
App. Servers Web Sphere 5.0/6.0
Version Control Rational Clear Case, Clear Quest
Scripting Languages Java Script, VB Script and TSL.
Web Browsers Netscape Navigator 3.1,Internet Explorer 6.0/7,
Mozilla Fire fox 1.5
Office Suits MS-Excel, MS-PowerPoint, MS-Access, and MS-Word.
Education and Certifications:
. Master's in Computer Application.
. Sun Certified System Administrator (SCSA 10)
Professional Summary:
Client: KPMG, Montvale, NJ
Project: Sentinel
Role: QA Tester
Nov 08 -Date
Sentinel is a secure online application developed to assist KPMG member
firms in complying with legal and regulatory independence requirements
related to the provision of services and in identifying potential conflicts
of interest with proposed engagements and managing them.
Sentinel checks every Request to provide services to a client in order to
identify existing Requests to provide services and key relationships
recorded in Sentinel that may give rise to a potential business or
Objectivity Conflict of Interest. A Conflict of Interest is a circumstance
or situation that has, or may be perceived by a fully informed reasonable
observer to have, an impact on a KPMG firm or its personnel in their
ability to perform objectively or otherwise act without bias.
Responsibilities:
. Created test plan by analyzing the Business Requirements Documents.
. The tracking, executing and scheduling of test cases was done using
Quality Center.
. Implemented changes to software development lifecycles (SDLC) by moving
test case development into the HP Quality Center software tool, from MS
Excel, Word, and other manual methods.
. Implemented Service Oriented Methodology (SOA) and Agile for testing the
new application.
. Performed regression testing for the application and maintained a
database of regression Scripts using QTP.
. Developing a High Level Scenarios for the application in Quality Center.
. Developing and execution of manual test scripts for the application in
Quality Center.
. Prepared automation testing status documents, status reports & daily
defect status documents for management.
. Developed SQL queries to retrieve data from Oracle database..
. Traceability Matrix was used to trace the requirements from Business
requirements to design document to QA test scripts.
Environment: HP Quality Center10.0, HTML, SQL, MS SQL Server,, DB2,,JAVA/J2EE, UNIX, Windows XP/2000, MS Excel, MS Word, QTP9.4 .
Merrill Lynch, Hopewell, NJ Prometheus- Benefits
Online Application
Role: QA Tester
June 2006- To Sep 2008
Benefits Online Application is a complete Retirement package consisting of
subsystems such as 401(K), Non Qualified plans, Defined Benefits, EXSOP and
ESPP. This application enables the participant and plan sponsors to access
their accounts through web enabled BOL application by entering their user
id and password. The Application is divided into different Applications
based on the User Level. The User Levels are categorized into Participant,
System Administrator, and Developer etc. The Account balance comes from
various sources depending on the various accounts held by the participant.
The Home page displays the content generated by the Content Management
System (CMS). The Plan Sponsor information is stored in Oracle database and
the Participant information is stored in mainframe.
Responsibilities:
. Involved in preparing test plans based on Business Requirements Document
(BRD)
. Developed exhaustive Test Cases and Test Scripts for the Requirements
. Developed Use cases as per the Requirements.
. Performed Functional, Integration, System, Regression, Performance, White
and Black Box Testing.
. Analyzed the Business and System Requirements for various modules of the
application
. Made extensive use of Performance testing tool Load Runner for building
and executing scripts.
. Used Quick3270 Emulator for Mainframe Access.
. Implemented Service Oriented Methodology (SOA) and Agile for testing the
new application.
. Made extensive use of MS Office tools to create and maintain documents
such as test plans, test execution and test results documents.
. Enhanced and modified the scripts according to the test case scenarios
. Developed SQL queries to retrieve data from Oracle database.
. Performed regression testing for the application and maintained a
database of regression Scripts using QTP.
. Performed Cross browser testing for multiple browsers, e.g., Safari,
Microsoft Explorer, and Firefox on different platforms (Windows & UNIX)
interpreted the negative/positive results.
. Used Quality Center for Bug Tracking.
. Reported the status of the testing of the application to the upper
management in regular intervals.
. Reviewed and retrieved details of Participant's from Mainframe.
Environment: Java, HTML, SQL, DB2, Oracle, QTP9.4, Web Setup, IE 6.0,
Windows NT HP Quality Center.J2EE,
State Farm Insurance, Bloomington, IL
Payroll Automation System (PAS)
Role: QA Analyst Jan 2005 - May 2006
State Farm Insurance is one of the largest insurance companies serving
people all over America. Payroll automation system was an in-house product
that was developed to automate the functions and activities of employee's
services. The main application gets executed at the Head-office and
networked to every Corporate and City office such that they had real time
access to the application remotely. This application was used to maintain
employee information, calculate the number of hours worked by an employee,
deduct taxes, track sick leaves and vacation days and keep up to date with
tax law changes. This software consists of four modules i.e. employee's pay
information, sick and vacation days, tax information and
allowances/deductions. I was involved in System testing of the project. The
application was developed in two-tier architecture. Obtain rate quotes for
life products including term, whole and and health products including
supplement and hospital income. Save, retrieve and compare rate quotes.
Submit application information for auto property, life and policies. Submit
online claims for auto and property policies. View and changes policy
details and request policy related documents.
Responsibilities
. Analyzed the requirements and Developed Test Cases
. Coordinated and executed assembly or product tests with the Test Team,
Application Team and the Program Manager.
. Defined product test plans and the criteria for acceptance.
. Developed and executed SQL queries to perform back-end testing
. Developed, Updated, and maintained testing standards and procedures.
. Resolved testing process questions / issues.
. Assisted in the planning, creation, and control of the test environments.
. Involved in writing and implementation of the test plan and developed
test cases and test script.
. Compared actual & expected results using multiple checkpoints like GUI,
text, bitmap & database.
. Performed work allocation, resolving the issues, coordinating with Onsite
/Offshore Team members.
. Worked with the management and technical teams to resolve the issues
related to testing environment.
. Created Scenarios using Load Runner Controller.
Environment: Windows 2000, TOAD, J2EE, XML, Web Sphere, Microsoft Office,
Unix, QTP, Quality center. HP Load Runner.
Sprint, Kansas City, KS Customer Online
Billing System (COBS)
Role: QA Tester Jan 2004- Dec 2004
Customer Online Billing System (COBS) is a Web based application running on
Oracle database. It is used to generate the Customer bills based on their
billing Cycle date, Retrieve billing history, View transactions of Customer
etc., which will be published on internet for on line viewing by the
customers. The system also generates the comprehensive reports of revenue
generation for each region, market and for each product like Long distance,
DIAL/DSL etc., for internal sales planning.
Responsibilities
. Analyzed business requirements document and developed test plan, test
objectives, test strategies, test priorities, test cases etc.
. Prepared pre-conditioned data for testing the application.
. Performed Cross browser testing for multiple browsers, e.g., Netscape
Navigator, Microsoft Explorer on different platforms (Windows & UNIX) and
interpreted the negative/positive results.
. Developed detailed Test Plan and Test Cases for Testing the Application.
. Tested the application manually by executing Test Cases prior to
Automation.
. Involved in functional testing using manually.
. Wrote and modified required and other, and writing scripts in SQL/PLSQL
to validate the outputs
. Developed user defined functions using for testing customer and billing
data with data base and validating the conditions.
. Developed SQL commands to do the Backend Testing.
. Executed the Test Cases Manually and reported the defects using
. Involved in system integration and validation of populated data.
. Prepared test data for positive and negative test scenarios for
functional testing as documented in the test plan.
. Involved in Load Test Planning using Task Distribution Diagram,
Transaction Profile Documents.
. Created Scenarios using Load Runner Controller.
. Responsible for validating account and premium summary reports whether
they are pulling correct data in SQL generated report
. Monitored various scenarios using Web Server Resource, Web Application
Server, Database Server and Network Monitors.
. Conducted Functional Testing on various builds of the application and
reported the defects to the developers using a Customized EXCEL
Spreadsheet utility for the bug reporting and tracking.
. Involved in weekly status updates showing the progress of the manual
testing.
Environment: Java, HTML, UNIX, Oracle, Windows NT, Load Runner.
C S Informatics Ltd., Pune, India Insurance Processing System
(IPS)
Role QA Tester Feb 2002 - Nov 2003
Insurance Processing system (IPS) is designed keeping in mind the Indian
population and its need on the insurance segment. The object of the project
is to provide an efficient environment to reduce the time and the man power
of the insurance company. Insurance company is providing different
insurance coverage with different plans and insured term values. It suits
to all the middle level and high level insurance companies and individuals
across the country. This software solution performs its acts and duties in
an accurate and perfect manner. Company is consistently and effectively
observing the transaction done by the agents without their physical
presence with the every insured individual. The company is comfortable to
operate each policy being at one place. IPS consists of existing system,
proposed system advantages of speed and accuracy in Automation. IPS support
the following sectors 1) Life Insurance 2) Industrial Insurance sector 3)
Motor vehicle Insurance 4) Electric Appliance Insurance.
Responsibilities:
. Involved in writing and executing software System test plans and Test
cases.
. Involved in writing of Modification Reports for Errors Identified in
Testing and clearly communicate with development via defect tracking
database
. Analyzed system requirements and created test plan and test cases that
would verify the functionality aspects of the application.
. Develop and Execute automated test scripts using Win Runner
. Extensively used Win Runner to test the performance of the Web and other
applications
. Performed manual Integration, Functional, UAT and Regression testing.
. Documented the results of system functional testing onto the report
database.
. Involved in Database testing using SQL Queries
. Carried out Functional, Integration, System, Load and Performance Testing
. Prepared status summary reports with details of executed, passed and
failed test cases.
. Performed User Acceptance Test (UAT) for various applications with
documented procedures and result
. Worked on preparing reports for the use of management on the project and
test cases.
Environment: Win Runner 7.0, Test Director 7.0, Windows NT, JSP, Java, J2EE
& XML
Contact this candidate