Placing an animated object over video
Look under Render Options for the Shading settings. Alpha is set to "Sky" by default, which will remove transparency from your rendered image by filling it with the sky gradient colors (by default a simple dark gray color). That Alpha Over node needs this transparency. Set Shading > Alpha to "Transparent" to make the rendered image transparent.