Sujatha Makkena

305-***-****

abm4t2@r.postjobfree.com

Objective

To secure challenging position in the field of Information Technology as a

Software Quality Assurance Lead/Analyst by testing and managing various

applications, manual and automation using different tools.

Professional Summary

> 9+ years of experience in Information Technology Industry as a Programmer

and a Software

> Quality Assurance Analyst on both Windows and Unix Environments.

> 7+ years of Extensive Experience in Quality Control of software product

release as a

> QA Tester using Manual & Automated test methods.

> Expert in testing Client/Server and Web based Applications.

> Good Experience in Datawarehouse Concepts.

> Good Domain Knowledge of Financial and Utility Sectors.

> Excellent working experience in Scrum/Agile methodology.

> Strong in Analysis to under standing Business and user Requirement.

> Good exposure in preparing test plans/procedures based on business and

system Requirements.

> Sound knowledge of the Software Development Life Cycle: analysis, design,

testing, documenting, maintaining and training.

> Good experience in writing test cases and developing automation scripts.

> Excellent in performing Functional, Integration, System, Regression&

User acceptance testing

both manually & using automated tools.

> Working experience in Selenium Automation.

> Good working experience in writing the php scripts for backend API

testing.

> Strong in back end testing using SQL queries, generating reports to

ensure data Integrity.

> Efficiency in defect tracking and reporting system.

> Excellent communication skills and Good team Player.

> Excellent Customer relationship management.

Testing Expertise (Manual and Automation) :

Web Testing, Functionality Testing, Database manipulations using SQL,

Integration Testing, Security Testing, and Client server Testing, Database

validation, Regression test, System Testing and Black box Testing

Technical Skills

Testing Tools: Mercury Win Runner 6.0/7.0/7.5, Test

Director 6.0/7.2/7.6/8.0

Selenium

IDE/RC.

Programming Languages: Java, VB.Net, C#, PHP, SQL, PL/SQL, Shell

Script

ETL Tools Informatica

Data Bases: Microsoft Access, SQL Server 2000, Oracle

7.x/ 8i/9i/10g,

Browsers: Internet Explorer 5.x,6.x,7.x,Fire Fox,

Safari

Web Technologies: HTML, XML, JSP, JavaScript

Operating Systems UNIX, Linux, Windows 95/98/2000/NT/XP

Job Title History

Sr. Testing Analyst eMeter Corp, San Mateo, CA Nov

2006 - Present

Testing Analyst eFunds Prepaid Solutions May

2005 - Nov 2006

(Formaly Wildcard Systems Inc.,)

Sunrise, FL

Testing Analyst CFS - SunTech Servicing LLC, MS Sep

2004 - Feb 2005

Software/QA Tester CHASE, Houston, TX Feb

2004 -Jul 2004

Software/QA Tester Equiserve Inc., NJ

Jan 2002 - Nov2003

QA Tester Prudential Security, Boston, MA

Mar 2002- Nov 2002

QA Tester Net-Link, Metuchen., NJ

Jun 2001 - Jan 2002

Programmer CNC Investments Inc., Houston, TX

Nov 2000 - Apr 2001

Programmer HCL Info Systems Ltd., Hyd, India

Mar 2000 - Sep 2000

Developer Krebs Bio-Chemicals Ltd.Hyd,

India Aug 1999 - Feb 2000

Professional Experience

Client : eMeter Corp.,

Nov'2006 - Present

San Mateo, CA

Role : Sr.SQA Engineer/Analyst

Project : Energy IP MDMS

The eMeter platform delivers the only proven, comprehensive, enterprise-

scale energy information management solution for utility mass market and

C&I deployment. EnergyIP includes full meter data management (MDM)

capabilities, provides a wealth of AMI business process applications, and

serves as an integration platform for linking advanced meter data, AMI

technologies, and utility enterprise systems.

As a Sr.SQA Engineer, working on the Billing Service Application of the

Engergy IP Product . The Billing Service application takes the meter read

data from meters or usage data calculated from interval data, processes it

through several modules in multiple steps before preparing final billing

determinants for the utility.

Responsibilities:

. Review Business Requirements

. Creating Test Scenarios based on the Functional Specifications.

. Converted high level Test Scenarios into Test Cases.

. Walk through the test cases with functional and engineering team

prior to System Testing.

. Preparation of test data and execution of test cases.

. Setting up the environment and tools which requires for the

testing.

. Verification of Oracle database changes.

. Testing the User Interfaces that are being developed in Siebel.

. Verification of communication messages through web services and

JMS.

. Responsible for verification of property files, shell scripts.

