We provide IT Staff Augmentation Services!

Sr. Etl Tester/bi Tester/edi Tester Resume

Festus, MO

SUMMARY:

  • Over 8+ years of Software ETL Tester/Data warehouse Tester/BI Reports Tester Quality Assurance/Data Analysis experience working with Web - based testing, Service Oriented and Client/Server applications.
  • ICD 9-ICD 10 Conversion knowledge -Worked in the analysis of the ICD 9 - 10 codes. HIPAA 4010 - 5010 Conversion Analysis -Involved in documentation of HIPAA 5010 changes to EDI 837, 834, 835, 276, 277 Transactions.
  • Experience in testing APIs level testing. Good knowledge of Medicare/Medicaid (MMIS) rules.
  • Deep understanding of QA Process, Test Methodology and Software Development Life Cycle (SDLC), Waterfall, Agile and RUP. Good working knowledge of AMYSIS and FACETS.
  • Solid experience with all levels of testing including Smoke Testing, Unit testing, Functional Testing, Integration Testing, System Testing, Regression Testing and UAT.
  • Experienced in writing Test plans, Test Cases, Test Scenarios and defining the Testing methodologies and verifying and validating the web based applications.
  • Developed different Automation Frameworks like Linear, Structured, Keyword in HP Quick Test Professional, HP Quality Center/ALM, JIRA, Bubzilla, MTM and TFS.
  • Experienced in both Manual and Automated testing tools using HP Quality Center/ALM, Bugzilla, JIRA, TFS, MTM, Test Director and QTP with VB Script.
  • Good knowledge in web application testing and automation testing using Selenium.
  • Excellent knowledge and working experience in Test Planning, Test execution, Test Results Analysis, Requirement Traceability Matrix and analyzing business requirements.
  • Good Working knowledge of Linux, UNIX, IOS and Microsoft operating systems. Effectively worked on Hp Load Runner for performance testing and developed test scripts.
  • Experienced in Functional, Load and Data Driven Testing in using SOAP UI. Extensively verified and validated XML request and response files Web Services from the third party service provider using SOAP UI.
  • Extensively involved in Build Acceptance Testing, Functional Testing and Database Testing using SQL Server, Oracle, Teradata, DB2, MongoDB, Hadoop, Bigdata and Netezza. Excellent working Knowledge of Databases like MS Access, SQL server, Oracle with PL/SQL and Stored Procedure.
  • Good knowledge of ETL Testing/ETL Analysis, for designing of the flow and the logic for the Data warehouse project and performed the testing.
  • Experienced in testing other web technologies like J2EE, Java Scripts and ASP.NET. Excellent hands on MS office applications. Good knowledge using the reporting tool Cognos, Business Objects, SAS, Hyprion, SSRS, Hyperion and Microstrategy.
  • Organized, detail-oriented and have the ability to work well in a time sensitive environment. Excellent communication and presentation skills, self-starter, quick learner and team player.

WORK EXPERIENCE:

Confidential, Festus, MO

Sr. ETL Tester/BI Tester/EDI Tester

Environment:Oracle 11g, Facets 5.01, SOA Framework, ETL, Data warehouse, Informatica, SQL server management studio, MS Outlook, Linux, MS Excel, MS Access, QTP, HP ALM, MS Visio, JIRA, Cognos.

Responsibilities:

  • Worked as a Quality analyst (backend and front-end tester) in the financial management, member enrollment and eligibility module for the UAT and production environment for the Washington Health Finder web application.
  • Involved in testing to verify that all data were synchronized after the data is troubleshoot, and also used SQL to verify/validate.
  • Responsible for testing entire member enrollment and eligibility workflows as per business requirements using Facets 5.01
  • Used JIRA to raise defects and submit the tickets to the respective level.
  • Responsible for communicating with the client for weekly status report and also with the offshore team.
  • Participated in Daily and weekly status meeting with team members and coordinated with teams (Development, Business, and QA) for the progress of the work done in application.
  • Responsible for running batch jobs (daily and monthly) to create the EDI files from the existing XML.
  • Responsible for validating and analyzing the EDI 834 and 820 files. Created jobs to schedule multiple reports in Cognos connection.
  • Reviewed Informatica ETL mappings/workflows and SQL that populates EDW and data mart Dimension and Fact tables to ensure accuracy of business requirements.
  • Performed Back end testing by writing SQL statements like Join, Inner Joins, Outer joins and Self Joins used TOAD and SQL Developer.
  • Participated in business requirements reviews and software system (application) designs for testability.
  • Track and report upon testing activities, including the test case execution stage, defect status if any defects opened during execution and the testing results status.
  • Performed end to end data validation using ETL and BI tools.
  • Wrote Use Cases, prepared use case diagrams (using Rational Rose & UML) and followed Agile at every stage of the processes.
  • Developed SQL Queries for checking the Data Transaction and Database Integrity. Provided technical and procedural support for User Acceptance Testing (UAT)
  • Assisted in GAP analysis for any available requirements and communicated through the CR process.

