Project Consulting Success Stories
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 augment your team with specialized SAS knowledge.
Reporting Environment Data Warehouse—REDW
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.
Marketing Regression AnalysisW
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.
Enterprise Business Intelligence
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.
Supplier Extranet
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.
Finite Capacity Production Planning
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.
Business Intelligence Information Delivery
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.
Manufacturing Execution System (MES)
Architecture Workshop conducted as a 4-session workshop delivered over 6 weeks 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 project plan in subsequent phases.