Dhanunjaya Ketha

336-***-**** / ac9z71@r.postjobfree.com

Oracle ERP Techno Functional Consultant

SUMMARY

Over 14 years of experience in implementing effective solutions in Oracle E-Business Suite R12 (12.2.X/12.1.X), 11i (11.5.10/11.5.9/11.5.8) and Oracle Database 11g/10g/9i.

Successfully completed several Full Life Cycle Implementations of Oracle Financials (GL, AR, AP, FA, CE, AGIS, TCA and Advanced Collections), Manufacturing and SCM modules (PO, OM, INV, iProcurement and iSupplier), PA modules (Project Management, Projects Costing, Projects Billing) and OTL, Oracle HR.

Extensive experience in Design, Development and Production Support of Interfaces (Inbound/Outbound), Data Conversions and Data Extraction Programs using Oracle Open Interfaces, APIs, SQL, PL/SQL, SQL Loader and UNIX Shell Scripts.

Experience in Design, Development of OA Framework, OA Page Personalization, OA Extensions, XML/BI Publisher Reports, Forms, Reports, Workflows and Forms Personalization.

Very good understanding of Order to Cash (O2C) and Procure to Pay (P2P) life Cycles.

Expertise in SQL and PL/SQL programming. Extensive experience in developing Stored Procedures, Functions, Packages, Triggers, Indexes and SQL Queries using SQL*Plus, TOAD and PLSQL Developer development tools.

In-depth knowledge on Oracle WebADI, AOL (Application Object Library), AME (Approvals Management), OA Framework and Oracle Public APIs (Applications Program Interfaces).

Very good understanding of Functional Setups in all the Oracle financials modules.

Took professional training on Fusion Middleware, Oracle ADF, BPEL and Oracle Service Bus.

Took professional training on Oracle Fusion Financials and HCM Cloud.

Expertise in implementing Multi-Org structure using MOAC (Multiple Organization Access Control).

Extensive knowledge on R12 Accounting Concepts and Oracle SLA (Oracle Subledger Accounting).

Extensive experience in Performance Tuning of very complex SQL Queries, PL/SQL Programs using Explain Plan, SQL Trace, TKPROF and STATSPACK.

Extensive experience in set up of Concurrent Programs, Executables, Request Sets, Value Sets, Lookups and Flex Fields.

Experience in Interacting with Business Users, Gathering Requirements, System Analysis, Gap Analysis, Unit Testing, Integration Testing and Documentation.

Experience in AIM (Application Implementation Methodology).

Excellent communication and inter-personal skills.

Proven track record of successful implementation of medium to large projects for very big clients like Salesforce, FedEx, GE Health Care, CSX, Nabors Industries and Wood Group.

SKILLS

Oracle Applications R12, 11i :

(E-Business Suite)

General Ledger (GL), Accounts Receivables (AR), Advanced Collections (IEX), Accounts Payables (AP), Cash Management (CE), Subledger Accounting (SLA), Trading Community Architecture (TCA), Fixed Assets (FA), iSupplier, iProcurement (ICX), Inventory (INV), Purchasing (PO), Project Accounting (PA), Project Costing, Project Billing, Projects Management, Oracle Approvals Management (AME), Human Resources (HR), Applications Object Library (AOL), Electronic Data Interchange (EDI), Alerts, and Multiple Organization Access Control (MOAC)

RDBMS :

Oracle Database 10g, 9i

Development Tools :

JDeveloper, XML Publisher (BI Publisher), Workflow Builder, Oracle Forms & Reports 10g/6i, Discoverer 10g, SQL * Plus, TOAD, PLSQL Developer and SQL Loader

Programming Languages :

SQL, PL/SQL, UNIX Shell Scripting, C and JAVA

Scheduling Tools :

AppWorx 5.1, $U

Version Control Tools :

GitHub, PVCS Tracker, Star Team and Clearcase

Operating Systems :

UNIX SUN OS 5.8, HPUX RISC (64 Bit), WINDOWS and MS-DOS

EDUCATION:

Bachelor of Engineering, India

CERTIFICATIONS:

Oracle Financials Cloud: Payables 2017 Certified Implementation Specialist

PROFESSIONAL EXPERIENCE:

Salesforce, Indianapolis, IN

Sr. Oracle Applications Consultant - May 18 to Current

Employer: EZ2 Technologies Inc/Caspex

Description: This is a 12.1.3 to 12.2.8 upgrade and implementation of new projects in the following modules oracle EBS Suite for Salesforce. My work involved designing and developing custom applications, legacy application integration, interfaces, reports, extensions in the following modules: General Ledger (GL), Advanced Global Intercompany Settlement (AGIS), Payables (AP), Receivables (AR) and Cash management (CM).

Responsibilities:

Design and Development of following Interfaces/reports for Lease Accelerator business of Salesforce.

Journal Import interface between Lease Accelerator and Oracle EBS.

FX Rates and Chart of Accounts Integrations from Oracle EBS and Lease Accelerator

Payables Invoice integration from Oracle EBS to Lease Accelerator

BI Publishers reports for reconciliation.

Design and Development of Interfaces/reports/configurations for Intercompany Settlement of EMEA Reseller business entities.

Configure AGIS application to setup Organizations, Transaction Types, User Security, Customer and Supplier Associations, Intercompany Accounts.

Configure Payables bank accounts, Payment Process profiles and Pay groups.

Payables Payment extraction, Receipt Creation and Receipt application using public Receipts APIs.

Journal Import interface between TMS and Oracle EBS.

BI Publishers reports for reconciliation.

Support 12.1.3 to 12.2.8 upgrade

Use secure key encryption for all integrations files exchange.

Involve in daily standup SCRUM meetings.

Provide support during Period and Quarter close.

Use FNDLOAD, XDOLoader and XMLImporter for migrating various components of AOL, BI Publisher Reports and OA Pages between oracle apps instances

Creating database objects like Packages, Stored Procedures, Functions and Indexes required in the interface development.

Unit Testing, Integration Testing and User Acceptance Testing of the functional Setups and Technical Development components

Environment:

Oracle Applications R12.2.8, GL, AGIS, AP, AR, FA and CM.

ORACLE 11g, SQL * Plus, TOAD, and BI Publisher

Wood Group Mustang, Houston, TX

Sr. Oracle Applications Consultant - May 17 to Apr 18

Employer: EZ2 Technologies Inc

Description: This is a 12.1.3 implementation of the following modules oracle EBS Suite for Wood Group Mustang. My work involved designing and developing custom applications, legacy application integration, interfaces, reports, extensions in the following modules: Project Costing, Project Billing, Project Management, OTL and Payroll.

Responsibilities:

Design and Development of following Interfaces for Infinity, Elkhorn businesses of Wood Group.

Interface from Project Billing to OilDex to transfer Customer invoices to Oildex Open Invoice system in PiDx format.

Interface to create Expenditures in Projects Costing for the Field Service Timecards using PRC: Transaction Import

Interface to transfer equipment usage cost to Projects Costing as Expenditures using PRC: Transaction Import

Create OTL timesheets using APIs from the timecard data entered in Field Service custom application.

Design and Development of Conversions for Infinity, Elkhorn businesses of Wood Group.

Projects and Budgets conversion

Project Agreements and Funding Lines conversion

Change Order conversion and application of the Fin Impact lines to Financial Plan

Labor and Non Labor Bill Rate conversion

Employee Conversion

Projects Forecast Extension to include custom forecast logic.

Design and development of a custom Web ADIs

Webadi to upload/update Planned Work Quantities to Project Workplan

Webadi to upload/update Actual Progress Quantities to Project Workplan

Webadi to upload Equipment Assignment activities to custom equipment application

Development of custom reports using BI Publisher

Used FNDLOAD, XDOLoader and XMLImporter for migrating various components of AOL, BI Publisher Reports and OA Pages between oracle apps instances

Creating database objects like Packages, Stored Procedures, Functions and Indexes required in the interface development.

Unit Testing, Integration Testing and User Acceptance Testing of the functional Setups and Technical Development components

Environment:

Oracle Applications R12.1.3, Project Costing, Project Billing, Project Management, OTL and Payroll

ORACLE 11g, SQL * Plus, TOAD, and BI Publisher

Nabors Industries, Houston, TX

Sr. Oracle Applications Consultant - Dec 15 to Apr 17

Employer: EZ2 Technologies Inc

Description: This is a 12.1.3 implementation of Supply Chain Management (SCM) and Financials modules for Nabors Industries. Implementation of Supplier Life Cycle Management (SLM), iProcurement (ICX), iSupplier (POS), Purchasing (PO), Payables (AP), Payments (IBY), Approvals Management (AME).

Responsibilities:

Design and Development of the following processes

Payable Invoice integration from a legacy system called ‘NSG’ using Payables Open Interface Import program

Prospective Supplier Registration configuration and approval through Approvals Management (AME) and Customization of Supplier Registration Approval workflow.

Customization of Requisition Approval workflow and approval of requisitions through Approvals Management (AME)

Blanket Agreement import using Purchasing Documents Open Interface

Payable Invoice Entry through Payables Requests and approval of Non PO Invoice Request through Approvals Management (AME)

User Interface changes using OA Framework (OAF) CO Extensions, VO Extensions, VO Substitutions, Adding Custom Regions and Personalization’s etc. in the following UI Pages.

Prospective Vendor Registration pages

iProcurement Shopping Cart, Car Checkout and Requisition Approval Notification pages

iSupplier Invoice Creation pages and Supplier Profile Management pages

RFQ, Quote creation and Quote Comparison and analysis pages

Order Search and Creation pages and Agreement search and Creation pages in Buyer Work Center

Non PO Invoice creation and approval notification pages in Payables Requests

Implemented Captcha Service for secure user Login using OA Framework extensions

Created Event Subscriptions for seeded business events and related code that gets executed for these events.

Created a Web ADI to import Blanket Agreement import using Purchasing Documents Open Interface

Configuration of Approvals Management for approval of Requisitions, Prospective Suppliers, Non PO Invoices

Developed several BI Publisher Reports.

Used FNDLOAD, XDOLoader and XMLImporter for migrating various components of AOL, BI Publisher Reports and OA Pages between oracle apps instances

Creating database objects like Packages, Stored Procedures, Functions and Indexes required in the interface development.

Unit Testing, Integration Testing and User Acceptance Testing of the functional Setups and Technical Development components

Environment:

Oracle Applications R12.1.3, ICX, POS, SLM, iSupplier, iProcurement, AP, PO, IBY, and INV

ORACLE 11g, SQL * Plus, TOAD, OA Framework (OAF), JDeveloper and BI Publisher

CSX, Jacksonville, FL

Sr. Oracle Applications Consultant - Apr 13 to Nov 15

Employer: EZ2 Technologies Inc

Description: CSX has implemented almost all oracle applications (12.1.3, 12.2.3) modules. My work involved designing and developing custom applications, legacy application integration, interfaces, reports, extensions in the following modules: AP, Subledger Accounting (XLA), Financial Accounting Hub (FAH), iProcurement (ICX), iSupplier (POS), PO and INV.

Responsibilities:

Designing and Developing of a Custom Oracle Warranty and Core System

Developed UI using OA Framework (jDeveloper)

Provide capability to Create Requisitions, POs, AP Invoices and Return to Inventory transactions from the custom OA Framework pages

Developed reports using BI Publisher

Upgrade from 12.1.3 to 12.2.3

Designing and development of Procurement Card Transactions integration.

Development of Employee Supplier Bank Accounts interface with People Soft HR application.

Designing and Developing of MAXIMO integrations

Interface Material Issues and Returns, Purchase Requisitions and Receiving Transactions

