Freelance
- 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.
- Developed financial models for a startup using partial equity ownership as an alternative to foreclosure for mortgages.
- Served as the interim CFO, establishing 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.
- Created a dynamic cryptocurrency index tracking a large universe of assets for a hedge fund specializing in digital assets using Power BI.
- Assisted a serial entrepreneur in performing due diligence on purchasing a startup eCommerce business. Discrepancies identified in the review of the financial records led to further investigation uncovering the past criminal history of the seller.
- Developed 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.
- Advised BB&T, Community One, and Life Store Bank on the completion and 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 the Northwest Regional Housing Authority and implemented a new cloud-based system to track 1,800+ Section eight rental units.
- Provided advice to a private equity portfolio company on mortgage alternatives to the sale and lease-back of a behavioral health facility.
Focus areas: Commercial Real Estate, Big Data, Financial Modeling, Microsoft Power BI, Cryptocurrency, CFO, Due Diligence, Data Analysis, Valuation, Finance, Real Estate, Statistics, Statistical Analysis
Director of Finance and Analytics
2022 - 2022
The Wildcat Group
- 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 provide liquidity for other projects.
- Reviewed financials prepared by the controller and produced monthly reports for lenders and investors.
- Built a Power BI data model that created automated proforma for multifamily projects in 200+ US cities.
Focus areas: Financial Modeling, Accounting, Analytics, Regression Modeling, Project Finance, Fundraising, Statistics
Business Analyst Manager
2020 - 2021
Intertrust Group
- 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
Finance Analyst
2018 - 2020
Intertrust
- 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)
External Contractor
2018 - 2018
Deutsche Bank
- 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: Financial Services, Structured Finance Documentation, Data Analysis, Distressed/Special Situations
Assistant Vice President - Legal Entity Accounting and Reporting
2016 - 2017
Credit Suisse
- 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.
Focus areas: Commercial Real Estate, Financial Services, CFO, Accounting, Financial Regulations, Analysis of Variance (ANOVA), Controller, Financial Reporting
Assistant Vice President - Product Control
2016 - 2016
Credit Suisse
- Supervised daily P&L reconciliations for 100+ bankers and traders covering private label MBS issuance, mortgage trading, and derivatives hedging with annual revenue of $1+ billion.
- Centralized the daily/monthly revenue reconciliations of commercial and residential mortgages previously performed by three separate teams.
- Oversaw the migration of $10+ billion in revolving credit facilities from Credit Suisse USA to Cayman Islands Branch.
- Identified solutions for reporting 50+ loan-level attributes on mortgages, which is required by the Federal Reserve under a new Intermediate Holding Company structure.
Focus areas: Commercial Real Estate, Financial Services, Commercial Mortgage-backed Securities (CMBS), Project Finance, Asset-backed Securities (ABS), Financial Reporting, Profit & Loss (P&L)
Senior Product Controller
2013 - 2015
Credit Suisse
- Established standard procedures for daily and monthly reconciliations of the relaunch of a commercial mortgage business, originating $10+ billion in loans in two years.
- Designed reports for commercial real estate team to analyze deal-level P&L, balance sheet utilization, derivatives hedging, funding costs, and profit-sharing agreements.
- Reviewed mortgage warehousing master repurchase agreements for revenue recognition under U.S. GAAP and trading/banking book capital treatment.
- Maintained commitment receivables and fee amortization schedule on 50+ mortgage warehouse facilities.
- Performed daily front and back-office reconciliation of trade breaks, inventory, and P&L for desks trading asset-backed securities, derivatives, futures, and mortgages.
Focus areas: Commercial Real Estate, Financial Services, Asset-backed Securities (ABS), Project Finance, Finance, Real Estate, Commercial Mortgage-backed Securities (CMBS), Financial Reporting, Profit & Loss (P&L)
Barr Development
- Planned, designed, and managed the development of five luxury home communities between 15-65 acres in size.
- Built cash flow models, P&L forecasts, and market absorption studies to analyze dozens of potential projects.
- Created business plans and presentations used to raise over $5 million in capital.
- Produced reports for limited partners, summarizing their investments, analyzing current market conditions, and projecting future sales.
- Maintained financial records, prepared operational budgets, and performed bookkeeping activities including paying vendors and reconciling bank statements using QuickBooks.
- Created geospatial models using SQL and ArcGIS to identify properties suitable for development in a 4-county area based on location, topography, and MLS sales data.
- Oversaw marketing efforts including online marketing and direct mail campaigns, hiring an ad agency and maintaining relationships with local realtors.
Focus areas: Statistical Analysis, Big Data, Financial Modeling, Project Management, CFO, Business Planning, Fundraising, Cash Flow Modeling, Market Research, Financial Planning & Analysis (FP&A), Revenue & Expense Projections, Cash Flow Forecasting, Investment Decision-making, Construction, Real Estate, Statistics
Research Analyst
2004 - 2005
Buxton
- Built multivariate regression models to predict store sales for Pizza Hut, FedEx Office, Restoration Hardware, 99 Cents Only, A.C. Moore, and GameStop.
- Prepared research reports for retailers, economic development corporations, and commercial developers to predict performance of retail locations nationwide.
- Created model using SQL and ArcGIS to measure the urbanization of every Zip+4 postal code in the U.S. using statistical analysis of household and business densities.
- Developed AutoID product to identify potential opportunities for car dealerships based on a leakage analysis of new car sales.
Focus areas: Statistical Analysis, Big Data, Market Opportunity Analysis, Market Research, Finance, Real Estate, Revenue Modeling, Statistics