John Cousen was supervising the F/x team: Jane Smethurst, Graham Bebbington, Lynette Charters. I would guess that some of them worked on this.
Simon Maddocks spent the majority of the time he worked on the film animating the part of the opening shot where the camera is craning around the Golden City. He achieved this without a computer, just hand drawn perspective construction on every frame.
After going through trace and paint the cels for this animated crane shot were rendered, most likely by the brilliant rendering artist Dee Morgan. Dick wanted the animated elements of some shots to match the look of the background art. Another example of Dee's art can be seen in the scenes with the roses, that Yumyum re-arranges.
John Leatherbarrow shot a test of the whole scene, without the hands, just the crystal ball, to see if the huge camera zoom could be achieved. 5 or 6 pieces of take-over artwork, a slow exponential zoom, and some carefully lined up optical dissolves to hide the joins.
Roy Naisbitt might have been involved plotting all this out. There was another spectacular shot in the film that used this technique, we'll get to that later. It was called “Mouth to Mountain”. (We had names for our scenes instead of referring to them by sequence and scene number, a fact that caused considerable problems when the completion bond company tried to assess the film because they didn't know how to put it into their computer. )
Dick wanted to get all this work out of the way early as he was concerned that later in the game production pressure wouldn't allow him to spend all these resources on this one scene.
His plan towards the end of production in 1992 was to animate the hands himself (perhaps doing a drawing every 16 frames), entrusting breakdowns and inbetweens to another artist.

Dietmar found these inspirational sketches:

Apr.4, 2008 UPDATE:
Simon Maddocks just sent this: "...Mark Naisbitt did some of the detailing work (like bricks etc.) towards the end and Dee Morgan began rendering the drawings in the latter weeks. The final drawings were laser xeroxed onto yellow paper for rendering with frosted cell work overlays for the detail such as bricks and enhanced gold minarettes etc."
Simon will write about this scene in more detail soon.