Client: Stryker
The Stryker Supplier Portal empowers Stryker’s supply engineers the ability to analyze the performance of individual vendors by examining key metrics such as:
- Defect per Million
- Cost Variance
- Delivery Promptness, and more.
This business intelligence application was built as a service business model around hosted software that tracks inventories for suppliers and consumers.
Highlights
- 4GB Microsoft® SQL Server 2005 Standard Database
- From .5 Million to 22 Million statistical data points analyzed (e.g. rows in tables), depending on metric
- Nightly (or periodic) import of data via SSIS (SQL Server Integration Services) importing thousands of records
- Multiple layers of data access security to allow Divisional, Plant, and Vendor users to see only what is appropriate, and control personnel access, and statistical calculation thresholds beneath them
- IIS6.0, ASP.Net 2.0 with AJAX for more desktop-like experience
- Custom software, no ongoing licensing costs, third party technologies, etc.
- Data aggregation provides near instantaneous performance system wide
- Ability for Plant and Division managers to compare vendor statistics and allow them to make better business decisions
- Vendor Scorecard reports provide easy to use online drilldown with ability to export reports to Excel or PDF.