19 Nov
|
Stackzy Technologies
|
India
19 Nov
Stackzy Technologies
India
Senior Oracle Technical Functional Analyst – Oracle EBS R12 Needed for US client interview and project. Strictly 10+ years of overall experience, You can also directly DM on whatsapp (phone hidden), Required availability ( between 6:30 PM to 2:30 AM) IST. Senior Oracle Technical Functional Analyst – Oracle EBS R12 Technology: Oracle E-Business Suite R12 | SQL | PL/SQL | Oracle APEX We are seeking an experienced Senior Oracle Technical Functional Analyst with solid techno-functional expertise in Oracle E-Business Suite (EBS) R12 to own, maintain, enhance, and support critical enterprise billing, inventory, and purchasing applications. The ideal candidate will have extensive hands-on experience with Oracle Financials, particularly Accounts Receivable (AR), AutoInvoice, eBTax, Subledger Accounting (SLA), and General Ledger (GL), along with expertise in SQL, PL/SQL, Oracle APEX, concurrent programs, and application integrations.
Key Responsibilities
1. Oracle EBS Financials & Billing Support
• Own and maintain Oracle EBS R12 billing processes, ensuring financial accuracy and operational stability. 2. Oracle EBS Pricing, Inventory & Purchasing
• Manage annual USPS postage rate increases, client-specific pricing changes, coupon updates, and statement minimum adjustments. 3. Oracle Technical Development & Reporting
• Develop, maintain, and optimize complex SQL and PL/SQL scripts, packages, procedures, and functions.
• Build and maintain Oracle concurrent programs and custom interfaces.
• Develop Oracle APEX reports, forms, dashboards,
and alerts to improve operational visibility.
• Create and maintain BI Publisher reports and Oracle Alerts.
• Develop and troubleshoot integrations using SQL*Loader, UTL_FILE, and Oracle EBS open interfaces.
• Perform performance tuning, SQL trace analysis, TKPROF analysis, and database lock investigations. 4. Oracle Application Administration & Portal Support
• Manage Oracle Application Object Library (AOL) configurations, including lookups, value sets, and responsibilities.
• Perform configuration migrations using FNDLOAD. 5. Offshore Team Leadership & Delivery Management
• Lead and coordinate offshore Oracle technical developers and support resources.
• Create clear technical user stories with detailed requirements and acceptance criteria.
• Track tasks, progress, and effort through Azure DevOps or equivalent project management tools. 6. Production Support & Incident Management
• Act as the primary escalation point for critical P1/P2 Oracle EBS and Portal incidents. Required Technical Skills & Experience Oracle EBS R12 Functional Modules
• Minimum 6+ years of hands-on techno-functional experience with Oracle E-Business Suite R12.
• Strong expertise in:
• Oracle Accounts Receivable (AR)
• AutoInvoice
• Oracle eBusiness Tax (eBTax)
• Subledger Accounting (SLA)
• General Ledger (GL)
• Strong experience in at least one additional module:
• Oracle Inventory Management (INV)
• Oracle Purchasing (PO)
• Oracle Payables (AP)
• Advanced Pricing
• Order Management (OM)
• Knowledge of Oracle Workflow and Forms Personalization. Oracle Technical Development
• Advanced SQL and PL/SQL development.
• Oracle PL/SQL Packages, Procedures, Functions, and Triggers.
• Oracle Concurrent Programs and Request Sets.
• Oracle APEX Reports and Forms.
• Oracle BI Publisher.
• Oracle Alerts.
• Oracle Forms Personalization and Workflow. Interfaces & Integrations
• Oracle AutoInvoice Interface.
• Oracle Inventory and Purchasing Open Interfaces.
• SQL*Loader.
• UTL_FILE.
• External billing and General Ledger integrations.
• Experience troubleshooting data exchange, interface failures, and reconciliation issues. Oracle Application Administration
• Oracle Application Object Library (AOL).
• FNDLOAD.
• Lookups, Value Sets, and Responsibilities.
• Concurrent Request Logs and Troubleshooting.
• SQL Trace and TKPROF.
• Database Lock Analysis.
• Period-Close Exception Reporting. Tools & Platforms
• Azure DevOps.
• Oracle Application Development and Support Tools.
• SQL and PL/SQL Development Utilities.
• Oracle APEX.
📌 Senior Oracle Technical Functional Analyst – Oracle EBS (India)
🏢 Stackzy Technologies
📍 India