Customer Service Testing

[pic]

Srigowri Vakalapudi

Email: *********@*****.***

Cell: 848-459-

4078(Preferred), Home: 678-***-****

OBJECTIVE:

Contributing to organizational growth to its optimum efficiency,

deliver effective business results, and quality by obtaining a

position that allows me to use my strong IT analytical skills and SDLC

experience extensively, to design, develop and testing projects in a

dynamic team-oriented environment that promotes leadership, learning,

and growth.

Actively involved in the SCRUM agile Methodology, working as Scrum QA

Lead.

SUMMARY:

. Extentensely working personality with Mobile Technology, CRM,

Billing with Quikview of T-Mobile Internal application along

with the Amdocs Billing.

. Close intimate work nature with Amdocs Billing system on daily

basis.

. Pretty good knowledge and work experience with all the mobile

Devices with Iphone, Blackberry, Tablet, IOS, femato cell signal

testing.

. Hands on experience with Performance using both Jmeter, Load

Runner and Montioring tools like ksar.

. Capturing the Non Functional Requirements like Response time,

TPS and getting the SLA from the sign off doc

. Worked extensively with both client side and server side setting

to run baseline, load and stress and also endurance testing.

. Recorded the base scripts to make sure the set up is ready and

then enhance the scripts in order to make the performance suit

ready

. Working with the Network enginerrs for IPSpoofing

. Working with the Workload modules.

. Capturing the server logs from the developers or from the

123LogAnalyser

. Identifying the Critical scenarios, talking to the architects

and also with Business.

. Monitoring the most critical scenarios and providing the reports

to the Development team.

. Working with the scenario setting up, and also with correlation

(session id dealings)

. Good knowledge of Cloud based platform for testing and

monitoring mobile websites and applications using

. DeviceAnywhere

. Very good understanding and involvement in Agile Testing based

Environment with very good communication.

. I am innovative, result-driven, highly self-motivated and

energetic professional having more than 15 years of experience

in Information Technology with over 8 years of experience in

design, development, and multi level QA(quality assurance)

