Embattled Rochester community college president resigns