Advertisement

ORM and Retirement of Outdated Business System

  • Chad Sevre
  • Necito dela Cruz
  • Tor Westgard
Part of the Lecture Notes in Computer Science book series (LNCS, volume 7046)

Abstract

The use of Access 97 and Excel 2003 workbooks led to a high risk environment for the Global Supply functional pillar within Boston Scientific. Without making a change to the current system, Boston Scientific would not be able to implement a 3.6 million dollar savings per year cost reduction program in 2009.  A retirement of complete collection of 55 Excel workbooks along with a 256 tiered Access 97 database system, incorporating dependent primary queries with many sub-queries, was required. To achieve the project goals, ORM was used to capture data requirements and all the related business rules. The ORM process showed the data gaps that were present in the current supply chain processes which allowed for a 20% mapping failure in the reporting. ORM also provided a more robust schema for product mapping in the reporting structure saving the company $300, 000.00 per year of the next five years.

Keywords

Enterprise Architecture Business Rule Subject Matter Expert Supply Chain System Business User 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. 1.
    Business Objects, an SAP company, Data Quality Strategy: A Step-By-Step Approach. White Paper, p. 3 (2008)Google Scholar
  2. 2.
    Loshin, D.: Master Data Consolidation and Canonical Data Models. Knowledge Integrity, Inc., 2011 Sybase Article, v. 7.1, p. 1Google Scholar
  3. 3.
    Loshin, D.: Master Data Consolidation and Canonical Data Models. Knowledge Integrity, Inc., 2011 Sybase Article, v. 7.1, p. 2 – Good Models and Good ToolsGoogle Scholar
  4. 4.
    Walker, D.M.: Resolving Data Warehouse Challenges Through Modeling. Sybase White Paper, pp. 1 Line 34 (March 2010)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2011

Authors and Affiliations

  • Chad Sevre
    • 1
  • Necito dela Cruz
    • 1
  • Tor Westgard
    • 1
  1. 1.Boston Scientific CorporationUSA

Personalised recommendations