SUMMARY:

• Over 7 years of progressive experience in Software Quality Assurance (QA) and tested Data Warehouse, Database (ETL & BI), Graphical User Interface (GUI), 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.
• Excellent working experience with web-based Graphical User Interface (GUI) testing, and experience of executing manual testing for GUI.
• 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.
• Validated the web services using the Soap UI.
• 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, ALM 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.
• Excellent experience with Mainframe tool to debugging and analysis.
• 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.
• Extensive experience in all testing methods including Waterfall, Spiral, V model, Agile and Scrum.
• 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, HP ALM, Selenium, Web Driver, UFT, 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: Mainframe, SAAS, TextPad, Agile, CompareIT, PuTTY, WinScp, SnagIT

PROFESSIONAL EXPERIENCE:

Confidential, Mclean, VA

ETL UAT Tester | QA Analyst

Responsibilities:

• Reviewed Functional Requirement Specifications and created test cases/test scripts based on test scenarios drawn from functional requirements/technical specifications.
• Performed Automated testing using SQL, Quality Center suite of tools.
• Prepared test data for positive and negative test scenarios for Functional Testing as documented in the test plan.
• Wrote Test Cases and Performed Manual & Automation Testing like GUI, Functionality, System, Integration, Regression, UAT, Localization Testing, Black Box testing and performed Positive/Negative, testing for system validations for mainframes, web based & Mobile applications.
• Support for User Acceptance Testing (UAT).
• Tested the web-based application manually and SQL for Automation.
• Created complex SQL queries to perform & validate the backend testing of the Application.
• Created and executed SQL queries to validate the data to verify the JSP front end correctly displays data.
• Scripted test cases for component and UAT using HP Quality Center.
• Tested .Net based applications extensively.
• Validated response with the XML Schema during Web Service Testing
• Followed the Agile methodology for the entire SDLC with daily scrum and through Sprints.
• Performed Web Service Testing using SOA Test Tool for Functional & Regression Testing
• Used Quality Center (HP ALM 11.0) for maintaining and tracking defects.
• Created a team project in TFS and tracked work with Visual Studio and TFS by creating backlog, work in sprints and reported progress via a chart progress.
• Supported the development of a test strategy to perform system integration and ETL using FICO Blaze and SAS.
• Wrote several complex SQL queries for data verification, data validation, data quality checks.
• Extensive querying using Toad to run SQL queries and monitor quality & integrity of data.
• Involved in preparation of System Test Results after Test case execution.
• Worked with data base validation, constraints validation, record counts, source to target validation, random sampling and error processing.
• Performed data validation, accuracy of calculated fields, Accuracy of the data shown, Selection criteria shown, Accuracy of subtotals for the Cognos reports.
• Validated the front end reporting components created using Cognos Reports as well as performed back end testing, making sure that the correct data for a specific report are being pulled out from the Data Warehouse.
• Performed Sanity, Functional, GUI, Unit, Integration and Regression Testing of the Application at different levels.
• 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.
• Involved in O&M mode of project post deployment and resolving deployment issues.
• Tested data migration to ensure that integrity of data was not compromised.
• Used Analytix as a data mapping requirements management tool.
• Used HP Quality Center as Test Management tool.
• Used Jira as defect management tool and SharePoint as version control tool.
• Extensively used Informatica Workflow to run workflows / mappings and monitored the session logs in Informatica Workflow Monitor.
• Involved in the System integration testing.
• Responsible in testing Initial and daily loads of ETL jobs, Involved in Black box testing and White box testing
• Before the Load is accepted to test, have performed the smoke or shake-out test.
• Extensively used Oracle database to test the 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.
• Verified Informatica session logs to identify the errors occurred during the ETL execution.
• Done regression testing after the defect fixed and change made in Functional or Business Requirement Document.
• Actively participated in stand up meetings, story reviews, and retrospectives of the Agile process.

Environment: Informatica Power center 9.1, Oracle 11g, UFT, HP ALM, JIRA, UAT, Share Point, TFS, MTM, MDM, Cognos, SQL Server 2008, T-SQL, SSRS, SharePoint, FICO Blaze, Jira, UNIX, BMC Remedy.

Confidential, Mooresville, NC

Web Services UAT ETL Tester | Data Analyst

Responsibilities:

• Responsible for Planning, Coordination and Implementation of QA methodology
• Responsible for analyzing, supplying & translating data using SQL queries on a multiple platform such as aqua data and WinSQL.
• Created User Stories based on requirements and tasks using agile methodologies.
• Creating tables, reading and writing queries using SQL and DB2 databases.
• Involved in mapping, tracking, manipulating data as per the requirement.
• Involved in handling large volume of data setup tickets.
• Heavily involved in automating repetitive tasks.
• Support Ad-hoc data requests with a timely and accurate response
• 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.
• Created automated functional testing scripts, tools, and data sets in an Agile development environment. Performed setup and maintenance of continuous integration environments.
• Involved in analyzing, designing and developing automated functional test scripts, programs and executed data set creation
• Worked with Agile Test Analysts and Developers to ensure test scenarios and plans meet specifications for projects, acceptance, and regression tests.
• 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.
• Provided updates to Team Lead on testing activities.

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

Confidential, Stamford, CT

DWH UAT Web Services 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.
• Excellent experience with Mainframe tool to debugging and analysis.
• 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.
• Created automated functional testing scripts, tools, and data sets in an Agile development environment. Performed setup and maintenance of continuous integration environments.
• Involved in analyzing, designing and developing automated functional test scripts, programs and executed data set creation
• Worked with Agile Test Analysts and Developers to ensure test scenarios and plans meet specifications for projects, acceptance, and regression tests.
• 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.
• Validate the responses of web services by passing various requests using soap UI.
• 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.
• Created User Stories based on requirements and tasks using agile methodologies.
• 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, Mainframe, Clear Quest, SQL, PL/SQL, SSAS, UNIX, Putty, GUI, Soap UI, Agile, Web Services, Session Log files, TFS, XML files, Oracle 11g, Compare IT, HP Quality Center ALM, Autosys, SQL Server 2012, TOAD, Agile.

Confidential, Rosemont, IL

DWH QA GUI Manual / 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.
• Excellent experience with Mainframe tool to debugging and analysis.
• Worked on Web-based Graphical User Interface (GUI) testing, and good experience of executing manual testing for GUI.
• 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.
• 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, GUI, SOAP, Data Stage, HP ALM, Mainframe, Rational Clear Quest, TSQL, OBIEE, Quality Center, Putty, XML, SAAS, 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, SOAP, GUI, SQL Assistant, SAAS, Rational Clear Case, Rational Clear Quest, PL/SQL, UNIX, Putty, DB2, HP Quality Center, Autosys, Agile, 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 references.
• 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, GUI, SOAP, Agile, 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.