We provide IT Staff Augmentation Services!

Etl Testing Engineer Resume



  • Quality Assurance with unique dual - role in manual and automated testing and SQL query to sort big data applications. Specialize in writing Test Requirements, Test Cases and Test Plans. Ability to resolve uncover defects of any application in early stage of SDLC, which helps to improve the application’s quality and reduce development cost.
  • Excel under pressure in deadline driven environment with superior interpersonal communication and technical documentation skills.
  • 7 years of experience as a Quality Assurance Analyst with extensive knowledge and experience across the project life cycle in Systems Development Life Cycle (SDLC) in the fields of Insurance, HealthCare.
  • Experienced in every phase of Quality Assurance Life Cycle (QALC) and Software Development Life Cycle (SDLC)
  • Proficient in design and execution of all articrafts of testing such as Test Scenarios, Test Cases, Test Data, Test Scripts(QTP/Selenium v3.0),Defect Reporting & Tracking using HP QC/ALM.
  • Knowledge of the PMBOK, PMI and state Project Management Methodology, used to evaluate a project
  • Proficient in Defect Reporting and Tracking throughout the entire defect life cycle.
  • Possess strong problem solving skills with the ability to adapt to a new environment and meet deadlines.
  • Expertise in Testing of Client/Server and Web based applications.
  • Strong knowledge of software development methodologies including the Agile methodology, Waterfall, and V-Model and SOA Methodology.
  • Review system level requirements with Agile team members
  • Involved in preparation of Test planning, Designed Test Scenarios, Test cases, Test Data preparation using ALM/QC and reviews as a manual tester.
  • Skilled in bug reporting and tracking using Test Director, HP Quality Center.
  • Good Understating on Medicaid Management Information Systems (MMIS)
  • Extensive experience in Backend Testing on distributed databases using SQL queries.
  • Experience in Functional Testing, System Integration Testing, Back End Testing, GUI Testing, configuration Testing, User Acceptance Testing.
  • Solid understanding of Membership, Claims Processing, Billing, Benefit/Eligibility, Authorization/Referrals, COB, and have experience in HIPAA standards and corresponding EDI transactions.
  • Involved in writing and execution of different Scenarios, Cases for the modules using ALM/QC.
  • Knowledge of Medicaid and Medicare Services.
  • Experienced in Performing Functional and Regression Testing using Selenium v3.0/QTP.
  • Experienced on writing VB and VB Script code in Selenium v3.0/Quick Test Pro environment.
  • Experience in performing functional testing using Quick Test Pro.
  • Proficiency in Medicaid/Medicare and EDI 4010 to EDI 5010. Involved in conversion and mapping HIPAA ICD9 to ICD10. Expert in COB (coordination of benefits).
  • Followed Workgroup for Electronic Data Interchange standards for testing that need to comply with the HIPAA guidelines.
  • Tested the HIPAA EDI transactions 834, 837/835, 276/277, 270/271 according to the requirement test scenarios.
  • Optimum use of documentation to avoid any form of miscommunication or misinterpretation during the entire software development process
  • Excellent communication and organizational skills with the ability to adapt to a new environment.
  • Experience in facilitating meetings with clients to discuss and sign-off on the document.
  • Conducted User Acceptance Testing (UAT)
  • Motivated self-starter with exceptional team building, leadership, and interpersonal skills. Good team player with the ability to work in time sensitive environments.
  • Proficient in working with FACETS, claim processing systems.


Methodologies: SDLC, RUP, Agile, Waterfall

Platforms: Windows, Mainframe

Testing tools: SOA Test, ALM, RTC, Selenium v3.0, LoadRunner, Quick Test Professional

ETL tools: Tableau, Gephi, MATLAB, Informatica, SSIS

Change Management Tools: Rational ClearQuest, TestDirector, HP Mercury Quality

Office Tools: XMLSPY, MQ/JMS MS Project, MS Office, MS Visio

Database: MS SQL Server, MS Access, Oracle, Toad


Confidential, Maryland

