We provide IT Staff Augmentation Services!

Etl Uat Edi Tester | Qa Analyst Resume

Tucson, AZ

SUMMARY:

  • Experience on QA EDI ETL UAT Web Services, System Integration Testing (SIT) and Data Analysis of various business applications in Client/Server environments, web - based applications.
  • Excellent understanding of the Software Development Life Cycle and role of QA in Manual Testing.
  • Excellent ETL/BI testing experience with extensive backend testing with good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architectures and Database concepts.
  • Excellent understanding of Web Based testing.
  • Expertise in Integration testing, System Testing, and generating test plans, test cases and test scripts.
  • Experience in Front-end GUI testing of web based applications and client/server applications.
  • Strong skills in performing System Integration, Acceptance, Functionality, Front End and GUI Testing.
  • Performed System, Integration, Smoke, Regression testing and UAT.
  • Performed ETL/BI testing and Backend testing using SQL Queries.
  • Extensive experience in writing complex SQL and PL/SQL scripts
  • Expertise in PL/SQL procedures functions and packages.
  • Well versed with complete process in executing the Test Scripts and Bug Reports.
  • Manually conducted Functionality and GUI testing during the various phases of the development of the application manually.
  • Experienced in writing and executing SQL queries to verifying Source-to-Target Mapping.
  • Investigated bugs, tracked using HP Quality Center and interacted with developers to resolve technical issues.
  • Experience working in a FACET environment and gained knowledge about various modules of a FACET system such as claims, membership and pre-pricing etc.
  • Excellent knowledge of HIPAA standards, EDI (Electronic data interchange), transaction syntax like ANSI X12, Implementation and Knowledge of HIPAA code sets, ICD-9, ICD-10 coding and HL7.
  • Tested Product for Copay, HRA, MOPS Maximum Out of Pocket, PSL Plan Stop Loss.
  • Experience worked on any requirement upgrade and/or change request while doing UAT.
  • Skilled knowledge on different modules within Healthcare Claims Adjudication Process (Membership process, Billing process and enrollment and claims processing).­
  • Experienced in testing Crystal, SSRS, Cognos and Business Objects, OBIEE Reports.
  • Experience in Data Analysis, Data Validation, Data Verification, data profiling, identifying data mismatch and Good experience with data sources.
  • Excellent experience on migration from Oracle reports to Business Objects.
  • Excellent knowledge on Medicaid Management Information System (MMIS).
  • Tested the entire functionality of the application on different browsers and operating systems.
  • Experienced using test management tools like Quality Center and Clear Quest, Test Director.
  • Experience in usage of defect tracking tools Quality Center for logging the defects, generation of reports and analyzes the reports.
  • Good knowledge in using UNIX environments.
  • Worked as onsite offshore coordinator.
  • Comprehensive knowledge of Test Driven Development, Agile and Waterfall Methodology.
  • Experience in all phases of software development life cycle that includes requirement study, analysis study, and testing of various client/server and web application.
  • Quick learner with an ability to rapidly achieve design and production requirements, detail-oriented with good organizational skills.
  • Experience in Testing ETL, Store Procedures, PL/SQL, UNIX batch jobs using scheduling tools such as Autosys, Cron tab, Control-M.
  • Ability to deal with a fast paced production environment.
  • Excellent communication, interpersonal, intuitive, technical, analysis, problem solving skills.
  • Thrive in both independent and collaborative work environments.

TECHNICAL SKILLS:

Testing Tools: HP Quality Center 11.0/10.0/9.2 , DOORS, TFS

Databases: SQL Server, MS Access 2000, Oracle, DB2, Teradata, Hadoop

ETL tools: Informatica, Ab Initio and Data Stage, Informatica MDM, IDD

BI Reporting Tools: Cognos, MircroStrategy, Business Objects

Software QA & Testing: SDLC, STLC, Test Plan Development, Development and

Technologies: XML, Web Services, PHP

Operating System: Windows 2000, Windows NT, Windows XP, UNIX, LINUX

Languages: SQL, PL/SQL, XML, HTML, C, Java, .NET, Visual Basic

Others: Putty, WinScp, TextPad, SSH, SalesForce, Hadoop Hive

PROFESSIONAL EXPERIENCE:

Confidential, Tucson, AZ

ETL UAT EDI Tester | QA Analyst

