EXPERIENCE SUMMARY:

• 7 years of experience on Oracle financial QA testing.(E-Business Suite) FA, PO, OM, INV, A/R, A/P. G/L.BOM, WIP,I Procurement.
• 3 Years of Structured Integration, System and Performance Testing experience in Financial,(A/R, A/P. G/L) Health care InsuranceBanking, Manufacturing, Departmental Warehouse Management System, Human resources in a Client Server/Environment, /ERP/Oracle.
• Internal users and external customers can view bills online using Oracle Receivables, Oracle receivables, Oracle Collections. or other calling application.
• Interacted with Functional and Technical Teams in highlighting deficiencies
• Prepared Test Plan Formulation, Test Scripts and Test Cases for each test cycle.
• Participate in the analysis, development and review of test plans, test cases
• Manualandautomated testscript design and development using Winrunner, Testdirector, Loadrunner, QTP 9.2, Quality Center. CVS Version control.
• Hands on experience in designing manual test scripts and Test development life cycle .creates and updates defect tracking logs and works with development teams to ensure that all defects
• Involved in Database testing usingSQL Statements and Queries.
• Experience in testing under Windows 95, 98, 2000, NT, XP, IBM Mainframe and Unix environments & Sunsolaris
• Experience in testing various methods includingValidation, Verification, Functional, Integration, End to End testing Performance, Graphic User Interfaces (GUI), Regression, System, Recovery, Volume, Load and Stress, UAT
• Involved in Black Box, Grey Box and White Box testing.
• Experienced in understanding Test plan. QA Process, SDLC and other methodologies Solid understanding of relational databases and SQL.
• Creates and maintains test plans and scripts, and carries out hands-on testing efforts both manually and using automated test tools.
• Good troubleshooting skills and excellent communication skills.
• Experience in writing validation code i.e. SQL statements for data selection.

TECHNOLOGY EXPERTIES:

• Languages: C,C++, SQL, PL/SQL, TSL and Linux, Unix Shell Scripts
• ERP: Oracle Financials 10.7/11/11.5.10, R12
• Oracle ERP modules: A/P, A/R, FA, GL, ,CRM, Order Management, OTC,P2P, HR Benefits, Install base and Manufacturing, Warehouse management. procurement, I Expenses,
• Databases: DB2, Oracle, MSSQL,and MS Access.
• Operating Systems: Windows95/98/NT/2000,XP, Unix, Linux and Solaris.
• Testing Tools: Compuware, Winrunner,Testdirector,Quality centerLoadrunner,QTP 9.5,Silk Test, Rational Robot.
• Business Tools: MSWord, MS Excel, MS Power point & MS Project, Visio, VB scripts
• Defect Tracking Tools: BugZilla,Test Clear Track pro, Clear Quest, Mercury-Test director, Quality center.9.5
• Web Technologies: HTML. XML, VB scripts
• Graphic Tools: Photo Shop
• Reports: Crystal reports

PROJECT EXPERIENCE

Confidential September 2011 to present
Roanoke VA
WMS Red prairie QA Analyst

Inbound testing R1
Receiving: Receiving the trailer, check in trailer doors, creating master receipts and adding SKU's,
Source location is the receiving sorter. Each location is tied with Zone. Manual decision to close the location- Pallet full or decide to close when finished.
Receiving sorter: RECIND -A, Non-Conveyable, Conveyable and Conveyable with help
Put away work: Consolidation on operation code, source location, work zone and destination location
Work Zones (64): Determine where the work goes. Storage area: Drive storage around the warehouse
Reserve MOD- Stock Picker. Pick MOD: Reach truck

• Analyzing the Business Requirement and process flow documents, from test plan created test cases.
• Working with the configuration team to set the configuration for Red prairies application
• Working with system testing team to create data as per the test cases.
• Executing the system test cases and reporting the bugs to the management
• All the defects in the WMS is logged in Test Director and attending the test case status meetings
• Working with various business stake holders to resolve the WMS testing issues.
• Writing SQL queries to find the data and create a data using LEXEDIT
• Executing the regression test cases and finds the results.
• Received the goods through GUI and PUTTY
• Participated in integrated testing.

