Familiarity with Oracle Application Framework and associated components
Strong analytical and problem-solving skills
Ability to work onsite in Pasadena, CA
Responsibilities
Collaborate with stakeholders to gather business requirements
Conduct fit-gap analyses and present configuration options
Map current-state and future-state business processes
Recommend updates to Oracle configurations for process optimization
Support the implementation of new system features and changes
Troubleshoot and resolve application issues
Create and update technical and functional design documentation
Benefits
Opportunity to work on diverse projects with Oracle EBS
Access to advanced tools including GIT and OBIEE
Hands-on experience with financial close processes
Ability to influence system enhancements based on user feedback
Engagement in user acceptance testing and validation processes
Full Job Description
Job Responsibilities:
Collaborate with the Lead Enterprise System Analyst to review existing business requirements and gather new requirements from stakeholders
Conduct fit-gap analyses and present options
Map current-state and future-state business workflows
Recommend Oracle configuration updates to optimize business processes
Support ESA in implementing new features and/or system changes aligned with approved functional designs
Troubleshoot application issues through resolution
Log and manage Oracle Service Requests
Create and update functional design documents, technical design documents, and process flows associated with configurations or approved customizations
Develop scalable Oracle SQL/PLSQL code including procedures, functions, packages, and triggers
Update existing code to meet evolving requirements
Tune and optimize queries for performance
Build or retrofit interfaces, APIs, and data loaders
Support custom extensions including Form Personalizations
Diagnose system bottlenecks, debug functional and technical issues, and apply fixes
Support testing and user training activities
Perform additional duties as directed by project team
Provide bi-weekly status reports
Required Skills:
Design, develop, review, test, deploy, and support Oracle EBS customizations, extensions, reports, interfaces, conversions, and workflows.
Develop and maintain solutions using SQL, PL/SQL, performance tuning techniques, Oracle Workflow, XML Publisher, Oracle Reports, Oracle Forms, Concurrent Programs, and Unix/Linux scripting.
Support and enhance Oracle Financials modules, including AP, PO, PA, FA, GL, and SLA.
Develop and support Oracle Application Framework (OAF), personalization's, DFF/KFF, FNDLOAD, alerts, and AOL components.
Demonstrate expertise in Oracle EBS R12.2.X implementation, upgrades, patching, enhancements, and integration projects.
Utilize tools and technologies such as GIT, Informatica, OBIEE, Oracle APEX, SQL Developer, TOAD, custom data extractors, and data warehouse solutions.
Support month-end and year-end close processes, accounting reconciliations, audit requirements, and financial reporting activities.
Participate in user testing and acceptance throughout the development lifecycle to identify usability issues, missing requirements, and necessary design changes early, ensuring timely business validation and deployment of solutions.
The methodology ensures users can validate the accuracy of business requirements and assess the usability and performance of new developments.
Strong analytical and problem-solving skills
Familiarity with REST APIs
Proficient with MS Office
Desired Skills:
Experience with JIRA and GitHub
*Must be a US Citizen or Permanent Resident
*This is an onsite role. It is not remote. Must be in or near Pasadena, CA
