SUMMARY

• Over 7 years of experience in IT as Quality Assurance Analyst. Proficient in Manual/Automation Testing of Client/Server and Web based applications using Mercury Interactive Test Suite - Test Director, Win Runner, Quick Test Pro and Load Runner.
• Domain competency includes finance, Mortgage and Insurance sectors.
• Expertise in writing Test Plans, Test Strategies, Test Cases, Test Scripts, Test Scenarios, Test Reports and Defect Metrics.
• Involved in various stages of Software Development Life Cycle (SDLC) implementing Waterfall, V-Model and Agile methodologies.
• Strong understanding of QA Principles, QA Process, Use Cases, and Software Development Life Cycle.
• Used Test Director for test documentation management and defect tracking.
• Extensive experience in developing Test Procedures and Test Strategy for Web and Client/Server applications.
• Sound noledge of Black Box, White Box, System, Regression, Integration, Functionality and User Acceptance Testing.
• Experience in testing on enterprise wide applications wif multiple databases.
• Proven experience wif teh development, and implementation of large-scale, enterprise data warehouse and reporting solutions.
• Extensive experience in Test Director 7.2, Clear Quest, Clearcase and Remedy.
• Good Knowledge of Workflow Manager and Workflow Monitor in Informatica 8.6.1/7.1.2.
• Experience in Business Intelligence in generating various reports using business Intelligence tool Business Objects XI R2/XI/6.5.
• Interacted wif teh developers on various technical issues and resolved teh reported bugs.
• Excellent understanding of teh Software Development Life Cycle and role of QA.
• Extensive experience performing ETL/Data warehouse and database testing.
• Worked wif all stages of testing namely Integration Testing, System Testing and User Acceptance testing manually as well as using automated test tools.
• Back-end testing using SQL, PL-SQL, Unix.
• Well versed in testing Methodologies, Web testing, and software Deployment/Release processes.
• Very Strong skills, including teh use of nested table expressions, unions, Multi-table joins and outer joins.
• Supported teh defect resolution process by prioritizing teh severity level of defects.
• Self Motivated, Team Oriented wif ability to handle multiple tasks and efficient in meeting deadlines.
• Participation in design reviews wif teh Development team.
• Possess excellent communication skills along wif verbal and written skills.

TECHNICAL SKILLS

Operating Systems: Windows 2003/2000/XP, UX-HP, Solaris, MS DOS

Internet: ASP, HTML DHTML, XML, Web Services

Business Modeling Tools: Rational Rose, MS Visio

Languages: C#, C++, C, VB.Net, VBScript, JavaScript, VB 5/VB 6, SQL, PL SQL

Testing Tools: QTP8.x/9.2/9.5/10,Quality center, WinRunner 7.5/7.0/6.0, LoadRunner9.0/8.x, Test Director

Office Tools: MS Office, MS Project

Databases: MS SQL Server 2000, Oracle 8i/9i, TeradataV2R6/R5, DB2

ETL/ Reporting tools: Informatica, Datastage, Ab Initio, Crystal Reports

Configuration Management: MS Visual Source Safe, SOS, Clear Case, Share Point Portal, PVCS, Doors, Rational Test Manager

PROFESSIONAL EXPERIENCE

Confidential, Mc Lean, VA

Senior Data warehouse / ETL Tester

Responsibilities:

• Worked as a System Analyst and a Data warehouse/ ETL Tester.
• Worked wif teh business team to gather requirements.
• Created and executed test cases based on test plans.
• Developed SQL scripts and used Rapidsql query tool to run teh SQL scripts from Sybase and SQL Server databases.
• Tested load scripts that are developed and executed using Teradata client utilities MULTILOAD, FASTLOAD and BTEQ.
• Validated JCL scripts and debugged stored procedures in TERADATA SQL Assistant.
• Validated customized Mload scripts on UNIX platform for Teradata loads
• Validated several Teradata BTEQ scripts that implement teh business logic.
• Used Quality Center to execute teh test cases, track execution against teh plan during testing and manage defects from inception to resolution.
• Created Test cases scripts from teh functional specifications and maintained traceability wif teh requirements.
• Created SQL queries to fetch data and validate application against teh database
• Performed functional, performance, regression and black-box testing on teh payment and billing application.
• Creating teh test batch data file by FTP thru Unix.
• Created Test execution, Defect Metrics for daily status meetings
• Validated XML files for teh web services triggered by teh Java based application (OUS).
• Performed web service testing using SOAPUI, QTP as part of OUS functionality
• Tested reports developed using Business Objects and Crystal Reports
• Validated data between different web applications and documented teh test results.
• Communicate testing activities and findings in oral and written formats.
• Ran Sql queries to check if teh data is loaded correctly into teh database for teh backend testing.
• Responsible for maintaining RTM in DOORS.
• Trained end users on teh new application and conducted noledge transfer sessions on teh project.
• Attended daily status meetings for Data quality issues and technical review meetings.

