Project Manager

Amit Gangal - Lead SQA Analyst

Master’s Degree

Master of Computer Application

Certification

ISTQB

Expertise Area

Manual testing

Industries

Publishing,

Assessment & Certification,

Document Management

Management Tool

HP Quality Center 10.00

Digité (PM Smart), MS Project

Defect Tracking Tool

Rational Clear Quest

Jira, PVCS, Bugzilla

Testing tool

Quick Test Professional 8.2,

Load Runner 8.0

Reporting

Business Object Enterprise,

Crystal Reports, Data Export

RDBMS / Language

SQL Server 2005, SQL,

Oracle 9i, VB, C++

Search Engine

Verity, Fast Impulse

Configuration/Content Mgmt

Star Team, SharePoint Portal

Internet Technologies

JAVA, Flash, Flex, .Net, HTML, XML, Cold Fusion, Perl

Operating Systems

UNIX, Windows(x), DOS

Database Tools

TOAD,

Oracle SQL editor

ISTQB certified SQA Lead with 8 years of experience in Web based, Client/Server applications, database testing and leading SQA team in Publishing, Assessment & Certification and Document Management domain.

Summary:

• Extensive hands-on experience in diversified fields of the Software Development Life Cycle (SDLC), specializing in Quality Assurance Process and Methodologies.

• Proficient in analyzing the Business Requirements, documenting/reviewing Functional Requirement Specifications, Requirements Traceability Matrix.

• Worked for specific Industries include Publishing, Assessment & Certification and Document Management.

• Experience in Manual testing of Web based, Client/Server applications using Black Box testing techniques.

• Extensive experience in testing Business Intelligence / Crystal reports and exports.

• Expertise with all phases and stages of software testing (Functional, System, Integration, Data Validation, Regression and User Acceptance).

• Experience in analysis of Business, Functional requirements to derive test plans and test cases.

• Execute test cases/procedures and accurately reported both progress and defect status, including gathering and reporting on project quality metrics.

• Performed Quality Reviews on Business requirements, Functional requirements, Test Plan, and Test Cases.

• Usage of automated testing tools like Quality Center, Quick Test Professional and Load Runner.

• Regular interaction with Client, BA, Developers, Managers and team members to coordinate job tasks.

• Managing offshore SQA team including estimation, assigning and tracking task, daily/weekly follow-up meeting and periodic update to management on health status of release/project.

• Implemented HP Quality Center where in defined processes & folder structure for SQA team.

• Led SQA team of 3 for creating and compiling training documents.

• Compiling data to prepare report for monthly ORM (Organization Review Meeting).

• Worked as Onsite testing & release coordinator.

• Worked as a PQA (Project Quality Analyst). Performed periodic/ad hoc monthly Configuration Management, Data Validation and Work Product audits for the ongoing or recently finished projects.

• Worked as a DPA (Defect Prevention Analyst). Prepare CAPA (Causal Analysis and Preventive Action Form) & Lead RCA (Root Cause Analysis) meetings.

• Experience in implementing Six Sigma to improve productivity of SQA team.

Experience Highlights:

 Worked as Onsite Testing and Release Coordinator for PEARSON GLOBAL HIGHER EDUCATION PRODUCT MASTER project (HCL Technologies India).

Responsibilities included:

• Identifying business critical testing scenarios for projects.

• Developing and execute User Acceptance test cases for Client.

• Report Client about project testing issues and Project health status.

• Act as Test Coordinate between client and HCL Offshore team.

• Ensure and coordinate execution of production release of projects.

• Production sanity testing after each project release.

 Worked as a Project Quality Analyst for PEARSON ONLINE project (HCL Technologies, India). Responsibilities included:

• Periodic or ad hoc monthly Configuration Management, Data Validation and Work Product Audits for the ongoing or recently finished projects.

• Representing the team in internal and external Quality audits.

• Capturing all the internal & external audit findings in SQA Work Book, passing the non compliance to the concerned team member and tracking them to the closure.

• Organizing team meetings after audits, informing about the non compliance(s). Discussing and finding the solution for the same.

 Worked as a Defect Prevention Analyst for PEARSON GLOBAL HIGHER EDUCATION PRODUCT MASTER project (HCL Tech, India).

Responsibilities included:

• Filling of Causal Analysis and Preventive Action Form (CAPA) every fortnight.

