Oracle Developer

Resource Log; Sharjah; On-site; AED 150,000 - 250,000; Full time

Job summary

A tech solutions provider in the United Arab Emirates seeks an experienced Oracle Developer specializing in PL/SQL to enhance financial systems through automation and integration. The ideal candidate will have over 7 years in Oracle Forms and PL/SQL, demonstrating expertise in database optimization and integration with platforms like Salesforce. This role demands a strong ability to automate processes, improve billing accuracy, and provide detailed financial reporting. The position requires an onsite commitment of 6 days a week.

Qualifications

• 7+ years experience as Oracle Forms(11g,12c) and PL/SQL Developer.
• Strong PL/SQL and Oracle Database expertise.
• Proficient in integrating Oracle Forms with other business platforms.

Responsibilities

• Integrate System with TOS, Ebis, and Salesforce for real-time data exchange.
• Automate billing tasks to ensure accurate tracking of shipped versus billed amounts.
• Develop automated SP statements for agents and partners.

Skills

Oracle Forms (11g, 12c)

PL/SQL

WebLogic

Database performance optimization

Integration skills

Job description

Job Title: Oracle Developer PL/SQL Developer

Onsite Requirement 6 days a week

Interested candidates who can join on urgent basis may apply to [e-mail]

We are assisting our client in hiring an Oracle Forms(11g,12c) and PL/SQL Developer

The ideal candidate should have 7+ years as an Oracle Forms(11g,12c) as well as have experience as a PL/SQL Developer.

Detailed specifications as below:

Experience & Skills

• 7+ years as an Oracle Forms(11g,12c) and PL/SQL Developer.
• Proficient in WebLogic server-based dynamic solutions.
• Skilled in integrating Oracle Forms with other business platforms.
• Strong PL/SQL and Oracle Database expertise.
• Experienced with Oracle Reports and SQL optimization.
• Adept at system design, UI development, and Oracle middleware configuration.
• Proficient in database performance optimization, including query tuning, indexing, and partitioning strategies, to enhance overall database efficiency.

Scope of Work

Finance Improvements on System with Integration to Enjaz, ODS, E-Freight, and Salesforce. The goal is to improve financial functions in the system by automating manual tasks, increasing billing accuracy, enabling real-time data integration, and providing detailed financial reporting through smooth integration with Enjaz, ODS, E-Freight, and Salesforce.

1. System Integration and Data Automation
   • Integrate System with TOS, Ebis, and Salesforce to allow real-time data exchange for billing, vessel operations, service terms, and customer updates.
   • Automate data flows such as refer and storage charges, THC billing, and vessel movements to remove manual uploads and enhance billing accuracy.
2. Financial Automation and Control
   • Upgrade System with Credit/Debit Note, Receipt Allocation, and Refund modules to simplify financial transactions.
   • Create automated accrual modules for sales promotions, incentives, municipal fees, and free trucking costs using data-driven guidelines.
   • Introduce real-time CN generation when BOE amendments happen and improve visibility of CIF value-based incentive payments.
3. Billing and Revenue Assurance
   • Automate billing tasks across System and E-Freight, including support for Petro and GC discharge monitoring to ensure accurate tracking of shipped versus billed amounts.
   • Implement Outstanding Charges Reports, Automated Daily Sales Reports, and Vessel/BOE revenue summaries to boost financial oversight.
4. SP Statement and Incentive Management
   • Develop modules to create automated SP statements for agents, sub-agents, and transport partners based on confirmed receipt and application data.
   • Categorize and calculate all incentive payments with clear details (Agent, Sub-agent, Consignee, Transport, etc.).
5. Reporting and Dashboarding
   • Enable dynamic dashboards and reports via System and Power BI/ODS for TEU volumes, revenues, net profits, and container-wise analysis.
   • Provide detailed customer profitability reports and track unbilled transactions to reduce revenue loss.

Oracle PaaS (OIC + Apex + SQL & PL/SQL) Developer

Oracle Fusion Accounting Hub and Accounting Foundation Cloud - Functional Consultant

Senior Oracle Fusion Technical Specialist (Reporting & FDI)

Lead Client Accountable Executive - Fusion/Oracle Health

FLEXCUBEFunctional Business Analyst / SME ORACLE

Senior Oracle Technical Specialist (Finance, Supply Chain , HRMS)