Quality Assurance Project

CHAITALI MITRA

Pleasanton, California ***** 925-***-****

******************@*****.***

PROFILE

. Skilled Computer Engineer with Software quality assurance and testing

experience in a wide variety of environments, complex system and software

quality process assessment/improvement.

. Experience in Oracle APPS (11i) ERP Interface testing in Inventory, Sub

Inventory, Order to Cash, AR, OM, Purchasing, and WMS.

. Proficient in smoke, functional, negative, regression, wrapper/data

quality, system integration (SIT), UAT, backend, load/performance, and

production testing

. Excellent knowledge and working experience in with test planning, test

execution and test results analysis

. Strong business knowledge in Telecommunication Legacy Billing System

. Proficient in various database query tool - SQL*Plus, Microsoft Access,

DTR, ChapView and MySQL 4.0.18

. Strong problem solving skills and the ability to understand new business

processes and related issues

. Strong communication skills with business resources and IS resources

related to test requirements

. Practical knowledge in using C/C++ programming languages in Windows

environment

. Good history of nurturing strong working relationships with customers.

Track record of innovative designs and successful solutions.

EXPERIENCED IN

BILLING SYSTEM ? ORACLE APPS (11i) INT. TEST ? QUALITY CONTROL ? TEST

AUTOMATION (QTP)

TECHNICAL SKILLS

Oracle APPS 11i Windows XP Load Runner

Developer 2000 Eclipse Unix

Form 4.5 VB Script VAX/VMS Basic

Reports 4.5 C/C++ Verilog

SQL*Plus Rational Rose Web Server

My SQL/MLPQ JAVA Chainsaw

Chapview DTR XML

QUALITY AND TESTING TOOLS

o eValid - Website Analysis & Testing Suite Load Runner

o Test Automation - QTP Information Quality Management

o CVS - Open Source Version Control VSS - Version Control Tool

o HP (formerly Mercury)Test Director for QC Caliber-RM

o Ruby

PROFESSIONAL EXPERIENCE

Key Projects

PROJECT: Cable Billing System - Shaw Communications

