PROFILE: About 7 years experience in Software Quality Assurance on Web Based, Client Sever and Mainframe applications. Expertise in Manual and Automated testing. Comprehensive understanding of SDLC and methodologies. Proven track record in understanding, analyzing, and testing business requirements.

Summary

• Worked on various projects across Banking / Finance, Insurance, and Healthcare domains
• Followed Agile, RUP & Waterfall methodologies for software development
• Tested User Interfaces, ETL processes, and Databases
• Performed functional and non functional testing
• Involved in Regression, Performance, and User Acceptance testing
• Analyzed business requirements to make sure that each requirement is testable
• Interacted with various project teams to exchange information and resolve issues
• Executed test plans, test cases, test scenarios, test data and test metrics
• Executed automated test scripts using QTP and Load Runner
• Analyzed QTP scripts execution results at various check points (expected vs actual)
• Used Mercury Quality Center to manage test cases and defects
• Created test plans, test cases, test scenarios and test data
• Wrote SQL queries to understand and test backend data
• Produced traceability matrix to map business and functional requirements to test cases
• Identified functional modules for automation and produced test scripts
• Possess strong analytical and problem solving skills
• Facilitated weekly status calls, produce status reports, and ensured smooth signoff

Skills:

Oracle 9i/10i/11i, MS Access, SQL Server7.0, Sybase,DB2, MS SQL ,RDBMS

Testing Tools:

Test Director/Quality Center, Win Runner, Load Runner, Rational Clear quest, Rational Test Manager, Rational Requisite Pro ,QTP

Other Tools:

MS Office (Word, Excel, Powerpoint, & Access), MS Visio

Operating systems:

MS Windows all Versions , UNIX , SUN Solaris , MAC OSX

Web technologies:

HTML, XML, XTML, Java Script, ASP, JSP, .NET Servlet

Browsers:

Netscape Navigator, Internet Explorer, and Firefox

Certifications and Training

• Trained by Mercury Quality Center (QC)
• Trained by Oracle 9i
• Trained by HP QTP

PROFESSIONAL EXPERIENCE
Confidential,Columbus, OH
QA Analyst Aug 11 – Present
Confidential,provides different types of products like Home and Auto Insurance. They specialize in Home Insurance products with customizable coverage options. The project involved validating new products, testing enhancements to existing products, user interfaces, and testing interface between front end and the policy admin system (Main Frame AS - 400)
Responsibilities:

• Attended requirement review session to make sure that each requirement is testable
• Created functional and regression test scenarios, test cases, and test data
• Performed manual testing and automation testing (regression and performance)
• Worked with business analyst to create traversal scripts and test criteria for regression and performance automation using QTP
• Wrote SQL queries to validate data load and retrieve existing policy info for expected test results
• Interacted with cross functional teams (Business Analysts, Developers, and DBAs)
• Validate field mappings, interface feeds, end to end functionality, and business rules
• Validated ACORD (80, 85,90) standards for XML transactions
• Managed defects (logged, tracked, and closed) using Squish
• Worked with new hires giving them knowledge transfer and assigning tasks
• Maintained good relationship with business and other technology teams

Environment: Windows XP, Squish, QTP, Mainframe AS-400, JAVA, Oracle

Confidential,Des Moines, IA Nov10- july11
Quality Assurance Analyst
This project involved configuring IBM – Enterprise Service Bus as the middleware between various Aviva’s internal and external systems, including their Policy Admin System (Oracle IPAS). Implementation followed SOA – Service Oriented Architecture to support data transfer and service sharing between these systems.
Responsibilities:

• Attended requirements review sessions to make sure requirements are complete and testable
• Produced deliverables like test plans, test cases, test data from business/functional requirements document
• Executed test scripts (SIT, UAT, PROD Checkout) and managed defects using Quality Center
• Tested input/output files (xml, .csv, flat), validating data quality and business rules supporting ETL
• Created sample files to use them expected results for testing efforts
• Identified modules for automation and implemented automation testing using QTP
• Executed test scripts to automate policy creation for regression and performance testing
• Wrote SQL queries to perform backend testing on loaded data
• Used ACCORD standards to test XML files
• Facilitated daily status calls and produced status reports
• Supported technology and business checkouts

Environment: Windows XP, Quality Center 9.2, QTP, ACCORD, XML, Websphere, Oracle, VB, Java

Confidential,Annapolis, MD Aug 09- Sep 10
Quality Assurance Analyst
This project involved enhancing MAIF’s (Maryland Automobile Insurance Fund) Claims Management System to integrate with their Policy Management System, generate email notifications, and produce client letters. In included validating claim information against policy information and handling other regulations.
Responsibilities:

• Reviewed Business and Functional Requirements and analyzed them to come up with test plan
• Produced Test scenarios, Test cases, and Test data interpreting functional requirements
• Automated the process of policy/claim creation for scenario testing during UAT and regression testing
• Managed test cases, test results, and defects using Quality Center
• Worked with development team to communicate, track, retest, and close defects
• Wrote SQL queries to validate data load into backend tables
• Acted as a point of contact for defect status & resolution for Development team, QA team and business.
• Maintained test metrics and produced daily status reports
• Coordinated SIT and User Acceptance Testing by organizing daily status calls

Environment: Windows NT4.0, Quality Center, QTP, Rational Functional Tester (RFT), UNIX, Java, HTML, DB2, Microsoft Excel, MS Word, Internet Explorer 5.0.
Confidential,IA Sep 08- Jul 09
Financial Institution (DTCC)
QA Analyst
This project involved building an application that supports new business to Aviva via Financial Institution channel. The channel supports the automation of various business activities – New Policy Issue, Initial Premium/Subsequent Premium Payment, Commission Payment, Financial Reporting, Policy Values, and Internal Reporting. DTCC, through its subsidiaries, provides clearing, settlement and information services for various financial instruments. It also supports insurance transactions.
Responsibilities:

• Understood the functional requirement document and created test scenarios, test cases, and test data
• Created manual test plans to validate straight through processing (STP) of an insurance policy
• Attended requirements review sessions to make sure requirements are complete and testable
• Developed automated scripts using Quick Test Professional to perform functional and regression testing.
• Inserted Bitmap and Text checkpoints where needed, to compare the current behavior of the application using Quick Test Pro (QTP).
• Parameterized the fixed values in checkpoint statements, created data tables for the parameters and wrote

functions for the parameters to read new data from the table upon each iteration – Performed Data-driven testing using Quick Test Pro

• Analyzed QTP scripts execution results at various check points (expected vs actual)
• Managed (logged, assigned, tracked, and closed) defects using Quality Center
• Created sample xml files using ACCORD standards
• Organized defect status calls, produced weekly status reports, and ensured smooth signoff

Environment & Tools: Windows XP, QTP 9.0, QC 9.1, Win runner, XML, Websphere, Oracle

Confidential,Phoenix, AZ Nov 07- Sep 08
Quality Assurance Analyst

Project 1: Involved in Testing Pharmacy/Healthcare applications for Wolters Kluwer Health, this application contains different work streams like dimension, drug, payer, claims, Fact and HCE.
Project 2: The creation and maintenance of a metadata repository that contains information about the location of Protected Health Information (PHI) and data elements protected under vendor contracts, and includes information about who has access to this sensitive information.
Responsibilities:

• Involved in Preparing Test plan as per Agile standards and Guidelines
• Used Quality Center to prepare Test cases, procedures and Requirements Tractability Matrix
• Generated the detailed reports of the Defects/Bugs, Pass-Fail report and Assigned defects using Quality center
• Interacted with Business users, SME (Subject matter experts) and Technical Analysts in providing clear solutions

to requirements.

• Involved in defining, planning and conducting QA reviews
• Wrote SQL queries to understand and test backend data
• Responsible for designing, developing test plans and executing test scripts.
• Involved in testing HIPAA EDI, PHI Data Transactions
• Worked on various EDI X12 transaction sets 837 I/P, 275/276, 270/271, 834 etc
• Tested Various levels of FDA regulatory and HIPPA Rules
• Tested based on rules that are shared across applications and organizational boundaries
• Used Load runner as performance tool for load and performance testing

Environment: Data Stages, java, Java Script, File-Aid, Oracle 11i, PL/SQL, UNIX, J Boss, Windows98/NT/2000/XP,UNIX, QTP, Win runner, Quality Center

Confidential,India Jul 05– Aug 07
QA tester
This is a web-based single sign-on (SSO) application that interacts with various back-end systems like Credit reporting system, Accounting System etc. This application allows customers to login to their account, check the balance, make payments, apply for loans etc. Since this is a single sign-on application the loan officers has flexibility to access different back-end systems to process the application.

Responsibilities:

• Involved in Planning, Coordinating, Developing Test plans, Test Procedures, Test cases and Test Matrices based on the Requirements and Design Documents
• Used Quality Center to create and maintain the Test cases and the Test scripts for both System Testing and Regression Testing
• Extensively used Quality Center for reporting and categorized the bugs based on severity
• Developed scripts using Automated Testing tool QTP for Functional testing and Regression Testing
• Analyzed Test results to meet the end user needs
• Involved in loading of Test Data into Oracle Database using SQL LOADER in Test environment
• Conducted the System Integration testing of the application manually for different Modules

Environment: Windows XP,QC 9.0 ,SQL LOADER, Java , QTP,VB Script.

Education:
Bachelor of Technology, Computer Science