custom wordpress plugin for site

We are looking for an experienced web developer to create a module for an interactive community engagement website. The module will be a community project database for WordPress which will store project information, generate project pages on the website and export geographical information to Google Earth KML files. An intuitive control panel for Wordpress will be required for project administration. The project page currently exists on the page as a static mock-up. This is an example of what a registered project page will look like. The idea is to provide information, a venue for conversation, and a process for contributors to follow to help make the project a success. Database The project module will meet the following criteria: 1. Use a MySQL database engine 2. Support bilingual fields (duplicate field with _fr suffix) 3. Follow standard database design practices a. Standard and consistent naming conventions b. Enforce relations with proper cascade effects The database will store the following project information or similar (some items must be bilingual): 1. Project Table a. ProjectGUID b. Name (English and French) c. Subtitle (English and French) d. Description (English and French) e. HeaderImage (English and French) f. StartDate (date) g. Owner (from WordPress user database) h. Website (English and French) i. FundingGoal j. FundingCurrentAmount k. FundingLink l. ForumID m. KML (Binary KML file for Google Earth) (English and French) 2. Contributor Table a. ContributorID (from WordPress user database) b. ProjectGUID 3. ProjectStage Table a. StageGUID b. ProjectGUID c. StageName (English and French) d. StageLength (float) e. StageProgress (float) f. StageOrder (int) 4. ProcessStages Table a. StageGUID b. Name (English and French) c. Description (English and French) d. DefaultLength (float) e. DefaultOrder (int) 5. ProjectKMZ Table a. KMZGUID b. KMZURL c. ProjectGUID Administration The module will require an administration interface for site administration with the following abilities: 1. Create and delete projects through an easy to use, visually appealing, user interface in WordPress 2. Edit all information in a project through an intuitive user interface in WordPress with appropriate controls (ie: Image import with preview for project image, KML file importer, list box for stages, etc.) 3. Create a default stage list in an XML file for use by projects, they will be selected and added to the project from this list 4. Activate/deactivate projects 5. Export a project and all related information to new web page as text, or XML file. The administration interface should follow standard WordPress admin page format where it is accessible in the Dashboard. The Project Pages The project pages will be automatically generated from the database. They will include the following functions: 1. Automatic insertion in the “Live Projects” menu 2. Automatic insertion in the KML’s in the master KML list 3. Creation of a page which resembles the mock-up shown on the site 4. Display a forum on the project page as specified by the forum ID in the project database. This will be an existing WordPress forum, likely SimplePress Site functionality: Adding Projects  A prior visitor decides to start a project  Instructions on the site tell them to provide the project information  The contributor emails the required information  The admin logs in to the Project Admin panel and adds the new project, setting the owner and populating the info provided  The project now appears in the projects menu, and a project page is automatically generated  The project appears in the specified front page maps since its KML entry was automatically merged into the map KMZ files  The project page displays info according to what’s in the database (timeline according to start time and stage length, funding, web-link, description, etc.) Maintaining Projects (more info does not fit here)