Official resigns a week after being appointed following "insensitive" behaviour during visit to tsunami-hit region.