(June'06 - Till Date)

Role: Senior QA Analyst

Shaw is a Canadian Communication company whose core business is providing

Broad Band Cable television, High Speed Internet, Digital Phone,

telecommunication services through Big Pipe Inc., and satellite direct to

home services through Shaw Direct to over three million customers. CBS is

the main billing system used by Shaw for their products and services.

The projects tasks include:

> Played test lead role for projects and releases

> Document and guide team to understand as-is and to-be processes for

Oracle Apps Interface project

> Testing Oracle APPS and CBS Conversion, verification of Oracle APPS

interface message, interface transactions.

> Billing system business process clarification and validation.

> Testing Web Applications

> Participation on gathering business requirements to integrate Oracle APPS

with CBS.

> Actively participate in the Design Lockdown session at warehouse and

understand business use cases

> Help preparing training guidelines, user manual.

> Interacting with the Development teams to assess the requirements and

issues

> Development of test scripts for functional, interface, and end to end

integration testing

> Monitoring batch jobs and documenting test results / defects / resolution

of defects,

> Develop test plan and log defect using Test Director

> Leading test activities for major and minor releases, co ordinate and

maintain status of defects, enhancements, and projects.

> Participate in automated testing for smoke and regression test scripts

> Functional, Regression and Provision testing

> Actively participate on improvement of various testing process.

> Experience working both in off-shore and on-site team

Specific Technologies Utilized:

Oracle Applications 11.5.10.2, Oracle Forms Version: 6.0.8.27.0 Chainsaw,

QTP, Ruby

VAX, VMS Basic, Mainframe Legacy system, Chap view, Test Director,

Filezilla, 7Zip file manger, DTR. Caliber RM. .NET, XML, SOAP-API Web

Services, mobile application

PROJECT: TransCanada Pipeline Gas Storage System & EPRS Billing Enhancement

(Feb 06 - May'06)

Role: QA Analyst

The Gas Storage System is developed for the Gas Storage Operations Group to

manage the gas storage business. The system includes:

> Contract & Transaction Management

> Operations & Invoicing

> Book Management, Exposure & Credit Risk

> Assorted Reporting Deliverables

Phase II of EPRS Billing Enhancement process is now include the calculation

and invoicing of two charges -

> RMR (Reliability Must Run) which is now significant compared to before

and needs to be passed through the customer

> ICAP for all the new and renewed contracts to be added to their contracts

The projects tasks include:

> Interacting with the Development teams to assess the testing requirements

> Development of test scripts

> Monitoring and documentation of testing / defects / resolution of defects

> Development of documentation/template where applicable

> Generate user acceptance test scenarios for the client

Specific Technologies Utilized:

Java, ASP.NET, Sybase, Oracle 8i, Speed SQL, Allegro, Crystal report

PROJECT: KUMUD GROCERIES (Nov 2005 - Jan 2006)

Role: Test Co-ordinator

Kumud Groceries is an online ordering system consists of four grocery

stores and one Electronics store.

The projects tasks include:

> Involvement in writing the technical requirement specifications, analysis

and designing the software application

> Management of the resources and co-ordination with the development team

at off-shore

> Database design and development, Import data from QuickBooks to Excel and

export to SQL server

> QA and testing

Specific Technologies Utilized:

ASP.NET, mySQL, Windows XP, VB scripts, QuickBooks, MS Excel

PROJECT: HEALTHLYNX, Apr 2005 - Oct 2005

Role: QA Analyst

HEALTHLYNX is a low cost savings program that provides discounts on

essential health care services nationally.

The projects tasks include:

> Involved with the initial stages of planning in the Software Quality

Assurance and Help Desk departments.

> Writing/testing of manual smoke and extensive test scripts covering the

entire application, including writing sample models.

> Maintenance of eTrack internal issue-tracking system, covering the re-

creation and confirmation of bugs and regression testing.

> Assisting in the creation of release and on-line documentation.

> Recreate customer issues and help to resolve their problems.

> Assist on training material, including the writing of new training

manual.

Specific Technologies Utilized:

Oracle 9i; Servlets, JSP, JDBC, mySQL, Linux, Apache Web Server; Solaris;

Windows XP

PROJECT: Centrix Health, Jan 2003 - Aug 2003

Role: QA Analyst

For this Application Service provider played the role of a software tester.

The application was a practice management system for a Physicians office

comprising of 1 to 10 doctors.

> Establishing and executing test procedures, analyzes test results.

> Creating and maintaining tests and test records.

> Logging defects, analyzing defect data, performing test for product

release.

> Recommending process improvements, reviewing test procedures, maintaining

strict adherence to client's described testing guidelines, control

processes, and procedures.

> Working in all aspects of the software development lifecycle.

> Wrote Integration Test Plan and Test Cases.

Specific Technologies Utilized:

Java, Swing; Oracle 8i; Sun Solaris; Apache Web server.

PROJECT: Panoptic, Mar 2002 - Sep 2002

Role: QA Analyst

Played the role of a Software Quality Assurance specialist for this wealth

management company for high net-worth individuals.

> Tasked with pioneering implementation of Quality Software validation plan

and procedures for development efforts and production processes.

> Wrote and executed software/system test procedures

> Used defect tracking software packages, and logged all defects.

> Analyzed test results and defect data, reported on the status of

projects, maintained test records, provided ideas for improvement,

assisted in maintaining client's change control system, developed

documentation, including procedures used by other departments, reviewed

documentation, specifications, test procedures, validated documentation,

including operator manuals.

> Created, maintained and analyzed a requirement trace (traceability)

matrix, performed product release testing, recommended process

improvements, implemented and complied with client's quality system,

maintained a strict adherence to prescribed testing guidelines and

quality control procedures, developed requirements documents and test

plans in a development environment, worked in all aspects of the

development lifecycle, responded to urgent situations, by prioritization.

> Prepared system test plan, test cases and validation summary report.

> Meet aggressive project milestones.

Specific Technologies Utilized:

Java; JRun Version 3; Oracle 8i; Windows 2000; IIS Web server.

MASTERS PROJECT (2004)

Application of Pattern Language in the selected area of Unmanned Ground

Vehicle System

Purpose: The main idea of introducing pattern language in this project is

to develop the architecture framework independent of any application or

area. Generic properties of each pattern will be applicable to all similar

type of scenario using Software Stability.

Specific Technologies Utilized:

Object Oriented Design and UML; Software stability; Pattern Language; Real

Time Embedded System; Rational Rose; Java coding

EDUCATION AND TRAINING

Master of Science in Computer Engineering, 2002-04

San Jose State University, San Jose, USA

Certificate in Oracle RDBMS and Developer 2000, 1999

Aquarius Institute of Computer Sciences, Chicago, USA

Master of Science in Physics, 1993-95

University of Calcutta, Calcutta, India

Bachelor of Science in Physics, 1990-93

University of Calcutta, Calcutta, India

In House Training on Oracle 11i

GL,

AP, AR, INV, PO, OM, WMS

Contact this candidate