Ravi
SUMMARY
Experienced Oracle EBS, Fusion/Cloud and Integration professional with over 15 years of
experience with proven track record of success with an ability to execute and deliver
Experienced in variety of tools, technologies, technical project management and execution.
Exceeds expectations by overcoming challenges to meet the project objectives
Experience of working with the track and task leaders to formulate and define systems scope
and objectives based on both user group needs and a good understanding of applicable
business systems and industry requirements
Coordinated and facilitated offshore development teams and third-party providers such as
global preferred vendors or central service providers and worked in various geographies like
India, South Africa, UK and USA
More than 15 years of working experience in various On-Premise and Cloud technologies, in
multiple projects in lead roles with excellent technical project, team & task management skills
Worked on Cloud Applications such as Oracle Sales Cloud, Service Cloud, Field Service
Cloud, Workday HCM and integrating them with On-Premise EBS Application using SOA
Suites like Oracle BPEL & Integration Cloud (PaaS Offering)
Measure and monitor progress to ensure application releases are delivered on time and meet
expectations
Identifying all applicable stakeholders per release, notify, communicate, and manage
expectations during the planning and roll-out of new releases
Handson experience developing APIs using MuleSoft and managed a project to integrate with
Salesforce
Expertise in Oracle PaaS offerings such as Integration Cloud (OIC), Database Cloud (DBCS),
ATP and good understanding of Visual Builder (VBCS)
Proficient in Integration design and hands-on development of Inbound/Outbound integrations
using Integration Cloud (OIC)
Experience leading integration design and managing stakeholder expectations
Extensive experience in maintaining development plan, tasks allocation, task monitoring,
establishing/monitoring quality process, study/audit of existing business process and
preparation of issue logs, requirement gathering, user interaction, gap analysis, technical data
mapping and analysis
Enthusiastic to learn new concepts quickly and assimilate new ideas efficiently
Worked in various domains like Insurance, Energy, Manufacturing, Media etc.,
Hands-on experience with Agile/Scrum methodologies. Track and monitor project scope,
risks, issues, and action items. Ability to influence and drive teams to success using Agile
CERTIFICATIONS
Oracle certified SQL, PL/SQL 9i Developer
Oracle recognized Discoverer Developer (Oracle University, Bangalore)
Attended Oracle Apps UK Payroll Functional (Payroll, Self Service & Fast Formula) training
from Oracle University, Chennai
MuleSoft Certified Developer (Mule 4)
EDUCATION
Master of Science, Information Systems – Acharya Nagarjuna University 2003
Bachelor of Computer Applications – Sri Venkateswara University 2001
SKILLS SUMMARY
Languages Oracle SQL, PL/SQL, HTML, XML, Java
Oracle ERP/EBS Oracle E-business Suite Financials, Supply Chain and CRM/Service - General Ledger,
Accounts Payable, Accounts Receivable, Purchasing, iProcurement, iExpense, Order
Management, Quoting, Inventory, Project Accounting, Cash Management, Oracle Tele
Service, Field Service, Mobile Field Service and Service Contracts
Cloud/SaaS Oracle Financials (GL, Payables & Receivables), Supply Chain (Procurement,
Inventory, Order Management)
Oracle Sales Cloud, Service Cloud, Field Service Cloud, Salesforce and Workday HCM
Integration & BPM Oracle Integration Cloud, MuleSoft and Pega BPM
Tools SQL *Loader, OA Framework, Application Express (APEX), VBCS, BPEL & J Developer
BPEL Designer, Oracle XML Publisher, Oracle Developer Suite (Forms 6i, 10g &
Reports 6i, 10g), Oracle Discoverer, TOAD, PL/SQL Developer, Data Loader, File Zilla
(FTP), Win SCP, Kintana, Jenkins, Git
Methodologies Software Development Lifecycle (SDLC), Application Implementation Methodology
(AIM) and Agile
Scripting/ Shell Scripting using Unix, Linux and Sun Solaris
PROFESSIONAL EXPERIENCE
eBay (Remote) May 2021 – Present
Oracle Fusion – Application Development and Integration
Description:
Participating in design sessions, understanding the overall interface strategy, providing inputs
and building proof of concepts to confirm the feasibility
Understanding of functional requirement, formulating technical solution and preparing
technical design documents
Building BIP Reports to call it as web service from other external systems, creation of ESS
jobs to trigger BIP reports on schedule basis to external systems
Working with functional consultants to design best possible technical solution for the business
need and amending the standard BPM workflows in Order Management
Using SOAP & REST standard APIs of Fusion and managing the Subscriptions/Events of
Supply Chain modules (especially Procurement, Inventory and Order Management) with in
Integration Cloud (OIC)
Creating personalizations to enable PaaS VBCS screens accessible from Fusion and building
custom applications using VBCS
Configuring the Business Events using Integration Cloud and enriching the default Payloads
to have additional attributes as per the business requirement
Working with other integration teams to make them understand Oracle process and/or various
APIs in Oracle and providing the required API to be able integrate with Oracle
Creating SRs with Oracle support for any product issues or fixes. Monitor the releases the
analyse the impact of the same to Standard & Custom (extensions built) functionality
Working with functional teams and business teams for end-to-end testing, supporting the UAT
Creating the deployment instructions and codepacks
Environment: Oracle Fusion Financials, Supply Chain, Oracle Integration Cloud, VBCS, SQL, Soap
UI and Postman
Raydiant – San Francisco, CA Feb 2018 – Apr 2021
Senior Consultant and Integration Architect - Oracle Fusion Implementation
Role Description: Senior Cloud Technical Consultant and Integration Architect
Responsibilities:
Managing technical tasks and prioritize them according to its urgency and dependency.
Running the scrum call on regular basis
Responsible for data extracts, mapping of fields from legacy system with Fusion Financials
and Supply Chain
Proof of Concepts for data conversions of various master and transactional data
Defining the data conversion strategy from source system to Oracle Fusion/SaaS system
Building BIP Reports to call it as web service from other external systems, creation of ESS
jobs to trigger BIP reports on schedule basis to external systems
Data migration/conversion using FBDI into Oracle Fusion modules
Building custom applications using VBCS and ORDS, to be accessible from Oracle Fusion
screens
Working with functional consultants to design best possible technical solution for the business
need and amending the standard BPM workflows
Developing APIs for legacy systems to validate the Journals that needs to be posted to
Fusion General Ledger
Configuring the Business Events using Integration Cloud and enhancing the default Payloads
as per the requirement
Building APIs using ORDS (Oracle REST Data Services) & Apex to expose PL/SQL
Packages as API End Points for integrating with other Cloud applications
Integrating Field Service with Oracle EBS, to replenish inventory, create inventory
transactions, Orders for inventory, labour, travel and Install Base create/update for record
keeping using Oracle Integration Cloud (PaaS)
Proficient in working with Fusions SOAP & REST APIs and using of OOTB Adapters (for
Service Cloud and Field Service Cloud) available in Integration Cloud
Developing OTBI Reports/Dashboards and BIP Reports for integrating with external systems
by using object storage and other cloud platforms
Developed a framework in Oracle Apex to monitor the integrations and logging, also helps in
retrying the transactions in case of errors after fixing the data
Experience working with agile methodologies using CI/CD techniques in a DevOps
environment and Git
Triage production issues, report the root cause and providing permanent resolution/fix
Creating SRs with Oracle support for any product issues or fixes. Monitor the releases the
analyse the impact of the same to Standard & Custom (extensions built) functionality
Environment: Oracle Fusion Financials, Supply Chain, Service Cloud/RightNow, Field Service Cloud,
Integration Cloud (OIC) and Mulesoft
MOOD Media – Austin, TX Dec 2013 – Jan 2018
Project Description: Mood Media Corporation - Oracle EBS Integration and Conversion of Muzak.
Scope of work includes converting the Muzak’s data into MOOD’s Oracle EBS and integrating the
other legacy systems. Also, development of forms and reports using Oracle APEX. Implementation of
Oracle Cloud Applications and integration with On-Premise Applications
Responsibilities:
Responsible for Technical components/upgrade from 12.1.3 to 12.2.8, identifying of
components and retrofitting the same
Responsible to develop fallback and restart strategy when integrations are down for any
reason
Generating integration errors report and E-Mailing on daily basis for easy Production
Monitoring, providing re-try and/or re-trigger mechanism for all failed integrations/messages
Loading of Master Data and Transactional Data like Customers using TCA, AP Invoices, AR
Invoices, Install Base instances, Item On-hand etc.,
Worked on building integrations to trigger/convert the data from Oracle EBS to Service Cloud
& Field Service Cloud using Oracle Integration Cloud (OIC)
Working with OFSC REST APIs and using of OOTB Adapters (for Service Cloud, Field
Service Cloud and Workday) available in Integration Cloud
Very good experience of working with Oracle Field Service Cloud, setting up Resources,
Activities, Inventories, Business Rules, Work Zones, Routing
Pulling the data from Field Service Cloud for record keeping and reporting purposes in EBS
Design of overall interface strategy between Oracle EBS, Cloud and other legacy systems of
Mood, handling exception scenarios in case of fallback
Enabling the Oracle Database for REST capabilities, creating modules, handlers and
templates and hands-on development to write APIs to provide the End Point URLs to be used
by other systems for integration
Customized iReceivables to have Autopay registration and anonymous user login (without
having to register for login). Customized/personalized the user dashboard/BPA Pages
Worked on a customization in Service Contracts to increase the Counters as per the Business
requirement based on the number of exchanges by Customer
Creating Warranty Contracts using Install Base and BOMs, and managing the Entitlements
for servicing the Customer
Using of Warranties to process Charges for Depot Repair using Entitlements and Coverage
Templates defined in Service Contracts
Worked extensively in development of interface and conversion programs using PL/SQL and
API’s. Migration of legacy data to Oracle & Cloud Applications. Knowledge of underlying table
structure of Applications for development of enhanced functionalities. IT Project Support and
involvement in risks identifications and risk mitigations
Customized the standard OAF pages of iStore to serve their Independent Affiliates (Dealers)
Working with Tele Services/Charges to define Business Process, Service Activities and
mapping the same with Item/Service configurations
Designed a Process to receive RMAs for Installs and Cancellations, and manage them using
Service Requests in Tele Services
Design and development of forms required to integrate Oracle Order Management/Shipping
with UPS to enable the Warehouse users for shipping and to schedule the return pick-ups
Customizing/developing various reports in Order Management and Inventory to suit the needs
to MOOD-Muzak Business process
Unit testing and System Acceptance testing of the components. Also supporting the UAT
Responsible to estimate and review the effort required to develop the module/Change
Requests
Worked on OAF Personalizations and also customizing the existing AP-AR Netting form to
display in a single form as well to delete both records if either of them are deleted
Involved in implementing and Customizing the Account Generator in Oracle iProcurement
Customized the seeded functionality to receive the Invoices related to iProcurement Punch
outs into multiple Operating Units in Payables
Setting up the Realm in iProcurement to restrict access to the Store to a specific responsibility
Worked with AME (Approvals Management Engine) in iProcurement to configure the rules,
conditions, attributes etc as per the Business Requirement
Creation of alerts to monitor the daily processes, improve the automation thus reducing the
manual intervention
Environment: Oracle R12 Financials, Supply Chain & CRM Modules, Sales Cloud, Service Cloud,
Field Service Cloud, Oracle Integration Cloud (OIC), PL/SQL, Oracle Forms & Reports, Oracle BI
Publisher (XML Publisher), Oracle APEX, Forms & Reports
Ciena Corp Apr 2013 – Nov
2013
Lead Techno-Functional Consultant - Oracle Apps EBiz
Project Description: Ciena Corporation - Oracle Apps EBiz integration with Telamon
Integrating the Ciena’s Oracle Apps system with Telamon to automate the Business process, involves
B2B Integration using the EDI signals. Also involved in Ciena-Nortel acquisition and integration of the
systems
Responsible for interacting with Business for requirements and analyzing the existing process
Writing the Functional Design Document (MD050s) and Technical Design Documents
(MD070s) based on the Business Requirement document
Leading technical onsite & offshore project team, task allocation, status monitoring and
ensuring quality & timely delivery of the deliverables
Experience in working with different EDI Signals like 850 (Order Creation), 860 (Order
Update), 861 (Receiving), 945 (Pick-Release & Ship Confirm)
Designing of B2B Tables to receive the EDI Signals to integrate the Telamon’s Enterprise
system with Ciena’s Oracle system
Writing interfaces in Order Management using different Standard APIs of OM Module to
integrate the Orders coming from Telamon
Developed the Interface error handling forms to review the Sales Order data received from
Telamon and correct the errors if any & reprocess/reject the same
Developed an interface to automate the process of Sales Order creation (No Touch) based on
Customer PO from Ciena’s CPODS System
Worked on automating the process of Sales Order returns using the Process Order API
Defined various setups in Order Management such as Picking Rules, Carriers, Service
Levels, Ship Methods etc.,
Responsible for field mapping between Ciena’s Oracle System and Telamon’s Enterprise
system
Resolving the issues related to Procure to Pay (P2P), Order to Cash (O2C) and Quoting
Migration of current Citi Bank cards to US Bank cards in iExpense
Uploading/Conversion of Tax Exemptions into Oracle EB Tax and attaching the supporting
documents using the FND APIs (Mass uploading of the .pdf files to Oracle EBS
programmatically)
Worked on various interfaces to Telamon such as Items, Categories, On-hand balances,
receipts etc.,
Working with Integration Teams and legacy Application Teams to analyse the impact of on-
going changes
Environment: Oracle Apps – General Ledger, Payables, Receivables, Fixed Assets, Purchasing,
Projects, iProcurement, Order Management, Service Contracts, Install Base, Quoting, Inventory,
iExpenses, SQL, PL/SQL, SQL Developer, Oracle Developer Suite (Forms & Reports), XML
Publisher, APEX and Unix
Constellation, an Exelon Company Nov 2011 – Mar
2013
Senior Techno-Functional Consultant - Oracle Apps R12 Enhancements /Support
Project Description: Constellation, an Exelon Company - Oracle Apps Enhancements/Support
To support the on-going enhancements and maintenance of Constellation Entergy Enterprise system.
Also involves implementation of new modules and integrating the Constellation with Exelon’s
Enterprise system
Responsible for managing the overall technical deliverables including helpdesk tickets/change
requests related to Oracle Production instance including bug fix & enhancements
Leading technical onsite & offshore project team, task allocation, status monitoring and
ensuring quality & timely delivery of the deliverables which are in form of issues resolution,
bug fix migration, user’s assistance, escalation handling, new development effort, testing and
migration
Interacting with users to understand the support issues and resolving the same on time
Involved in the Data extraction from Oracle Apps to send it to Vendor Management System
(VMS) to support workforce solutions
Developed various Unix scripts such as Archiving of the files, moving them to different servers
etc.,
Creation of alerts to monitor the daily processes, improve the automation thus reducing the
manual intervention
Worked on Install Base open interface to synchronizes with subsystems by importing item
instances from different feeder systems
Mapping of the legacy Constellation data with Exelon (Projects, Supply Spend)
Worked on Items classification and updating the cycle count for the current year in Oracle
Inventory
Updating the receipt tolerance for items and items sales tax code in Oracle Inventory
Responsible for ‘Close’ related activities and resolving the issues within stipulated time
Preparing the SLA Report (detailing the Tickets, Enhancements, Data Fixes etc.,) and sharing
with customer
Environment: Oracle Apps Release 12.1.3 – General Ledger, Payables, Receivables, Fixed Assets,
Purchasing, Projects, iProcurement, Order Management, Service Contracts, Install Base, Quoting,
WHM, Inventory, iExpenses, SQL, PL/SQL, SQL Developer, Oracle Developer Suite (Forms &
Reports), XML Publisher, Paybase/C-Series and Unix
PricewaterhouseCoopers (PwC) Nov 2010 – Oct 2011
Technical Lead - Oracle Applications R12 Re-Implementation
Oracle R12 Upgrade, Re-Implementation & Rollout
Leading development team at onsite and offshore successfully to meet the technical
milestones as per development plan ensuring quality and schedules
Establishing quality processes and ensuring processes are followed as per defined standards
and guidelines
Day to day status tracking on development RICE components with offshore development
team and updating the status to onsite project manager
Worked on defining the Security Profiles using Multi-Org or Multiple Organization Access
Control (MOAC)
Involved in the Data migration from Legacy systems to Oracle
Worked on Check printing using BI Publisher
Worked with QA team to design test plan and test cases for User Acceptance Testing (UAT)
Helped QA analysts and technical team with troubleshooting and fault resolution
Environment: Oracle R12 AP, GL, PL/SQL, Oracle Forms & Reports and TOAD
Aviva Sep 2009 – Oct
2010
Techno-Functional Consultant - Oracle R12 Implementation & Rollout
Responsible for customization of Check Print Process. Design of the check template as per
business requirements and customization of Oracle Packages to implement custom Check
Print solution
Customization of EFT Payment Process. Customization of EFT template as per business
requirements and customization of Oracle Packages, and development of custom packages
to implement custom EFT solution
Responsible to define the Security Profiles/Global Security Profile using Multi-Org or Multiple
Organization Access (MOAC) and assigning the responsibilities from one Business Group or
multiple Business Groups
Worked on customizing the Oracle provided Requisition workflow as per the Business
requirement in Purchasing/iProcurement
Worked on AME (Approvals Management Engine) to customize the workflow approval
process in iProcurement
Development of Unix Wrapper scripts for customization of Bank Statement Loader Program
Worked on the development of XML Publisher reports
Loading the data into Oracle e-Business Tax module from Vertex and integrate with Payables
and Receivables
Environment: Oracle Apps R12 GL, AP, FA, FSAH, EB Tax, iExpenses, iProcurement, SQL,
PL/SQL, SQL Developer, Oracle Developer Suite, XML Publisher and Unix
Scottish Water May 2008 – Aug
2009
Oracle CRM Consultant (Functional, Technical & Integration) and Project Lead
Liaison with Business people to capture the requirements and understanding the same
Involved in the Functional and Technical design of the solution
Responsible for writing Functional Specification and Technical Specification documents
Involved in the Interface Design Workshops (Dataflow) and documented the mappings
between different systems (Oracle CRM, Click Schedule, IMS and Integration)
Involved in writing the Functional and Technical Specification documents for integration
(Informatica & Web Services)
Responsible for the CRM Configuration (Lookups, LOVs, DFFs, Territories, SR Attributes
etc.,) and documenting the same (BR100)
Worked on APIs in Oracle Install Base to create/update Item Instances
Responsible for Impact Assessment of the Change Requests and Effort Estimation
Guiding the Testing Team and helping them to write System Test cases and the End-to-End
Test scripts
Support for User Acceptance Testing, Regression Testing and Rollout Testing
Worked with Business and other teams to prepare the solution for implementation/rollout and
documented the same
Environment: Oracle 11i (11.5.10) CRM (Tele Service, Field Service, Mobile Field Service), Install
Base, PL/SQL, Oracle Forms, Oracle Workflow, Oracle APEX, TOAD and Win SCP
National Grid Nov 2007 – Apr
2008
Oracle SoA (BPEL) Consultant
Technical consultant for Oracle BPEL, integration between the NG’s SAP system and Work
Management System
Liaison with business people to capture the changes in the existing business process
Responsible for writing Functional Specification and Technical Specification documents
Made the changes in the existing BPEL system to reflect the change in the business process
Preparation of the End-to-End test case document and involved in the System testing
Support for User Acceptance Testing
Responsible for implementing the changes in the production and post production support
Environment: Oracle BPEL (Process Manager, J Developer BPEL Designer)
University of Witwatersrand May 2007 – Oct
2007
Techno-Functional Consultant
Involved in all phases of custom module development and integration with Oracle Apps
Financials using Application Implementation Methodology (AIM). Following are the
responsibilities:
Requirements gathering from key-users and building of specification documents
Design of interfaces, reports and custom processes
The work also included estimating and reviewing the effort required to develop the
module/Change Requests
Design and development of reports using Oracle Reports 6i and Oracle BI Publisher
Responsible for conducting UAT sessions
Environment: Oracle 11i (11.5.10) Financials, PL/SQL, Oracle Forms & Reports, Oracle BI Publisher
(XML Publisher), PL/SQL Developer and Core FTP
Aviva Nov 2005 – Apr
2007
Technical Consultant, Module Lead
Technical consultant for Finance modules which includes GL, AP & AR
Also worked in Inventory, Order Management, Quoting, Service Contracts and Field Service
Involved in Preparing Templates and scripts required for Data Migration from Legacy system
to Oracle Applications as per Oracle On Demand Standards
Have built custom components using PL/SQL, required for integration of Oracle Apps with the
legacy system (ICON) using Oracle BPEL as middleware
Also developed and deployed BPEL Database Adapters to integrate with legacy system
Performance tuning of system processes to remove the bottlenecks for the system
Project Management – Project Status Notifications, Setting-Up Business Calls & Preparing
necessary project documents in accordance with AIM Methodology
Environment: Oracle 11i (11.5.10), Oracle Alerts, Oracle Forms & Reports, Oracle SQL, PL/SQL,
TOAD, Data Loader, File Zilla (FTP) and Oracle BPEL (Process Manager, J Developer BPEL
Designer)