**Objective:** To develop a custom web-based Business Intelligence Reporting application that can report across legacy Access 2000 and SQL 2000 CRM databases for the financial department.
Knowledge of the group insurance industry would be very beneficial, but not necessary.
**Timeline:** Project must be completed within 60 days of project start date.
**Description:** This web application will be run internally on the small business network. The application will be built with 10 to 20 predefined reports containing calculated data, graphs and dynamic content where needed. The specific reporting data will contain financial calculations reporting estimated and projected commissions, account status activity, new client data, organic growth data, revenue goals tracking and budget reporting filterable by data types such as account manage, practice leader and account. The application should be designed with the ability to easily add new reports and modify existing reports. The hired worker will work closely with the Financial Department to meet their needs.
**Technical Requirements:** All reports will need to be printable and exportable to Excel. The web application should be developed using PHP 5 running in Apache within a Windows environment.