Oracle ERP Technical Consultant

Cloud Analytics Technologies, LLC; Chicago (IL); On-site; USD 80,000 - 110,000; Full time

Benefits offered by this job

Equal opportunity employer

Professional development opportunities

Job summary

A leading cloud solutions provider is seeking an ERP Technical Consultant to provide comprehensive support for Oracle Fusion. Responsibilities include troubleshooting technical issues, developing customized reports, and managing integrations with third-party systems. The ideal candidate will possess expertise in Oracle ERP modules and demonstrate strong skills in report development and data migration. This is a full-time role located in Chicago, Illinois, offering competitive compensation and opportunities for professional growth.

Qualifications

• Proficiency in Oracle Fusion and ERP technical areas.
• Experience developing BI Publisher and OTBI reports.
• Strong knowledge of customizing Oracle ERP modules.
• Ability to manage integrations with APIs and web services.
• Experience with data migration and performance optimization.

Responsibilities

• Provide technical support and troubleshooting for Oracle Fusion.
• Develop and customize BIP and OTBI reports.
• Configure user access controls within Oracle applications.
• Execute data loading for items and invoices.
• Design custom solutions using Oracle Forms and PL/SQL.

Skills

Oracle Fusion expertise

Technical support and troubleshooting

Report development (BIP, OTBI)

Customization (PL/SQL, Oracle Forms)

Integration with third-party systems

Education

Bachelor's degree in Computer Science or related field

Tools

Oracle Fusion

Oracle PL/SQL

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.

CLOUD ANALYTICS 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. CLOUD ANALYTICS 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 CLOUD ANALYTICS 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.