SUMMARY

• In my current project I am playing teh role of ETL QA tester in CDW (Card & Bank Data warehouse) program. My tasks include data set - up, draft test cases based on business and system requirements and System test execution, System Integration Test (SIT) execution and supporting UAT. Extensively using Teradata, DB2 and Informatica power center for data set-up, Informatica and UNIX box for Data Analysis and running batch jobs. Teh test cases and results are documented in Quality Center and in Knowledge link.
• Quality Assurance Analyst wif 8 years of experience in Software Testing in teh areas of Client/Server, Web applications and Data warehousing under Windows and UNIX environments.
• Experience in various Informatica techniques and implemented Informatica Mappings using data Multi File System (MFS) techniques.
• Expertise in Software Development Life Cycle process (SDLC) and Quality Assurance Life Cycle (QALC) including Business Analysis, System Design and Testing.
• Experience wif QA Methodology and QA Validations to ensure teh Quality Assurance Control.
• Proficient in Gathering Data, Test Cases, Execution, Bug Tracking and Reporting Systems.
• Worked extensively in Data Warehousing, Auto Finance and Commercial Loans applications. Good noledge of work process wif customer data.
• Expertise in querying and testing RDBMS such as Oracle, DB2, MS SQL Sever for data integrity. Experience wif backend database and data migration testing.
• Experience in Quality Assurance & Testing Phases including Unit Testing, Integration Testing, Stress Testing, System Testing, User Acceptance Testing(UAT), End to End Testing, Smoking Testing and Regression Testing.
• Good understanding in Data Warehousing and ETL testing concepts.
• Specialized in Testing Database of Data warehousing Applications in Oracle, Teradata, MS SQL Server.
• Hands on testing experience in .NET, J2EE, and Web Services on Windows & UNIX operating systems
• Experience wif Mercury Test Management tools (Quality Center) and Clear Quest Defect tracking tool.
• Tracked and maintained application test defects, impact assessments, and assisted operations team.
• Excellent logical skills for understanding and developing system workflows, computing and verifying Software Metrics and well suited for communicating wif both technical and non-technical professionals.
• Worked in both Agile Environment and Water Fall methodology.
• Strong Project Orientation wif excellent Team Involvement, Client Coordination and good Written and Verbal Communication skills.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, TSL and COBOL, Java

Databases: Oracle, Teradata, DB2, MS-SQL and MS-Access

Database Access Tools: TOAD, Teradata SQL Assistant, SQL Loader

GUIs: Developer 2000, VB, HTML and DHTML,Visual Basic

Operating Systems: Windows98/NT/2000/XP, Unix, Linux & Solaris.

Testing Tools: Win Runner, Test Director, Load Runner, Quality Centre, Quick Test Pro, Rational Robot, Rational Clear Quest and Rational Requisite Pro, Tempest

Programming: ASP, VB, JAVA, HTML and DHTML

Business Tools: MSWord, MS Excel, MS Power point & MS Project

Data Warehouse tool: AbInitio, Informatica, Data Stage, Objects XIR2

Application/Web Servers: IIS, Apache, Web sphere, Web logic

Networking protocols: TCP/IP, SMTP, PPP, SNMP, DHCP, HTTP

Defect Tracking Tools: Rational Clear Quest, Mercury Test Director, PVCS Tracker, Mercury Quality Center.

PROFESSIONAL EXPERIENCE

Confidential Houston, TX

ETL BI QA Tester

Responsibilities:

• Involved in analyzing business and technical requirements and developing strategic test plans, test cases and test scripts and responsible for executing teh test cases, test scripts by using Mercury Tools.
• Co-ordination wif upstream and downstream systems and identifying teh business scenarios.
• Worked in an agile environment which brings key performers working together in one location - dedicated to one project until its completion.
• Involved in conducting defect review meeting wif testers and managers.
• Provide inputs into Business Assurance Strategy, Risk identification and mitigation strategy based on teh business requirements and technical implementation
• Developed Test Plans and Test Cases for System, Integration and Regression Testing from Business Requirements, System Requirements, Technical Design Documents.
• Extensively used Quality Center 10.0 for documenting Test Cases and updating teh Test Results after test cases execution TEMPhas been completed.
• Exclusively worked on Informatica Mappings testing and developed small graphs to copy data and join multiple source tables for testing purpose.
• Worked wif Multi-file system and successfully created test data for our process.
• Extensively used Teradata SQL Assistant 12.0 to verify and validate data in target Teradata databases.
• Involved in setup Test data in source tables using Informatica Mappings.
• Executed UNIX Shell scripts to validate application functionality.
• Worked closely wif (TDM) Test Data Management team for data scrubbing. Used to send work order requests to Test Data Management team when sensitive data exists in source tables.
• Involved in meetings wif upper management and used to update Testing progress and used to discuss about issues wif them.
• Involved in conducting Test Case review meetings and KT (Knowledge Transfer) sessions to new Testers.
• Always used to interact wif Developers to escalate testing issues and to take their valuable inputs for successful completion of Testing.
• Responsibilities include meeting wif teh developers and client groups to determine performance requirements and goals and to determine test strategies dat is based on requirements.
• Extensively involved in Interface System testing, Integration, Functional, Regression, Data Integrity, System, Compatibility, End to End Testing and User Acceptance testing
• Used Teradata SQL Assistant to query teh data in teh target Teradata data warehouse using SQL Assistant.
• Created issue list for each day while performing testing to keep track teh status and issues.
• Reported teh defects by entering in Quality Center defect tracking tool.