Confidential, Kansas City, MO

Sr. EDI Tester/SQL Tester/ETL Tester

Environment: HP Mercury Quality Center, UNIX, Facets 4.81, Rational Clear Quest, MS Excel, MS Visio, Oracle BI, Business Objects, SSIS, Informatica, DWH, XML, Selenium, Cognos.

Responsibilities:

  • Coordinated, Managed, Mentor and Lead the offshore team in all the activities regarding Testing and conversion of legacy system to the newest version of Facets 4.81.
  • Worked on Member Enrollment and Billing module for the implementation of Facets.
  • Highly Responsible in developing High Level Test Scenarios from the Business requirement/Functional requirement document.
  • Get approval from the business/ Client for the Test Cases/Test Plan, Data Setup and Execution of Test Cases.
  • Logged defect in Quality Center (QC) 10.0, and assigned to an appropriate developer.
  • Document all the Test Results (TR) from the Scenarios and submit to respective POC.
  • Supported and provided valuable suggestions to the ETL Tester / ETL Analysis, for designing of the flow and the logic for the Data warehouse project and performed the testings.
  • 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
  • Involved in Adjustment of the Pharmacy Claims (Reversing the Claims, RR, RRCR, RRMR), and paying various types of claims. I.e. DMR (Paper Claims), PTP, Government claims, E-claims, MSP (Medicare secondary payer), COB, steps on running ERIC, EXTRACT, CET and NDM process.
  • Performed smoke, Integration, Functional, and Regression Testing.
  • Handled and worked in multiple projects at the same time within the given time frame.
  • Reviewed Informatica ETL mappings/workflows and SQL that populates EDW and data mart Dimension and Fact tables to ensure accuracy of business requirements
  • Attend multiple meetings with the client Lead, Developer, and Project Manager to fully understand the functional and technical requirement, and to discuss the Test Scenarios Created.
  • Highly involved with the Client to better understand the system and the business requirements.
  • Wrote and Review test cases in QC, and Matrix the requirement documents along with it.
  • Provide answers to the users for the test cases created and explained the final results, and the important functionality in the project.
  • Conducting the Test Results walkthrough with the Clients and getting Sign off to deploy project on time.
  • Involved in integration testing between EAS and RxClaim.
  • Prepare TR (Test Results) documents via Quality Center and provide to the Clients on each project.

Confidential, Independence, MO

Sr. SQL Tester/QA Tester/Facets Tester

Environment: SOA Framework, MS Visio, Word, Excel, PowerPoint, Facets 4.71, CMMI, Rational Rose, Requisite Pro, Clear Quest, Claredi, SQL, Oracle, J2EE, Load Runner, Cognos, Data warehouse.

Responsibilities:

  • Responsible for testing entire claims processing workflows as per business requirements using Facets 4.71.
  • Gathered requirements and reviewed Use Cases for the applications that used SSN and DOB as unique identifiers.
  • Analysed URS and Functional Requirements Specifications to understand business rules of application.
  • Validated displays of Patient Screen to include masked SSN & DOB Information.
  • Claims Process validation - Identified Claims Matching Scenarios upon which millions of Claim records were matched daily based on Patient's Information
  • Involved in writing Test plans, creating Test scripts, and Team Co-ordination
  • Performed Analysis of ICD 9 Procedure and Diagnosis Codes in accordance with ICD 10 CM and ICD 10 PCS Conversion Compliances
  • Participated in meetings and JAD sessions to ensure legal and compliance deadlines of CMS (Centers for Medicare and Medicaid Services) are met
  • HIPAA 4010 - 5010 Conversion Analysis - Involved in the documentation of HIPAA 5010 changes to EDI 837, 834, 835, 276, 277 Transactions.
  • Defined the approach for automating significant parts of the QA framework.
  • Responsible for carrying out manual testing like Integration, Regression testing during various phases of test cycles.
  • Interacted with dev. & various members to discuss and resolve defects based on priorities.
  • Supported and provided valuable suggestions to the ETL Tester / ETL Analysis, for designing of the flow and the logic for the Data warehouse project and performed the testing's.
  • Developed and Maintained Test Schedule for Quality assurance deliverables.
  • Responsible for working with application team in UAT and Production Release.
  • Documented defects in IBM Clear Quest and provided test execution progress updates.

