Giulio Maresca

Led pursuit and delivered analysis and design of a budgeting and forecasting solution for a large financial services company.  The solution included the redesign of all major business dimensions and the adoption of Oracle DRM to manage them.

Business Results

• Standardization of all master data across the company
• Financial data mart as one source for all budgeting and forecasting need
• Distribute planning process

The client, a major credit card company, wanted to conduct a due diligence project to assess whether Oracle Hyperion Planning could be used as the back-end application to manage the  Global Client Incentives Platform (GCIP).  My team created an Hyperion Planning prototype to mock several use cases requested by the client.

Business Results

• Create Hyperion Planning application prototype
• Conduct interim prototype “dry runs” with key users in order to preview the prototype functionalities and drive out any key gaps in the package.
• Present prototype to project sponsor for “Go/No-Go” decision.

This project was a global initiative to bring together the diverse companies and operating units created through the merger.  The new reporting and planning system consolidated company-wide financial information and key performance indicators (KPIs).  The system allows the client to have a global, regional, company or business unit view of their financial status at any point in time.  Running the business as one global integrated company is extremely challenging given the IT infrastructure and business processes inherited from two very different historical companies. My team led the design, implementation and testing of the global planning and budgeting system.  This system was deployed worldwide to 300 locations.  We also delivered end-user training and UAT to more than 80 stakeholders.  The application was implemented with Hyperion Essbase and a web-based front-end.

Business Results

• Provided for a single repository of financial planning data
• Provided for consistency in language, data, etc.
• Linked plan to business strategy to achieve financial goals
• Increased ability to react to changes in the current business environment
• Provided for better decision making as a result of better, more frequent information
• Provided information for management to become more forward-looking and able to anticipate change
• Helped to reduce close cycle time and number of forecasting iterations

My team assisted a national insurance company’s finance organization to evaluate and improve its financial planning and performance management capabilities. The initial phase of this effort involved close cooperation with the P&C, Life, and Corporate controllers to:

• Review client’s KPIs/drivers to-date and recommend enhancements
• Assist with design of interim non-automated Executive Dashboard report
• Develop design & business case for automated dashboard tool
• Create an online prototype to illustrate dashboard design
• Review current planning & forecasting process and identify quick hits
• Develop high-level design of planning & forecasting (P&F) process

We developed a sophisticated Hyperion Essbase prototype that led to the following results:

• Assessed tools and technical options for implementing a production solution
• Designed, developed, and tested web-based dashboard for displaying key metrics
• Prepared proof of concept for executive presentation

Developed the post-merger integration approach for financial consolidation, reporting, planning and forecasting applications for a major Hollywood studio. The client needed a temporary application able to report financial results of the two merged companies on day 1 after deal-close. The major challenge of this project was the limited time, but the project was successfully completed on time and on budget. The temporary consolidation and reporting application was developed using Hyperion Enterprise.

Our client was undergoing a major finance transformation program including re-engineering all back-office processes and technology.  As part of this program, the client wanted to select the next generation technology to manage internal and external reporting as well as planning and budgeting processes.  The project had a large number of stakeholder organizations that needed to be involved in the selection process.  I managed a team of consultants that assisted the client with selecting the IT solution.  We prepared vendor RFP, proof of concepts and conference room pilot to facilitate the selection of the software.  The result was a comprehensive presentation of software selection process and the winning vendor.