Summary:

• Over 9 years experience in Quality Assurance 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 such as TOAD, SQL Navigator, SQL Assistant and SQL Plus.
• Expert level skills in testing the Enterprise Data Warehouses using Informatica Power Center, Data Stage, 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, 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
• 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 queriesfor 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.
• Experience in 24X7 production support, ETL executions and resolving root causes.
• 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
ETL Tools: Informatica Power Center 8.x/7.x,
Data stage 8.1/8.0/7.5/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

Professional Experience:

10/2009 - Present
Confidential, Reston, VA
Sr. QA Analyst/DW/BI/BackEnd Tester

• 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).
• Closely went through and worked on all the stages of SDLC for this project and designed and executed Functional, Integration, Regression, and System (End to End), 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.
• 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.
• Analyzed and tested Informatica Mappings with OLTP source data, staging and target data.
• 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.
• 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.
• 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 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.
• Tested theETLInformatica mappings and otherETLProcesses (DW Testing).
• Prepared Test Scenarios by creating Mock data based on the different test cases.
• Provided updates to Project Manager and other team members on testing activities. Attended daily agile standup meetings.

Environment: Informatica Power Center 8.6, Cognos 8.0, Rational Clear Case, Rational Clear Quest, Rational RequisitePro, TOAD, JCL, Web Logic, MS Access, Oracle 11g, SQL Server 2008, DB2, XML, XSLT, XSD, PL/SQL, ERWIN, Data Flux, Flux, Linux, UNIX, PuTTY, Flat files, Session Logs, SQL scripts, HP Quality Center.
03/2008 - 09/2009

Confidential, Charlotte, NC
Sr. QA Analyst/DW/BI/ Production Support Analyst

• 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.
• 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).
• 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.
• Tested theETLInformatica mappings and otherETLProcesses (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.
• 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.
• Extensively worked with flat files and excel sheet data sources. Wrote scripts to transfer data from database to excel or flat files and used SQL Loader to load data from excel or flat files to data base.
• 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 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, Ab Initio, Informatica Power Center 8.4, ClearCase, IBM Cognos 8.0, Micro Strategy,ClearQuest, SQL, PL/SQL, UNIX, Autosys, Putty, ERWIN, Teradata V2R6, Session log files, Flat files, SOA, Batch processing, Mainframes, Web based Testing, Java, HP Quality Center, Remedy, SQL Server 2008, SSIS, and TOAD.
12/2006 - 03/2008

Confidential, Springfield, MA
Sr. QA Analyst/DW Tester/Data Analyst/Web Tester

• 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.
• 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 MicroStrategy 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: Informatica Power Center 8.0, Data stage 8.0, HP Quality Center, Micro Strategy, Informatics, Rational Clear Case, Rational Clear Quest, Data Stage, Rational RequisitePro, XML, XSD, XSLT, Web Testing, Java, .Net, TOAD, JCL, Remedy, Quick Test Professional (QTP), Perl, Web logic, Oracle 10g/9i, SQL Server 2005, PL/SQL, Linux, Win XP

08/2004 - 12/2006
Confidential, Manhattan, NY
DW/Reports Tester/ Backend Tester/Web tester

• 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 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.
• Tested data and cosmetics of MicroStrategy reports.
• 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:Oracle 9i, SQL Server 2005, Rapid SQL, Data stage 7.x, MicroStrategy, SQL, PL/SQL, Autosys, Toad, Web based Testing, Remedy, IBM AIX, MS Access, Unix

08/2001 - 07/2004
Confidential, Bangalore, India
Software Engineer/QA Analyst/Backend Tester

• 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 Informatica session logs to identify the errors occurred during the ETL execution.
• Used Oracle Collections, Cursors, Ref Cursor for developing PL/SQL subprograms (Packages, Procedures, and Functions)
• Extensively worked on debugging Packages, Procedures, Functions and Triggers.
• Used Quality center for test scripts repository and Clear Quest for defect tracking.
• Actively involved in Review meetings and walkthroughs.
• Done data validation for the Cognos reports.
• Prepared daily Status report after executing of scripts from the Quality center.
• Worked with data validation, constraints, record counts, and source to target, row counts, random sampling and error processing.
• Worked on Power Center client tools like Source Analyzer, Warehouse Designer, Mapping designer, Mapplet Designer and Transformations Developer
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Assisted in generating Post Deployment Scripts and UAT scripts.
• 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
• Testing has been done based on Change Requests and Defect Resolved.
• Effectively coordinated with the development team for resolving defects.

Environment: Informatica Power Center, Oracle 8i, SQL Server, SQL, PL/SQL, Cognos, Autosys, Toad, IBM AIX, Web based Testing, MS Access, Data Stage, Unix log files