Project Description

The application allows view, create modify and handle workflow of different kinds of trades either committed in the markets or out-of-market in the unique way. System traces and loads trades from different sources such as MICEX stock market, FOREX and other places (actually there are about 25 different kinds of market places which system handles) to a single data storage (Oracle data base). Since the all trades stored there is in the unique way the client interface give ability to user to view, change and handle them in the standardized format. Also it provides interface to create new trades on the base of predefined templates (such as simple non-market trade (buy/sell stock), REPO trades, loans, nettings and buy-sell-back trades) with corresponding parameters calculators for each one. Also there are a handful of company-specific trade types with the same features. System also includes the specific business logics for the trades such as ability to hand on trades to back office or modify specific parameters of trades which have been committed on a particular market. Also there has been implemented clients permission system which allows restrict the particular user of viewing specific information or doing not allowed operations.

Project was implemented using C# and Frame Work 3.5. Also were used 3-rd party libraries such as DevExpress and DevArt.
Our team has had 5 members, 4 Oracle developers and I was entirely responsible for the client part of application including UI, interaction with Data Base structure, calculation of the specific parameters of the trades.
JIRA and SVN were used for the project management.

DB interaction

Were used ADO.NET, DevArt - dotNet for Oracle, DataSet memory-cache model.
DevArt was used because it has some advantages upon standard Oracle framework library such as: faster data selection, support asynchronous data selection, has more logical implementation and finally – friendly support team.

UI

User interface largely relies on DevExpress win form controls. The controls which library provides much more comprehensive and have a great deal of extensive functionality in comparison with standard windows controls. For example XtraGrid and XtraLayout controls allow customize presentation of the data on the form by the end-users and then save / restore their preferences. And once again great support.