Oracle Developer Resume
Professional Summary
- Over 10 years of experience in QA and functional knowledge in Oracle applications testing. Expertise in Oracle testing for implementation, upgrade and support projects
- Conversant with various modules of Oracle ERP modules (Accounts Payable, Oracle General Ledger, Oracle Purchasing, Accounts Receivables, Cash Management, Order Management, Inventory, HRMS and iProcurement).
- Experience in testing strategy, Test plan and communication plan for testing facility. Experience in estimating the effort for testing.
- Hands-on experience in regression testing and performance testing for Oracle business flows like Order to cash (O2C), Procure to pay (P2P), Accounting to financial reports. Performed functional, regression, Data Driven, Batch Tests, descriptive programming using QTP and performance testing using Load runner. Experience in load testing RAC environment infrastructure.
- Conversant with Oracle Methodology (AIM)
- Involved with cross-functional teams for Implementation projects in all phases like unit testing, Integration testing, system testing and UAT.
- Strong knowledge using testing tools (HP QTP, HP Load runner, Test link, HP Quality Center).
- Excellent communication skills with mentoring, managing and Project coordination skills. Worked as Onsite coordinator on Onsite-Offshore Model consulting projects.
Technical Skills
Oracle Apps modules: Account Payables (AP), Account Receivables (AR), General Ledger (GL),Cash Management (CM), Oracle Purchasing (PO), Order Management (OM), Inventory (INV), Oracle Human Resource (HRMS) and iProcurement
Languages: Java, C, SQL, PL/SQL, XML, PERL, Python, PHP5.2, HTML, TSL, VBScript
Databases: Oracle 10g, MySQL5.x, SQL Server 2008, Access 97/2000
Operating Systems/Platforms: UNIX, Win 7/NT/XP/2000, MS-DOS, MAC OS X,
Tools: Microsoft office, MS-Visio, MS – Project, Sun Open office, TOAD, SQL yog7.1, MS-Info path, MS SharePoint
Web servers: Apache2.x, IIS6.0, OAS
Functional Testing tools: Winrunner8.0, Quick Test Pro9.5, Selenium, TestPartner, Oracle Functional tester
Performance Testing tools: Load Runner 9.0, Jmeter, Open STA, Badboy1.6, e-Load
Test management tools: Quality Center10.0, Test link1.7.4, Mantis1.1.6
Project Details
Confidential, Plano, TX
Functional Test Lead Jan ’11 – Present
Project Confidential, has been chartered to upgrade the Frito-Lay US (FLUS) core financial systems. The main focus of this project is to migrate the existing solution to Oracle version 12.1.3, a current and supported version of the Oracle e-business suite. In addition, the scope includes implementing improved capabilities in several selected areas with supported Oracle products. This includes Oracle Financials, Purchase to Pay (P2P) and Project Cost Accounting systems. Upon completion of this project, FLUS will be on a current/supported version of Oracle Financials (12.1.3).
Responsibilities
- Functional test lead for Accounts payable module.
- Involved in requirement gathering, gap analysis.
- Involved in FD reviews for understanding business process
- Involved in CRP with the process team and process partners for test execution.
- Responsible for delivering test case inventory for the Standard scenarios/ Customizations/ datasheets
- Reviewing the standard test scenarios with process partners and sign off on the same.
- Reviewing the FD test scenarios with Process team/FD authors and signoff on the same.
- Responsible for delivering the extended KT documents.
- Involved in reviewing and delivering the test scripts.
Environment: Oracle Applications 12.1.3 (AP, GL, PO, iSupplier, OIC, FA, PA), TOAD
Confidential, Plano, TX
Functional Test Lead Nov ’09 – Jan ‘11
Confidential, business process transformation initiative, which is integrating the information technology, business intelligence, and resource management across all of Confidential divisions. Organized into distinct releases, One Up utilizes a cross-release technology team.
Responsibilities
- Functional test lead for legacy financials for One-up Release 7.
- Understand finance business process. Worked on legacy applications (Mainframe and Oracle applications)
- Interacting with client for gathering business knowledge for testing R7 changes in legacy finance and prepared the test scenarios for Integration and regression testing. Identify the critical business scenarios for system and regression testing.
- Involved in testing Interfaces, Extensions and Forms. Prepared As-Is and To-Be documents for legacy finance process. SQL queries to test the data using dB Visualizer
- Analyze the business scenarios and design the test approach using the test management tool.
- Involved in extensive testing of end to end business process flow during system integration testing.
- Tested Oracle period end closing process, Oracle Invoice/Payment processing, Journal validations, Stock receipt verifications, Lights out processing, and Order status validations.
- Support client for testing whenever required like creating transactions, running reports, interfaces.
- Ensure the quality assurance during the testing process and check the traceability
- Work with cross-functional teams and offshore for regular status on the issues on day-to-day basis.
Environment: Oracle Applications 11.0.3 (AP, GL, PO, OPM), Legacy (FIG, FS2, C2C, HVL), dB Visualizer, Mainframe, Reflections, Windows NT/XP, MS- Visio, MS-Project, MS Office.
Confidential, Livermore, CA
Oracle QA Analyst Jan ’09 – Oct ‘09
Confidential, is a global leader in advanced wafer probe card technology and design. FormFactor is a mission critical supplier to top chipmakers, enabling them to bring next-generation devices to market. The company has gone through a rapid growth and needs to expand the use of Oracle Applications and factory applications to roll out for multi country implementations with Regionalization project.
Responsibilities
- Interacting with client for gathering the testing scenarios and prepared the test environment for regression testing.
- Prepared TE.040 test scripts for the business scenarios Procure to pay, Order to cash and bank statement to reconciliation
- Prepared Test plan, Test strategy and communication plan for testing cycles and UAT.
- Involved in testing reports, interfaces and conversions. in
- Experience on SQL queries using TOAD to test the back end data.
- Tested business scenarios: AP invoicing, Validations, Payment batches, Journals, Reconciliation, order entry, shipping, requisition process, PO creation, Receiving, IR Creation, Customers, auto invoice.
- Tested Checks, deposits and miscellaneous transactions are matched to bank statement.
- Tested In-bound interfaces like Invoice, PO and Out-bound interfaces for the system
- Analyze the business scenarios, designed and setup of test management tool (Test link) and defect tracking tool (Mantis) for traceability of each test case during all phases of testing
- Developed and executed QTP scripts. Programming, batch tests, re-usable scripts, Functions, Recovery scenarios, descriptive programming, data validation and regression testing using QTP.
- Prepared daily status reports and project in meetings to the project management
Environment: Oracle Applications (AP, AR, GL, OM, CM, BOM, WIP, OSFM, INV), QTP 9.5, Test link1.7.4, Mantis1.1.16, Java, Apache2.2, MySQL5.x, TOAD, Windows NT/XP, MS- Visio, MS-Project, MS Office.
Confidential, Delray Beach, FL
Oracle Applications Test Lead Jan ’08 – Nov ‘08
Description: Office Depot, Inc. is one of the world's largest sellers of office products and an industry leader in every distribution channel, including stores, direct mail, contract delivery, and the Internet and business-to-business electronic commerce. It implemented Oracle Applications 11i for two different tracks like Order to Cash (O2C) and Procure to Pay (P2P).
Responsibilities
- Gathering the business requirements for functional regression testing.
- Involved in testing different modules include Account Payables, General Ledger, Purchasing, Order Management, Inventory and Self Service Applications.
- Business Requirements study and prepare test case documents TE040 and TE020 for the custom reports and custom process developments and testing of the same.
- Involved in testing business scenarios in purchase order, requisitions, receipts, Invoices, payment and bank reconciliation
- Tested Invoice processing, payment processing, matching process (2-way/3-way) and post Journals to GL.
- Tested Invoice interfaces/Vendor conversion and verify payables reports,
- Tested sales orders inbound interface, sales order holds/releases, pick release, ship confirm, order fulfillment & customer invoices.
- Keep track of execution of scripts, documentation and status reports. Involved in developing, execution, reviews, bug tracking, preparing consolidated issue logs for different phases of testing.
- Prepared the test automation framework for functional regression testing.
- Prepared test plan, test methodology and strategy document for business flow testing
- Create, develop and maintain automated test scripts using QTP for various business scenarios in order to cash and procure to pay cycle.
- Backend testing to validate the data using SQL queries.
Environment: Oracle e-Business Suite 11.5.10 (AP, GL, CM, PO, OM, INV, AR), Quality Center 9.0, QTP 9.0, Oracle 8i/9i, TOAD, Windows NT/XP, Visio, MS Office.
Confidential, Bangalore, IN
QA Lead Aug ’07 – Nov ‘07
Confidential, the nation’s largest retailer of arts and crafts materials. Michael’s implementation consisted of the full Oracle financial footprint and involved Accounts Payable, Fixed Assets and General Ledger including a complex integration with Retek store merchandise systems to support 3-way match.
Responsibilities
- Test lead for functional automated regression testing in Oracle e-business applications.
- Interacting with customer for gathering the business scenarios and prepared the test bed for the functional regression testing.
- Write test scripts for Oracle modules AP, AR, GL and CM for business scenarios customer invoice to cash, bank reconciliation and period end close to financial reports.
- Analyze and Planned test scenarios in batches and tested the application for various critical business scenarios.
- Prepared test plans and testing methodologies based on the business requirements.
- Performed regression testing using QTP for business flows Supplier invoice to payment and Customer invoice to cash.
- Provide the status reports to the customer based on the different test cycles performed during development, UAT and on pre-production instances.
- Upload the test scripts in quality center and execute automation scripts from test lab. Scheduled the QTP scripts in quality center.
- Oracle applications backend testing to validate the data using SQL queries.
- Keep track of execution of scripts, documentation and status reports.
- Participated in Bug reporting using quality center and participated in bug reviews.
Environment: Oracle Applications11.5.10 Modules: GL, AP and PO, Mercury Quick Test Professional (QTP) 8.2, Quality center, TOAD
Confidential, Bangalore, IN
Oracle apps performance Tester Feb ’07 – Aug’07
Confidential, intended upgrading their Oracle Applications 11.5.8 to Release 11i (11.5.10.2) consisting of CRM Modules. The project objective was to provide LCM with a technical upgrade of their current 11.5.8 Oracle Applications to R11i along with a platform migration from Windows 2000 to HP-UX 11.23.
Responsibilities
- Interacting with client for gathering the business requirements for performance testing.
- Reviewed TE040’s for the performance testing on Oracle applications.
- Developed and executed Load runner scripts based on the Functional requirements.
- Prepared Scenarios in groups and tested the application for various loads using 4000 virtual users.
- Worked closely with tech architect team for testing system for various loads.
- Analyze the reports and provide conclusions to the customer.
- Keep track of execution of scripts, documentation and status reports. Involved in developing, execution, reviews, bug tracking, preparing consolidated issue logs for different phases of testing.
- Oracle applications backend testing to validate the data using SQL queries.
- Mentored new consultants on Load runner for testing Oracle Applications.
Environment: Oracle Applications11.5.10 Modules: CRM, Loadrunner8.1, TOAD
Confidential, Bangalore, IN
Test lead Jul ’06 – Nov ‘06
Confidential, headquartered in Evansville, Indiana, is energy and applied technology holding company with approximately $4 billion in assets. Vectren has upgraded 120 custom objects and developed new CEMLIs for order management.
Responsibilities
- Test lead for functional testing.
- Involved in preparing the QTP scripts based on the Functional requirements (TE040).
- Developed re-usable scripts, common functional library, and recovery scenarios in QTP.
- Tested various Oracle Financial reports.
- Developed and executed QTP scripts for HR/Payroll functionality.
- Escalate/Log the issues about project requirements (Software, Hardware, Resources) to Project Manager / Client.
- Assist in performing any applicable maintenance to tools used in Testing and resolve issues if any.
- Document, implement, monitor, and enforce all processes and procedures for testing is established as per standards defined by the organization.
- Capture the metrics during the execution and provided conclusions to the customer.
Environment: Oracle Applications11.5.10 Modules: GL, AP, AR, HRMS and PO, Quick Test Professional (QTP) 8.2
Confidential, Bangalore, IN
Oracle Applications QA Analyst May ’05 – Jun ‘06
Confidential, is a financial services company specializing in the surety and title insurance industry. The First American Corporation, through its subsidiaries, is engaged in the business of providing business information and related products and services. The Company has five reporting segments that fall within two primary business groups, financial services and information technology.
Responsibilities
- QA Analyst for Production support in Oracle modules AP, GL, CM, FA and AR.
- Defined and documented client business requirements for accounts payable module and developed test cases for the same.
- Developed TE040 and TE.020 for customers and involved in testing the converted customers. Setup customer information for billing.
- AP setup work done include Pay Groups, Payment Formats, Payable Options, Financial Options, Payment Terms, Tax Codes, Distribution Sets, Recurring Invoice Templates and Expenses Report Templates.
- Configuration of application according to client requirement including Flex fields, Book Controls, Categories, Calendars, Depreciation. Setup Vendor information and Payment Terms.
- Involved in testing Reports, Interfaces, Conversions and Extensions (RICE)
- Develop Scenarios and Scripts to test functional requirements, Modifications, Interfaces, and Conversions into Account payables, General ledger and Accounts Receivable Modules.
- Tested AP, AR, GL, FA and CM customizations and responsible for quality assurance.
Environment: Oracle Applications11.5.10 Modules: General Ledger, Accounts Payables, Receivables, PA, Cash Management and Fixed Assets, TOAD, Kintana, Tech Excel, 170 systems
Confidential, Bangalore, IN
Senior Tester Jan ’05 – May ‘05
Confidential, implemented Oracle applications 11.5.10 in Order to cash flow for 26 BU’s. My role involved in 3 BU’s as functional testing, testing the various flows Order to cash. Financial flows include invoice to cash, Accounting to Financial reports.
Responsibilities
- Involved in mentoring/hiring new staff for testing team/team building to understand the Test process and test methodologies.
- Tested various business scenarios in order to cash: Order to shipment, Order to buy shipment, Order to drop shipment, Pick to order to shipment and Order to customer invoice
- Build test automation environment for functional testing and test maintenance.
- Involved in validation of the TE040 documents.
- Execute the test plans for assigned modules and generated the test summary report
- Develop and execute automated test scripts.
- Participated in Conference Room Pilot (CRP) and User Acceptance Testing (UAT).
- Act as the single point of contact (POC) between Development and Testers for iterations, testing and deployment activities.
- Track and report upon testing activities, including testing results, test case coverage, required resources, defects discovered and their status and performance baselines.
- Develop and execute the Winrunner test scripts. Integrating the WR scripts with Test director. Scheduling the scripts and design the execution flows in test director.
Environment: Oracle Applications11.5.10 Modules: OM, INV, BOM, PO, AR, AP, GL and CM Winrunner7.5, Test director8.0, TOAD
Confidential, Bangalore, IN
Functional Tester Nov ’03 – Oct ‘04
The aim of the project is to upgrade Oracle Applications from 11.5.7 to 11.5.9. Identify the impact after applying patches on the system. Business flow accelerators like Sourcing Requirements to Agreement, Supplier Return to Replacement, Supplier Invoice to Payment, Requisition to Receipt Direct, Period End close to Financial Reports, Supplier return to Debit were tested thoroughly. Test scripts developed were approved for client’s usage.
Responsibilities
- Involved in validation of the TE040 documents.
- Involved in testing business scenarios: Requisition to receipt (direct and indirect), Supplier invoice to payment, Supplier return to debit, Supplier return to replacement and sourcing requirements to agreement.
- Develop and execute automated test Scripts for functionality testing, Regression testing and business flow Navigation. Developed Common Function Library using descriptive programming.
- Developed Re-usable scripts (generic) for any Oracle instance. Integrated the test scripts and performed Batch tests for all the business flows.
- Performed Data driven and Exception handling (Recovery Scenario). Integrated Quick tests with Test Director, Performed batch tests, scheduling the tests.
Environment: Java, JSP, Oracle Applications11.5.9 Modules: iProcurement, Purchasing, Account Receivables, General Ledger and Accounts payables, Quick Test Professional6.5 (QTP)
Confidential, Bangalore, India
Software Engineer Feb ’01 to Aug’03
Responsibilities
- Study the functional specification of the Feature/Design being developed.
- Understanding business processes. Regression Testing, Acceptance testing.
- Understanding client Requirements. Writing Use cases and Test cases, testing various modules.
Environment: Oracle Forms, Oracle 8i, Winrunner 5.6, MS-VSS, Buggy
Trainings and Certifications
- Oracle Certified Associate in Oracle 11i E-Business Essentials
- Brain bench certified : Software testing, Project Management, Managing People
- Oracle QA zone Featured user of the month Confidential
- Trained on 11i Oracle Payables from Oracle University
- Internal training in Oracle Applications R12i
Education
- Bachelor of Engineering in Computer science