SUMMARY:

• Over 8 years of experience Software Quality Assurance (QA) experience testing Data Warehouse, Database (ETL & BI), Web, Client - Server Systems and Applications for various Industries.
• Experience in defining Testing Methodologies; creating Test Plans and Test Cases, Verifying and Validating Application Software and Documentation based on standards for Software Development and effective QA implementation in all phases of Software Development Life Cycle (SDLC).
• Strong in Software Analysis, Planning, Design, Development, Testing, Maintenance and Augmentation for various applications in data warehousing, metadata repositories, data migration, data mining and Enterprise Business Intelligence.
• Expert in ETL, Data Warehousing, front-end and BI testing. Strong experience in Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export through the use of multiple ETL tools such as Ab Initio and Informatica PowerCenter
• Extensive experience in writing SQL to validate the database systems and for backend database testing.
• Extensively worked on design and implementation of Database Management Systems such as Oracle, Hadoop, MongoDB, Teradata, DB2 UDB, MS SQL Server, and MS Access.
• Implemented all stages of development processes including extraction, transformation and loading (ETL) data from various sources into Data Warehouse and Data Marts using Informatica PowerCenter using Informatica Designer (Source Qualifier, Warehouse Analyzer, Transformation Developer, Mapping and Mapplet Designer), Repository Manager, Workflow Manager and Workflow Monitor.
• Have good knowledge of HIPPA 4010 /5010 versions.
• Profound understanding of insurance policies like HMO and PPO and proven experience with HIPPA 4010 EDI transaction codes such as 834(Benefit enrollment), 835(Payment/remittance advice), 837(Health care claim).
• Experienced in working with Business Users, Business Analysts, IT leads and Developers in identifying and gathering Business requirements to further translate requirements into functional and technical design specifications.
• Worked extensively in UNIX, Windows, Linux environment
• Comprehensive knowledge of Ralph Kimball's data modeling concepts including Dimensional Data Modeling and Star/Snowflake Schema Modeling.
• Extensive experience in performing Black Box, Regression, Integration, and User Acceptance testing.
• Experienced working with Excel Pivot and macros for various business scenarios.
• Effective independently or in a team. Excellent communication as well as inter-personnel skills. Ability to convey technical information at all levels. Excels in research, analysis, and problem solving skills.

WORK EXPERIENCE:

Confidential, Denver, CO

Sr. ETL Tester/ EDI Tester/ Data warehouse Tester

Responsibilities:

• Analysis of Business requirements & Design Specification Document to determine the functionality of the ETL Processes.
• Good Understanding of the EDI (Electronic data interchange), Implementation and Knowledge of HIPAA code sets.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
• Worked on HIPAA Transactions and Code Sets Standards according to the test scenarios such as 270/271, 276/277,837/835 transactions. Worked with Agile Methodology.
• Performed HIPAA Analysis and Testing on 4010/5010, including Claims handling, with Payer and Provider experience and EDI file generation and testing
• Involved in code changes for SAS programs and UNIX shell scripts
• Tested SAS Programs, to create customized ad-hoc reports, processed data for publishing business reports.
• Involved in testing the Cognos reports by writing complex SQL queries.
• Created flow charts to exhibit the flow of data from source datasets to the final reports using MS VISIO.
• Interacted with end users to obtain specific system requirements and for User Acceptance Tests (UAT).
• Day-to-day Cognos administration activities like monitoring Scheduled jobs like Cube refresh, Impromptu scheduled reports, Backup and recovery maintenance
• Created Test input requirements and prepared the test data for Data Driven testing.
• Generated reports using Informatica Power Analyzer. Prepared extensive set of validation test cases to verify the data
• Tuned stored procedures/scripts, SQL queries to improve the system performance
• Developed Test Plan and Test Cases using HP Quality Center to test the application for the new code.
• Prepared Test Cases for the mappings developed through the ETL Informatica tool and executed those Test Cases.
• Used Quality Center as central repository to maintain the test scripts and print the status report of the same.
• Worked with Rational Clear Quest for bug tracking. Wrote several UNIX scripts for invoking data reconciliation.
• Involved in extensive DATA validation using SQL queries and back-end testing

