SUMMARY

• Around 7 years of experience in Software Quality Assurance (QA) and tested Data Warehouse, Database (ETL & BI), Web, and Client - Server Systems and Applications for Health, Financial, 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
• Involved in the Process 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.
• Validated data consistency, data completeness, de-duping logics in data migration and data conversion projects.
• 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.
• Performed well under stress, working with multiple applications testing concurrently, coordinating QA activities with various teams and supported project management teams in release activities.
• Experienced in leading Software Testing projects and expert in coordinating testing effort between Onshore and Offshore teams.

TECHNICAL SKILLS

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

QA Tools: HP - Quality Center, Test Director, JIRA

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

Languages: SQL, PL/SQL

Databases: Oracle11/g/10g, SQL Server 2008/2005/2000, DB2, Teradata V2R6/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: Microsoft 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, SOAP UI, Load UI, Jmeter

PROFESSIONAL EXPERIENCE

Confidential, Parsippany, NJ

Sr. ETL/ BI/DWH Tester/QA Analyst

Responsibilities:

• Involved in design and development of test plans based on high-level documents -- BRD & FRS.
• Worked on 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 validating various Business objects 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 were communicated to the developers using defect tracking tool JIRA.
• Tested a number of complex ETL mappings and reusable transformations for daily data loads.
• Creating 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).
• Worked on Informatica Workflow Manager to run the workflows and monitored the status and logs in Workflow Monitor.
• Validated data consistency, data completeness, de-duping logics in data migration and data conversion projects.
• Evaluated and created different document to support data migration process & troubleshooting during Data migration process.
• Coordinated with different level of team members for successful data migration & progress update on same.
• 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 PL/SQL.
• 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.
• Reviewing the test activities through daily Agile Software development stand-up meetings.
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.

Environment: UNIX, Informatica 9.1, Oracle 11g, SQL, PL/SQL, Autosys, SQL Server 2008, Toad, Java, Autosys, Business Objects XI, Rational Clear Quest, TSQL, SQL Server 2008, OBIEE, Clear Case, UAT, Quality Center, Putty, XML, XSD, XSLT, Leech FTP, Remedy, Windows XP/NT, JIRA, Agile Methodology.

Confidential, Cleveland, OH

Sr. ETL BI DWH Tester/QA Analyst

Responsibilities:

• Reviewed the Business Requirements and developedTest cases based on functional requirements, general requirements and system specifications.
• Prepared test data for positive and negative test scenarios for Functional Testing as documented in the test plan.
• Prepared Test Plan from the Business Requirements and Functional Specification.
• Performed ETL testing based on ETL mapping document for data movement from source to target.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Performed backend database testing by writing SQL and PL/SQL scripts to verify data integrity
• Extensively used Informatica to load data from Flat Files to Teradata, Teradata to Flat Files and Teradata to Teradata.
• In a team environment, planned testing strategy for end to end flow through the system to link the front end functionality to the back end.
• Wrote test procedures for back end validation via functional specifications
• Prepared SQL scripts for test data preparation for Back End functionality testing
• Written several complex SQL queries to validate the Data Transformation Rules for ETL testing.
• Written extensive UNIX Shell scripting for data parsing and text parsing needs including archiving the old data, running backend jobs & setting up of job dependencies.
• Performed extensive data validations against Data Warehouse.
• Loaded flat file Data into Teradata tables using Unix Shell scripts.
• Responsible for verifying business requirements, ETL Analysis, ETL test and design of the flow and the logic for the Data warehouse using Informatica and Shell Scripting
• Tested several Informatica Mappings to validate the business conditions.
• Designed and executed the test cases on the application as per company standards and tracked the defects using HP Quality Center 9.2
• Designed and prepared scripts to monitor uptime/downtime of different system components.
• Written Test Cases for ETL to compare Source and Target database systems.
• Monitored the data movement process through Data Extract to flat files through Informatica execution flows and Loading data to Data mart through NZLOAD utility.
• Testing the ETL data movement from Oracle Data mart to Teradata on an Incremental and full load basis.
• Developed the ETL process to automate the testing process and also to load the test data into the testing tables.
• Used Excel Pivoting for various running totals, total sales for trades, highest performance of trades.

Environment: Informatica Power Center 8.6.1, Oracle 10g/9i, SQL, PL/SQL, Excel Pivot, Business Objects 4.1/5.1.5 /6., DB2 UDB, WinSQL, UNIX (AIX), Linux, PuTTY, WinSCP3, Mercury Quality Center 9.0/8.0, Autosys, Teradata, TOAD, XML

Confidential, Houston, TX

ETL/DW QA Analyst/Data Analyst

Responsibilities:

• Designed and Created test plan, test scenarios and test cases for Data warehouse and ETL testing.
• Responsible for translating the business requirements into quality assurance test cases
• Review of test scenarios, test cases and Data warehouse Test Results.
• Developed test scripts using SQL queries to validate data.
• Responsible in testing Initial and daily loads of ETL jobs.
• 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.
• Ran and monitored the Data Stage jobs in Data Stage Director.
• Extensively usedRational ClearQuestto track defects and managed them.
• Extensively tested several Cognos Reports for data quality, fonts, headers, footers, and cosmetics.
• Involved in analyzing the data, and preparation of ad hoc reports for Business needs.
• Created test cases and Scripts to test the Performance of the application using Load Runner.
• 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 references.
• Responsible for in-depth knowledge of data, processes or applications in their specific area of responsibilities

Environment: Data Stage 8.0, HP Quality Center, Cognos, Rational Clear Case, Rational Clear Quest, Rational RequisitePro, XML, XSD, XSLT, Teradata, Web Testing, Java, .Net, TOAD, DB2, Remedy, Oracle 9i, SQL Server 2005, PL/SQL, Linux, Win XP

Confidential, Bellevue, WA

Database/Backend Tester

Responsibilities:

• Reviewed 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 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.
• Involved in testing packages/procedures/functions using TOAD.
• Tested OBIEE 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.
• Worked with Developers on Defects until the test case is passed.
• Extensively written SQL to confirm the data transfer from source to target.
• Created Temporary tables, procedures, views, materialized views in Test environment.
• 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.
• 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.

Environment: OBIEE 11g, Cognos, Clear Quest, Rational Requisite Pro, Clear Case, TOAD, GS Data generator, SOA, MS Access, Oracle 10g/9i, SQL Server 2010, Quality center ALM, PL/SQL, Linux, UNIX, Putty, SharePoint, SQL scripts.

Confidential, King of Prussia, PA

Database Tester/Backend Tester

Responsibilities:

• Analyzed business requirements and module-specific functionalities to identify test requirements and formulate an effective master test plan.
• Used TestDirector to Report bugs and Data Quality Issues on each check sum and field validation Tests completed.
• Communicated with Developers about the status of each Data Quality Issues.
• Ran SQL Statements manually to execute Record Counts on Each Table Loaded into System and Compared with Source Table.
• Wrote complex SQL for data validation.
• Created test data to validate procedures.
• Modifying the existing Shell Scripts with Ultra Edit utility.
• Written various Unix Shell Scripts for Scheduling the job in production like check file script, load script, complete script, and DQ script.
• Responsible to find out different DDL Issues and Report to DBA's using Test Director.
• Created various User Defined Functions for script enhancements and to verify the business logic.
• Worked with Developers on Defects until the test case is passed.
• Extensively written SQL to confirm the data transfer from source to target.
• Created Temporary tables, procedures, views, materialized views in Test environment.
• Tested the PL/SQL procedures, functions, packages according to the requirements
• Wrote complex SQL scripts in Oracle for testing data quality and validation.
• Execute the Unix Shell Scripts to Know the Backend Batch Jobs Status

Environment: Oracle 9i, Autosys, Business Objects 5.x, Windows NT, Shell Scripting, SQL, PL/SQL, Test Scripts.