Customer Service Analyst

Joseph F. Burns

Professional Experience

*/** - *******- ********* ******* Processor

PNC Bank Philadelphia, Pa.

. Domestic and Global Corporate Actions processor responsible for

scrubbing data from press releases and prospectus

. Monitored letters of transmittals, vendors and DTCC source materials

for all events

. Processed information to MS Access to inform all traders,

administrators and cashiering of announcements

. Processed all end of day general ledger entries on financings and

positions on ADP

. Responsible for analyzing, reconciling and comparing stock record

positions with DTC inventory on tender offers, conversions, mergers,

reverse/forward splits, optional dividends, bonus issues, memorial

dividends, rights offerings, bankruptcies, Dutch offerings

12/08-12/10 Business Analyst / SME Corporate Actions

Bank of America New York, NY

. Analyzed Prime Broker corporate actions process for migration to Bank

Paribas

. Processed prime broker corporate actions on tenders, rights, calls,

name changes

. Reconciled monies and allocated securities for administrators, Fed,

DTC and custodians

. Processed voluntary and mandatory tenders on BPS/ ICI /Cage

Three/Gloss

3/08-11/08 Business Analyst / SME Corporate Actions

KeyBank Brooklyn, Ohio

. Consulted with management to develop a plan of action on Key Bank's

platform conversion

onto ADP's BPS Gloss and ICI platforms

. SME for bank's operations with emphasis on corporate actions and

dividends for conversion onto BPS Gloss and ICI platform

. Created use cases using UML (Unified Modeling Language) visual models

/data modeling /business modeling relationship diagrams and work

flows/ object modeling and component modeling

. Provided analysis of end-user information needs

. Gathered requirements from business users making sure information was

accurate, timely, complete and documented

. Developed detailed business requirements documents and functional

specifications using

SDLC (System Development Life Cycle)

. Performed gap analysis between business requirements and current

capabilities

. Performed UAT testing/ analysis/ design /implementation/ testing

evaluation of operations; obtained acceptance for installation and

deployment

. Involved with set-ups of B1's, Track file reports, pending div file,

interim accounting files, MSD, mapping name and address, and account

cross reference files

. Analyzed how interface with Ridge clearing and Post edge would affect

clearing business

1/08 - 3/08 Business Analyst / SME Counterparty Risk

JP Morgan /Treadneedle Asset Mgr. / Swindon UK

. Partnered with management to develop a plan of action on evaluating

newly acquired asset manager

. Analyzed the risk and compliance of the firm's operational business

with emphasis on the collection and reconciliation of DTC statements,

Bank statements, Confirmations, swift messages

. Recommended daily (vs. current weekly) reconciliation of all security

positions and money statements, reporting any risk and compliance

issues to management and controllers

. Involved in analysis of Master Security Department (MSD); Updating

code specifications and evaluating current capabilities of MSD to

benchmarking with other security code vendor systems

2/06 - 1/08 Business Analyst

Bank of New York New York, NY

. Collaborated with managers to segregate "aged" differences from "new"

differences

. Reconciled differences at DTC, Euroclear, agent and client holdings

including interest income in foreign nostros accounts. Balanced

optional cash dividends

. Reconciled positions and monies by adjusting transactions on GPS by

swift messages or by adjusting entries on internal systems

. Calculated and processed currency trades; made withholding tax rate

adjustments and money pair-offs to balance payable and receivable

accounts and optional dividends

. Set up and reconciled Corporate Actions events on tenders, mergers,

acquisitions, splits, warrants, rights, calls, redemptions, name

changes, spin-offs, buybacks

. Solved problems with trading desk, administrators, agents, customers,

custodians and subs; pre- balanced and post- balance foreign accounts

for corporate actions and dividend events

. Performed end of day foreign trade financing and reconciliation of

overdrafts

11/03-1/06 Business Analyst

Deutsche Bank New York, NY

. Consulted on project to convert ADP system to in-house E-Spear system.

Helped structure outsourcing of various operation's departments to

India

. Reconciled with DTC, CNS, P&S, traders, stock loans, Corporate Actions

on redemptions, calls, mergers, name changes, tenders. Reconciled

stock record breaks during conversion

. Worked in International department processing foreign income

collection, reconciling ADR's/ORD, nostros accounts, settlements,

foreign exchanges and swaps on Gloss system

. Collaborated and resolved foreign nostro accounts and transaction

problems for FX and swaps trading desk on trades at DTCC, FED,

EUROCLEAR, CEDEL, CREST,GLOSS

1/01 - 10/03 Mgr. of Customer Admin

National Australia Bank New York, NY

. Analyzed and structured bank's plans to become a broker dealer. Set-up

and created a separate firewall splitting bank operations departments

. Managed broker/ dealer operations

. Developed and managed all broker/dealer trading support Ops/Protocol

. Wrote settlement procedures, restructured customer service department

. Settled all DTC, stock loans, Income collections, Australian Gov't

bonds. Responsible for settling all equity, corporate, gov'ts, IPO's

and private placement trades

. Analyzed budget for broker dealer's operation's objectives.

Restructured New account department, reconciled trading profit and

loss ledger for accounting, traders and partners. Partnered with

Bloomberg/ADP to create efficient trade reporting to branches

Education: CCNY Tech Computer Science

Netcom Information Technology courses:

2778: Writing Queries using MS SQL server 2008 Transact-SQL / 6232:

Implementing a MS SQL Server 2008 Database / 6231: Maintaining a MS SQL

Server 2008 Database / Project Management Professional courses

Licenses: Expired series 7 and 63, NY Real-Estate, Health life and Accident

Insurance

Computer Applications: : MS Word, MS Excel, MS T-SQL 2008, Visio, Power-

point, Bloomberg, Euclid, PTC, DTC, NSCC, CEDOM, ISCC, GSCC, World lend,

Data Explorer, Intellimatch,, Reuters, ADP, Gloss, Global one, Smart

stream, Trace, AML, KYC Risk compliance

Contact this candidate