Environment: Informatica 9.6, HIPPA, EDI 5010/4010, Cognos BI Report Studio, Cognos Series, Oracle 10g, SQL Server 2014/2012, HP Quality Center/ALM, SQL, PL/SQL, Sybase, QTP, TOAD, XML, Korn Shell Scripts, UNIX, Windows XP

Confidential, Denver, CO

Sr. SQL Tester/ BI Tester/ ICD Tester

Responsibilities:

• Analyzing Business Requirements, Business rules and Technical Specifications. Created test cases and test plans for testing the ETL processes and reports.
• Tested all the ETL processes developed for fetching data from OLTP systems to the target Data warehouse using complex SQL and PL/SQL queries.
• Analyzing EDI transaction Claims, Remittance, Claims Status, Member Eligibility, Functional acknowledgement, and Claim acknowledgement.
• Performed testing to verify back-end database functionality of the application through SQL Queries
• Wrote and executed complex SQL queries including JOINS to validate Back-end data.
• Designed Data warehouse ETL informatica test cases for source and target db validation.
• Developed and executed automated test scripts in ETL Informatica.
• Reporting testing status to Project Management and Project Stakeholder resources
• Performed Regression Testing as and when the Bugs got fixed and check whether the application is free from bugs. Worked with Trizetto Facets Modules like claims, member/subscriber and provider.
• Wrote test plans to incorporate the testing needs of the data warehouse using HP ALM.
• Developing and maintaining Test Strategy and Test Plans across multi project fast paced environment.
• Providing draft Test Estimates and Test Schedules to the project team.
• Tested the Inbound / Outbound Interfaces to Facets and populated XML files.
• Responsible for testing all new and existing ETL data warehouse components.
• Ensuring a high level of quality in all testing deliverables, including conducting QA reviews. Identifying and reporting project risks logged against Clarity
• Executed the UNIX shell scripts that invoked SQL loader to load data into tables.
• Ability to manage change during the test process.
• Extensively involved in Defect tracking/observations, reviewing and analyzing and reporting test result using Quality Center.
• Validated Business Objects Reports and Universes against Data warehouse/Data mart Database by writing SQL Queries
• UNIX Log files and Error logs are reviewed & validate test data
• Worked with different data sources ranging from SCX files, flat files, and Hadoop, Vertica and SQL Server databases.
• Assisted extensively on HIPAA EDI 837 (I & P), 835 and 820, 820s, 270/271 for different business users.
• Tested various Business Objects Reports including Dashboards, Scorecards, Master Detailed, Grouped List & Cascade.
• Communicated with Users, Managers and business analyst along with Team Leader for understanding the business and database flow.
• Administration of test control and statistics collection (i.e. problem reporting, defect tracking) in JIRA
• Understood the data model represented in logical and physical enterprise data warehouse schemas

Environment: DWH ETL Informatica, BI Business objects, SQL, XML, Web services, EDI, CPT, HIPPA, SQL Server, Hadoop, Vertica, TOAD, DbVisualizer, Putty, UNIX shell scripts, HP Quality Center/ALM, JIRA, Tableau.

Confidential, Denver, CO

Sr. QA Tester/Validation Tester

Responsibilities:

• Developing and maintaining Test Strategy and Test Plans across multi project fast paced environment.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Informatica Testing and designing of the flow and the logic for the Data warehouse project.
• Providing draft Test Estimates and Test Schedules to the project team.
• Analyzed the Data warehouse ETL Informatica design documents to understand the logic
• Wrote and executed complex SQL queries including JOINS to validate Back-end data. Reporting testing status to Project Management and Project Stakeholder resources.
• Responsible for leading a team of testers by providing Business understanding and inputs related to test strategy.
• Performed testing to verify back-end database functionality of the application through SQL Queries
• Involved in entire QA Life Cycle, which includes Designing and Developing and Execution of the entire QA Process and Documentation of Test Plans, Test Cases, Test Procedures and Test Scripts.
• Analyzed HIPAA EDI transactions in XML and X12 responses and amended the errors manually by data mapping.
• Used Data warehouse ETL Informatica Power Center Workflow Monitor to trigger master/stand-alone workflows.
• Good experience in writing SQL in order to data validation in migration as part of backend testing
• Developed, modified and debugged scripts in Automation frame work using QTP for future release
• Involved in developing Unix Shell wrappers to run various Scripts
• Tested all the Data warehouse ETL process that was developed to fetch the data from various feeds into the data warehouse.
• Involved system testing on EDI transaction 270/271, 837, 835 for both inbound and out bound.
• Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards
• Worked with different data sources ranging from VSAM files, flat files, DB2, oracle and SQL Server databases.
• Communicated with Users, Managers and business analyst along with Team Leader for understanding the business and database flow.
• Written several complex SQL queries & PL/SQL stored procedures for validating Cognos Reports
• Extensively used SQL queries/Unix commands for data verification and backend testing.
• Administration of test control and statistics collection (i.e. problem reporting, defect tracking) in Quality center.
• Extensive experience in testing SQL Server and Oracle databases, involved in testing back end jobs using SQL queries.
• Supported onsite/offshore team coordination for all fast paced projects.
• Experience in writing Macro's for validation of huge migration data & validation of reports exported to Excel using QTP.
• Responsible to ensure successful data load from several sources systems into appropriate targets.
• Responsible to verify SQL's for the data validation transformations by guiding the team of testers.

Environment: DWH ETL Informatica, BI Cognos, SQL, PL/SQL, SOAP UI, XML, Web services, HIPPA, EDI, GDE, ETL, Oracle 11g, TOAD, QTP, Unix, HP Quality Center/ALM.

Confidential, Boulder, CO

QA Analyst/Manual Tester

Responsibilities:

• Understood the cleansing and deduplication process from complex set of documents including the Mapping, FRDs, business rules and mapping document.
• Extensively used Data warehouse ETL Informatica methodology in testing for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL solution using ETL tools like Informatica
• Created and populated patient data using advanced SQL queries and also performed Teradata SQL performance tuning
• Involved in preparing the Data-driven and keyword-driven frameworks in QTP for system and UAT environments and performed data comparison and functional comparison.
• Performed data quality checking to ensure integrity and consistency of master data.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Also used components like run program and run sql components to run UNIX and SQL commands.
• Tested reports in the form graphs and charts used to present medical findings
• Developed a wide-range of SQL queries to assure data validation and avoid duplication in tables of the database.
• Tested medical claims data to support the company's predictive modeling tools
• Tested metadata of the application by double checking the Informatica mappings using transformations like Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update strategy, Joiner, Normalizer, Union, Store procedure and XML transformations
• Promoted Unix/Informatica application releases from testing to QA and UAT environments.
• Highly experienced in various features of Micro Strategy like managing multiple projects, project migration and defining standards, procedures for development, production environment
• Performed Regression testing with QTP by executing the automation test scripts
• Tested routine Clinical Documentation on Electronic Medical Record Software
• Involved in testing Micro strategy reports including conditional formatting testing and threshold testing.
• Performed numerous data tests to validate the extraction requests involving SQL scripts and UNIX
• Tested drill down analysis reports using SQL server reporting services
• Tested data dictionary for the clinical aberrancy rules
• Extensive experience in testing SQL Server and Oracle databases, involved in testing back end jobs using SQL queries.
• Tested the final analysis of the Facets claims processing application in order to gather requirements to comply with HIPAA 5010
• Tested HIPAA 4010 and 5010 standards for 837P EDI X12 transactions related to providers, payers, subscribers and other related entities

Environment: DWH ETL Informatica, BI Microstrategy, SQL, PL/SQL, UNIX, Oracle 10g, XML, SOAP UI, QTP, .NET, HTML, Toad for Oracle.