|
|
|
... reveal the names of the clients in the case study, but to give you an understanding of the spectrum and depth of the project we compiled a highly representative selection of the assignments we successfully completed for our clients:
|
 |
 |
|
With a volume of hundreds of thousands trades per day the bank needed a multi-currency data warehousing system capable of:
Generation of on the fly PNL reports
Trade information lookup
Position reporting
Providing customers with secured information over the web
Database performance tuning, query optimization, and indexing of frequently used business data were the corner stones of this project. The developed system was generating reports based on millions of rows of data in a matter of seconds.
|
|
 |
|
With a high volume of trades and thousands of clients, the firm needed to implement a secure, reliable system for reporting on:
Account trade activity
Projected settlement day positions
Cash balance
These reports needed to be delivered to the customers via fax or email within the constraints of the night cycle following the close of business in New York. The allowed period of processing was further shortened by the requirement that the foreign clients receive the reports by the beginning of next business day overseas.
Every report and database process involved was optimized for maximum performance. Reports mappings (client - report) were automatically ranked, generated and delivered based on the time zone of the recipient. Additionally, mappings idle due to inactivity were not processed to minimize CPU load and further improving system performance.
Faxes were delivered utilizing least cost routing (LCR) mechanism, allowing the business to cut costs associated with report distribution.
|
|
 |
|
Brokerage House concerned with the potential vulnerability of their Internet-enabled desktops, open email system, and employee remote access requested Securion performs an Information Security Audit of the company's systems. This audit covered:
User and system password audit, weak password detection and policing.
Internet usage security policy
Company-wide deployment of anti-virus software and regular update rollout.
Automated inventory of patch level of various server software to allow system administrators to keep up-to-date with vendor security advisories, updates and hot-fixes.
|
|
 |
|
Large amounts of information exchanged by the local offices, and high volume of incoming market data from various providers required:
Redesign of upgraded network infrastructure based on Cisco routers and switches
Planned roll-out of upgrades focusing on minimal downtime
|
 |
