SUMMARY:

• Over All 7 years Sr. QA Analyst and Quality assurance of Testing Client/server application using RequisitePro, Rational Rose, ClearCase, ClearQuest) in support of the RUP. Worked on Agile SCRUM approach implementation for the whole testing life cycle for Performance Test
• Proficient experience in Manual and Automated Testing of GUI and functional aspects of the Client - Server and Web based Applications on multiple levels of SDLC and Testing Life Cycle (STLC)
• Worked in all phases of Black Box (Front End) and White Box (Back End) Testing of the application beginning from the preparation of Test Plan, Test Cases and Test Scripts.
• Worked on Data migration, FACETS version upgrades Reports Implementation, letters, Inbound/outbound Interfaces and FACETS Extensions. Implemented EDI transactions 837, 835, 270/271, 276/277 and 834.
• Experienced in planning, documenting and coordinating End to End Testing, User Acceptance Testing (UAT), Client Testing and obtaining the necessary signoffs from the stakeholders.
• Written multiple Use Cases for EDI transactions (Inbound and Response) including 837, 276, 277, 835, 834, 820, 270, 271 transactions.
• Expertise in querying and design SQL test scripts to perform testing on various RDMS like Oracle, SQL server,
• Excellent experience on STLC, its Methodology and used HP QC (Defects Management Tool) for defects/bugs tracking and for Manual Testing.
• Designed the online screens and reports for the Medicaid Online Electronic Claims Test Pro Submission System.
• Worked extensively on testing tools like ALM, Quality Center, QTP and Test Director
• Knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
• Demonstrated skills using best practices in QA methodologies including automated testing techniques, White Box and Performance/Load testing strategies, Release Management and Customer Support.
• Hands-on experience using defect Management Tools Quality Center,HP-ALM and Rally
• Strong knowledge of Business Intelligence and Data Warehousing (SQL Server, SSIS, SSAS,SSRS)
• Conducted White box, black box, system, integration, functional, regression, localization, compatibility, security, different reports, smoke and UAT testing.
• Extensive experience in writing SQL and PL/SQL scripts to validate the database systems and for backend database testing.

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Sr. QA Analyst

Responsibilities:

• Analyzed Use Case documents and User Stories got clarification regarding the ambiguous requirements and got the inaccurate requirements changed or removed in many cases.
• Worked with SGOR interface Tidal jobs to run the interface and validate the results in Custom and Stage tables in Facets databases and Facets front end page by logging into Citrix.
• Worked to build extensions for FACETS Members, Claims, Billing, Enrollment applications.
• Tested various functionality like Membership & Eligibility, Customer Relationship Management, Claims Processing and Payment, Provider Credentialing and Benefits Packages.
• Designed Test Plans, Scripts after analyzing various scenarios/requirements & performed defect tracking using Test Director & Clear Quest.
• Recommend on implementation of HIPAA 5010 (EDI X12 837,834, 820, 278,270,999) in the new System.
• Performed database integrity check using SQL and Unix Shell Scripts
• Participation in requirement / Use Case analysis, risk analysis and configuration management.
• Authored and executed Test cases for Claims and Customer Service Workflow by manually.
• Prepared the test cases based on the Use Cases that Business Team provided us & exported them to HPQC.
• Participated in testing the various Interfaces (Inbound and Outbound) of Facets.
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, Primavera, MS Access, MS Visio, technical assessment tools, Data Warehousing concepts and web design and development.
• Updated the status of the testing to the QA team and accomplished tasked for the assigned work to the Project Management team regularly.
• Used Web Service Description language (WSDL) to provide a model for describing web services.
• Tested web services by generating XML SOAPUI Requests and validated the corresponding XML SOAPUI Responses.
• Analyzed HIPAA EDI transactions in XML and X12 responses and amended the errors manually by data mapping.
• Testing inbound XML files and prepare analysis document with various results.
• The Agile methodology was used for the Software Development Life Cycle of the application.
• Worked on Agile process using Rally, attended daily scrum and provided status.
• Tested HIPAA 5010 Claims processing through the Clearing house.
• Troubleshooting of Facets Configuration issues.
• Used Rational Clear Case to keep different versions of the documents and Rational Clear Quest to report bugs or defect.
• Developed and modified Unix Shell scripts to automate QA execution process in Test environment.
• Used SOAP UI for web service testing like validating the response of claim processing.
• Played key role in defining test automation procedure and standards, creating Win Runner and QuickTestProfessional scripts for all the modules, which reduced the regression cycle drastically and improved the testing efforts for daily builds.
• Helped during Pre-UAT and UAT (User Acceptance Testing) sessions.
• Extensively performed Partner Testing to make sure all the external components are receiving data from FACETS according to plan configuration.
• Checked the data flow from front end to backend and used SQL queries to extract the data from the database.
• Experience in system testing and UAT testing of the facets core application and custom modules as needed.
• Performed FunctionalTesting, SystemTesting, UserAcceptanceTesting (UAT) in Agile SDLC Environment

