Quality Assurance Project Manager

SUMMARY:

• Over * years of experience in testing various software applications with major emphasis on Software Quality Assurance, Software Development Life Cycle, Test Life Cycle, Validation & Verification Model in Windows, J2EE, Mainframes and UNIX Environments.

• Excellent functional knowledge in Insurance, Financial, Mortgage and Banking industries.

• Expert in Planning Quality Assurance for Client/Server, Mainframe and Web based applications

• Expertise in Planning, Execution, Analysis and Reporting of Test Life Cycle.

• Extensive experience in analyzing business requirements, technical and business documentation, developing Standard Procedure documents, test strategies, Environmental setup and testing preparations.

• Experience in the creation and maintenance of Master Test Plans, Performance plan, Test cases, Test strategies, Test Scenario, Test procedure , Test Scripts, defect report, and periodic progress report .

• Very good knowledge in creating and maintain manual test process and procedures.

• Experience in Black Box, Functional, Regression, Integration, System, Backend, GUI, Performance, End to End and User Acceptance Testing.

• Strong in analyzing, developing, enhancing and executing of UAT Test Plan, Test Strategies, Test Cases and test Scripts and Test Report.

• Proficient in Manual and Automated testing using Structured Testing Methodologies.

• Experience in creating, modifying and enhancing the functional and integration test scripts

• Handful of experience with HP Mercury Interactive tools WinRunner, LoadRunner, Test Director/ Quality Center, Quick Test Pro and Rational tools like Rational Robot, Test Manager and ClearQuest.

• Administrated testing artifacts in Test Director and Quality Center and produced coverage reports

• Performed testing on Web based Java, J2EE Business Rules, Client/Server, Mainframe, Custom software products and Standalone applications.

• Hands on Load Testing experience using Load Runner for Java based web application and analyzed Load graphs to determine application benchmark

• Experience in testing web interfaces developed using JSP, XML and Servlets

• Strong Knowledge of Data Warehousing and Data modeling Concepts

• Performed testing on Extraction, Transformation and Loading of various Data Warehousing applications

• Created test process for data Extraction, Transformation and Loading the large teradata files

• Executed extensively the Ab- Initio scripts for Backend validation and Integration testing.

• Expert in the Extraction Transformation and Loading of data and its validation using Ab Initio graphs

• Experience in analyzing, enhancing and executing UNIX shell scripts.

• Executed different types of Unix shell scripts including File Validation, Clean Data, Pass Through, Generate signal file and FTP for different types of monthly and daily data files

• Hands on Experience in composing complex SQL Queries for retrieving data from various databases for data validation and backend testing

• Complete Backend Testing was performed using SQL and Unix Shell Scripts

• Experience in debugging and maintaining Autosys jobs and batch jobs that run on a regular basis.

• Capacity to analyze test results describe the problems and issues found, compiling test result, monitoring all fixes, and proofreading documentation prior to release.

• Good experience in Defect Life Cycle and also maintaining Defect Tracking System Quality Center, ClearQuest, Bugzilla, VersionOne to track and close fixed Defects.

• Experience in using Remedy Support for creating and tracking Incident and change management tickets for production issues and DB Modifications.

• Active involvement in project status meetings with developing team, business teams and Clients.

• Excellent management, problem solving, decision-making, communication and interpersonal skills

• Proven ability to support multiple projects under tight deadlines often with competing priorities and complexities.

• Performs independently with little to no supervision. Clear and concise written and oral communications and Strong analytical and problem solving skills.

SKILL SET:

QA Testing Tools WinRunner, QTP, Quick Test, LoadRunner, Rational Robot.

Test Management Test Director/Quality Center, Rational Test Manager

Requirements Management DOORS, Rational Requisite Pro, HP Quality Center

Defect Management Rational Clear Quest, Quality Center, Bugzilla, BMC Remedy Support

Programming Languages C, C++, Java, J2EE, VBScript, SQL, PLSQL, Unix Shell Scripts

Graphical User Interface Java, J2EE, JSP, DHTML, XML, ASP, MS.Net, VB, D2K

RDBMS Databases Oracle, DB2, Sybase, MS SQL Server, MS Access

Mainframes CICS, TSO, SPUFI, JCL, COBOL, VSAM, AS400

Change Management Rational Clear Case, MS Visual Source Safe, PVCS Tracker

Operating Systems Windows NT 4.0/XP/2000/ME/95/98, UNIX, Linux, AS 400

Others MS VISIO, MS Project, Crystal Reports, ETL, Ab Initio, Rapid SQL, TOAD

Professional experience:

Chubb Insurance Company of Canada, Toronto, ON June ‘09 – Present

Role: Lead QA Analyst

Description: Chubb Insurance has reengineered claims and quotes applications. As a lead I was involved in managing QA teams testing the functional and non functional requirements of the mentioned applications and also other downstream applications from which the claims or quotes applications retrieve or transfer data.

