Acting Texas Comptroller Kelly Hancock to resign at end of month