Oracle Apps Ebs

REVATHI GADDE

Oracle EBS Financials Techno-Functional Consultant

E-mail: ************@*****.***

Mobile: +1-469-***-****

LinkedIn: linkedin.com/in/revathi-gadde-555b3229

EXPERIENCE SUMMARY:

Having total 16 years of experience in IT industry on the different domains and modules related to Oracle Applications. Worked as Oracle Apps Finance functional, which includes Implementation, upgrades, Testing and Production support on Oracle Apps 11i, R12.

Implementation and Support of various financial modules including General Ledger, Payables, Receivables, Purchasing, Cash Management, Fixed Assets, E-Business Tax, Expense TCA, and Trade Management in EBS and Cloud.

Worked on upgrade projects from 11i to R12 and also involved in R12.0.6, 12.1.3 to 12.2.6

Excellent configuration experience on Procure to Pay(P2P), Order to Cash(O2C), A2R and Assets to GL Cycles and R2R Using Multi-Org.

Multiple project life cycles experience with Initiating, Planning, Executing, Supporting and Monitoring. Business Analysis, Requirements Gathering including facilitate Workshops, Scope Verification & Validation, Alternatives Identification and Analysis, Functional Design Development, Integration & User Acceptance Testing, Training, cut off, Go-live and Post-Implementation Support.

Participated in requirements gathering workshops, prepared AS-IS(BP-040), TO-BE(BP080), GAP analysis, Application setups (BR-100), Functional design (MD050) documents and Conducted CRP, SIT, UAT sessions and user training sessions.

Proficient working with Oracle Support, creating and following up on SRs. Coordinated and followed on multiple issues based on priority including identifying bugs and follow-up with Oracle Development as well as conducting Oracle Web Conference (OWC) with Oracle Support Team.

Strong Exposure in preparation of high-level functional design documents for Custom application development, Conversions and Interfaces.

Experience in developing Conversions, Interfaces, Data Migration and various custom RICE components.

Good Team player and leading key business scenarios meetings with coordinating and getting signoff from business for the proposed business scenarios.

Worked in Onsite and Offshore model projects, coordinating and leading offshore team

Thoroughly involved in creating Test Scripts TE040 and end to end testing TE060 cross modules.

Good understanding of various Oracle developer tools including Oracle Forms, Reports, Workflow, Conversions, SQL, PLSQL, TOAD etc.

Proficient is documenting Specifications following AIM and OUM Methodology. Authored MD50, MD120, BR100, CV40 documents.

Coordinate with Suppliers on EDI integrations for both invoices and Payments especially in 850,855,856,810

Having experience on Oracle fusion cloud data conversion using FBDI (File based Data Import) and spreadsheet uploads and knowledge in ADFDI process.

System setup configuration for Oracle fusion release R13 financials for – Enterprise structure, GL and AP modules as part of implementation.

Involved in Functional testing on Monthly/Quarterly patching on Oracle Cloud System. Well aware of Agile Delivery processes using Azure.

Well versed in handling integration issues with different integrated systems like Coupa, Concur, HRC, Kyriba etc.

SKILL SET:

ERP Systems: Oracle Application R12 (12.1.3, 12.0.6, 12.0.4), 11i (11.5.10)

Oracle Financial Functional: General Ledger (GL), Accounts Payable (AP), Accounts Receivable (AR) and Cash Management (CM), Oracle HRMS.

Oracle Cloud Financials: Oracle Fusion General Ledger, Accounts Payable, Accounts Receivables, Fixed assets, Cash Management, Cloud P2P.

Languages: HTML, Java, SQL, PL/SQL.

Operating Systems: UNIX, Windows NT, Windows XP

Oracle Tools: FSG (Financial Statement Generator), TOAD, SQL Loader and Discoverer, Workflow, Reports, Forms, ADI, Discoverer

EDUCATION:

Master of Computer Applications (MCA) in 2007, ANDHRA UNIVERSITY, Visakhapatnam, India.

Bachelor of computer Application (BCA) in 2004, ANDHRA UNIVERSITY, Visakhapatnam, India.

CERTIFICATION:

Oracle Cloud Infrastructure 2024 Gen AI Certified Professional

PROFESSIONAL EXPERIENCE:

Client: Meta, California

Title: MSP- Payments (P2P)

Duration: Aug 2023 – May 2024

Modules: Oracle EBS Techno-Functional

Oracle EBS R12 Financials Techno-Functional Consultant

Environment: Oracle EBS R12 Financials R12.2.6, AP, AR, GL, FA,SLA, CM, EB Tax,SQL,PL/SQL

Developing the new enhancements in R12 EBS finance modules.

Acted as liaison between business and technical teams. Troubleshooting AP, AR, GL, FA issues.

Able to work with cross functional teams and solve the issues for business users on suppliers integration.