Environment: Windows XP Professional, Putty, UNIX, Informatica 8.1, Oracle 10g, HPQuality Center 10.0, Teradata SQL Assistant 12.0, MS Visio and MS Project 2003,QTP, Control - M.

Confidential, MA

ETL Tester

Responsibilities:

• Extensively involved in Interface System testing, Integration, Functional, Regression, Data Integrity, System, Compatibility, Installation, End to End Testing and User Acceptance testing
• Review design changes, Identify test scenarios, create test plan and test cases.
• Involved in scrum (standup) and used to update status of teh tasks.
• Involved in project planning meetings and used to provide estimation of teh testing tasks.
• Identifying/create test data dat covers identified test scenarios.
• Involved in developing Ab Initio graphs for testing purpose.
• Having experience in testing and validating Informatica Mappings.
• Having good noledge and experience in various Informatica transformations.
• Executed Informatica mappings in test environment and validated business functionality.
• Validated data in back end tables which is loaded through Informatica Mappings.
• Coordinated wif business and development teams to resolve issues during test execution.
• Execution of UNIX, Autosys Batch jobs, retrieval of logs, identification for teh source of errors.
• Maintained teh test environments (e.g. data loads, database backups, requesting deployments, troubleshooting issues).
• Responsibilities include meeting wif teh developers and client groups to determine performance requirements and goals and to determine test strategies dat is based on requirements.
• Used Teradata SQL Assistant to query teh data in teh target Teradata data warehouse using SQL Assistant. Expertise in SQL queries.
• Created issue list for each day while performing testing to keep track teh status and issues.
• Reported teh defects by entering in Quality Center defect tracking tool.

Environment: Windows XP, Informatica 7.1.2, QTP, Manual Testing, Oracle 10g, DB2,Toad, Putty, UNIX, HPQuality Center 9.0, Clear Quest 6.1, SQL, PL/ SQL.

Confidential, Portsmouth, NH

ETL Tester

Responsibilities:

• Involved in validating teh data dat TEMPhas been populated into Data warehouse Fact and dimensional tables using Ab Initio Data Warehouse tool.
• Involved in writing Test cases as per teh users requirement document.
• Involved in testing teh Ab Initio graphs parameters as per teh data movement practice standards using Ab Initio tool.
• Translate business-reporting requirements into data warehouse architectural designs and analyzing source and target data models and makes necessary changes.
• Extensively used SQL Assistant to validate teh records dat TEMPhas been populated by ETL process.
• Performed Regression Test after each and every code drop.
• Involved in Database Testing, comparing record count from source to destination
• Used Tivoli to schedule teh Ab Initio deployed scripts and Unix Wrapper Scripts.
• Conducted teh Regression tests after each and every bug fix.
• Defects were tracked, reviewed, analyzed and compared using Test Director.
• Updated management about teh QA test progress on weekly basis wif status reports and attended project meetings.
• Participated in weekly status meeting, Coordinated wif teh developers and testers to resolve teh defects and close them.
• Actively participated in all phases of testing life cycle including document reviews, inspections, and project status meetings.

Environment: Windows XP, Manual Testing, Ab Initio GDE 1.12, Co-Op 2.12, UNIX, QTP, SQL Assistant, ERWIN, Test Director.

Confidential, Buffalo, NY

QA Analyst

Responsibilities:

• Actively participated in both manual and automated testing procedures.
• Involved in preparing teh Test scenario’s, Test cases for complete application Testing.
• Created Test Cases based on Use Case Requirements and teh Page Specification documentation.
• Involved in all teh quality assurance phases of Software Testing Life Cycle (STLC).
• Verifying teh Website so dat teh XSL, XML, HTML content on Web pages are not giving script errors on user input or data input or traversal through teh different web pages and User actions.
• Involved in integration testing, system testing, user acceptance testing and regression testing of teh application for quality of teh software.
• Involved in tracking, reviewing & analyzing bugs using a Defect Tracking system.
• Analyzed functional specifications and provided structured to all phases of testing by setting test priorities.
• Defined test procedures dat incorporate multiple tests of teh entire system.
• Conducted Smoke, Security and Functional testing of teh application.
• Interacted wif developers and other QA engineers to address quality problem (s).
• Used Test Director for writing test cases, test scripts and for reporting teh bugs.
• Involved in Black Box Testing of teh GUI application.
• Identified software errors and interacted wif developers to resolve technical issues.
• Prepared pre-conditioned data for testing teh application.
• Automated teh functionality using Quick Test Pro.
• Developed scripts, used various check points and developed reusable functions using Quick Test
• Responsible for testing teh application for Time Based Tests on various features.
• Prepared test data based on exact definition of defect (for positive testing) and exact opposite definition of defect (for negative testing) tested teh application on different operating systems wif different versions of all teh browsers like Netscape Navigator, Internet Explorer, Fire fox Mozilla and AOL .
• Created documentation and participated in Bugs Triage meetings, Team meetings and Defect report meetings.

