Web-based Data Count Tool and Data Warehousing System - repost

Maximum budget for this project is £500.00 We are looking for a freelancer to start this urgently. Data Count Tool and Data Warehousing Project Details: Database: ? Schema should be able to store customer’s profile ? Questions and answers from surveys. This table should be scalable and can be group in query by respondent, answer, postcodes, etc… ? Must have lookup tables for postcodes, type of answers, type of questions, etc… for scalability ? No redundant data to be stored, relationships must be properly set ? Use foreign keys and triggers for referential integrity ? Engine must by InnoDB since it will be a MySql Database ? This database will be getting its data from a live survey database UI: Web-based UI with login page. ? Roles and Authentication must be implemented ? Admin users will be taken to Admin Home page ? Admin can view or print data counts for answers and questions ? Group these data counts by client, answers, questions, etc… ? Clients go directly to the client’s home page ? Should be written in PHP using CakePHP or Zend Framework ? Feature to allow Admins and Clients to create their own report forms ? Clients also can view or print report of data counts but only for their data Operations Reports Brief project information ? Dashboard o This shows overview data of all operations reports ? Revenue Reports o Daily Revenues o Revenue Forecast ? Daily Deliveries ? Detailed Survey Report ? Survey Questions Statistics per agent ? Survey Dispositions Statistics ? Detailed Disqualified Survey Report ? Employee attendance Report ? Employees Active Directory ? Output Tally ? Reporting Update Tracker ? Pay-out table for the questions ? VOIP Usage Charges These reports will get its data from the local survey database . Time Frame: ? Three (3) to Four (4) days