Finding the Signal in
Healthcare Marketing Data

Healthcare marketing analytics leader with 15+ years across pharma, HCP, DTC, omnichannel measurement, web analytics, QA automation, dashboards, and executive storytelling.

“I find what others miss in the data.”

Where Strategy, Messy Data,
and Business Decisions Meet

I help healthcare and pharma teams find the signal in fragmented marketing data, build trusted measurement frameworks, and turn dashboards into decisions.

With over 15 years in healthcare marketing analytics, I have worked across major pharma brands, HCP and DTC campaigns, omnichannel media, web analytics, CRM, claims-based measurement, and executive reporting. My career has been shaped by agencies including Publicis Health, Digitas Health, and Epsilon — environments where the data is complex, the stakes are high, and the clients need answers that hold up under scrutiny.

I work across the full analytics lifecycle: defining the right questions, connecting the right data sources, building measurement infrastructure, QA-ing the inputs, and translating performance into insight that drives action. I am as comfortable in an Excel workbook building a measurement logic layer as I am presenting findings to a VP of Marketing.

“I work where marketing strategy, messy data, and business decisions meet.”
15+
Years in Healthcare Analytics
Pharma
HCP · DTC · Omnichannel
Agency
Publicis · Digitas · Epsilon
Full
Analytics Lifecycle

What I Do Well

Omnichannel Measurement Strategy

Design measurement frameworks that connect media, web, CRM, and claims data into a coherent view of campaign performance.

Marketing KPI Frameworks

Define the right KPIs for each journey stage, tactic, and audience so performance reporting connects to business goals.

Web Analytics & Tag QA

Validate and troubleshoot GA4, Adobe Analytics, and GTM implementations to ensure data collection is trustworthy from the start.

Dashboard Development

Build reporting systems that create trusted sources of truth and dramatically reduce the manual effort required each reporting cycle.

Executive Storytelling

Translate complex analytics into clean slides that answer “so what?” and lead stakeholders from data to decision.

Claims-Based Measurement

Connect media exposure to real-world prescription and patient data to measure audience quality and campaign impact.

Test/Control & Incrementality

Design and analyze holdout tests, exposed vs. unexposed comparisons, and incrementality studies to measure what media is truly driving.

Data QA & Automation

Build repeatable QA processes that replace manual file checking with automated validation, exception flagging, and audit trails.

Excel-Based Analytics Systems

Design Excel workbooks that function as micro-databases: lookup logic, pivot structures, linked outputs, and repeatable templates.

Cross-Agency Alignment

Lead measurement conversations across media agencies, analytics vendors, and client stakeholders to reach shared definitions before the campaign launches.

HCP & DTC Campaign Analytics

Measure healthcare professional and patient-facing campaigns across digital, search, display, email, and content channels.

AI/LLM-Assisted Workflow

Apply AI tools to accelerate analysis, automate routine tasks, and improve analytical throughput — without replacing judgment.

What I Build

Measurement Frameworks

Connect tactics to journey stage, KPI, data source, reporting cadence, and decision use. A good framework tells you what to measure, why it matters, where the data lives, and what action follows each signal.

Dynamic Dashboards

Build dashboards and reporting systems that reduce manual effort, establish a single trusted source of truth, and give teams the ability to answer client questions confidently — without scrambling for data mid-call.

QA Automation

Replace manual file-by-file checking with repeatable QA pipelines that scan folders, validate formats, flag exceptions, and generate audit reports. Less analyst time. More consistent outputs.

Web Analytics & Debugging

GTM, GA4, and Adobe-style implementation QA: tag validation, bot and noise detection, consent impact analysis, traffic source diagnosis, form path performance, and behavioral pattern review.

Executive Slides & Storytelling

Convert complex data into clean, decisive presentations. The goal is not a data dump — it is a clear narrative: here is what happened, here is why it matters, here is what we should do next.

Excel Training & Enablement

Teach teams to think clearly through data: pivot tables, lookup structures, Power Query logic, QA checklists, and repeatable reporting templates. Turn report builders into insight generators.

Work Examples

All examples are anonymized and sanitized. No client data, campaign IDs, or proprietary metrics are displayed.

Vendor Accountability Media Measurement Digital Bloodhound

