B015 - Oracle ERP CRS
About The Position
Duties and Responsibilities 1.Design, develop, maintain, and deliver critical dashboards scheduled and ad hoc reports and queries that meet the business needs of stakeholders and support all areas of Oracle ERP, Procurement and Project/Grants Cloud 2.Responsible for designing, developing, and supporting various reports and data extracts. 3.Support the day-to-day operations, including help desk issues and end-user support. 4.Develop custom reports using OTBI/Business Intelligence Publisher (BIP) 5.Develop, unit test, performance tuning and implementation of Custom Reports 6.Deploy and Schedule reports using ESS 7.Collaborate with the workstream leads to create reporting specs that accurately document required functionality 8.Create BIP reports where requirements cannot be met through out-of-the-box reports and Oracle Transactional Business Intelligence (OTBI) 9.Create end-user training documentation, ensuring that the functionality of the report is fully understood 10.Support unit testing and user acceptance test for Oracle ERP, Procurement and Project/Grants Cloud reporting 11.Support quarterly upgrades to Oracle cloud by assessing its impact on reports.
Requirements
- 5+ years of experience dealing with Oracle Fusion Financials.
- 4+ years of experience developing OTBI/BIP Reports
- 4+ years of Experience with Oracle ERP Cloud
- Deep understanding of Fusion Financials database schema (GL_LEDGERS, XLA subledger accounting tables, AP/AR transaction tables, Project-Grants Management tables)
- Full lifecycle implementations using government-compliant data warehousing solutions with Oracle Fusion Financials or Oracle ERP
- Experience with at least one modern ETL/ELT tool.
- Implement automated data extraction from Oracle Fusion Financials using native Oracle tools (BICC, OIC, OTBI) or third-party extraction platforms
- Worked on Automation of reconciliation between Oracle Fusion and warehouse, fund balance validation, audit trail documentation, and support for government audit cycles.
- Excellent understanding of Financial Modules and Data structure
- Built self-service reporting using enterprise BI platforms for Oracle Fusion Financials
- Bachelor's Degree in Computer Science or related field
Nice To Haves
- Experience with Oracle Integration Cloud development is a plus
Responsibilities
- Design, develop, maintain, and deliver critical dashboards scheduled and ad hoc reports and queries that meet the business needs of stakeholders and support all areas of Oracle ERP, Procurement and Project/Grants Cloud
- Responsible for designing, developing, and supporting various reports and data extracts.
- Support the day-to-day operations, including help desk issues and end-user support.
- Develop custom reports using OTBI/Business Intelligence Publisher (BIP)
- Develop, unit test, performance tuning and implementation of Custom Reports
- Deploy and Schedule reports using ESS
- Collaborate with the workstream leads to create reporting specs that accurately document required functionality
- Create BIP reports where requirements cannot be met through out-of-the-box reports and Oracle Transactional Business Intelligence (OTBI)
- Create end-user training documentation, ensuring that the functionality of the report is fully understood
- Support unit testing and user acceptance test for Oracle ERP, Procurement and Project/Grants Cloud reporting
- Support quarterly upgrades to Oracle cloud by assessing its impact on reports.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