Responsibilities:

  • Wrote test cases for all Provider and Member data according to BRD and STM document, and uploaded test cases in JIRA by using Zephyr
  • Worked with business analysts in preparing test plan and test cases based on BRD and STM document for the mapping developed through the ETL tool from the requirements.
  • Analyzed the Business Requirements and Rules and worked with Business Analysts and Business Users in preparing Test Plans.
  • Involved in FACETS Implementation, involved end-to-end testing of FACETS Billing, Claim Processing and Subscriber/Member module.
  • Excellent experience in application upgrade/migration testing.
  • Tested the HIPPA EDI 834, 270/271, 837/835 transactions according to test scenarios and verify the data on different modules.
  • Experiences working in ANSI x12 EDI Transaction.
  • Analyzed the Functional Specifications and implemented their technical aspect in System and Integration testing (SIT).
  • Developed Test cases, Test scripts from the data mapping documents, functional Specification documents and mapped the test cases with the requirements for generating the Requirement Traceability Matrix (RTM).
  • Worked on all the stages of SDLC for this project and designed and executed Functional, Integration, Regression, System (End to End) and Backend (Database).
  • Developed and executed test cases and test scripts, performed Integration, Regression, Performance and Functional Testing.
  • Performed Manual Testing as well as Automation Testing for the EDI transactions.
  • Conducted GAP analysis and filling gap according to the format set by HIPAA.
  • Worked on the Functional Specifications and implemented their technical aspect in System and Integration testing (SIT).
  • Good Understanding of the EDI (Electronic data interchange), Implementation and Knowledge of HIPAA code sets.
  • Performed data validation on the flat files that were generated in UNIX environment using UNIX commands, and worked with the UNIX shell scripts.
  • Validated the responses of web services by passing various requests in SOAP UI, and used HP Quality Center as test management tool.
  • Prepared Requirement Traceability Matrix (RTM), Test Status reports and Test Sign off documents.
  • Involved with project backlogs and sprint backlogs.
  • Performed Negative testing using Informatica to find how the workflow performs when it encounters invalid and unexpected values.
  • Tracked and executed the User Acceptance Test Cases (UAT) with respect to the requirements to determine the feature coverage.
  • Involved in validating SSIS and SSRS packages according to functional requirements.
  • Involved in testing Stored Procedures, Functions, Triggers and packages utilizing PL/SQL.
  • Worked on Autosys for Batch Processing ETL, PL/SQL subprograms and performed backend testing.
  • Verified ETL logs and reject/discard files for errors and reported them to development team.
  • Worked on Informatica Workflow Manager to run the workflows and monitored the status and logs in Workflow Monitor.
  • Extensively tested Cognos reports for static/cosmetic errors like header, footers, logos, fonts etc which may appear in all pages of the reports.
  • Performed Backend database testing, by executing the Group functions, complex Joins and sub queries.
  • Validated the data moving from multiple sources to target using Informatica data validation option
  • Extensively written SQL to confirm the data transfer from sources to target.
  • Tested the PL/SQL procedures, functions, packages according to the requirements.
  • Performed Backend database testing, by executing the Group functions, complex Joins and sub queries.
  • Verified test results (viewing the log files, querying the database) documenting the defects.
  • Involved in testing the UI screens, reports which was used by the internal business team.
  • Involved in defects tracking meetings for system integration testing and communicated the issues and escalations with the project manager.

Environment: Informatica, Informatica DVO, Clear Case, Clear Quest, RequisitePro, Quality Center, Facets, SharePoint, HP ALM, Web Services, Soap UI, JIRA, XML, Oracle 10g, SQL Server 2005/2008, DB2, PL/SQL, UNIX, Putty, Flat Files, Session Logs, Rally.

Confidential, Richfield, MN

ETL QA Tester| Data Analyst

Responsibilities:

  • Worked on technical aspects of RPM Conversion including knowledge of MCW and other conversion tools
  • Involved in sending Report status of all conversion-related data tasks to RPM Data Conversion Lead.
  • Worked with RPM Store Readiness team to understand the work required by the Data Conversion Support team
  • Participated as a product owner/user in requirements/design, testing and providing user feedback on data conversion tools
  • Recommended for efficiencies/process improvements to streamline overall conversion
  • Participated in rollout planning and strategy meetings to provide input on teams role in the process
  • Worked with RPM Store Readiness team to understand the work required by the Data Conversion Support team.
  • Participated as a product owner/user in requirements/design, testing and providing user feedback on data conversion tools
  • Developed ETL Test Plans, Test Strategies and Test Cases.
  • Coordinated with Business Users to understand business needs and implement the same into a functional Data warehouse design.
  • Worked on writing SQL queries to verify the count and data difference between source tables to landing tables, landing to staging tables and staging to base tables.
  • Wrote several complex queries to validate De-normalized tables and materialized views.
  • Created and maintained test cases for ETL mappings and design documents for production support in HP ALM based on the Source to Target documents
  • Validated the MDM tables by executing the SQL scripts based on the transformation/clinching rules and designed Test data for Informatica MDM to be entered through IDD.
  • Tested the ETL Informatica mappings and other ETL Processes (DW testing)
  • Worked on validating ETL target tables in table level and column level looking at the complexity of Source to Target document.
  • Tested data migration to ensure that integrity of data was not compromised
  • Involved in preparation of Defect reports, Weekly status report and presentation documents with testing data and testing results
  • Performed defect tracking and reporting with strong emphasis on root cause analysis to determine where and why defects are being introduced in the development process using SQL to narrow down the root cause of the problem
  • Created data set for process ability to validate different workflows for ETL mapping rules to test the functionality according to requirements of the FMDR application
  • Involved in communicating with business, support, and development teams to resolve issues during test execution.
  • Worked in Agile Software Development environment, Participated in daily stand-ups, Iteration planning meetings and Iteration Retrospective meetings
  • Effectively communicate testing activities and findings in oral and written formats
  • Developed test cases in Excel and uploaded to Quality Center.

