Senior Oracle Apps Technical Consultant

About Company: Company Description Big Oh Tech is a reputed global IT solutions provider offering expertise in software development, enterprise applications, staff augmentation, offshore outsourcing, and technical recruitment consulting. With an experienced team of over 100 technology enthusiasts, we deliver scalable solutions to complex challenges, driving business revenue for our clients. As an ISO 27001 and CMMI Level 3 certified company, we provide innovative and strategic solutions across diverse industries. Our services encompass mobile app development, web development, emerging technologies like AI, blockchain, and AR/VR, as well as custom product development and performance engineering.

Key Responsibilities:

Design, develop, and support custom solutions in

Oracle EBS R12 . Develop and maintain

Advanced PL/SQL

packages, procedures, functions, triggers, and performance tuning. Work on

Oracle Forms, Reports, and AOL

components. Develop and support

WebADI

integrations and customizations. Design, develop, and maintain

SCM and Finance interfaces . Work on inbound and outbound integrations between Oracle EBS and third-party systems. Provide techno-functional support for

O2C (Order to Cash)

and

P2P (Procure to Pay)

cycles. Handle data migration, conversion, and interface development. Troubleshoot and resolve production issues with root cause analysis. Collaborate with functional teams to gather requirements and translate them into technical designs. Prepare technical design documents (TDD), MD070, MD050, and related documentation.

Required Skills:

Strong expertise in

Advanced PL/SQL

with performance optimization. 8+ years of relevant experience in Oracle E-Business Suite (R12) Hands-on experience with Oracle Forms & Reports, WebADI, AOL (Application Object Library), Oracle, EBS R12 architecture Experience in developing and supporting

SCM and Finance modules . Strong understanding of: O2C Cycle (OM, AR), P2P Cycle (PO, AP) Experience in developing interfaces, conversions, reports, Reports, Customizations Good understanding of APIs, Concurrent Programs, and Workflow. Experience in Oracle R12 implementation or support projects. Exposure to performance tuning and query optimization. Strong analytical and problem-solving skills. Excellent communication skills and ability to interact with business stakeholders.