Modelling Financial Instruments
When we developed a front-to-back office global derivatives system, an independently-commissioned technical review by Sybase characterized model as a
"... very unique approach of arriving at a very adaptable logical database design for capital market trading…[s]how[s] good experience and judgment
in terms of implementing the physical database design.”
We exploit our ability to:
- visualize data models in light of their logical relationships; then capture that image in a concise object-oriented
specification with relational DbMS model considering performance implications.
- grasp business requirements for new products or functions from non-technical end-users and independent research;
then communicate a systematic solution to developers for implementation.
- design a generic, systematic and robust solution providing long useful life.
- anticipate exceptions and enhancements and provide accordingly in the original design to minimize maintenance costs.
- identify the economically and operationally significant attributes of instruments.
- integrate diverse instruments across all products in a cohesive design.
- apply industry conventions to functional requirements.
- weigh the cost/benefit of error detection and correction features,
evaluate alternatives, incorporate team members’ ideas into a robust design.
Clients include:
- AIG
- Bank of America
- Caxton
- CitiBank
- CitiGroup
- Derivative Solutions
- Deutsche Bank
- Fidelity Investments
- Freddie Mac
- IBM – Morgan Stanley Dean Witter
- JP Morgan Chase
- JP Morgan Investment Bank
- JP Morgan Private Bank
- JP Morgan Securities
- Merrill Lynch
- Morgan Stanley
- TD Ameritrade
Our experience includes:
Normalized/Operational
- Accounting: G/L & Sub-Ledgers
- Client/Party & Accounts: Institutional & Retail
- Instrument/Security
- Position/Collateral
- Reference: Currency, Geography & Types (diverse)
- Trade/Transaction
- Tax Lots
- Tax Reporting (1099)
Dimensional/Warehouse
- Client/Party & Accounts: Retail
- Financial Reporting
- Instrument/Security
- Operational Losses
- Reference: Currency, Geography & Types (diverse)
- Trade/Transaction
- Tax Lots
- Tax Reporting (1099)
We have built software libraries and can either offer our toolkit and consulting services or can put together systems for:
- Debt / Equity Securities
- MBS, ABS, CMO, Strips
- Spots / Forwards
- Futures: Commodities, Financial
- Security Derivatives (Options, IR Swaps, Caps, etc)
- Credit / Default Swaps
- Foreign Exchange Cash / Options
- Options on Futures / Forwards