ERICK E. MOFFATT
White Plains, NY 10606
OBJECTIVE: To obtain a position utilizing my education, training, and
experience.
EDUCATION: Bernard M. Baruch College University of
Phoenix
City University of New York
Masters of Business Administration
Bachelor of Business Administration
October 2007
1991
EXPERIENCE:
3/05-Present The Bank of New York Mellon (Investment Services Unit)
Brooklyn, NY
Business Line Data Analyst (Enterprise Global Client Solutions)
? Daily setup and maintenance of different institutional investment asset
classes held under custody in centralized global database.
? Adding, modifying, or deleting different data sourced records and other
related duties and tasks assigned or as becomes evident.
? Reviewing and validating client holdings and transactions in order to
maximize data accuracy levels and manage risk.
? Setting complex and dynamic billing rules in order to increase data
integrity and enhance operating leverage.
? Querying data used for testing, planning, business analysis, and
production implementation.
? Importing data through the means of an ASCII text file that with header
record, multiple detail records, and trailer record.
? Extracting data using SQL based written queries by means of Microsoft
SQL Server.
? Manage ongoing project of migrating data from various company system
platforms.
? Developing and documenting of process and procedures used for training
and mitigating operational risk.
? Provide quality, timely, and accurate end user support of any issues
within billing area of responsibility.
? Collaborating and working closely with other functional partners and
business areas.
1/01-3/05 The Bank of New York Mellon
Brooklyn, NY
Billing and Revenue Operations Specialist
? Daily accounting and billing in a fast paced environment of securities
held by The Bank as custodian for its small, medium and large
Institutional clients: Insurance companies, Banks, Foreign Banks, Asia,
EMEA, Mutual Funds, Alternative Investment Services,
Government Agencies, Pension and Trust Clients, and Broker-Dealer Firms.
? Auditing, accounting, maintaining, tracking, and monitoring of security
accounts from valuation to collection according to contracts
negotiated between the Account Relationship Managers and the clients.
? Releasing accounts through the bank's in-house system, resulting in the
production of a preliminary fee calculation or Itemized Fee
Summary Report for Account Administrators review and approval.
? Preparing Accounts Receivable and Accrual journal entries to post into
the General Ledger.
? Communicating with Client Services Unit, Relationship Managers and other
managers concerning problems, missing information and
questions that may arise on a daily basis.
10/95-8/00 The Metropolitan Museum Of Art
New York, NY
Security/Visitor Services
? Overseeing the proper conduct of the visiting public
? Safeguarding the museum's artwork
? Directing the public to various facilities
4/94-5/95 B.E.A. Associates
New York, NY
Assistant Auditor
? Verifying and auditing the market value of securities held by company's
clients
? Reconciling bank statement and client record as directed by section
manager
? Assisting in the preparation of Auditor Reports to insure completeness
and accuracy
? Confirming the accuracy of price and market value of clients' securities
1/92-4/94 C.I.T. Group
New York, NY
Accounts Receivable Clerk
? Reviewing of clients' monthly accounts receivable aged trial balance
? Verifying current balance owed by customers
? Preparing positive confirmation requests in order to insure correct
amount
SKILLS Communication, Spanish, Problem Solving, Leadership, Microsoft Word,
Lotus Notes, Excel, Outlook, PowerPoint, Access, Microsoft SQL, SharePoint,
Enterprise Document Management (EDM), Snagit.