PROFESSIONAL SUMMARY:

• Around 7 years of experience in Software Quality Assurance with extensive knowledge in testing both web based and client server applications.
• Experienced in every phase of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
• Specialized in testing Web application and Client server applications.
• Experienced in creating Test Plans, Test Cases based upon the business requirements.
• Worked on Agile (Scrum) and Waterfall methodologies to complete the projects.
• Experience with mapping and validating various EDI files such as 834, 820, 835, 837, etc.
• Strong knowledge of software development methodologies including the Agile methodology, Waterfall, and RAD Methodology.
• Skilled in bug reporting and tracking using ALM (Quality Center), IMB Clear quest and JIRA.
• Experience in developing, trouble shooting and customizing automation test scripts using Quick Test Professional QTP /HP UFT for Functional and Regression Testing.
• Performed backend database testing by writing SQL and PL/SQL scripts to verify data integrity.
• Tested the HIPAA EDI transactions 834, 837/835, 276/277, 270/271 according to the requirement test scenarios.
• Used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate - wide-ETL Solution using Informatica.
• Solid understanding of Membership, Claims Processing, Benefit/Eligibility, COB, Authorization/Referrals, and have experience in HIPAA standards and corresponding EDI transactions.
• Experience on Web services to combine component based development and Internet standards and protocols that include HTTP, XML and Web services Description language.
• Used Agile-testing methodology for achieving deadlines in UAT.
• Experienced with testing tools like Microsoft Team Foundation Server(TFS), HP Application Lifecycle Management (ALM)
• Extracted Data from Teradata using Informatica PowerCenter ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes
• Expertise Back-End Testing by writing SQL Queries and validating the database using SQL joins Unions and Stored Procedures on ORACLE and MS-SQL SERVER.
• Used SOAP UI tool to test QA based architecture application and test SOAP-UI services and REST API
• Experience with WSDL, SOAP, Web services, XML Schemas
• Experience in facilitating meetings with clients to discuss and sign-off on the document.
• Strong understanding of SQL (can create own SQL to check the integrity of database), database schema, ETL, and data warehouse concepts
• Experience in ETL/BI testing with extensive backend testing and good understanding of Data Warehousing concepts, Database concepts.
• Performed planning and development of Test Plans, Test Strategies, Test Cases and Test Scenario to meet product’s business requirement.
• Experience in testing complex reports generated by reporting tools like Business Objects, WebFocus, and Crystal Reports.
• Proficient in different phases of Testing including Black Box, Functional, Integration, System, Back-end, Regression User Acceptance and 508 compliance testing.
• Expertise in Testing of Client/Server and Web based applications.
• Experience in Functional Testing, System Integration Testing, Back End Testing, GUI Testing, configuration Testing, User Acceptance Testing.
• Possess strong problem-solving skills with the ability to adapt to a new environment and meet deadlines.

TECHNICAL SKILLS:

Operating Systems: Windows

Languages: SQL, HTML, XML

Testing Tools: UAT, SOAP UI, UFT/QTP

Bug Reporting Tools: Bugzilla, JIRA, HP ALM/ Quality Center

Project Methodologies: Agile Scrum, Waterfall

Management Tools: Rational Rose, Requisite Pro, Clear Quest, Clear Case, JIRA, MS Visio, MS Project, TFS.

Database: MS SQL server

ETL Tools: MS SQL server integration Services, ETL, Informatica, Tableau, Webfocus

PROFESSIONAL EXPERIENCE:

Confidential, Minnetonka, MN

Sr. QA Analyst

Responsibilities:

