A decision by Wachovia's board saw the establishment of a new unit dedicated to increasing its share of business from institutional investors, without increasing risk. The Board expects the new team to produce $US75 million in new revenue by 2005.
With information about past trades scattered acrosss multiple applications, the new team lacked the data it needed to create offers to entice customers or analyse the risks involved. With the Board pushing the new unit and expecting a substantial payoff, new tools were needed quickly.
SolutionAvanade constructed a data warehouse to consolidate information from a wide range of trading applications. Next, the Avanade team built the tools that allow Wachovia to understand clients’ performance, tailor offers, and conduct risk analysis to ensure sound proposals.
Well within a six-month deadline, Avanade implemented Microsoft SQL Server 2000, Microsoft’s Data Transformation Services, and Analysis Services to provide the OLAP facilitates that will empower the new team to deliver on its mission.
ResultsAnticipated results of this project include: