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.
Presented by:
Chad Sevre, Boston Scientific Corporation (USA)
Necito dela Cruz, Boston Scientific Corporation (USA)
Tor Westgard, Boston Scientific Corporation (USA)