SUMMARY:

• Over all over 8 years of strong experience as a QA ETL Tester/ DWH/ BI - Reports Testing & Testing of Software systems in Data Warehouse/ Business Intelligence.
• Experienced in every phase of Quality Assurance Life Cycle (QALC) and Software Development Life Cycle (SDLC)
• Extensive for creating validation rules for HIPAA 837/835/997 on Edifecs Spec Builder.
• Experience in full System Development Life Cycle (Process Engineering, Design, Development, Deployment Support and Testing) using Waterfall, and Agile methodologies.
• Understanding of Data Models, Data Schema, ETL and created extensive store procedures, SQL queries to perform back-end data warehousing testing.
• Strong Data Quality Management background performing analysis, monitoring and tuning to maintain data integrity.
• Knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
• Hands on expertise in Data ware housing concepts and tools. Involved in the ETL processes where in the organizations were using Datastage, Informatica, and Abinitio and Autosys tools.
• Experience in Quality Assurance methodologies like Waterfall, Agile, & Scrum.
• Proficient experience in Manual and Automated Testing of GUI and functional aspects of the Client-Server and Web based Applications on multiple levels of SDLC and Testing Life Cycle (STLC)
• Excellent Knowledge in Microsoft Business Intelligence Technologies like MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS) and SSAS of MS SQL server 2005/2008/2008 R2/2012.
• Experienced in planning, documenting and coordinating End to End Testing, User Acceptance Testing (UAT), Client Testing and obtaining the necessary signoffs from the stakeholders.
• Worked with Rational Suite of tools to create requirements documents (Requisite Pro), visual data models (Rose), manage and track defects (Clear Quest).
• Experience in HIPAA EDI transactions 837, 270/271, 276/277, 999, 835, 834
• Expertise in writing all types of Test Specification document, Test Plans, Test Conditions, Test Cases (both manual and automated) and Test Summary Report.
• Have good experience using Informatica Workflow Manager for running/managing workflows and Informatica Workflow Monitor for monitoring the workflows and checking the session logs.
• Expertise in Functional, Regression, GUI, Performance Testing, Positive/Negative Testing, Black box Testing, Configuration Testing, Data Driven Testing, White Box Testing, Adhoc Testing, User Acceptance Testing (UAT) and Integration Testing.

TECHNICAL SKILLS:-

Testing/Tools: HP Quality Center, HP-ALM, Quick Test Professional, HP Load Runner, Soap UI, Clear Quest.

Databases: Toad Oracle, SQL Server, DB2, MS Access.

ETL Tools: Informatica Power Center Data Stage, SSIS,SSRS, Business Objects, Autosys.

Software/Tools: Microsoft Word, Microsoft Excel, Microsoft Power Point, Microsoft Outlook, Adobe

Operating System: MS-DOS, Unix, WINDOWS-/NT/2000/XP Adv. Server

EDI X12 Transaction: 835, 837, 270/271, 276/277, 834, 997, 999

PROFESSIONAL EXPERIENCE: -

Confidential, Wallingford, CT

ETL Tester

Responsibilities:

• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases.
• Tested Executive Dashboard for Self-service reporting using Cognos portal pages
• Tested Web services using SOAP UI and SOA Reported Defects to developer and generated Reports.
• Performed ETL Testing (on Informatica and Teradata) on Data Warehouse to validate source to target mapping.
• Validated SSIS packages to test ETL batch jobs and exceptions built in the jobs.
• Logged the defects using Quality Center and TFS and used Agile/Scrum methodology.
• Designed Test Plans, Scripts after analyzing various scenarios/requirements & performed defect tracking using ALM.
• Tested Enterprise reports using SQL Server Reporting Services (SSRS). Validated data in reports.
• Experience in Health care/Claims adjudication with knowledge of industry compliance standards like HIPAA and EDIX12 transactions (837,834, 835, 270/271. 276/277 ).
• Coordinated User Acceptance and Quality Assurance testing of mainframe and GUI applications, identified test data, prepared user manual and conducted seminars, installed applications on users.
• Validated SSIS packages to load data to a warehouse from a staging database by using different SSIS Data Flow transformations like conditional split, data conversion, slowly changing dimension, and derived column
• Wrote SQL and PL/SQL scripts to perform database testing and to verify data integrity.
• Used JIRA for Sprint storing creating, tracking and update for entire sprint
• Successfully completed (accepted by customer) a conversion of a Cognos reporting system into Business Objects.
• Extensively involved in the Performance testing of the programs, ETL Procedures and Processes.
• Did Transformation and data cleansing activities use various data flow tasks in SSIS packages during data migration.
• Performed Database testing (Data Warehouse/ETL) on ETL applications validating the data in Sources/Targets using Data Stage Client Tools.
• Created and executed test Plans, Test cases, Test cycles with in JIRA.
• Tested web services by generating XML SOAP requests and validated the corresponding XML SOAP responses.

Environment: ETL, Informatica, Autosys, HP ALM, Quality Center QTP UAT, SSIS, SSRS, Business Intelligence, Pearl, Agile, Clear Quest Quality Centre, SOAP UI, SQL,Toad, Mainframe Oracle Pl/SQL.

Confidential

ETL Tester

Responsibilities:

• Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
• Analyzing requirements and creating and executing test cases
• Involved in ETL process testing using Informatica ETL tool.
• Test Case Execution and Adhoc testing
• Used SQL queries to perform the back-end testing on Oracle. Co-ordinate in application setup for UAT Testing.UAT Testing done based on UAT Test Cases.
• Created reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
• Performed Integration, End-to-End, system testing.
• Involving in Functional Testing & Regression Testing.
• Provided Efforts Estimate and coordinated the test schedule using Agile testing methodology in UAT phase.
• Involving in writing SQL queries and Database Checkpoints to verify data quality and calculations, reviews
• Performed data validation testing writing SQL queries.
• Wrote complex queries in Teradata SQL assistant to check the data from Source and Target.
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica.
• Performance monitoring for ETL Solution using project parameters, connection manager, and SSIS packages
• Working on Quality Center for creating and documenting Test Plans and Test Cases and register the expected results
• Experience assessing testing processes, creating and implementing testing strategies in UAT phase.
• Using HP Quality Center for storing, maintaining the test repository, bug tracking and reporting.
• Preparing documentation for some of the recurring defects and resolutions and business comments for those defects
• Developed UNIX scripts to validate the flat files and to automate the manual test cases.
• Developing Test Matrix to give a better view of testing effort

Environment: Informatica Teradata SQL, DB2, Oracle, HP Quality Center, Agile, SSIS, SSRS, Rational Clear Quest, Remedy, Microsoft Office, HP/Unix.

Confidential, Minneapolis, MN

QA /ETL Tester

Responsibilities:

• 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.
• Wrote SQL Queries for Back End Testing.
• 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
• Performed thorough analysis of the companion guides from each trading partners both Medicaid as well as Commercial clients and identified the changes that specific clients need
• Used QTP to perform Regression Testing.
• Reviewing the Use Case Requirement, Functional Design Documents and Technical Specification documents.
• Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing in a corporate-wide-ETL Solution using Informatica.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation.
• Responsible to design, develop and test the software (Informatica, PL SQL, UNIX shell scripts) to maintain the data marts (Load data, analyze using OLAP tools).
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases.
• Developed Executive Dashboard for Self-service reporting using Cognos portal pages
• Tested Web services using SOAP UI and SOA Reported Defects to developer and generated Reports.
• Performed ETL Testing (on Informatica and Teradata) on Data Warehouse.
• Worked as BI Report Author on Cognos toolset including Report Studio, Query Studio, Analysis Studio, Framework Manager and Transformer.
• Created SSIS packages to manage SQL server databases and SQL server objects between instances of SQL server.
• Logged the defects using Quality Center and TFS and used Agile/Scrum methodology.
• Designed Test Plans, Scripts after analyzing various scenarios/requirements & performed defect tracking using Test Director & Clear Quest.
• Experience in Health care/Claims adjudication with knowledge of industry compliance standards like HIPAA and EDIX12 transactions (837,834, 835, 270/271. 276/277 ).
• Used various SSIS tasks such as conditional split, derived column on the data retrieved, performed data validation checks during staging, and then loaded the data into the data warehouse.
• Coordinated User Acceptance and Quality Assurance testing of mainframe and GUI applications, identified test data, prepared user manual and conducted seminars, installed applications on users.
• Used Descriptive programming in scripting dynamic objects and reusable actions in defining scenario flows in Quick Test Professional (QTP).
• Completes code to implement solutions using SQL, Shell scripts and Autosys.
• Used JIRA for Sprint storing creating, tracking and update for entire sprint
• Successfully completed (accepted by customer) a conversion of a Cognos reporting system into Business Objects.
• Extensively involved in the Performance testing of the programs, ETL Procedures and Processes.
• Did Transformation and data cleansing activities use various Control flow and data flow tasks in SSIS packages during data migration.
• Used Data warehousing for Data Profiling to examine the data available (Data Analysis) in an existing database
• Performed Database testing (Data Warehouse/ETL) on ETL applications validating the data in Sources/Targets using Data Stage Client Tools.
• Created and managed Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Involved in Data Mining, Data Profiling and Data Modeling.
• Created and executed test Plans, Test cases, Test cycles with in JIRA.
• Tested web services by generating XML SOAP requests and validated the corresponding XML SOAP responses.

Confidential, Long Beach, CA

QA Analyst

Environment: HP/ALM, Jira, HIPAA, EDI, SQL Server.

Responsibilities:

• Developed Test Plans, Test Cases for the test
• Worked on HIPAA Transactions and Code Sets Standards according to the test scenarios such as 270/271, 276/277,837/835 transactions.
• Tested the interface between database and the application.
• Participated in requirement walkthroughs and creation of test plan.
• Experienced in backend testing by executing SQL Queries.
• Checked the data flow through the frontend to backend and used SQL Queries to extract the data from the database.
• Configuration and evaluating the impact of proposed changes in rules and regulations.
• Involved in writing extensive SQL Queries for back end testing oracle database.
• Retrieved files using SQL statements.
• Maintained Traceability matrix and Test Matrix.
• Performed Smoke Testing.
• Created and maintained SQL Queries for back-end testing.
• Maintained various versions of Test Scripts.
• Validated records, structure of tables, Indexes, Triggers in tables after migration.
• Analyzed system requirements and developed detailed test plan for testing.