|
Database Professionals and Oracle Consulting Solutions
|
|
|
Mid-Willamette Workforce Network
intranet site - contact IC for production demo
The Mid-Willamette Workforce Network (MWWN) is a group of seven One-Stop Job and Career Centers covering three counties in the state of Oregon under the umbrella of Chemeketa Community College. In addition to providing employment and training services to job seekers this organization also reaches out the employers in the community offering assistance where necessary including providing regulatory information as well as specialized training to businesses.
The MWWN required a system that could easily be accessed anywhere at any time to track and better serve the requests of businesses. An internal rule of the system specified that a real person had to respond to an initial business contact within a 48-hour period during the workweek, from when the request was made. The complexity of this single rule required a system that not only collected a request and all necessary contact information with which to fulfill it, but also automatically posted notices to staff via their "reminder" list for each area of expertise the request targeted. Another requirement that the system had to fulfill was the ability to "hand-off" an entire businesses record to other staff members of every MWWN agency AND every partner agency that the MWWN works with, in order to expedite serving businesses without re-entering information at each referral point. Even more, the staff member that originally met the employer and created the record needed to be able to continue tracking the record and it's progress, remaining a point of contact to ensure unified provision of services rather than making the business feel like it was getting the "run around". The system also needed to collect and post upcoming training classes and programs to other similar businesses in the community, to reduce costs all around for both the businesses and the college. Finally, the system required a running history of services, training courses offered in the past, and costs that could be pulled up in a moment's notice to address another businesses request.
InControl Consulting took a design team of key upper management from MWWN and several of their partner agencies through an Information Strategy Planning process to define the functions performed by this inter-agency business area. A design team was assembled of coordinators and key line staff from all appropriate Centers and their partner agencies, and detailed dataflow diagrams were built. Modular components were designed from those dataflow diagrams and screens were generated along with navigation that further supported the inter-agency service-delivery flow. InControl also integrated an easy-to-use administration console for an appointed staff member to update system pop-lists and certain database items without needing technical skills. The system was deployed on an unbreakable Oracle Database/Apache Server using SSL behind a physical firewall.
On time and on budget, InControl Consulting deployed a comprehensive solution that tracks all of a businesses needs and requests, and keeps an ongoing history of services provided, who received the services, where the services were provided, when the services were provided and who provided the services. The system supports a staff member making contact with a business and being able to keep track of them even as their case is assigned to and moved through the partner agencies specializing in the services that the business is after and back again, as though the entire network of partnerships was one organization. The system includes additional staff support functions, contains automated "reminder" lists and tracks services, offerings, and the agreements that went with them.
|
 |
 |
|
|
|
|
|