ETL Testing Engineer


  • Testing experience with strong background in Software QA and Testing in a multi-server environment. Including back-end and front-end testing activities.
  • Use Thorough Data Structures and Algorithms skills to Test ETL Data
  • Demonstrate understanding of Agile software development lifecycle and deliverables · Engage in technical discussions, designs and present technical ideas through white boarding
  • Execute in a fast paced delivery mode, delivering on tasks to meet the product release goal
  • Maintain product quality through testing best practices, design techniques and automation Seek and provide feedback on test designs and execution
  • Understand the whole product, its modules and the interrelationship between them while developing expertise in assigned modules
  • Assess application performance and optimize it with performance test techniques and tools
  • SOATest including WSDL, XML, and messaging clients.
  • Worked with high-volume transaction systems, MQ/JMS Messaging, web services, and GUI development
  • Experience and In-depth knowledge of Claim Adjudication process
  • Conduct deep technical analysis/testing of release in plan to conduct validation and verification of entire application.
  • Participate in Business Requirements reviews and work with systems analysts/developers to fully test application changes.
  • Understand the functional specification and scope of releases to design robust testing harness to ensure the quality delivery
  • Detailed knowledge of 837/835 EDI formats including all segments and loops. Ability to manipulate 83/83 EDI /XML files to generate a wide variety of valid claims
  • Ability to execute all phases of the testing process in a multi-server environment. Requires the ability to define and maintain testing environments and/or configuration.
  • Hands on UNIX knowledge to write and execute queries would be preferred. Ability to write scripts to run queries in an automated fashion
  • Demonstrate strong and clear communication skills with the ability to work with all project members including representatives from business and technical groups of people in a collaborative environment.
  • Ability to maintain individual testing machines with required software, and connectivity configuration.
  • Ability to work independently and meet deadlines in a highly demanding environment
  • Healthcare insurance related technology project experience
  • Experience and In-depth knowledge of Claim Adjudication process
  • Extensive experience in Relational database (including) generating complex queries, setting up database connections, and automating query processing.
  • Experience with databases testing in a data warehouse environment.

Confidential, Nashville TN

ETL Testing Engineer/ Quality Analyst


  • Work closely with Business Analysis team to develop requirements and appropriate test plans to meet the requirements outlined in the requirements documentation.
  • Wrote complex SQL queries to retrieve claims and member data from multi-database environment.
  • Create and publish formal release notifications, instructions, deployment notes, and user manual as needed.
  • Coordinate activities with Project Management, QA, and Development teams to ensure a smooth and trouble-free roll out of releases.
  • Good Understanding of the functional specification and scope of releases to design robust testing harness to ensure the quality delivery
  • Built test strategy based on a thoroughly reviewed and understanding of the scope of Home and Community Based Services project
  • Used UNIX knowledge to write and execute commands on the Operating system
  • Used understanding of the UNIX O/S filesystem to store data and locate files on the system
  • Gathered project requirements from the TennCare Medicaid program SME's to create specification artifacts for the CHOICES/ECF project
  • Involved in writing and execution of different Scenarios, Cases for the modules using ALM/RTC
  • Involved in Validation of HIPAA for 837, 270/271, 276/277, 835, 834 EDI transactions
  • Review requirements and identify gaps and missing information
  • Extensively research the performance of the application to derive scenarios for testing
  • Performs testing utilizing different Testing techniques
  • Tested HIPAA EDI Transactions and Code Sets Standards such as 837/835, 270/271, 276/277 transactions.
  • Produced Thoroughly written Test scripts for automation testing of functionality
  • Assist in analyzing and resolving the problems identified by team members
  • Creates progress reports of project to the Project manager effectively and provides complete visibility to team members
  • Tested web services by generating XML SOAP requests and validated the corresponding XML SOAP responses.
  • Promote and recommend enhancements to the performance quality of the software
  • Validated member enrollment in Care Advance management application
  • Conducted web services testing to validate information is accurately transferred from the web application version of system and the accurately rendered in the Care Advance system
  • Conducted integration testing to validate data residing in disparate client-server system are accurately transferred
  • Conducted validations of the business rules compliance in member eligibility and enrollment in the ECF/Choices program

Confidential, St. Louis MO

