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.
Recapitalized a $48 million multifamily project in Florida after a $7 million construction budget overrun.
Found a solution for a $15 million cash-out refinance on a multifamily property in Arizona that allowed the owner to lock in a long-term fixed-rate and have two liquidity events to meet both short-term needs and capitalize on fast-growing rental rates.
Built Power BI data model that created automated proforma for multifamily projects in 200+ US cities.
Built a multivariable regression model to predict rents for multifamily properties across ten US cities in the Sunbelt, leading to an acquisition of a $30 million project in Florida.
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, providing financial analysis, and documenting accounting operations for the bookkeeper.
Assisted serial entrepreneur in performing due diligence on purchasing a startup eCommerce business. Discrepancies identified in the review of financial records led to further investigation uncovering the past criminal history of the seller.
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 three million dollars 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: Commercial Real Estate, Big Data, Financial Modeling, Microsoft Power BI, Cryptocurrency, CFO, Due Diligence, Data Analysis, Valuation, Corporate Finance, Finance, Real Estate
Business Analyst Manager
2020 - 2021
Managed a business optimization and data quality team split between the Cayman Islands, Delaware, and Chennai, India, covering over 25,000 client entities domiciled in five countries across the US.
Designed automated solutions for collecting data from clients and reporting regulatory information to appropriate jurisdictions.
Built new analytical tools for business users and other support groups using Microsoft Power BI.
Focus areas: Financial Services, Big Data, Project Management, Data Analytics, Business Intelligence (BI), Data Governance, Data Migration, Business Operations, Business Analysis
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 Services, Financial Modeling, Credit Risk, Credit Collection, Process Automation, BI Reporting, Financial Planning & Analysis (FP&A)
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.
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.