Orcale EBS Techno Functional Consultant

Royal Cyber; United States; Remote; USD 90,000 - 130,000; Full time

Job summary

Royal Cyber is seeking an Oracle EBS Techno-Functional Consultant to gather business requirements, configure EBS R12 modules, and document MD50/BR100 designs. The role covers AS-IS/TO-BE mapping across O2C, P2P and RTCR, with Multi-Org setups and extensive reporting and interfaces work.

Excellence in PL/SQL, Oracle Forms/Reports, BI Publisher, Discoverer and OA tools is required. Expect collaboration with global teams, production support, and occasional offshore coordination.

Qualifications

• Must have hands-on experience configuring Oracle EBS R12 modules and performing fit-gap analyses.
• Experience documenting business requirements and designs (MD50/BR100).
• Strong knowledge of finance and supply chain modules, multi-org setups, and GL/AR/AP workflows.

Responsibilities

• Gather and analyze business requirements across Finance and SCM; run workshops and document outcomes as MD50 and BR100 documents.
• Configure EBS R12 modules, perform fit-gap analyses and favor standard functionality where possible.
• Map AS-IS and TO-BE processes across Order-to-Cash, Procure-to-Pay and Record-to-Report; set up Multi-Org structures and key flexfields.
• Support period close, reconciliations, month-end and year-end issue resolution.
• Develop reports using Oracle Reports, XML/BI Publisher, Discoverer and custom SQL; build interfaces and conversions using Open Interfaces, APIs, SQL*Loader and UTL_FILE.
• Configure Oracle Workflow Builder, AME, Alerts and concurrent programs; manage AOL objects and My Oracle Support tickets.

Skills

MD50 functional design

BR100 setup

AS-IS TO-BE design

Multi-Org structure

Chart of Accounts

Flexfields configuration

Ledgers & Inventory setup

Period close processes

SQL

PL/SQL

Oracle Reports

BI Publisher/Discoverer

Oracle Forms Personalization

APIs/Open Interfaces

AOL concurrent programs

My Oracle Support

Tools

EBS R12 Modules

Open Interface tables

SQL*Loader

UTL_FILE

Workflow Builder

AME

MD70 design documents

Consolidated interfaces & conversions

Job description

Dear Candidate,

We have Job opening for Oracle EBS Techno Functional Consultant, please find the detailed description below

Company Details

Royal Cyber is a trusted global IT consulting & digital transformation partner, empowering enterprises for over two decades to evolve with agility, security, and innovation. Founded in 2002, Royal Cyber has built a strong legacy of helping organizations modernize legacy systems, embrace cloud-native technologies, and adopt AI-driven solutions. With 20+ years of delivering business-critical digital projects, we serve clients across USA, Canada, UK, UAE, KSA, India, Australia, and more with innovation hubs and delivery centers strategically located to support 24/7 operations. Global Presence: Headquartered in Naperville, IL (USA) Operations in 15+ countries 1,000+ certified consultants 1,000+ successful global deployments Fortune 500 client base across retail, banking, insurance, manufacturing, healthcare, and public sector What We Specialize In: Cloud Transformation & DevOps (Azure, GCP, AWS) Generative & Agentic AI (Enterprise-grade use cases powered by LLMs) Digital Commerce & CX Platforms (Salesforce, SAP Commerce, Adobe, Magento, Creatio, HubSpot, Commerce tools) Enterprise Integration & API Management (MuleSoft, Boomi, IBM) Hyper automation & Low Code Enablement (UiPath, Appian, Power Platform) Data Governance, Privacy & Security (Microsoft Purview, Zero Trust) Legacy Modernization & Mainframe Refactoring (COBOL to Java, Monolith to Microservices)Royal Cyber is on a journey to become the worlds most agile modernization partner blending innovation, strategy, and delivery excellence to accelerate enterprise evolutionKey

Responsibilities

Techno Functional

• Gather and analyse business requirements across Finance and SCM; run workshops with process owners and document outcomes as MD50 functional design documents and BR100 setup documents
• Configure EBS R12 modules, perform fit-gap analysis, and favour standard functionality over customisation where practical
• Map current-state (AS-IS) and design future-state (TO-BE) processes across Order-to-Cash, Procure-to-Pay and Record-to-Report
• Set up Multi-Org structures, chart of accounts and key flexfields, ledgers, operating units, inventory organisations and approval hierarchies
• Support period close, reconciliations, month-end and year-end issue resolution

Technical

• Develop reports using Oracle Reports, XML/BI Publisher, Discoverer and custom SQL
• Build and customise Oracle Forms and personalisations (Forms Personalization, CUSTOM.pll)
• Write PL/SQL packages, procedures, functions and triggers; performance-tune long-running queries
• Build inbound and outbound interfaces and conversions using Open Interface tables, APIs, SQL*Loader and UTL_FILE
• Configure Oracle Workflow Builder, Approvals Management Engine (AME), Alerts and concurrent programs
• Register custom objects via AOL concurrent programs, value sets, lookups, profile options, responsibilities and menus
• Produce MD70 technical design documents and support migration across instances

Delivery & Support

• Prepare test scripts, lead SIT/UAT, and drive defect triage to closure
• Provide production support and on-call issue resolution; perform root cause analysis on recurring defects
• Raise and manage Oracle SRs through My Oracle Support; apply patches and test regression impact
• Produce configuration workbooks, user guides, training material and cutover plans
• Work with business, IT, DBA and offshore delivery teams across the full lifecycle

Work timings 6.30 pm to 3.30 am IST