• Analyzing the defect trend and gray areas of project life cycle.

• Representing the team in internal and external Quality audits as a DPA.

• Capturing all the internal & external audit findings in CAPA form, passing the non compliance to the concerned team member and tracking them to the closure.

• Organizing team meetings every fortnight after preparing CAPA, informing about the findings. Discussing and finding the solution for the same.

• Performing Root Cause Analysis (RCA) for the production issue by discussing the issue with the concerned team, coming out with the solution, record it and circulate it within the team.

• Making sure that the solutions are implemented across the team.

 Implemented Six Sigma project ‘Improvement of Design Document Process’ for PEARSON GLOBAL HIGHER EDUCATION PRODUCT MASTER (HCL Technologies, India. This project was undertaken as at that time because of weak design there was some major lag and fallouts occurred in completion of the project. After the implementation of the project there was a substantial reduction in the number of the defects at the later stage of the project due to design.

 Led the Six Sigma initiative for PEARSON ONLINE project (HCL Technologies, India). The project was to gather and store the project findings before and after the project closure in such an optimized way that it can be easily accessible, usable by the existing team members or new members.

 Mercury Load Runner was used for Performance Testing for PEARSON ONLINE project (HCL Technologies, India. This testing was done when server hardware up gradation at the client site was done on the request of HCL. Performance/Load testing was done before and after the up-gradation to show the improvement in the performance of the web application. The testing was performed through.

Project Details:

Client : Pearson VUE, USA

Employer : Populus Group, USA (Dec 09 – Present)

1. CAT Global Monthly Releases

(Worked on this assignment for HCL Technology from Sep 07 to Nov 09 and then for Populus Group from Dec 09 to Present date.)

Pearson VUE provides a full suite of services from test development to data management, and delivers exams through the comprehensive and secure network of test centers.

Roles & Responsibilities:

 Taking on the Lead role for Monthly Releases and managing offshore SQA team. This role includes:

• Estimating the SQA effort for the assignment.

• Discussion with SQA Manager for distribution of defects within SQA team.

• Coordinating with third party like ES or Technical group within the company to setup / update the SQA environment for testing.

• Tracking & follow up on the release progress.

• Periodically updating SQA Manager with the health status of the release.

 Preparation of Test Plan, Template Design, Test Scenario, and Test Script for Online reservation, Test Center, Reporting and License Portal applications.

 Completed HP Quality Center implementation where in defined the process and designed the project/monthly release folder structure in QC for SQA team.

 Review Functional specifications to find any issues associated with the original requirements.

 Coordinating with Peer and Client for queries/issues.

 Responsible for reviewing/uploading Test Plan & Test Script.

 Building Test Environment.

 Executing Test scripts.

 Logging Defects/Issues in Clear Quest.

 Providing guidance & support to other resources for queries/concerns related to functionality & for testing practices.

 Coordinating with development team for defect resolution and other support required.

 Led a SQA team in creating Training document. This role includes responsibilities as below:

• Planned & scheduled the activities of all 3 SQA team members preparing the training documents.

• Provided all the required information to the team including the existing documents.

• Provided training whenever required as the team was relatively new.

• Regularly reviewed the prepared documents or passing them to the concerned team member for review and making sure that the review comments are incorporated.

• Regularly updated the SQA Manager with the progress.

 Actively involved in the training of the new SQA members on number of applications related to Online Reservation and Certification.

 Led the HCL SQA team at Pearson.

This role includes responsibilities as below:

• Sending the Weekly Status Report to Pearson SQA Manager and HCL Managers.

• Preparing & sending the Monthly ORM data to HCL Manager.

• Working as a coordinator between the HCL SQA team here and HCL management by organizing weekly team meeting.

• Regularly interacting with the team, resolving and/or passing issue if any.

2. City & Guilds CBT Exams & Reports

City and Guilds is to be converting their current paper based functional skills exams to the CBT model by replacing those Key Skills qualification exams currently delivered via GOLA. In order to support this effort, enhancements will be required of the Pearson VUE examination content development system, Builder. These modifications will allow for the content developers to add marking scheme information as part of the test build process to those test items that are designated as examiner marked. This also includes developing and/or modifying various reports.

Roles & Responsibilities:

 Analyzed System specifications, functional requirements for any gap.

 Prepared test plan, test cases (including sql queries) in Quality Center, as per the requirements in the Functional Requirement Document

 Reviewed the design document and schema documents to understand the business logic and expected results

 Worked with business contacts to determine test success and exit criteria.

 Created and executed Manual Test scripts to verify complex system requirements.

 Tested candidate’s result XML for correct values, tags, data elements, sequence and order.

 Performed backend testing to validated correct tables and data is getting updated and inserted.

 Tested Business Objects reports to ensure that the Business Intelligence Reports like Item Analysis, Summary Statistics, Examiner Marking Distribution, Item Data File export are in sync with business needs.

 Analyzed defects and created defect reports using Rational Clear Quest.

 Coordinating with UAT team.

 Prepared a Requirement Traceability Matrix using the Quality Center.

 Involved in cross browsing testing of the application on various Browsers to ensure that it functions similarly on all browsers.

 Participated in SQA weekly meetings and various other meetings and discussed Enhancement, and Modification Request issues and defects in the application.

Client : Pearson Technology, USA

Employer : HCL Technology, India (Aug 04 – Nov 09)

1. Book Page Display for UK

The internet applications/catalogs are used for selling both Penguin and academic/professional/technical reference products offered by Pearson Education. Through feeds system receives and also sends data feeds, from and to multiple locations/vendors.

Pearson Online deploys host of technologies – Vignette for content management, Verity and Fast Impulse for Search Engine, Web technologies – Cold Fusion; Perl, PL/SQL, UNIX shell scripting for back end operations like Feeds and Oracle 9 for persistence storage/manipulation of data.

Penguin and DK online teams redesigned their book page templates to significantly improve the ‘find and choose a product’ process. The scope of the requirements was to replace the existing dynamic book page built in Vignette, and to add dynamic FAST data to the left hand navigation of the homepages for DK and Penguin.

Roles & Responsibilities:

 Preparation and execution of Test Plan & Test cases.

 Testing the software (regression, functional, GUI etc).

 Building and executing database scripts. This involves:

• Creating DB objects like tables, indexes, etc.

• Queries using inner/outer/equi joins.

• Spooling activity logs. Generating log of DB tasks for analysis and debugging.

• Scheduling database feeds.

 Integration and Sanity Testing.

 Reporting defects through Digité (PM Smart).

2. AIV process for IRC requests initiated from Socrates

There was an IRC Register button available in Socrates that links to the IRC registration page on the web catalogs. The registration process was the same as the customer facing process which does not add value for reps that want to register a professor for IRC as a courtesy. This Project placed a more streamlined, rep driven approval process to best utilize the IRC Register button in Socrates.

Roles & Responsibilities:

 Review Functional specs to find any issues associated with the original requirements.

 Coordinating with Peer’s and on-site coordinator for queries/issues related to business rules.

 Prepare and execute the Test Plan, Test Scenario & Test Cases.

 Testing the software (regression, functional, GUI etc).

 Reporting the defects through PM Smart.

 Executing & Updating Regression Suit.

 Providing guidance & support to other resources for queries/concerns related to functionality & some times for testing practices.

 Coordinating with development team for defect resolution and other support required.

 Production sanity testing after project release

3. HEPM – QTP-HEPM Applications

To test HEPM applications manually, a huge amount of time and resources were required to perform regression testing which directly affects the productivity of the individual. To resolve these issues to greater extent and not to compromise on the quality of the deliverables, it was decided to implement QTP (a functionality testing tool) for automating each and every regression test cases and also include end to end scenario with various data to ensure that every business logics built in the system has been catered to. Automation testing enhances the effectiveness of the application and quality of the product.

Roles & Responsibilities:

 Plan the testing activities and develop a testing strategy for automating regression-testing.

 Preparing & execution of automation scripts.

 Reporting the defects in defect tracking tools like PVCS.

 Participated in team meetings with Testers and Developers to discuss bugs.

 Updating Regression Suit after every release or project.

4. HEPM - ISBN-13

The project is an initiative which has been carried out worldwide in publishing Industries. The objective of this project was to re-design existing system to compliance with the increase value of ISBN from 10 digits to 13 digits.

Roles & Responsibilities:

 Prepare and execute the Test Plan & Test Cases.

 Testing the software (regression, functional, GUI etc).

 Monitoring of DB (using TOAD) & logs to catch any error/exceptions

 Along with other team members developed & executed test cases to check the functionality of the application against the user requirements.

 Reporting the defects in defect tracking tools like PVCS.

 Participated in team meetings with Testers and Developers to discuss bugs.

5. HEPM – Automated Instructor Validation

This project provided the ability to automate the instructor validation process in order to grant access to online resources in an efficient and timely manner. In order to achieve this goal; the manual routing of e-mail requests was eliminated and an automated procedure that matches up on-line requests for access (from web based catalogs) to instructor information stored in Socrates was created. If a match is made; access codes would be e-mailed automatically to valid instructors. If a match is not made – automated e-mails will be routed to FFS and/or the sales rep depending on a set of rules.

Roles & Responsibilities:

 Designed and developed Test Plan and Test Scripts for UAT (User Acceptance Test) testing.

 Performed Manual Testing for GUI.

 Testing the software (regression, functional, GUI etc), plus monitoring of DB (using TOAD),Shell scripts & logs to catch any error/exceptions

 Reporting the defects in defect tracking tools like PVCS.

 Created and Maintained Test Activity, Test Results, Test Summary and SQA document.

 Executing & Updating Regression Suit.

6. HEPM- EMA Web Catalog

The project is to ensure EMA’s product information and value added proposition was promoted to customers in a consistent and transparent way, the organization requested enhancements to its already existing Academic Web site. This created the ability to have dynamic browse structures and product pages created from the Global HEPM. Also Catalog Builder allowed marketing teams to add and control the content added to specific portions of the discipline, cluster, course and product pages of the Web catalog.

Roles & Responsibilities:

 Review Functional specs to find any issues associated with the original requirements.

 Coordinating with Peer’s and on-site coordinator for queries/issues related to business rules.

 Prepare and execute the Test Plan, Test Scenario & Test Cases.

 Testing the software (regression, functional, GUI etc).

 Reporting the defects through PM Smart.

 Executing & Updating Regression Suit.

 Providing guidance & support to other resources for queries/concerns related to functionality & some times for testing practices.

 Coordinating with development team for defect resolution and other support required.

 Production sanity testing after project release

7. HEPM – Editorial Reports

The purpose of the Editorial Reports project was to allow editors to track their daily sales and daily inventory levels. Before this, daily sales information was not available until monthly closings. Editors were essentially operating blindly; in that, they were not able to monitor their list during key selling periods. This new Endeavour enabled them to view results for specified date ranges, and compare against previous years. This improved their ability to forecast sales and manage inventory more effectively.

Roles & Responsibilities:

 Preparation and execution of Test Plan & System Test cases.

 Testing the software (regression, functional, GUI etc).

 Building and executing database scripts. This involves:

• Creating DB objects like tables, indexes, etc.

• Simple and complex queries using inner/outer/equi joins. Nested and inline queries.

• Spooling activity logs. Generating log of DB tasks for analysis and debugging

• Scheduling database feeds.

 Integration and Sanity Testing.

 Reporting the defects in defect tracking tools like PVCS.

 Executing & Updating Regression Suit.

CLIENT : TOI, India

EMPLOYER : Ingenius Systems, India (Dec 03 to Jun 04)

Document Management System

The project was related to a Document management system, which handles the paper document right from scanning to storing and retrieving the documents. The Product was a windows based. The Database used was Oracle/SQL Server.

Task Assigned and completed.

 Review Functional specs.

 Coordinating with Peer’s and BAs for queries/issues related to business rules.

 Involved in the preparation of Test Plan, Template Design, Test Scenario, Test Script and also, responsible for reviewing Test Script,

 Building Test Environment.

 Executing Test scripts.

 Logging Defects/Issues using in house tool.

 Coordinating with development team for defect resolution and other support required.

 Involved in analysis and resolution of Client Support Issues.

CLIENT : BSNL, India

EMPLOYER : APS, India (Jan 03 to Nov 03)

Automated Integrated Management System

The project was to prepare software for Automated Integrated Management System and AC Controller. These products were installed at the sites where DG set and more than one AC unit is used.

Task Assigned and completed.

 System study and requirements analysis.

 Prepared test strategy, test cases based on the functional specification requirements.

 Integration testing.

 Backend Testing using TOAD.

 Defect logging using in house tool.

 Created and maintained Test Activity, Test Results and Test Summary.

 Coordinating with Peer’s and BAs for queries/issues related to business rules.

 Executing & Updating Regression Suit.

Contact this candidate