If you import a sequenced .psd or .tga file into AE, it will acknowledge and work the the alpha channel. The .tga format has the alpha channel "embedded" as a transparency channel like the .png format does. Carrara doesn't export .png though. So, to get that same functionality, simply export a sequenced 32 bit .tga