Prelude for conversion and then Bridge for keywords would be my best guess on how to do this.
I would suggest doing all of this work in Prelude CC. On importing/ingesting your footage, you can add metadata (with customizable fields to suit your needs) transcode to a primary location, copy to alternate locations and transcode to alternate locations all in one pass, rename files, etc... Then, once in Prelude, you can add metadata in a ton of fields and formats. Once added, this metadata is written into the file and travels with it wherever it is accessed. And the search within Pelude is very responsive.
I would suggest doing some tutorials for Prelude and checking out the forum. I am a big proponent of Prelude and it has changed my workflow dramatically. (I'm also a FCP7 convert)
Ok, made some progress. right now our workflow is-
ingest with prelude, transcode and rename to a set folder
use bridge to add keywords to all of the files
go back to prelude, add subclips to mark ins and outs
files are now done.
when starting a project, we would use bridge to search for keywords, and send to premiere from there. we had to figure out a few things since we are sharing media over a network. We set our cache to the same folder on the network instead of on our individual machines, hopefully that helps with some of the confusion the programs were having.
thanks for the help