Environment: Sybase, SQL Server, Teradata V2R6, Java, .Net, Informatica 8.6.1, BO XI 3.0,Embarcadero's Rapid SQL, XML, Lotus Notes 7.1.1, Clear case, Clear quest, UNIX, MS Excel 2007, MS word 2007, Windows XP, Unix, Quality Center 9.2, QTP 10/9.5, SOAPUI, IBM DOORS.

Confidential, New York

Senior Data warehouse / ETL Tester

Responsibilities:

• Working wif teh business team to gather requirements.
• Creating and executing test cases based on test plans.
• Performed report validation of teh securities system, which are generated, on Cognos8.0.
• Developing SQL scripts and used TOAD to run teh SQL scripts from Oracle and SQL server databases.
• Experience in testing using Teradata utilities like BTEQ and exposure to FastLoad, MultiLoad, FastExport, Tpump, SQL Assistant, SQL Administrator.
• Extensively tested data from flat files, Oracle, Teradata database.
• Worked extensively wif teh Teradata Queryman to interface wif teh Teradata.
• Performed Verification, Validation, and Transformations on teh Input data (Text files, XML files) before loading into target database.
• Monitored teh Informatica workflows using Power Center monitor. Checked session logs in case of aborted/failed sessions
• Perform Functional, Data Validation, Integration, regression and User Acceptance testing.
• Used TOAD, DB Artisan tools to connect to Oracle Database to validate data that was populated by ETL applications.
• Involved in backend testing for different environments like System Testing and User Acceptance Testing.
• Perform Functional testing, System testing, Smoke testing and Regression testing.
• Developed automation scripts and executed them as a part of teh regression testing using QTP.
• Followed teh keyword driven methodology for teh automation
• Documenting teh test results.
• Creating and modifying UNIX shell scripts.
• Created T-SQL queries to retrieve teh data teh SQL Server database.
• Tested internal and high-level business reports.
• Running Sql queries to check if teh data is loaded correctly into teh database and into teh reports subsequently.
• Checking teh job flows in Informatica.
• Used Quality Center for executing teh test cases and defects tracking.
• Scheduling Autosys jobs and running teh job flows.
• Attended weekly status meetings for reporting teh testing updates.
• Participating in review meetings on a periodic basis.

Environment: Quality Center 9.2, QTP 9.5, Oracle, SQL Server, Teradata V2R5, Toad, Informatica 8.1, XML, Java, Cognos8.0, MS Outlook, Autosys, MS Excel, MS word, Windows XP, Unix and DOORS.

Confidential, Mc Lean, VA

Senior Data warehouse / ETL Tester

Responsibilities:

• Worked as a Data warehouse / ETL Tester
• Worked wif teh business team to gather requirements.
• Used TOAD SQL browser to write SQL queries for validating constraints, indexes.
• Used TOAD schema browser to check teh characteristics of teh schema objects(tables, synonyms etc)
• Performed Positive testing, Negative testing, Functional testing, Navigational testing, System Testing and Regression Testing in different phases
• Extensively used Informatica Debugger for testing teh mapping logic during Unit Testing. Performed unit testing, integrated testing and validated results wif Business Analyst and/or customer.
• Extensively worked on understanding teh business requirements and designing Cognos applications
• Involved in FTP process to transfer teh files from one server to other.
• Performed quality control analysis and validates results of conversion programs. Used extensive SQL query. Evaluated actual data load results. Involved wif high volume testing.
• Developed SQL scripts and used Rapidsql query tool to run teh SQL scripts from Sybase and DB2 databases.
• Performed Functional testing, System testing, Smoke testing, Regression testing and UAT.
• Documented teh test results.
• Created and modified UNIX shell scripts
• Communicate testing activities and findings in oral and written formats.
• Ran Sql queries to check if teh data is loaded correctly into teh database.
• Responsible for maintaining RTM in DOORS.
• Used Quality Center for executing teh test cases and defects tracking.
• Enhanced teh existing automation scripts in QTP and maintained teh object repository to ensure teh sync wif teh application version
• Created teh Naming conventions document and documented management plan.
• Attended daily status meetings for Data quality issues and technical review meetings.

