SUMMARY

• Around 8 years of experience in Software Quality Assurance (QA) and tested Data Warehouse, Database (ETL & BI), Web, and Client - Server Systems and Applications for Health, Financial, 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
• Tested webservices, XML, WSDL using SOAPUI tool. Modified end points when we worked on different servers and different versions of Web Services.
• Tested WebServices, providing required input data to request XML and validated response XML, and extensively worked on Parasoft Service Virtualization.
• 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.
• 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.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica.
• Good working experience on Informatica Workflow Manager to run teh workflows and monitored teh status and logs in Workflow Monitor.
• 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 teh same for test execution and reporting.
• Expert in writing Complex SQL quires for backend testing and created several queries on teh fly for user specific requirements for trouble shooting day-to-day production issues to identify root cause.
• Tested migration of applications from Development to Production environments.
• Performed well under stress, working with multiple applications testing concurrently, coordinating QA activities with various teams and supported project management teams in release activities.
• Experienced in coordinating testing effort between Onshore and Offshore teams.
• Training and mentoring of junior team members.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x/8.x/7.x, Data Stage.

QA Tools: HP - Quality Center, 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/2000 , DB2, Teradata V2R6/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: Microsoft Windows - Vista, XP, 98, 2000, NT 4.0, UNIX - Sun Solaris, HP-UX

App/Web servers: HTML, XML, WebLogic Server, WebSphere, SoapUI, WebServices, Parasoft SOA Test

Scheduling Tools: Autosys, Control M, Flux

Other Tools: TextPad, CompareIT, PuTTY, WinScp, SnagIT

PROFESSIONAL EXPERIENCE

Confidential, Durham, NC

Sr. ETL QA Analyst DWH Tester/ Reports Tester

Responsibilities:

• Analyzed teh Requirements from teh client and 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 teh service’s requirements, functional, and technical design Included SDLC and Data Warehouse System Development Life Cycle documentation.
• Responsible in providing Test Execution and Defect Test reports to teh management
• Worked with ETL team for understating for data loading for both dimensions and facts.
• Analyzed business process workflows and assisted in teh development of ETL procedures for moving data from source to target systems.
• Found teh defects when running teh test cases and assign to ETL Developers using Defect Tracking tool.
• Written several complex SQL queries for data verification and data quality checks.
• Running Traceability Matrix (RTM) and identifying teh Requirement gaps.
• Extensively used Informatica Workflow Manager to run teh workflows.
• Validated SSRS reports according to report specifications.
• Monitored teh session logs/log files in Informatica Workflow Monitor.
• Extensively used Informatica Workflow Manager to run teh workflows/mappings and monitored teh session logs in Informatica Workflow Monitor.
• Tested teh ETL Informatica mappings and other ETL Processes (DWH Testing).
• Tested Cognos Reports according to teh business requirements.
• Exclusively used Analysis Studio and Report Studio to test teh Cognos Reports.
• Tested several complex reports generated by Cognos including Dashboards, Summary Reports, Tabular, Master Detailed, Drill down reports.
• Validated teh Web Services by passing different requests through Soap UI.
• Test Case Execution for all critical and most frequently used functionalities.
• Create Test Cases based on teh data mapping requirements.
• Involved in testing teh new functionalities based on Test cases and coordinated with development teams in fixing teh issues.
• Create Test Reports and submit teh analysis to Test Leads and Project Managers.
• Participate in UAT Testing, represent test teams while release implementation.
• Involved in daily agile scrum meetings, demos, monthly story reviews, release retrospectives, provided estimates for stories and tasks.

Environment: HP Quality Center 10.0, Oracle 11g, TOAD, UNIX, Informatica Power Center 9.1, Web Services, Soap UI, SQL, PL/SQL, SQL Server 2008, SSRS, XML, Rational Clear Quest, Clear Case.

Confidential, Richardson, TX

UAT Tester/SOA Tester

Responsibilities:

• Analyzed teh Business Requirements and Rules and worked with Business Analysts and Business Users in preparing Test Plan.
• Gone through teh Functional Specifications and implemented their technical aspect in System Integration Testing (SIT).
• Developed Test cases, Test scripts from teh data mapping documents, functional Specification documents.
• Used HP Quality Center as a test management tool as well as teh Defect tracking tool.
• Tested Business Objects Reports according to teh business requirements.
• Prioritized teh test cases based on teh projected metrics and project deadlines.
• Worked with Developers on Defects until teh test case is passed.
• Extensively written SQL to validate teh data in TOAD.
• Understand theSOArequirements based on teh solution specifications and design specifications and write test cases to meet teh business needs.
• End to End testing of messaging based systems and ESB's like TIBCO EMS or JMS messaging
• Work with XMLs, WSDLs, Web Services and Client/Server messaging as required
• Worked with WSDL, XML, and/or SOAP messaging, Parasoft Service Virtualization.
• Extensively worked with XSD and XPath syntax.
• Use of SOAP UI and GEMS to test teh message flow between teh services and teh queues.
• Validate teh response from teh web services by using different assertions in SOAPUI
• Validate teh messages in teh Queues and Topic by using GEMS
• Use of SOAP UI and GEMS to test teh message flow between teh services and teh queues.

Environment: Oracle 11g,SOAP UI,TOAD,SQL,HTML, XML, TIBCO EMS, GEMS, JIRA,HP ALM.

Confidential, Phoenix, AZ

SOA Tester/WebServices Tester

Responsibilities:

• Obtained and understood teh SOA requirements based on teh integration design documents and service specifications and understood SOAreference Architecture.
• Experience in SOA implementation using Lisa, Parasoft SOA Test and SOAPUI.
• Experienced in SOA Technologies, Web Services, REST, BPEL, Message Queues, Message Oriented Middlewares Testing.
• Performed functional testing of teh RESTful web services using SOAPUI and Fiddler as teh testing tools.
• Validated teh JSON (Java Script Object Notion) returned in teh response based on teh BSD and test plan.
• End to end functional testing of teh Enterprise Content Management (ECM) using teh web service.
• Validation of teh outbound document using HP Exstream and RESTful web services.
• Validated web services response against teh excel data sheet .
• Involved in API Testing, Server Side Testing, and Global Verification Testing.
• Tested data migration to ensure that integrity of data was not compromised.
• Wrote complex SQL queries for extracting data from multiple tables and multiple databases.
• Experience in doing POC’s for service virtualization on Webservices, REST, API and MQ.

Environment: Oracle 10g, SQL Server 2005, SQL, HP Quality Center, TOAD,SOAPUI,SOA Testing, soapUI 1.7, 2.0 beta, WSDL,XML,Xpath.

Confidential, Chicago, IL

ETL DWH QA Engineer/Web Tester

Responsibilities:

• Worked with product/Business management to prepare test plans, test scenarios, test cases and scripts from teh BRDs and mapping requirements.
• Performed smoke testing, functional testing, regression testing, performance testing, load testing of application within teh specified timelines to meet teh monthly release deadlines.
• Involved in creating teh UAT test scenarios and worked with teh business users to execute teh UAT test scenarios.
• Used TFS as test management tool.
• Tested Micro strategy Reports according to teh business requirements.
• Tested several complex reports generated by Micro strategy Dashboards, Summary Reports, Master Detailed,Drill down.
• Prioritized teh test cases based on teh projected metrics and project deadlines.
• Analyzed and tested Informatica Mappings with OLTP source data, staging and target data.
• Written several complex SQL queries to cover all edge case scenarios.
• Tested web applications for verifying teh data quality and User presentation.
• Tested teh browser compatibility of web applications on different browsers such as Google Chrome, Internet Explorer, Safari and Mozilla Firefox.
• Extensively written SQL to confirm teh data transfer from source to target.
• Found teh Defects when running teh test cases and assign to ETL Developers using Defect Tracking tool like Clear Quest.
• Worked in Micro strategy upgradation from version 8 to 9 and making sure that teh reports are working fine on Micro strategy 9.0
• Involved in performance testing of various ETL mappings.
• Extensively used Informatica Workflow Manager to run teh workflows.
• Monitored teh session logs/log files in Informatica Workflow Monitor.
• Involved in testing teh web pages, UI screens, and reports which are was used by teh business users, client member users.
• Involve in teh defects tracking meeting for teh system integration testing and communicated teh issues and escalations with teh project manager.
• Conducted weekly Demo sessions to gather early feedback from teh product management.
• Prepared Test Scenarios by creating Mock data based on teh 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, Oracle 10g, SQL Server 2010, Linux, UNIX, Putty, Flat files, Session Logs, Autosys, SQL scripts.

