Oracle Erp Ebs

BALA SUBRAMANIAN

Senior Oracle eBS/Cloud ERP - Technical/Technofunctional Consultant

832-***-**** *****@********.*** Houston, TX

SUMMARY

Oracle eBS professional with over 25 years of experience in technical consulting and business transformation, expert in Oracle ERP and integration solutions.

Key achievements include the successful integration of ERP systems with external vendor and customer systems, and leveraging ERP capabilities to drive business transformation. Passionate about enhancing business processes through ERP integration and customization with proven technical and functional abilities across multiple industries. Eager to leverage skills in developing innovative solutions and contributing to the transformation of enterprise systems, aligning with the goal of optimizing operational performance. The proven track record of improving client satisfaction and operational efficiency aligns seamlessly with the mission of enhancing business operations through innovative Oracle solutions.

•

•

•

•

•

EXPERIENCE

06/2023 - Present

Remote(New harford,NY)

Senior Oracle eBS Techno-functional Consultant

PCC

Development and maintenance of interface programs for Finance and SCM Analyze enhancement requests, design, develop, coordinate testing and deploy enhancements in production instance

Ensure daily data sharing from Oracle ERP to Data Warehouse and ensure timely propagation of data happens to the data warehouse from Oracle ERP Help resolve any issues to enable timely completion of month-end close activities Customized requisition approval workflow to add additional approval routing for specific values used for cost center and account segments of charge account used in the requisition

01/2021 - 05/2023

Remote(Cary, NC)

Senior Oracle ERP Advisory Consultant

Skillsoft

Integration of GL Journals from Oracle to PeopleSoft: Worked with Peoplesoft team to understand the requirement and defined and implemented the GL Journal interface to PeopleSoft

Worked with integration partner team and internal team in defining the integration solution for Sales Orders, Purchase Orders, Supplier invoices, Invoice and Sales Order synch and Customer credit balance synch with D365

Analysis and design of new solutions and development and work with business track leads to plan and prioritize the deliverables

Work with DBAs on database related issue resolution, instance refresh and path deployment

Integration of Oracle ERP with Salesforce: Developed and implemented integration between Salesforce and Oracle ERP for real time synch of Customer Master, Sales order and Customer credit balances.

Integration of Oracle ERP with Coupa: Developed and implemented integration between Oracle ERP and Coupa for real time synch of Vendor Master, Invoice and payments and Vendor balances

Integration of Oracle ERP with D365: Worked with the implementation partner to provide the data mapping for Purchase order and AP invoices Data Migration: Used FBDI extract to migrate master data for Supplier, Customer, AR Invoices and Purchase Orders using FBDI templates. BI Report Customizations: Modified other BIP reports to change the output format and to made it available to the custom role and assign it to the user. Custom ESS Job and Roles: Defined custom ESS jobs and made it available to users

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

E

EXPERIENCE

02/2017 - 12/2020

Remote(Cary, NC)

Senior Oracle eBS Advisory Consultant

Global Knowledge

O2C, P2P, SFDC integration

Oracle Workflow, PLSQL, Data conversion and Integration, RICEW, BIP and OTBI Designed and implemented daily open invoice and customer integration to TermSunch to facilitate timely AR collection activities. Designed and implemented AR Credit memo creation automation using AR Credit memo API

Worked with the external business partner and internal stakeholders from the AP team to analyze the business requirement

Designed and implemented integration solution to send daily vendor specific outstanding Payables balances, Vendor Master changes and VOID payments to external business partner to facilitate the timely payment activities Daily production issue resolutions to enable business continuity which involves both technical and functional issues

Support the business team with month end close activities and help resolve any issues to enable timely completion of month-end close activities Improved client satisfaction scores by 15% by implementing more efficient ERP systems and streamlined workflows.

Implemented ERP solutions, increasing efficiency by 25% for client projects. 02/2017 - 05/2017

Remote(Austin,TX)

Senior Oracle ERP Technical Consultant

SmartDog

Oracle Teleservice Modules