. Perform regression testing before the Release.

. Logging the issues in a timely manner using Bug Tracking tool

called JIRA.

. Storing the test cases, data and results in source management

tool Perforce.

. Assist support team to debug the issues.

. Deploying the builds when requires in test environment.

. Managing the test schedules and providing the estimates to the

management team.

. Educate other team members with the functionality that we are

working with.

Environment: Linux, ShellScript, Java, Oracle 10g, Jboss 3.2.7,

apachetomcat, Siebel,Tibco

Soap UI.

Project : Energy Engage Portal

Energy Engage is an online Consumer Engagement solution that empowers

utilities and consumers to work together to drive sustainable energy

conservation and cost reduction.

As a Sr.SQA Engineer, Involved in multiple module like Admin, Report and

Notifications.

Responsibilities:

. Review Business Requirements.

. Creating Test Scenarios based on the Functional Specifications.

. Converted high level Test Scenarios into Test Cases.

. Created php scripts to test backend API and Selenium Scripts to

test Admin UI

Environment: Linux, ShellScript, Java, Java Script, php, Oracle 10g,

Selenium IDE/RC, Soap UI.

Company: iGate Mastech May' 2005 -

Nov'2006

Client: eFunds Prepaid Solutions

Sunrise, FL

Role: Test Analyst

Project : Association Release

eFunds Prepaid Solutions (WildCard Systems) is the global solutions leader

in turnkey host based prepaid cards and custom stored-value products. The

company offers an array of commercial and consumer stored-value products

that are made available to end-users through banks and commercial clients.

eFunds Prepaid Solutions (WildCard Systems) is certified by MasterCard,

Visa and Discover as an endpoint on their networks, and is authorized to be

an issuing processor for cards bearing Visa, Electron, Interlink, PLUS,

MasterCard, Maestro, Cirrus and Discover/NOVUS payment marks

Working as a Testing Analyst for the Association Release Group. Association

Release Group is focusing on the Authorization and Settlement changes that

are release by the Associations include, Visa, MasterCard, Discover,

eFunds, etc., The applications currently being tested include features

such as Cash back, Chargeback, Partial Auth, 3D- Secure, etc.,

Responsibilities:

. Participated in walkthroughs and formal reviews for preparing

test strategy and test scenario.

. Developed test plan using the requirements.

. Developed Test Cases using the Tech Specifications.

. Developed test scripts using the Visa Test System (VTS),

MasterCard Credit/Debit Simulator and General Clearing Management

System (GMS) for both Autorization and Settlement process.

. Worked closely with developers in analyzing test results and

defining different test approaches specific to the application under

the test.

. Wrote SQL Queries to test the data integrity.

Environment: Coldfusion, ASP, C#, VB.Net, SQL Server 2000, Megaapp (MAX -

Multiple Application Access), C4 (Claim Card Client Configuration), VTS

(Visa Test System), MasterCard Debit/Credit Simulator, GCMS Simulator.

Company: Cybersoft Technologies Inc., Sep '2004

- Feb'2005

Client : CFS - SunTech Servicing LLC, MS

Role : Testing Analyst

Project: Servicer Data Mart

The Servicer Project will be the initial project to integrate SunTech data

for reporting and analysis within CFS' new data warehouse. The subject

area consisted primarily of SunTech funded loan and borrower (customer)

information. The vision of the servicer data mart system is to enable the

rapid development, testing and deployment

The Servicer project will consist of three major pieces:

. an ETL (data extraction transform and load) process,

. a data warehouse

. And business intelligence browsing/reporting application.

The extraction transformation and load process will extract data from the

METS application on the mainframe at Suntech. Data will be cleaned,

validated and transformed by the ETL tool. Once the data is prepared for

the data warehouse the data is saved in the data warehouse.

Responsibilities:

. Participated in walkthroughs and formal reviews for preparing

test strategy and test scenario.

. Developed test plan using the requirements.

. Developed Test Cases using the Tech Specs.

. Worked closely with developers in analyzing test results and

defining different test approaches specific to

. the application under the test

. Wrote SQL queries to verify data integrity

Environment: ETL Informatica, SQL Server, Test Director 8.0, MS - Share

Point Server, SQL Analyzer, Windows NT

Company: Cybersoft Technologies Inc., Feb 2004 -

Jul 2004

Client: CHASE, Houston, TX

Role : Software/QA Tester

Project: Online and Paperless Statement

Worked as a Software Tester at CHASE bank on their ongoing Banking system

called CHASE Bank Online and Paperless Statement Project. System is

migrated to a new Portal platform using latest Java, J2EE technologies. The

