US Secret Service Director Kimberly Cheatle has tendered her resignation coming under fire over the recent assassination attempt of former President Donald Trump