Rail minister Lord Peter Hendy has said he is surrounded by fascinated guests at parties whenever he mentions that he works in transport.