Publisher Delivery Investigation

The Problem

A publisher promised high audience delivery for a sponsored content center, but reported delivery numbers did not match observed behavior in the traffic data.

The Approach

Audited traffic patterns across time, monitored competitive activity, used a market disruption as a natural experiment, and compiled evidence into a structured presentation for leadership.

The Outcome

Secured make-good value from the publisher, reduced spend against low-quality delivery, and reallocated budget to higher-performing tactics.

Optimization Media Quality
Claims Data Audience Quality Incrementality

Claims-Based Audience Quality Measurement

The Problem

Reach metrics showed impressions delivered, but gave no evidence that media was actually reaching the diagnosed patient audience. Reach without relevance is waste.

The Approach

Connected media exposure data to claims-based validation, benchmarked audience quality against real-world diagnosed prevalence, and compared exposed versus unexposed groups.

The Outcome

Identified higher-quality publishers, reframed the optimization conversation from cost-per-impression to cost-per-qualified-reach, and informed spend reallocation.

HCP/DTC Measurement Audience Validation
QA Automation R AI-Assisted

QA Automation for Publisher Data Files

The Problem

Monthly data QA required manually opening multiple vendor files, checking row counts, NPI formats, date structures, and file completeness. The process was time-consuming and inconsistent across analysts.

The Approach

Used AI-assisted coding to build a repeatable folder-level QA script that scanned incoming files, validated against defined rules, and produced a structured exception report.

The Outcome

Reduced manual QA effort significantly, improved consistency across analysts, and surfaced data quality issues earlier — before downstream reporting was affected.

Process Improvement Automation
Excel Dashboards Reporting Systems

Dashboard Source of Truth

The Problem

Teams were producing reports on schedule, but struggled to answer follow-up questions quickly or consistently. Each question required rebuilding the analysis from scratch.

The Approach

Built Excel-based micro-database structures with lookup tables, pivot-driven summaries, and PowerPoint-linked outputs that could be refreshed and queried without manual rebuilding.

The Outcome

Improved reporting speed, increased client confidence, and gave teams the ability to answer deeper questions live — without scrambling to pull new data mid-call.

Client Readiness Reporting Infrastructure
Omnichannel KPI Framework Journey Analytics

Journey-Based KPI Framework

The Problem

Campaign reporting was organized by channel, not by business goal. It was impossible to see how tactics were moving HCPs or patients from awareness through consideration to conversion.

The Approach

Mapped each tactic to a journey stage, clarified the KPI for each stage, aligned internal and client stakeholders on definitions, and connected media signals to downstream business questions.

The Outcome

Improved strategic clarity in optimization conversations, reframed reporting from “channel performance” to “journey impact,” and gave leadership a cleaner view of where to invest.

Strategy Stakeholder Alignment
Team Leadership Coaching Storytelling

Analyst Coaching: From Numbers to “So What?”

The Problem

Analysts were producing accurate, well-structured reports — but stopping there. The data was right. The interpretation was missing. Reports described what happened, not what it meant.

The Approach

Created a “so what?” review framework, coached analysts to connect performance changes to business goals, and built a feedback loop tied to actual client questions.

The Outcome

Improved insight quality across the team, built analyst confidence in client-facing storytelling, and reduced the revision cycle between analyst draft and final deliverable.

Analytics Enablement Team Development

Tools & Methods

Web Analytics & Debugging

Google Analytics (GA4) Adobe Analytics Google Tag Manager UTM Development QR Code Tracking Chrome DevTools Tag QA Consent Impact Analysis Bot & Traffic Noise Diagnosis

BI & Dashboarding

Excel (Advanced) PivotTables Tableau PowerPoint

Data & Automation

SQL R Python AI/LLM-Assisted Coding

Healthcare & Marketing Data

Claims Data NRx / TRx CRM Media Platform Exports Publisher Reports Web Event Data HCP Target Lists

Measurement Methods

KPI Frameworks Test / Control Holdouts Incrementality Attribution Audience Quality Segmentation Engagement Scoring Journey Analytics

Where I’ve Worked. What I’ve Measured.

Examples are summarized at a category level to respect client confidentiality.

Companies & Clients

Publicis Health
Digitas Health
Epsilon
Teva
Sanofi Pasteur
GSK
AstraZeneca
Horizon / Amgen
Genzyme
Additional pharma and healthcare environments

Therapy Areas & Indications

Vaccines RSV Shingles Meningitis Pertussis Flu High Dose Respiratory Asthma Bipolar Disorder Major Depressive Disorder Neurology Multiple Sclerosis Migraine Rare Disease Thyroid Eye Disease NMOSD gMG IgG4-RD Tardive Dyskinesia Huntington’s Disease Immunology Head Lice HCP Campaigns DTC Campaigns Disease State Websites Branded Websites

What Reporting Looks Like

Thumbnails are placeholders. Sanitized screenshots can be added to assets/dashboards/.

From Data to Decision

Slide thumbnails are placeholders. Sanitized examples can be shared upon request.

Condenses campaign quarter into one page: performance vs. goal, top insights, and recommended next actions. Built for leadership, not analysts.

Maps each tactic to its journey stage, primary KPI, data source, and optimization lever. Aligns teams before the campaign launches.

Shows how patients or HCPs move from awareness through engagement to conversion, with KPIs tied to each stage of the journey.

Presents exposed vs. unexposed comparison clearly, with confidence framing and business interpretation — not just statistical output.

Breaks down publisher-level performance, delivery quality, and audience validation to support optimization and vendor accountability conversations.

Documents what was flagged in data QA, how many records were affected, and what action was taken — so issues are tracked, not buried.

Connects performance data to a clear media decision: what to shift, why, and what outcome to expect. Makes the recommendation easy to act on.

Excel Is Where Many Analytics Teams Learn to Think Clearly

Excel is not just a tool. It is the environment where most healthcare marketing analytics teams build their analytical instincts — and where poor habits compound into reporting problems. I help teams go further.

I have trained analysts and clients in practical Excel skills that improve reporting quality, reduce manual effort, and build the kind of repeatable systems that survive staff turnover and client questions.

“From report builder to insight generator.”
Excel Training & Pivot Tables

From basics to advanced pivot structures that answer real business questions.

Lookup Table Design

VLOOKUP, INDEX/MATCH, and structured reference logic that reduces formula errors.

Dashboard Templates

Reusable templates that can be refreshed each reporting cycle without rebuilding.

QA Checklists

Structured QA routines that catch formatting errors, missing data, and logic breaks before they reach a client.

Reporting Automation Thinking

Power Query logic, repeatable refresh workflows, and removing the copy-paste step from the process.

“Ask Better Questions of the Data”

Coaching analysts to move beyond the number and connect performance to business meaning.

Calm. Structured. Practical. Collaborative.

Coaching Junior Analysts

I have developed analysts from report builders into genuine business thinkers — pushing beyond accurate numbers to interpretation, narrative, and recommendation.

Managing Offshore & Onshore Workflows

Designed clear handoff structures, templates, and QA protocols that make global team collaboration repeatable and low-friction.

Leading Cross-Agency Calls

Facilitated measurement alignment across media agencies, analytics vendors, client teams, and creative partners — keeping discussions structured and productive.

Aligning Stakeholders

Bridged the gap between clients, media teams, analytics teams, and vendors — translating technical findings into business language and turning ambiguous questions into structured analysis plans.

Repeatable Reporting Cadences

Built reporting workflows that teams can sustain independently — clear templates, ownership, timelines, and quality gates built into the process.

Structured Analysis Planning

Turn vague briefs and ambiguous business questions into clear analytical plans: defined question, data needed, method, output, and decision framework.

How I Work

I inspect what others assume is correct.

I like clean data, clear logic, and useful reporting.

I enjoy translating complex data for non-technical stakeholders.

I ask “so what?” until the answer connects to a decision.

I like building repeatable systems that save time and reduce analyst toil.

I enjoy teaching analysts how to think beyond the numbers.

I am energized by messy problems, fragmented datasets, and hidden signals.

I care about doing the work right — not just getting it done.

Let’s Talk Analytics

Open to healthcare analytics, omnichannel strategy, marketing measurement, business insights, BI, and analytics leadership roles.

Location

Philadelphia Metro · Glenside, PA