Responsibilities:

• Involved in analyzing and understanding the Business Requirements, Business Rules supporting the Business Requirements and Master Test plan.

• Created Testing artifacts based on Test Excellence Team suggested SDLC formats and followed strictly SDLC processes and procedures

• Involved in creating and updating Test plan and Test Strategy after understanding the Requirements.

• Involved in creating executing and updating Test Cases and Scenario associated with test data as per application monthly requirements and enhancements for Smoke, Regression, System and User Acceptance Testing.

• Involved in creating UAT Test Plan and subset of Functional & Integration Test Cases and Test Script for Production Acceptance Tests and UAT test

• Performed Functional, Regression, Integration, System and User acceptance testing(UAT)

• During the testing interact with team members and also facilitate review meeting with the Client.

• Created Test plan, Test cases, test script and store in Quality center, and tracked the progress of testing by generating the reports

• Identified the bugs/defects and co-ordinate and communicated to the developers using the Tracker in the Team Track.

• Created extensively reusable test cases design steps for monthly releases regression testing

• Customized Regression test suite with Automated QTP Scripts and Manual Design Steps for Critical, High, Medium and Low Severity Defects and enhancements as part of monthly release

• Created QTP Reusable actions and shared object repository for end-to-end testing.

• Performed Sanity testing on the builds after accepting the new builds into test environment.

• Created Traceability Matrix to ensure that all the requirements are covered by the test cases.

• Created Risk Assessment matrix document based on defects identified and risks associated in production environment

• Completed Backend Testing was performed using UNIX shell scripts and SQL queries to verify the Integrity of the database

• Executing SQL queries to perform database testing using SQL programming.

• Helping, supporting and consulting with other team members in resolving unusual and complicated problems related to new development as well as maintenance of existing application.

• Support interface testing with another Data warehouse for performing ETL testing using Ab-Initio.

• Participated in Daily conference calls and attended walkthroughs and review meetings, also provide status of work in progress, encountered.

• Providing status report of each design, testing and analysis phase of project, technical reports, formal periodic report and documentation, according to company standards.

• Created end user documentation

• Mentored Customers and junior team members with industry best practices, new SDLC methodologies and Defect life cycle using Team Track and also created end user documentation,

Environment: QTP, QC, Team Track, Java, J2EE, Oracle 10.2, SQL, PL/SQL, UNIX, Putty, MS Access, Source forge, AMDOCS, Internet Explorer, Windows XP, MS Office, MS SQL, MS VISIO and MS Project.

Morgan Stanley, Toronto, ON

Jan ‘07 – May ‘09

Role: Senior QA Analyst

Description: Morgan Stanley, one of the leading financial organizations in North America has scoped in a project of revamping the wealth management and investment trading tool to be used by investment brokers to plan, propose and perform equity trading transactions on behalf of account holders.

Responsibilities:

• Reviewed requirements, use cases and technical specifications for Online Mortgage application, suggested required changes to the requirements during walkthrough meetings as needed.

• Created Test Plan, Test Scenarios, and Test Cases, test scripts for all the quarterly releases. Created test data to test application critical release requirements, enhancements and defects.

• Conducted brainstorming session to understand production critical defects, perform root cause analysis, identify test data and plan regression-testing activity.

• Created test cases for Smoke, Functionality, Backend, Integration, System and User Acceptance Testing

• Worked with Database administrators to mock the production data for Regression, Production Acceptance Test and UAT

• Worked with Environment specialist to set up test environments for various releases.

• Worked on upgraded Latest version of Quality Center version 10 for Regression Test Management.

• Stored all the test cases and other testing related documents in Quality Center

• Organized, Baselined and Version Controlled the test cases in Quality Center

• Maintained QTP Regression Automation Test Scripts in the Quality Center.

• Executed Smoke and Regression testing using QTP Automation test scripts for all releases.

• Performed Manual testing for Functionality, Backend, Integration, System for some releases and User Acceptance Testing for some other releases.

• Logged, Tracked and Closed Defects using Rational Clear Quest Defect Tracking System.

• Assigned proper Severity and Priority levels to defects identified during all phases of the testing.

• Created Requirement Traceability Matrix for all releases testing of WFO-PMT applications and their interfaces.

• Performed Back End testing on Oracle, Sybase and MS Access using TOAD.

• Used Joins and complex nested queries to test data from multiple tables and views for validating data related requirements.

• Executed Unix Shell Scripts for ASCII data file transfer from Source system to Target System.

• Used Putty to check the Logs and Job status while performing critical pricing related testing.

• Verified Autosys jobs functionality as a part of release requirements and regression.

• Conducted Walk through and inspection for test cases and test execution results review and

• Participated actively in weekly status meeting and communicated effectively QA status to project management team and stakeholders.

