Skills
Microsoft Excel, including developing macros by writing visual basic
Microsoft Access, creating and maintaining tables, queries, forms, reports and macros
Microsoft Word
Advent Axys, Advent Geneva, Sungard InvestOne, Sungard InvesTier and Koger NTAS
Regulatory compliance policy and procedure creation and monitoring
Deconstructing and reconstructing trial balances and shareholder allocation reports
GAAP Accounting, multiple types of performance calculations and investor allocations
Local IT infrastructure maintenance and support
Major Project Accomplishments
Designed, created and implemented a daily reconciliation process to confirm holdings, transactions and values between the companies books and records versus multiple counterparties which was used for over a hundred funds daily across multiple countries including the United States, Ireland and Singapore
Designed, created and implemented a daily reconciliation process to track cash movements, create workbooks, update workbooks for fundings and payments, track potential issues and create a hedge analysis to track exposure variances
Onboarded clients, both domestically and internationally, including deconstructing previous administrators’ books and records and converting them into the company’s accounting and investor allocation systems for equities, options, fixed income, credit default swaps and bank debt
