EXPERIENCE SUMMARY

• ISTQB Certified Tester with QTP and TFS (Team Foundation Server) Experience.
• Involved in Complete SDLC and followed QA Methodologies/Processes for organizations to meet goals for cost, schedule, functionality, and product quality.
• Expert in using the Spiral, Agile/Scrum, Waterfall and V - Model testing lifecycle Methodologies.
• Working Knowledge in databases using Oracle, DB2, SQL Server and MS-Access.
• Extensive experience in Test Director and Quality Centre for both Defect Tracking, BPT and Test Management Tool
• Expert in IBM Master Data Management (MDM) Testing and ETL Testing
• Expertise on backend Database Programming with Triggers and Stored Procedures on Oracle and SQL server.
• Excellent Knowledge in Microsoft Office Products - MS Word, MS Office, MS Excell, MS Visio and MS Project.
• Experience working with DB-driven intranet and internet applications.
• Profound noledge on flavors of Selenium.
• Knowledge in Rational Suites.
• Excellent Communication Skills, good team player and good analytical capabilities.
• Knowledge in programming languages including C, C++, Extensively used VB Scripting language, SQL and HTML.

TECHNICAL SKILLS

Tools: HP QTP, Selenium, TFS, AQT, JIRA, Dream Weaver, XML Tester

Microsoft: Office Tools MS-Excel, MS-Office, Visio, MS Share Point and MS Project

Test Management Tools: HP Quality Center (QC), SVN, CVS

Functional Testing Tools: QTP, Selenium, Para soft SOA Test, SOAP UI

Defect Tracking Tool: HP Quality Center (QC), TFS

Performance Testing Tools : Load Runner, Neo Load

Scripting : VBScript, JavaScript, HTML, XML, Shell Scripting

Operating System: Windows-98/XP/2000/2003, Windows7, XP, UNIX, Linux

Languages : C, C++, Java, PL/SQL, ASP.net, Web Services, MS Visual Studio.net

Database : Oracle, DB2, MS-SQLServer, MySQL, IBM MDM -Data Studio

TECHNICAL SKILLS

Confidential,

ETL QA Analyst III

Responsibilities:

• Developed Test Plans, Test Cases, Test Case Execution Estimation, Test Data and Test Scripts for System Testing, SIT and PAT Testing.
• Prepared and Validated Flat File data(text file) for TDI(TD Insurance) and TDW(TD Wealth) and MBNA(US project)Multiple Lobs(Line Of Business) using ETL -DATASTAGE Jobs for generating XML. Loaded the XML to MDM Using XML TESTER TOOL and also with ETL jobs.
• Created Test Cases and developed Tractability Matrix and Test Coverage reports. Managed and conducted System testing, Integration testing and Functional testing.
• Worked with the BA team, for understanding the TD Business logic, issue in the requirement SRS and BRD document. Experience in Requirements gathering, Risk Analysis, Test Planning, and Scheduling, Defect tracking, Reporting and Change Control procedures.
• Used the Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into data warehouse (ESI and EDW).
• Involved in System, Functional and Regression testing.
• Worked on SQL Queries for validating the data stored in the MDM tables using IBM Data Studio for System Testing, SIT and PAT Testing.
• Evergreen Jobs using ETL- for Collapsing the Matching Customer (SDP) process within and Across Multiple TD LOB to get the Customer 360 degree view of all the different accounts to ONE unique Customer Id.
• MQ and NT jobs using ETL for generating the Notification and sending back to notification within and Across LOB
• Verified new and updated user data in the Data base and Data Warehouse.
• Recon Jobs for testing Cascade purge Accounts, valid and invalid Customer in Source and MDM and not in Source and MDM functionality.
• Worked with Developer on DATA STAGE Director and its run-time engine to schedule the jobs, validating and debugging its components, and monitoring the resulting executable for finding the root cause of the Defect cause.
• Actively participated in the Bug review meeting, along with the team, developer and BA team. Tracked the defects using QC and used QC as Management tool and generated defect summary reports.
• Tested DSUI- GUI- Manual collapse, Split functionality which is used by Business for making manual changes on customer information.
• Validated the data movement and transformations are done correctly for MDM.

Environment UNIX, SQL, QTP, HP Quality Center, IBM On Demand, Data Stage, CA 7 scheduler, ESB, IBM Web sphere MQ Explorer, IBM MDM Server, MS Share Point, MS Excel, MS Vision, MS Access and MS Word.