• Wrote Test Plans, Test Scenarios, Test Cases and the Test Matrix.
• Analyzed and worked with MS SQL Server Test databases.
• Prepared Test Cases based on business requirements and business rules for HIPPA EDI Transaction 276/277, 270/271, 837/835.
• Performed Data Driven Testing, Functional Testing, System, Integration, and Regression testing for application releases.
• Using CTR (Claim Test Runner) for Claims generation for testing and information gathering for the claims testing purpose.
• Created test case based on approved 385 Rules Description to cover one happy path to trigger the Edit and negative scenario to get the clean claim.
• Tested SOAP request and response in XML format using SOAP UI.
• Interacted with the technical team for the 837 claims transactions design.
• Used Informatica as an ETL Tool for validating data in the Data Warehouse
• Tested and validated the database tables using SQL queries and Stored Procedures and performed Data Validation and Data Integration.
• Analyze test cases and defects being loaded in HP ALM by QA teams to ensure the link entities and accuracy of data.
• Designed and implemented HIPAA 835 Payment Advice Transaction, 837 Health Care Claim Transaction. Populated EDI X-12 transaction sets 835, 837, 270, 271, 276, 277, responsible for Claims processing, coordination of benefits and pricing process.
• Analyzed the EDI X12 data elements in the existing system to validate it against the data elements required in new system.
• Recommend ways and workarounds for HIPAA (EDI X12 837,834,278,270) upgrades.
• Involved in testing Web services (SOAP and REST) and XML with tool called 'SOAP UI' for the local WSDL with URL and created Test cases, run them, do load testing, security testing.
• Performed Back-End testing manually for database integrity using SQL statements on UNIX platform
• Tested 837/ 835, 820, 270/271, 276/277 transactions with File Aid.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using Webfocus.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Packages.
• Performed manual and automated test procedures for functional testing of Web services/ APIs using Soap UI
• Analyzed and worked with HIPAA specific EDI transactions for claims, member enrollment, billing transactions. Worked specifically with 837, 835, 834, 270/271
• Involved in testing the Webfocus reports by writing complex SQL queries.
• Tested the ETL Informatica mappings and other ETL Processes (DW Testing).
• Tested and validated the database tables using SQL queries.
• Analyzed and worked with HIPAA specific EDI transactions for claims, member enrollment, billing transactions. Worked specifically with 837, 835, 834, 270/271
• Ran the SQL queries for checking the data stored in the database.
• Provided assistance in building EDIs 270, 271, 276, 277, 470, 835, 837 and 834 transactions.
• Used complex SQL queries to perform Back End Testing manually with UNIX Shell Scripting.
• Performed Backend Testing by using SQL Queries.

Confidential, Bronx, NY

QA Tester

Responsibilities:

• Worked with the agile methodology reviewing the Business requirement, Functional Design Documents and Technical Specification documents.
• Worked on impact analysis on 837 (P-I), 270/271, and 834 for transitioning.
• Coordinated with business analyst about Functional Requirement Document (FRD) to configure the Graphic User Interface (GUI) of TRIZETTO FACETS system as per the business rules and HIPAA guidelines.
• Participated in JAD session to make Business Requirement Document (BRD) and the Functional Requirement Document (FRD) for 837 (Professional, Institutional and Dental), 835 1.
• Worked with FACETS team for HIPAA Claims Validation and Verification Process (Pre-Adjudication).
• Participated in preparing Test Plans and Test Data based on BRD, and FRD.
• Performed and assisted manual tests related to HIPAA transactions 270/271, 835, 837-(I, P) using HP Quality Center (ALM).
• Responsible for Data modeling and Mapping through data analysis to extract data elements from various OLTP’s using ETL technique and utilized Business Intelligence Tool (Webfocus) for report generation.
• Accurately translated the Business requirement for the expiration of duplicate records, survival of the correct records etc. into ETL Logic.
• Performed UAT, Functional Testing, End-to-End Testing and Regression Testing using HP Quality Center (ALM).
• Responsible for working with the team to review and modify process flows to increase productivity and effectively utilize FACETS features not provided by the legacy systems.
• Wrote extensive SQL queries for Back End testing using SQL Server.
• Performed Informatica ETL testing to validate end-to-end data from source system MS SQL Server and Target system Teradata environment.
• Translated project artifacts into Test Cases, executing Test Cases, reporting Defects and documenting Test Results using testing and bug reporting tools such as ALM/QC, TFS, JIRA.
• Represented as the point of contact in the HIPAA core team to respond to related to technical support.
• Involved in validation of the data in 837 transactions in accordance to companion guide.
• Involved in FACETS Implementation, involved end to end testing of FACETS Billing, Claim Processing and Subscriber/Member module.
• Created various interactive reports/dashboards using Webfocus.
• Used ETL tool to perform ETL testing and validating end-to-end flow of data.
• Performed Back-End testing manually for database integrity using SQL statements on UNIX platform.
• Used the Rational Unified process methodology for the application development and created Use cases, activity diagrams and drafted UML diagrams using MS Visio
• Analyzed the FACETS Requirements and conducted gap analysis.
• Tested and validated the database tables using SQL queries and Stored Procedures and performed Data Validation and Data Integration.
• Tested and validated the database tables using SQL queries.
• Performed Test execution and wrote and executed Test scenarios/Test Scripts

