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 wif 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 the workflows and monitored the 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 the same for test execution and reporting.
• Expert in writing Complex SQL quires for backend testing and created several queries on the 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 wif multiple applications testing concurrently, coordinating QA activities wif 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 the Requirements from the client and developed formal Test cases based on functional requirements, general requirements and system specifications.
• Worked wif developers to gather information for a set of Development Plan templates documenting the 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 the management
• Worked wif ETL team for understating for data loading for both dimensions and facts.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Found the defects when running the 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 the Requirement gaps.
• Extensively used Informatica Workflow Manager to run the workflows.
• Validated SSRS reports according to report specifications.
• Monitored the session logs/log files in Informatica Workflow Monitor.
• Extensively used Informatica Workflow Manager to run the workflows/mappings and monitored the session logs in Informatica Workflow Monitor.
• Tested the ETL Informatica mappings and other ETL Processes (DWH Testing).
• 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, Tabular, Master Detailed, Drill down reports.
• Validated the 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 the data mapping requirements.
• Involved in testing the new functionalities based on Test cases and coordinated wif development teams in fixing the issues.
• Create Test Reports and submit the 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 the Business Requirements and Rules and worked wif Business Analysts and Business Users in preparing Test Plan.
• Gone through the Functional Specifications and implemented their technical aspect in System Integration Testing (SIT).
• Developed Test cases, Test scripts from the data mapping documents, functional Specification documents.
• Used HP Quality Center as a test management tool as well as the Defect tracking tool.
• Tested Business Objects Reports according to the business requirements.
• Prioritized the test cases based on the projected metrics and project deadlines.
• Worked wif Developers on Defects until the test case is passed.
• Extensively written SQL to validate the data in TOAD.
• Understand theSOArequirements based on the solution specifications and design specifications and write test cases to meet the business needs.
• End to End testing of messaging based systems and ESB's like TIBCO EMS or JMS messaging
• Work wif XMLs, WSDLs, Web Services and Client/Server messaging as required
• Worked wif WSDL, XML, and/or SOAP messaging, Parasoft Service Virtualization.
• Extensively worked wif XSD and XPath syntax.
• Use of SOAP UI and GEMS to test the message flow between the services and the queues.
• Validate the response from the web services by using different assertions in SOAPUI
• Validate the messages in the Queues and Topic by using GEMS
• Use of SOAP UI and GEMS to test the message flow between the services and the 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 the SOA requirements based on the 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 the RESTful web services using SOAPUI and Fiddler as the testing tools.
• Validated the JSON (Java Script Object Notion) returned in the response based on the BSD and test plan.
• End to end functional testing of the Enterprise Content Management (ECM) using the web service.
• Validation of the outbound document using HP Exstream and RESTful web services.
• Validated web services response against the 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 wif 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 wifin the specified timelines to meet the monthly release deadlines.
• Involved in creating the UAT test scenarios and worked wif 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 wif OLTP source data, staging and target data.
• 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 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.
• Worked in Micro strategy upgradation from version 8 to 9 and making sure that the reports are working fine on Micro strategy 9.0
• Involved in performance testing of various ETL mappings.
• 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 wif the project manager.
• 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, 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 wif 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 wif 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 the Interactive Reporting.
• Extensively tested several Cognos Reports for data quality, fonts, headers, footers, and cosmetics.
• Extensively involved in testing the ETL process of data sources, SAP, PeopleSoft, Teradata, SQL Server, Oracle, flat files into the target Teradata, Oracle database as per the data models.
• Analyzed the testing progress by conducting walk through meetings wif internal quality assurance groups and wif development groups.
• Responsible for documenting the process for future references.
• Responsible for in-depth noledge of data, processes or applications in their specific area of responsibilities
• Reviewing the test activities through daily Agile Software development stand-up meetings.
• Experienced wif 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 the Business Requirements and Rules and worked wif 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 wif the requirements for generating the Requirement Traceability Matrix (RTM).
• Closely went through and worked on all the stages of SDLC for dis 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 wif 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 Query Studio to test the Cognos Reports.
• Prioritized the test cases based on the projected metrics and project deadlines.
• Analyzed and tested DataStage jobs wif OLTP source data, staging and target data.
• 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.
• Tested data and cosmetics of Micro Strategy reports.
• 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.
• Verified test results (viewing the log files using VI editor, querying the database using the SQL) documenting the defects.
• Involved in testing the UI screens, reports which was used by the internal business team.
• Responsible for Data integrity and Data validation testing.
• Involved in testing the functionality of Data Stage jobs.
• Executed ETL jobs through Data Stage director and monitored status.
• Effectively coordinated wif 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: 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.