SUMMARY:

• Around 8 years of experience in Quality Assurance, Data Analysis and Software Testing of various business applications inClient/Server environments, Web - based applications, Data Warehousing solutions, ETL and Business Intelligence solutions.
• Excellent working knowledge of System Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC) and Defect Life Cycle.
• Expertise in Writing, Executing and Maintaining Test Plans, Test Strategy, Test Procedures, Use Cases, Test cases.
• Have solid experience on database query tools TOAD, SQL Navigator, SQL Assistant.
• Expert level skills in testing Enterprise Data Warehouses using Informatica Power Center, Data Stage, Ab Initio, and SSIS ETL tools.
• Experience in working with execution of the scheduled jobs by using Autosys.
• Experience on UNIX commands and Shell Scripting.
• Experienced in Functional testing, Performance testing, Load testing, Integration testing, System Testing, Regression testing, SIT, UAT, Black Box testing, White Box, Testing, Smoke Testing, Recovery Testing and GUI Testing.
• Strong experience in preparing documentation, preparing test environments, executing and analyzing the results.
• Very good understanding of Data Warehousing concepts, Data Analysis.
• Extensively used Informatica Workflow Manager to run the workflows.
• Monitored the session logs/log files in Informatica Workflow Monitor.
• Have experience in testing reconcile (initial) and delta (daily) loads.
• Have tested several complex reports generated by Cognos, including dashboards, summary reports, master detailed, drill down and score cards.
• Involved in preparation of Requirement Traceability Matrix (RTM), Defect Report, and Weekly Status Reports.
• Have experience in Bulk loading data from Flat files into Oracle using SQL * Loader
• Proficiency in Defect management, including Defect creation, modification, tracking, and reporting using Industry standard Tools like Quality Center, Test Director, Clear Quest.
• Expert in writing complexSQL queries for back-end testing.
• Experienced in interacting with Clients, Business Analysts, UAT Users and Developers.
• Experience in Data Analysis, Data Cleansing (Scrubbing), Data Validation and Verification, Data Conversion, Data Migrations and Data Mining.
• Excellent interpersonal, communication, documentation and presentation skills.

TECHNICAL SKILLS:

SDLC Methodologies: Iterative, Agile, Waterfall and Spiral Methodology

QA Tools: Hewlett Packard (HP) - Quality Center

IBM / Rational: Clear Quest

ETL Tools: Informatica Power Center 9.x/8.x, Informatica IDQ, Ab InitioData stage 8.x/7.x, SSIS

BI/Reporting Tools: IBM Cognos 10, Micro Strategy, Business Objects, SSRS

DBMS Tools: TOAD, Embarcadero Rapid SQL, SQL Developer

Operating Systems: Microsoft Windows - Vista, XP, 2000, NT 4.0, Linux, Unix

Databases: Oracle: 11g, 10g, 9i, Microsoft: Access, SQL Server 2012/2008

IBM: DB2, DB2/UDB, Teradata: V2R6, V2R5

Languages: SQL, PL/SQL, UNIX Shell Scripts, VB Script, Java, C

Version Control Tools: Clear Case, DOORS, Requisite Pro

Scheduling Tools: Autosys, Control-M

Other Tools: Putty, CompareIT, TextPad, WinSCP

PROFESSIONAL EXPERIENCE:

Confidential, Bellevue, WA

Sr. QA Analyst / DW / BI / Data Analyst

Responsibilities:

• Analyzed the business requirements, system requirements, and data mapping requirement specifications, interacting with client, developers and QA team.
• Written Test Plans, Test Strategy, Test Script, Test Cases, Reported bugs and tracked defects using Quality Center
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing
• Written complex SQL queries for data validation for verifying the ETL Mapping Rules.
• Tested Metadata of tables including the data types, constraints and default values on the columns.
• Involved in maintaining the test environments; with activities like requesting data loads, data base backups, restarting the servers, requesting the deployments, troubleshooting issues.
• Used Toad to run SQL queries and validate the data loaded in to the target tables.
• Involved in user training sessions and assisting in UAT (User Acceptance Testing).
• Involved in Functional Testing, Regression Testing, Sanity Testing, Ad-hoc Testing and User Acceptance Testing.
• Created and executed Test cases in Soap UI to validate web services.
• TestedAbInitiographs with both positive and negative scenarios.
• Responsible to test the functionality of Informatica workflows.
• Responsible for testing Initial and daily loads of ETL workflows.
• Involved in preparationand maintenance of theRequirement Traceability Matrix(RTM) to measure the progress, test matrix and test script review.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
• Exclusively involved in execution of Autosys jobs, PL/SQL batch programs and responsible for reporting the defects to development team.
• Scheduling shell script jobs, creating instances of jobs, verifying logs according to client requirement using Autosys server
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Written several complex SQL queries for validating Business Objects Reports.
• Created Test input requirements and prepared the test data for Data Driven testing.
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Tested the different sources such as Flat files, Main Frame Legacy Flat Files, SQL server 2005 and Oracle to load into the Oracle data warehouse
• Extensively usedRational Clear Questto track defects and managed them.
• Tested whether the reports developed in Micro Strategy are as per company standards.
• Performed periodic checks to run crosscheck against QA/SIT/PROD environments to ensure it is up and running.
• Monitored the session logs/log files in Informatica Workflow Monitor.
• Involved in testing the UI screens, reports, web applications for cross browser compatibility.
• Checked the SOA Architecture for validating the errors.
• Involve in the defects tracking meeting for the system integration testing and communicated the issues and escalations with the project manager.
• Tested theETLInformatica mappings and otherETLProcesses (DW Testing).
• Provided updates to Project Manager and other team members on testing activities. Attended daily standup meetings.

