What is he? vs Who is he?

"What is he?"

You're asking about his job. For example:

A: What's he? B: He's a painter.

"Who is he?"

You're asking about either his name or position; sometimes both. For example,

A: Who's he? B: Oh, he's Mr. Wilcox, the head of the division.