Job Description :
Role:- Oracle Financial Functional Consultant
Duration:-6+ Months
Location:-Virginia Beach,
Overview:
The City of Virginia Beach is interested in contracting with a firm that has:
Oracle Cloud Financials General Ledger and accounting experience with financial and budgetary controls
Public Sector Cloud experience
Is an Oracle Cloud Elite partner (Diamond, Platinum or Gold level)
Has the ability to provide various specialty functional expert consultant resources from their company to the City within two weeks after award
Has on-staff implementation experts in Oracle Cloud financial ERP, Project Financials, Planning & Budget
Accounting and Finance experience strongly preferred
Multiple resources with specific expertise in task areas are acceptable
The consultant(s) must have good/easy to understand English verbal and written communications skills.
The City is currently on e-business suite version R12.1.3, and is an Oracle Managed Cloud Services hosted customer.
Activities:
Development of chart of accounts (COA) analysis document.
The Oracle GL analyst will conduct an analysis of alternatives for the design of the chart of accounts to include the following:
Review of School and City current COA to establish a foundation for efficient accounting, budgeting and reporting.
Recommendations, advantages and disadvantages to options including: two separate COAs (one for the City and one for the Schools); the same COA for City and Schools; the same COA for City and Schools with separate numbering.
Advantages and disadvantages analysis of COA to include the implications for on-going maintenance, security and reporting.
Advantages and disadvantage analysis and recommendations for using project, grant and activity codes as part of the COA to consider implementation during phase 1 or 2 of the grants and projects cloud modules.
Recommendations for naming conventions for COA segments and groupings, numbering of roll-up groups in the segment based on analysis of current, actual use, best practices, future growth and reporting needs.
Recommendations to include best practice use of hierarchies, dynamic insertion, account types and roll up groups for classifying reporting breaks for segments.
Development of crosswalk logic between current COA and recommendations for future COA options.
Review of existing cash management fund customization and provide feedback on the impact to the proposed COA and GL.
Develop recommendations for options to configure cash within funds, and ensure accounting, reconciliation and reporting for cash without customization.
Provide guidance for financial and budgetary controls.
Advantages and disadvantages of COA design foundation on financial funds reservations for requisitions and purchase orders
Recommendations for COA structure that supports budgetary control for different groups such as the City budget office, City departments and City budget units including project managers for CIPS
Expected Deliverables:
In collaboration with the ERP Program Team, prepare documentation (functional requirements, functional analysis, alternatives, process and recommendation) for review on a periodic basis as defined in the mutually agreed upon schedule of activities/tasks. NOTE: CVB standard documentation templates will be used where available and applicable.
In collaboration with the ERP Program Team Members, define tasks that will track and manage progress of the activities that have been identified above.
Enter time and task notes weekly into PlanView for work that was completed to deliver the activities that have been defined above. NOTE: Invoices will not be paid unless time billed match what is entered into PlanView and task notes are complete.
Weekly status reports to the City’s project manager and Applications Administrator
Weekly meeting with the Applications Administrator and will be established with by the Applications Administrator
Additional Information:
Must have clear verbal and written communications skills
The City of Virginia Beach uses PlanView to track project tasks and to record daily time expended on the activity
The City is currently using Oracle e-business suite version R12.1.3, and is an Oracle Managed Cloud Services hosted customer