Used Oracle Workflow, PLSQL and RICEW, BIP and OTBI Customizations in RMA Sales order receipt & Shipment confirmation for Order Management Line

Followed Workflow processes for line flow - Generic and Line flow - Return for credit Customized receipt workflow processes to submit a concurrent program when line status changes to 'CLOSED'

Sent a custom notification when the line status became 'CLOSED' Attached concurrent program output to a custom notification Customized Teleservice Contact Center Dashboard to display customer Credit limit, amount used, and amount remaining based on OM, AR & OM interfaces and AR Invoice

04/2015 - 01/2017

Houston

Senior Oracle ERP business transformation consultant Exterran

Collaborated with stakeholders at different levels to promote, deliver and implement business solutions

As part of the GEMINI project, worked in the company split related technical activities to split the database, transactions and master data related to Oracle ERP modules Redesigned PLM description generator plugin to reduce the processing time and increase the efficiency

Automated the data cleanups by eliminating manual data loader tasks of AP Invoice cancellation, Finally closed POs, Cancel requisitions and close OM order lines by using APIs which tremendously reduced the cutover time Designed and implemented custom solutions to automate the material requirement planning ahead of time when it is time for preventive maintenance. Enhanced reporting accuracy by 25% by integrating advanced data mapping techniques.

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

EXPERIENCE

03/2014 - 04/2015

Houston

Senior Oracle ERP Technical Consultant

Parker Drilling Company

Projects, Purchasing, and Finance, P2P and O2C cycles Oracle Skills Used: Oracle Workflow, PLSQL, Data conversion and Integration Part of the Oracle R12 implementation team implementing Project Costing, SCM and eAM

Involved in the designed an development of solution to handle centralized procurement which involved PO and Req account generator customization for Project related and non project related SCM/FIN transactions Designed and developed Auto Accounting customization for deriving accounting segments when transactions are imported into Project Costing Worked with users, stakeholders and team members of different level in solution design and implementation

Responsible for Project/Task data conversion and SCM Receipts data conversion from legacy applications

10/2013 - 02/2014

Houston, TX

Senior ERP Consultant - Oracle GTM integration with Oracle SCM

(R12.1.3)

Noble Energy

Senior oracle eBS TechnoFunctional Consultant - Oracle GTM integration with Oracle SCM(R12.1.3)

Part of the Oracle Global Trade Compliance(Oracle GTM) implementation initiative to integrate eBS and GTM

Responsible for the eBS side of the integration solution in facilitating the compliance screening of Non-locally sourced Purchase Order created eBS before the PO is approved in eBS

Integration solution was accomplished through a non-invasive customization of the Seeded PO Approval workflow Process

Raising custom business events and SOA web services which will hand off the data to GTM for compliance screening

Once PO is screened in GTM, depending on the screening outcome the eBS PO Approval is transitioned for further DOA approval

02/2013 - 09/2013

Houston, TX

Senior Oracle ERP Technical Consultant

NOV

Part of the Global implementation team involved in the implementation of Release 12.1.3 for the global business units

Responsible for the Sales Orders data conversion and Customers Conversion Implemented business solution to interface WIP Work orders from MS Projects to Oracle WIP using WIP Mass Load API

Addressed a number of production support issues or enhancement requests involving Forms Personalization, Interfaces and trouble-shooting production support issues Achieved 20% reduction in operational bottlenecks by implementing streamlined workflows for ERP systems.

06/2012 - 01/2013

Houston, TX

Senior Oracle ERP Technical Consultant

MUSTANG Engineering

Version R12(12.1.3) - Oracle Project Costing & Billing and Project Management Oracle Workflow, PLSQL, Oracle Reports, APIs and Extensions, XML/BI Publisher, Data Mapping and Data Conversion, RICEW, OBIEE

Have been involved in the reimplementation of Oracle EBS from 11.5.10 to R12(12.1.3) Involved in the Conversion, customizations and extensions related to Oracle Project Costing and Billing

