Trump made my job pointless with compulsive tweeting, former aide says