Oracle Senior Analyst - Projects (Open to Remote)

About CRS

Catholic Relief Services is the official international humanitarian agency of the Catholic community in the United States. CRS works to save, protect, and transform lives in need in more than 100 countries, without regard to race, religion, or nationality. CRS’ relief and development work are accomplished through programs of emergency response, HIV, health, agriculture, education, microfinance, and peacebuilding.

 

Background:  

Project Insight is CRS' initiative to improve Finance, Human Resources, and Supply Chain functions, supported by Oracle technology. Improved processes will make CRS more efficient, and using timely, accurate data for decision-making will make CRS more effective. By equipping our staff with tools for better stewardship, Insight will help us to better meet the needs of those we serve. To maximize the business and technology return on investment from the implementation of an integrated solution for Finance, Human Resources, and Supply Chain, CRS has established a Center of Excellence (COE) to govern, manage, and maintain the systems and processes addressed by Project Insight.

 

Job Summary:

This position performs ongoing tasks related to clearing exceptions across the Oracle Cloud Fusion (Insight) financial platforms throughout the month, allowing accurate and timely data flow throughout the application. This position also performs month-end closure system-required processes in all sub-ledgers and clearing related errors, warnings, and exceptions.

 

• Regularly runs and checks Oracle Project Portfolio Management (PPM), Grants, and Accounts Receivables (AR) sub-ledgers exception reports throughout the month to ensure that the errors, warnings, and exceptions are cleared timely.
• Performs month-end closure system-required processes in Oracle PPM and AR sub-ledgers and ensures all errors, warnings, and exceptions are cleared.
• Runs burdening, revenue recognition, billing, receipt and invoice matching, and other system processes as required during month-end closure.
• Runs and clears period-end exceptions in PPM throughout the month and during month-end closure. Investigate the cause(s) of each unprocessed cost in Project Portfolio Management Module (PPM) and clear them to ensure smooth month-end closure. Follow up with the technical team on timely resolution of any escalated issues.
• Reviews the applicability of the established transaction controls in consultation with the Global Controller department and takes the necessary actions to resolve the exceptions.
• Updates contract and project metadata in support of clearing errors in the PPM throughout the month in consultation with the Global Controller department.
• Runs create accounting in PPM and AR sub-ledgers and resolves the resulting exceptions.
• Runs billing exceptions reports throughout the month and addresses exceptions.
• Runs SCM sub-ledger reconciliation throughout the month and shares with HQ cost accountants.
• Runs period-end validation report for each CP to identify any accounting errors to be fixed before starting month-end closure in coordination with HQ cost accountants.
• Ensures escalation of complex exceptions to the BPOs and others for resolution.
• Regularly investigates and clears the exceptions from sub-ledger interfaces such as ePBCS to ERP, ePBCS to PPM, AP to PPM, PPM to GL, SCM to PPM, etc.
• Follows up on the outstanding actions to ensure that PPM and AR sub-ledgers are fully closed during each month-end (there are no pending close periods).
• Selects relevant information from a variety of sources in order to prepare documents, reports, summaries, and replies to inquiries, ensuring accuracy and proper format of the information provided.
• Keeps track of assigned tasks in order to ensure compliance with established deadlines.
• Provides accurate and timely status updates.
• Performs other duties as assigned.

 Supervisory Responsibilities – None

Key Working Relationships:  

Internal: Global Finance Division, Regional Finance Officers, GKIM, Finance, SCM, Finance Solutions Architect, and HR Oracle Business Process Owners (BPOs)

External:  Oracle Corporation, System Integrating consultants, and other External Consultants.   

Knowledge, Skills, and Abilities  

• Good project management and change management skills with proven ability to coordinate and manage several significant projects at once.
• Strong written and oral communication skills, strong systems thinking skills with capacity to see the big picture and ability to make sound judgment 
• Proactive, resourceful