In addition to White Eagle have suggested, please consider reading the following posts on how to build and MIS. You would need to hire an external consultant or an agencies who can map all your requirement and offer you the best solution. The discussions and format shared here are for your reference.
How to make an MIS
MIS - Excel Sheet
Alternatively, you may consider to start putting the information available for the employee in a definite pattern so that it can be accessed by everyone, who may need to. The problem with such an internal effort is that, it remains a patch work. Please consider a solution , in totality. You may share the areas, that you find difficult for us to brainstorm it further.