Add customizations to seeded objects

Setting up of Financial Accounting Hub to import journal entries and related transaction details into Subledger Accounting and developing technical components related to this integration.

Developed several OA Framework Extensions and Personalizations for iProcurement and iSupplier Portal modules

Used FNDLOAD, XDOLoader and XMLImporter for migrating various components of AOL, BI Publisher Reports and OA Pages between oracle apps instances

Creating database objects like Packages, Stored Procedures, Functions and Indexes required in the interface development.

Unit Testing, Integration Testing and User Acceptance Testing of the functional Setups and Technical Development components

Environment:

Oracle Applications R12.1.3, AP, XLA, OM, PO, ICX, POS and INV

ORACLE 11g, SQL * Plus, TOAD, EDI Gateway, OA Framework (OAF), JDeveloper and BI Publisher

Fortegra Financials, Jacksonville, FL

Sr. Oracle Applications Consultant - July 11 to Apr 13

Employer: EZ2 Technologies Inc

Description: This is a Fresh R12 (12.1.3) implementation for Fortegra Financials. Fortegra implemented GL, AP, AR, PO, Oracle Payments (IBY), Cash Management (CE) and Fixed Assets (FA) modules to manage their Payment Protection and Consecta Insurance businesses.

Responsibilities:

Lead designing of the following processes:

AS400 to Oracle AP interface for Importing Payment Protection and Consecta Invoices using Payables Open Interface Import program

Supplier Conversion/Interface to import Payment Protection & Consecta Suppliers to Oracle

820 Payment Order/Remittance Advice Interface with Wells Fargo Payment Manager to Upload 820 Payment Instruction Files

Cash Management Bank Statement Loader Interface to Import BAI2 files received from Wells Fargo to reconcile AP Payment and AR Receipts transactions.

ProtectCell to Oracle AR Invoice Conversion/Interface using AutoInvoice

Customer Conversion/Interface to import Customer data from ProtectCell to Oracle

Payments Interface using AutoLockbox to import AR Receipts from CyberSource to do Cash Applications

Customized ANSI 820 e-Text RTF Template as per Wells Fargo 820 Payment File requirements to generate Text Payment Instruction files.

Developed Custom XML Check Templates for various Bank Accounts for In-House Check Printing using BI Publisher.

Created Templates in Bills Presentment to print AR Invoices

Worked with TekStream to Implement AP Scanning Solution which uses Oracle Document Capture, Oracle Forms Recognition and WebCenter Imaging to Scan paper/email invoices and import them into Oracle Payables

Receivables Setups: Transaction Types, Sources, AutoInvoice Lines Ordering and Grouping Rules, Receipt Sources, Receipt Classes, Lockboxes and Lockbox Transmission format etc.

Payables and Payments setups: Bank Accounts, Payments Documents, Invoice Sources, Pay Groups, XML Templates, Payment Formats, Payment Process Profiles and Payment Templates etc.

Customized e-Text RTF Template to enable Wells Fargo to send the Check PDF Images back to Fortegra Server.

Designed and Developed a Accounts Mapping Custom OA Page to map AS400 account string to Oracle Account string

Developed a OA Extension (VO) on Bank Accounts page to add Bank Name to the account search LOV.

Implemented MOAC in the setups and Custom Conversion/Interface code

Helped in resolving issues related to Assets Mass Additions functionality and Assets Reports

Developed several BI Publisher reports for various reporting requirements.

Developed SQL Queries and functions for AME Approvals Management Setups.

Developed SQL Queries to generate for SOX Audit Reports.

Created a Custom WebADI Integrator to import the Invoices related to 1099 Suppliers.

Environment:

Oracle Applications R12.1.3, GL, AR, AP, PO, iReceivables, Oracle Payments, Cash Management and Assets

Oracle Document Capture (ODC), Oracle Forms Recognition (OFR) and WebCenter Imaging (IPM)