Environment: HP ALM, Informatica, Clarity, Service Now, MDM, SalesForce, ORACLE, XML, Clear Quest, UNIX, putty, TOAD, SQL, PL/SQL, JIRA, MS SharePoint, JAVA, SoapUI

Confidential, Tucson, AZ

Quality Analyst

Responsibilities:

  • Worked on Confidential ’s Enhanced Data Warehouse and Data Migration from Legacy System to Enhanced Data Warehouse.
  • Wrote Test Cases for EDW - Data ware house (Source to Target) and Cognos Standard Reports, OLAP and CUBES.
  • Wrote complex SQL queries for positive and negative testing in validating data ware house tables.
  • Involved in testing Stored Procedures, Functions, Triggers and packages utilizing PL/SQL
  • Conducted Test plan reviews, Test case reviews by analyzing the requirement specifications.
  • Worked on traceability matrix to map Test cases against Requirements using Quality Center.
  • Wrote Test Cases for EDW - Data ware house (Source to Target) and Cognos Standard Reports.
  • Involved in working with slowly Changing Dimension type 1, type2 and type 3 based on the requirement.
  • Validated ETL DW load statistics and Data mart Loads on an Ongoing Basis.
  • Worked on FACET environment and gained knowledge about various modules of a FACET system such as claims, membership and pre-pricing etc.
  • Worked as per the HIPAA standards, EDI (Electronic data interchange), transaction syntax like ANSI X12, Implementation and Knowledge of HIPAA code sets, ICD-9, ICD-10 coding and HL7.
  • Tested Product for Copay, HRA, MOPS Maximum Out of Pocket, PSL Plan Stop Loss.
  • Validated Source - Target mappings applying various transformation rules and Business Rules.
  • Validated Data ware house DB2 tables and verified the defects.
  • Involved in testing Data Stage ETL jobs for the data quality and number of the records.
  • Validated Adhoc Reports, OLAP Reports for Data Accuracy.
  • Created various complex SQL scripts for functional validation of ETL applications.
  • Worked in creating scenarios for row count validations in EDW.
  • Created test sets based on scenarios to validate EDW.
  • Participated in Defect Review meetings periodically.
  • Worked on Test management using DOORS.
  • Validated Cubes, Adhoc Reports and Standard Reports built from Cognos.
  • Working Experience with Agile Development Methodology.
  • Reviewing the project and coordinating with onsite Clients, onsite Project Leads and local reporting managers
  • Responsible for reviewing and modifying test scripts after initial iterations of testing phases to in corporate changes in project environment

Environment: DB2, SQL Server, SSIS, Cognos 8.0, IBM Ascential Data Stage, Mercury Tools (Quality Center), Remedy, RapidSQL, UNIX, Flat Files, Rational Clear Case, Rational Clear Quest, DOORS

Confidential, Columbus, OH

Quality Analyst

