Leon Goodwin is the psychologist that Frank Reagan visited when he found out that John McKenna was dying. The visit didn't last long as Frank doesn't believe in talking things out with shrinks.
Not much else is known about him as he only appeared once.