The client, a division of a Fortune 500 company, develops, analyzes and tests formulation models for product formulations. This division employs more than 2,000 people worldwide in three regions with sales networks that extend to local markets. The company’s formulators share model data and collaborate with other formulators around the world to seek consensus on models to publish to the broader analyst audience across the company.
While the client has used SAS Enterprise Guide and other SAS analytical solutions as its platform for formulation model development and distribution, full functionality and the models were not available to users without SAS expertise. The client wanted to enhance SAS tools and collaboration between modelers and engineers.
“Experis provided what we requested very efficiently in time and expense. They were quick to understand our needs. Our tools are enhanced greatly by their involvement. It is a pleasure to work with them.”-Client Project Team Leader
Experis deployed experts in SAS and Windows development to enhance SAS Enterprise Guide and create a portal application to enhance collaboration and data sharing. Our flexible development solution allowed for multiple design revisions throughout the course of the project. Experis created an early prototype and provided it to the client for installation and infrastructure testing. We then developed the application at our Center of Excellence in Kalamazoo, Michigan.
The system had three main components:
- The SAS Enterprise Guide Add-in, a customization to SAS Enterprise Guide, allows the modeler to easily publish information about the model.
- The Model Information Database holds all information required for running formulation models.
- A custom portal allows the user to search for, review, and run published models.
The system also uses Windows, SQL Server, and SAS security features for user identification and authentication.
Following the initial completion of the base application, the client rolled out the application to all formulators to a very positive response.
- Allowed non-programmers to create, publish, and execute formulation models
- Standardized the modeling process and documentation
- Saved time for modelers by simplifying model creation and publication
- Saved development money by building upon existing technology investments
The greatest benefit to the client is that the application allows full collaboration within the group; non-programmers find the application easy to use. This collaboration enables substantial time-and cost savings in tests on chemical formulations. Models can easily and quickly be updated as more data becomes available. This improves the company’s chances to win competitive bids.