Wored asLead, Business Analyst, Production support and UAT/BAT support
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*: ******.**@*****.***
*
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
Contact this candidate