What I'm looking for is a program similar to Automator or A Better Finder Rename but more extensive / advanced.

In my situation we have two files with the same name, one is a MOV the other an XML. We want to use some of the metadata within the XML to rename both files. Then we want to re-arrange the contents of the XML file so that it is compatible with another piece of software we use (I think this process is called mapping?)

Essentially some software that takes a bunch of variable from existing file and performs file actions to them.

I imagine this would be an easy task using apple-script, but I'm wondering if there is a OSX application similar to Automator that can do the above?

Questions are:

1. Is there software that can do the above?
2. Could Automator achieve this?
3. What is the technical name of this kind of process?
4. If no such software exists, what would be the best kind of script to use? eg. Make an Apple Script, python script etc.