We provide IT Staff Augmentation Services!

Edi Tester Resume

Downers Grove, IL

SUMMARY

  • 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.
  • 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 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 usingQuick Test ProfessionalQTP/HP UFTforFunctionalandRegression 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.
  • Solid understanding ofMembership, Claims Processing, Benefit/Eligibility, COB, Authorization /Referrals,and have 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 the EDI transaction file to test the 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 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
  • Used ETL methodology for support in extracting data, transforming and formatting the data as per needs, loading the data to Data Warehouse..
  • Extensive experience in Data Analysis and ETL Techniques for loading high volumes of data and smooth structural flow of the data.
  • Excellent communication and organizational skills with the 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 the 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, Downers Grove, IL

EDI Tester

Responsibilities:

  • Worked with the agile methodology reviewing the Business requirement, Functional Design Documents and Technical Specification documents.
  • Created Test Cases and Test data after analyzing the BRD.
  • Conducted GAP analysis and filling gap according to the format set by HIPAA.
  • Involved in validation of the 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 the Rational Unified process methodology for the 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 the company Data Warehouse.
  • Developed Automation Test Scripts for Functional and Regression testing using UFT for the automation project.
  • Performed Data Mapping to map the EDI 834 data to XML.
  • Define and develop process flow charts for allEDIapplications
  • Tested the HIPPA EDI 834, 837/835 transactions according to test scenarios and verify the 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 the 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 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
  • Monitored ETL batch jobs on batch servers and reviewing Log, Error and Output files
  • 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 the claims (837s) processing application (Facets) for any defects.

Confidential, Mountlake Terrace, WA

QA Tester

Responsibilities:

  • Wrote Test Plans, Test Scenarios, Test Cases and the 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 the integration and UAT as well as conducted root-cause analysis
  • Preparing the 837 I&P Claims and validated these in Facet System.
  • Set Automation standards, practices designing the framework Procedures to analyze test results.
  • Manual Testing for checking the flow of the 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 the xml.
  • Monitoring nightly ETL process from various highly different source systems. Sources included SQL based databases and Excel Files.
  • Provided training on the EDI 834 and 820 transactions and on the reconciliation processes
  • Tested EDI 820 payment order/ remittance advice transaction
  • Performed compliance testing on 837 I and P, 834 and 820 EDI transactions.
  • Develop the 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 the data as per needs, loading the data to Data Warehouse..
  • Tested the HIPPA EDI 834, 835, 837 transactions according to test scenarios and verify the data on different modules.
  • Involved in testing HIPAA EDI Transactions and mainly focused on eligibility Transactions 834, 835, and 837).
  • Create SQL queries using the physical data model as guide to validate new tables (e.g. table structure, field constraints, uniqueness, not null, etc.)
  • Prepared all documents necessary for knowledge transfer such as ETL strategy, ETL development standards, ETL processes, etc.
  • Tested SOAP request and response in XML format using SOAP UI.
  • Tested the changes for the front-end screens in FACETS related to following modules, test the 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 the corresponding XML SOAP responses.
  • Performed some back end testing using SQL Queries by connecting to the database server.
  • Performed Requirements Gathering and Analysis, interviewed the SME (Subject Matter Experts), and ensured that contributors and all key stakeholders were motivated to complete assigned tasks.

Confidential, El Paso, TX

QA Analyst

Responsibilities:

  • Created Test Cases and Test data after analyzing the 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 the data before and after the 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 the corresponding XML SOAP responses.
  • Tested the 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 the testing of web portal of New MMIS system.
  • Logged of defects in Quality Center to maintain Test requirements and to communicate the bugs with the Developers.
  • 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.
  • 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).
  • 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 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.
  • Developing and automating ETL processes to extract and upload daily data from Google Analytics API into the web warehouse using Talend Integration Suite.
  • Used Agile Methodology in the process of the project management based on SDLC.
  • Involved in SOAP and REST API based web services testing using SOAP UI PRO Web services testing tool.
  • Validate the preparation of test scripts and the 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 the data into target database
  • 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).
  • Responsible for testing of claims adjudication process for the New MMIS system
  • Conducted Backend testing on the 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 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.
  • Tested user interface and navigation controls of the application.
  • Tested SOAP request and response in XML format using SOAP UI.
  • Used Quality Center to create and maintain Test Requirements and to communicate the bugs with the 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 the technical team for the 837 claims transactions design.
  • Tested and validated the database tables using SQL queries and Stored Procedures and performed Data Validation and Data Integration.
  • Heavily involved in the 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 the 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 the company's data warehouse ETL population process.
  • Generated Ad-hoc reports regularly which involved complex SQL process as the 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 the Slowly Changing Transformation, to maintain Historical Data in Data warehouse
  • Tested and validated the database tables using SQL queries.
  • 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.

Hire Now