SUMMARY:

• Over 9 years of experience in Software Quality Assurance, Quality Control, and Quick Test Professional.
• Experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications
• Experience using query tools for Teradata, Oracle, DB2 and MS SQL Server to validate reports and troubleshoot data quality issues.
• Experienced in writing complex SQL queries for data validation for both ETL and BI testing.
• Experience in PERL, UNIX Shell Scripting & PL/SQL for text parsing, error logging and data parsing.
• Experienced in coordinating resources within Onsite - Offshore model
• Experience in HIPAA EDI 837 (Professional, Institutional, Dental Claims) and Facets 4.61,4.81.5.01, 5.03
• Experience with Agile Methodology.
• Experienced in writing SQL queries to validate input data submitted through GUI with the actual data in the Database Analyzed Test results to meet the end user needs.
• Extensive Experience using Multi-Tire Applications and Client Server Applications.
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Experience in writing Test cases based on Business Requirements and Technical Specifications.
• Worked on User Acceptance Testing (UAT), System testing, Integration testing, Regression Testing, Black Box Testing and Backend or Database Testing.
• Strong knowledge of working with Data Marts (Star Schema and Snowflake Schema).
• Excellent knowledge and working experience in test planning, test execution and test result analysis.
• Excellent analytical, problem-solving and trouble-shooting skills.
• Expert in implementing / suggesting best practices and Understanding the complexity of the application, collecting the client’s requirements and providing the software solution to achieve his quality standards. Vast experience in entire software development process from concept definition of system specification and requirement analysis
• Good interpersonal skills, committed, result oriented and hard working.
• Ensuring smooth onsite to offshore transition of requirements and conducting knowledge transition sessions.

TECHNICAL SKILLS:

Languages: HTML, XML, XSLT, VB Script, Java2.0, SQL T-SQL and PL/SQL

Testing Tools: Quick TestPro, Quality Center/ALM

Databases: My SQL, SQL Server 2005, Oracle, Ms Access, Teradata V2R6, IBM DB2

Web Technologies: C#.NET, VB.NET, ASP.Net, XML, HTML, DHTML, XSLT, CSS, PHP, AJAX

Software Applications: Microsoft Suite (Word, Excel, Power Point, Access), Adobe Photoshop

Operating Systems/ Reporting Tools: MS Windows 2000/XP/Vista, Windows 95/98, UNIX.

Reporting Business Object: s XIR2, Cognos Series 8.0, Crystal Reports, OBIEE

PROFESSIONAL EXPERIENCE:

Confidential, Grand Rapids, MI

Sr. ETL QA Tester

Responsibilities:

• Worked with the Business analysts and the DBA for requirements gathering and project coordination .
• Testing both inbound and out bound and XML files and prepare analysis document with various results.
• Loaded Cases/Tasks/Assessments for Scenarios in CARE ADVANCE (CA) Web Application for Testing Scenarios.
• Involved in Testing Web Services that was linked with Reject Table to the main database.
• Involved in Testing of Server Changes in Informatica 9.0.1/ Hyperion Reports/BO XI
• Assisted QA Lead and Project Manager in developing Test Plan and communicated with Project managers and supervisors to provide the best test strategy as per Agile Testing Life Cycle
• Coordinated and initiated Agile SCRUM meetings with the Project Managers, QA, BA and Dev Teams
• Regression Testing, System Integration Testing, Creating Test Cases and maintaining the test cases with all alternative as well as regular scenario
• Tested Mappings that used JMS real time messages from MQ Series Queues using PowerExchange. Defined the configurations within Power Exchange for the Queues.
• Involved in testing of mappings, which use CDC (Change Data Capture) methodology.
• Load testing and performance testing files on server, Run Informatica jobs, Check database connections and Run Queries in Oracle, Sybase and SQL Server .
• Tested integration of CARE ADVANCE (CA) interfaces like 278, Vendor Files and Auto load Files with FACETS.
• Tested EDI 278 request and response of Outpatient Cases from Vendor to CA XML.
• Created Mock files for 835, 837, 278 to test regular as well as alternate scenarios.
• Implemented Soap UI for data driven verification form sender and responder files.
• Created Alternative Scenarios and Produced Test Files for User Approval Test.
• Created Test Scripts in SOAPUI to validate the web service linked with Reject Table.
• Involved in Test Case Management Matrix in HP Quality Center.
• Involved in FACETS upgrade and validated columns added to existing tables also tested new tables added to FACETS data model.
• Testing on Care Advance Web Application and checking whether tables load properly according to requirements mentioned in business document (BRD) as well as Technical Design Document (TDD).
• Involved in Job scheduling activities using TWS (Tiwoli Work Scheduler).
• Involved in Generation as well as loading of Flat File from Informatica Server to CA .
• Clear Quest and JIRA issue tracking systems for different environments

