The chairman of the Dáil’s Public Accounts Committee, Brian Stanley, has resigned as a Sinn Féin TD.