Full strategic finance support
Recent Bridge Square Projects:
Market Sizing Dashboard (Tableau):
Health insurance services market size quantified in dynamic dashboard.
Delivered Tableau dashboard to highlight addressable market size of managed care organizations in Medicare Advantage, Medicaid, Marketplace and Commercial
Leveraged enrollment data, quality measure eligibility estimates and internal pricing targets
Year-End Performance Metrics Report (Excel):
Key performance metrics organized and presented for SaaS-based company
Refreshed key-performance indicators at client-level with 2020 results.
Medicare Advantage Quality Bonus Market Analysis (Excel / Tableau):
Financial incentives for quality quantified for all Medicare Advantage plans
Prepared analysis outlining financial opportunity for each Medicare Advantage contract based on CMS quality incentive structures.
Supporting sales team identification of potential customers.
Projects in Previous Roles:
Annual Budget for Multi-site Startup (Google Sheets / Google Data Studio / MS PowerPoint):
Dynamic model included market sizing, LTV/CAC targets in 3-year forecast.
Designed multi-site budgeting model to support financial forecasts for telehealth provider operations
Assumptions and inputs dynamically adjusted for scenarios and produced financial statements.
Synced budget to Google Data Studio to share Key Performance Indicators cross-functionally
Prepared and led budget presentation for board of directors
Monte Carlo ROI Simulator ( Excel / SQL / Tableau / Python ):
Partnered with actuarial consultants to build client-facing ROI model for sale and marketing team to leverage.
Accounting System Transition (NetSuite):
Transition to scalable accounting solution for growing organization
Selection of accounting software to scale with organizational needs
Development of chart of accounts
Initial documentation of revenue recognition policies - direct to consumer SaaS, enterprise arrangements, grants and insurance claims.
Templates:
coming soon