SUMMARY

• Over 6+ 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, Informatica 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
• 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 Micro strategy and Cognos
• 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

Data Warehousing ETL: Informatica Power Center (Source Analyzer, Target Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Repository Manager, Workflow Manager, Workflow Monitor) ETL, DataStage, SSIS, Repository, Metadata, Datamart, FACT & Dimensions tables.

Data Modeling: Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, Fact, Dimensions), Entities, Attributes, Cardinality, ER Diagrams

BI Tools: Cognos 8.x/7.0, SSRS, Micro strategy, Cognos XIR3/XIR2/6.x

Databases: Oracle 11g/10g/9i, MySQL 5.4, MYSQL, OLTP, MS SQL Server

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

Tools: TOAD, SQL*Plus

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

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

PROFESSIONAL EXPERIENCE

Confidential, IL

Quality Assurance Specialist

Responsibilities:

• Analyze, review design documents and Functional/ Business requirements to define functional specifications.
• Involved in requirement review meetings with Business Analysts and Product Owners.
• Expertise in developing Test Estimations, Test Plans,Test Metrics and Test Execution plan.
• Responsible in coordinating with QA team in developing the test cases, test plan and day to day test status for all the releases.
• Represented as SPOC for a complex module and led the team as a module lead in functional testing.
• Involved in integration testing by taking the input from one application and testing it in POS application.
• Generated XML files as a package by configuring parameters in Restaurant File Management application and applied the package to the POS application.
• Analyzed the XML files and identified the root cause for the issues or defects.
• Involved in day-to-day SCRUM in an agile environment meetings both on site and off shore teams to providing the day-to-day updates on the testing schedules.
• Represented as SME and SPOCin the team for both functional and integration testing.
• Created Test Lab infrastructure for functional, smoke, integration, regression, and system testing.
• Responsible for preparing Requirement Traceability Matrix for both functional and integration testing.
• Involved in managing Test Execution status for all phases /cycles in testing.
• Responsible for reporting and tracking defects using JIRA.
• Managed build verification testing, smoke testing, integration testing, functional testing, regression testing, data integrity testing, system testing.
• Prepare project documentation, test reports and defect reports.
• Worked very closely with developers to recreate defects found and also to verify fixes.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Tested the data which loads from Source to Staging to Data warehouse (EDW).
• Creating and executing SQL queries to perform Data Integrity testing on Teradata to validate and test data using Teradata SQL Assistant.
• Worked with UNIX shell scripts. Worked with releasing scripts live and tested.
• Tracked bugs using Quality Center and generated the defect reports for review by the client and the
• Submitted weekly bug or issue report updates to the Project Manager in the form of the QA Error Log.
• Took part in PPV (Post Production Validations) and worked efficiently to manage off-shore teams for timely completion of the task.

Environment: Teradata, Teradata SQL Assistant, JIRA, AGILE, Clear Quest, Informatica 9.0,UNIX(AIX),Rational Quality Manager(RQM),Putty, Winscp,VB Scripting

Confidential, San Francisco CA

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.
• Worked with business team to test the reports developed in Cognos
• Promoted Unix/Informatica application releases from development to QA and to UAT environments
• Generated reports using Cognos Report Designer.
• Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• 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.
• Used Informatica for extraction, loading and transformation (ETL) of data in the data warehouse.
• Strong knowledge in Data warehouse tools like Informatica, Cognos and 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.
• Involved in testing the Cognos reports by writing complex SQL queries
• Extensively used Informatica power center for extraction, transformation and loading process.
• Creation and execution of manual test cases in 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.
• Tested reports using Cognos functionality like Queries, Slice and Dice, Drill down, @Functions, Formulae etc.
• Developed Teradata and Oracle Structured Query Language (SQL) test scripts from test procedures and executed them with Oracle's SQLplus 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.

Environment: HP Quality Center 10, Informatica Power Center 9.1, QTP, Cognos, Teradata, Autosys, Oracle 11g/10g, XML, TOAD 6.0, Java, Java Script, Agile, SQL, PL/SQL, IBM UNIX AIX.

Confidential, Cleveland OH

ETL/QA Tester

Responsibilities:

• Involved in understanding Business Process and coordinated with Business Analysts to understand specific user requirements.
• Extensively used Informatica client tools. The objective is to extract data stored in Oracle database, flat files to load finally into a single data warehouse repository, which is in Oracle.
• Tested the different sources such as Flat files, PeopleSoft accounting data and Oracle to load into the Teradata data warehouse
• 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.
• Quality, integration testing, UAT & regression testing.
• Involved in validating the data that has been populated into Data warehouse Fact and dimensional tables using Informatica Data Warehouse tool.
• Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic
• Strong knowledge of working with Star Schema and Snowflake Schema
• 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
• Developed Automation test scripts, and run the scripts as part of regression testing.
• Tested Cognos reports and Web Intelligence reports.
• Worked in an Agile technology with Scrum
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purpose.
• 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 Cognos SQL engine generated queries.
• Tested several Informatica ETL mappings and ran on UNIX for loading purpose and checking the log files
• Involved in SQL Optimizations, Performance Analysis, and future growth analysis for OLTP and data warehouse applications
• Written several complex SQL queries & PL/SQL stored procedures for validating Cognos Reports
• Analyzed the specifications and identified the source data that needed to be moved to the data warehouse
• 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
• 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.
• Translate business-reporting requirements into data warehouse architectural designs and analyzing source and target data models and makes necessary changes.
• Used standard testing techniques to test the data validity before deploying the Cognos Reports to Users.
• Extensive experience in testing and implanting Extraction, Transformation and Loading of data from multiple sources into Data warehouse using Informatica.
• Tracked the defects to closure.
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica and provide technical support and hands-on mentoring in the use of Informatica for testing.

Environment: Informatica Power Center8.1, Oracle 10g/9i,QTP, Cognos, IBM DB2, Quality Center, ClearQuest 8.0, MYSQL, XML, SQL, TOAD, Agile, AutoSys, Java, Java Script

Confidential, Minneapolis, MN

QA Tester

Responsibilities:

• Reviewed the Business Requirement Documents and the Functional Specification.
• Interacted with senior peers or subject matter experts to learn more about the data.
• Validating the Workflows and running them using Workflow Manager.
• Prepared Test Cases and Test Plans for the mappings developed through the ETL Data Stage tool.
• Tested different detail, summary reports and on demand reports. Extensively used Cognos for report generation.
• 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 Different Module Like Billing, Claims, Subscriber/Family, and Customer Care in Facets.
• Experienced in writing complex SQL queries for extracting data from multiple tables and validating with target tables.
• Experience testing tables like SCD Type 1, Type 2 & Type 3 verified history load and incremental load data.
• Developed advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.
• Validated target tables DDL, counts, data (Business rules), negative testing and regression testing.
• Experience in writing test cases for the Facets applications
• Worked withFACETSTeamfor HIPAA Claims Validationand Verification Process (Pre-Adjudication).
• Worked on HIPAA EDI Transactions and Code Sets Standards according to the test scenarios such as 270/271, 276/277,837/835 Transactions
• Strong technical Knowledge of UNIX Utilities, Shell Script to automate process.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Analyzed trading partner specifications and created EDI mapping guidelines.
• Involved extensively in doing back end testing of the data quality by writing complex SQL.
• Exported Manual Test Cases from MS Excel template directly to QC and executed the Test Cases in Test Director with Pass/Fail/Blocked status.
• Executed the developed Test Cases and Test Plans and also responsible for creating Test Strategy for the Data Warehouse.
• Highly Experienced in HIPAA (Health Insurance Portability and Accountability Act), Health Care industry providing Business Process Assessment, Requirements Gathering, Gap Analysis, Implementation and Testing
• Did data analysis for various version changes of EDI messages on different sub-systems.
• Defect tracking and Defect Report Generation are prepared using ALM and Quality Center
• Highly Experienced in HIPAA (Health Insurance Portability and Accountability Act), Health Care industry providing Business Process Assessment, Requirements Gathering, Gap Analysis, Implementation and Testing

Environment: IBM Data Stage, Oracle 10g, SQL, PL/SQL, Flat files, Excel Files, UNIX, ALM/Quality center, Cognos8.4.1