Post Job Free

Resume

Sign in

Wored asLead, Business Analyst, Production support and UAT/BAT support

Location:
San Jose, CA
Posted:
September 18, 2014

Contact this candidate

Resume:

Hi,

This is Prathyusha, I am having * years of experience in Software Analysis,

Testing and Support.Currently Working with Cisco systems, San Jose, CA I am

very much comfortable for this position.Please consider my profile for this

position.

*Prathyusha Danda *

*Email*: acf0qe@r.postjobfree.com

*

Ph: 507-***-*****

*PROFESSIONAL SUMMARY*

- 8+ years of experience in Software Quality Testing in Retail, Banking

and Financial industries.

- 3+ years of experience in Oracle applications 11i and R12 (Financials,

OM, AR, AP, Inventory, Revenue).

- Extensive experience in Oracle E-business Suite applications involving

Order Management, Inventory, Shipping, Financials modules – General Ledger,

Accounts Receivable, Accounts Payable and Revenue Recognition.

- Experienced in preparing the Project Plan, Test Plans for all levels

of testing, BAT Test Cases, Test Scripts, Test Data from requirements and

Use cases.

- Experienced in set up environments and test executions.

- Worked on extensive Functional Testing, System Testing, Sanity,

Boundary, Positive, Negative, Integration, Regression, Compatibility,

Security, User Acceptance, Cross-Platform and Performance of stand-alone,

Intranet and Internet, web based, & Client-Server application.

- Strong experience in organizing and conducting User Acceptance Testing.

- Experience in Setting up Defect Life cycle Management processes by

using tools to ensure compliance with internal and external audit

requirements.

- Experience in automated Mercury tools like Quality Centre, Quick Test

Professional, Test Director and Bugzilla.

- Involved in MDM deal creation and Quote creation process through SFDC

(Sales force.com).

- Created Product and Service orders in OM and performed validation on

Invoices and involved in Revenue Recognition process.

Involved in Data pulling from the Automation tool for creating

the Service Renewal opportunities.

- Strong skills in back-end testing using SQL Queries on SQL SERVER and

Oracle.

- Experience in interacting with developers, technical support and

gather all the baseline requirement specifications.

- Interacted with developers and product analysts regarding Testing

Status, Defect and Change Tracking using Quality Center QC.

- Identified the test cases to be automated and developed scripts using

QTP 9.2

- Experience in creating TRR (Test Readiness Review), TCR (Test Closure

Review) and Traceability Matrix.

- Having good experience in Onsite and offshore model and Leading

offshore teams.

*Technical Skills*

*RDBMS : * Oracle 9i/10g/11g, R12,

SQL Server 2008/2005/2000.

*ERP Modules : *AR, AP, GL, OM and Revenue

recognition.

*Testing Tools :* QC 9.5/9.2/9.0,

QTP9.5/9.2/9.0, Test Director, Bugzilla, and JIRA.

*Languages : *.Net, VB6.0, Java, VB

Script, Java script, HTML, XML, SQL, Pl Sql.

*Operating Systems : *Windows 95/98/2000/ NT/XP, UNIX.

*Bug Tracking : *Mercury Test Director, Rational

Clear Quest, Quality Center.

*Office Software’s MS Office (Word, Excel,

PowerPoint, Access).

*Front end tools * * :* Sales force, Tableau

Desktop 8.1, BI, and 360 IB Click View.

*Education & Certification*

*Bachelors in Computer Science (J.N.T. University, India).*

*Professional *Experience:

*Cisco Systems, San Jose,

CA

Feb 14 – Present*

*CPAI Analyst- Cisco Partner Annuity initiative *

Cisco’s CPAI Portal generates $300 million dollar business, by

creating Auto Quotes for low dollar opportunities via the Renewal

notifications for all expiring contracts. Cisco’s CSCC creates the quotes

and converts them into order and Invoice gets generated and revenue

recognized in the Oracle ERP system.

*Responsibilities: *

Working in Cisco Service Factory Floor team as a SME for

resolving revenue impacting issues and supporting Cisco 1-Tier and 2-Tier

partners.

Perform analysis for Auto Quote failures and drive the issues

towards resolution.

Auto Quote Data mining and data analysis.

Involved in retrieving the data using filter from IB click view

and run the Reconciliation reports.

Prepared report for the Quote Failure Analysis and Partner

performance Dashboard reports using Tableau for better Visualization.

Determining Cisco’s Partner issues to resolve the auto quote

problems.

Worked with multiple cross functional team members on the root

cause to fix the issues or being added to the Enhancements list.

Involved in the Quote Failure analysis through Request and

response B2B XML files.

Worked on analyzing automated issue resolution capabilities.

Daily prioritize the open issues and update the case notes in Bug

tracking System.

Sending weekly status report with the latest updates to the

Management.

* Environment:* CSCC, SMS3, SCM, XML,TOAD, SQL Server 2008,

Tableau Desktop 8.1,

Mantis Bug Tracker, SCM, Teradata, EDW, C3, 360 IB View.

*Cisco Systems, San Jose,

CA

Jan 11 – Feb 14*

*QA Lead*

Test Analyst in NGCCRM project and involved in Revenue deferrals and

revenue recognition process. Involved in Revenue accounting engine (RAE)

and Reports testing and UAT support. The core modules are Hold/s

processing, Revenue recognition, Reports and Data Migration.

*As an Onsite SME*:

- Analyzed Business Use Cases, Leading Offshore team in Business

functionality explanation and help team to create Test scenarios and Test

cases and support.

- Work with Business Analyst for reviewing the Scenarios and cases As an

Onsite lead, and make sure the corresponding changes are done by the team

and upload the Test cases into Quality Center.

- Involved in preparing Automation Test Plan and Test Cases based on the