Confidential, Norcross, GA

QA Analyst

Responsiblities:

• Created Test Cases and Test data after analyzing the BRD
• Tested and managed the XML files of the Claims.
• Performed Functional and GUI testing on Facets Billing, Customer service and Subscriber application under Facets.
• Involved in FACETS Implementation, involved end to end testing of FACETS Billing, Enrollment Claim Processing and Subscriber/Member module.
• Tested web services by generating XML SOAP requests and validated the corresponding XML SOAP responses.
• Analyzed FACETS data model to ensure optimal system performance and tuning. Involved in testing Web services and XML using SOAP UI. Verified the response received by updating the request XML.
• 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.
• Used complex SQL queries to perform Back End Testing manually with UNIX Shell Scripting.
• Worked on Data Mapping to map Facets data to outbound eligibility extracts. Wrote SQL queries to extract and validate the data from the Facets database.
• Gathered requirements and created, executed and documented Test Cases as per requirements in Quality Center/ALM.
• Developed complex SQL queries to test ETL jobs from source to target Data Warehouse (DWH)
• Developed test strategies and test scenarios for all 837, 835, 834, 270/271, 276/277 transaction related reports
• Analyzed data entry into FACETS application in the test environment for creating groups, subscribers and family members.
• Troubleshoot any problems found within FACETS and when testing the SQL data database while validating against the business rules.
• Extensively used ETL for testing and supporting data extraction, transformations and loading processing in a corporate-wide- ETL Solution
• Involved in SOAP and REST API based web services testing using SOAP UI PRO Web services testing tool.
• 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).
• Utilizing HP ALM software to track test results and defects, and SQL to execute calls in Sybase environment.
• Identified the requirements for accommodating HIPAA standards for 837P transactions and captured these requirements to develop new GUI for the internet based application.
• Tested and validated the database tables using SQL queries and Stored Procedures and performed Data Validation and Data Integration.
• Involved in testing of HIPPA 835 for the payment of claims and transfer of remittance information
• Executed Performance test procedures to check to time span.

Confidential, Nashville, TN

QA TESTER

Responsibilities:

• Wrote Test Plans, Test Scenarios, Test Cases and the Test Matrix.
• Reviewed and Analyze client business requirements and prepared Test Plan and Test Cases accordingly.
• Executed and validated the claim process in HP interchange portal based on the business required documents.
• Performed Smoke Testing, Model testing, E2E Testing, Integration Testing, Regression Testing, and UAT Testing.
• Extensively used Quality Center and ALM for writing Test Plan and uploading and executing the Test cases related to the client requirements, logging and tracking the defects, and reporting Issue logs.
• Created HIPPA EDI X12 files based on the Business requirement also extensively used Ultra-Edit.
• Extensively used FileZilla, Transaction Management and Ultra Edit to process EDI files through the claims
• Connected to Putty and used UNIX to pull the EDI X12 files from client server.
• Used MySQL server and Toad to run the SQL Queries and SQL Scripts to extract the data from the database.
• Analyzed and worked with MS SQL Server Test databases.
• Corrected/Improved the ETL process of defining defaults within Data Warehouse by giving ETL full control of assigning defaults instead of database defaults, thereby giving ETL visibility of default assignment and simplifying the Lookup process.
• Provided support during the integration and UAT as well as conducted root-cause analysis
• Preparing the 837 I&P Claims and validated these in Facet System.
• Written several complex SQL queries for validating Tableau Report
• Developed design specifications writing Test Reports and documenting test results.
• Conducted Backend testing, writing extensive SQL queries.
• Tested modified / new Oracle forms and database using SQL for its functionality.
• Create SQL queries using the physical data model as guide to validate new tables (e.g. table structure, field constraints, uniqueness, not null, etc.)
• Accurately translated the Business requirement for the expiration of duplicate records, survival of the correct records etc. into ETL Logic.
• Tested SOAP request and response in XML format using SOAP UI.
• Tested daily and monthly ETL data validations using PowerShell scripts.
• Used Red gate SQL Server tools and features to compare ETL process and documented data issues.
• Documented and reported bugs using HP ALM.
• Tested web services by generating XML SOAP requests and validated the corresponding XML SOAP responses.
• Performed some back end testing using SQL Queries by connecting to the database server.
• Assisted with data-driven testing to verify reports generating from the project based on knowledge of valuation techniques and securities
• Verified the correlation between the UML diagrams and developing detail diagrams for QA purposes.