SUMMARY

• Over 7 years of progressive experience in Software Quality Assurance (QA) and tested Data Warehouse, Database (ETL & BI), Web, and Client - Server Systems and Applications for Financial, Banking, Health, Telecom and Retail sectors.
• Excellent working experience in testing Data Warehousing jobs (Informatica, SSIS, DataStage) and applications, Business Intelligence reports (OBIEE, SSRS, Micro Strategy, Cognos), Java based applications, Quality Assurance and management.
• Extensively done Data Centric Testing (data testing requiring data to be moved, copied from source to target systems correctly and completely, Checksum comparison, checking quality of data).
• Sound understanding in Software Development Life Cycle (SDLC), waterfall and Agile models.
• Experience in Functional testing, System Testing, Regression Testing, Integration testing, GUI Testing,Security testing, Smoke testing, System Integration Testing (SIT), Software Validation testing, Configuration testing, Interface testing, Stress and Performance Testing.
• Have tested several complex reports generated by Business Intelligence tools Cognos, Business Objects XI, Micro Strategy including dashboards, summary reports, master detailed, drill down and score cards, SSRS report validation and cube testing (SSAS).
• Involved in the Process improvement and changes like Change Management (CM), Change Request (CR) and implementing industry best practices using tool like ClearQuest.
• Expert in planning and executing Smoke, Functional, Integration, Regression, User Acceptance Testing, Compatibility Testing for Java and .Net based web application, Data Warehouse Application, UNIX based applications and Client Server applications.
• Experience testing ETL, PL/SQL, UNIX batch jobs using scheduling tools such as Autosys.
• Very good experience working with UNIX commands and UNIX Shell Scripting.
• Experienced in writing detailed Test Plans, Test Strategy, Test Data Management Plan and maintained Test Readiness Reviews (TRR) for large releases, application enhancements, maintenance releases and defect fixes for various applications.
• Knowledge in creating Business Scenarios, Test Scenarios, Test Cases for System, Integration, Regression using HP Quality Center and User Acceptance Testing.
• Experience working with Data Warehousing, Data Validations, Data Scrubbing, Data Cleansing, Data Profiling and Data Frequency Analysis.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica.
• Excellent working experience on Informatica Workflow Manager to run the workflows and monitored the status and logs in Workflow Monitor.
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
• Maintained and updated Requirements Traceability matrix (RTM) having Business Requirements, Technical Requirements, Test Scenarios and Test Cases for test completeness
• Managed all testing artifacts in HP Quality Center, TFS (Team Foundation Server), utilized the same for test execution and reporting.
• Expert in writing Complex SQL quires for backend testing and created several queries on the fly for user specific requirements for trouble shooting day-to-day production issues to identify root cause.
• Tested migration of applications from Development to Production environments.
• Experienced in coordinating testing effort between Onshore and Offshore teams.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x/8.x/7.x, SSIS, Data Stage, AbInitio

QA Tools: HP - Quality Center, Test Director, Quick Test Pro (QTP), JIRA

DBMS/Query Tools: TOAD, Rapid SQL, SQL Developer, SQL Navigator

Languages: SQL, PL/SQL

Databases: Oracle11/g/10g, SQL Server 2008/2005, DB2, TeradataV2R6/V2R5

Version Control Tools: Rational Clear Case, WIN CVS,TFS, Subversion

Requirements Tools: Doors, Rational Requisite Pro

BI / Reporting Tools: IBM Cognos 8.0, Business Objects BOXI, SSRS

Operating Systems: Windows - Vista, XP, 98, 2000, NT 4.0, UNIX - Sun Solaris, HP-UX

Scheduling Tools: Autosys, Control M, Flux

Other Tools: TextPad, CompareIT, PuTTY, WinScp, SnagIT

PROFESSIONAL EXPERIENCE

Confidential, Stamford, CT

DWH UAT ETL Tester/QA Data Analyst

Responsibilities:

• Developed formal Test cases based on functional requirements, general requirements and system specifications.
• Worked with developers to gather information for a set of Development Plan templates documenting the service’s requirements, functional, and technical design Included SDLC and Data Warehouse System Development Life Cycle documentation.
• Prepared test data for positive and negative test scenarios for Functional Testing as documented in the test plan.
• Tested 3NF Data Warehouse, Star Schema Data Marts
• Prepared Test Cases and Test Plans for the mappings developed through the ETL tool from the requirements.
• Extensively used Informatica Workflow Manager to run the workflows/mappings and monitored the session logs in Informatica Workflow Monitor.
• Verified session logs to identify the errors occurred during the ETL execution.
• Created Test Cases, traceability matrix based on mapping document and requirements.
• Validated the web services using the Soap UI.
• Involved in testing SSIS Packages, and in Data and application migration from development to production environment.
• Worked in Agile to create, maintain and execute test cases while participating in the validation of functional and non-functional requirements in an agile development environment.
• Creates table pairs in Informatica data validation option (DVO) and validated the data moving from source to target.
• Written several complex SQL queries for data verification and data quality checks.
• Reviewed the test cases written based on the Change Request document and Testing has been done based on Change Requests and Defect Requests.
• Effectively coordinated with development team for closing a defect using Team Foundation Server.
• Used Team Foundation Server as a test management tool for preparing test cases and executing them.
• Perform defect Tracking and reporting with strong emphasis on root-cause analysis to determine where and why defects are being introduced in the development process.
• Have tested reconcile and incremental ETL loads for the project.
• Scheduling shell script jobs, creating instances of jobs, verifying logs according to client requirement using Autosys server.
• Written Shell scripts to handle data before executing Informatica Maps and to meet pre-requirements.
• Profiled the data using Informatica data quality (IDQ).
• Tested Cascading Prompts and Multi Level Prompts on Dashboards.
• Identified issues, performance bottlenecks, and optimized the Business Intelligence Dashboards and Reports.
• Validated different kinds of OBIEE reports like pivots, charts, tabular and ad hoc reports.
• Involved in testing the Informatica mappings, by validating whether the mapping adhere to the development standards and naming conventions; whether the mapping do what the technical design says it should do.
• Developed UNIX Shell Scripts for scheduling various data cleansing scripts and loading process.
• Worked in Agile environment with 2 weeks sprints.

Environment: Informatica Power Center 9.5/ 9.1, Informatica Data Validation Option (DVO), Informatica Data Quality (IDQ), Star Schema Data Marts, Clear Case, OBIEE, Clear Quest, SQL, PL/SQL, UNIX, Putty, Shell Scripting, Soap UI, Web Services, Session Log files, TFS, XML files, Oracle 11g, Compare IT, HP Quality Center, Autosys, SQL Server 2012, TOAD, Agile.

Confidential, Rosemont, IL

DWH QA ETL Tester/ Reports Tester

Responsibilities:

• Involved in design and development of test plans based on high-level documents (BRD & FRS).
• Involved in high and detail level design reviews to ensure requirement traceability and to determine application/component functional readiness requirements.
• Being part of the test team, responsibilities involved writing complex queries using SQL and PL/SQL to generate data based on the complex derivations for each attribute.
• Complex SQL queries were written to compare data generated by the application against the expected results generated based on mapping requirements for each interface.
• Involved in testing of various Business objects universes and reports for Lay out and data quality.
• Exclusively involved in execution of Autosys jobs, PL/SQL batch programs and responsible for reporting the defects to development team.
• Defects identified in testing environment where communicated to the developers using defect tracking tool JIRA.
• Tested a number of complex ETL mappings and reusable transformations for daily data loads.
• Creating formal test cases for ETL mappings and design documents for production support.
• Worked with the development team to create a suite of test data (Input files, Expected results), that fully exercises Data Validation (detecting, rejecting bad data) to test ETL functionality (properly processing).
• Testing migration of applications from Development to Production environments
• Validated data consistency, data completeness, data quality in data migration and data conversion projects.
• Evaluated and created different document to support data migration process & troubleshooting during data and application migration process from development to production.
• Coordinated with different level of team members for successful data migration, goal, policies & progress update.
• Tracked and executed the User Acceptance Test Cases (UAT) with respect to the requirements to determine the feature coverage.
• Performed functional, data and cosmetic testing for OBIEE reports.
• Validated procedures, functions, triggers in T-SQL.
• Responsible for testing Initial and daily loads of ETL jobs.
• Involved in testing the batch scheduling programs by using the Autosys tool.
• Involved in creating various data scenarios (Excel Sheets having expected data) and validating them before and after running the respective Autosys batches.
• Developed UNIX scripts for file archiving, file transfers and file management.
• Involved in Database Validations, Writing Test scripts (Including the related SQL Statements by joining various tables) depending on Requirements for both Positive and Negative Scenarios.
• Linking Requirements from DOORS, to Test Scenarios in Quality Center.
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.
• Experienced with Data Warehouse System Development Life Cycle

Environment: UNIX, Oracle 11g, SQL, PL/SQL, Autosys, SQL Server 2008,Toad, Autosys, Business Objects XI, Star Schema Data Marts, Data Stage, Rational Clear Quest, TSQL, OBIEE, Quality Center, Putty, XML, Leech FTP, BMC Remedy, JIRA, Agile.

Confidential, Birmingham, AL

ETL/BI Tester/ QA Analyst

Responsibilities:

• Prepared test data for positive and negative test scenarios for Functional Testing as documented in the test plan.
• Extensively used Cognos for generating the reports and validating them according to business requirements.
• Responsible for testing of data marts, data stage, data validation, business objects universes, accuracy of calculated fields, accuracy of the data shown, Selection criteria shown, accuracy of subtotals, for the Cognos reports.
• Tested business object universes and reports in Cognos using Analysis studio, Report studio and query studio.
• Tested reports for column headings, field titles, column and field alignment, field spacing and size, fields in correct format (dates, currency etc).
• Written several complex SQL queries using joins, subqueries for data verification and data quality checks.
• Verified session logs to identify the errors occurred during the ETL execution.
• Created Test Cases, Traceability Matrix based on mapping document and requirements.
• Verified the logs to identify the errors occurred during the ETL execution.
• Reviewed the test cases written based on the Change Request document and Testing has been done based on Change Requests and Defect Requests.
• Validated SSRS reports according to requirements.
• Preparation of System Test Results after Test case execution.
• Effectively coordinated with the development team for closing a defect.
• Prepared Test Scenarios by creating Mock data based on the different test cases.
• Run Data Stage jobs by using Data Stage Director and by running UNIX scripts as well.
• Used Rational Clear Quest as defect tracking tool.
• Before the Load is accepted to test, have performed the smoke or shake-out test.
• Extensively used Oracle database to test Data Validity and Integrity for Data Updates, Deletes & Inserts.
• Worked in the role of data analyst in mapping and scrubbing sensitive data within the application.
• Provided the management with weekly QA documents like test metrics, reports, and schedules.

Environment: Oracle 11g, Cognos 8.0,SQL, Business Object, Star Schema Data Marts, Data Stage, Teradata V2R6/V2R5, SQL Assistant, Rational Clear Case, Rational Clear Quest, PL/SQL, UNIX, Putty, DB2, HP Quality Center, Autosys, Toad.

Confidential, Detroit, MI

ETL/QA Analyst/DW/Reports Tester

Responsibilities:

• Designed and Created test plan, test scenarios and test cases for Data warehouse and ETL testing.
• Responsible to translate business requirements into quality assurance test cases
• Review of test scenarios, formal test cases and Data warehouse Test Results.
• Developed test scripts using SQL queries to validate data.
• Prepared Regression Test Plans, Requirements Traceability Metrics (RTM), positive and negative test scenarios, detailed oriented Test Scripts, Test Kickoff documents, Test Scorecard for test progress status, Test Results, Release Check list, Lessons Learned documents and Regression Test Suite for future use.
• Responsible in testing Initial and daily loads of ETL jobs.
• Validated various Ab Initio graphs according to functional requirements.
• Interacted with design team to decide on the various dimensions and facts to test the application.
• Planned ahead of time to test the mapping parameters and variables by discussing with BA’s.
• Tested several reports detailing price/volume trends and expense variance over previous periods by using financial reporting and through the Interactive Reporting.
• Extensively tested several Cognos Reports for data quality, fonts, headers, footers, and cosmetics.
• Extensively involved in testing the ETL process of data sources, SAP, PeopleSoft, Teradata, SQL Server, Oracle, flat files into the target Teradata, Oracle database as per the data models.
• Analyzed the testing progress by conducting walk through meetings with internal quality assurance groups and with development groups.
• Responsible for documenting the process for future s.
• Responsible for in-depth knowledge of data, processes or applications in their specific area of responsibilities
• Reviewing the test activities through Software development meetings.
• Tested several data marts in star schema model
• Worked in waterfall methodology.
• Worked with the UNIX shell scripts.

Environment: Cognos, Quality Center, Rational Clear Case, Rational Clear Quest, Ab Initio, Rational Requisitepro, Autosys, Toad, Perl, Putty, Web logic, Oracle 10g/9i, SQL Server 2005, PL/SQL, Linux, Win XP, Data Warehouse System Development Life Cycle

Confidential, Reston, VA

QA Analyst/Database/Reports Tester

Responsibilities:

• Analyzed the Business Requirements and Rules and worked with Business Analysts and Business Users in preparing Test Plans.
• Gone through the functional Specifications and implemented their technical aspect in System and Integration testing (SIT).
• Developed Test cases, Test scripts from the data mapping documents, functional Specification documents and mapped the test cases with the requirements for generating the Requirement Traceability Matrix (RTM).
• Closely went through and worked on all the stages of SDLC for this project and designed and executed Functional, Integration, Regression, System (End to End) and Backend (Database).
• Developed and executed formal test cases and test scripts.
• Performed Integration, Regression, Performance and Functional Testing.
• Worked with the UNIX shell scripts.
• Used HP Quality Center as test management tool.
• Validated various SSIS packages according to functional specifications.
• Tested Cognos Reports according to the business requirements.
• Exclusively used Analysis Studio and Query Studio to test the Cognos Reports.
• Tested several complex reports generated by Cognos including Dashboards, Summary Reports, Master Detailed, Drill down.
• Prioritized the test cases based on the projected metrics and project deadlines.
• Analyzed and tested DataStage jobs with OLTP source data, staging and target data.
• Worked with Developers on Defects until the test case is passed.
• Extensively written SQL to confirm the data transfer from source to target.
• Found the Defects when running the test cases and assign to ETL Developers using Defect Tracking tool like Clear Quest.
• Tested data and cosmetics of Micro Strategy reports.
• Tested the PL/SQL procedures, functions, packages according to the requirements.
• Performed Backend database testing, by executing the Group functions, complex Joins and sub queries.
• Verified test results (viewing the log files using VI editor, querying the database using the SQL) documenting the defects.
• Involved in testing the UI screens, reports which was used by the internal business team.
• Responsible for Data integrity and Data validation testing.
• Executed ETL jobs through Data Stage director and monitored status.
• Prepared Test Scenarios by creating Mock data based on the different test cases.
• Attended Bi-Weekly Defect Review and Defect Status meetings.
• Provided updates to Team Lead on testing activities.
• Experienced with Data Warehouse System Development Life Cycle

Environment: Data Stage, SQL, HP Quality Center, Cognos 8.0, Micro Strategy, Clear Case, Clear Quest, RequisitePro, TOAD, JCL, Web Logic, Oracle 10g, SQL Server 2008, SSIS, SSRS, DB2, PL/SQL, UNIX, PuTTY.

Confidential, Phoenix, AZ

DW/BI/Reports Tester

Responsibilities:

• Analyzed business requirements and module-specific functionalities to identify test requirements and formulate an effective master test plan.
• Responsible for review of Functional Requirement Specification and System Design Specification documents for testing
• Performed extensive manual testing on critical functionalities of the application.
• Tested ETL graphs to extract and load data from different databases such as Oracle, SQL Server and flat files and loaded them in to Oracle.
• Design and Development of QA documentation like Test Cases and Test scenarios from business and functional requirements.
• Tested reports in Cognos using Analysis studio, Report studio and query studio.
• Experienced in analyzing the issue by checking the log files in the AIX environment.
• Used Mercury Quality Center for Test Planning, Test Designing, Test Analysis, Test Execution, Defect Tracking and Test Result
• Extensive querying using Toad to run SQL queries and monitor quality & integrity of data.
• Actively participated in creating requirements Traceability matrices and Test plans
• Performed Unit and functional testing for all the Mappings and Sessions.
• Extensively tested different kinds of reports like tabular, drill-down.
• Implemented automated Processes & scheduling using Autosys.

Environment: Cognos, Oracle 9i, SQL Server 2005, Rapid SQL, SQL, PL/SQL, Autosys, Toad, IBM AIX, MS Access, Unix, Mercury Quality Center.