Confidential, St. Louis, MO

ETL QA Tester/ETL QA Tester/SQL Tester

Environment: Oracle 9i/10g, SQL, TOAD, ETL/Informatica, DB2, Business Objects XIR2, XML, Flat Files, Shell Scripting, UNIX, Windows NT

Responsibilities:

  • Configured the QA Environment for Manual Testing that includes data level testing and web application testing. Used QTP for web application testing as well.
  • Performed Business objects testing and validating the results against Data warehouse.
  • Tested the data and data integrity among various sources and targets. Well exposed to SDLC system and its methodologies.
  • Review the different subject areas like Formulary, Customer, Sales, Employee, Aggregates etc and provide feedback and comments that help in fulfilling the goal of EDW project.
  • Participated in Daily and weekly status meeting with team members and coordinated with teams (Development, Business, and QA) for the progress of the work done in application.
  • Analysed the Specifications and involved in identifying the source data needs to be moved to data warehouse.
  • Good experience in communicating with offshore team. Communication with the client for weekly status report
  • Helped the team in analyzing the data to be able to identify the data quality issues
  • Supported and provided valuable suggestions to the ETL Tester / ETL Analysis, for designing of the flow and the logic for the Data warehouse project.
  • Involved in testing to verify that all data were synchronized after the data is troubleshoot, and also used SQL to verify/validate my test cases. Involved in various testing phases like Functional Testing, Integration Testing, Data Validation Testing Positive and Negative Testing, Sanity Testing, User Acceptance Testing and Regression Testing.
  • Used HP Quality center to write and run the test cases and to raise and track the defects.
  • Participated in Daily and weekly status meeting with team members and coordinated with teams (Development, Business, and QA) for the progress of the work done in application.
  • Developed Test Plan and Test Strategy for multiple data feed applications.

Confidential, Kansas City, MO

Manual Tester/SQL Tester

Environment: SQL Server 2005, IIS, XML, Web Services, SOAP UI, VB-Script, HTML, Toad, MSOffice, Mozilla Firefox, Microsoft Visual Studio, Microsoft Visual Studio Source Control Explorer as TFS, HP Quick Test Pro 9.5, Load Runner 8.0

Responsibilities:

  • Involved in writing test cases and test scripts to verify requirements and design in an economic and efficient manner based on defined testing standards.
  • Responsible for ensuring quality and correctness of reusable software components developed in an SOA service model, to verify that the programs function & conform to established guidelines in RUP software process Model.
  • Involved in writing QTP Scripts for Functionality and Regression testing for the web based and for the XML Web services using SOAP UI and used XML as input and output.
  • Performed end-to-end test execution in a distributed SOA environment, testing applications both at the UI level and without UI at the service layer
  • Coordinated and Collaborated with QA team, Architects, Managers/Project Managers, Business Analysts, Leads, and Developers to ensure that the Quality Assurance deliverables and approach are comprehensive and meet required objectives.
  • Ensured Test traceability from high-level requirements to lower level requirements to test cases.
  • Identified and executed positive and negative test cases and test scenarios and the data sets required supporting them.
  • Assisted in development of the Test Plan/Strategy by identifying based on project scope, proposed methodology, and project risks.
  • Responsible for defect identification, documentation, communication and tracking in accordance to related procedures in the available tools.
  • Involved in writing complex SQL Queries for Backend Verification and Comparison using case, joins and unions in SQL Server 2005 for a huge data driven testing Project
  • Involved in writing Stored Procedures for a project using a complex query in SQL server 2005
  • Involved in developing specific project related Data Driven Testing tool in SQL Server 2005 which can be used in Automated regression of several Cycles in order to validate previous versions
  • Build Automation Regression test suite and Smoke test suite in QTP.
  • Involved in writing functional automation framework code by using Descriptive programming

Hire Now