Department of Human Services Data Warehouse Development
Brief Description: SES managed and developed a multi-purpose
TeraData Data Warehouse involving DHS’s three major functional areas:
Administration, Policy, and Operations. In addition to the integration of Web
and SQL Servers, support for OLTP, metadata repositories, initialization of
repositories from VSAM data stores, and dynamic expansion of multiple data
marts, the project required access and query support from a state-of-the-art
Business Intelligence process. The spiral development methodology focused on
capturing the data from outside sources, and ensuring that the comprehensive
and detailed business rules were integrated. The project, the first of its kind
for the State of Iowa, was required to demonstrate the support of "data
driven" decisions, and to provide expert data manipulation across all
DHS’s existing databases.
Services included project management, requirements analysis, design, coding,
unit and system level testing, documentation, acceptance testing,
knowledge-transfer, Quality Assurance, and Configuration Management.
Deliverables included the TeraData Data Warehouse with associated reporting
capabilities, Requirements Definition Document, QA Plan, CM Plan, Test
Evaluation Master Plan, Subcontractor Management Plan, System Design, and User
Documents. This data warehouse contained State Medicaid-related information and
formed the basis for a data warehouse that expanded to include data for several
other State agencies.
Highlights/Benefits: The actual technical performance of the
data warehouse exceeded the technical specifications. The system was promoted
as one of the State’s IT 2000 Success Projects. All program milestones
and key deliverables were accomplished on or ahead of schedule. Additionally,
the project was completed and accepted by the customer three weeks ahead of
schedule. There were no cost overruns.
Return
|
