|
Partnering with a leading commercial
bank for application development and maintenance
|
|
|
The Client |
|
Our client is one of the largest commercial banks in California
and among the 35 largest banks in the United States. Our client
has branches throughout California, Oregon, and Washington,
as well as offices in New York and Texas. They also have international
offices, mainly along the Pacific Rim. The bank is a full-service
commercial bank, providing a broad mix of financial services
to businesses and individuals.
|
Project Background
|
|
|
There were five projects that were done with our client
in continuation. Each had to be done before the other to
be properly implemented the background of each project is
explained briefly:
IQ Fee Improvement - New maintenance screens were
created for Senders reference and future Distinct Billing
customers and the same was embedded into the existing system
along with Audit trail reports and trigger programs.
MT100 to MT103 Migration - The existing system, which
receives incoming MT100/MT103 and sends out only MT100,
was enhanced to Receive MT103, MT100 and MT103+ and Send
MT103, MT100 optionally. The existing system will ignore
any MT103 tags received. Whereas the enhanced system should
store MT103 tags if MT103 received or should extract and
store MT103 tags when MT100 is received.
Hard copy statement - This is a research on technical
approach in solving the existing printing of hard copy statement
problems faced by OUR CLIENT. This includes printing of
AFP and SCS reports. This includes evaluating the tools
available in market and suggesting one window based tool
and one AS/400 based tool.
Billable Unit Enhancement - After the implementation
of this enhancement, the system will also track IP Book
Transfer Payments were the fee was waived for BKT Items.
Before enhancement these were not tracked. After the implementation
of this enhancement the user could differentiate between
Hard dollar fee and Soft dollar fee.
Customer Advices - After the enhancement, the system
will support the generation of payment advices and payment
messages in
- Telex
- Lotus Notes
- SWIFT message types
|
Scope of the project |
|
|
IQ Fee Improvement - The MT100 enhancement for field
Tag53A is to provide the ability for the Receiving Bank
to optionally reconcile the swift ID of OUR CLIENT in field
53A, instead of their Due to Account number in field Tag
53B.
Scope: To develop new objects Design screens, printer
files, database files, triggers and new Programs. The developed
screen features will provide:
- Ability to Add, Update and Delete records
- Ability to inquire on records
- Protect fields that are not used by this enhancement
- Create triggers for audit report
MT100 to MT103 Migration - In November 2003 SWIFT will
replace the MT100 Customer Transfer message with the MT103.
The MT103 has additional information that must be accommodated
in the existing incoming and outgoing MT100 processing for
International Payments.
Scope: To enhance the existing system, which receives
incoming MT100/MT103 and sends out only MT100 to Receive
MT103, MT100 and MT103+ and Send MT103, MT100 optionally
Hard copy statement - This is a research on technical
approach in solving the existing printing of hard copy
statement problems faced by OUR CLIENT. Presently, customer
statements/reports that are generated on the AS/400 system
are printed on the printer device connected to the AS/400
to generate hard copy statements.
Scope:
- To provide an optimal solution for printing AFP and
SCS reports in minimal time.
- To evaluate the tools available in market and to suggest
one PC based and one AS/400 based tool, which is cost
effective and efficient.
- To provide a solution which will avoid FTP time
Billable Unit Enhancement - (Complex Billable Unit
Volumes and BKT Billable Unit Volumes) Enhancement of Complex
Billable Unit design to allow the tracking of Simple Billable
Units that only contain a soft dollar transaction. The second
enhancement request is for the capturing of IP Book Transfer
Payments (charges to BEN) that did not receive the BKT Fee,
in the IQ Product. The Taiwan Office and other branches want
to be able to charge fees in the Account Analysis System for
these items based on volumes.
Scope: Following 2 modules were modified
- Complex Billable Units Enhancement
- BKT Volume Enhancement
Customer Advices - The Payment Advices enhancement
encompasses new software incorporated into our clients existing
product modules. This enhancement is to support the generation
of payment advices and payment messages in their telex or
email equivalent formats as well as the SWIFT message types.
This enhancement only generates payment advice or payment
messages for “Bank-to-Bank“ payments. This enhancement does
not generate payment advices or payment messages for “Customer
Transfers” such as International Payments (IP) or Incoming
3rd Party Payments (IQ).
Scope:
Message Mapping, Generation and Transmission
- Maintenance/Inquiry Screens
- Reports
|
TCGIvega's Role |
|
|
TCGIvega Onsite/Offshore will study IBG (International
Business Group) requirements and recommend and/or develop
technical solutions.
- Carry out extensive study of the Functional Specification
received from the client to understand the existing processes
and the proposed system.
- Design and develop the solution.
- Complete the requisite documentation.
Thorough check of Offshore QA before shipment. |
Client Benefits |
|
- The above projects were developed or enhanced by TCGIvega
by connecting to the remote the client’s machine, thus
the client was able to monitor each and every progress
in the project with respect to project plan.
- TCGIvega’s efficient offshore model, a result of greater
economy of scale and the advantage based on specialization,
assisted to reduce our client’s operating costs.
|
