Question: Can someone help? Please I need a complete and specific answer. When CFO Steve Umpelby arrived at the London offices of top interdealer broking firm

Can someone help? Please I need a complete and

Can someone help? Please I need a complete and specific answer.

When CFO Steve Umpelby arrived at the London offices of top interdealer broking firm Compagnie Financire Tradition in 2010, he found all the right things going on in terms of legal and regulatory requirements. But when it came to analysis there was a wide gap. The organization, which acts as an intermediary in trading derivatives and other instruments, depends on the performance of its brokers for its financial health. Yet despite plenty of figures on how much individuals and teams were bringing in, there was little fact-based understanding of their true contribution against costs. His immediate answer was to hire an Excel specialist, who set about looking at broker performance, laboriously correlating data such as the 400 to 500 brokers' pay and bonuses from HR, with travel and entertainment costs and the numbers held in IT timesheets. The resulting reports appeared two or three times a year, at first taking up to two-and-a-half months to produce each time with a large amount of figure-checking, according to Tradition EMEA CFO Umpelby. "Which is OK if everything's going well, but not great if you're in a declining market and you need to take action quickly," he said. Umpelby explained that one of the reasons for needing to do things faster is that many of the brokers have contract clauses specifying that a failure to produce certain revenues can lead to a salary cut and ultimately the sack at no cost to the company. But to enforce the performance clauses the broker has to be notified within cither 14 or 28 days of the end of period. "Given it was taking us over two months and then down to a month and a half to produce the reports, we could never enforce them," he said. THE NEED TO SPEED ANALYSIS With the manual Excel process becoming increasingly cumbersome, Umpelby began to look for better technology to speed up the analysis and make it more robust. "We wanted to produce a profit-and-loss account by broker. We needed to know who was profitable and who wasn't, in what region, within what period of time, what backgrounds and past experience they had, deals they were involved with, and so on. So, when it came to contract renegotiations we were doing it based on data rather than just gut feel and bluster," Umpelby said. "But the Excel was getting too awkward. There were occasions where we were finding errors in it. As well as taking a long time to produce, it also took a long to time to check because the data was coming from different sources and changed each month." Umpelby stipulated the functionality the new analytics software would have to offer, while his colleagues in IT ensured that possible products would fit the firm's IT infrastructure and allow data feeds from the different existing systems. In the end Tradition, which employs about 2,400 people in 27 countries, worked with analytics specialist Cubewise and opted for IBM's Cognos Express software. "In very simplistic terms, it felt to me like Excel. It had the flexibility of Excel because all accountants love Excel but at the same time it had a lot more robustness in terms of its calculating capacity and its ability not to fall over. It also had a far better ability to take in the data from the various different systems that we needed to," he said. HARDWARE DEMANDS AND CLEANING DATA The hardware demands for Cognos Express were relatively light - a new production server and a backup- and there were few teething problems cleaning existing data and getting it into the new system. But now Umpelby can press a button to generate a report showing brokers' profit and loss accounts, which after a quick check can go out to business heads. In a market with falling revenues, the software has played its part in providing more accurate data for the cost and job reductions that have taken place at the company. "It wasn't particularly pleasant last year but [the system) helped us cut the cost of our business in the right places because we knew exactly which people were producing and performing last year and exactly which people weren't," Umpelby said. "Previously it would have been down to gut feel from the business management. Gut feel might have got 80 percent of it right but it might have got some things wrong as well. The management knows who's doing what but previously they didn't have the data to back it up." With the business shifting more towards electronic broking, the company is also using the Cognos system to get a more precise picture of the platform development costs. The old spreadsheet and timesheet files became too big to manage after six or seven months and offered no method for recharging costs accurately to the businesses that had incurred them. In fact the Cognos system is now used not just for IT timesheets but for cost allocations across all the business lines and generates reports for the board and executive management committee. The system is also flexible enough to take on other new tasks, according to Umpelby, who wants to be able to use it for more client and transaction analysis, including developing a more detailed picture of how the brokers override rate cards for commission on particular trades. Now another unit of the business is looking at the system and may go down the Cognos route, according to Umpelby, who has also shown it to his US colleagues. Question (Answer very briefly) Based on your reading, what does the Cognos Software represent (Data Analysis software? Data Analytics software? ...) Justify your answer. When CFO Steve Umpelby arrived at the London offices of top interdealer broking firm Compagnie Financire Tradition in 2010, he found all the right things going on in terms of legal and regulatory requirements. But when it came to analysis there was a wide gap. The organization, which acts as an intermediary in trading derivatives and other instruments, depends on the performance of its brokers for its financial health. Yet despite plenty of figures on how much individuals and teams were bringing in, there was little fact-based understanding of their true contribution against costs. His immediate answer was to hire an Excel specialist, who set about looking at broker performance, laboriously correlating data such as the 400 to 500 brokers' pay and bonuses from HR, with travel and entertainment costs and the numbers held in IT timesheets. The resulting reports appeared two or three times a year, at first taking up to two-and-a-half months to produce each time with a large amount of figure-checking, according to Tradition EMEA CFO Umpelby. "Which is OK if everything's going well, but not great if you're in a declining market and you need to take action quickly," he said. Umpelby explained that one of the reasons for needing to do things faster is that many of the brokers have contract clauses specifying that a failure to produce certain revenues can lead to a salary cut and ultimately the sack at no cost to the company. But to enforce the performance clauses the broker has to be notified within cither 14 or 28 days of the end of period. "Given it was taking us over two months and then down to a month and a half to produce the reports, we could never enforce them," he said. THE NEED TO SPEED ANALYSIS With the manual Excel process becoming increasingly cumbersome, Umpelby began to look for better technology to speed up the analysis and make it more robust. "We wanted to produce a profit-and-loss account by broker. We needed to know who was profitable and who wasn't, in what region, within what period of time, what backgrounds and past experience they had, deals they were involved with, and so on. So, when it came to contract renegotiations we were doing it based on data rather than just gut feel and bluster," Umpelby said. "But the Excel was getting too awkward. There were occasions where we were finding errors in it. As well as taking a long time to produce, it also took a long to time to check because the data was coming from different sources and changed each month." Umpelby stipulated the functionality the new analytics software would have to offer, while his colleagues in IT ensured that possible products would fit the firm's IT infrastructure and allow data feeds from the different existing systems. In the end Tradition, which employs about 2,400 people in 27 countries, worked with analytics specialist Cubewise and opted for IBM's Cognos Express software. "In very simplistic terms, it felt to me like Excel. It had the flexibility of Excel because all accountants love Excel but at the same time it had a lot more robustness in terms of its calculating capacity and its ability not to fall over. It also had a far better ability to take in the data from the various different systems that we needed to," he said. HARDWARE DEMANDS AND CLEANING DATA The hardware demands for Cognos Express were relatively light - a new production server and a backup- and there were few teething problems cleaning existing data and getting it into the new system. But now Umpelby can press a button to generate a report showing brokers' profit and loss accounts, which after a quick check can go out to business heads. In a market with falling revenues, the software has played its part in providing more accurate data for the cost and job reductions that have taken place at the company. "It wasn't particularly pleasant last year but [the system) helped us cut the cost of our business in the right places because we knew exactly which people were producing and performing last year and exactly which people weren't," Umpelby said. "Previously it would have been down to gut feel from the business management. Gut feel might have got 80 percent of it right but it might have got some things wrong as well. The management knows who's doing what but previously they didn't have the data to back it up." With the business shifting more towards electronic broking, the company is also using the Cognos system to get a more precise picture of the platform development costs. The old spreadsheet and timesheet files became too big to manage after six or seven months and offered no method for recharging costs accurately to the businesses that had incurred them. In fact the Cognos system is now used not just for IT timesheets but for cost allocations across all the business lines and generates reports for the board and executive management committee. The system is also flexible enough to take on other new tasks, according to Umpelby, who wants to be able to use it for more client and transaction analysis, including developing a more detailed picture of how the brokers override rate cards for commission on particular trades. Now another unit of the business is looking at the system and may go down the Cognos route, according to Umpelby, who has also shown it to his US colleagues. Question (Answer very briefly) Based on your reading, what does the Cognos Software represent (Data Analysis software? Data Analytics software? ...) Justify your

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!