Confidential, Buffalo, NY

Sr. QA Analyst

Responsibilities:

• Excellent knowledge of Agile & Scrum development environment, multiple web browsers, and automated testing suites
• Member of QA Team (Black Box) that wrote and executed test scripts to troubleshoot new versions and upgrades of the Property Management System product.
• Worked with business leaders to translate business requirements and processes into test cases according to FACETS package requirements and subsequent effective FACETS configuration.
• Performed Black Box testing and conducted Functionality and Regression testing on various phases of the Management software
• Wrote Structured Query Language (SQL) statement against Claims, Claim Status and updating Personal Information modules by Joins, Unions and Aggregate Functions.
• Experience with Trizetto Facets System implementation, Claims and Benefits configuration set-up testing, Inbound/Outbound Interfaces and Extensions, Load and extraction programs involving HIPPA 837 and proprietary format files and Reports development.
• Peer Review requirements and the test cases entered into HP Quality Center
• Created user stories, test cases, tracking defects using Rally (Agile Project Management Tool)
• Conducted Back-End Testing manually for the purpose of Database Integrity
• Assisted EDI team with the testing of maps for HIPAA transactions 835 and 837.
• XML and SQL Server package configuration to make package dynamic using SSIS package Configuration Wizard and deploy packages to production Server
• Reporting the defects through Defect Management using Clear Quest.
• Analyze and Debug the Automated scripts in an event of failure. Record the defects using HPQC Defects tab.
• Execute data validation test cases by verifying the values passed in the application against the values displayed in database using SQL queries.
• Detailed bug reporting with exact steps to reproduce and appropriate functional reference in HP Quality Center - Defects tab.
• Performed White Box, Black Box, and Usability Testing
• Data Warehouse; developed Test Scenarios and Test cases for EDW mapping
• Involved in Testing Web Services using SOAP UI.
• Document request/response XML's, test procedures and functional/technical findings from the test run.
• Identified the bugs and kept track of the defect report using ALM Quality Center, and also analyzed the root cause for defects.
• Executed test cases manually as well as using Automation tool Quick Test Pro.
• Executed SQL statements to check if the data integrity has been maintained.
• Created SQL queries for data validation.
• Logged defects in Quality Center and interacted with the developers to resolve technical issues.
• Involved in HIPAA/EDI Medical Claims Analysis, Design, Implementation and Documentation.
• Build ad-hoc reports using SQL Server Reporting Services (SSRS), Excel.
• Tested the configuration of Medicaid Claims and membership Sub-systems in Facets.
• Participated in various kinds of testing like (UAT) User Acceptance Testing, Functional Integration, System, Regression and Black Box.
• Designed and implemented HIPAA 835 Payment Advice Transaction, 837 Health Care Claim Transaction.

