Kapil Sahu

WORK HISTORY

EDUCATION

ABOUT KAPIL SAHU

Oracle Finance Consultant in IBM Gurgaon, India November 2017 – Present Responsibilities: • Completed training in PL/SQL, BI Publisher reports, Putty, WinSCP & P2P cycle of Oracle Apps R12 in IBM (Nov-17 to Mar-18).• Working with UK client (Apr-18 to Present) on following modules in Oracle Apps R12:Financial Accounting Hub:• Define new “Premium” source as an Application and event classes and event types in Financial Accounting Hub to transfer the accounting of Premium transactions in General Ledger.• Create Mapping sets to map the source code attributes with Entity segment.• Define Journal line rules and journal entry rule sets to transfer the accounting generated for 3rd party Premium transaction into General Ledger.• Define Processing Unit size in General Ledger for Premium application to process accounting of number of transactions in single journal.Account Payables & Tax:• Developed an Oracle custom report for showing “Invoices with Hold” details using XML and RTF templates.• Modified existing custom reports “Supplier Duplicate Payment Report” & “Corporate Report” using XML and RTF templates.• Developed an Oracle Wrapper program to call “Payment Instruction Register” program internally and send an output to business using PL/SQL.• Design drill down sql query from GL to AP to provide Audit extract to Business on ad-hoc basis.• Create new tax setup as per the change in Ireland Government policies to process Supplier invoices for the Payment.Procurement:• Developed an Audit Purchase Order Deletion Report using PL/SQL to capture deleted Purchase Order in the System by enabling Audit trails on Purchase Order tables.• Customized existing iProcurement responsibilities to disable “Purchase Order Checkbox” and added new messages and TIPS to avoid automatic creation of Purchase Order after the approval of Requisition.Account Receivables:• Customized existing Oracle seeded report “AR Aging Report” to include receipt information.• Design custom “AR to GL Reconciliation” extract to identify accounting of AR transactions in General Ledger.• Resolve priority issues like period closing and Dunning statement by providing data fix or configuration change as solution.General Ledger:• Created new setup for new Budget journals for the year end budgeting.• Setup new entity in Primary ledger for accounting purpose.• Create new Custom responsibilities to restrict the data for specific entities and Consolidation ledgers only.• Design “GL to Accurate” outbound interface to send subledger Journals to Accurate Cube for the reporting purpose.