testing using SDLC((software development life cycle), waterfall

and Agile methodologies.

. In Agile as a team work together better, and will hold one

another accountable for delivering.

. Attending the daily standups in scrum.

. Working based on the Business priority.

. Managing backlogs and Pre-Planning for the next sprints

. Periodic Communication in SCRUM AGILE Methodology to the stake

holders about the status.

. Creating working agreement with the cross platform team in

Agile.

. I am very strong in object oriented analysis and design skills

including 5+ years of experience Oracle, PL/SQL, and C

programming, UNIX and shell scripting.

. Worked thoroughly with the SAP based T-Mobile internal

application Quikview having couple of modules like DMW, EEIR,

. And SAP OER.

. I have proven track record experience of leading, developing,

unit, regression and system integration testing (SIT) and

delivering client-server, warehouse, and web based complex multi

dimensional projects on time with quality.

. I have strong functional knowledge in data warehousing, billing,

collections, vouchers, and Internet transaction solutions, GUI

(Graphical User Interface), and mobile technology systems.

Multiple times, I was recognized as a Strong QA Resource with

strength in leading and managing QA teams, proven Ability to

Work effectively in very competitive and aggressive Agile

development methodologies, recognizing peer strength, building a

productive and intelligent QA Team.

. I professionally performed the responsibility as Mentor and

Leader to motivate the team to follow strong QA Process.

. I have been extensively using QTP, QC (Quality Control),

Performance Testing (Load Runner) tools.

. I always advocate for improvised QA Process which will provide a

Quality Product within Schedule and Budget. My leadership

experience coupled with strong technical background, along with

excellent Analytical, Presentation and Communication skills

makes me a valuable asset to any project or to any organization.

. Worked extensively with the Iphones, Ios, Blackberry mobile

device testing, in almost all the Mobile Technology companies

worked with.

CERTIFICATION AND TRAININGS:

. Oracle 8i Certified DBA Professional. (OCP DBA) and completed

Oracle9i DBA Training, Wilshare Soft. Ltd., India

. WinRunner Certification from Brain Bench and Completed diploma

course in C, UNIX, Oracle from BDPS, India

. Fast Track Training in Cold Fusion 4.5, from Allaire given by

CSC, New York, USA

. Year 2000 Solution on ES9000, Focus InfoTech & DSQ Inc., India

. UNIX Admin works with VERITAS Volume Management, SAN, and Web

servers including Samba and Apache

SPECIFIC EXPERTISE:

. Expertise in Manual, Automated, Performance and Stress testing.

. Proven ability to work on multiple projects within given

timeline by delivering projects successfully and efficiently,

. Expertise in creating Risk Analysis reports, Test Coverage, Test

Requirements, test plan, Test Cases., Test data specifications,

Test matrices, Test results, Test status and incident reports

and Final test reports.

. Manage Software Test Deliverables for QA Team, Development Team,

Business and Upper management.

. Ability to setup and maintain Test Environment. Influence

designs and Plans to Improve Performance and Reliability, Reduce

Resource consumption and Facilitate Testing.

. Excellent understanding of SDLC, Agile, Waterfall and Test

methodologies from project scope to post deployment.

. Expertise in Testing with Windows Environment, UNIX Environment

and Oracle, SQL Server, Netezza databases.

. Expertise in testing the Migration of the data from Legacy

system to new systesm

. Experise in writing and executing sql queries

. Expertise in testing Data Stage to load data to different stages

. Expertise in Preparing XML files for test scenarios

. Expertise in VB Scripting, Java scripting.

. Mobile handsets testing.

. Testing the apps in iPad and Touch pads.

. Testing the apps in Smart phones.

. Understanding and acting accordingly to all the server side

coding in order to deal with some of the critical Intermediate

server issues.

. Expert Level Knowledge in Creating an Automation Test Scripts

for Web based Application Using HP QTP 10/11 using Descriptive

Programming. Proven Problem - Solving and technical Debugging

Skills.

. Participates in requirement definition for specific projects.

. Expertise in Quality Centre (Test Director) to Manage and Handle

Project Planning and to create Test Requirement, Test Coverage,

and Test scripts, Test cases, Defects tracking and reporting.

. Advance knowledge of system analysis, database design, form

design, report outlay, development and testing

. Expertise in various levels of Quality Assurance for

Client/Server, Web based and Mainframe applications.

. Expertise in Handling Small to Medium, Medium to Large QA member

Team in Agile Development Methodology.

. Strong leadership quality. Ability to lead based on situation.

Handling small to large QA groups in onsite and also off shore

team based on time zones. Effectively provided 24X7 supports.

. Ability to test in the DMW module of the SAP based application

Quikview which is involved in associating of IMEI and MSISDN

which is called sterilization (relationship maintainance).

. Ability to work with EEIR which is involved in SIM and MSISDN

relationship.

. Actively involved in In SAP OER New IMEI (New Device) and New

SIM with the old phone number are been related.

. Ability to work through any kind of Defect to give result and

work with Developers to resolve the issue.

. Ability to provide both detail information and also summarize to

management level.

. Expertise in Performing Usability Testing, Black Box Testing,

GUI Testing, Unit (CIT), Integration, and System Integration

Testing(SIT), Security Testing, User Acceptance Testing(UAT),

Regression Testing, Data Driven Testing, Beta Testing, Boundary

Value Analysis and Performance Testing, Input Testing,

Equivalence Partitioning, Syntax Checking, Special-Value

Testing, Output Result Coverage.

. Attending the Requirement Analysis meetings, playing a major

role in the defect tracking Meeting.

Working with the test metrics. Working with the developers and

BAs for the Use case and test case deliverables.

. Preparing the traceability and test coverage matrix. Working

with the Test Plan and Test cases.

TECHNICAL SKILLS:

. Operating System: Unix, Linux, SCO Unix, MS-DOS, Win

95/98/NT/2000/XP/7, OS/400, MVS, SunOS4.1.4

. Software: TOAD, PL/ SQL, SQL, MS-Office, Rumba,

Tomcat, WinSQL, SQL Developer

. Database: DB2/400, ORACLE 11g/10g/9i/8.x/7.x., MS

Access, ES9000, MS SQL

. Application Server Oracle Web Server, JSP Server, SQL

Server, IIS, Solaris 2.8/2.7/2.6/2.5.1, XMPP

. Automated Test Tools QTP 11/10/9x/8x, Win Runner 7.00/7.2/8,

Load Runner, Clear Quest, Silk Test6.0, AMDOCS

. Bug Tracking Tool Quality Center 11/10//9.5/8.x, Rational

Clear Quest, PVC Tracker, JIRA, Rally, BUGZilla

. Testing methodologies: Black Box, White Box, System Integration,

Regression, End-to-End, Performance, CIT, SIT,

UAT, Data Validation & Verification, Data Driven,

Functional, Smoke, Positive and

Negative testing, boundary testing, bottom up, RBT,

SBT,ATDD.

. Reporting Tools: Test Director (Test Manager), Quality

Center, Team Track, Crystal Reports, Rally,ALM,PVC

Tracker, Crystal Reports, Oracle Business Intelligence

. Web tools Flash, Dream weaver, Adobe Photoshop, Web

sphere, Web logic, eCom, COLD FUSION

. Language C, C#, SQL, PL/SQL, SQL*PLUS, JAVA, AJAX,

JCL, CICS, VSAM, BASIC, COBOL,.NET

. Scripting Languages VB SCRIPT, JAVA Script,

HTML,DHTML,TSL,XML, .NET, UNIX Shell Scripting

. Business Tools Ms Word, Ms Excel, and Ms Power Point, Golden

Tool for SQL

. Web navigator Netscape Navigator 7.0, Internet explorer,

Firefox

. OLTP CICS

. Network protocols TCP/IP,HTTP,SMTP,MM7

. SDLC Methodology Agile, RUP, Water Fall,V-Model and

Spiral Model

. Training QTP, QC, Load runner, Configuration Management,

HIPPA, Agile.

. Administration Test Management,Quality Control, Quality

Analysis,Review, Audit, Assessments, Reporting

. ETL Informatica 9.0.1/8.6

EDUCATION

. Bachelors of Science, Biology, Physics, Chemistry, Andhra University,

India

. Post Graduate Diploma in Systems Development, Computers, NIIT,

India

Visa Status: Green Card

PROFESSIONAL EXPERIENCE

T-Mobile (Contract through Pro-Karma)

Sept 2012 to Till date

. Working with the Quick View T-Mobile application made with Flex and

Java, which is a Customer Service Management (CSM) application.

. Dealing with all the Socs, Services, Bans and IMEI and SIMS with

different environments, depending on the Monthly Builds.

. Leading and Working extensively with the Production supporting QA

group.

. Working with the Customer Service defects from the Production.

. Working with the Quick View T-Mobile application made with Flex and

Java, which is a Customer Service Management (CSM) application.

. Dealing with all the Socs, Services, Bans and IMEI and SIMS with

different environments, depending on the Monthly Builds.

. Working to retrieve different types of data for different environment

using SQL Server database.

. Very close intimate work culture with the Developers, discussing day

to day defects.

. Before released to QAT group, testing extensively in the PST group.

. Working with the Automation projects of the QuickView Application

using Flex Monkey.

. Simultaneous work culture with both PST(Production support ) and also

with the Automation Team.

. Leading and Working extensively with the Production supporting QA

group.

. Working with the Customer Service defects from the Production.

. Working to retrieve different types of data for different environment

using SQL Server database.

. Very close intimate work culture with the Developers, discussing day

to day defects.Before released to QAT group, testing extensively in

the PST group.

. Working with the Scrum Master and other offshore team.

. Working with the Automation projects of the QuickView Application

using Flex Monkey.

. Providing them with the data or any software help in the early hrs of

eastern timings to match with the offshore team., Wokring with the

sanity and communicating with the CSM team also with Jira, internal

supporting and in-build T-Mobile application of all the defects.

. QC 11 is the day to day defect tracking along with the Jira(overall

application for the T-Mobile).Dealing with the weekly build, sanity

testing.

. Communicating with the CSM team.

. Leading daily scrum Meetings and also defect meetings for the

production based issue. .

Environment: Web 2.0, Quality Center 11 (Test Director), Quick Test Pro

11.00, XMPP, Agile, RUP, UAT, SQL Developer, Putty, SQL NAVIGATOR, Sun

Solaris, HP-UX, Oracle 10G/11G, QTP, Flex Monkey, SQL Server, T-Mobile

Tools for IMEI.

AT&T Lindberg, GA Encore QA Analyst/LEAD (Contract through Epitech)

July 2010 - Sept 2012

In the process of competing with the Google Voice, Skype and VoIP, AT&T is

coming up with the embedded web based application called Encore. Basically

this application is for the smart phones like Android, iPhone and the

blackberries later to BMP (BREW mobile platforms).

Responsibilities as Quality Analyst (Contractor):

. Working with the Unified Inbox and the Address Book in the 4G

technology

. Extensively involved in completing the Requirements Doc, gathering and

analyzing before test case writing.

. Created the test cases from scratch and provided team co-coordination

to complete all test cases ahead of weekly test cycles start.

. Successfully completed and executed Warehouse Management System Test

Cases.

. Proactively analyzed test cases with cross functional team leads and

managers and shared weekly cycle's defect tracking status.

. Successfully executing test cases for telephone line transmission,

SMS/MMS, Audio, Video, and webcam pictures by executing series of

tests such as Unit, Regression and System Integration Testing (SIT),

Stress and User acceptance testing (UAT), pre-prod and prod

certification testing.

. Tested with different levels of the stage environment with the femoto

cell to get the signals onto mobile.

. HUI Testing is done with Femoto cell.

. Recording Voice Message and testing it before and after sending.

Recording Video calls and testing it before and after sending

Successfully executing test cases for telephone line transmission,

SMS/MMS, Audio, Video, and webcam pictures by executing series of

tests such as Unit, Regression and System Integration Testing (SIT),

Stress and User acceptance testing (UAT), pre-prod and prod

certification testing.

. Capturing/debugging data using Firebug and sending across to

development team.

. Testing of the chat conversations, Send Receive Picture messages, MMS,

sending sms from the chat, calling from the conversation,

Notifications.

. Involved in end-to-end testing for the Mobile Applications.

. Multiple sets of data along with SMS, MMS, Video, Voice and Emoticons

are tested in all the environments like QA, SIT and Production.

. These are the points u can add in the recent project

. Developed and executing the Test Planning Test Development, Test Bed

and Test Matrix and Test Execution.

. Performed extensive tests by uploading pictures after instantly taking

the pictures and also with the old pictures.

. Recording Voice Message and testing it before and after sending.

Recording Video calls and testing it before and after sending.

. Performing multi-tasking by Working with the Master Number Management

and working with the voice plus, photo attachment and forwarding it.

. Testing after forwarding and again attaching some Emoticons.

Thoroughly testing the emoticons, with direct selection and also with

the short code typing. Working with the Jmeter with the server side

script running.

. Loading the Jmeter scripts for SMS/MMS, MMS with vcard.jmx files, MMS

with vCal, EP1 Inbound services, BSCA Services.JMX, Metaswitch, Jmx,

Login.jmx.

. Created Regression test scripts and developed reusable scripts to test

the functionality of the application developed in XML for ORACLE and

Windows. Attending meetings with Business/BA's/Developer in

BR/SR/FRD/ADD stages and create test cases and train teammates.

Testing all the services through backend server services.

. Create User Define Function, Maintain User define function library for

Automation Scripts.

. Testing with the QTP automation framework mostly with the descriptive

programming of vb script.

. Writing and enhancing the scripts as per the Requirement changes.

Working with the object repositories both local and shared.

. Automated the MMS and SMS concepts with the Data driven framework

using data in the excel sheet.

. Multiple sets of data along with SMS, MMS, Video, Voice and Emoticons

are tested in all the environments like QA, SIT and Production.

. Different options for time recording with min of 1 sec to max of 4 min

voice and video were tested with QTP.

. Design, Document and Gain approval for test Deliverables for Test

Automation.

. Review Test Results to Validate Completion of Testing. Review test

deliverables to ensure compliance to the Test Strategy.

. Analyzing results of performance and stress test execution and

deliverables reviews to evaluate product performance.

. Analyzing test Metrics to determine quality and forecast release

readiness.

. Participated in Peer Reviews and Walkthroughs for SRS, Design, Test

Planning, Test case Specification artifacts, and Source code

. Performed back-end testing using SQL queries to make sure that data

entered correctly into the Source Database.

. Create Regression and Functional Automation Scripts using Descriptive

Programming.

. Created and Implemented an Automation strategy that converted manual

test cases to QTP scripts.

. Created and maintained Virtual test lab Resource via VMware

Virtualization.

. Create User Define Function, Maintain User define function library for

Automation Scripts.

Environment: Web 2.0, Quality Center 11 (Test Director), Quick Test Pro

11.00, XMPP, Agile, RUP, UAT, PL/SQL, SIT, TOAD, SQL Developer, Putty, SQL

NAVIGATOR, Sun Solaris, HP-UX, Oracle 10G/11G, QTP, Load Runner, UNIX /

Linux Shell Scripts

AT&T Alpharetta, GA QA Analyst (Contract through Comsys)

Oct 2008 - Dec 2009

Responsibilities as Senior Quality Analyst

. Involved in successfully executing multiple Modules, which includes

QPASS, Bad Debt, Manual JE, Roamer, Rollover, VPDP, Warehouse

Management System, commissions and compensations.

. Performed testing on UI (User Interface), PC Client, Middleware, and

web user interface solution.

. Successfully created and executed test cases by utilizing Agile, RUP,

and interactive test procedures.

. Performed system integration testing (SIT) of Web 2.0 applications.

Responsible for messaging protocols including XMPP.

. Prepared the Setup scripts and uploaded the test cases into Quality

Center. Worked on Manual JE testing both SIT and with UAT.

. Uploaded the test scripts for testing in MPQA1 (SIT environment),

MPQA2 (UAT environment), MSQA6 (Pre-Prod and Prod).

. Prepared the SIT test summary.

. Worked extensively with the performance test plan for Roamer and

manual testing projects, VUGEN scripts, and its enhancements.

. Extensively worked on performance test cases for manual JE process and

Roamer project.

. Wrote the test cases and worked with testing and defect tracking with

the java based application.

. Extensively used Web based application (ASPEN) for MANUAL JE testing

and created new featured Manual JE in Phase 3.

. Tested the breadcrumbs, navigation, and content on the web page and

also compatibility check and orphan pages.

. Extensively worked with the commission agents projects including VPDP.

. Worked with Crystal Reports for the report generation and testing.

Attending meetings with Business/BA's/Developer in BR/SR/FRD/ADD

stages and create test cases and train teammates.

. Worked with commission and compensation projects in VPDP.

. Participated in BRD and FRD meeting with users. Working with the NFRD

test cases. Defect tracking and discussion about the defects with

developers. Leading up all Test Efforts across the Board for

business.

. Analyzing test Metrics to determine quality and forecast release

readiness.

. Responsible for creating risk analysis reports, test plan, test data

specifications, test matrices, test results, test status reports and

final test reports. Retesting the fixed defects. Worked on Flat

files.

. Worked very effectively and efficiently with ATDD development

methodology (Agile Methodology).

. Checking the mappings in Informatica 8.6 and analyze the sources and

target mappings how the data is transmitting and write test cases on

these mappings. Check the source vs. Target based on the mappings

done in Informatica and make sure all the required data populated in

target tables based on the Filter transformations used in Informatica.

. Wrote test cases on Informatica data flow (how the data is populating

in Target tables from Source using different transformations).

. Wrote the whole project test cases single handed. Worked with the

developers and Business Analysts.

. Opened and maintained the defect tracking and retested the defects.

. Aggressively used the SQL Developer for the Backend testing. Used

ASPEN front end JAVA APPLICATION for testing.

. Set up the entire environment for testing. Wrote the full QPASS

project test cases single handed.

. Prepared the setup environment document and set up the entire UAT

environment for testing.

. Extensively worked with developers and fixed all the opened defects.

Environment: Web 2.0, Quality Center (TestDirector), XMPP, Agile, RUP,

UAT, PL/SQL, SIT,TOAD, SQL Developer, Putty, SQL NAVIGATOR, Informatica

8.6, Sun Solaris, HP-UX, Oracle 10G, Informatica, QTP, LoadRunner, UNIX /

Linux Shell Scripts

VNC, GA QA Engineer/ETL (Contract Through Santinfotech LLC)

Sept 2007 - Aug 2008

Responsibilities as Senior Quality Analyst

. Utilized Agile, RUP, and interactive test procedures. Conducted UI, PC

Client, Middleware, and web user interface solution testing.

. Conducted QA trainings on both Manual and automated tools including

Quality center, WinRunner, QTP, and LoadRunner.

. Dealt with the interface level testing as the data which is being

updated during this time must be automatically entered into the new

system basing on the old. Responsible for component testing,

integration testing, and regression testing.

. Analyzed and compared actual results against expected results and

worked with developers in researching and fixing the defects.

. Developed and executed SQL Queries to perform the VNC backend database

testing using TOAD.

. Gathered the surveyed information about the construction material and

also the information on labor charges and filled the quote and tender

application.

. Worked extensively with compensation and payroll which is involved in

managing the base pay, commissions, overtime pay, bonuses, profit

sharing, merit pay, stock options, travel / meal / housing allowance,

and benefits including dental, insurance, medical, vacation, leaves,

retirement, and taxes.

. Extensively worked with the synchronization of the old and the new

systems, as the new system is been implemented in the Railway

Blasttress track for railway. Reported and tracked the problems and

defects with the Trans world garnet project.

. Involved in testing the quote and tender of the Synergies automotive

limited for wheels manufacturing and oil seed processing companies.

. Involved in the extra wages quotation generation and extensive testing

the application according the state and city wise taxes.

. Working with PM/BSA and Development team on ETL process.

. Involved in BR/SR/Design phase of SDE, SIL and PLP process in ETL.

. Created the test cases and test plan for SDE, SIL and PLP process in

Informatica 9.0.1.

. Validating the Source systems using DBLinks and also through

Informatica ODBC/Relational connectivity to see how the metadata was

pulling into Target system and Validate the Data pulled from the

Source Vs. Staging tables in Target.

. Validate the Join Queries in Source Qualifier to make sure the data

pulled to Target Staging tables are accurate.

. Check the Naming standards for Dimension Staging, Dimension, Fact

Staging, Facts and Aggregate mappings.

. Check all the mappings if the column population is accurate or not

including both Input and output ports for all transformations to make

sure the columns are populating as expected.

. Validate the data in Dimension and Fact tables by checking the Staging

tables for Dimension and Facts in SIL process.

. Validating all mappings, Work flows in SIL process.

. Validating the PLP loads after SIL process.

. Checking the Parameter files and values generated through DAC into

Parameter files in Unix environments for all Dev, QA and UAT

environments.

. For production issues, access the parameter files in Production Unix

server and validate the flow from SDE to PLP to make sure the issue

got resolved.

. Used Toad/SQL Developer tool to check the output of SQL queries on

Database to validate source Vs. Target data.

. Validate the Error tables (_DSE- Dimension Error, _FSE-Fact Error

table) and check the Row wid's to make sure these are really errors.

Sometimes we need to check the Archive tables in Source side as Source

will keep the data for 6 months or 2 yrs depends on RIM policy of the

company.

. Validate the Audit queries and output to compare how many records are

fetching from the Source into Target based on Full Load or Incremental

loads.

Environment: Web 2.0, Quality Center, Informatica, Unix, SQL(Toad/SQL

Developer) Agile, RUP, Win Runner, Load Runner, QTP

Amdocs, GA QA Analyst (Contract through Aurora IT)

June 2006 - July 2007

Responsibilities as Quality Analyst:

. Performed test case creation and execution. Performed system

integration testing of Web 2.0 applications.

. Utilized Agile, RUP, and interactive test procedures. Worked with the

CSM WinRunner TSL scripts.

. Executed positive and negative test cases with valid and invalid data

using Quality Center.

. Reported, tracked, and reviewed the defects using Quality Center and

Focus.

. Involved in running test scripts under component testing, weekly

system integration testing, and regression testing.

. Enhanced the scripts using relevant functions and modifying according

to the needs of the CSM.

. Created BANs, cancelled the ban, and resumed the cancellation.

Developed different scripts in the version of 9.4 of CSM.

. Created the BANs, calendars of the API, and SODs, and executed the

APIs.

. Performed successful execution of APIs in different markets like OKC

(DE18), DB46 (STL), and several other markets.

. Set up the whole system for the UAT testing and worked closely with

the UAT group.

. Assisted UAT group in all the issues and the data issues and the

defect tracking issues.

. Analyzed and tested the Amdocs Suite (combination of telecom billing,

cable billing, order processing, along with customer relationship

management modules) by assuring the overall quality of the products

under test.

. Created, modified, and tested the XML files based on requirements

using API Tester.

. Created and modified test data in MS Excel Spreadsheet for XML files.

. Extensively involved in testing of various DDP modules (order

processing, director maintenance, personnel maintenance, money

processing, and reports). Analyzed and compared actual results

against expected results.

. Developed and executed SQL Queries to perform ABL and BCS backend

database testing using TOAD.

. Developed and executed SQL CI statements to validate DDP backend

database.

. Participated in the daily and weekly scheduled meetings and discussed

the status, enhancement and modification request issues.

. Worked with developers in researching and fixing of the defects /

problems.

. Tested the API for different scenarios using different ports for

different environments including DP1012, DP104, locking the tables,

and creating XML. Tested the CPAC tables (Customer Product and

Charging) functionality in order to track charging activities for

recurring products purchased by customer.

. Dealt with the problems encountered while testing the AR (accounts

Receivable) and CPAC tables not getting populated whenever the API

Invoker is not upon running.

Environment: Quality Center, Agile, RUP, Win Runner, Telegence, API

scripts, TOAD, PL/SQL, SQL NAVIGATOR, Sun Solaris, HP-UX, Oracle 8 / 8.1.x

/ 9i, QTP 8.0, UNIX / Linux Shell Scripts, IBM AS/400, DB2/400, DBU, DFU,

WRKQRY

Cingular Wireless, GA Lead QA Analyst (Contract through Globalrely)

Mar 2005 - May 2006

Responsibilities as Quality Analyst:

. Performed test case creation and execution.

. Used advanced concepts on Win Runner and Quality Center (Test

Director).

. Utilized Agile, RUP, and interactive test procedures.

. Analyzed Test Plans and Test Cases based on Requirements and High

Level Design Documents.

. Involved in both Manual and Automation Testing.

. Performed Functional and Regression testing and load testing on

different platforms.

. Understanding the business concepts and process flow existing in the

legacy system and methods followed to maintain daily, weekly or cyclic

activities.

. Analyzing the charges available at the back-end Oracle tables after

the Billing process for their correctness. Creation of mass customers

and attaching different services through customer interface to test

all the functionalities that needs to be supported in the new system.

. Involved in performance testing, integration testing and Backend

testing.

. Attaching resources like IMSI, MSISDN through CARE front-end tool.

. Maintained Test Matrix for latest test results information.

. Using SCRUM Agile Methods. Tested rollover minutes test cases and

QPASS problems.

. Responsible for functional testing 3G TECHNOLOGIES for Video Share

Calling.

. Responsible for provisioning the services for the mobiles.

. Used Switch Control to provision the network elements which are the

main part of the AMDOCS billing system.

. Worked with the regression testing most of the markets including NY,

INDIANAPOLIS, DCS.

. Worked with the Kintanas of 37866 (3G technology) and 37233 with all

the IMS Infrastructure Phase II.

. Worked with the voice bundle testing and also parental control.

. Put in the defects tracks using the Protrack and Team Track and

contacted the project leaders, project managers, and developers.

. Reviewed the log files and validated the status of the testing and

pulled the data from IBM AS/400 to check the AMDOCS Projects.

. Dealt with both Care application problems with the trouble queue and

also with Switch Control problems and trouble shooting.

Environment: Web 2.0, Quality Center (TestDirector), Agile, RUP,

WinRunner, QTP, PL/SQL, Oracle, UNIX, IBM AS/400, TOAD, SQL NAVIGATOR, Sun

Solaris, HP-UX, Oracle 8 / 8.1.x / 9i, UNIX / Linux Shell Scripts, IBM

AS/400, DB2/400, DBU, DFU, WRKQRY

Datamatics GmbH, Germany (Developer/Lead QA Analyst)

Aug 2001 - Dec 2004

Responsibilities as Quality Analyst:

. Extensively worked on WinRunner, Quality Center (TestDirector), and

QTP. Performed test case creation and execution.

. Tested (Unit, Sub-System, System, and Integration) using the Quality

Center (TestDirector) with statistical analysis and review.

. Used SCRUM, eXtreme Programming (XP), and DSDM (Dynamic Systems

Development Method) Agile Methods.

. Responsible for coding and maintenance of PL/SQL programs, clearing

the user's needs and problems instantly, and fixing the bugs as per

their requirement, and maintaining the interface level.

. Dealt with the interface level programming and automatically entered

the data into the new system basing on the old.

. Put in the defects tracks using the Protract and Team Track and

contacted the project leaders, project managers, and developers.

. Performed all levels of testing using both white-box and black-box

testing techniques.

. Validated the log files and to make sure all tests executed

successfully. Reported the status back to management.

. Worked with the regression testing for most of the markets including

NY, Stuttgart, Karlsruhe markets.

. Responsible for modifications in the front end and other databases of

old model which is not that user friendly are being changed to the new

model and also made much user friendly with the use of

. Used TOAD to make databases user friendly. And used UNIX / Linux Shell

Scripts.

. Customized the Rater module using C++ and XML to support any product

specific functionality.

. Analyzed and coded various schemas and PL/SQL procs to map data across

these schemas to maintain integrity among systems. .

Environment: Quality Center (TestDirector), Agile, PL/SQL, TOAD, SQL

NAVIGATOR, Sun Solaris, HP-UX, Oracle 8 / 8.1.x / 9i, WinRunner 7.6, QTP

8.0, UNIX / Linux Shell Scripts

CSC, Corporate Service Corporation, NY, USA (Programmer/Lead QA Analyst)

Feb 2000 to Jul 2001

PROJECT# 1

Worked on Accounting and Finance packages Testing tools, Win Runner, Test

Director, QTP and also wrote TSL Scripts and involved in running Load

Runner, Unix Shell Scripting, and IBM AS/400.

PROJECT# 2

Worked on the company scalable web-based transaction application system

(www.incspot.com), which serves corporate attorneys, secretaries and Para

legal matters The IncSpot provides an easy-to-use interface to ordering and

filing preparation services for CSC clients as well as testing whole

application using Win Runner, Load runner and QTP and creating Manual Test

Cases using Test Director and also stored all documents and test cases

imported into Documentum tool.

PROJECT 3: Order Entry Interface Module: (PL/SQL programming and testing

the applications)

In this module designed and developed PL/SQL programs, that deals to map

that data and migrated the large number of services between the existing

legacy system and the new database. Studied the old and new database tables

and created the prototype. After finishing of the modules I have tested

all modules using Win Runner, QTP and created Test Cases using Test

Director and also performed performance testing using Load runner.

Checking for number of hits on Database and time taken by each module using

Load runner

PROJECT 4: Filing Preparation Module: (PL/SQL PACKAGES Maintenance,

Development & Testing)

This module consists of three different services, Qualification, Uniform

Commercial Code and Change of Agent. It is an intense data driven

application generating dynamic HTML and JavaScript pages using PL/SQL, SQL

and dynamic SQL, WSGL and HTP libraries. Worked on PL/SQL packages to

enhance the product with new features, enforce business rules and implement

data validation.

PROJECT 5: Knowledge Base Interface Module: PL/SQL PROGRAMMING

This module handles the data across multiple projects and multiple database

schemas for the services newly added to the system. Analyzed different

schemas and wrote PL/SQL procedures to map data across these schemas.

Responsibilities as Programmer Analyst

. Actively reviewed Business Requirement Documents (BRD) and the

Technical Specification.

. Successfully developed the Order Entry interface module using PL/SQL

and Unix shell scripts by creating various data tables.

. Created parameterized test scripts for data driven tests. E-mail

import tool - Used SQL Queries & Stored Procedures for customer

information validations before inserting into production customer

database.

. Responsible for reporting bugs to the corporate Bug Tracking System

(Test director) & verifying known bugs against new builds. Worked with

developers & other QA Engineers to address testing issues in a

proactive manner.

. Involved in user acceptance testing & general site validations of web

page objects such as HTML links & images. Tested the application

functionality by using multiple browsers such as Netscape Navigator,

Microsoft Explorer on multi platforms and interpreted the

negative/positive results. Simulated customer real world situations

i.e. Customers shopping experience.

. Expert operations on IBM AS/400 and Unix Shell Scripts. Also expert

in Vi Editors.

. Promotions Functionality Validations: Played major role in verifying

the business logic for various promos like Free shipping, Dollar off,

Percent off, Site wide Etc.,

. Involved in checking the functionality of the system in pre/post

production release processes i.e. Presage, stage, Production &

Disaster Recovery environments. Key member of testing in Product

dailies, weekly Marketing releases etc.

. Responsible for writing test cases corresponding to business

requirements and other operating conditions.

. Created test cases and test scripts for the functional testing and

converted the manual tests into automated using QTP.

. Performed End-to-End testing manually. Used IBM AS/400 to retrieve

data from Database (DB2/400), SQL's.

. Extensively used UNIX Shell Scripting. Extensively worked on Win

Runner and Test Director to created Manual test cases.

. Analyzed functional specifications and provided a structured approach

to all phases of testing. Develop & execute test cases and test

scripts designed to ensure application quality. Used SCRUM and eXtreme

Programming (XP) Agile Methods.

. Environment: Win Runner 8.0, QTP 8.0, Test Director 7.5, Load

Runner 8.0, PL/SQL, Oracle, SQL Server, UNIX, IBM AS/400, UNIX Shell

Scripts, PL/SQL, SQL Server, Oracle Application Server 4.0, Netscape

Enterprise Server, UNIX Shell Scripting, Cold Fusion 4.5, JavaScript,

IBM AS/400 Basic Operations

Tata Consultancy Services (TCS), India (Programmer/Analyst)

Feb'98 - Dec'99

Project 1: Year 2000 project for Guardian Insurance

Project 2: Year 2000 project for American Presidential Line (APL)

Responsibilities:

. Performed the phases of Analysis, Conversion, and Testing of the

project using TCS tools like CAT, ID and MOD. Using the CAT tool

generated a global file with all attributes and relationships of the

program modules and various reports of date and non-date fields. This

global file is then supplied as input to the ID tool and generated the

control file, which in turn is used as input to the MOD tool to

finally create the converted program. Performed manual checking of

the converted program for date fields by tracking the comments written

by the MOD tool Performed system and unit testing using fixed window

technique and observing the control flow within the program

. Performed the analysis phase of the project by preparing the checklist,

and cat parsing the data to generate ATR and RLN of both program and

copybooks. Checked and verified the reports generated by the JCL's of

BATQMF and BATSPUF modules for the confirmed and undecided date and non-

date fields and finalized the date and non-date patterns.

Environment: COBOL, TCS Tools - CAT, ID and Mod, TCS tools - CAT, ID

and MOD on ES9000.

Contact this candidate