The search for a popular graphic designer who went missing a month ago has come to a tragic end.