Private Equity · M&A · Investment Analysis

Building at the intersection of finance & intelligence.

A finance professional on the private equity and M&A track — I build the AI tools that source, score, and pressure-test deals.

130+
PE investments screened — Transal
Multi-$B
PE portfolio overseen — Transal
$50M+
Annual M&A pipeline tracked — Walgreens
80%
of SOX testing cut by an AI pipeline I built — Walgreens
Portrait of Joseph McDevitt, finance professional and AI builder.

About

A finance mind with a builder's edge.

I'm a finance professional focused on private equity, M&A, and investment analysis — with hands-on experience overseeing a multi-billion-dollar PE portfolio and building M&A deal infrastructure. My edge: I build the AI tools that source, score, and pressure-test deals, moving from raw data to an investment decision faster than a traditional analyst. University of Miami, cum laude.

Private Equity M&A AI Systems Financial Modeling Deal Origination

Deal Work

How I think about a deal.

A sample investment memo — the same sourcing engine from my projects, turned into a thesis, a valuation, and a recommendation.

Investment Memo · IllustrativePublic NCPA / CMS data + proprietary screening

Independent Pharmacy Roll-Up — Acquisition Thesis

Buy-and-build consolidation of independent community pharmacies, sourced via a proprietary AI screening engine I built.

Recommendation

Pursue a buy-and-build roll-up of independent community pharmacies — using proprietary AI screening to acquire owner-operated stores off-market at low-single-digit EBITDA multiples, integrate them onto a shared purchasing and clinical platform, and exit a scaled regional operator at a higher multiple. A focused ~25–35-store platform is achievable in 4–5 years; the edge is proprietary deal flow, not capital. Illustrative base case: ~3.0× MOIC / ~28% IRR.

Market Opportunity

~19,000 independent community pharmacies (NCPA 2025) generate ~$103B in annual revenue — a fragmented, owner-operated market consolidating at more than one closure a day. Owners are operators, not financial sellers, so processes are uncompetitive and pricing is negotiable. Fragmentation plus a retirement wave is the classic roll-up setup.

The Sourcing Edge

My platform scores a ~65k-record universe of non-chain pharmacies on a 6-factor model. I rejected normalization methods that inflated the target list to 25k–50k stores and kept a deliberately conservative score — isolating just 820 high-conviction targets, with the top 100 holding 83–85% stable under ±10% stress. The discipline is the moat: a short, vetted, off-market pipeline.

Target Profile

The 820 targets share a clear signature versus the field: 86% show stale licensing records (a retirement / disengagement proxy), sit in far less competitive markets (2.6 vs 14.9 pharmacies per 10k residents), and serve higher-income ZIPs ($98k vs $66k median). Profitable, defensible stores whose owners are most likely to sell.

Valuation Framework

Two cross-checks: a file buy at ~$3–5 per annual script (defensible off-market; chains pay $5–12+ in competitive deals), or a whole-business buy at ~2.5–4.0× EBITDA plus inventory. Independents run ~22% gross margin (NCPA), so we underwrite thin entry margins with room to expand. Base entry: blended ~3.5× EBITDA.

Illustrative Returns

ScenarioStoresEBITDA %ExitMOICIRR
Downside255%7.0×~2.0×~17%
Base306%7.5×~3.0×~28%
Upside356.5%8.0×~4.0×~38%

Return driver: multiple arbitrage (buy ~3.5×, exit ~7–8× as a scaled platform) plus margin expansion. Pace check — 820 scored targets × ~6% win rate ≈ 49 reachable; a 30-store build implies a disciplined, not heroic, close rate.

Value-Creation Plan

  • Purchasing scale — GPO / wholesaler improvements on a ~78% COGS base (~+150 bps)
  • Reimbursement discipline — centralized PBM contracts and DIR-fee management (~+100 bps)
  • Central fill & shared back office — ~$50–80k saved per store
  • Net target — lift entry EBITDA from ~4% toward ~6% of revenue (+200–300 bps vs standalone)

