Ex-finance secretary resigns from SNP following suspension :