SUMMARY

• 5+ Years of experience wif SoftwareQuality Assurance, UI, Manual, UAT and Automationtesting of Web, Client/Server, ERP and Data warehousingApplications wif business noledge and working experience inBanking & Finance Domain.
• Comprehensive noledge of functional testing, web technology, and agile software development
• Extensive noledge of software development process and methodologies
• In - depth noledge of software testing processes and test case design methodologies
• Well versed in test case automation, bug tracking software, and database testing
• Expertise in manual testing for both Web applications and Client-Server application
• Extensive experience in Manual testing using WinSQL
• Expert level skills in testing Enterprise Data Warehouse (EDW) using Informatica Power Center ETL tool
• Expertise in Querying tool like TOAD and WinSQL for querying Oracle 11g/10g/9i and IBM DB2 9.8/10.1
• Automated and scheduled multiple ETL jobs using UNIX Shell Scripting.
• Working experience wif Test management tools - HP Quality Center 9.2, Test Director, QTP 10.0/9.2, Load Runner and Rational Suite.
• Expertise in designing and developing Test strategy, test plans, Test Cases and Test Scripts.
• Extensive experience in writing SQL scripts to validate teh database systems and for backend database testing.
• Experience in developing, trouble shooting and customizing Manual
• Requirement Coverage Analysis andRequirements Traceability Matrix (RTM) for teh projects.
• Strong noledge of Quality Management and CMMI-related concepts.
• Experience in using Bug tracker and error logging
• Extensive noledge in regression testing and design documentation.

TECHNICAL SKILLS

Testing Tools: Quality Center 10.0/9.2/9.0, QTP 10.0/9.2, Rational Suite, Load Runner 8.1, WinSQL, Win Runner 7.1, Test Director

ETL tools: Informatica Power Center 9.1/8.5.1/7.1

OLAP tools: Business objects 2008/XI-R2, Cognos V9 Reporting Studio

Databases: Oracle 11g/10g/9i, IBMDB2 9.8/10.1, MS SQL Server 2008

Project Management: MS Project 2007

Operating Systems: Win 98/ NT/2000/XP/ 7, UNIX (Solaris/LINUX), OS 390

GUI Tools: VB 6.0/5.0

Web Servers: BEA Web logic, IBM Web Sphere, Apache Tomcat, JBOSS

Web Technologies: HTML 4.0, XML, JavaScript

Languages: SQL, PL/SQL, shell scripting

Other Tools: IBM Clear Case, VSS, CVS, TOAD, SQL Developer

PROFESSIONAL EXPERIENCE

Confidential, AR

Sr. QA Consultant

Responsibilities:

• Responsible for gatheringBusiness Requirements,Functional RequirementsandDesign Documents.
• PerformedFunctional,Negative,Positive, Integration,Regression,End to EndandUser Acceptance Testing
• Extensively involved in writing and designing templates for theTest PlansandTest cases
• Identified theTest Casesand documented them inQuality Center.
• Analyzed and DevelopedTest Plan, Test Cases, Test Scripts, Expected Test ResultsandTest Procedurefromfunctional requirementfor different modules in SAP
• Involved in creating theTraceability matrixbased onFunctional requirementin each module.
• Base-lineandRegressiontests were scheduled and performed on every Release and build.
• Worked on Winsql tools for accessing DB2 and SQL SERVER 2008 databases
• Used TOAD Software for Querying ORACLE and Used WinSQL for Querying DB2
• Involved in Task Creation,Task Estimation, Task Distribution,Task Prioritizationand Communication among Onsite and Offshore Team Members.
• Tested ETL applications in relational databases and flat files using Informatica and involved in teh report generation of BI systems
• Creatednon-functional system requirementspertaining todata qualityandsystem performance
• Involved wifTest Coverage MetricsandDefect metricssuch as Defect Density, Delivered Defect Density, Defects by Severity, Number of Defects, and Defects per build, Defect Fix Rate, Test Case Utility, Test Effort and various other measurements.
• Coordinateduser acceptancetesting wif final users. Prepared end userdocumentationfor teh new system
• UsedQuality Centerto store all testing results, metrics, implemented Test plan Document, created Test Cases, Defect Tracking & Reporting.
• Prepared and PresentedweeklyandmonthlyQADefectandStatus Reportsto teh different Stake holders of teh project usingQuality Center.
• Maintained bug lists for critical issues usingQuality Center
• As part of QA team was involved in implementation of ETL best practices.
• Worked wif batch jobs, monitoring and scheduling jobs usingCNTRL-M
• SupportedEnd-to-endtesting for downstream systems.

Environment: Manual Testing, WinSQL, Quality Center,SAP, HTML, DB2 10.1, MS SQL Server 2008, Control M, Internet Explorer, Microsoft outlook, PowerPoint and Visio, MS Office

Confidential, CA