functional specifications.

- Help team in Preparation of Test data and executing test cases,

addressed the issues to the development team by using the Quality Centre.

- Responsible for the all deliverables (Test Case, Test Scripts, Test

Data, Traceability Matrix Test, Defect Reports, Execution reports).

- Worked closely with functional team to understand the each form

functionality in Hold, Revenue holds and Manual adjustments.

- Associated Requirements to Test Cases (Maintained overall

traceability) in QC and Share Point.

- Preparation of Consolidate Bug summary reports and Test Summary

reports in Excel.

- Order creation in Order Management (ERP – OM) and Revenue accounting

in AR.

- Order Management (OM )mappings and validations.

- Worked on Data mappings (Source-Target).

- Involved in running the Batch jobs in ERP front end.

- Involved in creating purchase orders using ERP forms.

- Checked for the Database Integrity using the SQL Server.

- Experienced in AR/AP/GL and Revenue accounting and Revenue Transfer.

- Performed testing the applications compatibility on Windows

environment.

- Involved in E2E process (Order creation, SCM, Invoice generation to GL

postings) in EBS R12 implementation.

- Worked with UAT and support group.

- Involved in weekly status meeting and walkthroughs for project status

and updates.

*Environment*: Oracle ERP (OM, AR, AP, GL, and Revenue), PO, XML, MDM,

SFDC, CMS – Contracts, QC.

*UPS.com, Timonium,

MD

Oct 10 – Jan 11*

* QA Analyst*

The Customer One Event Manager initiative takes advantage of UPS’ extensive

package information to provide limited, Specialized, fee-based services to

customers. The first phase of Customer One (C1) focuses on shipper

Initiated Intercepts. While these intercept situations can be handled

within the normal operational processes, C1 will add value through

information and Tracking capabilities.EVM manage the flow of incoming C1

Delivery Change Requests.

*Responsibilities: *

- Analyzed Business Use Cases, creating System Integration Test Cases,

Test Scenarios, and Executing and addressed issues to the development team

by using Quality Centre for C1EVM, DCR, UDC and SPA applications.

- Responsible for the all deliverables (Project Plan, Test Plan, Test

Case, Test Scripts, Test Data, TRR, TCR, Traceability Matrix Test, Defect

Reports).

- Worked closely with functional team to understand the each form

functionality in EVM, DCR, UDC and SPA applications.

- Associated Requirements to Test Cases (Maintained overall

traceability) in QC and Share Point.

- Preparation of Consolidate Bug summary reports and Test Summary

reports by using Quality Center& Share Point.

- Responsible for SIT environments.

- Upload the all deliverables (*Test Plan, Test Cases, Traceability

Matrix, Daily Reports and Test scripts* )in Share Point and Quality

Center(QC).

- Performed *Smoke,* *Adhoc,* Functional*, System, Regression, UAT*

and end-to-end

testing*.*

- Created Release management notes at the end of System testing and

*UAT.*

- Created XML files for the Intercept messages.

- Executed automation scripts using *QTP* in order to perform regression

testing.

- Performed testing the applications compatibility on Windows

environment.

- Used Serena Team Track (mashups) for defect tracking.

- Involved in weekly status meeting and walkthroughs for project status

and updates.

*Environment*: .NET, VB6.0, VB Script, QTP, QC, CME simulator, XML, HTTP,

FTP, SQL Server2008.

*US Bank, Minneapolis, MN*

*Nov 09 – Nov 10*

QA - Analyst

I worked as QA Analyst and involved in more than 2 different applications

like Statements & Reports, Payment Rewards – Credit Card Process, Bill

Payment, Portfolio Management Reports, and Online Portfolio Review are

developed in different technologies and different databases.

*Responsibilities*:

- Preparation of Test Plan and Test Cases based on the requirement

document.

- Preparation of Test Requirement Traceability document.

- Test Case Execution and reporting the bugs in Product Studio – The bug

tracking tool.

- Performing Functional, Sanity, Integration, Regression, Compatibility,

and Security Testing.

- Perform the Data Base testing by using SQL queries.

- Preparation of Consolidate Bug summary reports (Operating System wise

and Severity wise) and Preparation of Test Summary reports.

- Conducting weekly conference calls with the team to discuss the

projects progress and the issues.

*Environment: *Quality Center, .Net, UNIX, Java Script, HTML, XML, SOAP,

Web logic, Oracle, DB2, SQL Server.

*Varnar Softech Pvt Ltd.,

India

May 06 – Sep 09*

* Test Engineer*

Team Connect Enterprise is a Web-based platform specifically engineered to

optimize the allocation of resources (people, intellectual capital and

time), functions, and processes of manually intensive industries,

organizations, and departments. TeamConnect Enterprise will enable you to

connect teams, coordinate their work, and manage their collective knowledge

throughout the enterprise.

*Responsibilities*:

- Analyzed business requirements to come up with Test Plan and Test

Cases.

- Performed Back end testing using SQL queries to *verify and validate*

data.

- Participated in *Defect Review* meetings.

- Developed the Scripts for the Scenario's being assigned.

- Involved in various phases *Software Development Life Cycle*.

- *Summarized & reported* the defects found during the execution.

- Executed all test cases manually based on test scripts and validated

results using *SQL Queries*.

- Performed *Manual Regression Testing*. Update of datasheet during

regression testing.

- Verified the Scripts generated by the team in accordance with the

Checklist.

- Involved in preparation of Test cases and executing them using Test

Director.

- Attended Joint Application Design sessions and worked on Business as

well as System Use Cases.

* Environment:* TCMS1.5.1, J2EE, JavaScript, Test Director HTML,

XML, SQL Server 2000.

Thank You,

Prathyusha

507-***-****



Contact this candidate