Dan led a team of controllers responsible for $185+ billion in assets at Credit Suisse and previously managed the acquisition/development of luxury home communities. He is passionate about helping small and mid-size businesses access the same tools employed by large corporations. Utilizing his financial knowledge and coding experience he has helped companies build financial models, automate processes, and bridge the gap between finance and IT.
Managed a business optimization and data quality team split between the Cayman Islands and a Center of Excellence in India covering over 25,000 client entities domiciled in 5 countries across the Americas.
Designed automated solutions for collecting data from clients and reporting regulatory information to appropriate jurisdictions.
Built new analytical tools using Power BI for business users and other support groups.
Focus areas: Business Operations, Data Migrations, Data Governance, Business Intelligence, Data Analytics
2011 - PRESENT
Created a dynamic cryptocurrency index tracking a large universe of assets for a hedge fund specializing in digital assets using Power BI.
Served as the interim CFO and established financial procedures for a new real estate fund prior to launch including setting up a chart of accounts in QuickBooks, creating framework for financial analysis of results, and documenting necessary accounting entries for bookkeeper.
Assisted serial entrepreneur in performing due diligence on the purchase of startup e-commerce business. An audit of the company’s financial records showed significant discrepancies, and further investigation revealed the seller was previously convicted on multiple financial crimes. As a result, the entrepreneur was able to avoid a potentially disastrous investment.
Created courses on derivatives and financial statement analysis for Smartly MBA. Also provided the final review for dozens of courses covering stocks, bonds, valuation techniques, investment decision making, and capital budgeting.
Worked with Broadsword Investors, LLC on strategies to identify commercial real estate investment opportunities in the Southeast and Mid-Atlantic regions, yielding potential targets in six states.
Advised BB&T, Community One, and Life Store Bank on the completion/rehabilitation of foreclosed commercial and residential projects, leading to the recovery of over $3 million after the housing crisis.
Conducted a survey of rental rates across seven county areas for Northwest Regional Housing Authority and implemented a new cloud-based system to track 1,800+ Section 8 rental units.
Focus areas: Real Estate Finance, Corporate Finance, Valuation, Data Analysis, Due Diligence, CFO, Cryptocurrency, Microsoft Power BI
2018 - 2020
Built automated model using SQL and Power BI to evaluate outstanding client receivables for the provisioning process, forecast future write-offs, and provide targets for collection efforts based on probability of success.
Created automated bottom-up revenue forecast for 50+ service offerings across 17,000 client entities used in quarterly forecasts and 3-year budget.
Leveraged SQL, Power BI, and VBA to create an automated process for producing and distributing individually-customized, daily MIS reports for the regional head, managing directors, and 60+ relationship managers.
Established monthly process for reviewing receivables, collating outstanding bills, and delivering email reminders via VBA macros to thousands of clients leading to a 15% increase in cash collections year-over-year.
Focus areas: Financial Planning & Analysis (FP&A), BI Reporting, Process Automation, Credit Collection, Credit Risk
2018 - 2018
Engaged by Deutsche Bank to manage the novation and termination process for its Corporate Services business in the Cayman Islands.
Built an Excel-based system using Power Query that centralized data on various workstreams. The system allowed users to continue using their existing processes uninterrupted while enabling local management and a central project team in London to have real-time data on the current progress on approximately 500 deals.
Created over 40 templates in Word to leverage centralized data in the automated production of novation and termination documents. As a result, 1,500+ documents were produced and executed in a 45-day period resulting in a completion rate 3x greater than the next closest office.
Focus areas: Specialty Finance, Data Analysis, Structured Finance Documentation
Assistant Vice President - Legal Entity Accounting and Reporting
2016 - 2017
Supervised team of legal entity controllers for U.S. broker-dealers as well as mortgage and derivative entities with $185+ billion in total assets.
Provided monthly/quarterly commentary and variance analysis of balance sheet movements and P&L drivers used for investor reporting and business planning.
Served as IB Americas Subject Matter Expert on Securities and Prime Brokerage, providing training and expertise on securities and institutional trading to employees within the CFO division.
Led working group to automate the processing of servicer remits for over 40,000 distressed residential mortgages in order to correctly account for $100+ million in annual expenses.
Coordinated with teams across six countries to appropriately resolve consolidation breaks between 20+ global affiliates before the close.
Prepared regulatory reports and answered questions from regulators for derivatives and mortgage entities.
Reviewed approximately 150,000 open and failed security trades each month to ensure compliance with US GAAP.
Traditional approaches to valuing real estate can lean towards the qualitative side, relying more on intuition over sound rationale. Linear regression analysis, however, can offer a robust model for using past transactions in an area, to provide better guidance on property valuations.