Embattled drug czar resigns