ORACLE 11g, SQL * Plus, TOAD, WebADI, OA Framework (OAF), JDeveloper and BI Publisher, SQL Loader, Oracle Forms & Reports.

SWIFT Energy Company, Houston, TX

Sr. Oracle Applications Consultant - Nov 10 to June 11

Employer: EZ2 Technologies Inc

Description: This is a 11.5.10 (11i) to 12.1.3 (R12) Upgrade Project for Swift. Swift uses P2 Energy Solutions (P2ES) modules like EU, EB, EE and JVA etc for its Oil and Gas Operations. P2ES Integrates directly with Oracle EBS. As part of this Upgrade Implementation Swift is Upgrading to Oracle Database 11g (11.2.0.2.0), Oracle EBS to 12.1.3 and P2ES to Version 34. Interfaces, Custom Reports, Custom Forms and Discoverer Reports in P2ES, AP, GL, PO, AR, OTL and HRMS modules are upgraded to R12.

Responsibilities:

Designing and Developing of the following Interfaces for Electronic Invoicing (These interfaces are fresh implementations)

PO Interface to Export Purchase Orders to ADP

AP Invoice interface to import Invoices for ADP Open Invoice Users

Implemented a Custom Solution in the Payables Invoice Workbench for Defaulting DFF values from Payable Invoice LINE Distributions on to Invoice TAX distributions.

Created a Custom e-Text template to generate Payment Instruction Output in Text format in Payables Payments Process.

Implemented a Custom Solution in JVA SWEEP process to Transfer Detailed Accounting Entries for Period End PO Receipt Accruals to JVA module.

Created Several OAF Personalization’s on AP Supplier Pages, AR Customer Creation Pages and OTL Employee Self Service Pages.

Customized OTL Timecard approval workflow to Timeout after 12 Days from Check Date and to hold Approval process Submission till Check Date.

Developed and Upgraded several Discoverer Reports Using Discoverer Administrator and Discoverer Plus

Created several Oracle Alerts to inform/email users of specific business events.

Environment:

Oracle Applications R12, GL, AP, AR, OTL, HRMS, Alerts, Oracle WebADI and AOL

ORACLE 11g, SQL * Plus, TOAD, OA Framework (OAF), JDeveloper, Discoverer and BI Publisher, SQL Loader, WorkFlow Builder, Oracle Forms & Reports.

P2ES Modules: EU, EB, EE and JVA.

Oracle Solaris 10 (64 Bit)

Republic National Distributing Company (RNDC), Houston, TX

Sr. Oracle Applications Consultant - Jun 10 to Nov 10

Employer: EZ2 Technologies Inc

Description: RNDC implemented Oracle Payables (AP), General Ledger (GL) and HRMS as part of their Technology upgrade.

Responsibilities:

Gathering requirements, Designing and Developing of the following Interfaces and Conversions

AP Invoice Interface from ASW-AP to Oracle-AP using Invoice Open Interface Import

Supplier and Supplier Site conversion from ASW to Oracle

Journal Entry Import from ASW-GL to Oracle-GL using GL interface

Employee Interface from Optimum Legacy system to Oracle HR using HR_EMPLOYEE_API

Involved in Chart of Accounts structure changes to add Employee Segment using Flex Field Express software

Developed Scripts and Views to support Chart of Accounts changes

Designed and Developed a Workflow Process to use as a Common Notification process for all Interface Error Conditions

Designed and Developed a Accounts Mapping Custom OA Page to map ASW account string to Oracle Account string

Used Config Snapshot tool to compare and find differences during Setup Migration

Environment:

Oracle Applications R12, GL, AP, HRMS, Oracle WebADI and AOL

ORACLE 11g, SQL * Plus, TOAD, OA Framework (OAF), JDeveloper and BI Publisher, SQL Loader, WorkFlow Builder

FedEx, Memphis, TN

Sr. Oracle Applications Consultant - May 07 to Nov 08 and Jul 09 to May 10

Employer: EZ2 Technologies Inc

