St. Albans police officer resigns