Sr. QA / ETL Test Engineer


  • Planned Inter-organizational Testing Activities with between the Home and Host Plans in the ITS development processing Interpreted tech documentation
  • Planned, Created Test Strategy, Test Plan and schedule by technically analyzing the requirements and ensure documented guidelines are followed.
  • Conducted Configuration testing on the MQ web-sphere server to validate the configuration of the ITS system between the Host and Home plans
  • Processed received SF (submission format) files from Host to Home BOID's and validated claims, plan codes and other details
  • Used ALM/Quality Center for tracking, reporting and managing bugs/defects.
  • Created and send DF (disposition format) files from Home to Host ITS plans and validated successful transmission
  • Created Test cases and scripts based on requirements in Selenium v3.0/QTP provided by the client.
  • Debugged the applications using conditional statement, loops statement using Selenium v3.0/QTP
  • Processed received RF (reconciliation format) files from Host to Home BOID's and verified matching contents with SF and DF.
  • Worked on HIPAA Standard/Gstandard transactions: 270, 271, 276, 277, 278, 834, 835, and 837 (P.I.D), 997 and 999 to identify key data set elements for designated record set.
  • Developed and executed automated test scripts using test plan and test lab sections of Selenium v3.0 for Integration testing and Regression testing of the application.
  • Tested the EDI transactions (HIPAA) like 270, 271, 276, 277, 278 837P, 837I, 837D, 835 remittances)
  • Creating Mapping documents for translating 837(I/P) to internal XML format and vice versa.
  • Responsible for inserting Check points to verify Functionality of the application using QTP.
  • Performed Web Services testing and Validated XML request/response data using SOAP UI.
  • Validated and Processed ITS claims in Blue2 ( Confidential assoc web based platform for ITS operations)
  • Created and Tested real time eligibility or claim status messages on Blue Exchange between the Host and Home plans
  • Validate populated ITS claims in FACETS with Blue2 systems and verify the claims information are synchronized.
  • Involved in writing and execution of different Scenarios, Cases for the modules using ALM/QC.
  • Coordinated BATCH processing jobs for SF, DF and RF transactions to be processed through the inter-plan systems.
  • Verified 834 member eligibility and enrollment information for Medicare ADV plan in FACETS for ITS.
  • Processed and adjudicated 835 ITS Claims in FACETS
  • Created and executed test extensively 270/271, 276/277, 835/837 transactions to include TA1 and 997 error message testings.
  • Created detailed issue logs, ITS processes tracking files and defect tracking records for the ITS operations.

Confidential, Mc Lean VA

ETL Testing Engineer/ Quality Analyst


  • Analyze and adjudicate cases reported by consumers on the 1095A form using thorough knowledge of EDI 834 enrollment and eligibility regulations and requirements
  • Technically analyze and recognize the reported issue with 1095A tax form problem and effectively detect and resolve problem
  • Providing recommendations for resolution of consumer reported errors by analyzing data from data warehouse
  • Importing, cleaning, transforming, validating and modeling data with the purpose of understanding or making conclusions from the data to adjudicate cases.
  • Validated Extract/Transform/Load (ETL) processes that load Teradata test databases with data feeds from upstream applications and provided information deliveries of warehouse data to downstream users.
  • Tested the ETL SSIS packages and other ETL Processes (Data Warehouse Testing).
  • Designing or presenting conclusions gained from analyzing data using statistical tools like Microsoft Excel, SAS, SPSS and others
  • Created Test cases and scripts based on requirements in Selenium v3.0/QTP provided by the client.
  • Extract data from primary or secondary sources and create workbook on Microsoft excel to compare and identify discrepancies in the data
  • Propose strategies to implement HIPAA 4010 in the new MMIS system & eventually move to HIPAA5010.
  • Developed and executed automated test scripts using test plan and test lab sections of Selenium v3.0
  • Use statistical skills to Identify, analyze, and interpret trends of cases reported by consumers to locate and define new process improvement opportunities
  • Used ALM/QC to log defects, Prepared status report (No of defects, QA estimation, actual QA hours etc.)
  • Worked in creating and verifying EDI transactions for Medicaid (MMIS) and Medicare claims.
  • Participate in analytical projects from the area of data analysis, processing and Data Mining
  • Preparing documentation and presenting work results in the resolution of consumer reported cases
  • Actively participating in business process meetings with clients and stakeholders
  • Using technical skills about various networking protocols to access data from protected sources
  • Effective coordination with project managers to suggest process and facilitation improvements

Confidential, Albany NY

