A leading, Fortune 100 public homebuilder was holding over $6 B in investments in Land & Other Assets as part of its real estate operations, with limited ability to view and manage the performance of underlying assets and joint ventures.
The required information was stored in scattered places across the enterprise. The financial data was not aligned with the asset performance. The business organization was inconsistent across regions of the same company. Vital data was stored in local files as excel models and documents across every US market and region. Multiple information sources needed to be combined to create Asset Management reporting and there were inconsistent ‘standard’ formats.
The business identified a Chief Investment Officer to lead the Asset Management division & each regional and local asset manager was aligned to him. Standards and definitions-of-terms were agreed upon.
I led a small, experienced and highly talented technical team to build a data warehouse architecture and data model to contain the asset management key performance measures. Information was extracted from over 28 data sources using Informatica, both structured (JD Edwards, AS400/IBM i, SQL Server, Oracle, mySQL) and unstructured (Excel). Reporting based on business KPI’s and metrics was created and delivered on time using Hyperion Brio, now Oracle Business Analytics.
As a result…
- The business used the data warehouse and asset management analytics to implement a rigorous process of managing asset performance and optimizing the overall portfolio – resulting in $2B in new cash flow within 14 months of going live.
