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.