Extensively worked on P2P cycle.

Worked on XML files and XML gateways w.r.t supplier paymens.

Expertise in setting up EDI 820 payment files for supplier remittences.

Worked on month-end closure issues related to all finance modules.

Proposed automations and best practices to improve the process and suggested to use standard oracle instead of customizing the system.

Creating users and assigned the roles and data access set as per responsibility matrix.

Worked on new enhancements and prepared test scenarios to test the functionality and requirements are met.

Configured General ledger module as per business requirement and creating test scenarios for the same.

Have configured the setups for Payables, Receivables and new books in assets.

Active participation in design, development, and testing activities and provide valuable inputs on the same.

Performed scheduled activities, recommends solutions or alternate methods to meet requirements.

Create and follow-up on multiple SEV1 & SEV2 SRs for speedy resolution explain business team with cause of issue.

Providing production support to the custom issues raised via incidents in Service now tool.

Create SRs with Oracle Technical Support, coordinate and follow-up on multiple issues based on priority including identifying bugs and follow-up with Oracle Development.

Client: Mattel Inc, El Segundo, California

Title: Next Gen Finance (NGF)

Duration: Oct 2022 – Jul 2023

Modules: Oracle EBS R12 Financial modules

Oracle EBS R12 Techno-Financials Lead Consultant

Mattel, Inc. is an American multinational toy manufacturing company founded in January 1945 and headquartered in El Segundo, California. The company has presence in 35 countries and territories and sells products in more than 150 countries. The company operates through three business segments: North America, International, and American Girl.

Environment: GL, AP, AR, FA, iExpense,SLA, PA,SQL,Pl/SQL,Forms 6i,Reports6i

Troubleshooting the issues raised by business users on all financial modules. Gathering the requirements for enhancements proposed by business.

Troubleshooting the issues related to P2P cycle during implemetnation.

Defined the system configurations setups for all financials modules for new enhancements.

Debugging the Pl/SQL packages for production issues.

Developing new procedures and packages for enhancements.

Expertise in generating the invoices in EDI 810 format and sent to customer.

Defined the process setups for Revaluation, Translation, CVR rules, Security rules, Reporting and Accounting Sequences.

Troubleshooting the issues related to integration between various systems like EFT file transfer, Informatica and High Radius and Mainframe systems.

Defined the Internal Banks, Branch, Payment Methods and validations in Cash Management module.

Configured the Transmission Configuration setups, generation of PGP Keys and enabling the setups for Bank Integration.

Worked extensively on the solution for Master Data Migration (Suppliers, Customers) from legacy applications into Oracle Fusion Cloud.

Experience assisting in the definition of systems strategy, gathering and documenting business requirements, leading fit-gap analysis, as-is and to- be business process designs, conference room pilots (CRPs) functional configuration, testing, client user training.

Acts as liaison between the business users and IT also with onsite and offshore teams.

Supports the development of project proposals, business cases, project charters and related documents.

Project management activities like allocation of budgets, team assignments, Status presentations etc.

Client: Humana Inc, Louisville, Kentucky

Title: Corporate Web Systems - Production Support

Duration: October 2018 – June 2022

Modules: GL, AP, AR, FA, PO, Trade Management, HRMS

Oracle EBS R12 Finance Techno-Functional Lead Consultant

Humana Inc. engages in the provision of health insurance services. The firm operates through Retail, Group and Specialty and Healthcare Services. The Retail segment consists of products sold on a retail basis to individuals including medical and supplemental benefit plans The Healthcare Services segment offer services such as pharmacy solutions, provider services, clinical care, predictive modeling and informatics services to other Humana businesses, as well as external health plan members, external health plans, and other employers.

Environment: Oracle EBS R12.2.6, R12.1.3, SLA,SQL, Pl/Sql, Unix, CA Service Desk, Service Now, Power BI

My core responsibilities involved with trouble shooting in the area of AR, AP, and GL modules

Coordinate with DBA team to apply patches proposed by oracle after following up on existing issues.

Providing production support to the custom issues raised via incidents in Service now tool.

Create SRs with Oracle Technical Support, coordinate and follow-up on multiple issues based on priority including identifying bugs and follow-up with Oracle Development.

Worked on issues in both O2C and P2P cycle technically.

Interacting with Business users and identify critical business Issues and resolving errors.

Interacting with integrated system users like AS400, concur via bridge calls to provide support for major incidents.

Provide support for monthly period closures in production.

Coordinating with technical team and DBAs and other mainframe systems to resolve Citi bank interface issues.

Monitoring Prod deployments done by Development team during monthly migration window.

Arranging KT sessions from dev team after each and every CR migration to Prod and owning the components to support.

Preparation of training and issue resolution steps docs for the team as well as business users.

Provide detailed root cause analysis on all assigned issues with reproducing the same in latest cloned copy of test environment.

