Oracle ERP Technical Consultant

Ethereum Technologies LLC; Chicago (IL); On-site; USD 110,000 - 160,000; Full time

Job summary

Ethereum Technologies LLC is recruiting an ERP Technical Consultant to provide comprehensive Oracle Fusion technical support and system optimization. You will work with functional teams to implement and maintain ERP systems, develop BI/OTBI/BIP reports, and configure ESS jobs to meet business needs.

The role involves data loading/integration, customization of Oracle modules, and cloud-transition activities from E-Business Suite to Fusion Cloud.

Qualifications

• Experience delivering technical support and troubleshooting for Oracle Fusion ERP systems.
• Strong report development experience with BIP and OTBI; ESS job configurations.
• Configuring user roles and access within Oracle Fusion for proper security.
• In-depth knowledge of Fusion modules (Procurement, SCM, Financials, GL).
• Data loading and integration using FBDI, REST and SOAP services.
• Design and development of custom solutions with Oracle Forms, Reports, PL/SQL, OAF.
• ERP customization across Financials, SCM, HRMS, and Procurement.
• Develop and support integrations with third-party systems via APIs.
• Lead data migration/conversion strategies during upgrades or implementations.
• Optimize ERP performance through PL/SQL tuning and scheduled processes.
• Ensure system stability and security per standards.
• Create and maintain Technical and Functional Design Documents (TDD/FDD).
• Collaborate with functional teams, PMs and stakeholders to deliver ERP solutions.
• Provide cloud-transition expertise for EBS to Fusion Cloud.

Responsibilities

• Provide Oracle Fusion technical support to maintain system reliability and performance.
• Develop BI/OTBI/BIP reports and configure ESS jobs as required.
• Manage security: user names, roles, and privileges for proper access control.
• Support data loading and integration including items, PO, PR, suppliers, AP/AR invoices.
• Create custom solutions using Oracle Forms, Reports, PL/SQL, Workflow and OAF.
• Assist in data migration and conversion during ERP upgrades.
• Collaborate with functional consultants and stakeholders to deliver ERP solutions.
• Support cloud transition from EBS to Fusion Cloud.

Skills

Technical Support & Troubleshooting

Report Development

Security & Access Configuration

Fusion Module Expertise

Data Loading & Integration

Customization & Development

ERP Module Customization

API & Web Services Integration

Data Migration & Conversion

Performance Optimization

System Stability & Security

Documentation

Collaboration with Stakeholders

Cloud Transition Expertise

Tools

Oracle Forms

Oracle Reports

PL/SQL

Workflow

OAF

FBDI

REST

SOAP

Job description

The ERP Technical Consultant is responsible for providing comprehensive technical support and troubleshooting expertise for issues related to Oracle Fusion. This role demands proficiency in various Oracle Fusion and ERP technical areas and involves close collaboration with functional teams and stakeholders to ensure successful implementation and maintenance of Oracle ERP systems.

Key Responsibilities

• Technical Support and Troubleshooting: Provide dedicated support for Oracle Fusion, addressing and resolving technical issues to maintain system reliability and performance.
• Report Development: Demonstrate strong knowledge in developing BIP (BI Publisher) reports, OTBI (Oracle Transactional Business Intelligence) reports, and configuring ESS (Enterprise Scheduler Service) jobs. Customize and personalize reports as required, including bank report development and designing templates using RTF, Excel, e-text, and XSL.
• Security and Access Configuration: Handle configuration of user names, roles, and privileges to ensure appropriate access controls within the Oracle Fusion applications.
• Fusion Module Expertise: Possess in-depth technical knowledge across Oracle Fusion modules such as procurement, supply chain, financials, and general ledger, ensuring robust support and customisation as per business needs.
• Data Loading and Integration: Execute data loading activities for items, purchase orders (PO), purchase requisitions (PR), suppliers, receipts, accounts payable (AP) invoices, payments, accounts receivable (AR) invoices, receipts, journal imports, and customer imports using FBDI, REST, and SOAP services.
• Customization and Development: Design and develop custom solutions using Oracle Forms, Reports, PL/SQL, Workflow, and Oracle Application Framework (OAF). Implement RICE components, including reports, interfaces, conversions, and extensions.
• ERP Module Customization: Customize Oracle ERP modules—such as Financials, SCM, HRMS, and Procurement—tailored to specific business requirements.
• Integration with Third-Party Systems: Develop and support integrations between Oracle ERP and third-party systems utilizing APIs and web services.
• Data Migration and Conversion: Manage strategies for data migration and conversion during ERP upgrades or new implementations, ensuring data integrity and consistency.
• Performance Optimization: Optimize ERP performance by tuning PL/SQL queries and scheduling processes for efficient system operation.
• System Stability and Security: Ensure the stability, scalability, and compliance of ERP systems with security standards.
• Documentation: Prepare and maintain comprehensive technical documentation, including Technical Design Documents (TDD) and Functional Design Documents (FDD).
• Collaboration: Work closely with functional consultants, project managers, and stakeholders to deliver seamless ERP solutions.
• Cloud Transition Expertise: Provide specialized knowledge and support for organizations transitioning from Oracle E-Business Suite (EBS) to Oracle Fusion Cloud.

ETHEREUM TECHNOLOGIES LLC is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. ETHEREUM TECHNOLOGIES LLC will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will ETHEREUM TECHNOLOGIES LLC require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract