East St. Louis officer accused of being drunk on job resigns