Police Officer Resigns After Sex Incident