Yan Dubin Email & Phone Number

9350 South Dixie Highway

• Manage data integration projects between third party data providers and AltaReturn Fund Accounting platform. • Support implementations of AltaReturn Fund Accounting. • Gather requirements for custom reports.• Client base includes PE firms and Family Office.

Miami/Fort Lauderdale Area

• Fund / Partnership Accounting services for Private Equity, Hedge Funds, and Family Offices• Management company financial books & records • FIT's Investran, PeopleSoft software onboarding / implementation consulting • Calculation and Automation of investment performance reporting • Custom report building

Miami/Fort Lauderdale Area

I support leaders in Finance and Accounting Profession on their career journey. Leadership Development and CoachingCareer Transition Coaching

Miami, Florida

• Manage data integration projects between third party data providers and AltaReturn Fund Accounting platform.• Support implementations of AltaReturn Fund Accounting.• Gather requirements for custom reports. • Client base includes PE firms and Family Office.

Greater New York City Area

• Manage onboarding/conversion of private equity funds’ data into Investran by creating the conversion plan, reviewing partnership agreements to establish investor/investment structure, coordinating resources to meet timely deliverables and communication with stakeholders on status • Conduct hands-on data conversion by collecting, mapping and processing historical accounting data for automated conversion using upload templates, importing partner level allocations, user defined fields, static data and demographics. Set up reconciliation files to validate against original data• Establish and maintain standard financial reports including Partner’s Capital Statement, Schedule of Investments and Roll-forwards. Design and create internal and client facing reports using OLEDB and Crystal Reporting.• Facilitate ongoing Investran support for accounting teams including educating on the best practices, troubleshooting, supporting data entry/upload, ad-hoc reporting and general questions

Greater New York City Area

• Maintained books and records for a $1 billion private equity fund including monthly journal entries, marking NAV values, allocating income and expenses and reporting to partners• Handled accounting and reporting of a $3 billion hedge fund consisting of separately managed accounts and hedge fund managers. Tracked index swaps and currency forwards• Analyzed and reported on direct investments in media, banking and commodity companies including quarterly valuation analysis and due diligence review• Handled all accounting and reporting for internal partners fund• Compiled monthly estimated performance analysis for the investment committee• Tracked cash flows for capital calls, distributions and withdrawals and maintained outstanding commitments to external managers• Handled all operational aspects of ETF and Swap trades initiated by investment team• Established automated procedures and processes to facilitate a more efficient and timely month end process resulting in a 50% increase in workload while maintaining timely deliverables • Automated capital account statements for upper management using OLEDB and Investran data management tools resulting in a seamless reporting• Led the project to calculate performance returns from Investran database resulting in the ability to track percentage returns as well as dollar returns on a deal by deal basis

Greater New York City Area

• Ran the conversion of accounting books and records from Excel to SunGard’s Investran system. The conversion process included conceptual design, hardware/software design and implementation, data entry and reconciliation, and reporting. • Assisted with quarter-end close process including calculations p&l and expense allocations for partners, capital call processing, commitment reconciliations, journal entries, valuations of portfolio holdings • Worked closely with outside legal counsel on compliance and regulatory issues

Greater New York City Area

•Created financial models, including Discounted Cash Flow, NPV and IRR calculations to assess investment opportunities •Conducted due diligence on potential investments including review of legal documents and loan agreements and operational procedures •Screened investment opportunities and perform preliminary valuation and analysis

Greater New York City Area

•Compiled weekly Profit & Loss analysis for a $13 billion portfolio•Prepared monthly risk adjusted valuation of portfolio assets for capital allocation •Participated in the ongoing process to streamline the risk reporting platform for capital budgeting purposes•Streamlined the month-end close process, reducing the completion time by 1 week•Participated in successful conversion to JD Edwards general ledger system without any interruptions to accounting operations•Maintained books and records for a Helicopter company. Lead the conversion of financial data from QuickBooks to the new general ledger accounting system•Produced monthly personal statements of net worth to managing directors•Maintained budget analysis and forecasting for the management company•Supervised accounts payable functions

Coach Training

Career/Life Coaching Executive Coaching Leadership Development

Master Of Business Administration (M.B.A.), Finance, General

Bachelor Of Business Administration (Bba), Accounting

Education record