It is really a job for a strong developer who is able to think up custom solutions and cary them out... If it is a large company, you may develop "snap in" web parts that allow intra-office communication (such as "my alerts" or "custom assignments" or whatever)... but make sure you are completely familiar with the many tools in SharePoint 2007 so as not to reinvent the wheel.