EXPERIENCE SUMMARY:

• 7+ years of experience in Quality Assurance testing for all stages of Software Development Life Cycle (SDLC) in SOA, WEB based and Client/Server applications for Health/Life/ Financials, Banking, Mortgage sectors& Pharma sectors.
• Extensive experience in Quality Assurance using Testing methods for both Manual and Automation tests with all phases of Software Development Life Cycle (SDLC) in Requirements gathering, Analysis, Design, Development, Implementation, Testing, Production & Maintenance Methods using Waterfall, RUP, Agile and V - Models.
• Excellent working knowledge of designing & implementation for developing Test Plans, Test Scenarios, Test Case, Test Strategies, Test Scripts, Test Procedures as per Testing Standards.
• Excellent testing experience in all phases and stages with good working knowledge on Testing Disciplines, Testing Principals and Testing Matrices on various types of industries and proficient in designing Test Scenarios and Traceability Matrix.
• Experience in Integration Testing, System Testing, Functional Testing, Regression Testing, GUI Testing, Unit Testing, Smoke Testing, Performance Testing, Load and Stress Testing, Security Testing, User Acceptance Testing (UAT) and Production Support.
• Excellent working knowledge on test design, test development and implementation of test procedures for Web based, Client/Server (Internet & Intranet) using Java, J2EE, VB, ASP, AJAX, .Net and PEGA-PRPC BRE, BPM applications on Windows, UNIX and CICS screens for Mainframe systems.
• Experience in Configuration Management, Bug-Reporting & Bug-Tracking Tools for Business Software’s and web applications.
• Experience in various dimensions of testing including CIT, SIT, Black Box, White Box, Grey Box, User Interface, Database, XML, End to End, Usability, and Reliability Testing’s and Knowledge on ISO, CMM and Six Sigma Standards.

TECHNICAL SKILLS:

Operating Systems: Windows NT/95/98/2000/XP, MS-DOS and UNIX.

Testing Tools: HP/Mercury Quick Test Pro (QTP)9.0/10.0,QualityCenter 8.2/9.0/9.2/10.0, Test Director 7.6/8.0, Rational Requisite Pro, Test Manager, Clear Quest, Clear Case.

Prog Languages: C, C++, Java, Pascal, COBOL, SQL & PL/SQL.

Databases: Oracle 10g/ 9i / 8i / 7.3, Ms Access, SQL Server 2000 & 2005, DB2.

Graphic User Interfaces: Dev-2000, Visual Basic 6.0.

Web Technologies: HTML, DHTML, XML, JSP, J2EE, ASP.NET, VB. NET, AJAX.

Scripting Languages: Java Script, VB Script and Shell Script.

Web/App Servers: IIS, WebLogic, WebSphere, Apache, Tomcat, ATG Dynamo 6.0.

ETL & Reporting Tools: Informatica, Datastage, Crystal Reports, Business objects, Cognos.

Other Tools: MQ, Toad, SQL*Plus, SQL Developer, Command editor, Control Center, Ultra Edit, WinSCP, PVCS, Ms-Visio, Altova-XMLSpy, EDI Editor

.PROFESSIONAL EXPERIENCE:

Confidential, Schenectady, NY

Sr. EDI QA Analyst

Responsibilities:

• Developed Test plans, Test cases and Test Scripts using ALM (Application Life cycle Management).
• Participated in Business Analysis, Requirement Analysis and Data Analysis.
• Developed Test Plan and overall Test Strategy for teh program.
• Developed Test Cases and Test Scripts for System and Regression Testing.
• Tested teh following modules of teh FACETS application as part of an upgrade from version 4.5 to 5.0
• Subscriber/Family
• Group/Subgroup and Member
• Claims processing
• Tested teh loading of claims data into Facets from Mainframes System.
• Developed XML Data Files and XML Test Files.
• Tested Web services using J meter.
• Created ANSI X12/EDI 5010 transactions, Processed them via EDIFECS spec builder for format and validated teh EDI transactions for (837 I,P &D,834,270/271)
• Tested 837I inpatient primary claim, Secondary claim, Med A crossover with inpatient & outpatient claim, 837I file with outpatient primary & secondary claim.
• Created 837 files that will adequately test for changes and cover regression that will be needed to address any 4010-5010 differences on teh remittance side (BET testing)
• Validated teh data by using SQL Developer extensively.
• Tracked defects using ALM & Conducted Bug-Review meetings.

Environment: Windows 2000, Office 2003, TriZetto Facets 4.51 to 5.0, Mainframes, TSO/ISPF, VSAM, File-AID, JCL/Proc, ALM, QTP, J2EE, Java script, XML, PL/SQL, Web logic.

Confidential, Seattle, WA

Sr. EDI/Facets QA Analyst

Responsibilities:

• Participated in Requirement Analysis, Business Analysis, Design Analysis and Gap Analysis.
• Developed Test Plans, Test Cases, Test Scripts, Test Scenarios, Test Beds and Traceability Matrix.
• Conducted Integration, System, Functional, GUI, Regression, Smoke, Database Integrity, User-Acceptance (UAT) .
• Test case management using Rational Test Manager / Rational Manual Tester
• Conducted Functional, Regression and Integration Testing using Rational Functional Tester.
• Automated teh scripts using Rational Functional Tester.
• Tested teh provider, Members in Facets (4.71 / 4.81).
• Performed End-to-End testing for Facets upgradation from Ver. 4.71 to 4.81.
• Created Claims for Medical, Hospital and Dental Claims Processing.
• Compared and Validated teh Reports between Facets 4.71 and 4.81.
• Tested ANSI X12 4010A EDI transactions (270, 271, 834, 835, 837, 276, 277, 278, 997)
• Created Traceability between Requirements and Test Cases.
• Tracked teh defects using Rational Clear Quest and generated defect summary reports.

Environment - Facets 4.71/4.81, Rational Manual Tester, Rational Clear Quest, Oracle 10G, Mainframes (Cobol, DB2, JCL, CICS, MVS, OS/390, QMF, SPUFI, File-Aid, TSO/ISPF), Microsoft Word, Excel, MS Visio.

Confidential

SOA/Web Tester

Responsibilities

• Reviewed Specified Business Documents and prepared Test Cases in Mercury Quality
• Center based on Use-Cases and Requirements, and executed Test scripts to verify actual
• results against expected results
• Created Test Cases in Quality Center and mapped Test Cases to Requirements.
• Developed Tractability Matrix and Test Coverage reports.
• Involved in System Testing, Functional Testing and Regression testing.
• Extensively worked with XML, SOA, WSDL, and SOAP Services.
• Developed XML test files based on XML schema.
• Generated XML data files using XML Spy.
• Validated teh Web Services (SOAP), both Request and Response messages.
• Validated teh protocols ( HTTP and HTTPS)
• Involved in working with XML files and XSD files.
• Extensively used Quality Center for Defect management.
• Extensively used SQL queries for validating data integrity.
• Actively participated with User groups to perform extensive User Acceptance Test.
• Provided teh management with Test metrics, Reports, and schedules as necessary and
• participated in teh design walkthroughs and meetings.
• Conducted Regression Testing based on priority, business importance and failure rate.
• Worked with business analysts, developers, and content department to resolve issues.

Environment: Java, J2EE, ASP.Net, XML, SOA, SOAP, SOAP UI, WSDL, Mainframes, Web Sphere, Mercury Quality Center 9.2, TIBCO, UNIX, Win XP, MS-office.

Confidential, San Ramon, CA

ETL QA Analyst

Responsibilities:

• Worked with project team (Scrum team) to plan testing, provide estimates, attend requirement/design meeting to understand project and testing scope.
• Developed Test Cases for ETL/ Data warehouse changes based on technical specifications and Mapping documents
• Involved in functional, system, regression, and Integration testing
• Ran Informatica workflows & sessions from teh Informatica workflow manager and captured teh run time.
• Extensively used TOAD to verify source data and target data after teh successful workflow runs using SQL
• Verified data loads between external files to DSL tables, DSL to Dimensional Tables, Fact Tables
• Developed complex queries by joining different Dimensional tables to Fact tables and retrieved teh data from source and validated teh data against ODW.
• Involved in writing complex SQL queries by combing data from multiple tables with various filters
• Validated Informatica extraction, transformation and loading process by writing SQL against Business rules.
• Verified record counts, column data types, column values, exceptional handling and SCD1 & SCD2 functionality
• Performed detailed requirement analysis, developed and maintained requirements traceability using in Test Management tool - Quality Center.
• Prepared Master Detailed ETL (Informatica) and BI Test Plan for teh entire Project.
• Performed End-to-End testing for teh entire ETL and Business Intelligence.
• Extensively involved with ETL Informatica Mappings and teh testing of Cognos reports.
• Verified teh data extracted from source and target tables to validate Informatica ETL process.
• Tested and validated teh ETL mappings in accordance with teh business rules.
• Focused on Data Quality issues / problems that include completeness, conformity, consistency, accuracy, duplicates, and integrity.
• Extensively involved with backend testing by writing complex SQL queries.
• Worked closely with business analyst and development group during teh requirement phase and design phase to find out functional incompatibilities and software issues early in teh QA process.
• Verified source systems, connectivity, tables, and fields, ensure data suitability mapped as per teh Informatica mapping specifications.

Environment: Informatica Power Center, Oracle 10g, SQL Server 2008 R2, Windows 7, UNIX, Shell Scripts, Flat Files, SQL, PL/SQL, ALM, Cognos, TIDAL, Control-M and TOAD.

Confidential

QA Tester

Responsibilities:

• Involved in writing backend procedures, using PL/SQL that would load and retrieve data from teh database.
• Involved in writing and implementation of teh various test cases and test scripts.
• Performed manual testing.
• Analyzed and documented detailed program information after working and interacting with software developers and members of various other dependent departments.
• Created UNIX shell scripts to perform repeated tests.
• Analyzing User and Functional requirements to point out gaps between them and teh application.
• Used MS-Excel for bug tracking and reporting, also followed up with development team to verify bug fixes, and update bug status.
• Documented bugs found out during teh process of testing.
• Reported periodic project status and updates to teh QA Lead and QA Manager.
• Wrote SQL & PL/SQL queries for data validation.

Environment: Windows NT, Oracle7.0, SQL, VB 5.0, UNIX shell Scripts, MS- Office.