Oracle Ebs Financial Reporting

Basangouda Patil (Basu)

Mobile: 317-***-****

Emai: ***********@*****.***

Immigration status: permanent resident

Over 20 plus years of domestic and international work experience in Oracle EBS application (R12.2 OCI, R12 and R11) as Finance Functional, Techno-Functional, and lead Consultant in providing solutions for R12 EBS application support and implementation.

CORE COMPETENCIES

•Business/Functional Consulting

•ERP Implementation – End to End

•Expertise in Client Interaction

•Project Management

•Team Management – Offshore /Onsite

•Generate Financial Reporting for Month End and Year End closing, extracts and Reconciliations

•Planning & Risk Mitigation

•Observation & Analytical skills

•Working experience on SOFS, Supplier Allowances, Market Allowances, and Co-Op sites Billing, Invoicing and Payments

•Working experience on Oracle Purchasing (PO), Oracle Inventory (INV), Order management (OM), Bill of Materials (BOM), Oracle Projects (PA) (Costing and Biling) and System Administration

•AIM Methodology

•Leadership skills to manage functional and technical teams

•Knowledge on Oracle Financials Cloud Rel 13 (GL, AP, AR, FA, CM) and Fusion Tools FBDI, ADFDI and OTBI

•Sysadmin activities like configurations, Request schedule, Alerts, User roles and responsibilities and other maintenance activities

EBS: Oracle E-Business Suite R12.2 on OCI (IAAS) with Oracle

Database:19c (PAAS) with Oracle

Linux

EBS: Oracle E-Business R12 on premises with Oracle

Database: 12c with Linux OS

DB Tools: SQL PLUS, PL/SQL, TOAD, SQL Developer

Reporting Tools: R12 Oracle Reports, EIS Reports

PROFESSIONAL SNAPSHOT

As an Oracle EBS Business Analyst/ Lead consultant/ ERP Functional Analyst

•Working with a global team, delivering solutions across multiple regions like APAC, EMEA, USA, and India, in industries such as retail, distribution, healthcare, oil and gas, banking, and high-tech manufacturing.

Functional Expertise in Oracle Financials Modules:

•Deep experience in the core Oracle Financials modules, including Accounts Receivables (AR), Accounts Payables (AP), Cash Management (CM), General Ledger (GL), iExpense, and Revenue Management.

•Handling complex financial operations like Revenue Recognition, Partner Billing, Consolidation Ledger, and EIS Reports

•AP/AR Netting, Balance Forward Billing (BFB), Inter/Intra-company accounting. Worked on Primary and Consolidation ledgers.

Business Process Improvement and Support:

•Focus on identifying process inefficiencies and recommending solutions to enhance system functionality.

•Close collaboration with both business users and the IT team to resolve issues and ensure smooth processes.

•Fit-gap assessments to propose the best solutions with clear impact analysis.

•Ledger and Sub ledger Reconciliations and Month end close process

Ad Hoc Reporting and Customization:

•Expertise in creating custom alerts, EIS reports, and ad-hoc reports to meet specific financial reporting needs.

•Proficiency in using TOAD for SQL to extract data as per the finance team's requirements.

Integration and Customization Leadership:

•Involved in technical leadership for Oracle EBS integration and customization.

•Strong focus on ensuring system interfaces work properly between ERP and other custom systems, along with handling data migration.

Experience with Key Business Process Projects:

•Involvement in various phases of projects, including EBS implementations, upgrades, month-end closes, and production support.

Service Level Agreements (SLA) and Incident Management:

•Ensuring issues are handled within the defined SLAs and providing quick, effective resolutions for incidents.

Other Tools: Winscp, Citrix desktop Jira, OraGit, Putty, Web ADI, Winscp, Citrix desktop and ServiceNow

Beyond, Inc Midvale Utah

ERP Oracle Analyst Nov 2018 to Mar2025

•Business Process Improvement: Identifying inefficiencies in existing processes and recommending enhancements, particularly in relation to system functionality.

•ERP Cloud Migration and Support: Overseeing and testing the migration of ERP systems to the cloud, ensuring data sync, and providing ongoing production support.

•Customization and Alerts: Designing custom alerts for general ledger (GL) and sub-ledgers, plus managing billing for partners and customers within the SOFS system.

•Reporting and Extracts: Creating and delivering EIS reports and ad-hoc finance extracts, covering revenue recognition, AP Payments, fixed asset retirements, iProcurement / Standard/ Partner POs, and ledger operations.

•Solution Design: Working with Oracle Financials (GL, AP, AR, FA, CM) to design, configure, test, and troubleshoot the system based on business needs and requirements.

•Reconciliation and Month-End Close: Handling reconciliation processes, AP/AR Netting (Accounts Payable/Accounts Receivable Netting) and overseeing month-end period close activities for both sub-ledgers and ledgers.

•Incident Management: Responding to incidents per SLAs, diagnosing and fixing issues related to data or system configuration.

•Designed and implemented a new company integration (Zulily and Bed Bath and Beyond) into an existing Beyond ledger, within Oracle EBS, to ensure seamless integration, accurate financial reporting, and compliance with business rules requirement. Worked in requirement gathering, Design, General Leger and Sub Legers configurations, Integration, Customization for integration for new companies. Integration from OM to integration to AR Subledger

•End-to-End Testing: Perform end-to-end testing by simulating typical transactions like GL and sub ledger interface sources, journal entries, intercompany transactions, and multi-currency processing) to ensure the system behaves as expected.

•Worked with Supplier Allowances, Market Allowances, and Co-Op sites, which are part of supply chain and vendor management within ERP systems. This data comes from external systems and integration with Oracle Financials for vendor invoices and payments.

•Worked on SOFS Billing (Supplier Oasis Fulfillment Services Billing) for various services related to supplier fulfillment. This data comes from a billing engine to Oracle EBS System which involves Billing Schedules and Invoice generation (BFB) and Revenue Recognition. designed custom billing invoices (bursting programs for BFB AR Invoices after BFB confirm process), reports, payment statuses, and revenue breakdowns for financial reporting.

•Setups for creation of locations/ Warehouses, Sub Inventory, Inventory Items, Item Costing, Operating Units, Intra company and other sub ledger setups

•Support daily operations systems of Order Management, PO, Inv, Costing, Finance Integrations and Drop ship order integrations. Worked on Standard PO and custom PO (Drop ship) management. Worked on COGS for Core orders and Cogs for Drop ship orders.

Oracle EBS: Oracle R12, 11.5.10.2 and Toad

Oracle Application Finance Modules: Oracle Receivables (AR), Payables (AP), General Ledger (GL), Cash

Management (CE), Fixed Assets, Inventory (INV), Bill of Materials (BOM), (FA),

EIS, Purchasing (PO), iProcurement, Costing (CST), HRMS

Report Manager, EIS Reports Tax Integration: Vertex

Oracle Application Operations Modules: Oracle Purchasing (PO), Inventory (INV), Costing (CST) Order

Management (OM), OTM, CRM applications.

Quote, Service, Costing, Oracle Sales and Marketing, WMS

Oracle Application Manufacturing: Inventory (Inv), Bill of Material (BOM) and OM

WIPRO June 2015-Nov-2018

Lead Consultant

Client: State Street Bank Boston, MA

Project: Oracle Application R12 Implementation for an India Ledger

Oracle ERP Suite of Oracle R12 – Oracle Payables, Fixed Assets, Cash Management, Oracle General Ledger, Oracle Purchasing, HRMS, iExpense, Report Manager

•Manage the resource allocation and task allocation based out of multi locations. POC demo to IT and Business Leads across the world for a global solution for state street.

•Responsible for Project Initiation, Configuration setups, conducting CRP sessions, Sign off from business, Testing, creation of User manual for new country (creation with LE, Ledger and OU’s and Inventory Org’s )

•Responsible for Project Deliverables, Project plan, status, Stage gate and project Cut over plan planning

•Configure Oracle EBS R12 Finance Applications like Payables, iExpenses, Receivables, General Ledger, Fixed Asset and Cash Management

