SUMMARY:

• Over 7+ years of overall IT exposure in Quality Assurance using Manual & Automation testing with Data Warehousing which involves ETL, Teradata, Reporting and Data modeling experience.
• Extensively written test plans, test cases, scripts and prepared test data and followed STLC extensively for DWH testing practices.
• Strong in Data warehousing concepts, dimensional Star Schema and Snowflakes Schema methodologies
• Extensively worked with large Databases in Test environments.
• Exposure to multiple ETL tools including Datastage, Informatica, Ab Initio and SSIS.
• Extensive work in ETL testing using SQL, UNIX, PL/SQL.
• Profound experience in testing web applications using Quality Center and Quick Test Pro (QTP).
• Strong SQL query skills using an enterprise wide RDBMS (Oracle, MS SQL Server & MS Access) and familiar with concepts of SQL queries ranging from DML and , DDL
• Wrote Test cases in ALM and Defect report generation using ALM (Application Life cycle Management)
• Validate EDI Claim Process according to HIPPA compliance
• Strong expertise in Relational data base systems like Oracle, SQL Server, MS Access, MYSQL and Teradata
• Extensively tested data validation, load processes (ETL) using Toad and SQL Developer.
• Data testing experience with Data Mart applications, mainly transformation processes using Informatica, Datastage tools.
• Extensive experience in tracking bugs using Bug tracking tool Quality Center
• Experienced in testing BI reports generated using different BI tools like Microstrategy and Business Objects
• Good Testing experience in developing reports using SQL Server (SSRS)
• Experienced in working in Agile Scrum and SDLC methodology environments
• Experience in testing/validating the Source, Stage and Target (End - to-End).
• Experience in Unit Testing, Functional Testing, System Testing, Integration Testing, Regression Testing, User Acceptance Testing and Performance Testing.
• Performed System, Integration testing and Performance testing.
• Proficient in understanding business processes / requirements and translating them into technical requirements.
• Team Player with excellent communication, analytical, verbal, writing and interpersonal skills.

TECHNICAL SKILLS:

BI Tools: Cognos 8.x/7.0, SSRS, Microstrategy, Business Objects XIR3/XIR2/6.x

Databases: Oracle 11g/10g/9i/8.0 , MySQL 5.4, MYSQL, OLTP Programming

SQL: , PL/SQL, SQL*Loader, Unix, Shell Scripting, C, Java, HTML,XML, Perl, PHP, JavaScript

Tools: TOAD, SQL*Plus, Dream weaver

Testing Tools: HP Quality Center 10, QTP,Selenium, Test Director

PROFESSIONAL EXPERIENCE:

Environment: UNIX(IBM AIX, Sun Solaris), Windows XP/Vista, Linux(RHEL)

Confidential, Woodlands, TX

Sr. ETL QA Tester

Responsibilities:

• Analyzed business requirements, data mapping specifications and developed Test Plans, Test Cases, Expected Results and Prioritized tests for the applications for various modules using Quality center.
• Developed the detail ETL Test Plan, Test Resource Utilization and Close Down document for multiple products.
• Prepared sample EDI test sets for files like 276/77, 278,837 and followed HIPAA implementation guide in preparing them
• Experienced in creating the SSIS packages, DTS packages
• Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
• Created and Developed Reports and Graphs using ALM.
• Involved in automated Regression Testing using Quick Test Professional (QTP).
• Created complex SQL queries for querying data against different data bases for data verification process.
• Created Test cases for Data Acquisition and Data Delivery and tested the data accuracy for all the transformations.
• Tested the extracted data from flat files and oracle database, and tested the applied business logic on the transformations.
• Tested mappings/Reusable Objects/Transformation/mapplets by using Informatica PowerCenter
• Tested different reports including detail, summary reports and on demand reports developed by SSRS Report Studio
• Used Informatica Power Center for extraction, loading and transformation (ETL) of data in the data warehouse.
• Designing and creating new reports, Freeform SQL reports in Micro strategy
• Validated the data on Front end applications to reflect the data on the back end using SQL queries
• Expertise in planner/designer using mapping, transformations, data validation, oracle data warehouse builder.
• Creation and execution of manual test cases in Quality Center
• Tested various mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformation
• Defect tracking and Defect Report Generation are prepared using ALM and Quality Center
• Analyzed test cases for automation and created scripts for regression testing using QTP 9.2. Automated Test cases for the purpose of regression testing.
• Worked in AGILE Methodology.
• Involved in uploading and processing of EDI 278, 276 claims in Portal.
• Developed Teradata and Oracle Structured Query Language ( SQL ) test scripts from test procedures and executed them with Oracle's SQL plus and Teradata 's Queryman or BTEQ
• Used SQL queries to retrieve data from tables and to perform back end testing thru TOAD.
• Wrote SQL, PL/SQL, stored procedures & triggers, cursors for testing business rules and transformations.
• Worked on UNIX for testing the sample data and comparing the data at the source vs target systems.
• Performed integration, regression, retesting.
• Wrote Test cases in ALM and Defect report generation using ALM (Application Life cycle Management)
• Tested various operational Drill-through and Drill-down reports using SSRS
• Writing complex SQL queries for data validation for verifying the SSIS Packages and business Rules.
• Written and reviewed test cases and participated in test effort estimation
• Worked with the team to set up the test bed.

