Data warehouse requirements gathering and enterprise modeling
The goal of the overall project is to provide a highly accessible, intuitive, single point of access to information maintained and/or analyzed by LDR. 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 as allowed by Louisiana Revised Statute 39:1503 from bona fide, qualified proposers who are interested in providing the consulting services required for Phase I of this project - the design of the Departments first data mart. The services are to include:
The review and analysis of the Departments Integrated Tax System data along with ancillary systems.
The collection and analysis of user requirements. The major business units to be interviewed in this phase are:
oPolicy Services Division
oOffice Audit Division
oField Audit Services Division
oCollection Division
oFinancial Services Division
oTaxpayer Services Division
oTax Administration Division
Creation of the enterprise data warehouse logical data model.
Assistance to the State with identifying the functional area for the Phase I data mart. The first data mart will be mainly built using data from our tax processing application, Gentax. Potential business areas for the first data mart include:
oTaxpayer profiles (Registration)
oQuality Review (Taxpayer Services/Office Audit Work Items)
oReturn & payment statistical analysis (Policy Services/Tax Administration)
oBilling Cycle Efficiency (Collections)
oCase load/warrant tracking (Collections)
oRefund tracking timing & amounts (Financial Services)
Definition of the functional requirements of the Phase I data mart.
Initial technical requirements of the Phase I data mart.
Creation of the logical data model for the Phase I data mart.
Knowledge transfer to State staff related to all contract areas of activity.
In order to respond to this RFP, a proposer MUST meet the following conditions:
The proposer must have experience in the design, development, and implementation of data warehousing and business intelligence solutions.
The proposer must have experience with Allfusion Erwin Data Modeler
The proposer must provide at least two (2) but should provide no more than five (5) customer references for work performed related to the type of services being proposed in this RFP.
The proposer must have experience with Microsoft SQL Server 2005.
It is preferred, but not required, that the proposer have experience with Cognos 8 (Framework Manager, Report Studio, and Query Studio) and MS Integration Services.