Sr QA Tester/ETL tester

Responsibilities:

• Performing GUI, Functional and Regression testing
• Performing Localization Testing
• Interacted wif developers, users and various members of my team to discuss
• and to resolve defects and their priorities
• Detecting defects & classifying them based on teh severity
• Performed functional, Plat form and End-to-End testing
• Providing Screenshots to identify & reproduce teh bugs
• Involved in writing Test Plans, Test Cases, Test Scripts to validate teh functionality and executed usingWinSQL
• create automation scripts for assigned products/projects
• Testing of ETL jobs that are scheduled for file transfers from Operational Data Stores to designated file systems/directories.
• Prepared and Executed Data driven scripts for adding multiple customers, applying for loans etc.
• Used Toad and SQL Plus for testing execution of ETL Processes' PL/SQL procedures, packages for business rules
• Designed and performed large-scale load volume end-to-end testing using large data files
• Using Quality Center submitted teh bugs, verified and resolved teh bugs, Change Requests and raises teh issues
• Tested various Reusable ETL Transformations which facilitate Daily, Weekly & Monthly Loading of Data.
• Perform responsibilities of preparing test data as well as performed test scripts under teh guidelines of Development Manager

Environment: Manual Testing,WinSQL,Quality Center 9.2, Quick Test Professional, Oracle 10 g, DB2 9.8, Load Runner 7.5, SQL, UAT, VB, ASP, SQL, Windows NT/2000

Confidential, MN

QA Tester

Responsibilities:

• Designing Test Plan Maintain/Organize teh Requirement Traceability Matrix (RTM)
• Reviewing teh Test Cases Prepared by teh Team Members
• Monitor teh Test Execution Progress and Manage teh Issues during Test
• Execution Defect Management (Tracking and Reporting)
• Preparing & Sharing teh Status Report as applicable
• Co-ordinate/Delegating teh task(s) to teh team members
• Involved in performing various levels of testing like Unit Testing, System testing, Integration testing and Regression testing.
• Owned and maintained all teh testing documents/deliverables in configuration management tool

Environment:Test Director 7.0, Test Track Client, Rational Test Manager, Rational ClearCase, Rational Clear Quest, UAT, Regression testing

Moschip Semiconductor

SrSoftware Engineer

Responsibilities:

• Developed and reviewed teh Test Plan and Test strategy documents.
• Developed Test scenarios and Test cases for manual testing
• Executed Test cases manually and logged defects using Quality Center.
• Based on change requests, performed Impact analysis to determine teh regression testing efforts.
• Used Workflow manager to run teh workflows, worklets and session tasks.
• Performed Database Testing by writing SQL queries for generating reports to ensure data integrity and validating business rules.
• Tested different detail, summary reports and on demand reports using Report Studio
• Created and Executed Automated Test Scripts using Quick Test Professional (Q.T.P 8.2) and involved in Functional, Regression and Back-end testing for teh web based applications.
• Developed and tested MIS, Costing Analysis reports along wif Accounts and Business teams as per company standards.
• Generated teh Test Results in teh form of HTML Report and prepare Test Summary Report.
• Creating and executing SQL queries to perform Data Integrity testing on an Oracle Database to validate and test data using TOAD.
• Performed Maintenance testing for planned enhancement changes in order to make sure teh software modifications meet requirements and operate satisfactorily in teh system environment
• Analyzed Test Execution Results and reported teh Bugs/defects using Quality Center Performed Defect fix verification after each release.

Environment: Informatica Power Center 7.1.2, Oracle 9i/8i, MS Access, Quality Center, QTP, .Net, HTML, SQL, Windows platform

SP Capital Financing

Software Engineer

Responsibilities:

• Responsible for reviewing Requirement Specifications and Design Documents.
• Tested various Reusable ETL Transformations which facilitate Daily, Weekly & Monthly Loading of Data.
• Tested teh performance bottle necks at sources, targets, mappings, and sessions and employed required measures.
• Used Toad and SQL Plus for testing execution of ETL Processes' PL/SQL procedures, packages for business rules.
• Tested data marts; tested teh security levels and granting of appropriate roles.
• Tested Informatica folders, global sources, global targets, global ODBC connections, global FTP connections workflows, data profiling and manage metadata.
• Tested data models and data maps (extract, transform and load analysis - ETL analysis) of teh datamarts and feeder systems in teh aggregation effort.
• Involved in Test Case Design wif respect to Test Plan.
• Involved in Test Execution and Bug Reporting using Test Director.
• Performed GUI, Functional, Regression and compatibility Testing.
• Responsible for communicating wif Development Team, Technical Support, Business Support in order to resolve teh issues.
• Involved in Test Reporting on daily/ weekly basis through company prescribed format

Environment:Windows NT/2003, MS SQL Server, C, JAVA, Visual Basic, Win Runner 7.5, Test Director 7.0, Informatica