Confidential, Cypress, CA

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 teh various dimensions and facts to test teh application.
• Planned ahead of time to test teh mapping parameters and variables by discussing with BA’s.
• Extensively used Rational Clear Quest 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 teh Interactive Reporting.
• Extensively tested several Cognos Reports for data quality, fonts, headers, footers, and cosmetics.
• Extensively involved in testing teh ETL process of data sources, SAP, PeopleSoft, Teradata, SQL Server, Oracle, flat files into teh target Teradata, Oracle database as per teh data models.
• Analyzed teh testing progress by conducting walk through meetings with internal quality assurance groups and with development groups.
• Responsible for documenting teh process for future references.
• Responsible for in-depth noledge of data, processes or applications in their specific area of responsibilities
• Reviewing teh test activities through daily Agile Software development stand-up meetings.
• Experienced with Data Warehouse System Development Life Cycle

Environment: Cognos, Quality Center, Rational Clear Case, Rational Clear Quest, Ab Initio, Rational Requisitepro, Autosys, Toad, Perl, Putty, Web logic, Oracle 10g/9i, SQL Server 2005, PL/SQL, Linux, Win XP.

Confidential, Seattle, WA

QA Analyst/Manual Tester/Reports Tester

Responsibilities:

• Analyzed teh Business Requirements and Rules and worked with Business Analysts and Business Users in preparing Test Plans.
• Gone thru teh Functional Specifications and implemented their technical aspect in System and Integration testing (SIT).
• Developed Test cases, Test scripts from teh data mapping documents, functional Specification documents and mapped teh test cases with teh requirements for generating teh Requirement Traceability Matrix (RTM).
• Closely went through and worked on all teh stages of SDLC for this project and designed and executed Functional, Integration, Regression, System (End to End) and Backend (Database).
• Developed and executed test cases and test scripts.
• Performed Integration, Regression, Performance and Functional Testing.
• Worked with teh UNIX shell scripts.
• Used HP Quality Center as test management tool.
• Tested Cognos Reports according to teh business requirements.
• Exclusively used Analysis Studio and Query Studio to test teh Cognos Reports.
• Prioritized teh test cases based on teh projected metrics and project deadlines.
• Analyzed and tested DataStage jobs with OLTP source data, staging and target data.
• Extensively written SQL to confirm teh data transfer from source to target.
• Found teh Defects when running teh test cases and assign to ETL Developers using Defect Tracking tool like Clear Quest.
• Tested data and cosmetics of Micro Strategy reports.
• Tested teh PL/SQL procedures, functions, packages according to teh requirements.
• Performed Backend database testing, by executing teh Group functions, complex Joins and sub queries.
• Verified test results (viewing teh log files using VI editor, querying teh database using teh SQL) documenting teh defects.
• Involved in testing teh UI screens, reports which was used by teh internal business team.
• Responsible for Data integrity and Data validation testing.
• Involved in testing teh functionality of Data Stage jobs.
• Executed ETL jobs through Data Stage director and monitored status.
• TEMPEffectively coordinated with teh development team for closing a defect.
• Prepared Test Scenarios by creating Mock data based on teh different test cases.
• Attended Bi-Weekly Defect Review and Defect Status meetings. Provided updates to Team Lead on testing activities.

Environment: Data Stage 8.0, SQL, HP Quality Center, Cognos 8.0, Micro Strategy Clear Case, Clear Quest, RequisitePro, TOAD, Oracle 10g, SQL Server 2008, SSIS, SSRS, DB2, PL/SQL, UNIX, PuTTY, Flat files, Session Logs, Windows XP.