Key Risks & Mitigants

  • PBM & DIR pressure (CMS 2024 reforms; state PBM-delinking laws) → diversify into cash-pay clinical services
  • Generic deflation → purchasing scale plus a richer service mix
  • Amazon / mail-order → focus on high-touch local and rural markets
  • 340B is upside only, not core EBITDA — given the 2024 appellate ruling on manufacturer restrictions and HRSA's 2026 rebate-model pilot
  • Integration & pharmacist retention → earnouts, retention packages, phased onboarding (base case assumes modest post-close attrition)

Assumptions & Limitations

Illustrative case study — not a live deal or a forecast. Market context from the NCPA 2024–2025 Digest, CMS, and Drug Channels; valuation and return assumptions reflect 2024–2026 comparables and are clearly bounded. Target counts and screening signals are outputs of my proprietary, un-audited model. Returns are scenario estimates, highly sensitive to store count, margin capture, and exit multiple.

Selected Work

Tools built where capital meets code.

Four production platforms I built to do deal work better — pharmacy M&A, multi-vertical deal origination, SMB tax intelligence, and family-office portfolio monitoring. Proof of the edge, not the day job.

Fig. 01 — Acquisition Targeting DashboardLive Platform
01
Live Platform

Pharmacy M&A Intelligence Platform

A full-stack acquisition targeting platform that ingests 112,000+ U.S. pharmacy records from the CMS NPI registry, enriches with Medicare Part D claims and Census demographics, classifies chain vs. independent, scores acquisition readiness using a 6-factor weighted model, and tracks deals through an 8-stage pipeline.

The Problem

Pharmacy acquisition teams manually sift through fragmented public databases to find independent targets. No centralized tool combines provider registry data, prescription volume, Medicare/340B designation, demographics, and competitive density into a single scoring system.

The Solution

An automated pipeline that downloads the full NPPES registry (~700MB, 10GB+ expanded), filters across 12 pharmacy taxonomy codes, classifies 112,000+ pharmacies as chain vs. independent, enriches with Medicare Part D claims and ZIP-level Census demographics, applies a weighted acquisition score, surfaces closing signals and retirement-risk probabilities, and delivers a filterable dashboard with a built-in deal tracker.

How It Works

i.

NPI Registry Ingestion

Downloads/processes full CMS NPPES registry — 112,000+ pharmacies across all 50 states/territories. httpx streaming 1MB chunks; pandas chunksize=100k; 12 pharmacy taxonomy codes; normalization + MD5 dedup; coverage 64 states/territories.

ii.

Chain Classification Engine

Identifies chains/independents/institutional via pattern matching + multi-location clustering (10+ addresses = chain). Result: 65,279 independents (58%), 47,258 chains (42%), 3,890 institutional.

iii.

Medicare & 340B Enrichment

Part D claims (total claims, unique beneficiaries, drug cost) + 340B eligibility signals — key for file value and acquisition pricing.

iv.

Census Demographic Scoring

ZIP-level enrichment (99.8% coverage) — % age 65+, median household income, population growth, competition density. File value estimate: Rx volume × $4/script — a standard prescription-file valuation cross-check, applied per store as a relative ranking signal.

v.

6-Factor Acquisition Score

Composite 0–100 — Rx Volume (30%), Competition (20%), Aging Population (20%), Retirement Risk (15%), Income (8%), Pop Growth (7%). Range 9.69–87.48, avg 44.41 across 112,537 pharmacies.

vi.

Closing Signals & Probability

Long-tenured (20+ yrs) 3,435 pharmacies; stale NPI records (3+ yrs) 71,986; nearby deactivations; change detection with full audit trail.

Highlights

  • 112,000+ pharmacies ingested, classified, and scored across all 50 states
  • Multi-source enrichment (CMS NPI, Medicare Part D, 340B, U.S. Census)
  • 6-factor weighted score with retirement-risk probability
  • Change detection with field-level deltas
  • 8-stage deal pipeline tracker with CSV export
  • Dockerized full-stack (FastAPI, React, PostgreSQL)

Technology

PythonFastAPIReactPostgreSQLDockerSQLAlchemyTailwind CSSLeaflet MapsPandasCMS / NPI DataMedicare Part DU.S. Census API

Experience

A track record across the deal lifecycle.

From algorithmic trading to multi-billion-dollar private equity oversight to enterprise M&A intelligence.

Jan 2026 – PresentChicago, IL

Financial Rotational Analyst

