HomeMy WebLinkAboutResolutions - 1997.06.12 - 25075MISCELLANEOUS RESOLUTION 197136 aune 12, 1997
BY: Strategic Planning Committee, Dennis Powers, Chairperson
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - IMPLEMENTATION AND FUNDING OF
PREVIOUSLY AUTHORIZED DATA WAREHOUSE PILOT PROJECT
To the Oakland County Board of Commissioners
Chairperson, Ladies and Gentlemen:
WHEREAS the Oakland County Board of Commissioners, by Miscellaneous Resolution
#96222 approved on October 10, 1996, authorized the Data Warehouse Pilot Project
planning effort which entailed the contracting of Prism Solutions, Inc. to prepare
a Business Plan-Readiness Assessment-Project Plan at a cost not to exceed $75,000;
and
WHEREAS the aforementioned Project Plan has been completed and presented to
the Strategic Planning Committee with a recommendation for implementation of data
warehouse architecture for the County's Land Management Information System as the
pilot project; and
WHEREAS successful implementation of the Pilot Project will provide the data
warehouse infrastructure for several other Management Information Systems currently
under development and directed toward a client-server environment, including the
Human Resource/Financial Management Information System (HRFIS), the Courts and Law
Enforcement Management Information System (CLEMIS), the Judicial Information
Management System (JIMS), the CHAMPS Health Management Information System; and
WHEREAS installation of the data warehouse infrastructure is a necessary
ingredient to the planned implementation of an Enhanced Access System for Oakland
County which will provide commercially valuable government information
electronically off-site for a fee, as provided in Public Act 462 of 1996; and
WHEREAS the total cost of hardware/software products, licensing, services and
training for installation of the Oakland County Data Warehouse Infrastructure and
Pilot Initiative amounts to $1,699,916, with an additional annual maintenance cost
of $155,808; and
WHEREAS the subject project is recommended by the County Executive.
NOW THEREFORE BE IT RESOLVED that the Oakland County Board of Commissioners
authorizes implementation of the Data Warehouse - Land Management Information System
Pilot Project.
BE IT FURTHER RESOLVED that the Board appropriates funds in the amount of
$1,699,916 for the one time cost of hardware/software products, licensing, services
and training for the aforementioned pilot project, as well as an additional $155,808
for annual maintenance.
Chairperson, on behalf of the Strategic Planning Committee, I move adoption
of the foregoing resolution.
STRATEGIC PLANNING COMMITTEE
AirvI14.0 eeowetz)
FISCAL NOTE (Misc. #97136) June 12, 1997
BY: Finance and Personnel Committee, Sue Ann Douglas, Chairperson
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - IMPLEMENTATION AND FUNDING OF
PREVIOUSLY AUTHORIZED DATA WAREHOUSE PILOT PROJECT
To the Oakland County Board of Commissioners
Chairperson, Ladies and Gentlemen:
Pursuant to Rule XII-F of this Board, the Finance and Personnel Committee
has reviewed the above referenced resolution and finds:
1. The Board of Commissioners, by Misc. Resolution #96222, authorized
the Data Warehouse Pilot Project planning effort at a cost not to
exceed $75,000, funding derived from the Information Technology
Internal Service Fund.
2. Project planning has been completed and the Land Management
Information System has been selected as the pilot project which
will, upon implementation, provide infrastructure for several other
projects currently under development, including the County's
Enhanced Access Program.
3. The total cost of hardware/software products, licensing, services
and training for installation amounts to $1,699,916, with an
additional annual maintenance cost of $155,808, detailed as follows:
Acquisition Maintenance TOTAL
Cost Cost COST
Software, Lic. & Training $ 764,815 $111,755 $ 876,570
Data Warehouse Server 203,791 37,053 240,844
Consulting Services 731,310 7,000 738,310
Total $1,699.916 $155,808 $1.855,724
4. Funding is available in the General Fund Designated Reserve for
Operational Improvements (1-10100-492-040) for transfer to the
Information Technology Fund (63600).
5. The following budget amendments are recommended:
General Fund (10100) FY 1997 FY 1998
Revenue:
3-10100-909-01-00-9901
Prior Year Balance $1,855,724 $155,808
Expenditures:
4-10100-181-01-00-8615
Operating Transfer to IT Fund $1,855,724 $155,808
Total 0 0
Information Technology Fund (63600)
Revenue:
3-63600-181-01-00-8101
Operating Transfer from GF $1,855,724 $155,808
Expenditures:
4-63600-182-01-00-3304 Depreciation $ 566,639 $566,639
4-63600-182-01-00-3342 Maintenance 155,808 55,808
Subtotal $ 722,447 $722,447
1-63600-455-001 Revenue
Over/(Under) Expense $1,133,277
FINANRE AND PERSONNEL COMMITTEE
$(566,639)
E FORE(4(DING RESOLUTIOr
Date
L. Brooks Pgferson, County Executive
I HERE
Resolution 497136 June 12, 1997
Moved by Powers supported by Huntoon the resolution be adopted.
AYES: Amos, Coleman, Devine, Dingeldey, Douglas, Garfield, Holbert,
Huntoon, Jensen, Johnson, Kaczmar, Kingzett, Law, McCulloch, McPherson, Millard,
Moffitt, Obrecht, Palmer, Pernick, Powers, Schmid, Taub. (23)
NAYS: None. (0)
A sufficient majority having voted therefor, the resolution was adopted.
STATE OF MICHIGAN)
COUNTY OF OAKLAND)
I, Lynn D. Allen, Clerk of the County of Oakland, do hereby certify that the
foregoing resolution is a true and accurate copy of a resolution adopted by the
Oakland County Board of Commissioners on June 12, 1997 with the original record
thereof now remaining in my office.
In Testimony Whereof, I have hereunto set my hand and affixed the seal of the
County of Oakland at Pontiac, Michigan this 12th iday o
5
June 7.
D. Allen, County Clerk