RSA Ireland's CEO resigns