SUMMARY:

• Quality Assurance professional with 7+ years of experience.
• Experience in testing both Web based and Client server applications , in multiple browsers (IE & Firefox).
• In depth knowledge of SDLC, with hands of experience in Waterfall, Agile, and Scrum.
• Experience in different phases of testing including Smoke, Integration, End - to-End, System, Regression, security and User Acceptance (UAT) testing and Compliance testing.
• Strong knowledge of Medicare and Medicaid state benefits plans.
• Experience in developing, trouble shooting and customizing automation test scripts using Quick Test Professional QTP /HP UFT for Functional and Regression Testing.
• Involved in HIPAA/EDI Medical Claims Analysis, Design, Implementation and Documentation
• Participated in design Walkthroughs and Inspection meetings to review Test scripts and results.
• Experience in Defect Tracking and Reporting using Quality Center (QC) and JIRA.
• Experience in creating Test Matrix, Requirements Traceability Matrix (RTM).
• Experience in Functional Testing, Stress Testing, Regression Testing,Load Testing, Performance Testing and User Acceptance Testing in a multi-tier environments.
• Experience in Designing Test plans, Test Cases, and Test Scripts.
• Experienced in both Agile and Waterfall methodologies.
• Experienced in client-server and web application testing.
• Experienced in SoapUI to validate XML files.
• Strong skills in performing Acceptance, Regression, Performance, Functionality, Front End and Back End Testing, Participation in requirement reviews
• Good knowledge of creating SQL queries for backend testing.
• Analyzed the responses of the web service using SOAP UI and validating the data in backend
• Solid understanding of Membership, Claims Processing, Billing, Benefit/Eligibility, Authorization/Referrals, COB, and have experience in HIPAA standards and corresponding EDI transactions.
• Hands-on experience with testing of COB, Healthcare Claim Pricing, Healthcare Claim Benefits, End to End Claims Processing
• Experienced with backend database testing using MS SQL Server.
• Experienced with Unit testing, Regression testing, Functional testing, UAT, Boundary Testing, Integration Testing.
• Experienced with claims lifecycle process and good understanding of EDI 270, 271, 837, 276, 278, and 835 in compliance with HIPAA standard.
• Knowledge of eliciting requirements, and developing test cases and test plan.
• Substantial experience in Sanity and Smoke Testing of applications before testing effort of UAT and Regression Testing of applications.
• Tested different web services using SOAP UI
• Experience in testing Data Marts, Data Warehouse/ETL Applications developed in Informatica and Data stage using Oracle, DB2, Teradata and UNIX.
• Proficient in Functional Testing tool Quick Test Professional (QTP/UFT)
• Strong experience in writing and executing SQL queries in SQL Server, MySQL, Oracle DB, and MS Access.

TECHNICAL SKILLS:

Test Reporting Tools: Quick Test Professional (QTP), Quality Center/ALM

Languages: Visual Basic, XML, HTML, DHTML

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

Databases: SQL Server, MS - Access, Oracle, and DB2

Others: UML, SDLC Agile Methodology, Rational Unified Process (RUP), Waterfall model

MS Office: MS Vision, Rational Requisite Pro, MS Visio, Rational Rose, Microsoft Project, Job Manager, SQL Server Management Studio, XML

PROFESSIONAL EXPERIENCE:

Confidential, MINNEAPOLIS, MN

Sr. QA Analyst

Responsibilities:

• Worked on Agile SDLC approach implementation for the whole testing life cycle.
• Reviewed Functional requirements documents, High level design requirement documents and finalize the testing in scoops and scenarios for Integration testing for each project.
• Gathered requirements and created, executed and documented Test Cases as per requirements in Quality Center/ALM.
• Interacted with the team member to ensure meaningful development of the scripts and simulated real time business scenarios.
• Designed and Developed UAT Regression automation script and Automation of functional testing framework for all modules using Selenium WebDriver.
• Acting as liaison between end user and Facets for user problems, outstanding issues, training needs and new software releases.
• Maintaining knowledge of Medicare and Medicaid rules and regulations pertaining to the Facets configuration and evaluating the impact of proposed changes in rules and regulations.
• Worked with business leaders to translate business requirements and processes into test cases according to Facets package requirements and subsequent effective configuration.
• Worked on testing the scenarios where individual might be eligible for Claim Adjustment under Medicaid Program.
• Also verified the test scripts before manual execution if they cover all the aspects of rate and quote details according to State Medicaid and Medicare Policy coverage selection.
• Creating Test Plan, Test Cases, and Test data after analyzing the BRD and Playbooks.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
• Extensively worked in the performance tuning of programs, ETL procedures and processes.
• Designed the overall ETL solution including analyzing data, preparation of high level, detailed design documents, test plans and deployment strategy.
• Experience of Web Services, SOAP and REST API Testing using Restful API and SoapUI.
• Tested and validated the database tables using SQL queries.
• Tested HIPAA EDI Transactions and Code Sets Standards such as 837/835 and 834 transactions.
• Authored and executed Test cases for Claims and Customer Service Workflow by manually.
• Experienced with batch processing system for claims electronic and manual transaction.
• Well known with frontend processing for the Claims, Subscriber/Family and with Providers.
• Experienced with External claim editing system on frontend system of Facets.
• Ran the SQL queries for checking the data stored in the database.
• Performed Backend testing by extensively using complex SQL queries to verify the integrity of the database.
• Worked on Quality Center for bug status tracking and maintained and created status reports for the application.
• Tested and Validated Request and Response of XML using SOAP UI.
• Create and run queries on Microsoft SQL database tables for FileNet system and for the user interface application tables.
• Responsible for creating the functional testing framework using NUnit and using Selenium WebDriver to automate the UI components.
• Used Selenium WebDriver and NUnit to run the parallel testing.
• Used Selenium WebDriver used to test search results of the Metasearch engine.
• Tested web services by generating XML SOAP requests and validated the corresponding XML SOAP responses.
• Involved in SOAP and REST API based web services testing using SOAP UI PRO Web services testing tool.
• Performed testing and implementation of X12 HIPAA standards for 837.
• Extensively used SQL for data integrity testing at the backend.
• Analyzed the responses of the web service using SOAP UI and validating the data in backend.
• Conducted Backend testing, writing extensive SQL queries.
• Tested modified / new Oracle forms and database using SQL for its functionality.
• Analyzed, Tracked and report defects using Quality Center/ALM
• Developed Selenium scripts in TestNG for parameterization using Data Provider annotation.
• Involved in testing the conversion of the application into web application using XML web services.
• Involved in web services testing and validating the xml.
• Performed some back end testing using SQL Queries by connecting to the database server.
• Involved in weekly defect review meetings to review the status of defect fixes and upcoming build releases.
• Used Quality Center/ALM for version control, tracking defects, enhancement requests, assign work activities, and assess the real status of project throughout the life cycle.

Confidential, El Paso, TX

QA Tester

Responsibilities:

• Responsible for gathering, analyzing and digesting the requirements and the critical areas of the application to setup and execute baseline tests
• Participate in Agile SDLC using the Scrum process
• Created an automation framework in Selenium WebDriver using behavior driven (BDD) approach like Specflow.
• Integrated Automation scripts (Selenium WebDriver API) in Continuous Integration tools (Jenkins) for the nightly batch run of the Script.
• Developed test automation scripts using Selenium WebDriver for regression and performance testing of the various releases of the application.
• XML stub creation for GUI test execution
• Assisted QA Lead and Project Manager in developing Test Plan and communicated with Project managers and supervisors to provide the best test strategy as per Agile Testing Life Cycle
• Coordinated and initiated Agile Scrum meetings with the Project Managers, QA, BA and Dev Teams
• Extensively participate in weekly status meeting with Test Team to discuss the current and future issues for testing plan as well as testing procedures
• Designed and developed automated scripts for functional, regression, sanity and integration testing using automation tool Selenium.
• Executed test scripts to verify the expected results based on the system requirements maintained in Quality Center.
• Involved in FACETS Implementation, involved end to end testing of FACETS Billing, Claim Processing and Subscriber/Member module.
• Involved in preparing Test Data for different EDI transactions like 837 for submitting claims, 835 for payments, 834 for benefit enrollment, and 820 for premium payments to insurance products, 270/271 for Eligibility inquiry, and 276/277 for claims status.
• Used ETL tool for Extraction, Transformation and Loading the data into target database
• Tested and managed the XML files of the Claims.
• Validated the following: 837 (Health Care Claims or Encounters), 835 (Health Care Claims payment/ Remittance), 270/271 (Eligibility request/Response), 834 (Enrollment/Dis-enrollment to a health plan).
• Derived UAT test cases using different white box, black box and experienced based techniques.
• Performance tuned and enhanced different complex SQL inquiries.
• Responsible for REST API testing using SOAP UI
• Involved in writing test cases using ALM based on the requirements.
• Expert in writing complex SQL queries in order to extract the data from multiple tables and perform data validations in the process of back-end testing.
• Wrote queries using SQL to retrieve data from the database for various customer requirements.
• Involved in testing, debugging and trouble-shooting code related to database.
• Created ETL test data for all ETL mapping rules to test the functionality of the ETL Mapping.
• Tested the ETL mappings and other ETL Processes (Data Warehouse Testing).
• Designed and developed automated scripts for functional, regression, sanity and integration testing using automation tool Selenium.
• Built automation scripts using Data driven Framework and TestNG and JUnit Framework and conducted using Selenium.
• Implemented the data driven frame in SOAP UI and Tested various functions in web services with different dataset.
• Worked on Data mapping, logical data modeling used SQL queries to filter data within the Oracle database
• Strong SQL programming skills include writing Functions, Triggers etc.
• Tested web services based on Data and functions by SOAPUI.
• Monitored ETL batch jobs on batch servers and reviewing Log, Error and Output files
• Performed back-end testing and verified the data between GUI and database are reflected correctly.
• Conducted smoke testing of different Applications using SOAP UI.
• Tested web services by generating XML SOAP requests and validated the corresponding XML SOAP responses.
• Executing the SQL statements to extract data from tables and verify the output data with ref to user inputs from browser page.
• Wrote Test Scenarios, Test cases in excel sheet and imported them to Quality Center and also used to track the bug.

