School resource officer resigns