Oracle EBS Technical Consultant

About the role

Responsibilities

• 1. Configure enhancements and fixes in ERP applications, focusing on the delivery of complex RICE Objects (PLSQL).
• 2. Develop queries and customized reports tailored to specific business requirements.
• 3. Build custom workflows in various areas such as AME, PO, and others, utilizing knowledge of forms personalization.
• 4. Utilize exposure to 3rd-party integration tools such as supplier collaboration portals and/or 3PL/4PL systems for seamless integration with ERP.
• 5. Create Interface & Conversions, Menus, Forms, and Functions, proficient in PL/SQL Packages, Procedures, and SQL Scripts.
• 6. Support technical and functional configuration, including table creation/extension, to enhance the use and supportability of Inventory, Fixed Assets, Supply Chain and Finance modules in Oracle ERP and other touchpoint systems.
• 7. Analyze, design, and implement integrated customized solutions to meet approved functional requirements and specifications.
• 8. Ensure data security in each developed application, adhering to best practices and company policies.
• 9. Create and maintain technical documentation for developed solutions and processes.
• 10. Facilitate testing of enhancements, fixes, patches, and upgrades to ensure smooth deployment and minimal disruption.
• 11. Resolve technical issues related to code, configuration, and performance of applications in collaboration with DBAs, system administrators, and functional teams.
• 12. Diagnose production issues, identifying and implementing fixes in coordination with relevant teams.
• 13. Design, develop, deploy, test, and maintain technical objects within the Oracle applications production environment, including reports, interfaces, conversions, and custom application extensions.
• 14. Create process flows, high-level functional and detailed technical design specifications based on business requirements.

Skills

• Oracle ERP
• PL/SQL
• SQL
• Interfaces
• Conversions
• Reports
• Forms personalization
• 3rd-party integration