Within Large and successful Organizations, there is a Revenue Centre. None other than the Corporate Treasury Department, it generally manages corporate finances, and ensures judicious use of surpluses in Investment/ deposits and Money Market operations and also raises cst effective finance for the Organization’s short term and long term operations. Apart from these functions, the Treasury Department is also responsible for carrying out the Board’s directive in organizational policies associated with the financial exposure of an organization, while transacting any third party financial arrangements. Adherence to these policies needs to be monitored to avoid preventable financial exposure / risk.

In many Organizations, the lack of a proper Risk management solution exposes the organization to several external influences. There are many Treasury solutions in the market today. Many of them comes with innumerable bells and whistles, making the product unwieldy, expensive, costly to maintain and also difficult to use or manage. The need of the hour is a straight forward Treasury and Risk Management solution that is easy to learn and use, which addresses the Organizations risk concerns and ensures that the agreed policies are practiced without deviation and appropriate checks and balances are in place to protect Organizations cash assets and financial exposure.

In Organizations where no Treasury solutions are in place, it is quite possible that when the Treasury Manager or a Dealer directly deals with counter parties, for making financial arrangement, (which may be in the form of an investment / deposit / loan etc) there is a possibility of human error and possible deviation or even deliberate sidestepping (without approvals) of the Treasury policy, exposing the organization to large exposures that may lead to embarrassing losses. This also can harm the reputation and image of a Corporation. In order to avoid such situations, Arowana Consulting Limited, joined hands with certain leading Corporate Organizations and Treasury Domain experts to develop a simple product called Arowana Risk and Treasury Solution (ART) which is suitable for any Corporate Organization, involved with day to day Market operations in the Money Markets and Currency Markets. ART interfaces with ERP solutions, Business Intelligence and Dashboard programmes, which means that the day to day operations of your Treasury desk is transparent and can be monitored and set to raise appropriate alerts.

• Addresses all Treasury management and reporting needs in a single, streamlined system
• Helps eliminate redundant entries and reduces errors
• Connects to clearing banks to offer integrated Treasury processes from the front- to back-office
• Provides a real-time, online system that gives up-to-the minute balances and exposure status throughout the day.
• Fixed-Income Module- an accounting system for fixed-income securities that is designed to comply with local regulations.
• Money Markets - a collection of funding options for the institution and its clients
• Investment Management - functionality that includes real-time portfolio accounting, reporting and management services
• Safekeeping - functionality that provides online, real-time information, transaction processing, and customer statements and reporting.
• Sales and Trading- a module for executing and managing securities transactions, providing immediate position updates, event notifications and integrated online reports
• Similar modules for Foreign Exchange, Equities and their Derivatives.

• Improves security coverage, portfolio accounting and performance measurement
• Allows automation of internal processes
• Automatically integrates transactions into general ledger, asset and risk management systems
• Keeps local regulations-compliant records with a minimum of human intervention
• Allows users to easily generate a range of compliance reports and statements
• Gives users the ability to customize the accounting system to best fit their business
• Commits to flexible terms and interest rate structures
• inks directly to depositories and custodian banks
• Offers online trade approval, with automatic calculation of broker and sales commissions and automatic generation of confirmations.

ART is designed in Java environment. The system properly interfaces with all ERP solutions and also is capable of receiving information from providers like Reuters and Bloomberg etc. The output provided to the ERP systems can help the ERP business users to automatically generate vouchers and update the underlying General Ledger.

The proposed solution addresses human errors and will prove to be advantageous for an organization by helping them to adhere to the business rules. ART is fully configurable and takes into account various intricate aspects related to the core treasury business. The Treasury Manager can configure business rules in the system, dynamically as per ever changing business demands. The proposed software solution will be the key to control the process and quality of Treasury Operations.

• Efficient ticket application process performs most of the checks at the time of applying, therefore reducing responsibility of processing agent.
• Helps proper tracking of requests by requester and processing agent, eliminating risk of requests being lost en route.
• Automatic ticketing reduces workload on processing department
• Automatic ticketing process books tickets accurately eliminating human errors in computation of fares, taxes etc.
• Employees do not need to wait in queue for refunds of tickets counter.
• Employees need not wait in queue at a Staff Travel Centre, hence, increasing productivity.
• Allows printing of IATA rebate letters.
• Duty travel approval process saves employee time in approaching their supervisor.
• Duty travel claims allows employees to claim expenses after returning from duty travel.
• Automated online transfer of duty travel claim amount to salary, saving manual input into financial system.

• Microsoft ASP.NET 3.5 Framework
• Oracle 11G
• C#.Net
• Microsoft Enterprise Practices Library 4.0

• Automated web-based internet solution
• Easily scalable for future business requirement
• Seamless Integration with PMS
• Ease of use and data consistency
• Ease of use in querying and reporting
• The system will also provide operational features for seamless but controlled access across functionality, loading of data from various systems, Access Control and Audit trail.
• The proposed systems also will use agents for data download from multiple end points and integrate with system data.
• Considerable improve efficiency of service.

The Technology framework is below:

• Telerik Controls (3rd Party UI control framework)
• Windows Server 2008 with IIS 7
• Visual Studio 2010
• Sql Server 2010