Environment: Quality Center 9.2, QTP 9.2, Sybase, DB2, Rapid SQL, Data stage, BO XI R2, XML, Lotus Notes 7.1.1, Clear case, Clear quest, UNIX, MS Excel, MS word, Windows XP, Unix and DOORS.

Confidential, IL

Data warehouse / ETL Tester

Responsibilities:

• Wrote Test Plans and Test Cases pertaining to data validation and integrity testing for data loading, data validation and integrity check testing.
• Wrote test cases and executed them on teh Billing System.
• Developed a detailed Test Plan for teh testing effort of teh User Interface
• Involved in requirement analysis
• Performed security testing manually and writing sql queries against teh database
• Maintained requirement traceability matrix.
• Extensively used Mercury Quality Center (TEST DIRECTOR) and Created Test Cases in teh TEST PLAN according to teh specifications.
• Used TEST LAB to run teh Test cases.
• Reported Defects and prioritized outstanding defects using Test Director/Quality Center.
• Ran teh Informatica ETL Sessions for Claims in different stages Source to Stage & Staging to Data mart and Data mart to Business Objects and BO to Dashboard using Informatica Server Manager
• Maintain Object repository
• Created TSL Scripts files as per teh test plan requirements.
• Tracked teh defects in Test Director.
• Validated data feed into teh data warehouse for DWH implementation and also tested front end application where massaged data was presented in report formats.
• Involved in Integration testing, UI, User Acceptance Test (UAT), Functionality testing & Performance testing.
• Performed database testing to verify teh rates as per teh large accounts
• Executed SQL Queries to verify teh dataflow from teh backend
• Involved in validating teh reports, both Data and their layouts
• Bug reporting, tracking and documentation on teh Bug tracking System using Test Director
• Weekly Status meeting wif Development and Management teams to discuss bugs and other issues.

Environment: Test Director 7.2, QTP 8.2, Flat files, Ab Initio, SQL Loader, Oracle 8i/9i, TOAD, UNIX, Windows

Confidential, VA 

QA/BA Analyst

Responsibilities:

• Identifying business requirements, process improvements and new processes in a timely manner.
• Designed, debugging & testing Informatica mappings for loading data to data warehouse.
• Involved in writing teh test cases and Test plans based on Informatica mappings and Data Analyst mappings, BA Visio diagrams
• Ran teh Informatica ETL Sessions for Claims in different stages Source to Stage & Staging to Data mart and Data mart to Business Objects and BO to Dashboard using Informatica Server Manager
• Checked teh existing functionality of teh application manually.
• Logged defects in TD and worked wif teh development team towards bug resolution.
• Developed Test Matrices for consolidating teh data required for Positive and Negative testing.
• Tested teh application manually (Black box testing) during teh development phase.
• Performed Integration and Regression testing to check compatibility of new functionality wif teh existing
• Tested performance web applications using Client /Server architecture.
• Managed defect tracking, defect reporting for assigned projects using Test Director.
• Worked wif development teams to investigate, prioritize and resolve software bugs / defects based on teh testing results.
• Participated in review meetings and took teh initiative to meet teh QA testing targets.
• Participated in daily status meetings to report any bugs, issues and risks.
• Run teh SQL queries to fetch test data and backend (database) testing to validate teh database.
• Worked wif teh QA / Development team for improving teh testing methodology.
• Communicating wif team members and managers by participating in bug review meetings

Environment: Informatica 7.1.2, .Net, XML, QTP, VBScript, UNIX, Test Director 7.2, IIS 5.0, SQL Server 2000 and Crystal Reports 8.0, Ms Visio.