|
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, providing employment and training services to people looking for jobs. The MWWN's existing computer system was antiquated and didn't support many of their specialized business processes and they were forced to perform many laborious tasks by hand to meet the state funding requirements. State reporting was a paper based, hand-delivered nightmare. Less and less time was actually spent serving people. On top of that, the federal Workforce Investment Act (WIA) was being passed, and a whole new way of providing services was about to be enforced to acquire the funding needed to provide workforce services. The MWWN needed a new system built from the ground up, to truly support their staffs ability to provide and track WIA funded services.
The MWWN required a system that supported the needs of the entire organization, from the director to the line staff. Data had to be collected with validateable precision, or funding from the State would be denied. At the same time, staff couldn't be stopped by the system if their customers didn't have all of the information needed as they built their case. The system also had to be able to easily serve both rural and metropolitan Career Centers, with differing service-delivery flows. Being an e-Business solution, the system could never go down.
InControl Consulting took the upper management through an Information Strategy Planning process to define the functions performed by the enterprise, and to expose the organizations inter-department data dependencies.
The Job Seeker Services business area was then separated from the diagram and with a design team of coordinators and key line staff from all seven Career Centers, dataflows of how each business process was actually performed were modeled and the database was built.
Modules were designed from those dataflows and screens were generated along with navigation that further supported the agencies 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 values without needing technical skills. The data was migrated in from the old system, and after three days of training the system was deployed on an unbreakable Oracle Database/Apache Server, SSL and physical firewall.
On time and on budget, InControl Consulting deployed a comprehensive solution that not only handles tracking of all Adults, Dislocated Workers, Older and Younger Youth through WIA Core, Intensive, Training, Follow-up, and JTPA transitions, but also captures all connected activities therein, including expenses and case notes. The system includes additional staff support functions, contains automated "to-do" lists/ eligibility enrollment, and does all state-reporting electronically. Data can also be moved from personal accounts in the Virtual Career Center & One-Stop site to the Case-Management database, saving staff time by avoiding the need to re-enter information.
By the April following implementation, the Mid-Willamette Workforce Network was showing validateable reporting of having exceeded their annual goal for WIA-1B Adult and Dislocated Worker enrollments and outcomes… barely nine months into the year.
The solution also received a commendation from the Oregon State auditing department for how quickly and easily they were able to extract the data they needed.
|
 |
|
|
|
|
|
|
