Had or have -- which one is correct here?

It depends on your current knowledge. If you NOW know that Angie has a different name, you could say, I HAD thought your name was Angie. I agree with the other suggestions, though, that say it's easy to write, "I thought your name WAS Angie."