Responsible for Project, Financial Plans and other bill rate data mapping and conversions

Implemented Custom Solution for Percent complete Revenue for Lump sum projects using Extensions

Involved in the custom Deposit/Prepayments solution design, development and implementation

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

EXPERIENCE

05/2011 - 05/2012

Houston

Senior Oracle ERP Technical Consultant

Occidental Petroleum Corporation (OXY)

Hired back again with a specific task to work on the enhanced R2P solution implementation which will integrate the ADP’s OIR and Open Invoice applications with Oracle eBS Oracle Purchasing and Oracle Payables.

Key deliverables includes identify key enhancement requirements, define and develop the enhancement, co-ordinate testing and implement. 01/2011 - 04/2011

Houston

Senior Oracle ERP Technical Consultant

SWIFT Energy Company

Technical team member involved in the upgrade activates of Oracle EBS from 11.5.10 to 12.1.2

Also involved in the day to day issue resolution of production environment specific to Financials/EU Base, EU Land, EU Production, AFE and JVA Contributed in the redesign/rewrite of PO Workflow approval customizations in R12 Implemented the 3D (Data Drill Down) functionality in AFE, JVA and Production EU modules

01/2010 - 12/2010

Houston

Senior Oracle ERP Technical Consultant

Occidental Petroleum Corporation (OXY)

Production support, Project APIs and Extensions, Reconciliation issue resolutions Web ADI, XML/BI Publisher, RICEW

Joined the team which helps the month end reconciliation issues related to Project Costing, GL and other modules

Primarily responsible for identifying resolutions for the issues related to the reconciliation of Project Costing against GL and other modules, which involves interaction with the business, end users and IT team members Successfully fixed the issues related to PowerTax interface reload PowerTax interface extracts cost data from Projects and creates records in a staging table for the PowerPlants application to use

There were issues related to this interface since go-live and my task was to identify the issues, fix the interface code and complete the reload of the interface for the period from Jan-2010 to Aug-2010, which was completed successfully Resolving production issues SRs related to Project costing Maintaining precise, documented configurations across multiple simultaneous application instances

Worked with the business analysts to identify issues, test the solutions and to get the approvals

Document the solution and test scripts to be used for multiple iterations of testing 03/2009 - 06/2010

Houston

Sr Oracle ERP Technical Lead-Consultant

Geokinetics Inc

Create design documents using AIM, PLSQL, Oracle Reports, Oracle Workflow, Production support, Project APIs and Extensions, RICEW Involved in multiple level of technical activities which comprises of solution design, develop specification and code development for multiple RICEW object in Project Accounting, AR, GL and AP modules

Managing a team of 5 technical resources to ensure the timely delivery of technical solutions

Involved in the implementation of R12 Financial and Oracle Project modules Implemented interfaces from Projects to GL, ATO cost accrual interface to Projects and ATO hours interface to OTL

Implemented pre-processing extension for the import process and Customized Billing Extensions in Projects

Performed the setups of User Defined Attributes (UDAS) and created program to upload the UDA values

Performed configurations for using the billing and pre-processing extensions Developed and implemented multiple month end reconciliation PA reports in XML publisher with the XLS out format

Implemented Oracle Benefits outbound interface of Benefits and COBRA to external vendors

1998 - 2009 Multiple Contract ERP implementation/support consultant roles

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

EDUCATION

1990 - 1992

India

M.B.A (Systems)

Annamalai University

CERTIFICATION

ISO 9000

TRAINING / COURSES

OTBI reporting training Oracle Cloud technical training SKILLS

Business transformation using ERP Procedure Development API Interface Analysis Conversion Analysis Interface Design API BI Publisher Data Extraction Data Mapping Data Migration E-business GTM HCM HRMS OBIEE Oracle Oracle Cloud Oracle Database Oracle E-business Suite Oracle Reports P2P Peoplesoft Performance Monitoring PLM PLSQL Reporting Tools Routing Salesforce SCM SDLC SFDC Smartview

Contact this candidate