•Assist with testing as needed. Review Oracle Service Request (SR's) and facilitates proactive development and configuration changes needed for patch acceptance, or business communication if needed.

Client: Emerson Network Power

Project: Oracle Application R12 Upgrade

Oracle ERP Suite of Oracle R12 – Oracle Receivables, Oracle Payables, Oracle General Ledger, Oracle Purchasing, HRMS, Oracle Projects (Costing and Billing), iExpense, Time and Labor, Report Manager, iProcurement

•Gathered business requirements for Oracle Financial modules which includes AP, AR, GL, PA and iExpense

•Design the process flow diagrams, Conduct a system validation session with Business owners. Understand the business process, configure system setups and prepare Configuration Document (BR100), Month End Close Process, Test Script and User Manuals for Oracle Projects and Finance modules.

•Create and maintain OU, LE, Project Organization, Banks, COA, Cross Validations, Security Rules, PA and AR Auto accounting, Sources, Transaction types, Intercompany and Trade Customers

•Configure the Oracle Applications Setups to meet business requirements for GL, Oracle Projects, iExpense, AR and AP

•Design and implement solution for Account Generator for AP Supplier Invoice and iexpense Invoice related to Project Expenditures. Configure and setup for Bill rate and cost rates for Oracle Project in Costing and Billing. Setup and execute Integration of Costs to projects and Revenue to AR. Worked on Receivable AR Invoice and Receipts.

•Identified and implemented CEMLI Finance objects in R12 and showcased the business with AS IS working process

•Design, Configure and implement iExpense System and integrate to projects for Costing and Billing.

•Worked on POC for GL 4-4-5 to Fiscal Month, PA Expenditures, Month End Close Process and COA mapping.

•Manage Team of onsite and offshore for the Project deliverable, resource assignment, schedule and manage CRP sessions. Outbound and Inbound data planning for Finance Hyperion and Data warehouse

•Responsible for Project Deliverables, Project plan, status, Stage gate and project Cut over plan planning

•Interaction with Finance, IT and Business Director for all the POC and project plans.

Client: Emerson Process Management MN

Project: EPM BPH Design Solution

Oracle ERP Suite of Oracle R11 – Oracle Receivables, Oracle Payables, Oracle General Ledger, Fixed Assets,, Oracle Purchasing, Inventory, BOM, WIP, Oracle Projects and Cash Management.

•Gathered business requirements, participated in setups & implementation and test scenarios for Oracle Financial modules

•Pre-Auto Invoice solution as a Global solution for Emerson Business units. Worked on Fit Gap Analysis. Gathered requirements through various meeting/discussions/workshops.

•Design and solution for Product Code segment derivation for COGS. Setup Category set and Category Accounts for COGS account of product code segment derivation. Derivation of Product code segment for PO, BOM and WIP transaction.

•Configuring Financial Setups and EPM Global solution for IR ISO and Factory Direct design. Design needs to calculate the transfer price for a cost at the Intercompany Transactions.

•Solution, Design and implementation for Deferred COGS in SMMC Business unit which is as part of EPM global solution.

•CRP sessions, testing for End-to-End process and resolving issues created from Finance Business Lead and users.

•Responsible for Team management, Project Deliverables, Cut over plan and Risk mitigation

•Design and implement IR /ISO, Derive Accounting distributions form different Categories and Outside Processing.

•Design and implement for Intercompany and Factory drop ship Orders.

Arrow Electronics Denver, CO Nov 2010– May 2015 Finance Projects Implementations and Oracle Application Support

ERP Functional Analyst

This Role involved:

•Oracle ERP suite of Oracle R11 and R12 Instance – Receivables, Payables, General Ledger, iReceivables, iPayment, iExpense, Trade Management, Purchasing, Inventory & Cash Management.

• Configuring various finance and iexpense projects. Design, Solution and implementation for Automation of Financial Month End Close Process (Pre closer, Closer and Post closer)

•Custom solution and prepare Functional Requirement Specifications documents (Data Migration, Customization, Interfaces and Reports)

•Finalizing the setups and configuration of the instance to meet requirements. Designed and executed several Projects, extensions, customizations in Oracle ERP as part of Revenue Recognition solutions. Projects include Blind Agency, Revenue and Cost Recognize by Location segment, Freight Classification and Sold to Location.

•Analysis, Design, Configure, Implementation and support for iexpense system which includes Integration with Amex transactions, HR data feed from Workday, Mark View and Account Payables. iExpense system is implemented with Requirement gathering, Business Process flow, Interaction with other vendors and Training.

•Setup, Design, Implement and Troubleshoot for GL, AP, AR, FA, PO (Drop ship and Intercompany Functionality), Credit Card payments/setups in Receivables, iReceivable and iPayment

•Extensive testing of data migration components to ensure accuracy.

•Writing SQL queries on TOAD to address requirements for data-analysis, Fix and Reconciliation

•Preparation of Test scripts and conducting post go-live support, Business/ User training and ensuring smooth period

•closure

• Proactive monitoring of interfaces to minimize the number of exceptions (Revenue and Cost Recognition)

• Management reporting on support tickets movement, nature of issues and timely identify the root cause and resolution

WIPRO Feb 2008– Oct 2010

Lead Consultant

Client: Rheem Manufacturing Atlanta, GA

Project: Implementation of R12 Oracle Application System

Lead Consultant

Oracle Financials- Receivables, Payables, General Ledger, Trade Management, Install Base, Purchasing, Inventory, OM, OTM, BOM, WIP, EAM, and Inventory, iReceivables, iPayments and iStore.

•Analyzed previous Claim system of Rheem and designed a New Custom Extension solution which is interfaced to Oracle Trade Management (Claims), Install Base, Service Contracts and Finance. The solution is implemented with custom objects, which integrates with Oracle Inventory and Finance (AP and Trade management). This extension solution involved design of several ADF custom forms with complex business logic.

•Involved in study of existing business process, Identify the required GAPs. Data Mapping, Design and create BRD, Functional Specification and functional data flow

•Responsible for RICEW (Data Templates, Data Mapping, Business Validations) objects solution for Finance PO, Identified the Gap and Designed Functional design documents and solutions.

•Finalizing the setups and configuration of the client instance to meet client requirements for GL, AR Receivable and AP Account Payables Setups.

•Creation and maintain of GL Accounting Flex field values, Security and Cross Validation Rules, Auto Post Criteria set, Rollup Groups and Recurring Journals

•Understand and modify Application Configuration as required (includes system setups, flex-fields, workflow builder, profile options etc.).

•Developing functional specifications for custom enhancements & coordinating with technical team for final deliverables

•Setup, Monitor and troubleshooting of GL, AR (Auto Invoice and Lock Box) and AP (PO receipt and AP invoices) Interfaces

•Managing offshore team, load balancing and team allocation on deliverables and issue resolution

•Finalizing the New setups and configuration of the client instance to meet client requirements

•Coordinating with development team for development and testing of custom components changed due to Upgrade.

Client: Therm-O-Disc Mansfield, OH

Project: Implementation of Oracle Application (Therm-O-Disc Mansfield, OH subsidiary of Emerson and a part of Emerson Appliance Solutions and Emerson Climate Technologies)

Lead Consultant

EBS Oracle Receivables, Payables, General Ledger, Purchasing, Inventory, Order Management, BOM, WIP, WMS

Responsibilities include,

•Involved in all the process of Therm-O-Disc project starting from Analysis to GO LIVE. This project included with modules like Finance, Inventory, Purchasing, CST, OM, BOM and WIP.

•Conducted a functional review of existing business processes and preparation of As-Is flows for the changes

•Responsible for all RICEW deliverables, Presentations to client to explain Oracle new architecture and flows

•Test integrity of Data Conversions, Interfaces, customizations and Reports to ensure no overrides for Oracle 11 migration.

•Finalizing Design and conducting detailed discussions for Solution for RICEW custom components

•Preparing BRD and Functional Requirement Specifications documents (BR and MD) for identified Customizations.

•Finalizing the New setups and configuration of the client instance to meet client requirements

•Managing Deliverables, Milestones, Resource Planning & Work Allocation

•Preparation of CRP scripts and demonstrating Oracle flows to the client

•Discussions with client team to understand roles and responsibilities in the organization to design Menus in the System Administration module to meet the SOX requirements

•Responsible for Migration strategies (PVCS and Kintana) and cutover planning for UAT and GO LIVE

•Extensive testing of data migration components to ensure accuracy

Alpha Soft Apr 2007– Feb 2008

Consultant

Client: Office Depot, Boca Raton FL

Techno Functional Consultant

Oracle Receivables, Payables, General Ledger, Purchasing, Inventory and Order Management.

Responsibilities include,

•Conducting detailed requirement analysis and preparing the Fit-Gap Analysis documents

•Finalizing Design of the implementation and conducting detailed discussions for development of custom components

•Preparing Functional Requirement Specifications documents for Approved Supplier List (ASL), IR ISO and Item master and Cost Conversion and Interface.

• Finalizing the setups and configuration of the client instance to meet client requirements

•Coordinating with development team for development and testing of custom components

•Extensive testing of data migration components to ensure accuracy

•Preparation of CRP scripts and demonstrating Oracle flows to the client

•Co-ordination with Oracle support for issue resolution

•Proactive monitoring of interfaces to minimize number of exceptions

•Developing functional specifications for custom enhancements & coordinating with technical team

•Writing SQL queries on TOAD to address client requirements for data-analysis, audit

•Testing of custom enhancements pre-deployment & validation of components

CGI

Apr 2006 – Mar 2007

Client: Implementation of Oracle Application at Arrow Electronics, NY USA

Associate Consultant

Oracle Application 11i - Oracle Receivables, Payables, General Ledger, Purchasing, Inventory and Order Management.

Responsibilities include,

•Configuring various finance and project modules

•Conducting detailed discussions for development of custom components

•Preparing Functional Requirement Specifications documents (Data Migration, Interfaces and Reports)

•Coordinating with development team for development for all RICE custom components

•Managed as well as participated in cross-functional (Mainframe and Legacy) teams from task initiation through task completion.

•Interaction with Domain managers to understand the requirements and convert design document into a IT solutions Conducting

•Co-ordination with Oracle support for issue resolution from Oracle SR

•Functional Support and New enhancements for Oracle Production Environment

•Proactive monitoring of interfaces to minimize number of exceptions and also help in analysis and approval of data-fixes and patches

•Manage team at Onsite and Offshore and responsible for all deliverables

Honeywell Bangalore, India May 2005 – Mar 2006

Implementation of Oracle Application at Honeywell

Project Lead

Oracle Application 11i - Oracle Receivables, Payables, General Ledger, Purchasing, Inventory, Project Billing and Project Costing

IBM, India Dec 2002-May 2005

Client: Williams Energy Tulsa, OK

Tech Consultant

Oracle Application 11i - Oracle Receivables (AR), Payables (AP), General Ledger (GL), Purchasing (PO), Inventory (INV), Order Management (OM)

Client: CTA Chicago, IL

Technical Consultant

Oracle Application 11i - Oracle Receivables, Oracle Payables, Oracle General Ledger, Oracle Purchasing, Oracle Projects (Billing and Costing), Oracle Grants (GMS)

iCelerate Technologies Jul 2001 – Dec 2002

Oracle EBS Applications Environment:

Oracle EBS: Oracle R12, 11.5.10.2 and Toad

Oracle Application Finance Modules: Oracle Receivables (AR), Payables (AP), General Ledger (GL), Cash

Management (CE), Fixed Assets (FA), Trade Management (OZF), SLA

Concepts, AGIS (Intercompany), Oracle Projects (PA), Oracle Grants (GMS)

iExpense, Report Manager, EIS Reports

Tax Integration: Vertex, Mark view

Oracle Application Operations Modules: Oracle Purchasing (PO), Inventory (INV), Costing (CST) Order

Management (OM), OTM, CRM applications.

Quote, Service, Costing, Oracle Sales and Marketing, WMS

Oracle Application Manufacturing: Inventory (Inv), Bill of Material (BOM) and WIP

Oracle Application Foundation Modules: AOL and SYSADMIN

OS Environment: LINUX, UNIX, HP-UX, AIX, LINUX, Sun® Solaris

AIM Methodology: CV10, CV60, TE40, BR100 BR110, MD50, BR10, BR030

Oracle EBS Phases: UAT, SIT, Project GO-NO Go, Oracle SR resolution

Languages:

PL /SQL, SQL, C, PRO *C and UNIX shell Script

Development Tools:

PL /SQL, SQL, SQL Loader, Oracle Forms 4.5/6i, Oracle Reports 4.5, Workflow Builder 2.6, APEX,

JDeveloper, C, Proc *C, UNIX Shell Script, XML Publisher, ODI, Web ADI and Oracle Discoverer

Migration Tools: Kintana, MKS, CVS, Winscp, Putty and Stat

Oracle DB: Oracle 10g, 11g, 9i and 8

Contact this candidate