SUMMARY

• 6+ years experienced IT Professional with diverse experience in Software Quality Assurance.
• Performed extensive Backend Testing of the applications using SQL Queries.
• Strong in Analyzing Business specifications and expertise in developing Test Plan, Test Scripts and Test Cases.
• Experienced in creating Test Plans, thorough hands on experience with designing test cases covering all test conditions and eliminating redundancy and duplications.
• Extensively involved in Performance Testing, Load Testing, and Stress Testing.
• Experienced in Data Driven Testing, Batch Testing, Functionality Testing GUI Testing, Regression Testing.
• I have used Microsoft Visual source safe for version control
• Well versed in using Defect Tracking Tools including Mercury Quality Center and Test Director.
• Created Test schedules, Test Scenarios, Test Strategy, Test Plan, Test Cases, test summary report, defect tracking documents.
• Experience in creating and maintaining Requirements definition documents that included Business requirements and Functional requirements.
• Managing reporting, analysis and decision - making for a change request using tools like Clear Quest and Excel.
• Used Rational Clear Case extensively for change management and to maintain history of source codes and builds.
• Extensive expertise in SQL for Back End Testing.
• Used Load Runner 9.2 to conduct performance testing.
• I have used Defect tracking and CMS using Clear Quest
• Worked on applications that used Claims Processing system.
• Performed functional and load testing using IBM Rational Performance tester.
• Understanding of Medicare, Medicaid services and Enrollment system.
• Exclusively used Security Testing, Usability Testing, Positive Testing, and System Testing.
• Experience in HIPAA EDI transactions 837,835, 834
• Highly skilled and experienced in managing SDLC, software testing lifecycle and quality assessment.
• Extensive experience in Unit, Functional, Integration, Regression, User Acceptance, System, Load and Stress Testing.

TECHNICAL SKILLS

Test Tools: Load Runner, Quick Test Pro, Clear Quest

Test Reporting Tools: Quality Center, Test Director

Testing Languages: Unix, SQL

Languages: C, Borland C++ builder, Visual Basic, Java, XML, XPath

Operating System: Windows 95/98/NT/2000/XP, UNIX

Databases: SQL, MS - Access

Methodologies: Agile, Waterfall

Packages: MS Office

PROFESSIONAL EXPERIENCE

Confidential, Virginia Beach, VA

QA Analyst

Responsibilities:

• Analyzed the requirements from Group Class Plan (GCP) document for member and subscriber demographic information and the insurance plans introduced in the New Yorkstates
• Wrote test plans and test cases based on the requirements and design documents
• Created members through express claim test pro for testing purposes
• Developed detailed test scenarios as documented in business requirements documents
• Executed test cases for the existing market’s various lines of business. (The test cases covered: Authorization of claims, Accumulator, Benefits, Claim Payment and Pricing, as well as member and provider data updates)
• Tested each web services using SOAP messages
• I have used Microsoft Visual source safe for version control
• I have worked on Facets Billing module and claim processing module and tested the claim processing module
• I have used Defect tracking and CMS using Clear Quest
• Used Rational Clear Case extensively for change management and to maintain history of source codes and builds.
• Used Load Runner 9.2 to conduct performance testing.
• Created 5010 preferences for all the HIPAA real time & batch transactions.
• Prepared Master Test Plan covers both the HIPAA 5010 Compliance.
• Performed Functional, Regression, and system testing for Pricing Application
• Maintained a traceability matrix of the requirements and created test cases, as well as testing matrix of the test cases and any corresponding defects. Conducting business validations, covering the following deliverables: Facets Providers, Facets Claims and Facets Membership and Operational reports.
• Involved in requirement gathering phase (Provider, Payer, Claim components and HIPAA)
• Used defect tracking tool such as quality center
• Performed various type Performance Test like Stress, Performance Testing’s.
• Experience with HP QC as Functional Documents Repository and defect tracking tool
• Created queries, reports and graphs in Clear Quest for defects, CR and ERs
• Involved in Facets Implementation, end-to-end testing of Facets Billing, Enrollment Claim Processing and Subscriber/Member module Was involved in Manual Functionality Testing and GUI Testing for objects tables, texts and object pages.
• Performed Manual Functional and Regression Testing.
• Reported the defects within Clear Quest Defect tracking tool.
• Executed claims data at the backend using SQL scripts
• Provided regular status updates to Team Lead on high priority issues and Testing Progress
• Loaded the modified claims data in target environment for testing
• Participated in defect review meeting and providing technical expertise on how to resolve the issues related to configuration and/or test scenarios
• Involved in writing SQL queries to check for the data validation.
• Performed SQL injection, cross site scripting Testing.
• Created SQL to test source to target data warehouse transforms, using TOAD, to find issues allowing a higher quality product to be released.
• Planning and execution of backend testing. Designed simple to complex SQL queries to retrieve data for database testing
• Performed UAT testing with the offshore team
• Logged the errors, reported defects, determined repair priorities and tracked the defects until resolution using Mercury Quality Center
• Extensively used SQL statements to query the Oracle database for data validation and data integrity