Sr. QA Analyst


  • Analyzed the requirements for Payment Integrity fraud and abuse solution to be developed
  • Worked with the Eligibility and Enrolment Team to recreate comprehensive eligibilities for health plan from amongst over a thousand possible scenarios from the business rules
  • Enroll individuals in plans via the front end application using test data and validate from the backend and database
  • Responsible for defect tracking and management metrics, defects are logged and change requests are submitted using Quality Center ALM.
  • Conducted end-to-end regression testing from enrolment to EDI 834 file generation scenarios
  • Update and manipulate data entities in the database to re determine plan eligibilities based on different consumers conditions and time changes.
  • Prepared various artifacts such as use cases, workflow diagrams, business process models, functional requirement specifications (FRS) and System requirements specifications (SRS) by interacting with end users, development team, the subject matter experts(SME's) and other project team members.
  • Validate the auto renewal process of plans for eligible members for upcoming year using test data
  • Access spreadsheet of authorized test data PII and PHI for purpose of conducting assigned task while abiding with the HIPAA rules
  • Wrote complex SQL queries to fetch data from database and update values to enable conduct backend testing and validation
  • Created Scenarios and Validate enrolment notices T99, T10, T12 N100 generation from both front and backend
  • Developed scripts using Regular expressions to handle dynamic Window names in Selenium v3.0/QTP.
  • Used verification points and conducted Data Driven test with the Test Data set using in Selenium v3.0/QTP
  • Validate Enrolment Cancellation and Termination notices T31 and T32 and validate key messages.
  • Implemented HIPAA transactions like 834, 837I, 820, 837P, 837D, 276,277 by gathering the requirements, built maps to translate HIPAA ANSI X12 data to XML format and custom format to X12 format, performed unit/integration testing and production migration for 5010 changes.
  • Created Use Cases, Sequence Diagrams, Collaboration diagrams, Activity Diagrams, and Class diagrams using business Process Models using MS-Visio, MS-Excel, MS-Project.
  • Involved in preparing test cases, test scripts based on use cases and BRD documents and high level X12 5010 based business requirements.
  • Worked closely on 834 transaction code for Benefit Enrollment and was involved in Validation of HIPAA for 837, 270/271, 276/277, 835, 834 EDI transactions for Medicaid members (MMIS)
  • Used BizTalk tool to convert and map XML to X12 and vice versa.
  • Daily Defect Triage meetings with the Client and HP QA team
  • Review the technical requirement Documents to validate key messages in enrolment notices
  • Validate the generation of EDI 834 files and validate the entries, loops and segments are in correct format.
  • Conducted smoke, sanity and boundary testing of new application releases and enhancements
  • Conducted regression testing following new releases and system upgrade
  • Conducted batch job testing to verify data are being picked up for batch jobs
  • Liaise with development team and Business analysts to discuss defects and bugs
  • Log and assign defects and monitor the progress in RTC.
  • Participated with team mates to analyze test planning and share task within the resources available.
  • Involved in management meeting to discuss progress of project and discuss improvements to the process.

ENVIRONMENT: Facets, HIPAA, EDI, XML, Test Director, Window, SOAP UI, MS Office, Oracle

Confidential, Durham NC

QA Analyst


  • FACETS 4.51 & 4.71 operational support member
  • Wrote SQL queries to validate the data integrity of the providers and members database
  • Worked with core developers to sanitize the big table and remove duplicate entries
  • Create and execute test cases to validate the database integrity.
  • Maintained Requirement Traceability Matrix (RTM) to make sure that test plans were written for all the requirements.
  • Created test cases and test scenarios looking at the PLM Business Requirement Documents: Benefits Requirement Documentation, GCP Documentation for testing.
  • Involved in Facets implementation, end-to-end testing of Facets applications like Claims Processing, Provider, Subscriber/Member, Utilization Management, etc.
  • Executed test cases for the new market as well as existing market’s various line of business.
  • Performed positive testing and negative testing manually.
  • Used HP ALM Quality Center11.0 and as the bug-reporting tool and testing tool.
  • Used Hybrid Methodology (Agile + Waterfall) for System Integration Testing.
  • Worked on Waterfall, V-Model, Scrum and Agile SDLC processes.
  • Developed automated test scripts on Dragon using QTP to automate regression testing.
  • Used select, inner joins, aggregates (SQL) to verify data with expected data.
  • Wrote SQL queries to validate actual record with expected record data
  • Followed a hybrid approach by using both Waterfall and Agile Lifecycle.
  • The Targeted testing for most of the projects were testing of Benefits, Claims Payment, Authorization, Pricing, Readiness Review.
  • Performed Back end Testing-using SQL queries, generating reports to ensure data integrity and validate the inserted and updated data
  • Tested Application functionality, business flow and Database Driven Testing using QTP.
  • Analyzed the responses of the web service using SOAP UI and validating the data in backend.
  • Performed Functional, Regression, and system testing of various Facets modules involved in claims processing, members and providers.
  • Retrieved records from multiple tables from Oracle Database by using joins such as Inner Joins, Outer Joins, and Self Joins.
  • Tested and Validated Request and Response of XML using SOAP UI.
  • Understanding Business and functional requirements, Creating Test Plans, Test strategy and Test cases for all functional requirements using HP Quality Center.
  • Executed Configuration Testing to check if the application was compatible in different environment.
  • Involved in member’s accumulator conversion data testing, accumulator sync testing.
  • Involved in testing HIPAA Transactions & Code Sets Standards like 834-Enrollment to a health plan, 837-Claim, etc.)
  • Logged errors and reported defects using HP Quality Center.