Description: FedEx implemented a suite of integrated systems to facilitate standardized Ship to Collect (STC) process to improve Customer Experience and lower operational costs. As part of Oracle ERP implementation FedEx implemented Oracle Receivables (AR), Advanced Collections (IEX), Trading Community Architecture (TCA) and Subledger Accounting (SLA).

Responsibilities:

Gathering requirements, Fit Gap Analysis, Designing and Developing the following Conversions and Interfaces

Customer Conversion from CHEERS to Oracle AR using Trading Community Architecture (TCA) public APIs

Invoice Conversion from IPAR to Oracle AR using AutoInvoice standard interface

Daily Payments Interface using Auto Lockbox

Created the Mapping Documents to map the legacy Customer record fields to Oracle TCA Registry fields for Customer Conversion.

Implemented MOAC concepts in all Custom Interfaces and Conversions.

Redesigned and developed the Customer Interfaces to support Party Merge, Customer Account Merge, Party Relationships and Customer Account Relationships.

Defined Matching Rules for Data Quality Management (DQM).

Setting up Scoring Components, Scoring Engines, Work Items and Collections Strategies in Advanced Collections.

Setting up Receivables related Functional Setups like Transaction Sources, Payment Terms, Receipt Sources, Receipt Classes, Receipt Methods, Lockboxes and the corresponding matching rules.

Designing and Developing Custom PL/SQL packages to Calculate Pre Scores and provide these scores to Scoring Engine Harness to Improve Collections Performance.

Created Following Custom WebADI Integrators.

WebADI for Remittance File upload.

WebADI for Next Review Date update.

WebADI for Payment File Upload.

Designing and Developing RTF Templates, Data Template Definitions, Data Definitions for various reports using XML Publisher (BI Publisher), XSL and XSL-FO functions.

Designing and Developing the following Custom OA Pages using JDeveloper.

Oracle AR to CHEERS Customer Update Screen

Invoice Reprints screen

IPAR Invoice and AirBill balance enquiry screen

Personalizing the Receipt Summary, Receipt Applications and Apply in Detail Forms using Forms Personalization.

Creating a custom SLAM, Application Accounting Definition (AAD), Journal Line Definition (JLD), Journal Line Type (JLT) and Account Derivation Rules (ADR) in Subledger Accounting (SLA).

Developing Views and PL/SQL functions for various Scoring Components.

Designing and Developing Work Flow Processes for various Strategy Work Items

Generating Trace files and TKPROFs and analyzing them to tune the performance of the conversions and interfaces.

Environment:

Oracle Applications R12, GL, AR, Advanced Collections (IEX), Subledger Accounting (SLA), TCA, DQM, Oracle WebADI and AOL

ORACLE 10g, SQL * Plus, TOAD, OA Framework (OAF), JDeveloper and XML Publisher, SQL Loader, WorkFlow Builder

HP UX RISC (64 Bit), $U (Scheduling Tool)

GE Health Care-US, AVIVA Insurance-UK (Tata Consultancy Services Ltd)

Sr. Oracle Applications Developer – May 04 to Jan 07

Responsibilities:

Developed Receivables and Payables conversions for AVIVA insurance company.

Developed custom workflows for payables customizations.

Support around 25 integrations in several oracle applications modules related to GEHC.

Responsible for developing several custom reports using Reports 6i.

Personalized several standard Forms for various requirements using Forms Personalization.

Registering Applications Object Library components like concurrent programs, request sets, Value sets.

Creating custom database objects like Packages, Stored Procedures, Functions, Triggers and Indexes required in the interface development.

Creating and scheduling AppWorx chains and modules.

Preparing MD 70-Detailed design document.

Environment:

Oracle Applications 11i (11.5.10), AP, AR, GL, CE, OM, PO, AME Oracle HR, Payroll and AOL

ORACLE 9i, SQL * Plus, PL/SQL developer, Discoverer, UNIX SUN OS 5.8 and AppWorx

Contact this candidate