Environment: MS Office 2007, Windows XP, Agile,RUP, Rational Tools Suite (Rose, RequisitePro, Clear Quest and Clear Case)Mercury Quality Center 9.0, Facets 4.71, Precertification Look-up tool (PLUTO), Express Claims Test Pro, SQL, Oracle, Claims look up environment (CLUE, Xml, X path

Confidential, New York NY

Quality Analyst

Responsibilities:

• Worked with Business team, Development team and externals Vendors to review BRD’s in order to define test strategies and test plan.
• Performed System and System Integration testing from core Facets to different UHG and external vendor’s subsystems.
• Prepared test plans on various Facets modules such as Membership, Claims, Providers, Finance, Customer Service and according to MS CHIP plan requirement.
• Performed extensive testing in Facets Subscriber/Member, tested Groups, Eligibility, and Enrollment and validated outbound 834 Extracts to different Vendors.
• Coordinated with different external vendors to accommodate MS CHIP plan integration, wrote detail test plans to test core Facets with extended UHG and External Vendors sub applications such as Confidential etc.
• Worked on QTP and wrote test scripts
• Wrote complex SQL queries to extract and validate the data from the Facets database.
• Automated regression testing of client server application using performance tester.
• Executed tests on performance specific tools such as IBM Rational Performance tester.
• Developed Adhoc Queries using Cognos Query.
• Identified the presence and cause of system performance bottlenecks using Rational Performance tester.
• Performed Load and Stress testing of the web applications.
• Involved in developing and maintaining Test Matrix and Requirements Traceability Matrix and performing Gap Analysis.
• Prepared state review documents to get approval on respective tasks from states.
• Perform Extensive EDI testing on X12/, 835, 270 etc, worked with state vendor ACS to validate inbound /outbound EDI transactions to Facets.
• Extensively worked and have knowledge of ICD 9 to ICD 10 conversions
• Worked on mapping of ICD 9 to ICD 10 data conversions
• Connected to Testing Applications using Citrix Accounts from Home at times when the applications where needed to test them on ADHOC basis.
• Created detail test plans for Pharmacy, Dental and Vision claims which were processed by External Vendors Rx Solution, Dental Benefit Provider (DBP), and Vision Service Provider (VSP).
• Extensively involved in data validation between 834 Membership file to Facets backend tables and from Facets Backend tables to different external EDI extracts based on CHIP plan requirement.
• Provided Facets related systems expertise (training) to system users, business partners, and other internal/external customers including trouble shooting issues, as well as, identifying and correcting inefficiencies.
• Executed SQL queries to get back end data for Membership and Enrollment.
• Extensively worked and have knowledge of ICD 9 to ICD 10 conversions
• Worked on mapping of ICD 9 to ICD 10 data conversions
• Created reports for clients within the Rational Performance tester tool.
• Extensively performed System and System Integration testing.
• Facilitated User Acceptance Testing by creating UAT test scripts in order to test end-user functionality and to ensure that business requirements were met.
• Extensively performed Partner Testing to make sure all the external components are receiving data from FACETS according to new CHIP plan configuration.
• Used ClearQuest for defect tracking and prioritizing defects and for enhancements after base lining the requirements.

Environment: Clear Quest, Facets 4.41, UNIX, Java, XML, Oracle, Sybase, Manual Testing, XML, X Path

Confidential, Hartford, CT

QA Analyst

Responsibilities:

• Performed all phases of end-to-end testing which includes User Acceptance testing, Functionality testing, Regression Testing, GUI testing, boundary testing, negative testing, system testing, unit testing and Smoke testing of the Application, its interfaces and Client-Server Utilities.
• Created and tested Scripts for the premium calculations and Claims limits and deductibles (Claims calculations).
• Involved in writing test cases applying the SQL scripts to the test database and execution of the scripts on the database.
• Involved in Database testing along with developers and coordinated with developers to solve the problems encountered in the application.
• Created, Modified and debugged the Scripts.
• Tested the EDI 837 interfaces, Developed test cases and test scripts for all 835, 276, 277, Institutional and Professional HIPPA Transactions
• Created Test Scenarios and Matrices for various Claim transactions for various projects.
• Involved in testing Facets for Group Information, Enrolling Subscribers, adding members, Related Entities, Class/Plan definition and Premium Rate Tables.
• Medical Claims experience in Process Documentation, Analysis and Implementation in 835/837/270/271/277 (X12 Standards) processes of Medical Claims Industry from the Provider/Payer side
• Designed and Performed Data Driven Tests for checking application functionality.
• Performed SOA/ Web service testing using SOA applications.
• Performed Functional and Regression testing using SOA applications.
• Analyzed the results to compare expected and Actual results.
• Expertise in Claims, Subscriber/Member, Plan/Product, Claims, Provider, Payer, Commissions and Billing Modules of Facets.
• Participated in bugs and enhancement review meetings, assigning the bugs and enhancement request to the developers and follow up.
• Documented test cases, test results, test procedure.
• Testing the Backend with SQL manipulations on database.
• Extensively used SQL/PLSQL to work on database for checking database integrity.
• Performed positive and negative testing of the application for identification of bugs.
• Involved in testing and reporting of errors of subsequent builds during the process of development and production
• Analyzing Professional and Institutional Claims create claim level, line, and payment level out of Balance Reports under the Submitted Billing Provider Number.
• Involved in testing HIPAA Transactions & Code Sets Standards like (820- Premium Payment for enrolled health plan members, 834(X12) - Enrollment /Dis-enrollment to a health plan, 835, 837

Environment: HIPPA 5010, Edi 835, 276, 277 VB Script, SQL, HTML, Java, UNIX, XML

Confidential, Detroit, Michigan

Quality Analyst

Responsibilities:

• Interacting with Business users to understand the Business Processes and the existing system within the organization.
• Validated test data within IKA GUI and New Membership Enrollment Mainframe system.
• Validated EE batch files and letter generated from Letter generation system.
• Worked with Business Analyst in reviewing and analyzing the business requirements Documents and functional requirements.
• Conducted the walkthrough meetings with business analysts and other QA team members to understand the functionalities.
• Prepared the test plan, test strategy, define the testing approach and got document approval from the delivery manager and project manager.
• Distributed the tasks to the team members to write and execute test cases for the different aspects of the project.
• Prepared Test Cases based on business requirements and business rules for HIPAA EDI Transaction 270/271, 837/835, 834.
• Conducted the test case peer review meetings with the business analysts to make sure all the functionalities have been covered in the test cases.
• Worked in preparing the EDI transmission files, dropping them in Inbound, Outbound Interfaces and validate the data according to the test scenarios.
• Tested the HIPAA EDI, 834, 270/271, 837/835 transactions according to test scenarios.
• Validated the date from EDI transaction with Facets.
• Prepared test case scenarios in Excel spread sheet and export them into Mercury Quality Center.
• Tested the application using SOAP UI.
• Tested the backend and User Interface functionality.
• Performed Usability testing for the applications to test the GUI interface.
• Documented the test results and reported the status of assigned test tasks and issues to project QA Lead.
• Tested use interface and navigation controls of the application using Quick Test Pro.
• Recorded scripts in QTP to perform Functionality testing.
• Used VB scripting in the expert view to enhance the scripts.
• Created text area checkpoints to test the properties of the text in the application using QTP.
• Conducted Back-End Testing Using SQL Commands.
• Used SQL statements to query the Oracle Database for Data Validation and Data Integrity.
• Executed test cases found errors reported defects, determined repair priorities, did regression testing and closed by using Mercury Quality Center.
• Conducted the defect review meetings to track status of the defect resolution and discussed the issues with the developers.

Environment: Windows NT, UNIX, Visio 2003, Load Runner SQL, Windows 2000XML and Java, QTP, Mainframe, IKA, JIRA, GUI, UAT

Confidential, Richmond, VA

Quality Analyst

Responsibilities:

• Experience with Health Insurance Packaged Application like Facets. Providing US Health Insurance domain and TriZetto's FACETS training .
• Worked on processing the claims in NASCO
• Worked on HIPAA Transactions and Code Sets Standards according to the test scenarios such as 270/271, 276/277,837/835 transactions.
• Prepared test plans outlining the scope, schedule and costing for a variety of software and system product releases.
• Identifying and preparing for proper test environments, test equipment and test data.
• Interfaced with marketing for product demonstrations and documented incidents and enhancement requests in Clear Quest.
• Performed manual testing to get a strong hold of application’s primary function.
• Performed execution of test cases manually to verify expected results
• Used Test Director to create and Maintain Test requirements
• Work with developing team to prepare test methods that properly test the software or system product.
• Develop test procedure and expected result that maximize test coverage.
• Execute tests using software and system testing standards.
• Record test results and prepare test summary reports.
• Report defects in the bug tracking system.
• Described reported defects and provided adequate information such that engineers can reproduce the issue.
• Risk Analysis, identifying the inhibitions and devising alternate plans in case of failures.
• Design and developed a framework encompassing features as extensible, easy to maintain, multiple versioning based on Plug-in model and service oriented architecture.
• Defects were identified during the test execution, entered in defect tracking tool ClearQuest and monitored for resolution and re-test before deployment.
• Performed manual back-end testing using SQL Plus to connect to an Oracle 9i database on a UNIX server.
• Gathered domain knowledge, business requirements of HealthCare industry
• Providing solutions to the technical issues, prioritizing the tasks, identifying the dependent and independent tasks for efficiency.
• Unit testing and N unit Framework.
• Continuously looked for the opportunities to improve testing practices with the organization.

Environment: MS Windows, FACETS, MS Visio, MS Project, MS Office (PowerPoint, MS Word, MS EXCEL), Web 2.0, SQL, Oracle, SDLC, Agile