What does Este Es Mi Amigo?

Translation: How are you, my friend.

However, it would be rather odd to use "Usted" with your friend. It would sound like "How art thou, my friend?" Usted is formal and you would not use such formality with your friend.