ENVIRONMENT: Windows XP, SOAP UI, MS Office 2007, DB 2, QTP, HP Quality Center 9.0, SQL.

Confidential, Eagan, MN

QA Facets tester


  • Identified the problem of SSN/SID duplication.
  • Worked on various applications such as EAB mainframe, CARE, FACETS, FLEXX mainframe, HIPAA data enquiry, SIR, Look up.
  • Worked on following applications to cut down the duplication.
  • Solid expertise with MS Word, Excel, PowerPoint, and Project.
  • Also worked on FACETS 4.71 member’s implementation.
  • Used HP Quality Center for the test cases, test management, and defect logging and reporting.
  • Experience with ICD-10 conditions to benefit from tailored diseases.
  • Worked exclusively on ICD-9 and good experience on ICD-10 coding systems.
  • As a part of operational production support team, received work request tickets for resolving on daily basis.
  • Troubleshoot any problems found within FACETS and when testing the SQL data database while validating the business rule.
  • Provided weekly project status report to project manager and project presentation to the high level management on monthly basis.
  • Automate test cases with the use of QTP and inserting checkpoints to validate data.
  • Enhanced the scripts in QTP by applying checkpoints, parameterizations, synchronization point, data driven tests and creating modular tests.
  • Worked on developing the business requirement and use cases for FACETS batch process, automating the billing entities and commission process.
  • Assisted project manager for planning and organizing the project activities, and in communicating with other business center managers and stakeholders of the project.
  • Analyzed and documented the limitations of the billing system.
  • Managed project scope and deadlines.
  • Developed automation scripts in QTP to automate smoke and regression testing.
  • Participated in various meetings and discussed enhancement and modification request issues.
  • Performed Gap Analysis.
  • Facilitated Joint Application Development (JAD) Sessions for communicating and managing expectations.

ENVIRONMENT: Windows XP, Facets 4.71, SOAP UI, MS Office 2007, DB 2, QTP, HP Quality Center 9.0, SQL, Oracle, Claims Look Up Environment (CLUE)

Confidential, Blue Bell, PA

QA Tester


  • Involved in HIPAA/EDI Medical Claims Analysis, Design, Implementation and Documentation
  • Involved in HIPPA Complaint X12N837 Transaction testing.
  • Developed and implemented EDI applications to process Health Care transactions as per the HIPAA implementation
  • Conducted Black Box Testing on the application and validated the dataflow in the application.
  • Involved in preparing the Test Scenarios for Health Care Claim Payment/Advice
  • Written multiple Test Cases (System, Integration) for multiple transactions include 837I, 837P, 835, (both inbound and outbound) transactions
  • Determined the requisite ICD10 training for both internal staff and Medicaid provider groups and assisted in the development of training materials.
  • Reviewing the Use Case Requirement, Functional Design Documents and Technical Specification documents.
  • Creating Test Cases after analyzing the BRD’s.
  • Performing Functional and GUI testing on Facets.
  • Prepared test matrices based through defect status in Quality Center.
  • Involve in testing of FACETS Implementation, involve in end to end testing of FACETS Claims Processing module, Membership and benefits.
  • Perform Header and Body Testing as a part of Regression Test using SOAP UI
  • Tested Web Services and WSDL documents by using SOAP UI.
  • Used SOAP over HTTP" as the transportation protocol to create a test SOAP request very quickly.
  • Functional Testing of Member Portal UI for Accident forms and Admin screen which are developed on Grails to handle Human intervention workflow process.
  • Planning for and reviewing the Test cases for Functionality, Security, Performance, Database and User Acceptance testing.
  • Inspected and worked on HTTP web services application and on SOAP APIs.
  • Logged defects in Quality Center and interacted with the developers to resolve technical issues.
  • Performing Backend Testing extensively by writing validation queries on DB database.
  • Validating member’s benefits against the benefits matrix.
  • Analyzed and tested data on claims manually and writing queries on DB database for validating data.
  • Validating member’s accumulator track right member’s benefits and making sure that Claims gets paid according to the SEPY’s rule.

