Role Overview
We are seeking a highly skilled Oracle OTM Technical / Functional Consultant with deep domain experience in transportation, logistics, and supply chain. In this role, you will translate business requirements into OTM solutions, lead technical development, integrate with external systems, optimize performance, and support full lifecycle implementations.
Key Responsibilities
* Gather & analyze business requirements; map them to OTM configurations and build activities
* Automate business processes using OTM workflows and agents
* Design, code, and configure workflows, agents, screen sets, layouts and user interface components
* Handle master data, itineraries, order planning, shipment execution, route optimization, and network setup
* Develop and maintain OTM data model schemas; ensure in-depth understanding of OTM data structures
* Design and implement technical integrations using OTM REST and SOAP APIs
* Create operational & analytical reports, dashboards, alerts, and metrics
* Tune performance, troubleshoot configuration and runtime issues
* Manage deployments and migrations in stage / production environments
* Migrate data & configurations from cloud to on-prem or between environments
* Write and optimize SQL queries for reporting, data extraction, and debugging
* Support SR resolution, system logging, data export procedures
* Define rate card templates, structures, and pricing models inside OTM
* Make technical UI adjustments (screen sets, manager layouts)
* Collaborate with 3PL, carrier, logistics, and external integration teams
* Create technical documentation, functional specs, and design documents
* Configure security, VPD (Virtual Private Domain) access, and domain rules in OTM
* Setup and manage OTM workbench configurations
* Support Freight Audit & Pay processes within OTM
* Work with multi-mode transport (e.g. LTL, FTL, ocean, air) and multi-leg, multi-stop routing
* Handle exception management, business monitors, alerts, and error handling
* Partner with stakeholders to elicit OTM requirements and ensure alignment
Required Skills & Experience
* 10+ years of hands-on experience implementing and customizing Oracle OTM
* Strong technical and functional knowledge of OTM, including data model/schema
* Experience designing and coding OTM workflows and agents
* Deep knowledge of integration via REST/SOAP APIs and data imports/exports
* Strong SQL skills; experience building queries, debugging, and performance tuning
* Proven experience with deployment, migration, environment management
* Familiarity with logistics operations: order planning, routing, network configuration, mode optimization, shipment execution
* Experience with security, VPD configuration, access controls
* Excellent problem solving, analytical thinking, stakeholder communication
* Experience working with logistics / supply chain / 3PL integration teams
* Ability to write clear technical and functional documentation