System and Business Process Improvements for Foreign and Commonwealth Office Phase A

System and Business Process Improvements for Foreign and Commonwealth Office Phase A

Requirement

  • Improvements to automate manual journals entries sent from global post locations for upload into Oracle Projects and correct all issues pertaining to incorrect project charging instructions applied to the journals created.
  • Improvements to the process of loading manual adjustment journals to Oracle Projects – Automated process required
  • Automate prepayments entered within Oracle payables resulting in accounted transactions interfaced to Oracle Projects
  • Streamline and automate the posting of purchasing accruals to projects. Resolve validation and accuracy issues with current month end processes

Solution

  • Design and development of a journal entry form to validate and auto account for required transactions at source/point of entry for remote global locations with no access or connectivity to Oracle
  • Provided a solution whereby account combinations are now accurate prior to being loaded into projects from remote locations reducing miscoded entries
  • Significant reduction in effort required from corporate services centre for error correction and upload of consolidated project accounted transactions/accruals
  • Replacement of the standard receipt accrual report with a modified version to display additional information required by the FCO to alleviate all existing issues
  • Designed and developed project accounting validation and loading accrual procedure to compliment the standard Oracle receipt accruals process
  • Used Prōject’s application and business process expertise to deliver process efficiencies to various business disciplines resulting in a number of elapsed days to be removed from newly implemented monthly process improvements
  • Development of applications roadmap for autoaccounted transactions
  • Extension of application configuration and WebADI loading process
  • Development and rollout of new reporting tools to assist in transaction efficiency and reconciliation of Project accounted transactions to GL
  • Continuous knowledge/skills transfer and training for new business processes and application configuration changes
    Full project, change and delivery management of all work package items
  • Project AutoAccouting design principles and business strategy workshops