Develop and Implement Data Mart
The Department maintains information system applications to support tax administration (and ancillary) applications. Application data for these systems currently reside in relational databases (DB2/MVS, SQLServer, and Access) and non-relational data sources (sequential files, VSAM files, Excel). The Department uses Gentax, a custom off the shelf (COTS) application developed by Fast Enterprises, LLC. Currently information access for these systems is supported by static data inquiry screens within each application, extensive development of custom reports, and limited ad hoc access to the operational database of each application.
The goal of the overall project is to provide a highly accessible, intuitive, single point of access to information maintained and/or analyzed. The vision for meeting this goal includes the development of a series of business area data marts and the development of an enterprise data warehouse. Due to the scope and complexity of the development effort, the system will be implemented in four distinct phases:
Phase I: Requirements gathering, development of enterprise logical data model, and design of first data mart logical model.
Phase II: Development/implementation of the Departments first data mart.
Phase III: Sequential implementation of full data marts across all business areas.
Phase IV: Implementation of an enterprise data warehouse.
The purpose of this Request for Proposal (RFP) is to obtain competitive proposals from bona fide, qualified proposers who are interested in providing the consulting services required for Phase II of this project - Development/implementation of the Departments first data mart. The services are to include:
Physical database design
Design and development of the data mart population process (SSIS ETL and CDC as required)
Configuration of the business intelligence tool to access the data mart (Cognos metadata model and initial reports)
