Adobe Premier or After Effects should be adequate. Of course you get what you pay for, and some turn key solutions can run $100K to $500K or even more.
AfterEffects reads Soft .pic files directly, and is much better with compositing and Special Effects than Premier. Premier is more of a general purpose editor. There are other products of course, so pretty much what ever you have will probably be adequate, if you are only intending to make a demo tape.
Urp