Responsible to monitor system maintenance and place the concurrent jobs on hold and release during monthly maintenance.

Worked on AP Invoice interface issue from other system (Legacy systems, Concur) to oracle.

Project status reporting to client and senior management weekly, monthly and quarterly.

Client: Cigna Corporation, Bloomfield, CT

Title: Oracle R12 Reconciliation

Duration: Feb 2017 – Sep 2018

Modules: GL, EBTax

Oracle EBS Functional Lead

Cigna is an American worldwide health services organization. Its insurance subsidiaries are major providers of medical, dental, disability, life and accident insurance and related products and services.

As part of GL international Rollout, Oracle EBS R12 configured for NA region. Accounting reconciliation has to be happened between old system and new system.

Environment: Oracle Application 12.1.3, GL, EB Tax, SLA/FAH, AOL, FSG, Microsoft Tools, Oracle Discoverer.

Involved in doing R12 GL accounts reconciliation.

Customized various rules in Sub ledger accounting module for deriving Tax and discount accounts on AP invoices.

Creation of reconciliation reports and does validations and submits to business users.

Interacting with technical team to build queries for reconciliation.

Project status reporting to client and senior management weekly and monthly.

Worked on POC related to EB Tax requirements for NA region implementation.

Working with business users on fit-gap analysis.

Working on Discoverer reports to validate the GL reconciliation reports.

Client: Rogers Communications, Canada

Title: Network Inventory Management Testing

Duration: Nov 2016 – Feb 2017

Modules: AP, AR, GL, PO

Oracle EBS R12 Functional Consultant

Rogers Communications is a Canadian communications and media company. It operates primarily in the fields of wireless communications, cable television, telephone and Internet connectivity, with significant additional telecommunications and mass media assets

Rogers implemented Oracle EBS to track the inventory systems and its accounting. There is central warehouse which transfers the network inventory goods to ship to contractors’ warehouse to install network towers, cables across all the locations.

Environment: Oracle Application 12.1.3 (SCM and Financials) PO, iProcurement, AP, AR, GL, OM, INV, QP, AOL, Microsoft Tools.

Perform testing/retrofitting of RICE components.

Performed functional testing and SIT and assisted the business users in UAT in both the release by preparing test scenarios and guiding the testing team.

Tracking defects and issues during UAT (User Acceptance Testing) using HP Quality Center.

Participated in meetings with SMEs and Dev team to understand the scope of the project.

Identify the test scenarios/test requirements.

Prepare test cases and send to the business analyst for reviews.

Identify every test case pre-requisite, test conditions, detailed expected results.

Review and approve test cases by business analyst.

Modify the test cases post peer review feedback and upload the test cases to test management tool (HPQC).

Executing the test cases successfully and passed, if test cases fail raise bugs in HPQC tool.

Successfully performed test-case scenarios in Inventory, Purchasing, Order Management, and finance modules.

Work with users to ensure the project meets business needs.

Performed Regression Testing and Smoke Testing.

Performed and tested full cycles of Procure to pay, order to cash cycle and service contracts business cycles.

Tested all purchase orders scenarios like Standard, planned purchase orders and Blanket, Contract purchase agreements.

Tested all sales orders like standard sales order, back-to-back sales order and drop shipment sales order

Client: Western Union, Denver, CO

Title: COTs Portfolio PSM

Duration: Nov 2013 – Nov 2016

Modules: AP, AR, GL, FA, CM, PO, iProcurement

Oracle EBS R12 Finance Functional Consultant

Western Union is the largest company engaged in the business of global money transfer, providing ways to send money worldwide, pay bills and purchase money orders.

Environment: Oracle Application 12.0.6 and 12.1.3 Support (SCM and Financials) (AP, AR, GL, EB Tax, SLA/FAH, AOL, CM), XML Publisher Administrator, Microsoft Tools. ASCENT for ticketing.

Creation of Requirement gathering document (BR 035), Solution Design (BR 010) Specs for the financial modules for new projects

Worked on impact analysis for upgrade proposals and involved in integration testing for the existing components from 12.0.6 to 12.1.3

Involved in trouble shooting the area of AR, AP, and GL modules.

Create and follow-up on multiple SEV1 & SEV2 SRs for speedy resolution and explain business team with cause of issue

Created Users and modified the privileges for the Users, Rollup group and Summary Accounts

Coordinate with DBA team to apply patches proposed by oracle Support after following up on existing issues.

Defined the setups for integrating Oracle Payables into Fixed assets.

Involved in Month-end support for close and reconciliation for AP and AR modules.

Setup Multi Org Structure including new Ledger setups based on 2 Legal Entities, and 2 Operating units.

Maintained Bank account signing authorities, managing Bank account statements in Cash Management.

Created custom check payment formats for R12.

