U.S. Attorney for Northern District of New York resigns