Environment: Informatica Power center 9.0, Oracle 10g, Agile, Pl/SQL Developer, SQL Developer, TWS, UNIX, SOAPUI, JIRA, and Clear Quest.

Confidential, BOSTON, MA

Sr. ETL QA Tester

Responsibilities:

• Worked with Business Users in understanding the Data Mart requirements and analyzed the requirement specifications and source to target mapping documents.
• Experience in Leading the Offsite Project, managing a team of 8 Offshore and 4 Onsite consultants..
• Worked closely with the Business Analysts, Systems Analysts, Developers, and DBAs to solve the issues identified during the testing process in a timely manner
• Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing.
• Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards
• Working with creating EOB and Voucher Claims for making payments to Providers, Subscribers and Agents
• Involved in backend testing for the front end of the application using SQL Queries in Teradata data base.
• Developed Ab Initio test environment for UAT testing and used all Ab Initio components while testing the graphs and ran the jobs on back ground.
• Created ETL test data for all ETL mapping rules to test the functionality of the Ab Initio graphs
• Tested the ETL Ab Initio graphs and other ETL Processes (Data Warehouse Testing
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Understanding of the database designs like Star Schema and Snow flake Schema and relationship between Fact and Dimension tables.
• Understood Data Models, Data Schema, ETL and created extensive store procedures, SQL queries to perform back-end data warehousing testing.
• Tested the ETL mappings and other ETL Standard Processes.
• Wrote Complex SQL queries for each Test case to validate the data between Source system, Data Warehouse, Data Marts and Reports.
• Ran SQL queries to verify the number of records and validated the referential integrity rules as per the design specifications.
• Performed Automation testing on Claims processing using Mercury Quality Center.
• Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic
• Validated the most granular data items against OLTP systems and identified the source tables from which the data warehouse extracts data.
• Created ETL test data for all ETL mapping rules to test the functionality of the ETL Mapping.
• Written several complex SQL queries for validating the Reports.
• Experience in loading from various data sources like Teradata, Oracle, Fixed Width and Delimited Flat Files.
• Reported bugs and tracked defects using HP Quality Center
• Metadata graphs from legacy source system to target database fields and involved in creating Ab Initio DMLs.
• Functioned as the Onsite / Offshore coordinator for a team.
• Used Quick Test Professional for developing Automation scripts and performed Regression testing on claims processing.
• Written several complex SQL queries for validating Cognos Reports.
• Involved in Data Extraction from Teradata and Flat Files using sql assistant.
• Involved in testing the Cognos reports by writing complex SQL queries.
• Handled onsite and offshore resources to make them understand and provided training on using the existing application, handling production issues.

Environment: Quality Center 10.0, SQL server 2005, SSRS, SSAS, Cognos 8.0 Series, Shell Scripting, UNIX, SQL Assistant, Ab Initio CO>OP 2.15, GDE 1.15, Visual Studio, ASP.Net, Netezza, WINSQL, IBM DB2, Oracle, XML Files, ASP.NET, Agile, Scrum,, COM, JavaScript.

Confidential, Owing Mills, MD

ETL QA Tester

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
• Participated in defect review meetings with the team members, provided written weekly status reports of testing project.
• Involved in developing detailed test plan, test cases and test scripts.
• Reviewing the project and coordinating with onsite Clients, onsite Project Leads and local reporting managers.
• Developed TSL (Test Script Language) for automated Testing using Win Runner. Worked with business team to test the reports developed in Cognos
• Managed and executed the test process, using Agile Methodology.
• Worked with Teradata SQL Assistant for data retrieval and data validation.
• Created Test Plans for testing the added functionality, regression, usability, security, and reliability.
• Tested several data validation graphs developed in Ab Initio environment.
• Worked with all kinds of components with Ab Initio including Dedup, Denormalize, Normalize, Rollup, Scan, Reformat, Redifine, Sort, Joiner, XML Read, XML Write, FBE, Partition Components.
• Tested various functionality like Membership & Eligibility, Claims Processing and Payment, Provider Credentialing and Benefits Packages.
• Involved in SQL Development, Unit Testing and Performance Tuning.
• Extraction of test data from tables and loading of data into SQL tables.
• Managed and executed the test process.
• Involved in Data Extraction from Teradata and Flat Files using SQL assistant Designed.
• Manually tested the whole application before going onto automated testing.
• Performed database testing with SQL queries to verify data.
• Tested the files comparing with the data at the backend.
• Worked with Data Extraction, Transformation and Loading (ETL).
• Involved in testing data mapping and conversion in a server based data warehouse.
• Developed and executed test cases and verified actual results with expected results.
• Used Quality Center for bug tracking and reporting, also followed up with development team to verify bug fixes, and update bug status.
• Involved in validating Reports and Documents, which displays complete details of the claims processed
• Tested graphs for extracting, cleansing, transforming, integrating, and loading data using Ab Initio ETL Tool.
• Written several complex SQL queries & PL/SQL stored procedures for validating Cognos Reports
• Conducted manual back-end testing on wellness application system.
• Performed extensive Back-End testing by writing and executing SQL queries on the database-using Toad.
• Involved in backend testing for the front end of the application using SQL Queries in Teradata data base.
• Involved in Data Extraction from Teradata and Flat Files using sql assistant.
• Performed Manual Testing in Claims and Billing modules on Data Warehouse and executing scripts manually in Test Director and done Keyword Driven Testing.
• Worked with business team to test the reports developed in Cognos
• Contributed to design, analyzed and conducted back-end testing using SQL scripts on a database developed from Data Mining.

Environment: QTP 9.0,Oracle10g, Quality Center 10.0, SQL, SQL, Toad, Visual Studio, Oracle, XML Files, CSV, Ab Initio CO>OP 2.14, AB INITIO GDE 1.14,,Teradata V2R6,Cognos 7 Series, VSAM Files, Agile, XML, COM, JavaScript, Visual Source Safe 6.0

Confidential, Bristol, CT

SQL/EDW Tester/Data Analyst.

Responsibilities:

• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• Worked in an Agile technology and participated in daily Scrum meetings.
• Involved in SPRINT Process.
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Extraction of test data from tables and loading of data into SQL tables.
• Involved in testing the Cognos reports by writing complex SQL queries
• Managed and executed the test process, using Agile Methodology.
• Tested the ETL mappings and other ETL Processes (Data Warehouse Testing)
• 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
• Worked with Data Completeness, Data Transformation, Data Quality, Integration, UAT testing and Regression testing for ETL and BI group
• Used HP Quality Center to write test cases, analyzed the results, tracked the defects and generated the reports.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used SQL for Querying the DB2 database in UNIX environment
• Worked in an Agile technology with Scrum
• Tested Cognos reports to check whether they are generated as per the company standards
• Responsible for Data mapping testing by writing complex SQL Queries using WINSQL
• Installed, Administered, Customized and Maintained the Quality Center Environment.
• Manually tested the whole application before going onto automated testing.
• Performed database testing with SQL queries to verify data integrity using QTP.
• Involved in testing data mapping and conversion in a server based data warehouse.
• Developed and executed test cases and verified actual results with expected results.
• Used Quality Center for bug tracking and reporting, also followed up with development team to verify bug fixes, and update bug status.
• Conducted manual back-end testing on a reconfigured sales application system.
• Performed extensive Back-End testing by writing and executing SQL queries on the database-using SQL Query Analyzer.
• Contributed to design, analyzed and conducted back-end testing using SQL scripts on a database developed from Data Mining.

Environment: QTP 9.0,Oracle10g, Quality Center 10.0, SQL, PL/SQL 7X, Shell Scripting, SQL, PL/SQL, PERL, Visual Studio, Cognos 7.0, .NET 2008, Kalido, Busines Object Data Integrator (BODI), IBM DB2, Oracle, XML Files, CSV, VSAM Files, SQL Server 2008, ASP.NET, Agile, Scrum, Sprint, XML, COM, JavaScript, Visual Source Safe 6.0

Confidential, Charlotte, NC

QA/ETL/Data Warehouse Tester

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
• Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing.
• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• Design and development of ETL processes using Informatica ETL tool for dimension and fact file creation
• Worked in an Agile technology.
• Responsible for testing Business Reports developed by Business Objects XIR2
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Extracted certain column of data from a number of files using PERL.
• Promoted Unix/Informatica application releases from development to QA and to UAT environments as required.
• Extraction of test data from tables and loading of data into SQL tables.
• Developed the test cases for Screen UI testing for all the Screen Labels.
• Perform Data Quality integrity testing (completeness, conformity, consistency, accuracy, duplicates).
• Worked on a Business Intelligence reporting system that was primarily functioning on Oracle Applications OLTP environment with Business Objects for Business Intelligence reporting
• Managed and executed the test process, using Agile Methodology.
• Worked with Teradata SQL Assistant for data retrieval and data validation.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Worked with PERL control structures & Regular Expressions for file manipulations
• 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
• Responsible for Data mapping testing by writing complex SQL Queries using WINSQL
• Installed, Administered, Customized and Maintained the Quality Center Environment.
• Manually tested the whole application before going onto automated testing.
• Performed database testing with SQL queries to verify data integrity using QTP.
• Used PERL for automating all the types of modules at a time and Responsible for testing the reports according to client’s requirement using Business Objects 6.5.1
• Worked with Data Extraction, Transformation and Loading (ETL).
• Involved in testing data mapping and conversion in a server based data warehouse.
• Assisted in promotion of Informatica code and UNIX Shell scripts from UAT to Production.
• Developed and executed test cases and verified actual results with expected results.
• Used Quality Center for bug tracking and reporting, also followed up with development team to verify bug fixes, and update bug status.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Conducted manual back-end testing on a reconfigured sales application system.
• Performed extensive Back-End testing by writing and executing SQL queries on the database-using SQL Query Analyzer.
• Contributed to design, analyzed and conducted back-end testing using SQL scripts on a database developed from Data Mining.

Environment: QTP 9.0,Oracle10g,Neteza, Toad Win SQL, Quality Center 10.0, SQL, PL/SQL,, Shell Scripting, SQL, PL/SQL, PERL, Visual Studio, Business Objects6.1, XIR2, .NET 2008, Teradata V2R6, Informatica 8.5.1, IBM DB2, Oracle, XML Files, CSV, VSAM Files, SQL Server 2008, ASP.NET, Agile, XML, COM, JavaScript, Visual Source Safe 6.0

Confidential, St Louis, Missouri

QA Tester - Customer Billing Data Mart

Responsibilities:

• Coordinating in the preparation of Test Plan/ Test Strategy for the application after careful analysis of requirements and specifications.
• Created and executed detail function test script and test cases based on the business requirements.
• Worked with ETL testing for Data Completeness, Data Transformation & Data Quality.
• Written complex SQL queries including joins, minus, case statements, etc.
• Performed Load testing, Stress testing, Performance testing and Regression testing.
• Performed Security testing for unauthorized access of the application with valid and invalid data.
• Conducted Regression testing on each new build of the application under test.
• Tested the performance of the application using Load Runner.
• Developed the Silk Performer scripts and created different scenarios as per the requirements.
• Performed Track Record defect process flow in Quality Center.
• Used Quality Center as a repository for Test Cases and for Defect Tracking.
• Mapped the original loan data to XML script data in the file.
• Performed Ad-hoc testing, Integration testing, End-to-End testing, Function testing, Performance testing, System testing, User Acceptance testing, Black box testing and White box testing.
• Executed SQL Queries to check the data table updates after test execution.

Environment: T-SQL, SQL, PL/SQL, DTS, SSRS, SSAS, Manual testing, Visual Basic, SQL Server, Windows