Call Us: 1-800-497-0151
Follow Us:

Clients

Case Study

ING featured Case Study

ING DIRECT USA is the nation's leading savings bank and is wholly owned by ING Group. ING DIRECT USA does business online, over the phone and by mail. Their principal product is high-interest savings accounts, with no service charges or minimum account balance requirements. ING DIRECT USA serves more than 7.6 million customers in the U.S. and is headquartered in Wilmington, Delaware with innovative ING DIRECT USA Cafes in multiple locations across the U.S. ING DIRECT USA replaced their former planning tool, SRC, with a new Oracle Hyperion 11.1.2 Planning application to increase the efficiency and capability of their budgeting, planning and forecasting process. The Hyperion Planning solution includes Workforce Planning, and FDQM - to enable analysts to drill down into ING Direct's PeopleSoft GL.

Business Problem

Prior to the Hyperion solution, the reporting process utilized SRC, PeopleSoft, ODW and Excel Spreadsheets. It was manually intensive because there was no centralized repository for financial data. Analysts needed to download data from various databases and manually manipulate/calculate data each month. The calculated data was not consistent across different functional areas and did not sync back to the source database. The process did not provide standardized reports among finance teams. It also did not allow analysts to compare the actual statistics to the budget statistics. The Financial Planning and Analysis team needed to wait for Accounting to close the period before the manual process of loading the data to be completed before they could begin forecasting. They needed to condense their process. The Forecast process started with a copy of the previous month's forecast to the current forecast. Pre-Close detailed adjustment exercises began and are followed by the Post-Close high level adjustments. Expenses were calculated based on the new volume forecast and business drivers or rates. There were separate files to drive a forecast update. Manual effort was the main challenge to the monthly process. It was time consuming and prone to human error.

Project Solution

The ING DIRECT USA Planning application is divided into four plan types. They include the primary plan type - Income Statement; and 4 secondary plan types - Balance Sheet, Volume (revenue by product forecasting), and Workforce. All secondary plan types flow into the primary plan.

The first phase of the project implemented Hyperion Planning for the purpose of expense planning within the existing business process. Currently the budget process is to collect the Financial and Employee related expenses from PeopleSoft, operating and loan data from ODW, and volume forecast and drivers from the flat file. The drivers are then applied to a rate that will result in the first pass of the expense plan. Analysts are then allowed to adjust the rates or the resulting expenses to have input into the planning process. This process is the same for all outer years. For the Salary and Employee expense portion of the application, the outer years are calculated as percent increases because the GL accounts in the Income Statement are separate from the Workforce Module expense accounts.

Share:

Contact MindStream Analytics

Want to know more about MindStream Analytics Case Studies. Fill the form below.



Latest testimonial

ING

MindStream lead our team to a successful Hyperion Planning implementation. From project management to application design to data integration to application build, the MindStream team was efficient, experienced, and professional. We started the process looking for an implementation team, what we found in MindStream was a strategic partner"

Mike McGay
Sr. Project Manager, ING Direct USA

Finance professionals must be put into a position where they can spend more time analyzing data and less time collecting it. Predictive analytics technologies enable you predict what will happen in the future with confidence, so that you make better business decisions. You can apply modeling techniques to discover trends in your structured and unstructured data, and then deliver optimized, empowered business decisions.

Read More...

To transform customer attitudes, you must create personalized experiences to which they can relate. This may entail competing for customers that use mobile devices and social media, data that is growing at an incredible rate. As all of the three "s" - variety, volume and velocity - of both structured and unstructured data increase, so does the demand for analytic capabilities to keep up with it all.

Read More...

The ability to optimize operations within a company typically depends on a decision maker's ability to react upon the right information at the right time. Information that is delivered on demand, in real-time will increase operating margins and improve process efficiency. Analytics for operations aims to enable you to respond at the moment you need to.

Read More...

About Us

MindStream Analytics is a leading consulting firm focused on helping clients improve business understanding and decision making. With years of experience in the analytics and Business Performance Management area, MindStream offers services ranging from software selection and implementation to best practices for financial planning.

Contact Us
  • Address: 400 Commonwealth Ave, Unit 2
    Boston, MA 02215
  • Phone: 1-800-497-0151
  • Monday - Friday: 9:00 am - 6:00 pm
    Saturday - Sunday: Closed
Newsletter

Sign up for our Newsletter Updates.

© 2015. MindStream Analytics. All right reserved. SiteMap SiteMap