OTM Technical-Functional Analyst

Title: Senior OTM Technical-Functional Analyst
Location : Cleveland, OH
Target Start Date : 12/08/2025
Type: CTH
Pay Rate / Salary : $65 - $77/HR | $100-$125K

Overview
We are seeking a highly skilled Senior OTM Technical-Functional Analyst to play a key role in designing, developing, and implementing advanced solutions for transportation and logistics systems. This position requires deep expertise in Oracle Transportation Management (OTM), strong technical development capabilities, and the ability to collaborate across operations, business, and IT teams to ensure optimal system integration, performance, and reliability.

Key Responsibilities

• Configure, enhance, and optimize OTM components including agents, workflows, statuses, and route groups.
• Develop advanced PL/SQL packages, stored procedures, queries, triggers, and perform database performance tuning.
• Integrate OTM with external systems using web services, XML, middleware platforms, ELD/telematics solutions, and APIs.
• Monitor OTM servers and environments, resolving issues related to application performance, logs, threading, and system stability.
• Perform root cause analysis for performance bottlenecks within workflows, agents, and integrations.
• Diagnose and resolve thread management issues, agent delays, deadlocks, and contention within OTM.
• Conduct database tuning, query optimization, and table/index maintenance to improve OTM performance.
• Collaborate with DBAs and system administrators on server load balancing, patching, upgrades, and capacity planning.
• Apply strong transportation and fleet domain expertise, including truckload operations, dispatch, compliance, and asset utilization.
• Develop and support dashboards, analytics, and reporting using BI Publisher and Tableau.
• Perform fit-gap analysis and design scalable, low-customization OTM fleet solutions aligned with business needs.

• 7 years of hands-on Oracle Transportation Management (OTM) development experience.
• Deep understanding of OTM data structures, fleet-specific tables, driver/asset workflows, and transaction lifecycles.
• Proven proficiency in OTM configuration—agents, workflow logic, automation, and event triggers.
• Strong background in OTM environment optimization and server performance tuning.
• Advanced PL/SQL debugging, query optimization, and handling of high-volume OTM transactions.
• Ability to analyze and resolve thread contention, deadlocks, queue/agent delays, and integration failures.
• Experience in OTM scalability planning, performance testing, and environment resilience.
• Strong analytical and problem-solving skills for complex OTM, integration, and infrastructure issues.

• Experience with OTM Cloud migrations, architecture, or roadmap planning.
• Familiarity with OTM Fleet Management modules, including:
  • Driver and equipment management
  • Dispatching and routing
  • Power unit/asset tracking
  • Translating operational requirements into scalable OTM fleet configurations

Welcome to ConsultNet and the family of companies, Tekne, SaltClick, TechBridge, and OmniMedia. As a premier national provider of technology talent and solutions, our expertise spans across project services, contract-to-hire, direct placement, and managed services both onshore and nearshore.

Celebrating more than 25 years of partnership with a diverse client base, we've crafted rewarding opportunities for our consultants, fostering high-performing teams that deliver impactful results.

Over the last few years thousands of consultants have found their calling with us in roles that have made a meaningful impact on their lives, enhanced their career, challenged them, and propelled them towards achieving their personal and professional goals. At the ConsultNet family of companies, we believe effective communication is crucial in aligning the right job with your unique skills and professional aspirations. To us, it's all about the personal approach we take and the values we uphold.

Our comprehensive service offerings cover a wide range of technology positions across key markets nationwide. Client more at www.consultnet.com .

We champion equality and inclusivity, proudly supporting an Equal Opportunity Employer policy. We welcome applicants regardless of Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other status protected by law.