SUMMARY

• 7+ years of experience in Software Quality Assurance with extensive noledge 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.
• Involved in FACETS Implementation, involved end to end testing of FACETS Billing, Claim Processing and Subscriber/Member module.
• Data Warehouse skills include: architecture/design familiarity with Star schemas, conformed dimensions, data quality, developing complex ETL packages, metadata.
• Worked on Agile (Scrum) and Waterfall methodologies to complete teh projects.
• Experience with mapping and validating various EDI files such as 834, 820, 835, 837, etc.
• Strong noledge of software development methodologies including teh 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 usingQuick Test ProfessionalQTP/HP UFTforFunctionalandRegression Testing.
• Performed backend database testing by writing SQL and PL/SQL scripts to verify data integrity.
• Tested teh HIPAA EDI transactions 834, 837/835, 276/277, 270/271 according to teh requirement test scenarios.
• Solid understanding ofMembership, Claims Processing, Benefit/Eligibility, COB, Authorization /Referrals,and has experience inHIPAAstandards and correspondingEDItransactions.
• Experience on Web services to combine component based development and Internet standards and protocols that include HTTP, XML and Web services Description language.
• Worked closely on 834 transactions for Benefit Enrollment and mocking up teh EDI transaction file to test teh internal system for open enrollment.
• Used Agile - testing methodology for achieving deadlines in UAT.
• Experience in Data Analysis, Data Validation, Data Modeling, Data Profiling, Data Verification, Data Loading, and Data Warehousing/ETL testing thorough understanding various Requirements, Analysis and Design.
• Experience with EDI transactions such as EDI 834 (Benefit Enrollment and Maintenance), 276/277 (Health Care Claim Status Request and Response), 278(Health Care Service Review Information), 835 (Health Care Claim Payment/Advice), 837P (Health Care Claim: Professional), 837I (Health Care Claim: Institutions), ICD9/ICD10.
• Expertise Back-End Testing by writing SQL Queries and validating teh 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
• Used ETL methodology for support in extracting data, transforming and formatting teh data as per needs, loading teh data to Data Warehouse..
• Extensive experience in Data Analysis and ETL Techniques for loading high volumes of data and smooth structural flow of teh data.
• Excellent communication and organizational skills with teh ability to adapt to a new environment.
• Well versed with Data Migration, Data Conversions and Data Extraction/Transformation/ Loading (ETL).
• Experience in designing and developing Data Warehouse applications using ETL and Business Intelligence tools like Informatica Power Center, Datastage, Mainframes, OLTP, OLAP, Business Objects..
• Experience of Web and Mobile applications using Android and IOS devices in agile process
• Solid experience in creating and validating TCS letters through various FACETS Applications (Utilization Management, Claim Processing and Customer Service Applications) in teh QAE1 environment

TECHNICAL SKILLS

Operating Systems: Windows

Languages: Java, SQL, HTML, XML

Testing Tools: UAT, SOAP UI, UFT/QTP

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

Business Analysis: MS Visio, Flowcharts, Business Process Modeling/Mapping, Use Cases/ User Stories, Data Flow

Project Methodologies: Agile Scrum, Waterfall, Kanban

Database: MS SQL server

ETL Tools: MS SQL server integration Services

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

EDI QA Tester

Responsibilities:

• Worked with teh agile methodology reviewing teh Business requirement, Functional Design Documents and Technical Specification documents.
• Created Test Cases and Test data after analyzing teh BRD.
• Conducted GAP analysis and filling gap according to teh format set by HIPAA.
• Involved in validation of teh data in 837 transactions in accordance to companion guide.
• Responsible for customer interface, requirements definition, general and detailed design, testing, maintenance and training programs and managed requirements using Rational Requisite Pro.
• Involved in FACETS Implementation, involved end to end testing of FACETS Billing, Claim Processing and Subscriber/Member module.
• Wrote EDI related test cases to test inbound(270/837/ transactions) and outbound files(271/277/835 transactions
• Performed Back-End testing manually for database integrity using SQL statements on UNIX platform.
• Used teh Rational Unified process methodology for teh application development and created Use cases, activity diagrams and drafted UML diagrams using MS Visio
• Wrote test cases in ALM to cover various scenarios.
• ValidateEDI Claim Process of EDI X12 files of 835, 837 and also validated 834 and 820 transactions.
• Prepared Test Cases based on business requirements and business rules for HIPPA EDI Transaction 276/277, 270/271, 837/835.
• Tested HIPAA regulations in FACETS HIPAA privacy module.
• Validated ETL mappings and tuned them for better performance and implemented various Performances and tuning techniques.
• ValidateEDI Claim Process of EDI X12 files of 835, 837 and also validated 834 and 820 transactions.
• Prepared Test Cases based on business requirements and business rules for HIPPA EDI Transaction 834, 820,
• Wrote hundreds of DDL scripts to create tables and views in teh company Data Warehouse.
• Developed Automation Test Scripts for Functional and Regression testing using UFT for teh automation project.
• Performed Data Mapping to map teh EDI 834 data to XML.
• Define and develop process flow charts for allEDIapplications
• Tested teh HIPPA EDI 834, 837/835 transactions according to test scenarios and verify teh data on different modules.
• Developing suitable solutions and custom inputs for testing using API services and SOAP UI
• Performed Back-End Testing to check database integrity by writing SQL queries.
• Set Claim processing data for different FACETS Module.
• Developed design Specification writing Test report s and documenting Test results
• Worked with ETL specialists to migrate data into Teradata DWH
• Used RUP to create use cases, activity, class diagrams and workflow process diagrams
• Analyzed teh FACETS Requirements and conducted gap analysis.
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database models.
• Tested and validated teh database tables using SQL queries and Stored Procedures and performed Data Validation and Data Integration.
• Tested and validated teh database tables using SQL queries.
• Performed Test execution and wrote and executed Test scenarios/Test Scripts
• Monitored ETL batch jobs on batch servers and reviewing Log, Error and Output files
• Tested and managed teh XML files of teh 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 teh claims (837s) processing application (Facets) for any defects.

Confidential, Mountlake Terrace, WA

QA Tester

Responsibilities:

• Wrote Test Plans, Test Scenarios, Test Cases and teh Test Matrix.
• Analyzed and worked with MS SQL Server Test databases.
• Created T-SQL statements and procedures for data mining related to 837 transactions.
• Involved in testing various healthcare applications and migration of plans from legacy system to FACETS application.
• Provided support during teh integration and UAT as well as conducted root-cause analysis
• Preparing teh 837 me&P Claims and validated these in Facet System.
• Set Automation standards, practices designing teh framework Procedures to analyze test results.
• Manual Testing for checking teh flow of teh application functionality.
• Involved in ManagedCareapplications, Healthcare claims, ITS, HIPAA / EDI (837/835/276/277 , 270/271, 278,), NPI, Provider portals and Claims Processing applications.
• Prepared and executed different test cases of HIPAA ANSI X12 EDI 820, 834 and 837.
• Created High Level of Test Scenarios, Test Cases and Test Scripts as described in Requirement Specification Documents (RSD) and Design Specification Documents (DSD) as well as HIPAA and EDI Transactions like 834, 835, 837, etc
• Used FACETS Analytics for fast and easy retrieval, display and grouping of information for performing queries and generating reports.
• Validated various EDI transactions like 837I, 837P, 276/277, 270/271.
• Analyzed EDI transactions like 834 Benefit Enrollment and 820 Remittance Advice files to verify Data .
• Developed design specifications writing Test Reports and documenting test results.
• GUI, Performance, and Backend Tested for Pulse application developing in Java on Oracle Database.
• Conducted Backend testing, writing extensive SQL queries.
• Involved in testing HIPAA EDI Transactions and mainly focused on 834.
• Tested modified / new Oracle forms and database using SQL for its functionality.
• Involved in web services testing and validating teh xml.
• Monitoring nightly ETL process from various highly different source systems. Sources included SQL based databases and Excel Files.
• Provided training on teh EDI 834 and 820 transactions and on teh reconciliation processes
• Tested EDI 820 payment order/ remittance advice transaction
• Performed compliance testing on 837 me and P, 834 and 820 EDI transactions.
• Develop teh SQL codes as well as use ETL tools to Data Cleansing, Data Mapping and conversion rules and applications.
• Used ETL methodology for support in extracting data, transforming and formatting teh data as per needs, loading teh data to Data Warehouse..
• Tested teh HIPPA EDI 834, 835, 837 transactions according to test scenarios and verify teh data on different modules.
• Involved in testing HIPAA EDI Transactions and mainly focused on eligibility Transactions 834, 835, and 837).
• Create SQL queries using teh physical data model as guide to validate new tables (e.g. table structure, field constraints, uniqueness, not null, etc.)
• Prepared all documents necessary for noledge transfer such as ETL strategy, ETL development standards, ETL processes, etc.
• Tested SOAP request and response in XML format using SOAP UI.
• Tested teh changes for teh front-end screens in FACETS related to following modules, test teh FACETS batches (membership, Billing, Provider, etc.).
• Wrote complex SQL queries for data validation for both ETL and BI testing. Wrote SQL queries for data validation.
• Created Data Stage jobs to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files etc.
• Documented and reported bugs using HP ALM.
• Tested web services by generating XML SOAP requests and validated teh corresponding XML SOAP responses.
• Performed some back end testing using SQL Queries by connecting to teh database server.
• Performed Requirements Gathering and Analysis, interviewed teh SME (Subject Matter Experts), and ensured that contributors and all key stakeholders were motivated to complete assigned tasks.