applications currently being tested include features such as domestic,

international, and inter-institution money transfers; the use of e-

signatures to expedite account openings; online check images; online chat

with instant callback features; and a security feature namely last-time

login time stamp, Investment and Portfolio's. Online statements were

generated in Excel and PDF formats. Online statements were also pivoted

using Excel.

Responsibilities:

. Developed test scripts, gathered statistics from client and

server side monitoring during test

Run, presented test results to product team.

. Executed different types of financial transaction using win

runner TSL Scripts.

. Developed TSL scripts for Account opening for different cin/pin

bin range.

. Tested Excel Pivoted Reports for Online statements for more

clarity/readability in the data..

. Created test bed for different product type using the tool Chase

Smart

. Utilized Web Defect manager for defect tracking, Cycle manager

for managing the test scripts

. Types of testing performed included automated, manual, system,

functional, regression, black box, white box, exploratory, and unit

testing.

. Performed regression testing, content management on every new

build

. Worked closely with developers in analyzing test results and

defining different test approaches specific to the application under

the test

. Tested the functionality and compatibility with different

versions of IE and Netscape on windows.

Environment: Windows NT, WinRunner 7.5,TestDirector 7.2,Chase Smart, Cycle

Manager, Java, JavaScript, HTML, XML, MS-Excel, SQL Server, Oracle 8i,

Websphere7.0

Company: Cybersoft Technologies Inc., Jan 2002 -

Nov2003

Client : Equiserve Inc., NJ

Role : Software/QA Tester

Project: Finance (Stock Transfer Agent/Call Center)

Equiserve Inc. is a stock transfer agent undertaking projects from publicly

listed companies such as ATT, Prudential, and GM. The application was

developed to facilitate sale of ATT shares with reference to the reverse

stock split and all operations associated with stock registration. It also

handled mailing of dividends and proceeds from sale of shares and tax

related information to the registered shareholders.

Responsibilities:

. Participated in walkthroughs and formal reviews for preparing

test strategy and test scenario.

. Utilized Test Director as a test management tool for planning

and executing manual and automated tests, and for defect reporting.

. Developed TSL scripts to test various business modules of the

application, involving Stock Transactions, Dividend Re-investments,

Account Modifications & Consolidations, Stock allocation and Customer

Tax liabilities.

. Performed Regression testing on the new build and Integration

testing with the Comcast module.

. Wrote SQL queries to verify data integrity.

Environment: Windows 2000, Win Runner 7.1, Test Director 6.0, Visual Basic

v6.0, SQL Server 2000, MTS, IVR Framework.

Company: Cybersoft Technologies Inc., Mar 2002- Nov

2002

Client : Prudential Security, BOSTON, MA

Role : QA Tester

Project: Retail Distribution Quality Assurance (RDQA)

Web Application: Retail Distribution Quality Assurance

Retail Distribution client site project provides a new retail distribution

client site by migrating all existing prudential retail customers onto a

portal platform. New online customers have the capability to register

through a newly defined registration process. Retail distribution customers

can access the portal to view their account information as well as content

and functionality from the PSI client under a single platform. The reports

could be also been pivoted in Excel format

Responsibilities:

. Wrote Test cases bases on Tech specs.

. Described scenarios for each applicable test level bases on the

business process.

. Performed both manual and automated testing for portal

Application.

. Tested for Excel pivoted reports for better understanding of the

data.

. Performed GUI Testing

. Created Batch files for Regression testing using Mercury's Win

Runner

. Performed User Interface testing, negative Testing and

Regression testing for Portal1

Application

. Performed cross -platform testing on windowsNT/2000/XP

. Performed Multi browser Testing, IE, Netscape

Environment: Windows NT/2000/XP, Sybase.7.x, MS-Excel, Web sphere,

JavaScript, Java, EJB, LDAP Portal Server and Win Runner 7.x., Test

Director 6.0.

Company: Cybersoft Technologies Inc., Jun

2001 to Jan 2002

Client :Net-Link, Metuchen. NJ

Role :Manual QA Tester

Responsibilities:

. Involved in manual testing for Financial Application also called

as Net-link Financial System. Application contain different modules

like inventory management, sales order, purchase order, security,

taxes, general ledger, payroll, account payable, account receivable

and bank reconciliation. Network based application was in related with

Windows NT/2000 and UNIX operating system.

. For the decision making the system has many reports, which are

developed and generated in Crystal report. The system also supports on-

line ordering and stock updating.

. Also involved in System testing, backend, front-end,

integration, black box and white box testing using test cases and test

plan. Also involved in Setup application on network and different

client locations.

