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.
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.
Leveraged SQL, Power BI, and VBA created 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.
Created reconciliation of government and internal databases to identify missed regulatory filings prior to the assessment of penalties saving tens of thousands of dollars annually.
Focus areas: Financial Planning & Analysis (FP&A), BI Reporting, Process Automation, Credit Collection, Credit Risk
2011 - PRESENT
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
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.