SUMMARY

• 8 years of progressive experience in IT as a Programmer /QA Analyst. Involved in Manual/Automated Testing, Web Testing, Client - Server and mainframe applications on multiple platforms.
• Experience in testing Health care and Retail (Sterling OMS, POS, Inventory Management and e-Commerce
• Worked closely with the Product Management for the new features, Product Comparison and Product improvement.
• Working knowledge of test methodologies: Agile, Waterfall, Iterative, RUP and RAD.
• Involved in gathering requirements, developing test plans & test cases using spec and design documents while specifying testing overview, approach, strategy, scope, roles and responsibilities.
• Working independently as a team lead and a team member.
• Also supported production on 24/7.Have delivered successfully beyond expectations in all my past projects.
• Have quick learning and effective communication skills.
• Experience of the full Software Development Life Cycle (SDLC) and Methodologies & Validations to ensure the Quality Assurance Control.
• Solid Automation experience in Health Care / Insurance / Financial systems.
• Extensive experience in using Automated Tools like WinRunner, TestDirector, LoadRunner, QuickTestPro, Rational Robot for Client /Server, Web and Database Applications.
• Highly Experienced in writing Data Load Automation Scripts using WinRunner
• Expertise in Analyzing Business Specifications and develop Test Cases and Test Scripts and execute them.
• Extensive experience Functional, Regression, User Acceptance, System, Load & Stress testing and black box testing.
• Experience in writing PL/SQL (Stored Procedures, Triggers, Cursors, Functions) and SQL statements
• Ability to interact with developers and product analysts regarding Testing Status and Defect & Change Tracking using TestDirector, Jira and ClearQuest.
• Expertise in Problem Solving and Tracking Bug Reports using Bug Tracking Tools
• Excellent Team Member with good Communication and Interpersonal skills.

TECHNICAL SKILLS

LANGUAGES: C, ASP, JAVA, JSP, HTML, XML, SQL, PL/SQL, TSL

DATABASE: DB2, AS400, ORACLE, SQL SERVER 7/2000.

WEB / APPLICATION SERVER: IIS 4.0, IBM WEBSPHERE.

SCRIPT: JAVASCRIPT, VBSCRIPT.

GUI: POWERBUILDER, VISUAL BASIC 5.0/6.0.

VERSION CONTROL: RATIONAL CLEARCASE, PVCS

OPERATING SYSTEMS: WINDOWS95/98/8/10NT4.0/2000/XP, UNIX, LINUXERP ORACLE FINANCIALS 10.7 SC, ORACLE APPS 11g

OTHER: MS OFFICE, MS OUTLOOK, VISIO, TOAD, LOTUS

IBM MAINFRAMES: MVS, TSO/ISPF, JCL, VSAM, CICS, IMS, QMF, FILE-AID

IBM MIDRANGE: AS/400, DB2400, RPG

PROFESSIONAL EXPERIENCE

Confidential

Lead QA Analyst

Responsibilities:

• Analyzed business requirements, Functional and Design specifications of the product.
• Conductedrequirement analysisanduse-case analysis.
• Involved in developing detailed test plan, test cases and test scripts for System, Functional, Integration, Regression, Smoke, GUI and User Acceptance Testing.
• Created and executed test cases forSterling Orders, Returns, and Complete Inventory, Inbound and Outboundmodules.
• Created e-commerce orders and shipped usingSterling.
• WrittenTest Plan, Test Casesandexecuted Test Cases using HP Quality Center.
• Performed System, GUI, Regression, Integration, Smoke, Negative Testing and UAT Testing.
• Tested various kinds of Transactions including Cash and Carry, back room sale, Gift Card sale, delivery sales and return Transactions.
• Validated various kinds of Transactions in T log.
• Involved in Testing, store open, store close, and store summary reports.
• Developed automated test scripts from manual test cases for Regression testing based on the requirement documents using QTP.
• Performed Database testing by running the SQL Queries against the Database.
• UsedHP Quality Centerfor thedefect trackingpurpose and discussedseverity leveldefects in the meeting with the project team.
• Participated in QA status meetings on a daily basis.
• Submitted status report to QA Management on a weekly basis.

Environment: e- Commerce, Sterling OMS, WINDSS, .Net, Mainframes, JAVA, J2EE, JSP, EJB, Oracle, HTML, XML, Web sphere MQ Explorer, QTP, HP Quality Center 10.0 & UNIX, soapUI .4.5.0

Confidential

Lead QA Analyst

Responsibilities:

• Helped developers to recreate and track the technical issues.
• Worked in the process of collecting Business Requirement Documents and Functional Requirement Specification. Reviewed requirements, functional specifications and AAAD designs.
• Was identified as Subject matter experts for QA team.
• Wrote and maintained Test Plans, Test Scripts based on the BRFR and AADD document.
• Leading QA team for performing Functional testing which included Requirements, Data Setup and Regression.
• Executed Claims on the RxClaim to verify and validate for the SSG Logic has been implemented in the new system.
• Validated that the new look & feel has been fully incorporated, also confirming that all the existing functionality has not been disrupted with the redesign initiative
• Performed Functional testing and Regression testing.
• Worked on Quality Centre in Planning and executing various Manual scripts.
• Created Data Setup for different types of Claims for testing the SSG functionality.
• Involved in developing, maintaining and running test scripts.
• Performed Test case walkthrough, Test results walkthrough, functional testing for conducting real time scenarios basically for account related transactions.
• Worked on Offshore-Onsite model.
• Provided guidance to Offshore QA team, validating their work.
• Provided daily status reports to CVS using Test Management Workbook.

Environment: AS/400, Sinon, DB2, PL/SQL, and QC 10.0.

Confidential

QA Analyst

Responsibilities:

• Involved in creating Test Plan, Test Scenarios and Test Cases as per System Requirement.
• Involved in doing Manual and Automated testing.
• Involved in performing Functional, Integration, Black Box and System testing.
• Developed and executed automated regression scripts / test scripts using QTP.
• Created QTP scripts for processing the claims and enrolling the members.
• Enrolled members from different applications like 834 Transaction, Portal application, Legacy application and Facets front end screens and verified members loaded correctly to Facets by running SQL queries.
• Processed 837 claim Transactions and verified whether they successfully loaded to Facets.
• Tested the Member, claims conversion process from Legacy to Facets.
• Tested the Integration between Facets and Portals.
• Created Groups, plans and enrolled members in Facets.
• Generated SQL queries to pull the member data, claims data from Facets member and claim tables.
• Tested the HIPAA EDI Transactions 837/835, 834, 270/271 and 276/277.
• Involved in the team meetings to discuss the issues and problems
• Tested all types of the Provider Claims in Facets.
• Involved in writing SQL queries in AS400 to validate the payment files.

Environment: Win Runner, QTP, Test Director, AS-400, PL/SQL and Jira

Confidential

QA Analyst

Responsibilities:

• Reviewed the application’s Specifications, and then built test cases and scripts for system testing through acceptance testing.
• Involved in doing Manual and Automated testing.
• Involved in performing Functional, Integration, Black Box and System testing.
• Developed and executed automated regression scripts / test scripts using QTP.
• Created QTP scripts for processing the claims and enrolling the members.
• Enrolled members from different applications like 834 Transaction, Portal application, Legacy application and Facets front end screens and verified members loaded correctly to Facets by running SQL queries.
• Processed 837 claim Transactions and verified whether they successfully loaded to Facets.
• Tested the Member, claims conversion process from Legacy to Facets.
• Tested the Integration between Facets and Portals.
• Created Groups, plans and enrolled members in Facets.
• Generated SQL queries to pull the member data, claims data from Facets member and claim tables
• Tested the HIPAA EDI Transactions 837/835, 834, 270/271 and 276/277.
• Involved in the team meetings to discuss the issues and problems
• Tested all types of the Provider Claims in Facets.
• Involved in writing SQL queries in AS400 to validate the payment files.
• Involved in generating complex SQL queries in AS400 to validate the extracts, loads and reports.
• Involved in doing extensive database testing for various reports, loads and extract processes validations.
• Executed UNIX commands to view the extracted files in UNIX.
• Ran workflows (it contains sessions) using Informatica workflow manager.
• Checked the workflow status on the workflow monitor like successful & fail.
• Validated data on Oracle tables, flat files-on the UNIX server after the workflow successful.
• Generated SQL queries in Oracle to validate the loads and extracts.
• Worked on Facets to pull the Eligibility information.
• Reported software defects in Quality Center and interacted with the developers to resolve technical issues.

Environment: WinRunner, QTP, Test Director, Visual Basic 5.0/6.0, SQL Server 7.0, Tibco, IBM Mainframe, DB2, QMF, AS400, TSO/ISPF, JCL, CICS, MVS, OS/390,Cobol, File-Aid, Extra Attachmate 6.4, IBM Websphere, Java, JSP, J2EE, Java Script, Quality Center, SQL, AS400, Manual Testing, Windows NT and MS Office Products.

Confidential

QA Analyst/Tester

Responsibilities:

• Involved in creating Test Plan as per System Requirement.
• Involved in various meetings with Business Analysts and Updated Business requirement.
• Performed Functional, Black Box and System testing.
• Prepared Test data to enable the software to be quality checked.
• Involved in writing Test cases using Test Manager by following the Use cases developed in Requisite Pro.
• Tested the HIPAA EDI Transactions 837/835 and 276/277 also worked on Medicare Claims.
• Involved in doing automation using SQA Robot.
• Created Data Driven Tests to process different sets of claims using SQA Robot.
• Reported software defects in Clear Quest and interacted with the developers to resolve technical issues.
• Involved in doing extensive database testing for various reports, loads and extract processes validations.
• Generated SQL queries to validate various reports, loads and extract processes.
• Involved in testing the integration between Claims application and other applications like Providers, Eligibility and Member Services application.
• Involved in testing the integration between the Pharmacy Claims application and other applications like
• Providers, Drugs, Eligibility and Member Client Services applications.
• Involved in loading the flat files into Oracle Database and involved in writing Complex SQL Queries.Involved in generating Reports using Oracle Report Builder and testing the reports using Oracle Run Time.
• Generated and validated various reports like Clinical, Tier Plan, Eligibility and Financial reports for the Pharmacy System.
• Involved in writing Complex SQL Queries in AS400 to validate the loads for Caremark and DEA.
• Involved in writing UNIX shell scripts.
• Wrote a whole bunch of PL/SQL code including stored procedures, functions and triggers using TOAD.

Environment: Visual Basic, ASP, Java Script, VB Script, XML, Cobol, CICS, TSO/ISPF, QMF, Oracle 11i, DB2, SQL, AS400, MS Access, UNIX, Oracle Run Time, IAS Webserver, Weblogic, BEA Tuxedo, Windows95/98/NT/2000/XP, Internet Explorer, SQA Robot, Test Manager, Requisite Pro and Clear Quest.