|
Building Better Solutions by Design |
|
Solution Design Team Inc. |
|
Our success story includes on-time/on-budget implementation of e-business solutions ranging from large scale integration architectures to single, one of-a-kind point solutions. Whether your solution will be deployed across the USA, Canada, or Mexico or you simply need a custom designed solution for a mid-tier business, we can assemble a complete project team or just augment your team with specialized SAS knowledge. |
|
Customer Successes |
|
To facilitate and simplify the reporting needs of Tri-State Energy associates, the project created a data warehouse from several Oracle source systems including Indus Passport, Oracle GL-Actuals and Budgets. The project featured SAS® Data Integration Studio, SAS® Portal, Stored Processes, SAS® Information Map Studio, and SAS® Web Report Studio. |
|
To improve overall business intelligence, our team was very quick in identifying key pain areas and developed SAS® Enterprise Business Intelligence v9.1.3 reports that improved their existing base SAS® data step processes. |
|
Designed, built and implemented a finite capacity planning system for an international manufacturing environment. The system integrated with Oracle and provided ability to promise, forecast analysis, distribution requirements planning, and a capacity sized production plans for cellular manufacturing in Mexico and the U.S. |
|
Built a supplier hub that integrated component suppliers into the ERP system to access bill of material forecasts and requirements, purchase order status, as well as inventory requirements planning for the vendor. |
|
ETL conversion from Oracle to SAS®. Used Proc MDDB in a HOLAP environment to build a marketing cube that analyzed price regression for over 50 million records. |
|
Supplier Extranet |
|
Installed SAS® EBI 9.1.3 and developed several “Quick Win” reports to replace existing Microsoft Office Excel® documents and publish to the Portal. The project utilized SAS® Web Report Studio, MS SQL® data, Stored Processes, and SAS® Information Map Studio. |
|
The Coors Architecture Workshop was a 4-session workshop delivered over 2 days aimed at developing a first pass at a Manufacturing Execution System (MES) architecture. The architecture was defined in terms of four views or perspectives: a business view, a functional view, a technical view, and an implementation view. The intent was to provide an artist’s sketch of all four views to be used as a guide to further refine and develop the architecture in subsequent phases. |
|
Manufacturing Execution System (MES) |
