SUMMARY

• Over 7 years of 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, Data Stage, AB Initio 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 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 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.
• Have experience working in Agile/Scrum Methodology.
• Excellent interpersonal, communication, documentation and presentation skills.

TECHNICAL SKILLS

QA Methodologies: Iterative, Agile, Waterfall and Spiral Methodology

QA Tools: HewlettPackard(HP) - QualityCenter,TestDirector IBM / Rational - Clear Quest

ETL Tools: Informatica Power Center 8.x/7.xData stage 8.x/7.x, Ab Initio 2.x, SSIS

BI/Reporting Tools: Cognos, 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: MSAccess,SQLServer2005/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

Confidential, Richmond, VA

ETL 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.
• Involved in testing Ab Initio graphs based on data mapping requirements.
• 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 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 Ab Initio graphs.
• 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.
• Have tested SSIS packages according to business requirements and data mapping requirement documents.
• Extensively used Quality Center to 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 Business Objects Reports for data quality, fonts, headers, footers, and cosmetics.
• Extensively involved in testing the ETL process of data sources 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.
• 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: Ab Initio 2.13, HP Quality Center, Business Objects, Rational Clear Case, Rational Clear Quest, Web Logic, Quick Test Professional (QTP), SQL Server 2005, SSIS, SSRS, Linux, Win XP

Confidential, Charlotte, NC

Sr. QA Analyst

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, GUI Testing, 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.
• Used Unix to run the graphs related to Abinitio
• 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).
• Used Data Stage Director to run/monitor the ETL jobs and tested the functionality according to data mapping requirements
• Worked on data validation, constraints, record counts, and source to target, row counts, random sampling and error processing.
• 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 ETLProcesses (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.
• Wrote complex SQL queries for extracting data from multiple tables and multiple database.
• Used Rational Clear Quest as defect tracking tool.
• Before the Load is accepted to test, have performed smoke or shake-out test.
• Extensively used Oracle database to test the Data Validity and Integrity for Data Updates, Deletes & Inserts.
• 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, Clear Case, IBM Cognos 8.0, Micro Strategy, Clear Quest, SQL, UNIX, Putty, TFS Defect tracking tool, Teradata V2R6, Session log files, Flat files, XML, XSD, XSLT, HP Quality Center, Web Services, SQL Server 2008

Confidential, Charlotte, NC

Sr. QA Analyst

Responsibilities:

• Analyzed the Business Requirements and Rules and worked with Business Analysts and Business Users in preparing Test Plans.
• Developed detailed Test Plan and Test Cases for the application manually through Quality Center.
• Gathered and analyzed data in support of business cases, proposed projects, and systems requirements.
• For every module followed the process of doing Analysis, Design, Produce, Unit testing and Integration testing.
• Involved in day to day SCRUM in an Agile environment meetings both on site and off shore teams providing the day to day updates on the testing schedules.
• Defects were tracked, reviewed, analyzed and compared using bug tracking tool Quality Center.
• Responsible in coordinating with the off shore QA team in developing the test cases, test plan and day to day test status for all the builds and releases.
• Executed automated scripts for smoke test on every build release using Quick Test Professional.
• Wrote SQL queries and validated data in the datawarehouse.
• Tested webMethods transactions with the outside vendor integration.
• Tested data flow to information factory via webMethods.
• Responsible in escalating the issues in the business templates, testing cycle to the business and development team on individual state for all the taxation functionality.
• Used to arrange meetings to discuss issues with developers and project managers.
• Worked very closely with developers to recreate defects found and also to verify fixes.
• Initiated and participated in Conference Calls, Walkthroughs and Reviews
• Meetings and involved in supporting Production Releases.
• Involved in Testing SSIS Packages, and also involved in Data Migration.

Environment: Quick Test Pro (QTP) 9.5, webMethods, Quality Center 9.5, Oracle, DB2, SQL, Microsoft Visual Studio Team Explorer, MS Office, Siebel, SOA, Java. J2ee.

Confidential

QA Engineer

Responsibilities:

• Analyzed the use cases and categorized the requirements of banking activities / modules
• Reviewed business requirements document and finalized the scope of testing.
• Prioritized requirements by interacting with business analyst so that those specific functionalities can be tested initially.
• Met with banking domain experts / subject matter experts and business analyst and identified the high-level requirement work flow on various LOB’s
• Performed data warehouse validation of source to target transformations using SQL queries
• Validated inbound and outbound files based on requirements and transformation algorithms.
• Created test requirements, test plans and test cases in Test Director.
• Performed integration testing and smoke testing.
• Created user defined functions for common tasks to reuse them in different tests and also for testing different builds of the application with same tests with out much modification.
• Performed unit testing, regression testing and system testing on the application.
• Validated business requirements to identify requirements specification problems like ambiguous requirements, missing requirement and inconsistent requirements.

Environment: Java, Java Script, VB 6, HTML, Oracle, SQL Server 2000, Windows 2000/2005, Win Runner, Quick Test Pro, Test Director.