Confidential, DETROIT, MI

QA Tester

Responsibilities:

• Loaded all Amendments and new Professional and Institutional provider contracts for Medicare, Medicaid and Commercial lines of business
• Assisted with user testing of systems (User Acceptance Testing) and Functional testing, ensuring that appropriate documentation is in place.
• Reviewing the Business requirement, Functional Design Documents and Technical Specification documents.
• Creating Test Plan, Test Cases, and Test data after analyzing the BRD and Playbooks.
• Logging of defects in HP ALM to maintain Test requirements and to communicate the bugs with the Developers.
• Performing Backend testing extensively by writing SQL validation queries against the database.
• Performing Frontend testing extensively through FACETS.
• Involved in the full HIPAA compliance life cycle from GAP analysis, mapping, and testing of Health Insurance Claims. Worked with HIPPA standard/ EDI standard transactions: 270, 271, 276, 277, 834, 835, and 999.
• Worked with the Agile methodology reviewing the Business requirement, Functional Design Documents and Technical Specification documents.
• Experience in developing, implementing and testing EDI ANSI X12, EcMap, EDIFECS Spec Builder,
• Involved in the full HIPAA compliance lifecycle from GAP analysis, mapping, implementation, and testing for processing of Medicaid Claims. Worked on EDI transactions: 270, 271, 834, 835, and 837 (P.I.D) to identify key data set elements for designated record set. Interacted with Claims, Payments and Enrollment hence analyzing and documenting related business processes.
• Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data and finally load it into the Multi-dimensional data warehouse.
• Tested SOAP request and response in XML format using SOAP UI.
• Responsible for testing an in-house application to compare data from deferent sources i.e., EDI, XML, and FACETS.
• Analyzed the FACETS (claims engine) data and discussed with the Business team regarding the Requirement.
• Analyzed and dissected system requirements and technical specifications to create and execute test cases for large business initiatives
• Responsible for creating user stories in JIRA (Agile methodology) from the high-level business requirements delivered by the SMEs.
• Writen SQL and PL/SQL scripts to validate the database systems and for backend database testing.
• Involved in testing the claims conversion from Mainframe to Facets. Also involved in testing the EDI transactions 834, 837, 835. 270/271 & 276/277 conversion to Facets.
• Involved in preparing Test Data for different EDI transactions like 837 for submitting claims, 835 for payments, 834 for benefit enrollment, and 820 for premium payments to insurance products, 270/271 for Eligibility inquiry, and 276/277 for claims status.
• Monitored ETL batch jobs on batch servers and reviewing Log, Error and Output files
• Used complex SQL queries to perform Back End Testing manually with UNIX Shell Scripting.
• Involved in SOAP and REST API based web services testing using SOAP UI PRO Web services testing tool.
• Performed Back-End Testing to check database integrity by writing SQL queries.
• Conducted Backend testing on the Oracle Database using SQL.
• Created ETL test data for all ETL mapping rules to test the functionality of the ETL Mapping.
• Tested the ETL mappings and other ETL Processes (Data Warehouse Testing).
• Developing suitable solutions and custom inputs for testing using API services and SOAP UI
• Utilizing HP ALM software to track test results and defects, and SQL to execute calls in Sybase environment.
• Worked on Member Management, Benefits, Eligibility, Claims, and Billing modules within FACETS.
• Tested the changes for the front-end screens in FACETS related to following modules, test the FACETS batches (member load, Billing, Provider, etc.
• Tested and validated the database tables using SQL queries and Stored Procedures and performed Data Validation and Data Integration.
• Performed Back-End testing manually for database integrity using SQL statements on UNIX platform.
• Responsible for REST API testing using SOAP UI
• Actively participated in daily standups to announce completion of deliverables, updates and roadblocks, if any.
• Planned, documented, evaluated and tracked testing results to ensure system applications are free from defects