Environment: Quality Center & ALM 11.0, Informatica Power Center 9.1,SSIS,SSRS, QTP, Micro strategy, Teradata, AutoSys, Oracle 11g/10g, XML, TOAD 6.0, Java, Java Script, Agile, SQL, PL/SQL, IBM UNIX AIX.

Confidential, Richmond, VA

ETL QA Tester

Responsibilities:

• Involved in understanding Business Process and coordinated with Business Analysts to understand specific user requirements.
• Tested the extracted the data from heterogeneous sources like .dat file, Excel file, .csv file, flat files, Oracle etc and loaded into target tables Oracle.
• Tested reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
• Involved in testing HIPAA EDI Transactions.
• Responsible for testing packages using SSIS (ETL) to verify data completeness, data transformation, data quality, integration testing, UAT & regression testing.
• Extensively used the Sequential File, Dataset, Join, and Look-up, transformer, Funnel, Xml and Connector stages provided by Informatica to perform transformation and load the data.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Involved in developing detailed Test strategy, Test plan, Test cases and Test procedures using Quality Center for Functional and Regression Testing
• Worked in an Agile technology with Scrum
• Prepared Test Scripts and test Plan for automated testing using QTP
• Tested all the reports by running queries against the warehouse-using TOAD. Also compared those queries with the Business Objects SQL engine generated queries.
• Used standard testing techniques to test the data validity before deploying the Business Objects Reports to Users.
• Tested several Informatica ETL mappings and ran on UNIX for loading purpose and checking the log files
• Used Aggregator stages to sum the key performance indicators used in decision support systems.
• Used SQL functions, clauses, Wildcards etc for extensive testing of the warehouse
• Tested slowly changing dimensions of Type 1 and Type 2 to populate current and historical data to Dimensions and Fact tables in the data warehouse.
• Extracted Data using SSIS from DB2, XML, Oracle and flat files, Excel perform transformations and populate the data warehouse
• Used SQL Queries to validate the data on daily basis
• Queried Teradata Database and validated the data using Sql Assistant
• Running SQL Query's in TOAD for counting the no of rows from the tables
• Monitoring the ETL jobs and coordinating the Bug fixes.
• Worked on different HIPAA EDI transactions and code sets including 278 (referrals), 834 (enrollment), 271 (eligibility), 277 (claim status), 837 (claims).
• Used Quality Center for Test cases, Bug reporting, tracking & generation of Test Metrics
• Participated in the review and maintenance of data security standards to protect information assets.
• Tracked the defects to closure.
• Involved in scrum meetings with the Project Manager and provided updates of the testing team.

Environment: Informatica 9, Oracle 10g/9i,QTP,SSIS,SSRS, Business Objects, IBM DB2, Quality Center, ClearCase 8.0, ClearQuest 8.0, MYSQL, XML, SQL, TOAD, SQL*Plus, Teradata, Agile, AutoSys, Java, Java Script

Confidential, Atlanta GA

ETL QA Tester

Responsibilities:

• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Performed segmentation to extract data and create lists to support direct marketing mailings and marketing mailing campaigns.
• Developed automation test scripts to test the database by retrieving the data from the tables using HP QTP and VB Scripting
• Reviewed and approved database modifications
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mappings.
• Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.
• Extensively tested the Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation.
• Validating the reporting objects in the reporter against the design specification document.
• Validating the data files from source to make sure correct data has been captured to be loaded to target tables
• Create XML request files for test scenarios and test cases for the claims control web services
• Validating the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules.
• Tracked the progress of the defects till end of the defect life cycle, used HP Quality Center for defect tracking and maintained the workflows and trail history of bugs using HP Quality Center.
• Validating the Archive process to purge the data that meet the defined business rules.
• Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle.
• Did testing on ETL Informatica process for various data loading scenarios.
• Tested Canned/Ad-hoc reports using Business Objects Reporter functionalities like Cross Tab, Master Detail and Formulas, Slice and Dice, Drill Down, variables, filters, conditions, breaks, sorting, @Functions, Alerts, Cascading Prompts and User Defined Objects.
• Validated the ETL Scripts in the Target Database (Oracle) for creating the cube before migrating it to SQL Server.

Environment: Informatica PowerCenter 8.6, QTP, Business Objects, Quality Center 10, Oracle 10g/9i, Flat files, SQL, PL/SQL, TOAD 7.x, java, Windows NT, XML,Agile, Shell Scripting, Sun Solaris

Confidential, Vernon Hills, Illinois

ETL QA Tester

Responsibilities:

• Monitor user requests/issues through tracking system & mails
• Work with the users to understand the issue/request
• Analyze and resolve the issue.
• Intensively conducted Functionality, User Interface, Security, and Regression testing during the various phases of the development using Test Director/Quality Center.
• Create enhancements/ bug fix requests and solve these if applicable
• Working on automation of test plans
• Performing smoke and regression tests for all releases
• Handling alerts & resolving issues behind them.
• Working on Test plans for the various builds and releases

Environment: Oracle 8i, J2EE, UNIX, Sybase, DB2, Quality Center, Java, Unix Shell Scripting, Data Synapse 5.1,