Environment: Pl/SQL, RED Prairie DLX version 2010.1.0.13, Test Director Version 8

Confidential Lynchburg, VA 7/2011 - 9/11
WMS Red Prairie QA Analyst

Confidential a retail company selling clothes of various international brands. There Order comes from call center, website (Blue Martini) through integrator and finally comes to WMS (Red Prairie)

Responsibilities:

• Writing test cases based on the business requirement and technical documentation.
• Creating JCDM (Jcrew Document Management) and screen shots of test cases.
• Based on the every week rollout have to retest the scenario
• Creating a wave , plan, allocate, release, shipment display, report operations , pick list, Pack and move , release manifest , small package operation if it international shipping, international shipping operations and shipping dock operations for the wave created in various environment like LYNQ, LYNJ and LYNX
• Tracing will be done at each and every step.
• Tested on single wave, Multi line wave, Gift box, Gift card testing using PUTTY to serial the items and release manifest in DLX(Red Prairie) ,
• Selecting a wave with various hubs with various service levels. Getting printer certification for various UPS labels like UPS Ground, UPS 2nd, UPS Next day and UPS Priority.
• Worked on Local orders and International Orders
• Worked on MOCA Commands using Command Server operations and helping production support.
• Integrator. Finding the shipment results Printing pick ticket and testing Size zero items. Validation of wave and pick labels.
• Executed functional and regression testing on WMS.
• Wrote SQL server queries to check the results.
• Validated the results from pick and pack list.
• Tested New DDA Reports and DDA

Environment: SQL Server 2005, RED Prairie DLX version 2007.1.0.13

Confidential Winston Salem NCMay '10 - June-11
QA Analyst

CUSTDW (Customer Data Warehouse) is an existing data warehouse containing heterogeneous data of Wells Fargo Legacy Customers using wholesale/Treasury Management products. Currently the Wachovia accounts are employed to this data warehouse to help Merger Transition Customer View team to serve customers better. The CUSTDW development team has provided the even driven framework to support ongoing merger activity in order to convert customer accounts based on predefined Business Rules.

RESPONSIBILITIES

• Involved in testing of Back End functionalities for different core processes to verify business constraints, Data Validation usingSQL.
• PerformedSoftware developmentlifecycleprocess, developed the system test plans by interacting with cross-functional team to meet end user requirements.
• Reviews and validatedQA Test Planwith functional test scenario using testing methodology by reviewing all test scenarios with internal/external team.
• Involved with developer to understand design of application, process flow and assist development team in unit testing.
• Prepared documentation onvalidating Business Rules/Criteriain formsmetadataand helped other team members to understand the whole process.
• Validating metadata used for variouscore processes.
• Performed sanity testing using post installation check usingrelease notesand identified installation or code initial problems.
• Communicated with Project Management to establish LOE of each phase of SDLC andplanned testing strategy with peer team.
• Involved at performing variousManual Feeds byvalidate data using SQL.
• Identified business requirement gap with customer level and involved in impact of functionality of application.
• Worked independently with the users for requirements gathering and prepare Functional specifications.
• Performeddefect analysisto identify root cause of problems and interact with appropriate team and resolved outstanding problems. Discussed blocking defects with team.
• Assist production support team onrelease nightto complete the testing.
• Performedregression testingfor various modules and core processes to ensure the overall functionality.
• Createddata modifications test scriptsfor several test scenarios to perform negative testing.
• Involved in System Integration testing withexternal & internal interfaceteam and performedE2ETesting.
• Provide data for SIT and tested all interfaces to make sure functionalitiessupports E2E.
• Assisted Production support team to resolvedproduction issues, trained team to develop cross-functional ability.
• Developed plan for cross-functional training with team for knowledge transfer.
• Attended most of the meetings involved the discussion of new requirements/changes in existing functionalities and shared my thoughts to provide best approach to achieve the goal of organization.

ENVIRONMENT:Oracle 10g,Microsoft SQL Server 2000/2005, Toad, SQL Developer, UNIX, MS Office Tools, SharePoint. Toad 10.5. Quality center: 10.5, UAT, SIT, Production Testing

Confidential, Atlanta, GA Sep '08 - Mar '10
QA Analyst

• Analyzing business documents like, functional, technical and Test plans.
• Responsible for gathering information from client, customers, core users regarding the data and business processes and made proper documentation.
• Participated in all phases of Soft ware development and Software testing life cycle.
• Execute and MaintainQTP scripts
• Analyzing business documents like, functional, technical and Test plans.
• Developed and executed different work products Quality Center. Requirement maintenance, Test plan, Test Suite and execution. Design and execution of test strategy, test plan, test cases
• Plan & prioritized manual and automation activities and design and developedAutomation Test Scriptsand manage the testing activities usingQTP
• Developed the Data Driven Framework for maintaining the automation scripts.
• Reusable functions to increase the reusability in the automation.
• Created Data Driven Tests to validate the same scenario with different test data.
• Scheduling and allocating work amongst the team members, ensuring deliverables in time.
• Developed the strategy for Manual Testing of the application and tested the strategy to be client compliant.
• FA: Functional testing of various scripts, Asset manual, quick Additions, CIP Assets, Load ADI Assets (Application Desktop Integrator), mass additions, create JE and reconciliation with GL , Retire and re-instate assets, Depreciation,. Transfer of Various Assets.
• Cash Management Inbound outbound testing: Loading bank statement interface file through FTP, upload files for Asia and Pacific region.
• HP QTP version 9.2-Debit card reconciliation testing of various automated scripts.Recording andEnhancing scripts and creating scripts. Automated testing using the toolsQuick Test Pro,Quality Centertorun bothmanual and automated scripts. Enhanced Test Scripts using QTP features like checkpoints, Synchronization points and parameterization..
• WriteSQL queriesto performdata validationand also wrote queries for Log table and Validate that all order Counts are as expected compare to production. Joints- Union, Intersect and minus. Multiple sub queries, Loops, Triggers

Environments:Oracle version 11.5.10 and R12. UNIX, Operating system: sun Solaris, Database: Oracle 9i Release 2, Toad, SQL with Agile experience. QTP Version 9.2 and VBScript.

Confidential, New York Jul '06 - Sep '08
Lead QA Analyst.

CRM application:Worked with 6 offshore resources. Coordinating to accomplish the job and collecting daily matrix report.

• Creating a DMA (Document Management Agreement) contract database application CDB (Xerox service contract database)
• Create Performance test scripts using Load Runner.
• XONE applicationperformance testby executing theload runner scriptsto get the contract Unit and contract numbers.
• Automated Flex contract is for creating line and service contracts and for creating service, labor, equipment, units and pool contract. ServiceContract, Install basebring this into Oracle XONE application. Creating workup sheet in value quix, Enter service, meter reads and allowance. Correct the contract error and approve from the controller.
• Match and post the contract order from flex process through telnet and enter to Oracle database. Did regression test usingLoad runner.

Manufacturing-Purchasing -P2P

• Creating Test plan. Analyzed SRD and BRD and wrote test cases in Purchase Module. Worked on validating end to end flows and interfacesBlack box testing, UAT testing, InvoiceTransactioncoming from Account payable is tested through interface and view results in web methods.Test conducted on multiple organizations. Requisition, Purchase order, Receiving, Blanket purchase agreement. Validation of Purchase order,I procurement, PO print, PO EDI and PO E-mail purchaser. Checking the purchase order in Approved supplier list- Item is purchasable, approved, stock, enabled and Assigned to an organization.
• A/R: Testing Address validation, Receipts, Adjustments, Invoices Checking the reports.
• A/P: Testing Supplier information, PO. Import invoices, Payments- online, cash, wire payments, PO header, lines, distribution, releases, credit card payment.
• WIP testing: Discrete, Assembly, Repetitive manufacturing, Assembly to order. Shop floor control- Assembly moved to shop floor and controlling. Supply chain module and warehouse Transport management.
• WMS Cycle Count • Internal Order• Internal Requisition• Job or Schedule• Move Order• Purchase Order• RMA• Sales Order
• OTC: Testing the following - Entering the order, booking the order, scheduling the order. Pricing. Testing the line item, pricing list and modifiers.
• TOAD: Querying the date from the front to backend using select command and comparing the results using SQL.

