Title: CC1 Consultant Contract for Mangco, Inc.

Recommendation:
I recommend award of the Consultant contract with Mangco, Inc. for $244,000.00,  effective May 17, 2007 through June 30, 2008 and authorize the Superintendent and Board Chairman to sign all needed documents. 

Description:

CC1 The following deliverables will be provided in FY2008:

1. Implement teacher-based security for teacher rollout (allowing every teacher access to Educational Data Warehouse). Work with EDW Team and IT in automating security access for all teachers
 - Assist in design and development of infrastructure required to support teacher-based security. Design will involve working with DBAs
Active Directory Security Administrators, and the Metadata Modeler.  Once the infrastructure is in place, will work with Cube Developers
and Metadata Modeler to incorporate this security in cubes as well as packages used for ReportNet reporting

2. Modify as necessary 2 Navigation menus and 22 existing reports in EDW for Teachers. Create 10 new EDW for Teachers reports

3. Assist with installations/performance tuning and infrastructure planning on a minimum of 7 servers for  EDW for Teachers

4. Function as a master developer and provide technical expertise to the EDW Team in the areas of security and analytical/reporting solutions

5. Assist with development of Scorecards and Dashboards using Cognos 8 software.  These applications will provide additional Indicators for schools

6. Additional Tuning of EDW for proficiency purposes
- Maximize the performance of EDW.  This will involve working with DBAs, Metadata Modeler (Framework Manager), Report
Developers, Network Services, and Cognos Server Administrators

7. Create additional listing and summary reports/graphs
- Create and assist with creation of 10 additional reports and graphs for production as well as supporting adhoc requests

8. Provide weekly customized hands-on training sessions for fast tracking 5 additional  EDW Reports

The Consultant's knowledge and experiences:
Assisted with the implementation of EDW for Teachers (Pilot) and implemented security and reports for Teacher Pilot
Expertise in the knowledge and use of Cognos tools through years of experience with Cognos product
Demonstrated success in producing data warehouse solutions
Knowledge of local system and data structures
Demonstrated ability to effectively interact with district staff
Proven ability to provide stability to the project
Served as the Cognos Project Manager from Phase I of Data Warehouse to the present and this will further develop in-house expertise

The consultant's combination of skills in all areas of the project  (i.e. Database, Reports, Infrastructure, Security) gives him the unique ability to interconnect all aspects of  the EDW for Teachers system. This unique combination of skills is not currently available in the District. Eight years of Cognos training and consulting, combined with Advanced Cognos 8 Training (May-2007), will enable the consultant to effect a smooth transition to the latest Cognos 8 Software. This experience and training will also be invaluable in Scorecard and Dashboard planning and development.

Approval of this contract increases the efficiency of the EDW and EDW for Teachers projects in the following ways:
Complete critical Data Administration tasks left open by JV Tech under contract 0000001118 - for optimizing performance of EDW database
Reduces Cognos administrative overhead
Increases the stability of the staffing of the data warehouse project
Reduces overall cost of contract by using salary available from vacant developer position
Consultant is registered and will attend Advanced Cognos 8 Training in May 2007 and this will increase skill set to expedite Cognos 8 conversion

Financial Impact:

Authorized Amount this Request:   $244,000.00 ($24,000 for FY07 and Balance for FY08)

Previously Authorized Amount Year-to-Date:   $160,000.00

Total Authorized Amount if this Request Approved:  $404,000.00

Fund Source:   Capital Funds
                     Consultant Services

For Additional Information, contact:

Joseph Moore, MooreJ@palmbeach.k12.fl.us

Marc Baron, Chief of Performance Accountability

Attachments (list):
Mangco, Inc. Contract.pdf
Mangco, Inc. Beneficial Interest.pdf
Mangco, Inc. Previous Evaluation.pdf
Mangco, Inc. Legal Checklist.pdf
Mangco, Inc. Data Panel.pdf