Role-Oracle EBS Programmer/Analyst
At minimum, a graduate degree in accounting major is required for candidates seeking placement in this position**
Must Have to be considered:
- Good problem-solving skills and troubleshooting skills
- Oracle Database SQL writing, understand PL/SQL, Workflow and BI Publisher Report logic
- Oracle eBusiness 12.2+ application support experience in Oracle Finance (AR, AP, CM, FA, GL, iSupplier) and/or Projects (Costing, Billing and Accounting)
Nice To Have
Nice to Have experience:
- Any programming experience in Oracle Apex 18.1
- Experience working in a multi-developer, team environment is preferred.
- Experience with Agile methodologies (SCRUM, Kanban) is preferred.
Responsibilities include, but are not limited to:
- Provides application functional and limited technical support for Oracle eBusiness in Finance modules (AR, AP, GL, CM, FA, iExpense, and iSupplier) and in Projects modules (Costing, Billing, Accounting).
- Collaborates with customers to ascertain system specifications and business/technical requirements to create spec documents that meet their needs.
- Troubleshoots, identifies the underlying cause, and recommends workarounds and/or corrective actions to solve the problem.
- Use diagnostics scripts, SQL and other query writing tools to analyze data, extract data for ad hoc reporting, and identify constraints and integrity issues with data.
- Provide data correction scripts to address a defect due to inconsistent state of the data.
- Conduct conference room pilots, user acceptance testing on defect fixes, features and system improvements, ensuring acceptance criteria is met without significant impediments.
- Responsible for completion of all required Change Management tasks and relevant SOX control requirements (if applicable).
- Utilize industry accepted project management principles, methodologies, tools, and best practices throughout the project life cycle.
- Acquire and utilizes business knowledge by taking advantage of available resources (internet, books, periodicals, classes/workshops, conferences, etc.) to develop and deliver business expertise solutions.
- Tracking deliverables and provide reporting to management as needed.
The successful candidate will have the following qualifications:
- Bachelors degree from a accredited university with accounting major, or 5 years of related industry is required.
- 3-5 years of experience supporting Oracle eBusiness modules. Preferably Finance and/or Oracle Projects.
- Able to review and understand programming logic constructs used in Oracle Workflow, Apex, BI Publisher Reports to learn current system state.
- 3+ years of experience with SQL, PL/SQL is required.
- Able to articulate application behavior, current and future states, in a language that is understood by the end user.
Must Haves:
- Good problem-solving skills and troubleshooting skills
- Oracle Database SQL writing, understand PL/SQL, Workflow and BI Publisher Report logic
- Oracle eBS 12.2+ application support experience in Oracle Finance (AR, AP, CM, FA, GL, iSupplier) and/or Projects (Costing, Billing and Accounting)