I am often asked usually by programmers - What is Data Warehousing & how do I learn it? I explain to them we use all the same tools that you do but differently. That’s when I coined the term Data Sense. It describes the essence of Data Warehousing and separates Data Warehousing from rest of Programming. Every aspect of IT from Hardware / Software infrastructure to Design, Development and QA is done with massive data flows and need for data precession accuracy and meaning.

Sunday, February 18, 2007

SOW – National Political party

This I would say is a high point for me. But after considerable introductory & strategy sessions the manager there left! And everything started all over again with new people.

Project Description
General Description of Services
The NPP envisions a Voter Database system to support upcoming elections. The NPP is seeking to hire XXX to serve in a technical advisory role for approximately two months to assist in planning for the implementation of the NPP's Voter Database. XXX will provide infrastructure, database and developer subject matter expertise and support for the NPP’s Voter Database Project. The XXX team will work closely with the NPP team to develop the data model and technical architecture required for the Voter Database Project.
…………………………..
…………………………..
…………………………..

Detailed Description of Project
XXX will assist, on a time & material basis, in the data modeling project by working with the NPP and required state party staff in order to create a data model for the voter database. XXX will work with the NPP to understand the various use-case scenarios of any eventual applications and determining exactly what types of data would be stored within the system.

Additionally, XXX will work with the NPP to develop the architecture for the technical infrastructure required for the Voter Database. This includes: assistance in selecting a RDBMS, guidance on the right solution for database and application high-availability, advice on purchasing hardware and assistance implementing this infrastructure.
Consulting Services
a) XXX will provide Client with the following services (collectively, the "Consulting Services"):

· Development of a Data Model for the voter database - This will include a diagram (Visio or other), Word Document describing the Data Model elements.

· Development of the Technical Architecture - This will include a diagram (Visio or other), Word Document describing the architecture recommendations.

· Development of a High Level Project Roadmap to describe versions, phase mapping and associated budgets.

· Development of budgets for complete solution (hardware, software and services) based on recommendations by Phase.

b) XXX will provide consultants with the requisite skills necessary to assist Client with its needs:

One Senior Technical Director, Business Intelligence
……………………………………………………..
Deliverables
a) List of Deliverables. XXX will provide the Consulting Services previously described to develop and deliver to Client the following Document Deliverables:
1. Data Model Document. This document will include a diagram (Visio or other), Word Document describing the Data Model elements.

2. Technical Architecture Document - This document will include a diagram (Visio or other), Word Document describing the architecture recommendations.

3. High Level Project Roadmap Document – This document will describe versions, phase mapping and associated budgets.

4. High Level Budget Document – this document will describe the budgets for complete solution (hardware, software and services) based on recommendations by Phase.

b) Requirements for Deliverables.
1. Data Model Document. This document must describe the Data Model elements.
2. Technical Architecture Document - This document must describe the architecture recommendations.
3. High Level Project Roadmap Document – This document must describe versions, phase mapping and associated budgets.
4. High Level Budget Document – this document must describe the budgets for complete solution (hardware, software and services) based on recommendations by Phase.