Responsibilities:

  • Responsible for developing and executing test plans, test cases, and SQL scripts based on the requirements and Source to Target documents and also responsible for creating and updating user-defined functions to meet the current business requirements.
  • Involved in extensive end to end DATA validation and back-end testing using SQL queries.
  • Written several complex SQL queries for validating staging and data warehouse Tables.
  • Wrote SQL scripts and PL/SQL queries using TOAD and Oracle SQL Developer to query DBs and analyzed the results.
  • Validated database structure based on the Source to Target documents.
  • Used Informatica workflow manager to execute the workflows and informatica workflow monitor to monitor the status of the workflows.
  • Performed Black Box Testing based on the functional requirements and product specifications of the application including smoke, regression and functional testing using Quality Center.
  • Performed User Acceptance Testing, GUI testing, Smoke testing etc.
  • Involved in daily stand up meetings, weekly project follow-up meetings to update the LOE and report on the testing progress.
  • Reported defects on Quality Center and followed bug life cycle.
  • Have tested reconcile and incremental ETL loads for the project.
  • Involved in validating various batch jobs scheduled using autosys
  • Involved in validating SSIS and SSRS packages according to data mapping specifications.
  • Involved in validating SSAS cubes according to functional specifications.
  • Involved in testing the XML files and checked whether data is parsed and loaded to staging tables
  • Focused on Data Quality issues / problems that include completeness, conformity, consistency, accuracy, duplicates, and integrity.
  • Validated Cubes, Adhoc Reports and Standard Reports built from Cognos.
  • Tested the Front-end functionality for the application.
  • Used Informatica MDM to cleanse data coming from source and to deliver consolidated and reliable data
  • Used IDD to insert data to MDM through UI
  • Developed test cases in Excel and uploaded to Quality Center.
  • Involved in testing reports and closely worked with operations, and Release teams to resolve the production issues.
  • Designed test data using MS Excel sheet to test the application with positive and negative inputs.
  • Involved in managing test cases and test execution in TFS
  • Used Toad to run SQL queries to check data is populating as expected from tables.

Environment: Informatica Power Center 9.1, SQL, PL/SQL, Quality Center 10.0, Oracle 11g, Cognos 10, SQL Server 2005, SSIS, SSRS, Java, XML, Autosys, Clear Case, Clear Quest, TFS, UNIX, TOAD

Confidential, Tempe, AZ

ETL Tester | Data Analyst

Responsibilities:

  • Developed and conducted a wide range of tests and analysis to ensure that software, systems, and services meet minimum company standards and defined end-user and system requirements.
  • Evaluated business requirements and technical specification documents to craft test strategies and LOE assessments which would account for durations, constraints, assumptions, etc. that are required to accomplish test objectives.
  • Involved in high and detail level design reviews to ensure requirement traceability and to determine application/component functional readiness requirements.
  • Involved in End-to-end testing whether the flow of an application is performing as designed from start to finish.
  • Being part of the test team, responsibilities involved writing complex queries using SQL and PL/SQL to generate data based on the complex derivations for each attribute.
  • Complex SQL queries were written to compare data generated by the application against the expected results generated based on mapping requirements for each interface.
  • Experienced on Master Data Management (MDM)
  • Exclusively involved in execution of jobs, PL/SQL batch programs and responsible for reporting the defects to development team.
  • Responsible to test the functionality of Ab Initio graphs.
  • Validating the data passed to downstream systems.
  • Worked with the development team to create a suite of test data (Input files, Expected results), that fully exercises data validation (detecting, rejecting bad data) to test ETL functionality (properly processing).
  • Involved in maintaining the test environments; with activities like requesting data loads, data base backups, restarting the servers, requesting the deployments, troubleshooting issues.
  • Tracked and executed the User Acceptance Test Cases with respect to the requirements to determine the feature coverage.
  • Involved in testing of inbound and outbound interfaces (Loan, Pool and FS (accounting)) from SIR to downstream/upstream systems.
  • Performed the file level, field level validations for loading of data into staging tables by Ab Initio graphs.
  • Written SQLs to validate Ab Initio ETL graphs according to data mapping specifications.
  • Validated the archive process to purge the data that meet the defined business rules.
  • Responsible for testing Initial and daily loads of ETL jobs.
  • Involved in testing the batch scheduling programs by using the Autosys tool.
  • Responsible for preparing test cases and scenarios for System testing and UAT testing.
  • Have worked in Technical Operations team for CDW ETLs execution support.
  • Creating and maintaining repositories, source systems, target databases and developing strategies for ETL mechanisms using Ab Initio.
  • Involved in creating various data scenarios (Excel Sheets having expected data) and validating them before and after running the respective Autosys batches.
  • Developed UNIX scripts for file archiving, file transfers and file management.
  • Involved in Database Validations, Writing Test scripts (Including the related SQL Statements by joining various tables) depending on Requirements for both Positive and Negative Scenarios.
  • Involved in Security Access Testing for Role based Internal and External Users, on S/IR System
  • Linking Requirements from DOORS, to Test Scenarios in Quality Center.

Environment: Quality Center 10.0, Quality Center 11.0, Cognos 10, DB2, ORACLE, XML, Control-M, Clear Quest, UNIX, TOAD, SQL, PL/SQL, Enterprise Architect, Ab Initio, JIRA, SalesForce, MS SharePoint, SoapUI

Hire Now