Edward J Mackey Email & Phone Number

Frankfurt Am Main, Hessen, De

Responsibilities include Repos, Reverse Repos, and Interest Rate futures) and related month end closing adjustments.• Discovered the root cause of approximately $2mm worth of suspense items and proposed the appropriate adjustments.• Located trades where approximately $2.2mm of interest expense was unreported due to interest rates not being input in the Back Office System.•Enhanced production of Balance Sheet report that includes detailed front-to-back comparison.•Uncovered under-booking of trading costs by the front Office and obtained the necessary $1.3mm adjustment.•Streamlined preparation of Quarterly disclosures with enhanced checks built in reducing preparation and analysis time by 50%.•Worked on transition to a new system for comparison of front-to-back office P&L that also included the balance sheet side.

Frankfurt Am Main, Hessen, De

Responsibilities included preparation and analysis of daily Swaps Desk P&L (financial instruments mainly include Interest Rate Swaps, Bonds, Repos, Reverse Repos, and Interest Rate futures) and related month end closing adjustments.•Enhanced analytics of the Swaps P&L, which mainly included flash-to-actual differences and computation of FX translation P&L.•Built additional controls in the P&L reporting file, which enhances the ability to spot and explain subtle flash versus actual differences.•User Acceptance Testing (UAT) on migration to new P&L reporting system. Also, I redesigned the P&L reporting file to make it compatible with the new reporting system.•Development of reporting file for above-mentioned new P&L reporting system, which included transformation of current-year attribution data to a format compatible with new P&L reporting system.•Worked on Reserves reconciliation project and developed system for daily monitoring.•Development and modification of VBA procedures used in automation of desktop procedures most notably those compatible with new reporting system.

Zurich, Ch

Automation of various manual P&L reports.

New York, Ny, Us

Responsibilities include User Acceptance Testing (UAT) on various automation projects as well as automation of desktop procedures.* Perform UAT on new software that automates and optimizes the netting in haircut reports.* Providing guidance in the implementation of a multicurrency General Ledger for Capital Markets.* Built Microsoft Access database to facilitate generation of position difference reports for a portfolio in excess of $1 billion.

Frankfurt Am Main, Hessen, De

Responsibilities included preparation and analysis of daily P&L (for Treasury, Fixed Income, Equity Derivatives and Equity Sales desks), month-end tasks such as preparation and analysis of the monthly funding charges from the Treasury desk to the other businesses, closing entries, and reconciliation of P&L flashed to the Trading Desks to the General Ledger.Financial products include Loans, Repos, Commercial Paper, CD’s, Deposits, Interest rate and variance swaps, futures and options.* Automated daily P&L preparation for the Treasury desk through Visual Basic macros, which freed up significant time for analysis. * Trained and supervised one person on preparation of Treasury P&L.* Created a new monthly front-to-back office P&L by-trade reconciliation process for the Treasury desk.* Developed additional controls and new tools for investigation of flash-to-actual P&L differences for the Equity Sales desk.* Implemented Excel spreadsheet model to verify valuations for a system migration involving thousands of positions.* Wrote test scripts for UAT testing* Enhanced various Excel spreadsheets that make additional analytic data readily available.

Responsibilities included financial planning and analysis activities such as computation of monthly funding charges to the business units, monthly preparation and analysis of Corporate Treasury's debt, swap, and FX P&L, as well as short-term and annual forecasting * Built Microsoft Access databases for calculation of funding charges to the businesses, variance analyses, and planning and forecasting.Accomplishments* Enhanced Excel spreadsheet model for computation of monthly funding rates for over 50 currencies that are charged to business units.* Played a key role in the development of market rate and capital projection methodology for various financial projections.* Trained and supervised one person on collection of data for capital projections.

Responsibilities included preparation of daily trading desk P&L for fixed income desk (Products included loans, futures and interest rate swaps), preparation of daily and monthly general ledger reconciliations for multiple departments.Accomplishments:* Automated preparation of daily fixed income P&L through use of Visual Basic, which reduced preparation time by 75%.* Wrote Visual Basic Macros that automated P&L preparation by Product Controllers for various desks.

New York, Ny, Us

Responsibilities included performance of End of Day closing for the Equity Linked Securities department, which included troubleshooting of flash P&L reports, review and summarization of daily trading activity and recording same in general ledger (Products included equities and derivatives such as options, equity and cross-currency swaps as well as Commercial Paper, and Equity-Linked securities.), Reviewed and prepared weekly and monthly valuations of trading assets, which consisted mainly of the products mentioned aboveAccomplishments:* Automated entry of daily trading activity into general ledger by writing Visual Basic procedures.

Worked on ad-hoc projects such as development of policies and procedures for the accounting and processing of equity derivatives multi-currency investment operations, Documentation and review of back office policies and procedures relating to credit derivatives operations with the objective of identifying weaknesses and recommending remedies, and Review of appropriateness of capital requirements on swap deals to ensure accuracy of reserves Products consisted mainly of loans and total return swaps.