Dealing with Bloomberg's ever-changing file formats can try the patience of any developer. Traditional in-house methods are usually rapidly developed under a tight schedule and quickly become a point of frustration for support staff as uncontrollable changes to file formats begin to break down the integrity of the loader. Using Bloomberg's tools simplify the process somewhat but are a long way from a fully automated solution.

Cicero is a production solution developed with the clear focus of eliminating maintenance problems for the user. Cicero automatically adapts to Bloomberg-initiated changes in file structure and sends email notification of any anomalies encountered with subsequent action taken. Additional corrective action, when required, is provided by our off-site nighttime support staff.

Instead of weaving the Bloomberg Back Office files into a complicated data structure, the Cicero-loaded database tables strongly resemble the original Bloomberg files. This provides a foundation for either simple queries made directly by users, as well as integration into downstream systems.