Programme/Analyst Resume

Business Expertise:
Corporate Trust
Asset Management
Mutual Funds

Technical Expertise:
Extensive usage of Assembler, COBOL, DB2, CICS, ,EXPIDITOR, INTERTEST, IMS, VSAM, FILEAID, ISPF, XPTR and ENDEVOR under IBM Mainframe.
Light usage of JAVA, HTML, VB and MQSeries

Experience

Confidential, 2001 - July 2008

Programme/Analyst (Consultant)
Met weekly with the Stakeholders, wrote portions of the business and detail specifications and coded for the following:

Mutual Fund Trading:
Requirements:
Eliminate the need to manually call in trades to the respective fund companies
Automate trade settlement
Reconciliation of our books with the funds.

Implementation:

Use NSCC FUND SERV/Profile Service/Networking Service as follows:

Extract mutual fund trades entered on our trading system and send them to NSCC FUND SERV which routes the trades to the applicable fund companies. This includes new account setup instructions.
Process Confirmations or Rejects returned by NSCC FUND SERV (from the fund companies) and update our trading/ posting Systems.
Receive settle data from NSCC and affect appropriate money movement.
Process Acknowledgements and record new fund account numbers.
Receive issue reference information from NSCC profile service for blue sky, exchange, and settle rules.
Receive account reconciliation data from the funds via NSCC networking service and feed into existing reconciliation process.

Environment:
IBM Mainframe using DB2, IMS and XPTR. Communication with server application via DB2 using remote access

Mutual Fund Dividends/Reinvestments:
Requirements:
Eliminate need to manually enter rates for fund dividends/reinvestments
Automate dividend settlement
Reconcile our books with the funds.

Implemetation:

Use NSCC Networking/Profile Service as follows:

Receive dividend data from NSCC and process payments and reinvestments via the current dividend system.
Receive settle data from NSCC and affect appropriate money movement.
Receive daily rates of accrual for applicable mutual funds from NSCC profile service.
Receive account reconciliation data from the funds via NSCC networking service and feed into existing reconciliation process.

Environment:
IBM Mainframe using COBOL, DB2, IMS and XPTR

Performance Reporting:
Requirements:
Current performance system did not conform to AIMR reuirements and didn't allow for CUSIP level returns.

Solution:
Various performance reporting systems were looked at by the performance analyst group and XAMIN was chosen
The following needed to be done in order to get performance results from XAMIN.

Send monthly holdings
Send accounting transactions to the XAMIN performance calculation system.
Send pending trades.
Allow for modification and deletion of pending trades
Analyze various accounting transaction's affect on performance for mapping purposes to performance transactions on XAMIN.
Develop logic to correct defects in processing liability transactions
Develop logic to ignore the Sell of the Sell reversals (reducing gains and/or losses) due to wash sales, I.E. (adjusting Tax Gai/Loss of the Sell Cost Lots) and only use to adjust the Tax Gain/Loss.

System uses COBOL, FTP, DB2 and IMS.
Communication with server application is via DB2 using remote access

Coded for the following:

Charles River Trading:

Reconcile the Charles River (Trading Ststem) Oracle Tables with those in US Trust to check for missing Trades using JAVA Main application invoked by Autosys (Invoked by a CA7 batch Job (Dummy) which is in turn Invoked by a CICS Transaction writing JCL to an extrapartition TDQ defined as the internal reader). The User and Password for the connection to Oracle was taken from a Parameter file on the Transaction server, and the Directory (of an input file to be read and an ouput file to be created) was passed in the Parameters invoking the Application. Upon completion, caused Autosys to schedule a batch Job on the Mainframe to print the results of the Reconcile.

Confidential, 1996 - 2001
Programmer/Analyst ( Consultant)
Designed, wrote the technical specifications, and coded the following:

An Inquiry System that was invoked by Phone to allow Shareholders to inquire against their Holdings and Transactions using COBOL, CICS, IMS and DB2.
Combined Account Statements for the UIT System (in house) with the Mutual Fund system (SUNGARD) using COBOL, CICS, DB2 and IMS.
Send information from the USTRUST UIT System to the CHASE 'TITAN" system and receive data back using MQSERIES and DB2

Confidential, 1979 - 1995
Programmer/Analyst Consultant
Designed, wrote the technical specifications, and coded the following:

Major portions of a stock transfer system (using BAL, COBOL, CICS, DB2 and VSAM), including ESCHEAT processing, dividend calculation and combined checks/statements across CUSIPs.
NSCC interface for a mutual fund recordkeeping system to process trades sent to us from brokers (This interface also accepted Account information including SWP and ADP)

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship