Rafael C. Alejandrino Home Address Block *** Clementi West

: Street 2

Singapore 120706

Contact (65) 91868139

Number :

E-Mail : aceqdn@r.postjobfree.com.

ph

Qualification IT Systems Specialist with more than 4 years experience as an Asset

Summary Management System Support, 8 years as Treasury System Support, 2

years as Data Warehouse Developer, and 5 years as Programmer/Analyst

employed by a Software Company.

Skills And Knowledgeable In

Strength

PROGRAMMING

LANGUAGES

Informix 4GL > 5

Power Builder > 5

Visual Basic .NET 4

Visual Basic 6.0 > 5

COBOL 4

Oracle PL/SQL 4

DATABASE AND Microsoft SQL Server >5

REPORT WRITERS

Microsoft Access >5

Informix SQL >5

Sybase 11 / 12.5 / 15 >5

Informix Metacube >5

Visual Basic .NET (Reporting Services) >5

Business Objects 4

Crystal Reports 4

INTERNET Macromedia Dreamweaver (ASP) 4

TECHNOLOGIES

OPERATING SYSTEMS Microsoft Windows 95/98/ME/XP >5

/ PRODUCTIVITY

SOFTWARES

Microsoft Windows NT/2000/2003 >5

Microsoft Office 95-2003 >5

UNIX >5

LINUX (Red Hat Enterprise Linux) 4

Connect Direct 4

SFTP >5

PROFESSIONAL Asset Management System Support

EXPERIENCE

assigned to United Overseas Bank Nov. 2009 - Present

396 Alexandra Road #11-00 Alexandra

under DL Resources PTE Ltd.

10 Anson Road #19-12 International Plaza Singapore

079903

Supporting UOB's Asset Management In-House Valuation System

Supporting 3rd Party Application ( Portia Investment Management System

( UOBAM Back-Office Application System)

StatPro Performance Measurement System to Portia Interface

Supporting In-House Interface/Trade Capture System POMS (Portfolio

Order Management System)

AMS (Portia) Intra-Day Orders/Trades File Transfer

UOBAM Asset Management System (AMS Portia) interface to transfer UOI

SHF holdings detail for the purpose of S29 reporting.

Treasury System Support (Systems Specialist)

Rizal Commercial Banking Corporation (RCBC), Makati Aug. 2007 - Oct.

City, Philippines 2009

Provided technical assistance as part of the systems maintenance and

system updates/enhancements.

OPICS Treasury System Maintenance / Daily Operations / End-of-Day Batch

Monitoring

TrOpics Implementation ( Treasury Opics Front-Office Dealing and

Blotter Module )

Regulatory Reports development and Internal Reports as well.

Audit Investigation / Reporting

Act as an IT Project Manager to some of the projects of the Financial

Management Group (Treasury Group).

Limits Monitoring System Project

Foreign Exchange Position Monitoring Project

Foreign Exchange Profit and Loss Monitoring Project

Developed Interfaces for the current Treasury System to be able to

Import/Export Data electronically.

Part of the Team that will convert the current Treasury System (OPICS)

to the New Treasury System (GUAVA).

Server Installation and Application Installation both on Server and

Client PCs.

Database Initial Set-Up, Daily Backup and Restoration.

Export Static Data from the Old Treasury System (OPICS)

Assist in the Preparation of Test Scripts.

Assist in the Set-Up of the System Administration Data.

Development of Custom Reports that is not included in the Standard

Reports of Guava.

Development of Simple Scripting to be used for the automation of

selected user's regular tasks.

Development of Interfaces for purposes of extracting Data from the

Guava Database to be loaded to another external database or external

system.

Import External Data or File to be loaded to Guava Database for

purposes of data consolidation into one single repository or database.

Treasury System Support (Senior Systems Analyst)

Philippine National Bank, Pasay City, Philippines Oct. 2005 -

Jul. 2007

Provided technical assistance as part of the systems maintenance and

system updates/enhancements.

OPICS System Maintenance / Daily Operations / End-of-Day Batch

Monitoring

OPICS Analytics Set-Up and Implementation.

Client Liability Ledger Reporting Facility.

Design and maintain a repository of reports for purposes of increasing

user efficiency, regulatory requirement, management reporting, and

Internal Control Improvement.

Maximize SQL Reporting Services Facility by creation of Regulatory and

Internal Report needed by the users.

Development of a Document Printing Facility thru an ASP Page for use in

the Management of Treasury Confirmation Documents.

Financial Reporting Facility for Central Bank Requirements concerning

PNB's Treasury Accounts.

Regular Systems Analyst (Treasury System Support)

Rizal Commercial Banking Corporation (RCBC), Makati 2002 - Sept.

City, Philippines 2005

Provided technical assistance as part of the systems maintenance and

system updates/enhancements.

Provided technical assistance during system migration from IMMS -

Integrated Money Market System (Old Treasury system running in Unix and

written in Informix) to Kondor-OPICS (New Treasury System), including

application transfers, database conversion and recoding/developing

reports for front-end and back office personnel.

Developed Interfaces for the current Treasury System to be able to

Import/Export Data electronically.

Provided technical assistance during system migration from Kondor

Treasury system to OPICS 6.1.1 Treasury system. That is, to be able to

have an All OPICS Treasury System ( Front-Office and Back-Office)

Data Warehouse Developer

Societe Generale De Surveillance (SGS), Makati City, 1998 - 2001

Philippines

Part of the team that design, develop and implement Data Warehouse

Facilities for Bureau of Customs.

Conducted a series of training session for the transfer of technology

to BOC IT People.

Programmer Analyst (Systems Development/Maintenance)

Center for Information and Computer Systems, Inc., 1993 - 1997

Quezon City, Philippines

Develop and maintain a number of business systems for different type of

industries such as banking, manufacturing, and others.

EDUCATIONAL Master in Business Administration (Undergraduate) 1994 - 1995

BACKGROUND San Sebastian College, Claro M. Recto Manila,

Philippines

Bachelor of Science in Commerce ( Major in Computer 1989 - 1993

Science )

San Sebastian College, Claro M. Recto Manila,

Philippines

Detailed Bank's Treasury System (Philippines) May 2002 - Oct

Projects / 2009

Assignments

Treasury Placements, Coupon Payments and Maturity

Develop an Interface Program (Visual Basic) for this Auto Debit and

Credit Facility.

Use IBM WebSphere MQ as the Messaging Backbone.

Up-Stream Systems (Wealth Management, General Ledger, Swift, Client

Liability Ledger, and Others)

Develop/Maintain Interfaces to be able to Import/Export Data

electronically thru SFTP.

Monitor Daily Issues and Compliance Requirements.

Reuter's FX Deal / FX Rates

Downloading of FX Deals and FX Rates on a real-time basis or upon

availability basis.

Uploading of FX Deals and FX Rates to OPICS (Treasury System of the

Bank).

Bloomberg Fixed Income Dealing and Securities Pricing Terminals.

Downloading of FI Deals and Security Prices on batch mode or upon

operator request.

Uploading of FI Deals and Security Prices to OPICS (Treasury System of

the Bank).

Treasury System Upgrade Or New System Implementation (Front-Office,

Middle-Office and Back-Office)

Explore possible Options, depends on the preferences of the system

owner and management.

Upgrade of the current system to OPICS Plus with Eagle Eye and OPICS

Risk.

Implementation of a new treasury system that will replace the current

system.

Implement a separate system for Front-Office and for Back-Office or

Middle-Office.

Treasury System Evaluation

System Vendor Coordination (Reuters, Bloomberg, Misys-OPICS, and

others)

Monitors System Integration Testing and User Acceptance Testing for Any

new releases and bug fixes.

Maintenance Issues.

Conducts System Review with the concerned Vendor and Users in case

there is a new requirement needed by the business.

Admin Tasks (Treasury business related)

Attends orientation/presentation on any IT Related topics that may or

will affect the business group that we are supporting. And then make a

report to the MIS or IT Manager.

In compliance to Central Bank or any government regulating body, be

involve in any treasury system study needed by the bank to provide the

needed data/information.

TrOpics Implementation (Opics Front-Office Dealing and Blotter Module)

Upgrade Database Driver Version (Sybase ASE) as required by Application

Vendor (Opics Misys)

Simulation and Testing.

Conversion Plan Preparation.

Implementation execution.

Addressing Post-Implementation Issues.

OPICS Treasury System Maintenance / System Updates

Provide Production Support and/or Technical Assistance.

Audit Investigation.

Regulatory Reports development and Internal Reports as well.

End-of-Day Batch Daily Monitoring.

Real-time limit checking for Foreign Exchange, Fixed Income, and

Deposit & Loans.

Possible solutions :

Explore OPICS functionality

Which monitor the limits and exposures for each particular Treasury

Deals.

Develop an In-House Solution to cover the limitations of the current

treasury system with regards to Limits Monitoring or Limits Checking.

Limits Monitoring (LINQ/LimSys) for Treasury Liquidity's usage.

Task Lists

User Requirement Gathering

Development

System Simulation and Testing

Implementation

Foreign Exchange Position Monitoring

User Requirement Gathering

System Integration Testing with Feeder Systems

Foreign Exchange Profit and Loss Monitoring (P/L Reconciliation of FX

transactions)

This will help automate FX Profit and Loss monitoring of HO Units/BC

and Treasury via System Interface.

It also covers P/L Reconciliation of FX transactions in compliance with

Central Bank's audit findings.

User Requirement Gathering

System Applications Design

Simulation and Testing

Implementation

NPV Reporting (Net Present Value) Facility and Auto Generation of

Booking Enties.

User Requirement Gathering

System Applications Design

Simulation and Testing

Implementation

Inter-Books Bridging (Regular-FCDU) Auto Generation of General Ledger

Entries.

User Requirement Gathering

System Applications Design

Simulation and Testing

Implementation

Exception Reporting of Treasury's NOSTRO Earmarking Versus Swift.

To be able to identify Earmarked Transaction(s) that has No Swift.

Monthly ADB report for BC (Currently this is done thru FTP Server

Uploading)

Provide Business Centers their monthly outstanding investments report

thru email notification and/or web browser. Purpose of this is to

upgrade the current reporting services/functionalities being provided

to users.

PDEX for FI (uploading of transactions from excel linked to PDEX

System)

Develop an interface to upload FI Transactions coming from PDEX going

to the target system.

Gap report

Development and Implementation of a Reporting/Monitoring Facility for

the purpose of determining the bank's liquidity.

Designed and maintained a repository of reports for purposes of

increasing user efficiency,

regulatory requirement, management reporting, and Internal Control

Improvement.

Maximize SQL Reporting Services Facility by creation of Regulatory and

Internal Report needed by the users.

Development of a Document Printing Facility thru an ASP Page for use in

the Management of Treasury Confirmation Documents.

Financial Reporting Facility for Central Bank Requirements concerning

PNB's Treasury Accounts.

Upgrade/Conversion of Treasury System Access Report Facility (current

version MsAccess97).

Develop and Implement required Treasury System Reports using a better

reporting tool.

Purpose is to upgrade the current reporting services / functionalities

being provided to users.

And to be able to catch-up with the advancements in the current

technology.

Development of Data Migration Tasks using SSIS (SQL Server Integration

Services).

This is to be able to export important data or information from Source

DB (Sybase) and then transform to a new Ms-SQL Server DB.

Use SSRS (SQL Server Reporting Services) in building a new business

intelligence tools for the treasury system users. In particular, this

will be use in the creation of new set of reports that can be

administered via web interface.

Certification of Balances (COB)

Develop Lotus Notes Database, must be upgraded to another application

tool.

This report facility helps ensure that Treasury's COB is in-sync with

the Bank's Financial

Management System.

User Requirement Gathering

System Applications Design

Simulation and Testing

Implementation

Nostro CORR Movements (current version MsAccess97, must be upgraded to

another application tool)

Upgrade and/or Convert the auto-generation of Nostro CORR movement

report/file being uploaded

to Risk Management Department.

User Requirement Gathering

System Applications Design

Simulation and Testing

Implementation

CLL Interface (current version MsAccess97, must be upgraded to another

application tool)

Upgrade and/or Convert the auto-generation of client's balances to CLL

for compliance purposes.

User Requirement Gathering

System Applications Design

Simulation and Testing

Implementation

GDA Deal Confirmation and Confirmation Printing Facility (currently

being handled thru Lotus Notes but must be upgraded to another

application tool)

Provide Business Centers their GDA Deal Confirmation and Confirmation

Printing Facility thru web

browser.

User Requirement Gathering

System Applications Design

Simulation and Testing

Implementation

Provided technical assistance as part of the systems maintenance and

system updates/enhancements.

OPICS System Maintenance / Daily Operations / End-of-Day Batch

Monitoring

OPICS Analytics Set-Up and Implementation.

Client Liability Ledger Reporting Facility.

Provided technical assistance during system migration from IMMS -

Integrated Money Market System (Old Treasury system running in Unix and

written in Informix) to Kondor-OPICS (New Treasury System), including

application transfers, database conversion and recoding/developing

reports for front-end and back office personnel.

Provided technical assistance during system migration from Kondor

Treasury system to OPICS 6.1.1 Treasury system. That is, to be able to

have an All OPICS Treasury System ( Front-Office and Back-Office)

Societe Generale De Surveillance (SGS) 1998 - 2001

CRF-IAN DataWarehouse Project (Clean Report of Findings and Import

Assessment Note)

develop, as well as implement the data loading and validation

facilities for the DataWarehouse Project.

provide simple Data Mining Tool as the starting point for the future

expansion of the DataWarehouse facility.

MWLS (Manufacturing WareHouse Liquidation System )

review and modify the system for compliance to Y2K, as well as its

potential for the possible integration to the DataWarehouse.

Center for Information and Computer Systems, Inc 1993 - 1997

RIMMS (Remittance and Inter-Office Memorandum System)

develop and maintain the system for Land Bank of the Philippines

IPS (Inventory and Purchasing System)

provide maintenance and enhancement on the system for Magnolia Nestle

Philippines

IPS (Inventory and Purchasing System)

customized and provide maintenance/enhancement on the system for BMEG

San Miguel Corporation Philippines

CGOIS (Contract Growing Operations and Inventory System)

provide maintenance and enhancement on the system for Magnolia Chicken

San Miguel Corporation Philippines

TRAININGS Introduction to VB.Net Programming May. 2008

and SEMINARS MISNet Makati City, Philippines

ATTENDED

Opics Functional and Technical Training Feb. 2008

White Plains, New York City USA

OPICS (FX700-Foreign Exchange Maintenance & June 20, 2006

Support)

Manila Peninsula, Sionil Jose Room, Philippines

OPICS (RW100-Report Writer) June 8, 2006

Manila Peninsula, Sionil Jose Room, Philippines

OPICS (EI100-Introduction to External Interfaces June 8, 2006

Manila Peninsula, Sionil Jose Room, Philippines

Sybase System and Database Server Administration December, 2001

12.0

Sybase Phils., The Enterprise Tower, Makati

City, Philippines

Informix (Datawarehousing using Metacube ROLAP) April, 1999

Informix Phils., Makati City, Philippines

Fast Track to PowerBuilder Plus January, 1999

Sybase Phils., The Enterprise Tower, Makati

City, Philippines

System Analysis and Design August, 1996

De La Salle Graduate School, Manila, Philippines

In-House Trainning (Informix-SQL) December, 1994

CICS Office, New Manila, Quezon City,

Philippines

In-House Training (Informix-4GL) December, 1994

CICS Office, New Manila, Quezon City,

Philippines

TERM III - Advance COBOL Programming with May, 1993

Mainframe CICS

STI-Systems Technology Institute, Makati City,

Philippines

Business System Course July, 1993

STI-Systems Technology Institute, Makati City,

Philippines

COBOL Programming Proficiency (Block 2) November, 1992

STI-Systems Technology Institute, Makati City,

Philippines

DBASE (Tutorial Training Program) Nov 20, 1991

STI Computer Campus Inc, Training Center,

Manila, Philippines

Contact this candidate