Environment: Informatica Power Center 9.1, Informatica IDQ, Informatica DVO, Informatica Power Exchange, OBIEE 11g, Cognos, SharePoint, Clear Quest, Rational Requisite Pro, Clear Case, TOAD, GS Data generator, SOA, MS Access, Oracle 11g, SQL Server 2010, Quality center ALM, PL/SQL, ERWIN, Data Flux, Flux, Linux, UNIX, Putty, Flat files, Session Logs, SQL scripts.

Confidential, New York, NY

Sr. QA Analyst / DW / BI / Web Tester / Data Analyst

Responsibilities:

• Experience working with product/Business management to prepare test plans, test scenarios, test cases and scripts from the BRDs and mapping requirements.
• Performed smoke testing, functional testing, regression testing, performance testing, load testing of application with in the specified timelines to meet the monthly release deadlines.
• Experienced in leading offshore team, providing tasks to offshore team and solving the issues faced by them.
• Experience in leading the modules of the project and was responsible for successful delivery on time.
• Involved in creating the UAT test scenarios and worked with the business users to execute the UAT test scenarios.
• Used TFS as test management tool.
• Tested Micro strategy Reports according to the business requirements.
• Tested several complex reports generated by Micro strategy Dashboards, Summary Reports, Master Detailed,Drill down.
• Prioritized the test cases based on the projected metrics and project deadlines.
• Analyzed and tested Informatica Mappings with OLTP source data, staging and target data.
• Handled work flow analysis in SOA Architecture.
• Written several complex SQL queries to cover all edge case scenarios.
• Tested web applications for verifying the data quality and User presentation.
• Tested the browser compatibility of web applications on different browsers such as Google Chrome, Internet Explorer, Safari and Mozilla Firefox
• Extensively tested PL/SQL batch processes (Autosys Jobs), PL/SQL programs - Packages, Functions, Stored Procedures, Collections, Cursors, and Triggers.
• 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.
• Involved validating SSIS and SSRS packages against the requirements.
• Worked in micro strategy upgradation from version 8 to 9 and making sure that the reports are working fine on Micro strategy 9.0
• Extensively used Informatica Workflow Manager to run the workflows.
• Monitored the session logs/log files in Informatica Workflow Monitor.
• Involved in testing the web pages, UI screens, and reports which are was used by the business users, client member users.
• Involve in the defects tracking meeting for the system integration testing and communicated the issues and escalations with the project manager.
• Involved in daily agile scrum meetings, demos, monthly story reviews, release retrospectives, provided estimates for stories and tasks.
• Conducted weekly Demo sessions to gather early feedback from the product management.
• Prepared Test Scenarios by creating Mock data based on the different test cases.
• Actively provided updates to Project Manager and other team members on testing activities by sending bi weekly testing metrics and test status.

Environment: Informatica Power Center 8.6, Micro Strategy 9.0/8.0, Rational Clear Case, Rational Clear Quest, Rally, TOAD, SOA, .Net, C#, web applications, IIS7, Fiddler 2, Soup UI, Oracle 11g, SQL Server 2010, SSIS, SSRS, Visual studio, TFS, XML, XSLT, XSD, PL/SQL, Selenium, ERWIN, Linux, UNIX, PuTTY, Flat files, Session Logs, Autosys, SQL scripts.

Confidential, Danville, PA

QA Analyst / DW / BI / Back End Tester

Responsibilities:

• Analyzed the Requirements and Rules and worked with Business Analysts and Business Users in preparing Test Plans.
• 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).
• Developed and executed test scenarios, test cases and test scripts.
• Involved in creating test data using GS Data Generator and Excel for covering all the test scenarios.
• Written several SQL queries to validate the functionality of ETLs and Reports.
• Performed Integration, Regression, Performance and Functional Testing.
• Used HP Quality Center as test management tool.
• Tested OBIEE Reports according to the business requirements.
• Created source to target mapping documents by analyzing the requirements.
• Tested several complex reports generated by OBIEE including Dashboards, Summary Reports, Master Detailed,Drill down.
• Analyzed and tested Informatica Mappings with OLTP source data, staging and target data.
• Managed onshore and offshore team. Assigned tasks and monitored the progress.
• Validated the ad hoc reports in OBIEE according to the requirements.
• Performed Backend database testing, by executing the Group functions, complex Joins and sub queries.
• Extensively tested PL/SQL batch processes, PL/SQL programs - Packages, Functions, Stored Procedures, Collections, Cursors, and Triggers.
• 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.
• Validated the SOA architecture.
• Verified test results (viewing the log files using VI editor, querying the database using the SQL) documenting the defects. Worked with the UNIX shell scripts.
• 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.
• Extensively tested the data validations and profiling done by data flux. Involved in testing the error files, Ack, Nack, Frequency reports generated by data flux.
• Extensively used Informatica Workflow Manager to run the workflows.
• Monitored the session logs/log files in Informatica Workflow Monitor.
• Involved in testing the UI screens, reports, web applications for cross browser compatibility.
• Checked the SOA Architecture for validating the errors.
• Involve in the defects tracking meeting for the system integration testing and communicated the issues and escalations with the project manager.
• Tested theETLInformatica mappings and otherETLProcesses (DW Testing).
• Provided updates to Project Manager and other team members on testing activities. Attended daily standup meetings.

Environment: Informatica Power Center 9.1, Informatica IDQ, Informatica DVO, Informatica Power Exchange, OBIEE 11g, SharePoint, Clear Quest, Rational Requisite Pro, Clear Case, TOAD, GS Data generator, SOA, MS Access, Oracle 11g, SQL Server 2010, Quality center ALM, PL/SQL, ERWIN, Data Flux, Flux, Linux, UNIX, Putty, Flat files, Session Logs, SQL scripts.

Confidential, Cleveland, OH

QA Analyst / DW / BI / Data Migration Tester

Responsibilities:

• Analyzed the Requirements from the client 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.
• Worked as an onshore offshore coordinator.
• PerformedSmoke Testing, GUITesting, FunctionalTesting, Backend Testing, System Integration Testing, Sanity Testing,andUser Acceptance Testing (UAT).
• Prepared Test Cases and Test Plans for the mappings developed through the ETL tool from the requirements.
• Validated the WSDL using schema compliance assertion in Soap UI.
• Verified session logs to identify the errors occurred during the ETL execution.
• Created Test Cases, traceability matrix based on mapping document and requirements.
• 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.
• Developed test plan with testing scenarios from theend user perspective for User AcceptanceTesting (UAT). experience on using Web Service such as SOAP and WSDL
• Tested access privileges for several users based on their roles in WebPages log in.
• Involved in testing PL/SQL programs, PL/SQL batch processes, UNIX Shell Scripts.
• Preparation of System Test Results after Test case execution.
• Used Ab Initio GDE and Co-op to run the graphs and monitor them.
• Effectively coordinated with the development team for closing a defect.
• Prepared Test Scenarios by creating Mock data based on the different test cases.
• 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.
• Debugging and Scheduling ETL Jobs/Mappings and monitoring error logs.
• Have tested reconcile and incremental ETL loads for the project.
• Tested data migration to ensure that integrity of data was not compromised.
• Have worked in production support team for EDW ETLs execution support in 24X7 shifts.
• Wrote complex SQL queries for extracting data from multiple table, multiple databases.
• Performed quality check/ Data analysis on data coming from different sources.
• Involved in testing the batch programs by using the Autosys tool.
• 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 the Data Validity and Integrity for Data Updates, Deletes & Inserts. Performed complex data validation using SQL queries.
• Tested various test harnesses and UI screens for testing integration of PL/SQL subprograms with the front end.
• Done data validation for the Business Objects reports.
• Provided the management with weekly QA documents like test metrics, reports, and schedules.

Environment: Oracle 10g, Ab Initio, Clear Case, Business Objects XI, Clear Quest, SQL, PL/SQL, UNIX, Autosys, Putty, ERWIN, Teradata V2R6, Session log files, Flat files, Batch processing, Mainframes, Web based Testing, Java, Apache, Soap UI, Web Services, API, HP Quality Center, Remedy, SQL Server 2008, SSIS, and TOAD.

Confidential, Houston, TX

QA Analyst / DW Tester / Web 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, 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.
• 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.
• Tested Informatica mappings for various ETL functions.
• Extensively involved in testing theETLprocess of data sources, SAP, PeopleSoft, Teradata, SQL Server, Oracle, flat files into the target Teradata, Oracle database as per the data models.
• Executed automated test scripts using QTP for Regression testing.
• 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
• Reviewing the test activities through daily Agile Software development stand-up meetings.

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

Confidential, Manhattan, NY

Backend Tester / Web 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.
• TestedETLmappings 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.
• Involved in testing the Data Stage ETL jobs, 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; whether the mapping work correctly in relation to other processes in your data logistical flow
• Experienced in analyzing the issue by checking the log files in the AIX environment.
• Tested several user logins and web page navigation based on the user roles.
• Extensive used 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.
• Implemented automated Processes & scheduling using Autosys.

Environment: Mercury Test Director, Oracle 8i, SQL Server 2003, Data Stage, SQL, TOAD, Web based Testing, IBM AIX, MS Access, Unix.