Democrat demands Secret Service director resign in heated hearing