Environment: UNIX, (Oracle & Pro C), Windows 98/NT/2000(Oracle, Power

Builder)

Company: Cybersoft Technologies Inc.,

Nov 2000 to Apr 2001

Client :CNC Investments Inc., Houston, TX

Role : Programmer

Project :Property Management System

This application was developed for Maintain Property Information like

Multi-family Properties. The

Property Management System has 8 modules. The Property Management

includes all the features you

need for efficient, fast property Management. This high performance

software goes far beyond

reporting and accounting functions provide property managers with a

complete leasing, Prospect,

applicant, Resident, Units-Make-Ready, Maintenance, Transaction process

for resident, accounts for

managers and reports for supervisors.

Responsibilities:

. Analyze and design the enhance requirements.

. Programming in PL/SQL, Oracle Forms and COM objects.

. Created database for displaying the all residents and units

information.

Environment: Oracle - Forms, VB, Oracle 7.3, Windows-NT

Client : HCL Info Systems Ltd.

Mar 2000 to Sep 2000

Role : Programmer

Project :Sales Order Processing

Involved in the design and development of "Sales Order Processing" This

system maintains inventory and sale order modules. Some of the main

features of this system are customer information storage and retrieval,

generation of sales quotations for customers, generation of sales order

from partial quotations and generation of shipping advice for partial sale

orders

Reports of all sales orders pending with a detailed list of item are

printed over a period of time, thus enabling one to determine which sale

orders have been shipped partially or completely. The Responsibilities:

. Development of simple to complex Oracle forms using Forms

4.5.

. Developed Stored Procedures and Database Triggers using

PL/SQL.

. Used Oracle provided PL/SQL database packages.

. Integration testing of the above in a distributed client

server configuration.

. Integration testing simulating a real time production

environment.

. Developing reports using SQL* Plus, PL/SQL and Reports.

Environment: Oracle 7.3, Developer 2000(Forms 4.5, Reports 2.5), PL/SQL, C,

and Win 98

Client :Krebs Bio-Chemicals Ltd.

Aug 1999 to Feb 2000

Role :Programmer

Project :Employee Information System

This system is designed to automate entire network by maintaining four

Databases.

Employee Details Database: All the information that remains constant for

substantial period of time will be held in this database by maintaining the

records and information of all the employees in the organization and also

maintaining the complete information about the works allotted by the

organization

Employee Maintenance Database: This database automates all the day-to-day

activities concerning the employees in the organization. Documents are

generated using leave application form, Medical Allowance Application etc.

Work Schedule Database: The work allotted by the organization in a

particular month, the worker information and all the related details are

stored in this database.

Archive Database: All the data that expires is moved into this database.

When a work is completed all the information pertaining to the worker and

related information will be moved into this database.

Responsibilities:

. Analyzed and coded Problems.

. Created Forms, Master Detail Forms Menus and Toolbars.

. Created tables with integrity Constraints, Indexes.

. Wrote Stored Procedures and database Triggers.

. Generated Reports.

Environment: Oracle 7.3, Developer 2000(Forms 4.5, Reports 2.5), PL/SQL,

and Win 95

ACEDEMIC PROJECTS

Computerized Banking

This system has various functionality's such as Creating a new accounts,

Modify the existing account information, deleting the accounts, Account

Transactions, Enquiry's the Account status and list out the various types

of accounts and day to day transactions by using forms and send them into

databases through the coding of PL/SQL procedures. Reports are also

generated for all the above functionalities. The roles and

responsibilities include the following:

. Designed and Coded the Transactions and Enquiry modules.

. Prepared invoices and inventories for customer's accounts.

. Used PL/SQL procedures and Database Triggers.

. Generated Reports.

. Tested Developed Forms.

Environment: Oracle 7.3, Developer 2000(Forms 4.5, Reports 2.5), PL/SQL,

and Win 95

Hospital Management System

This project consists of admission and billing of patients in a hospital.

The project consists of five modules that are Patient Details, Bed

Enquiry, Patient Accounts, Patient Discharge and Bills Printing. The

program was developed in house as a package tailored to fit the specific

requirements of a Hospital Organization. The roles and responsibilities

include the following:

. Analyzed and coded Problems.

. Created Forms and Master Detail Forms.

. Used PL/SQL procedures and Database Triggers.

. Created tables with integrity Constraints, Indexes.

. Generated Reports.

. Tested Developed Forms.

Environment: Oracle 7.3, Developer 2000(Forms 4.5, Reports 2.5), PL/SQL,

and Win 95.

Education

BS in Computer Science, SV University, India

1-

Contact this candidate