Environments:Oracle version 11.5.9 Operating system: sunsolaris, Database: Oracle 9i Release 2, Toad.
Oracle Apps Modules tested: A/P, A/R, and CRM, Install base and Manufacturing & WM Automated tool likeLoadrunner 9.0&QTP 8.2 and Test DirectorMD 50 Functional Document.

Confidential, NY Sep '04 - Jun '06
QA Tester
Confidential his implementingOracle Apps 11i Accounts Payable Legacy Decommissioning from Mainframe to Oracle App
Confidential In bound file testing A/P with payment. Responsibilities. Creating Master test plan: Writing Overview, Objectives, Goals, Testing data under test environments, system scope, creating Test plan, Test data, Data strategy

• DevelopingTest scripts from Functional and Technical documents.
• Common payment engine for outbound and inbound payments.
• Credit Card support - Validation, authorizationand funds capture.
• Transmission of Bills Receivable transactions
• Bank account transfer support for OracleReceivables and Payables.
• Testing all criticality and functions, provide regular status to project managers, review with developers and technical lead, to ensure software is properly tested
• Oracle Financial Apps interfaceand getting reports
• Using Control-M, FTP from Mainframe to UNIX.
• Testing the data under OAAP-Development environment and Testing environment

Western Union Money transfer: Decommissioning the Mainframe and moving to SQL Server. Every day A& P storetransactions of customer and vendor is sent to IBM to process and make payment to Western Union and generate various reports, such as Daily, Weekly, Division and Group reports. Responsibilities: Creating Master Test Plan. Performing one or more tests, System/Integration test and performance test and Database testing.

• Testing all criticality and functions, provide regular status to project managers, review with developers and technical lead, to ensure software is properly tested, black box testing and UAT testing.
• Smart Database to check the records are stored properly
• Using Control-M, FTP from Mainframe to Unix
• Text data file taking manual Excel sheet to compare the sql server results
• Testing the data under OAAP-Development environment and Testing environment

Environments:Oracle Apps 11.5.9, UNIX, Toad 6.5 Hp OS 5.8, Test Director 7.2, Oracle 9i, SQL Server 2000. Agile experience, Iterations

Confidential, CA Mar '04 - Aug '04
QA Tester

Cisco System implementing Oracle Apps 11i in various modules like Order Management, Accounts Receivable, Legacy Systems and Boundary Systems. P2P, Install base & Order Management.
Order to cash: Customers call the order, check the price, check availability, book order, receive cash, generate invoice, ship confirm and pick release.Procure to pay:Check the price of the vendor, P.O for approval and send the P.O to vendor. Matching and paying the invoice, receive the invoice, item to the shelf or to employee and receive the shipment
Responsibilities

• Going through variousDSD's and FSD's and writing String Test Scripts for Book Order and Create Order manually.
• Writing E2E scriptsand generic scripts.
• Mapping the entire requirement into the Test Case Builder. Participated in Specification reviews and Mapping Documents reviews with Technical staff and Business System Associates.
• Uploading all the String scripts and E2E scripts, Generic Scripts into Test Director.
• Bug fixing all the scripts issues and reports to the management.
• Performed manual functional testing of various business areas.
• Writing SQL queries for fetching data from boundarysystems.

Confidential, TN Dec '02 -Feb '04
QA Analyst

Confidentialhas implemented Oracle Applications 11i and it is integrated to other widely used legacy applications. They have customized Interfaces to meet the business requirements and in addition, many customized Forms and Reports are built in Accounts Receivable (AR) module.Manually testing Insurance forms.
Responsibilities