Resolved issues related to the P2P cycle before and after monthly, Quarterly and yearly releases.

Tested End to End flow of PO’s created in Third party interface tool to R12 application.

Participating/Coordinating with Business/Functional users in Application Configuration Set-ups.

The Cash management implementation covered the Bank setups, the Bank Transaction codes setups, Bank statement mapping and customization of Bank statement import process for previous day and current day bank statements, Cash positioning and Cash forecast etc.

Developing / Maintenance of KEDBs (Known Error Data Base)

Writing DoUs when new enhancement went into live.

Testing enhancements by writing test cases based on requirement.

Prepared Training Material for End Users whenever there is a configuration change in the application.

Created Customer bank, Supplier banks for transaction purpose as per the client requirements.

Setup Customers, Profile Classes and Internal Bank accounts.

Defined Payment process profiles in Oracle Payments.

Responsibility to manage: Creating & Administering Users, Responsibilities, Profile Options, Application Menus and Forms, User and Role Configurations.

Actively participated in ORG and Chart of Account discussion in design phase for Baltic countries implementation.

Preparation and presentation of weekly and monthly status reports to business.

Client: Motorola Solutions, Schaumburg, IL

Title: R12 Trilogy Upgrade

Duration: Jan 2013 – Oct 2013

Modules: AR, TCA (Trading Community Architecture)

Oracle EBS R12 Finance Functional Consultant

Motorola Solutions has most of its ERP applications running on Oracle Apps 11i and R12 versions for different regions The scope of this project is to develop and convert the existing customer data from Asia 11i System to Oracle R12 System.

Environment: Oracle Application 12.1.3 Implementation, (AR, WINDOWS 7, SQL, TOAD), Microsoft tools

Responsibilities:

Identified Business Requirements & detailed Solution Design for AR Customer management.

Developed Concurrent Programs to interface Customer data from Legacy Systems to AR.

Involved in workshop sessions with GL, AP Finance users in detailing out business requirements & map business design with Oracle AR and TCA configuration (12.1.3).

Worked on upgrading the existing components to R12 to migrate customer’s master data.

Worked with Oracle to fix the various functional related bugs/issues and migrate the solution to other environments.

Preparing and executing unit test cases and end to end interface testing.

Testing of Custom Components and Third-party integration

Closely worked with the core business finance team during UAT.

Developing / Maintenance of Application Manuals.

Performed migration of all AOL objects using FNDLOAD utility between instances.

Worked on data quality metrics.

Client: British Airways, New Castle, UK

Title: Payroll Online Optimization

Duration: Jul 2010 – Jun 2012

Modules: HRMS, Core HR and Payroll

Oracle EBS R12 functional Consultant

British Airways (BA) is the flag carrier and the largest airline in the United Kingdom based on fleet size. When measured by passengers carried, it is second-largest in the United Kingdom behind easy Jet.

Environment: Oracle Application 12.0.6, SQL, Toad, Pl/Sql Developer

Analysis of client's requirements & designing the solution.

Worked on the Functional Mappings for data conversion from Legacy to Release 12.

Worked on migrating payroll information from custom forms to standard HRMS forms.

Involved in Data migration to upload the payroll data of employees.

Prepared system test cases and test case execution.

High Level test plan Documentation and detail level test plan documentation.

Peer review for other components developed by team.

Pre upgrade testing and Post upgrade production live support.

Involved in testing and validating the logic of Customizations.

Performed end to end testing and validation of the reports in CRP and UAT instance.

Created test cases for UAT (User Acceptance Testing) in TE040 documentation with detailed testing.

Client: Xerox Corporation, Webester, NY

Title: NASPD Production Support

Duration: Apr 2008 – Jun 2012

Modules: AP, AR, GL, OM, INV

Oracle Apps Techno-Functional Consultant

Environment: Oracle Application 11.5.10 Support (GL, AP, AR, PO, AOL, TCA)

Troubleshoot issues related to AP, AR modules raised via ITT ticketing tool.

Also, creation/follow-up of Oracle service requests (SRs).

Conduct quality reviews of code developed by other development staff using coding standards document.

Coordinated and monitored Month End Closing process.

Analyzed the support incidents logged in the system and suggested to implement required solutions.

The project related to the maintenance and support of Oracle E-business Suite 11i - Accounts Receivables (AR), Accounts Payables (AP), General Ledger (GL), Purchasing (PO), Order Management (ONT) modules.

Support for Accounts Payable and AR Modules.

Handling the tickets, resolving the issues on day-to-day basis on priority.

Undertaking all steps necessary to satisfactory closure of the tickets raised by clients.

Prepared CR Documents for any changes in Production Instance

Maintaining KEDBs and provide permanent fixes for recurring issues.

Interacting with Project manager on daily and weekly basis and submitting status report.

Contact this candidate