Multi-Currency Cash Management Application
Money-Market Global Division Gains a Reliable, Trusted, High Performance and Flexible Application for Cash Management in London.

To improve control and minimise operational and reputational risk in its cash management unit, London Branch of a major European bank replaced a manual process based on an internally unsupported Microsoft Excel spreadsheet with a new Microsoft Visual Basic 6.0 application based on n-tier distributed methodology with business logic COM+ components hosted on Microsoft Transaction Server, Microsoft Internet Information Server and Microsoft SQL Server 2000 Enterprise Edition. The application uses Active Server Pages (ASP) populated with content that resides in an associated Microsoft SQL Server 2000 database. Business logic is encapsulated in stored procedures and data transformations from back-office and front-office systems are encapsulated in Data Transformation Services (DTS) packages for reliability, maintainability and recoverability. Performance and availability is guaranteed by using a Compaq DL-580 dual processor 2-node cluster in active-active configuration running Microsoft Windows 2000 Advanced Server with Clustering Services.
View full case study

Misys Meridian Middleware Implementation
London Branch replaced manual deal input from Reuters Kondor into Misys Midas with a Straight Through Processing Solution using Misys Meridian Middleware, IBM MQSeries, Microsoft SQL Server 2000 Enterprise Edition and Microsoft Windows 2000 Advanced Server with Clustering Services.

London Branch of a major European bank replaced manual deal input from Reuters Kondor front-office dealing system into Misys Midas with a straight through processing solution using Misys Meridian Middleware, IBM MQSeries, Microsoft SQL Server 2000, Enterprise Edition and Microsoft Windows 2000 Advanced Server with Clustering Services. A number of technical architecture options were evaluated with the key question in mind: How to leverage the existing skills set and investment in Microsoft SQL Server 2000 and provide a reliable lower cost solution. The chosen solution also include an intranet site (Observatory) hosted on Microsoft Internet information Server using Active Server Pages for monitoring transaction status, throughput and management information within the Misys meridian Middleware Repository and a Microsoft Visual Basic 6.0 application (Prospero) for the maintenance of static data required by the new interface.
View full case study

External Audit Letters and Data Warehouse
Audit Department in London Deploys High Performance Reliable VB .NET Application to Respond to Adhoc Audit Requests from Customers and their Auditors.

To enhance the accuracy and control of response to external audit requests from clients and their auditors, The Audit Department in London Branch of a major European bank replaced a Microsoft Visual Basic 6.0 application with a new Microsoft Visual Basic .NET Windows form application. Given development timescale of four weeks, the Microsoft .NET Framework and Microsoft Visual Studio .NET 2003 was chosen as the development platform of choice. Business analysis revealed that the AS/400 back office deals data required by the new solution was loaded separately into three Microsoft SQL Server 2000 databases using different jobs and schedules on the AS/400 and three distinct processes on the Microsoft Windows 2000 Advanced Server. One question remained: How best to consolidate these separate data extracts into a single data warehouse solution? The bank chose a data warehouse solution based on Microsoft SQL Server 2000, Enterprise Edition.
View full case study

Timesheet Application
To help allocate project costs and track annual leave and absences, the IT Department in London Branch Deploys A Flexible Low Cost Timesheet Application with Microsoft Outlook Forms and Microsoft Exchange 2000 Platform.

The IT Department London Branch of a major European bank implemented a flexible and inexpensive solution for time, annual leave and absence recording that leverages the bank's investment in Microsoft Exchange 2000 Server using Microsoft Outlook forms, a Microsoft SQL Server 2000, Enterprise Edition database and Microsoft Access 2000 for management reporting to help in the efficient allocation of project and support costs and the effective management of annual leave and absences.
View full case study

Application Support Services
Bank Outsources High Availability Application Support to WinSQL as Part of Ongoing Long Term Business Relationship in London.

As part of a long term ongoing relationship, London Branch of a major European bank outsourced high availability application support services to Windows & SQL Programmers Ltd (WinSQL). A service level agreements was agreed between the bank and WinSQL to provide on-site support from 08:30 to 18:00 Monday-Friday. The service includes incident troubleshooting through problem resolution and includes the escalation and tracking of incidents with third party vendors. The service has been expanded to meet the bank ongoing requirements to include a number of third-party software and applications in addition to internally developed Microsoft Visual Basic and Microsoft SQL Server applications.
View full case study