Senior public servant Gary Prattley has been sacked after an inquiry found unauthorised expenditure on his credit card.