Environment: Windows 2000, Test Director, Quick test Pro, VB.NET, ASP.NET, XSL, XML, Oracle, MS- Access, MS-SQL Server, IIS, Windows XP.

Confidential, Tampa, FL

Test Engineer

Responsibilities:

• Participated in preparing Test plan, Time estimations and Test strategy.
• Analyzing Business requirement documents like conceptual view, Requirement specifications, User interface specifications, and data structures.
• Writing requirements of application under test.
• Writing test cases and linking teh requirement coverage to test cases.
• Reviewing Test cases wif Developers / Business Analysts and modifying teh test cases as per teh suggestions made by Business people.
• Reviewing Test cases written by Co-testers.
• Executing Batch jobs and validating them.
• Collecting test data and configuring teh system to perform various kinds of testing.
• Executing functional test cases as well as System test cases.
• Writing SQL queries and executing them to compare teh results retrieved through online screens.
• Participated in various kinds of tests like regression, integration and incremental integration testing.
• Login teh defects into teh Test Director and tracking them and communicating wif teh concerned development team.
• Generated reports relating to Requirements coverage.
• Participating in Defect meeting and explaining teh status to Project team.
• Giving training on TD to Developers and Business people for tracking teh defects and entering requirements.

Environment: Windows 2000, Manual Testing, Win Runner, Test Director, MS-Excel, SQL Query Analyzer, Oracle, Java, JSP, Struts, Web Logic (Portal Server/Integration Server) platform 8.1/7.x and Oracle 9.0.

Confidential, Atlanta, GA

QA Analyst

Responsibilities:

• Responsible for developing Test plan, Test cases, Performing Regression Testing, Integration testing, System testing, Acceptance testing, Stress testing for online banking application.
• Collaborated wif Data warehouse team to create test scripts for validating data loaded by extract processes and data presented through BI tools.
• Validated Data at each Transformation throughout teh ETL process.
• Actively participated in reviewing test cases written by junior testers.
• Maintained and executed test scripts by using Test Director and analyzed teh results.
• Implemented automated testing of teh GUI application using Win Runner.
• Coordinate all teh database changes to teh development and test databases and implement SQL scripts as necessary.
• Monitor, Maintain and test teh database for quality and reliability during development and testing phase.
• Preparing Defect Reports and Interacted wif Developer for Debugging.
• Participate in team as well as department meeting and provide continuous input to improve quality product standards.
• Coordinated application performance test project. Created performance test plan, test scripts and test conditions.
• Deal wif performance, usability and productivity issues.

Environment: Manual Testing, ETL Informatica Power Center 6.5,Test Director, Win Runner, Oracle 8i, SQL, PL-SQL, Procedures, Triggers, Java 2.0, HTML, MS-Word, MS-Excel and MS-Project .

Confidential, Warren, MI

QA Analyst

Responsibilities:

• Responsible for creation and execution of Test Scripts based on functional specifications.
• Involved in Review and verification of Test Scripts for Unit, Integration and Regression testing wif teh Technical Team.
• Involved all teh database changes to teh development and test databases and implement SQL scripts as necessary.
• Tested different data warehouse transformations, created by using informatica.
• Validated Data at each Transformation.
• Validated Data at each stage using SQL queries (ODS, Staging & Data warehouse/Data Mart).
• Executed test scripts manually.
• Participated in automating teh User interfaces using Win runner.
• Involved in End-to-End and User Acceptance Testing.
• Generated teh detailed reports of teh Bugs, Pass-Fail results, Comparison Chart and Defect Tracking and Defect Aging in Test Director.
• Participated in Code reviews.
• Actively involved in Regression testing for version releases and for customizing teh software.
• Worked on teh application Helpdesk/Support for queries or problems reported by teh users.

Environment: Windows 2000, Manual Testing, Informatica 6.5, Win Runner, Test Director, MS Excel 2000, SQL-Server 2000, T-SQL, Java, XML, IBM Web Sphere Application Server 3.5,.

Confidential

QA Tester

Responsibilities:

• Involved in Test Planning and Test Cases creation and execution.
• Logged in defects and tracking teh until they are closed.
• Actively participated in Integration as well as regression testing.
• Conducted Black box testing.
• Tested to verify teh integration of different modules of teh system.
• Defects were tracked and reported to teh Technical Team for root-cause analysis and resolution using Test Director.
• Actively involved in teh review and analysis of specifications and enhancements.

Environment: Windows 2000, Test Director, MS Excel 95, ASP 1.0, Java 2, HTML, MS-Access 1.1, Oracle 7.3, PL/SQL 2.3, IIS server,.