Confidential

Sr Analyst

Responsibilities:

• Working as Sr. Functional QA Analyst, involved in entire Testing Life Cycle. Involved in Functional, System and Integration testing for Mainframes and UNIX environment projects.
• Performed Mainframe testing using Time Sharing Option (TSO).
• Scheduled Regression Projects using Para Soft SOA Test Tool.
• Developed detailed Test Scenarios and Test Cases in HP Quality Center, Prepared traceability matrix using QC and performing test coverage analysis to make sure 100% test coverage.
• Verified test results in DB2 database using SQL queries. Experience in Requirements gathering, Risk Analysis, Test Planning, and Scheduling, Defect tracking, Reporting and Change Control procedures
• Prepared and Validated Flat File data (text file) Multiple Lobs (Line of Business) using ETL -DATASTAGE Jobs for generating XML and verified the loaded XML into OCIF database.
• Actively participated in enhancement meetings, investigated software bugs including their priority and interacted with developers to resolve issues. Team Foundation Server (TFS) used as bug reporting tool.
• Performed regression testing using QTP Automation tool. Developed Test Scripts using VB Scripting and applied Hybrid, Descriptive Programming technique.Parameterized the test scripts using Data Driven Frame work in QTP.
• Data accessed using IBM On demand via thick client and Participated in PAT
• Participated and Organized User Acceptance testing along with the Business Users.
• HP Quality Center used as management tool, for managing test plans, test scenarios, testing cases and test results.

Environment Java, IBM DBG2,UNIX, SQL, HTML, XML, TFS (Team Foundation Server), QTP, HP Quality Center, IBM On Demand, TSO, ETL -Data stage, MS Share Point, Para Soft SOA Test, MS Excel, MS Vision, MS Access and MS Word.

Confidential

QA Analyst

Responsibilities:

• Working as a QA Analyst, involved in entire Testing Life Cycle. Performed both Automation and manual testing. Involved in Integration, Functional and the system testing for Web Application.
• Developed detailed Test Scenarios and Test Cases in HP Quality Center based on SRS document and also from the Wire Frames.
• Prepared traceability matrix using HP Quality Center and performing test coverage analysis to make sure 100% test coverage.
• Created test cases for the different features to be added into the product and performed browser compatibility testing (Ex: FF, IE, Chrome, and safari). Performed the Credit Card validation testing using SOAP UI.
• Actively participated in enhancement meetings, investigated software bugs including their priority and interacted with developers to resolve technical issues using TFS (Team Foundation Server) and HP Quality Center
• Developed Test cases and Test Scenarios for the DF project and Lead the team.
• Performed regression testing using QTP Automation tool. Developed Test Scripts by using Hybrid, Descriptive Programming technique.Parameterized the test scripts using Data Driven Frame work in QTP VB Scripting.
• Actively participated in the different releases onsite and offsite along with Developers, BA and Project manager and also with the Backend team.
• Worked as Team Lead for Bell.ca for the DF Project and co-ordinate offshore team. Worked with Business team User Acceptance Testing and Participated in PAT.
• Used Microsoft Share Point as test documents centralized location to share with other teams.

Environment Microsoft Visual Studio .Net, asp.net, HTML, XML, TFS (Team Foundation Server), Load Runner, QTP, HP Quality Center, Dream Weaver, MS Share Point, MS Excel, MS Access and MS Word

Confidential

QA Analyst

Responsibilities:

• Developed Test case and executed test cases for Web Application.
• Performed Regression testing and all bugs reported in Dashboard, which is a bug tracking tool.
• Wrote SQL queries against the database to test the referential integrity, contents and duplication of records.
• Gathered requirements, Test Planning, Scheduling, Defect tracking, Reporting and Change Control procedures
• Performed ADHOC testing and Created test cases for the different features to be added to the Product
• Actively participated in enhancement meetings, investigated software bugs including their priority and interacted with developers to resolve technical issues.
• Analyzed test results & was involved in creation of test metrics.

Environment Windows XP, Dash Board, Microsoft Office, Oracle, Digital Anchor, Microsoft Visual Studio .Net, Load Runner, asp.net, vb.net, Web services, html, xml, MS Excel, MS Access and MS Word.