 |
|
|
| |
|
News & Events |
|
|
|
|
| |
|
iPhone Applications |
|
|
|
|
|
|
Macro Planning
|
Mentoring |
A Way of Doing Business for the Rest of Us |
|
|
|
|
|
|
|
Mentoring |
|
|
|
Employment Data Warehousing |
|
|
Problem |
|
IT staff constantly had to deal with the frustration of compartmentalized databases on inflexible architectures. The department was overwhelmed by questions from the Legislature, the Governor's Office and other policy groups. Each request for information, regardless of size, required an IT employee to add the query to a queue for an overnight batch run by the mainframe computer. Often a request for information could take several people more than a week to generate. This inflexible process stripped the employees of the power they needed to be responsive.
|
|
|
Solution |
|
Empowerment from the flexibility of a data warehouse. With the data warehouse built by Seasia Consulting, a departmental employee receiving a request for information can get answers to nearly any questions - within minutes. Even expanded queries that require an integration of information from both the Employment Services and Unemployment Insurance departments can be handled at the employee's workstation - now, the front-line employees feel truly empowered.
|
|
|
|
|
|
 |
|
|
A Whole New Attitude |
|
|
|
|
For nearly nine months the Department of Employment had countless numbers of consultants from high profile, highly respected consulting firms working on building their data warehouse, but none had successfully moved the project from the idea to the implementation phase.
|
|
|
| |
|
|
|
|
Transforming an Idea into Solution |
|
|
|
|
Using the Idea Today Application Tomorrow Methodology, Seasia made decisions regarding the architecture and functionality that would best harness the power from the integration of the Employment Services and Unemployment Services data. The selected functionality of the data warehouse enables employees to:
|
|
|
|
-
Conduct ad hoc queries in real time
-
Generate customized reports
-
Complete historical trend analysis
-
Track spells and duration of unemployment
|
|
|
|
Each of the above can be sorted by demographic attributes such as race, gender, disability, marital status etc, and then can be drilled down to the individual customer. And most impressively each of the above can be accomplished directly by the end user - without the involvement of IT staff.
|
|
|
| |
|
|
|
|
Mentoring services ensure your self-sufficiency |
|
|
|
|
Seasia worked closely with the technical staff to ensure that the data warehouse could be maintained expertly in-house. Our consultants:
|
|
|
|
-
Created the curriculum for and self-directed training
-
Taught all training sessions
-
Conducted evaluations and issued progress reports
-
Wrote standards documentation for future projects
|
|
|
|
|
|
|
|
|
|
|
|
|
 |
 |
|
|
 |
 |
|
|
 |
 |
|
|
Quick Response |
|
|
|
|
|
|
|
Our Clients |
|
|
| |
|
|