• michaele d. rachlin
  • stories & solutions
  • contact
mdr management consulting * delivering intelligent, innovative & affordable solutions for your organization *

a new business is built upon a data warehouse…

January 6, 2013 6:00 am / michaele rachlin

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.
Share Button
Posted in: BPI business improvement, business, data warehouse | analytics, metrics & KPI, real estate & asset management / Tagged: analytics, business intelligence, business transformation, data warehouse | analytics, KPI, metrics & KPI, product design, project management

Comments are closed.

Post Navigation

← Previous Post
Next Post →

about. contact.

  • We empower non-profits + growing businesses
    • michaele d. rachlin
    • stories & solutions
    • contact

stories & solutions…

  • What do we mean by ‘capacity building’?
  • It took a very long time to win this first grant…
  • we are a ‘Power Player’!
  • now offering grant proposal writing + sustainability services to non-profits!
  • a local non-profit was behind its fundraising target…
  • a start-up with a great idea…
  • practical experts…
  • your website is you…

we deliver…

agile analytics business intelligence business transformation clients & crm co-location customer data warehouse | analytics disaster recovery planning donor management e-commerce ecommerce & digital business FMEA grants grant writing homebuilding IT architecture ITIL IT resiliency IT risk management knowledge management KPI loyalty media research mentor metrics & KPI non-profit not-for-profit online giving & donor management operations management outsourcing performance improvement product design project management quality team building team leadership vendor management VOIP website

tweets


followers
 0 seconds ago

follow us here…

  • RSS Feed
  • Twitter
  • LinkedIn
  • Google+

view posts by category

© Copyright 2021 - mdr management consulting
Infinity Theme by DesignCoral / WordPress