The executive director and CEO of the public agency overseeing the Coliseum and Oracle Arena resigned Friday amid questions over a stadium naming rights deal worth $3 million.