Confidential, Irvine, TX

QA Analyst

Responsibilities:

• Responsible for Manual testing of both web and stand-alone applications (Agile/Scrum development)- majority testing: System Testing, Function Testing, Integration Testing.
• Utilize data-driven and compartmentalized test automation practices using Mercury Interactive Test Suite and Compuware Products.
• Involved in writing Test plans, Test cases and responsible for executing the Test Scripts.
• Extensively used SQL statements and to extract data from the tables to validate test results and to prepare test data.
• Involved in Analyzing, Planning, Test data preparation and Testing of HIPAA EDI Transactions.
• Involved in validating the Claims data in FACETS and Mainframe Applications.
• Validated the diagnosis codes and procedure codes for claims in Facets application.
• Developed Test Scenario and Test cases for all 835, 837 278, 276, 277 Institutional and Professional HIPAA Transactions
• Managed requirements and Test Cases using Quality Center and executed the scripts/steps using Manual runner.
• Involved in writing test cases applying the SQL scripts to the test database and execution of the scripts on the database.
• Participated and drafted the Master Test Plan to covers both the HIPAA 5010 Compliance.
• Tested the application by writing SQL Queries and creating pivot views as to perform back-endtesting.
• Developed Test cases for manual testing and automated them using Win Runner, Silk, Load Runner, Silk performer and QTP.
• Maintained testing and requirements databases for different projects in the ClearQuestsystem and Requisite Pro (Rational Tools
• Work in the Agile-development environment with frequently changing requirements and features set.
• Create and upload Requirements and Test Cases on ALM.
• Used Rational Clear Case to keep different versions of the documents and Rational Clear Quest to report bugs or defect.
• Preparing work status matrix, rally defect list, QC defects, and sprint backlogs to automation team and Testing Manager.
• Extensively 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.
• Responsible for Performing Integration Testing, UAT testing./Maintained Test Matrix and Requirement Traceability Matrix
• Used QTP Checkpoints (GUI, Database and Bitmap) for comparing behavior of Application from previous builds.
• Responsible writing Test Plans, Test Cases and Test Scripts using manual and automated testing tools from Rational and Mercury Interactive such as test Director, Winrunner.
• Used Test Director and Mercury Quality Center for updating the status of all the Test Cases & Test Scripts that are executed during testing process.

Confidential, Livonia, MI

QA Analyst / Tester

Responsibilities:

• Excellent knowledge of Agile & Scrum development environment, multiple web browsers, and automated testing suites
• Internal & External review of Test plan and Test cases.Build setup on Test environment and installation Testing.
• Used Quality Center for storing test cases and QTP scripts, also used Team Track for defect tracking and reporting purpose.
• Analyzed research on operational procedures and recommend changes for improvement with an emphasis on automation and efficiency.
• Performing quality assurance functions covering the full software development life cycle, including development and implementation of test plans, test infrastructure and project plans.
• Conducted overall quality assurance responsibilities including writing test plans, detailed test cases, test scripts, and test automation development, test execution, defect reporting and tracking, full documentation, and supervision.
• Wrote Test Plans in MS Word for Manual Testing, System Testing, Integration Testing, Performance Testing, Regression Testing & reviewed their consistency with the business requirements.
• Logged the errors, reported defects, determined repair priorities and tracked the defects until resolution using ALM.
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Performed White Box, Black Box, and Usability Testing
• Wrote Test Cases in MS Excel for user registration, access to training material, and activity log-in, reviewed the test cases and finalized
• Reviewed colleagues’ test cases for testing the development of online resume, uploading users’ documents such as application and resume, browsing through jobs, selecting and applying for the jobs
• Documented the outcomes of all the testing in MS Word and MS PowerPoint
• Developed automated Test Scripts in Win Runner using Test Script Language (TSL) for Functional Testing, Regression Testing, Data Driven Testing, Usability Testing, and Verifying Specific content through using Checkpoints.