Walgreens
  • Designed and built the M&A deal tracking dashboard underpinning $50M+ in annual capital deployment, giving leadership a live unified view of target pipelines, deal economics, and progress against strategy.
  • Leading an AI automation initiative projected to replace 80% of offshore SOX controls testing, reclaiming thousands of tester hours annually.
  • Shipped an executive analytics platform consolidating audit risk, coverage gaps, and resource allocation across business units; adopted by senior leadership within weeks.
  • Deployed AI-driven risk analytics surfacing emerging threat patterns in real time for the audit committee.
  • Partnered with C-suite to transform a quarterly static report into a live executive command center.
M&A IntelligenceDashboard DevelopmentAI AnalyticsExecutive ReportingProcess Automation
Aug 2025 – Dec 2025Miami, FL

Analyst

Transal Corp
  • Reviewed 130+ active PE investments and screened hundreds of new opportunities within a multi-billion-dollar portfolio.
  • Modeled capital call pacing vs distribution flows in Excel to enhance liquidity forecasting.
  • Used Addepar and advanced Excel modeling for portfolio oversight, co-investment evaluation, and risk management.
  • Built dynamic IRR and MOIC models simulating long-term index exposure.
Private EquityPortfolio AnalysisFinancial Modeling
Jun 2025 – Aug 2025Chicago, IL

Specialty Pharmacy Finance Intern

Walgreens
  • Built a Power BI dashboard from millions of quarterly data points to visualize per-script drug profitability.
  • Delivered ad hoc drug-level financial insights to therapy directors and field leadership.
  • Developed a dietary supplement vending machine concept using DCF modeling and private credit financing.
Power BIData AnalyticsDCF Modeling
May 2024 – Oct 2024Miami, FL

Equity Analyst Intern

Maredin Wealth Advisors
  • Researched equities to support an independent RIA and contributed to enhanced portfolio returns.
  • Developed a full investment rationale for Snowflake Inc.
Equity ResearchInvestment Analysis
Jul 2023 – Feb 2024Chicago, IL

Algorithmic Trader

Core Value Capital LLC
  • Conducted research and backtesting to identify new currency pairs for a proprietary trading algorithm.
  • Applied calculus-based principles across 13 currency pairs.
  • Optimized capital allocation and leverage thresholds, removing 15% of pairs to mitigate risk.
Algorithmic TradingQuantitative AnalysisRisk Management

Skills & Credentials

The toolkit behind the work.

01

Financial Modeling

  • LBO Modeling
  • DCF Analysis
  • M&A Modeling
  • Comparable Analysis
  • Precedent Transactions
  • Three Statement Models
  • IRR / MOIC Analysis
  • Capital Call Pacing
  • Mathematical Modeling
02

Technical Skills

  • Microsoft Excel (Expert)
  • VBA Macro Development
  • Power BI
  • SQL
  • Python
  • Addepar
  • Bloomberg Terminal
03

AI & Automation

  • ChatGPT / GPT-4
  • Claude AI
  • OpenAI API
  • GitHub Copilot
  • Microsoft Copilot
  • Cursor AI
  • AI-Assisted Financial Analysis
  • Prompt Engineering
  • LLM Workflow Automation
  • AI Data Extraction & NLP
  • RAG Pipelines
  • AI-Powered Dashboard Development

Education

University of Miami

Herbert Business School — B.S. Finance & Mathematics — Cum Laude

Provost's Honor RollDean's List

Certification

Wall Street Prep (WSP)

Financial Modeling Certification

LBODCFM&ACompsPrecedentsThree StatementExcel VBA

What Drives Me

Three convictions, one direction.

01

Artificial Intelligence

AI will fundamentally reshape finance — from deal sourcing and due diligence to portfolio construction and risk management. Actively building tools and workflows that put AI at the center of the investment process.

02

Buying Companies

Finding an undervalued business, structuring a deal, and creating value through operational improvement and strategic growth. M&A and acquisitions are where I want to build my career.

03

Private Markets

The real alpha is in private markets. From PE and VC to private credit and co-investments — drawn to the complexity and outsized returns of illiquid strategies.

Contact

Let's connect.

I'm always interested in discussing deals, AI applications in finance, or new opportunities.