Top-ranking NYPD officer abruptly resigns amid sexual misconduct allegations