• Participated in Specification reviews and Mapping Documents reviews with Technical staff and Business System Associates.
• Did Extensive testing of the Customized and Oracle standard Reports before and after Customization.
• Participated in Code review sessions with the developers for production fixes.
• Executed test Scripts for the Inbound and Outbound interfaces to Oracle AR.
• Developed SQL scripts to validate the Oracle Interface and Base tables.
• PerformedFunctionality testing, Stress testing and Regression Testing.
• Participated in Production Check outs and Provide QA support for Production fixes.
  

Environment: Oracle Apps 11.5.5, Sun OS 5.8, Rational Clear Quest, Sun OS 5.8, Oracle8.1.7.4.

Confidential, MO Apr '02 - Nov '02
QA Analyst

Confidential was in a process of implementing Oracle applications and it was integrated to other widely used legacy applications. They have customized Interfaces to meet the business requirements and in addition to it many customized Forms and Reports are built.
Responsibilities

• Wrote test cases and test plans based on technical and functional design documentations.
• Wrote Test Cases and Load Test Plans based on Technical Documents been prepared.
• Developed Load Test Strategy to do performance testing of the applications.
• Performed Load and Performance Testing of critical areas of Oracle Applications module by simulating the load on the system using Load Runner 7.0.
• Performed Load Test of Outbound and Inbound Interfaces.
• Executed test cases created in Winrunner for functional testing
• Used Mercury Test Director for defect documentation.
• Worked on volume testing and stress testing.
• Performed manual functional testing of various business areas.
• Network Load testing was done by generating Network load from various locations and the entire application was load tested using Load Runner 7.0

Environments:Oracle Apps 11.5.6, Winrunner 7.0 Load Runner 7.0, Test Director 7.0, Sun Solaris 8, Oracle 8, UNIX.

Confidential, NJ Mar '01 -Mar'02
QA Tester

This was an application developed for a commercial bank. The complete application covered entry of Cash-In, Cash-Out, Loan Approvals, Wire Transfers, Loans, Financial Cash-flow Statements, Financial Ratio
Statements, Asset, and Equity etc. The product is more focused on Mortgage Home loan schemes and Certificate of Deposits, Facilitated with Home buy ability Test and Mortgage calculators. Involved in Testing of Loans and Certificate of Deposits (Fixed Income) modules.
Responsibilities:

• Written Test Plan and Test Cases using Test Director.
• Created Test Scripts to test the HTML pages according to the Test Cases. Performed Functional, Regression and System Testing.
• Performed Data-Driven testing using Winrunner.
• Performed Cross Browser, Configuration, Content & Security Testing..
• Used V user Script Generator for writing and debugging automation scripts for Vusers, monitoring communication between Test application and server.
• Incorporated Vuser scripts in load Runner Scenario after inserting the General Function calls.
• Load tested the application with Loadrunner. Analyzed the graphs and generated Performance reports. Written Database Vuser Scripts and Performed back-end Testing-using TSL, SQL calls to the database server.
• Tracked extensive IT testing issues of the whole project resulting from test execution and categorized according to severity of the problem.

Environments:WinRunner6.0, LoadRunner6.5, TestDirector6.0.2, Oracle, C, 8.0,PL/SQL, VB 6.0,Windows NT.

Confidential. INDIA Sep\' 00 - Jan\'01
QA Tester

Time Logging Systemis designed and developed to record the attendance of BHEL Employees. This system has got an Administration Module and a Employee Module. Employees can view but cannot modify the records.
Responsibilities:

• Manually executed various tests before functional testing using SQA Robot.
• Involved in writing Test plans, Test cases and Test scripts using MS Word and MS Excel.
• Conducted database testing (Data_ driven_ testing).
• Performed Security testing in different management levels.
• Performed positive and negative testing and tested for boundary cases.
• GUI testing, Black box testing.

Environments:VB, COM, DCOM, Oracle7.3, SQA Robot, Crystal Reports, Windows 95, Solaris, MS Word,MS Excel

EDUCATIONAL QUALIFICATIONS:

• M.S Finance and Accounting and Certification in Computer Applications.