Microsoft Office Data

Skills

●Good communication and interpersonal skills

●Microsoft office products (Excel, PowerPoint, Word and Access)

●Advanced Excel (VBA,Vlookup, Pivot tables, financial functions and Macros)

●Experience Systems ( Portia, CDO Suite, Markit Wall Street Office, BlackRock Aladdin and, Markit ClearPar)

●Equally effective as a team member and an individual

Work Experience

October 2014 - Present

Neuberger Berman Services LLC, Chicago, IL

Senior Analyst

●Responsible for improving excel models using VBA skills and other analytical tools

●Develop and maintain relationships with traders, portfolio managers and custodians for resolution of position breaks.

●Coordinate settlements with custodians, brokers and traders to resolve all failing trades.

●Facilitate on boarding of new accounts using LSTA guidelines and complete setup in Aladdin in other relevant trading systems.

●Collaborate with traders, portfolio managers and accounting to ensure amendment and corporate action activities are captured in the relevant systems.

January 2011 - Present

US Bank(Formerly Bank of America), Chicago, IL

Senior CDO Analyst - Reporting

●Forecasted accurate interest payment and collateral posting according to governing documents

●Develop flexible financial models and perform ad hoc financial forecasting and analysis using Microsoft Excel

●Responsible for creating the Trustee report that is used by our clients to make investment decisions. The report consist of liquidity and profitability benchmarks. Also, required to work with multiple internal and external clients, such as Asset Management Firms, Rating Agencies and Auditors

●Responsible for creating models that track historical data, profitability and projection of each CLO assets and expected cash flows. The data is used to determine the market value or price of each asset

●Provides statistical data trends to clients in order to meet monthly and quarterly compliance reporting

July 2005 - October 2010

Bank of America(Formerly LaSalle Bank), Chicago, IL

CDO Analyst- Reporting

●Perform daily bank reconciliation of general ledger, internal DDA, Trust house or Trust/Treasury Positions utilizing Recon Plus and Global Plus.

●Monitor exception reporting and assign outstanding items to appropriate departments.Maintain accurate records and establishes strong working relationships with all business lines and accounting groups.

●Responsible for the bank reconciliation design. Ensure the incorporation of data necessary for matching, monitor the automation of data feeds from source systems and verify the integrity of the reconciliation design on the automated system.

●Resolves basic non-standard reconciliations issues, as assigned by supervisor. Reconciling Swift payments to Euroclear accounts

Education

Devry University Keller Graduate School of Management 2009

●Earned Master of Business Administration

Roosevelt University 2005

●Earned Bachelor of Business Administration

Contact this candidate