Your plan cost went up 7% because of utilization.

Your plan cost went up 7% because of three specialty drugs and eleven claimants.

The first line is what the vendor's report said. The second is what the same data says when it's yours.

Your carrier, your PBM and your leave vendor each report their own version of the truth. We build the warehouse, the leave & absence platform and the reporting that put all of it in your own cloud, so the numbers are yours. Led by the engineer behind a Fortune 500 employer's health analytics program.

Book a 30-minute call Read a case story Fixed quotes before work begins. We work under a Business Associate Agreement, inside your environment, with identifiers masked before analytics.

25 yearsof data engineering, from Medicaid reporting to Fortune 500 health analytics

20+ vendorsof claims and benefits data unified in one warehouse

2 platformsbuilt for leave & absence, reconciled to 100% status matching

What we buildfor HR, benefits and finance

One hub, four things inside it, each with a screen you can picture your own numbers in.

The screens below are illustrations with made-up figures, modeled on systems we have built for a self-insured plan with tens of thousands of members. Your version runs on your data, in your account.

Health Intelligence Hub Illustrative

WorkspacesOverviewPlan costPharmacyLeave & absenceWellness escalationsVendor ROIAsk the assistantMonthly reports

Plan year to date, as of March

Medical spendPMPM vs budget$486 · +6.8%

Pharmacy spendSpecialty share$126 · 54%

People on leave todayAll business units412

Open escalationsMedian first contact62 · 1.8 days

High-cost claimantsMembers over $100k1.1% · 38% of spend

Reports this monthGenerated, no manual steps7 delivered

Illustrative data. One sign-in, every workspace reads the same warehouse.

Claims data warehouse and cost-driver analytics

Medical, pharmacy, eligibility and wellness feeds from every vendor, matched with Datavant tokenization so no vendor needs another's identifiers, and modeled into one warehouse that answers the first question every CFO asks: what is driving the increase.

Good fitSelf-insured, 2,000+ members, more than one carrier or PBMFirst releaseSix weeks: warehouse plus the cost-driver viewStackYour AWS or Azure account, Redshift or Snowflake, Airflow, Tableau or Power BI

Quoted after scoping

Plan cost drivers Rolling 12 months, illustrative

PMPM total$612+7.4% YoY

High-cost claimants1.1%38% of spend

Avoidable ED visits14%of all ED visits

Generic fill rate88%+2 pts

Specialty Rx+$1.9M

Musculoskeletal+$1.4M

Oncology+$1.1M

Cardiology+$0.8M

Maternity+$0.4M

Illustrative data. Members tokenized; no PHI shown.

Leave & absence platform

One view of every leave, short-term disability, workers' compensation case, transitional duty assignment and return-to-work plan, reconciled across your carrier's exports and your HR system. Case coordinators work from it daily; leadership gets the KPI view with month and year-to-date in one table.

Good fitSedgwick, Lincoln, MetLife or similar carrier feeds; HR in Workday, SAP or OracleFirst releaseSix weeks: claims view and KPI dashboardProven onThe leave platform of a Fortune 500 employer, 100% status matching across systems

Quoted after scoping

Leave & Absence KPIs March, all business units, illustrative

Avg daily absent412+3.1% vs Feb

Entering leave YTD1,284distinct employees

Returned to work1,097YTD

Avg days out, WC41ODG target 34

Beginning openNewReopenedClosedEnding open

Claim type	Mar	YTD	vs ODG
Workers' comp	96	287	+7 days
Short-term disability	141	402	On target
Transitional duty	38	119	On target

Illustrative data. Waterfall: beginning open, new, reopened, closed, ending open.

Specialist outreach platform

For the people who call employees during a leave. An outreach app that tells each specialist who to contact today, at which touch point, with the claim history on one screen. Surveys sent at the right moment and tied back to the claim and the touch point, so a leader view can show response rates, return-to-work outcomes and the ROI of the program by business unit.

Good fitA leave team with specialists or coordinators doing proactive outreach, and a leader who has to prove it worksFirst releaseSix weeks: specialist queue and touch-point tracking; leader view followsProven onA Fortune 500 employer's leave team, launched with one specialist group and extended to a second with its own claim view plus the full population

Quoted after scoping

Today's outreach, my team Illustrative

Due today23touch points

Completed this week11894% on time

Survey responses61%after touch point 1b

RTW within ODG72%target 80%

Employee	Claim	Touch point	Due	Specialist	Status
EE 31•••7	STD, day 3	1a Welcome call	Today	M. Ortega	Due
EE 58•••2	WC, day 14	1b Check-in + survey	Today	M. Ortega	Due
EE 09•••5	STD, day 30	2 RTW planning	Tomorrow	K. Patel	Scheduled
EE 77•••0	WC, day 45	3 TD offer	Mar 29	K. Patel	Done
EE 42•••3	FMLA, day 7	1a Welcome call	Mar 27	J. Lee	Done

Illustrative data. Employee IDs masked; specialist names invented.

AI assistant and automated executive reporting

A monthly report that writes itself from the warehouse, with charts and a plain-English summary leadership actually reads. And an assistant analysts can ask questions of, grounded in the same numbers so it never invents one. Identifiers are masked before any text reaches a model.

Good fitA team that rebuilds the same deck every month, or leaders who ask the same five questionsFirst releaseThree weeks for a report; six for an assistantStackAWS Bedrock or the Claude API, inside your account

Reports from $2,000, assistants quoted

Analyst assistant Illustrative

Which business units drove the STD increase in Q1?

Three units account for 71% of the increase: Field Operations (+48 cases), Customer Service (+31) and Contact Center (+19). Musculoskeletal diagnoses rose in all three; mental health rose only in the Contact Center.Sources: t_kpi_claims_monthly, v_std_diagnosis_group (Jan to Mar). Names masked.

Wellness escalations, March

62 escalations, 9 reopened. Median time to first contact 1.8 days, down from 2.6.

Illustrative data. Report generated monthly with no manual steps.

Case storyleave & absence

A Fortune 500 employer's leave team ran on carrier exports and spreadsheets. Here is what we built instead.

The problem

Workers' compensation, short-term disability, FMLA and transitional duty each lived in a different export from the carrier. Case coordinators kept their own spreadsheets. Nobody could say how many people were out today, how many came back last month, or whether a claim marked closed by the carrier was actually closed.

What was built

A leave & absence platform on the company's data warehouse: a daily case view for coordinators with every claim, status, doctor appointment and follow-up date, a transitional duty tracker, and a KPI dashboard for leadership with month and year-to-date side by side. Return-to-work logic was rebuilt from the work-status history, and a fallback matching layer recovered claims the carrier feed had lost.

What changed

Workers' comp and transitional duty data reconciled to 100% status matching across systems. More than a thousand previously unmatched records recovered. One number for "people out today" that HR, safety and finance all agree on.

Then the outreach app

With the data trustworthy, a second application followed, for the specialists who call employees proactively at defined touch points during a claim. It launched with one specialist group, then extended to a second, with each group seeing its own claims and the full population, surveys tied to the touch point and claim, and a leader view for program ROI.

Open claims, my station Illustrative

Employee	Type	Out since	Days	Next	Status
EE 48•••1	WC	Feb 11	47	Dr appt Apr 2	Past ODG
EE 72•••6	STD	Mar 3	26	Follow-up Mar 31	Open
EE 19•••4	TD	Jan 22	66	Full duty Apr 8	RTW planned
EE 05•••8	WC	Mar 18	11	Intake form	Reopened
EE 63•••2	FMLA	Mar 24	5	Cert due Apr 1	Open

Illustrative data. Employee IDs masked.

Processfour phases

The discipline of an enterprise build, without the enterprise timeline.

Week 0

Scope

A 30-minute call. You describe the data and the questions; a written scope and fixed price follow within two days.

Weeks 1 to 2

Assess

We read your feeds, contracts and current reports and return a roadmap. For a warehouse or platform this is a fixed $5,000 and can stand alone.

Weeks 3 to 6

Build

In your cloud account, with progress visible at a private link the whole way. First working release by week six.

Ongoing

Run

Monthly releases, documentation your team can maintain, and the option of a light retainer for new questions.

What the first call covers

Which feeds you have and who owns them
The three questions leadership keeps asking
Where the data would live and who would see it
A rough size and timeline, on the call

Book the call

AboutAJ Freeman

Twenty-five years of making data behave.

AJ Freeman is a French-American data engineering leader. Since 2014 she has led data engineering and health analytics at a Fortune 500 employer, where she runs a three-tier organization of engineers and analysts across the United States and India supporting the company's self-insured health benefits program. She built its health analytics warehouse, its leave & absence platforms and its first AI assistant for benefits analysts.

Earlier she built Medicaid reporting systems at Hewlett-Packard Enterprise Services and held data roles at McKesson and Cingular Wireless. She started Second Opinion because most self-insured employers have no warehouse of their own and are paying vendors to grade their own homework.

Based inEuharlee, Georgia; clients anywhere

StackAWS (Redshift, Glue, Airflow, Bedrock), Python, Tableau, Claude API, Cloudflare

EducationEDC Paris Business School; Teradata certified

LanguagesFrench (native), English

ConnectLinkedIn

Websites and appsfor small businesses

We also build fast, search-ready websites and small apps.

The same clean code, at a size a salon or a flight school can afford. Live in two weeks, on your own domain, with booking and contact that go straight to you.

Site	What it does	From
The Lueur LashLash studio, Hickory, North Carolina	Service menu with prices, booking through Vagaro and Instagram from every row. lueurlash.com	$1,500
Fly With RandallFlight instruction, North Carolina	Programs, resume and a discovery-flight request form wired to email. flywithrandall.com	$1,500
The Little Honey HouseApiary, Georgia	Brand site, honey labels, and a hive inspection app used in the bee yard with gloves on. thelittlehoneyhouse.com	$1,500 site, $4,000 app

Not ready to callstart here

Five questions to ask before you build a claims warehouse.

A short guide for benefits and finance leaders: what to ask your carrier, your PBM and your IT team before anyone writes a line of SQL. Sent as a PDF, no follow-up sequence.

Questionsasked before hiring

Straight answers, no second-guessing.

We already have a benefits analytics vendor. Why build our own warehouse?

A vendor's warehouse answers the vendor's questions. Your own warehouse, in your own cloud, joins claims to leave, payroll and wellness data the vendor never sees, and it stays with you when the contract ends.

How is protected health information handled?

We sign a Business Associate Agreement with every client and work inside your cloud account. Identifiers are tokenized for matching across vendors and masked before analytics and before any text reaches an AI model, so PHI never leaves your environment.

What does a project cost?

A two-week data assessment is a fixed $5,000. Warehouses, leave & absence platforms and reporting are quoted after a scoping call, as a fixed price before work begins. Small-business websites start at $1,500 and web applications at $4,000.

How long does it take?

A first working release of a warehouse or platform in six weeks, then phased releases. An automated report in about three weeks. A one-page website in two.

Do we own the code and the data?

Yes. Code, infrastructure and data live in your accounts. You can end the engagement at any time with everything in hand.

Do you work outside Georgia?

Yes. All work happens over video and email, in English or French.

Contactreply within one business day

Get a second opinion. Thirty minutes, no charge.

Pick a time directly, or send two or three sentences and you will hear back within one business day.

Pick a time

ajcfreeman@gmail.com