case study research analysis support banking luxoft for one of the top3largest bank in russia
DESCRIPTION
luxoft software developmentTRANSCRIPT
For more information about Luxoft, visitwww.luxoft.com
www.luxoft.com/financial-services/
case study
ReseaRch analysis suppoRt system foR a leading Russian Bank
Summary
13.09.2012
Develop a comprehensive, intelligent database to support the bank’s research department in market data analysis and the publications workflow.
u Client: One of the top three largest banks in russia u Business AreA: market analytics and research u Asset ClAsses: Equities, Fixed income, Indices u teChnology set: .NET 3.5: aSP.NET, WCF WWF, SmTP, aJaX, XSLT/XmL,
mS SQL Server 2005 u integrAtion: SOaP 1.2, SmTP Pooling, SOa over WCF, message Queuing u user Profile: research analysts, Compliance, Editors, Desktop
Publisher u geogrAPhy: moscow, London u relAtionshiPs stAtus: Ongoing, Fixed Price u serviCes Provided: Full cycle: Business analysis, Development,
Qa/Testing, maintenance u teAm size: 12+ u durAtion: 2+ years development and ongoing enhancements
BuSINESS ChaLLENgE
In 2008, the bank began an initiative to build an in-house market research and analysis team. To support the new department, a solution was needed for:
u a comprehensive database of equities, bonds, currencies, indices, company financial indicators and more
u automated import of market data from the mICEX and rTS exchanges and the Bloomberg agency
u automated distribution of calculated market analysis data and reports to research analysts and other company subscribers via email, as well as online, on-demand reporting
02Luxoft - Case Study
LuXOFT DELIvErED SOLuTION
Luxoft delivered the initial system on time and within the budget and new capabilities continue to be added as requested by the bank.
Luxoft’s market research database (rDB) was designed and populated with 10 years of historical market data and is automatically updated daily with current market information from financial information providers and stock exchanges. a wide range of standard ratios and parameters (i.e., yields, durations, spreads, yield curves, P/E, rOE, and mCaP) are calculated with configurable models and algorithms. more than 40 types of market data analysis reports are compiled in both russian and English, with automatic distribution to company subscribers.
Key business functions include market data management, data analysis, client or subscriber management, publication workflow governance, distribution management, and importing market data.
03Luxoft - Case Study
Future functionality will include improvements in publication workflow, document authoring, on-demand publications from ready-to-use calculated data blocks, additional analysis parameters in the Fixed Income analysis block, and development of an Internet research Portal.
Luxoft’s solution uses an n-tiered, layered architecture for maximum stability and flexibility. Functional capabilities are supported by four main components: email distribution, document storing, publication workflow, and market data imports.
Figure 1: research database
functional framework
Figure 2: research
database solution architecture
MARKET DATAMANAGEMENT
NEWS,EVENTS
TARGET PRICES,COMPANY FORECAUSTVERSIONS
COMPANY FINANCIALINDICATORS
INDICES, CURRENCY PAIRS
EQUITIES,BONDS
CLIENT MANAGEMENT
CRMINTEGRATION
SUBSCRIPTIONMANAGEMENT
LOAD BALANCING/FAILOVER
24X7 AVAILABILITY
AUTOMATICDISTRIBUTION
RDB
FEEDS
REUTERS(PROJECTED)
MICEX
RTS
BLOOMBERG
PUBLICATIONWORKFLOW
LIGHT-WEIGHTCUSTOM SOLUTION
SECURITY AND USER ROLES
MS OFFICE 2007INTEGRATED
DOCUMENT VERSIONCONTROL SUPPORT
COMPILANCEINTEGRATION
DATAANALYSIS
EXCEL-INTEGRATEDDATA EXPORT
CUSTOMIZABLEFORMULAS,ALGORITMS AND FORMATING
FIXED INCOMEREPORTS AND BOND CALCULATION
EQUITY ANDCOMPANY REPORTS
MAILSERVER
MS SQL SERVER 2005
ANALYST / ADMININTERNET EXPLORER
ANALYST / ADMININTERNET EXPLORER
REPORTFILES
FEEDFILES
WINDOWS 2003 SERVER+IIS + .NET RUNTIME
DOCUMENT STORING COMPONENT (Custom WebDAV PROTOCOL IMPLEMENTATION FOR STORING REPORT FILES IN DATABASE)
EMAILER
COMPONENT “WORKFLOW”
WINDOWS WORKFLOWFOUNDATION ACTIVITIES
FEEDS
DOMAINMODEL
SERVICES
NHibernate DAL
ASP Web UI
EXCEL EXPORT
INTERNET
03Luxoft - Case Study
CuSTOmEr FEEDBaCK
BENEFITS
With Luxoft’s technical expertise and advanced business domain knowledge, the bank realized the following benefits:
u Improved the quality of the analysis and interpretation of market data, facilitating better strategic and tactical decision-making
u reduced risks with improved governance of best-practice compliance and improved data quality
u added benchmark capabilities with 10 years of market history
u Increased productivity with automated distribution services
Detailed feedback is available on request.
emailer component
This component is dedicated to meeting the email distribution requirements. It is designed to interact with multiple SmTP mail servers for failover purposes and can be dynamically configured. It also includes notifications for system health other types of alerts.
document storing component
Documents in the system are stored in database. access to documents provided via custom implementation of WebDav protocol.
publication Workflow component
The publication workflow component governs the distribution of the research department’s analytical report documents to subscribers. The workflow uses the Windows Workflow Foundation (WWF) technology to schedule and execute publication activities and to manage the external data exchange.
market data import component (feeds)
This component is responsible for parsing, transforming and uploading market data feeds into the database. The data feed import process is optimized with centralized error handling, detailed logging, and load balancing routines.
about luxoftLuxoft, 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.comwww.luxoft.com/financial-services/
© 2012 Luxoft