For more information about Luxoft, visit www.luxoft.com www.luxoft.com/financial-services/
case study 26.09.2012
Trade Lifecycle Data Warehouse with Business Intelligence Summary Develop a trade lifecycle data warehouse (DWH) with business intelligence (BI) analysis tools to support decision�making in trades management, capacity management, performance control, and issues management by the bank’s front office, middle office, and IT operations teams.
uu Client: Top five global investment bank uu Business Area: Commercial Mortgages, Structured Finance, Securitization, Document Management uu Asset Classes: Commercial Mortgages uu Technology Set: Oracle, J2EE, AJAX, Documentum, Weblogic, Struts uu Integration: Various CMBS management systems supporting over 280,000 documents uu User Profile: Front Office, Middle Office and Operations 360+ users uu Geography: Worldwide uu Relationships Status: Ongoing ODC with quarterly releases; T&M basis uu Services Provided: Full cycle: Business analysis, Development, QA/Testing, Maintenance uu Team Size: 7+ team members uu Duration: 4+ years
Business Challenge The bank needed a decision support system to enable more effective decision making in the Prime Services department. The high-level requirements for the data warehouse and business intelligence tools included: uu Minimum capacity requirements for financial product trade data (e.g., fixed income, FX, equities, derivatives, and loans) —— 20+ heterogeneous source systems —— 100+ feeds and ETL processes —— 100+ business users —— 500+ gb of data —— 2M+ trade records per day uu Daily, weekly, and monthly measurement and analysis of the data from the bank’s trade and settlement applications uu BI analysis tools must support features such as drag-and-drop, drill-up/ drill-down, ad-hoc queries, and customizable dashboards
Luxoft Delivered Solution Luxoft created the project proposal, designed the system, and implemented the DWH and BI solution for the bank, performing all of the work activities in business analysis, architecture design, technical implementation, integration with SOA, and post-Production support. The data warehouse was designed for maximum scalability and performance, as well as for ease of maintenance. The core components included: uu Informatica as the ETL and data integration component uu Oracle RDBMS as the database component uu Cognos BI as the presentation component
Luxoft - Case Study
02
Figure 1: Trade Lifecycle Business Intelligence Framework
Using the Informatica platform, Luxoft provided the following ETL and data integration features: uu Single environment that works with multiple, heterogeneous data sources uu Ability to keep up with the rapidly changing business requirements uu Single ETL platform to reduce redundant code while delivering the data to a variety of users and applications uu Opportunity for early involvement of the business users in the data integration process to accelerate the project rollout and minimize the risk of rework Luxoft - Case Study
03
With the Cognos BI engine, Luxoft provided the bank with a wide range of BI applications and analytics including: uu Self-service reporting capabilities that provide the requested information quickly and easily uu Graphical representation of data relationships uu Easy-to-see performance metrics displayed using graphics, gauges, and charts uu Advanced decision support tools that combine analysis, forecasting, and scorecarding capabilities in one easy-to-use package uu Drill-down dashboard reporting, performance based review, management metrics, and performance metrics tools that exploit the service-oriented architecture to provide a configurable framework for long-term planning Luxoft consolidated issue�related information, such as priorities, criticality, time spent, and business domain, from external systems into the data warehouse, providing support teams with the BI tools they needed to: uu React quickly to issues uu Plan resolution policies uu Plan resources uu Manage the support team workload Luxoft made the complex process of load analysis simple for the bank’s IT operations by providing the following BI capabilities: uu Monitoring performance and throughput or load on a server, server farm, or property uu Performance analysis, including analysis of the impact of new releases on the capacity uu Performance tuning to ensure the most efficient use of the existing infrastructure uu Benchmarking the workload growth or shrinkage for capacity planning uu Identifying the influences on the demand for the computing resources uu Capacity planning tools
Luxoft - Case Study
04
Benefits Luxoft delivered the trade lifecycle business intelligence solution on time and within the budget. The bank’s Prime Services department realized the following benefits: uu Single source of truth for key performance indicators maintains alignment to the bank’s business objectives uu Real-time visibility into the trading and system performance to streamline operations uu Advanced, fact-based decision-making support to increase productivity and improve risk management, performance control, capacity management, investment management, and issues management uu Faster, more accurate forecasting and planning support uu A highly scalable architecture to reduce future development costs uu Predictive system intelligence to reduce downtime
Customer Feedback Detailed feedback is available on request.
Luxoft - Case Study
05
About luxoft
Luxoft, a principal subsidiary of IBS Group, is a provider of advanced application and software engineering outsourcing services for global and regional enterprises. Luxoft builds partnerships with its clients, such as Boeing, IBM, Deutsche Bank, UBS, Harman, Avaya, Alstom, and Sabre, based on the culture of engineering excellence, innovation, and deep domain expertise. Luxoft offers international delivery capability through its network of state-of-the-art delivery centers in North America, Eastern Europe, and Asia. Luxoft`s customers benefit from the right mix of technology skills, industry knowledge, proprietary processes and methodologies, and a choice of engagement models. For more information about Luxoft, visit www.luxoft.com www.luxoft.com/financial-services/
Š 2012 Luxoft