CASE STUDIES: Major financial institution put its trust in GL Associates
Account administrators needed to accurately track the investments and instructions of institutional customers in order to allocate funds for maximum investment return.
Institutional investment account managers wanted to accurately record the current status of a client’s account, as well as any investment instructions that the client may have issued. The instructions ranged from securities buy/sells, cash transfers to wire transfers and check writing. Since billions of dollars were under management, some of the instructions dictated that money be moved overnight, and returned in the morning to gain the maximum in overnight interest.
Accuracy depended on being able to properly calculate each account’s projected cash balance from a variety of different sources. These included pending trades, cancelled trades and settled transactions. Additionally, customer instructions and other extraordinary events needed to be figured into the cash balance calculation.
GL Associates implemented a custom Intranet-based application that provided account administrators with an efficient means of viewing all the required data and inputting transactions and instructions in a simple yet elegant interface.
This Cash Management System provides an orderly process for gathering and acting on cash balance information. An administrator logs onto the system and views a grid with summary account information. A click on any account results in a worksheet where details on account positions, instructions and cash balances can be easily viewed.
A series of navigation buttons leads to screens that reveal more extensive details and entry areas for account rules, instructions and adjustments. The system also has extensive reporting capabilities including a tool for producing custom “ad hoc” reports.
GL Associates relied on Microsoft technologies to implement what was an n-tiered solution. We started with a Microsoft SQL Server database that we populate nightly from the client’s mainframe system through IBM’s MQSeries for Windows NT. In the middle tier, the business processes were implemented using COM objects developed with Microsoft Visual Basic and managed by COM+. Web pages that comprise the system’s top tier are Active Server Pages. During the day MQSeries was also used to perform interactive messaging with a number of back-end custody and trust accounting systems
EMAIL
PRINT PAGESPOTLIGHT
ERP INSTANCE CONSOLIDATIONGL Associates performs major ERP database instance consolidations for JD Edwards, Oracle and PeopleSoft ERP systems. Our methodologies and automated conversion tools enable us to perform these projects in planned timeframes with high quality testing cycles at a predictable cost. We have experience with every need in ERP database instance consolidations including reorganizations, divestitures, and mergers (of similar and dissimilar businesses).
EVENTS
PRESS RELEASE: 2010 Technology Best PracticesJul 15th 2010
Optimizing the Chart of Accounts for Robust Management Reporting in JD Edwards
Sep 14th 2010