I dont know if this is the best reply, but till others drop in, let me see if i can add something here.
Software Engineer : Basically is a 'Code Coolie' as my manager at my previous organization put it. They are mostly technical, with emphasis being on coding to develop an application for a specific requirement.
Software consultant : This i am not sure, but based on my understanding, they have a mix of both technical and functional knowledge with the emphasis being on functional. For example, there are certain business software which require good understanding of the functionality involved in order to suggest the optimum configuration required for the same. Technical knowledge comes into play for customizing requests.
P.S. : Based on my knowledge.
__________________
"You can discover what your enemy fears most by observing the means he uses to frighten you." - Eric Hoffer |