Solution: Planning and Budgeting | Industry: Financial Services

Aegon implemented Oracle EPM for financial reporting, budgeting and planning. Before EPM Aegon reported from their general ledger Sun Accounts but found ad-hoc requests for information and the entering of budgets and forecasts both problematic and time-consuming.

Aegon now use of Oracle EPM Smartview for ad-hoc reporting against actual and budgetary data. Smartview is used as an add-on to Microsoft Office and therefore Aegon users require little or no training to be able to access financial information in Oracle EPM. The implementation of centralised business rules which allow for a common set of logic to be applied has reduced any confusion within the business as to how a number has been generated, as well as the reduction of the risk that this number has been incorrectly derived.

Solution: Planning and Budgeting | Industry: Banking 

By engaging with Codec to deliver an integrated BI and EPM platform, Permanent TSB (PTSB) have seen a number of benefits within the Group Finance Department. The focus has switched from the actual production of reports to analysis of data, enabling the team to make better decisions on behalf of the bank.

Productivity within teams has increased tenfold as there is no longer a requirement to manually produce reports on a daily, weekly and monthly basis. Finally, the quality and confidence in the reports and plans which are produced through the new solution is much higher due to in-built controls, governance and the resulting lack of human error.

Solution: Planning and Budgeting | Industry: Airlines/Aviation

Codec provided DAE/AWAS with a monthly financial management and statutory reporting module, and a forecasting and planning module that delivered a speedy and efficient solution for their planning and budgeting needs.

Going forward when the company has to adjust figures or details for their fleet of aircraft it will not be necessary to contact their Excel expert and ask them to modify the huge and unwieldy Excel file. Instead they now have access to a streamlined solution that promises to automate the process as much as possible, and create a new and user-friendly approach to the approval and sign-off process (from the relevant and multi-departmental stakeholders).

In short EPM empowers DAE/AWAS by both reducing workload, and optimising the planning and reporting processes, enabling them to reach performance goals, enhance efficiency and optimise business processes.

Solution: Planning and Budgeting | Industry: Government Administration 

Codec’s deployment of Oracle’s EPM solution tidied up all Essex County Council’s complex data requirements so that the reporting process became more streamlined and completely automated.

The data from various sources within the local government agency including the general ledgers, HR, refuse management, care systems and other projects was transferred to the newly-built and enhanced forecasting system, which then relayed financial actuals to pre-determined segmented locations such as “Projects” or “Ledger” or whatever was the appropriate category.

The information was then passed to a data warehouse where it was repackaged and repurposed for individual dashboards or variant analysis. As a result of the newly compartmentalised data streams every individual stakeholder need only access the EPM solution to get the specific information s/he needs in an instant.

Solution: Planning and Budgeting | Industry: Insurance

Codec consultants worked with the Irish Life in developing the functional requirements and technical design for the development of financial reports on top of an OLAP (Online Analytical Processing) Solution. There were a number of source systems such as Financial GL, Enterprise Data warehouse, Excel and third-party databases.

Codec consultants designed and developed a centralised web-based tactical solution made up of EPM Hyperion Planning and Financial Reporting cube/application. All source systems were brought together in a staging database and loaded into the relevant dimensional model allowing for centralised calculations with direct input via the web front end and data directly loaded from the general ledger, HR, and fixed asset register via Oracle Data Integrator (ODI). The Planning system was deployed to Group Finance, Corporate Business and Retail Finance teams within IL&P. Irish life now have a centralised reporting function which can run ad-hoc analysis. The ability to filter the financial information along with any supplementary information from both a web front-end and Excel environment and predefined reporting packs are automatically updated and distributed to the relevant people across the organisation.

Solution: Planning and Budgeting | Industry: Entertainment 

Benefits:

Why they chose Codec?

• Hyperion Planning in place
• In-house expertise available locally
• Licenses already paid
• Strong relationship with Codec
• Cross-comparisons would ensure quality and cohesive approach

Competitive Advantage:

• Cognos – no in-house expertise
• Qlikview – no data input ability for end users
• SSRS – in construction

Hyperion Essbase Benefits:

• Fast
• Flexible
• Well-suited for financial reporting

Solution: Planning and Budgeting | Industry: Educational Institution 

Codec is proud to have worked with UCD in delivering the first cloud deployment of EPM in the country. UCD’s request to Codec was to help facilitate a best practice financial planning process. Budgeting had previously been spreadsheet-based, and consolidation and sharing of information had been time-consuming and subject to the risks inherent with spreadsheet models. As a modern forward-thinking University, UCD sought to align their planning processes with the multitude of benefits associated with moving to the cloud. Their goals were to enable and improve the efficiency and quality of the annual budgeting process, to enhance regular forecasting and reporting, and to be able to access a flexible platform for further improvements in financial and other planning activities.

Codec’s team of consultants made these aspirations a reality by implementing Oracle’s Planning Budgeting Cloud Service (PBCS) to immediately meet UCD’s financial planning requirements, and provide a platform for future enhancement and more devolved planning. PBCS also allows for standardised automated structured interfaces with a variety of other systems, and integration with Excel is a particularly strong element of the solution. In making the jump to the cloud with PBCS the University is already experiencing the benefits of a more robust planning system with 24/7 availability.