SUMMARY

• Over 8 years of IT experience in Quality Assurance and Software Testing of various business applications in Client/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 such as TOAD, SQL Navigator, SQL Assistant and SQL Plus.
• Expert level skills in testing the Enterprise Data Warehouses using Informatica Power Center, Ab Initio, Data Stage, and SSIS ETL tools.
• Experience on UNIX commands and Shell Scripting
• Experienced in Functional testing, Performance testing, Load testing, Integration testing, System Testing, Regression testing, Black Box testing, Stress 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, Data Warehouse Architecture.
• Have good experience in testing the Web services according to the requirements.
• 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.
• Experienced in using the Oracle SQL* Loader features for loading the data from Flat Files to Data Base tables for Bulk Loading.
• 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.
• Knowledge on the phases of Agile methodology and scrum Methodology.
• Excellent interpersonal, communication, documentation and presentation skills.

TECHNICAL SKILLS

QA Methodologies: Iterative, Agile, Waterfall and Spiral Methodology

QA Tools: Hewlett Packard (HP) - Quality Center

IBM / Rational: Clear Quest

Microsoft: Team Foundation Server

ETL Tools: Informatica Power Center 9.x/8.x/7.x, Ab Initio (2.x) Data Stage 8.x/7.x, SSIS

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

DBMS Tools: TOAD, Embarcadero Rapid SQL, SQL Developer

Operating Systems: Microsoft Windows - Vista, XP, 2000, NT 4.0, OS/2

UNIX: Sun Solaris, HP-UX

Databases: Oracle 10g, 9i, 8i

Microsoft: MS Access, SQL Server 2005/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

Batch Scheduling: Autosys, UNIX Cron Jobs

PROFESSIONAL EXPERIENCE

Confidential, Columbia, MD

Sr.QA Analyst/Back End Tester/Front End Tester

Responsibilities:

• Prepared test plans and test strategy for the entire system based upon the business requirements
• Prepared test case scenarios, test cases and test scripts for the user interface testing and back end testing.
• Prepared test data for User Interface testing
• Interacted with the Business System Analyst and clients in understanding the business logics, rules and requirements
• Reviewed the test plan and test case workbook with the team and the clients
• Performed Functional testing, System integration testing, Performance testing, and Regression testing.
• Identified defects and worked extensively in defect management using JIRA tool
• Facilitated and participated in test triage sessions, internal daily scrums and client meetings
• Wrote SQL queries to validate the output tables
• Worked in validating derived variables. Written several complex SQL queries for data verification and data quality checks.
• Data comparison of the data generated by the RM system with the existing Microsoft system.
• Validated Cognos reports for data quality and the cosmetics.
• Manually validated different support process items.
• Manually compared the scripts generated by the SQL Generator with the inputs in User Interface.
• Executed the Informatica workflows and mappings using workflow manager and verified their status and logs using workflow monitor.
• Used UNIX commands and shell scripts for file management.
• Interacted intensively with development teams, business teams and clients till defect was closed.
• Provided support to UAT team with execution of their mock data in system test environment.
• Conducted final test result summary review and test case workbook review to the clients.
• Worked on all the phases of SDLC in Agile process.

Environment: SQL Server 2008, Oracle 11g, JIRA, Informatica Power Center 9.1, Informatica Data Quality 9.1, CVS, PL/SQL, Knowledge Link, Client Net, Cognos 10, Agile, Flat files, Session Logs, SQL Scripts, UNIX

Confidential, Richmond, VA

Sr. QA Analyst/ETL/DWH Tester

Responsibilities:

• Analyzed Business requirements interacted with Business Team in understanding the Business logic.
• Involved in preparing the mock test data for both the serial files and multi files (MFS).
• Performed the data validation for the inbound and outbound files.
• Ran Ab Initio graphs and checks the data integrity and data validations according to the Data mapping requirements and the functional flow.
• Worked actively on all the stages of SDLC for this project.
• Created several mock scenarios in testing the Business Requirements extensively to avoid any missing gaps.
• Created MS Word, and MS Excel templates to upload the test cases directly to Manual Tester using the inbuilt tools.
• Mapped Test cases to the requirement to ensure 100% coverage.
• Assigned Requirement Traceability Matrix (RTM) for all test cases in QC.
• Manually ran the test cases in Quality Center.
• Involved in Functional, Integration and Web Services testing.
• Validated business objects reports for data quality and the lay out of the reports.
• Involved in constantly monitoring the log files to make sure the process ran smoothly, contacting the Developing team if any errors encountered.
• Wrote SQL queries to validate Test data and comparing with Production data.
• Project is in Agile Environment, so involved in daily meetings, reports to Team Leads in regular fashions, worked in Sprints.
• Interacted with developing and business team till defect closure.
• Provided extensive support to UAT team with execution of their mock data in system test environment.
• Tested several Ab Initio graphs using GDE tool as part of functional testing.
• Created several UNIX scripts in automating the testing process. (Ex: scheduling the jobs, loader processes).
• Used UNIX commands for file management.
• Involved actively in weekly status meetings and provided testing status to Developing team, UAT team and QA team.
• Involved interactively with the team, providing better solutions within the team for any issues encountered.
• Developed Test Summary document at the end of each Build.

Environment: Ab Initio 2.x, HP Quality Center, TOAD, Oracle 10g, Teradata, SQL Assistant, PL/SQL, Linux, UNIX, Putty, Business Objects, Clear Case, Clear Quest, Quality Center 10, Agile, Flat files, Session Logs, SQL Scripts

Confidential, Minnetonka, MN

Sr. QA Analyst/DW/BI Tester

Responsibilities:

• Analyzed the Business Requirements and Rules and worked with Business Analysts and Business Users in preparing Test Plans.
• Gone thru 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).
• Tested the ETL Informatica mappings and other ETL Processes (DW Testing).
• Developed and executed test cases and test scripts.
• Involved in testing the batch programs by using the Autosys tool.
• Worked with the UNIX shell scripts.
• Used HP Quality Center as test management tool.
• Tested Cognos Reports according to the business requirements.
• Exclusively used Analysis Studio and Report 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.
• Found the Defects when running the test cases and assign to ETL Developers using Defect Tracking tool Clear Quest.
• Validated standard and Ad hoc reports in OBIEE.
• Performed Backend database testing, by executing the Group functions, complex Joins and sub queries.
• Validated SSIS and SSRS packages according to data mapping specifications.
• Involved in testing the Web Services.
• Extensively used Informatica Workflow Manager to run the workflows.
• Verified test results (viewing the log files using VI editor, querying the database using the SQL) documenting the defects.
• Monitored the session logs/log files in Informatica Workflow Monitor.
• Involved in testing the UI screens, reports which was used by the internal business team.
• Involve in the defects tracking meeting for the system integration testing and communicated the issues and escalations with the project manager.
• Involved in testing the functionality of Data Stage jobs.
• Effectively coordinated with the development team for closing a defect.
• 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: Informatica Power Center 8.6, Data Stage 8.0, HP Quality Center, OBIEE, Rational Clear Case, Rational Clear Quest, Rational RequisitePro, Autosys, TOAD, JCL, Web Logic, MS Access, Oracle 10g, SQL Server 2008, SSIS, SSRS, SSAS, DB2, PL/SQL, Linux, UNIX, PuTTY, Flat files, Session Logs, SQL scripts.

Confidential, Charlotte, NC

Sr. QA Analyst/Data Test Engineer

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.
• 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.
• 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.
• Performed complex data validation using SQL queries.
• Written several complex SQL queries for data verification and data quality checks.
• Developed test plan with testing scenarios from theend user perspective for User AcceptanceTesting (UAT).
• Preparation of System Test Results after Test case execution.
• Used Data Stage Director to validate, run and monitor the Data Stage jobs.
• Tested the ETL Informatica mappings and other ETL Processes (DW Testing).
• Effectively coordinated with the development team for closing a defect.
• Prepared Test Scenarios by creating Mock data based on the different test cases.
• Have tested reconcile and incremental ETL loads for the project.
• Tested data migration to ensure that integrity of data was not compromised.
• Used Rational Clear Quest as defect tracking tool.
• Have tested the functionality of batch jobs which were developed in Autosys.
• Done data validation for the Cognos reports.
• Tested reports in Cognos using Analysis studio, Report studio and query studio.
• Provided the management with weekly QA documents like test metrics, reports, and schedules.

Environment: Oracle 10g, Data Stage 8.1, Informatica Power Center 8.4, Autosys, ClearCase, IBM Cognos 8.0, ClearQuest, SQL, PL/SQL, UNIX, Putty, Teradata V2R6, Flat files, XML, XSD, XSLT, HP Quality Center, Web Services, SQL Server 2008, SSIS, SSRS, TOAD.

Confidential, Charlotte, NC

Sr. QA Analyst/DW 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 developed by Ab Initio.
• 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 the Ab Initio graphs according to data mapping requirements.
• Extensively usedRational ClearQuestto track defects and managed them.
• 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 Micro Strategy Reports for data quality, fonts, headers, footers, and cosmetics.
• 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.
• 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: Ab Initio 2.14/2.13, HP Quality Center, Micro Strategy, Rational Clear Case, Rational Clear Quest, Rational RequisitePro, TOAD, JCL, Web Logic, Java, Oracle 10g/9i, SQL Server 2005, PL/SQL, Linux, Win XP

Confidential, Dallas, TX

DW/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.
• 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 ETL 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; 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.
• Used Mercury Quality Center for Test Planning, Test Designing, Test Analysis, Test Execution, Defect Tracking and Test Result
• Tested data and cosmetics of Micro Strategy reports.
• Actively participated in creating requirements Traceability matrices and Test plans
• Performed Unit and functional testing for all the Mappings and Sessions.

Environment: Oracle 9i, SQL Server 2005, Rapid SQL, Data Stage 7.x, Micro Strategy, SQL, PL/SQL, Toad, IBM AIX, MS Access, Web Services, Unix, Mercury Quality Center

Confidential, Dallas, TX

QA Analyst/DW Tester

Responsibilities:

• Involved in business processes and quality assurance on testing across entire product life cycle stages from requirements to implementation.
• Prepared Test Cases and Test Plans for the mappings developed through the ETL Informatica tool from the requirements.
• Verified Ab Initio session logs to identify the errors occurred during the ETL execution.
• Used Quality center for test scripts repository and Clear Quest for defect tracking.
• Understanding UML diagrams, Use cases, ER and Data models for writing test cases.
• Done data validation for the Cognos reports.
• Used Test Director for test management activities.
• Worked with data validation, constraints, record counts, and source to target, row counts, random sampling and error processing.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Tested the functionality of Ab Initio graphs.
• Written test cases, test scripts for data warehousing application according to data mapping requirements and executed them.
• Queried data from different database tables as per the requirement by writing complex SQL queries for data validation.
• Extensively used UNIX commands for fetching and checking the Log files.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Effectively coordinated with the development team for resolving defects.

Environment: Ab Initio, Oracle 8i, SQL Server, SQL, PL/SQL, Cognos, XML, XSD, XSLT, Toad, IBM AIX, MS Access, Unix log files, Test Director, ClearCase, ClearQuest