ORM and Retirement of Outdated Business System
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.
KeywordsEnterprise Architecture Business Rule Subject Matter Expert Supply Chain System Business User
Unable to display preview. Download preview PDF.
- 1.Business Objects, an SAP company, Data Quality Strategy: A Step-By-Step Approach. White Paper, p. 3 (2008)Google Scholar
- 2.Loshin, D.: Master Data Consolidation and Canonical Data Models. Knowledge Integrity, Inc., 2011 Sybase Article, v. 7.1, p. 1Google Scholar
- 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.Walker, D.M.: Resolving Data Warehouse Challenges Through Modeling. Sybase White Paper, pp. 1 Line 34 (March 2010)Google Scholar