Confidential, Nashville, TN

QA Analyst

Responsibilities:

• Created Test Cases and Test data after analyzing teh BRD
• Monitored ETL batch jobs on batch servers and reviewing Log, Error and Output files
• Performed Functional and GUI testing on Facets Billing, Customer service and Subscriber application under Facets.
• Helped business users to reconcile reports generated from Data Warehouse with reports from legacy systems, and validate teh data before and after teh migration/integration.
• 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 teh corresponding XML SOAP responses.
• Tested teh claims (837s) processing application (Facets) for any defects.
• Tested HIPAA Transactions and Code Sets Standards such as 820,834, 837/835, 270/271, 276/277 transactions using Facets.
• Involved in teh testing of web portal of New MMIS system.
• Logged of defects in Quality Center to maintain Test requirements and to communicate teh bugs with teh Developers.
• Analyzed FACETS data model to ensure optimal system performance and tuning. Involved in testing Web services and XML using SOAP UI. Verified teh response received by updating teh request XML.
• Conducted and automated teh ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data and finally load it into teh Multi-dimensional data warehouse.
• Used complex SQL queries to perform Back End Testing manually with UNIX Shell Scripting.
• Created ETL test data for all ETL mapping rules to test teh functionality of teh ETL Mapping.
• Tested teh ETL mappings and other ETL Processes (Data Warehouse Testing).
• Worked on Data Mapping to map Facets data to outbound eligibility extracts. Wrote SQL queries to extract and validate teh data from teh Facets database.
• Gatheird requirements and created, executed and documented Test Cases as per requirements in Quality Center/ALM.
• 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 teh test environment for creating groups, subscribers and family members.
• Developing and automating ETL processes to extract and upload daily data from Google Analytics API into teh web warehouse using Talend Integration Suite.
• Used Agile Methodology in teh process of teh project management based on SDLC.
• Involved in SOAP and REST API based web services testing using SOAP UI PRO Web services testing tool.
• Validate teh preparation of test scripts and teh execution of UAT of all MMIS contract components and documents risks and variations based on earlier defined requirements.
• Used ETL tool for Extraction, Transformation and Loading teh data into target database
• Validated teh 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).
• Responsible for testing of claims adjudication process for teh New MMIS system
• Conducted Backend testing on teh Oracle Database using SQL.
• Utilizing HP ALM software to track test results and defects, and SQL to execute calls in Sybase environment.

Confidential, Eagan, MN

QA Tester

Responsibilities:

• Wrote Test Plans, Test Scenarios, Test Cases and teh 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.
• Tested user interface and navigation controls of teh application.
• Tested SOAP request and response in XML format using SOAP UI.
• Used Quality Center to create and maintain Test Requirements and to communicate teh bugs with teh Developers.
• Worked on 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.
• Interacted with teh technical team for teh 837 claims transactions design.
• Tested and validated teh database tables using SQL queries and Stored Procedures and performed Data Validation and Data Integration.
• Heavily involved in teh various aspect of design and implementation of ETL processes for data warehouse creations: data profiling, data delivery, data staging, data cleansing, data transformation, and data mapping.
• Involved in project using SoapUI and run request with input XML to receive a response XML for teh request sent.
• Validated ETL mappings and tuned them for better performance and implemented various Performances and tuning techniques.
• 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.
• Updated teh company's data warehouse ETL population process.
• Generated Ad-hoc reports regularly which involved complex SQL process as teh data warehouse is designed using a snowflake model.
• Performed end-to-end testing of FACETS Billing, Enrollment Claim Processing and Subscriber/Member module.
• Responsible for Processing claims using EDI 835, 270/271, 278, 837.
• Coordinated multiple OLAP and ETL projects for various data lineage and reconciliation.
• Analyzed and worked with HIPAA specific EDI transactions for claims, member enrollment, billing transactions. Worked specifically with 837, 835, 834, 270/271
• Involved in FACETS Implementation, end to end testing of FACETS Billing, Enrollment Claim Processing and Subscriber/Member module.
• Used ETL to implement teh Slowly Changing Transformation, to maintain Historical Data in Data warehouse
• Tested and validated teh database tables using SQL queries.
• Ran teh SQL queries for checking teh data stored in teh database.
• Provided assistance in building EDIs 270, 271, 276, 277, 470, 835, 837 and 834 transactions.