ENVIRONMENT: Configuration and Testing Management (In house Tool), Facets 4.71, SOAP UI, QTP, Interactive SQL, DB2, MS Word, MS Project, MS Excel, Quality Center, QTP.

Confidential, Dublin, OH

QA Analyst


  • Involved in preparing Test Plan and Test Cases based on business requirements.
  • Wrote Test Cases in Excel based on Technical Specifications, Functional Specifications and Business rules for online application system.
  • Authored Test cases for HIPAA EDI Transactions 270/271, 276/277,837/835.
  • Tested HIPAA Transactions and Code Sets Standards according to the test scenarios such as 270/271, 276/277,837/835 transactions.
  • Executed Test cases manually by composing 270, 276,837 EDI files and dropped inbound and check response 271,277,835 using interleaves and outbound.
  • Worked with providers and Medicare or Medicaid entities to validate EDI transaction sets or Internet portals. This includes HIPAA 4010; 837, 835, 270/271, and others. Provided healthcare provider problem resolution. Work as a medical coding SME, including ICD--9.
  • Involved in working on real time test harness.
  • Authored and executed Test cases manually for Tiered Benefit and mapped from website to PMHS.
  • Responsible for writing the Test Cases and Test Scenarios based on the Functional Specification and Technical Specification in Excel and exported them in Mercury Quality Center.
  • Logged errors reported defects, determined repair priorities, did regression testing and close by using Mercury Quality Center.
  • Completed several HIPAA 4010 and 5010 Projects, included Medicaid and Commercial entities. Projects include claims and enrollment testing as well as NPI and medical coding and ICD--9 EDI testing
  • Responsible for performing User Acceptance Testing.
  • Wrote extensive SQL queries for Back End testing.
  • Optimized SQL queries and interacted with development team to resolve anomalies in the database development.

ENVIRONMENT: Windows, Facets, Oracle, SQL, Mainframe, Mercury Quality Center, MS Office, MS-Visio, SOAP UI

Confidential, Chicago, IL

QA Tester


  • Reviewed Business requirement Documents and functional requirements.
  • Maintained Requirement Traceability Matrix (RTM) to make sure that test plans were written for all the requirements.
  • Analyzed system requirements and developed detailed test plan for testing.
  • Performed Smoke and Sanity Testing manually.
  • Performed positive testing and negative testing manually.
  • Detected and reported defects using Quality Center.
  • Identifying Test Cases to be run for Regression Testing and conducting Regression testing as and when new builds were made.
  • Executed Configuration Testing to check if the application was compatible in different environment
  • Performed configuration/ compatibility and user interface testing manually.
  • Used IP Spoofing to simulate multiple users from different machines trying to access the website.
  • Documented the test results and reported the status of assigned test tasks and issues to project manager.
  • Verified HIPAA rules
  • Involved in testing HIPAA Transactions & Code Sets Standards like (820- Premium Payment for enrolled health plan members, 834 Enrollment to a health plan, 835, 837 ...etc.)
  • Organized and participated in weekly QA team meetings
  • Coordinated with developers and Project Manager.

ENVIRONMENT: Windows, DB2, Oracle, Mercury Quality Center, SOAP UI,MS Excel, MS-Visio, File Aid, Oracle, HIPPA, EDI 5010, XML, Mercury Quality Center

Hire Now