Environment: Quality Center 10.0, QTP, Rational Clear Quest, Rational Requisite Pro, TOAD, Unix, Putty, Windows 2000, Sybase 12.5 Adaptive Server, Oracle 9i, and Web Methods.

Capital One Canada, Toronto, ON

Dec 04 – Nov 06

Role: QA Analyst

Description: Capital one is a financial giant with specialized operations in mortgage and loans. The collections application used by the legal and collections department was designed, developed and tested a collections applications to manage defaulter cases and invoke repossession activities.

Responsibilities:

• Effectively used Quality center for requirements tracking and building coverage for System Testing

• Developed various Test plans and Test cases and analyzed Test results with pass and fail criteria

• Responsible for tracking defects using Quality center and made sure those defects are efficiently passed from one layer to another.

• Reviewed standard Documentation of Software Development Life Cycle (SDLC)

• Involved in Regression testing heavily for constant rules changes

• Involved in creating the Scenarios for single and Multi-User test.

• Generated different reports and graphs after executing scenarios.

• Performed Database Testing by executing SQL statements.

• Worked closely with Development team members to have better understanding of the system functionality in order to improve Testing Quality.

• Used DOORS to view the history and traceability of requirements and created RTM for all releases

• Provided training to peers and team members on all enhancements of the applications

• Used XML to store data.

• Analyzed and documented the test results for each build of testing.

• Analyzed the testing progress by conducting walk through meetings with internal quality assurance groups and with development groups.

• Performed Functional, Integration, Regression, GUI and Data Driven Testing using QTP and WinRunner

• Tested web interfaces developed using JSP, XML and Servlets, used XML to test the Server Components.

• Involved in Extracting data from various Data sources through different phases and placing the required data in the Data Warehouse.

• Complete Backend Testing was performed using Unix Scripts and SQL queries to verify the Integrity of the database.

• Executed different types of shell scripts and JCL batch jobs including File Validation, Clean Data, Pass Through, Generate signal file and FTP for different types of monthly and daily data files.

• Extracted Transformed and loaded data from source to target using Ab Initio for backend testing and Performed backend validation after moving data to different targets.

• Involved in Analyzing and Testing the Ab Initio graphs and setting the parameters.

• Extensively developed SQL Queries to test business process of financial Modules in the application.

• Responsible for writing the Performance test plan document for load/Stress testing and designed the load test environment.

• Analyzed and reviewed Performance, Response time, Hits per second graphs in performance testing , Throughput, Average CPU Usage, Network Delay, Transaction Response time graphs and identified bottle necks and memory leaks, created performance report for the application and escalated issues to project management team.

• Used Load Runner for planning performance test and created Vuser scripts. Created scenarios through LR Controller.

• Periodical meetings with Directors, Project Managers and Clients for implementing new approaches and techniques.

• Responsible for User Acceptance testing by giving demos to the client and getting sign off.

• Responsible for documenting the process for future references.

Environment: Quality Center 9.2, Load Runner, Rational Clear Quest, Bugzilla, Java, J2EE, SQL, Oracle, Mainframes, Data warehouse, Windows NT, UNIX, Internet Explorer 5.5/6.0, XML, MS Office, MS VISIO and MS Project.

Client: Wells Fargo Bank, Charlotte - NC

Aug 03 – Nov 04

Role: QA Analyst

Description: Tested an online banking application which was developed after including new features. The application was used for account management, transfer funds, bill payments and statement generation.

Responsibilities:

• Reviewed standard Documentation of Software Development Life Cycle (SDLC)

• Interacted with developers and users to analyze the user requirements and functionality of the application.

• Identified the Gaps between Requirements, Technical Specification and Usecase documents.

• Developed test scripts, test cases based on requirements and functional specifications

• Executed the Test Cases to verify actual results to expected results

• Identified the bugs/defects and communicated to the developers using the Tracker in the Team Track.

• Performed integration testing between different modules of the application under test defects

• Performed thorough Defect Verification after development team resolved or fixed the bugs

• Wrote SQL queries to verify the database tables for the data inserted from the GUI

• Performed the Regression Testing and executed the WinRunner Automated Scripts in all the environment when the application attained a stable state

• Created Regression Suite by including the test cases that covers major functionality of the application and handed over to the Regression Team

• Modified the Unix Shell scripts and executed them for various timely scheduled jobs to create the reports

• Used VSAM to manage the files on mainframes.

• Used SDM to read the side-file data from the local XP disk array and then write the data to the remote disk array.

• Created and modified the JCL scripts while setting up the test environment.

• Participated in automation scripts Walkthroughs.

• Attended weekly status meetings showing progress and future testing efforts to the project manager.

Environment: Test Director, WinRunner, Team Track, UNIX, Mainframes, VSAM, JCL, SDM, Java, MS Office, Windows 2000, Windows NT, Netscape Navigator.

EDUCATION:

Masters in information technology

Bachelor of Computer Engineering

Contact this candidate