Michael Plunkett
About Me
I'm a Director of Analytics with 10+ years leading data, marketing analytics, and business intelligence — and 5 years building the SYW Analytics practice at Transformco (Shop Your Way / Sears Home Services) from the ground up into one of the company's most technically advanced, AI-native analytics organizations.
My career has tracked the evolution of the analytics field itself: from GA360 implementations and Tableau reporting, through Snowflake data warehousing and BigQuery data lake architecture, to designing MCP (Model Context Protocol) servers that let Claude AI query live production databases in natural language. I use Claude Code and Cowork as core daily workflow tools.
At Transformco I've simultaneously led two of the company's most complex measurement challenges: the complete redesign of SYW.com and the migration of the flagship credit card program to a new issuer — maintaining analytics continuity across both without a gap. In parallel, I modernized the team's underlying GCP infrastructure and built the agentic framework that positions the practice to operate at AI scale.
AI & Agentic Tools
Analytics & Measurement
Engineering & Cloud
Marketing Tech & Strategy
The Analytics Evolution
Four phases. Four compounding layers of capability. One team, built from scratch.
Founded the SYW Analytics Jira project (SA-1) and established the team's operating model from day one. Led the full migration from Adobe Analytics to GA4 across SYW.com, the SYW MAX app, and the PYW app. Stood up GCP BigQuery as the team's analytics data warehouse with Composer-managed ETL. Architected the Sailthru purchase API integration and UTM auto-tracking framework that still powers behavioral email personalization today.
Scaled BigQuery reporting across SYW.com, app, and financial services data. Built member transaction dashboards segmenting Members vs. Card Members. Integrated Sears Home Services (AHM) as the analytics team's first formal partner business unit, building weekly Salesforce-to-BigQuery pipelines and executive reporting that has run consistently for 15+ sprint cycles.
Led analytics for two simultaneous major initiatives: the flagship credit card migration to a new issuer, and the full SYW.com redesign (Lovable.ai + Builder.io architecture). Architected GTM tagging strategy for the new site, designed UTM persistence across non-linear multi-platform user paths, and launched next-best-action attribution for early card member onboarding.
Transformed the analytics practice into a fully AI-native operation. Deployed production MCP servers connecting Claude AI to live BigQuery and Snowflake — enabling the team to query production data in natural language. Simultaneously modernized the underlying GCP infrastructure: migrating legacy VM-based pipelines and managed Airflow to a serverless Cloud Functions + Cloud Build CI/CD model. Designed the 3-layer agentic framework (Directives → Orchestration → Execution) that positions the team to deploy intelligent agents at scale. Integrated AI-powered data cataloging for self-documenting infrastructure.
What I've Built
Key initiatives from 4+ years at Shop Your Way
Credit Card Program Migration
Full Analytics Rebuild · Issuer Transition
Led the complete rebuild of measurement infrastructure for a flagship credit card program as it transitioned to a new issuer. Designed the GA4 acquisition funnel dataset tracking the full customer journey from web visit to card approval. Built cohort segmentation tables powering win-back and lifecycle targeting. Identified and escalated a critical data integrity issue in the application flow with documented query analysis. Replaced manual encrypted file delivery with zero-touch automation.
SYW.com Complete Redesign
GTM & GA4 Measurement Leadership
Partnered with engineering to maintain measurement continuity across a full site overhaul — from monolithic codebase to multi-platform architecture (Lovable.ai + Builder.io + SYW app webviews). Led GTM auditing and resolved tag-firing-too-early bugs with delayed triggers. Designed UTM persistence for non-linear user paths. Stood up waitlist GA4 tracking within 24 hours of launch.
AI-Native Analytics Platform
MCP Architecture · Enterprise AI Infrastructure
Among the earliest enterprise analytics practitioners to build a production MCP server stack. Designed 3 MCP connections giving Claude AI real-time, read-only access to live BigQuery and Snowflake — replacing manual query-paste-analyze cycles with natural-language agentic data access. Directed credential security migration from legacy service account JSON to trusted MCP connections. 14 milestones delivered in 110 days.
GCP Infrastructure Modernization
CI/CD Architecture · Agentic Platform Foundation
Led the architectural decision to migrate legacy VM-based pipelines and managed Airflow (GCP Composer) to a serverless Cloud Functions + Cloud Build CI/CD model. Identified and documented the deprecation risk of Cloud Source Repositories (sunset June 2024) and designed a phased migration ladder to GitHub + Cloud Build, enabling the team to scale without inheriting technical debt. Audited and re-homed all production pipeline jobs to Cloud Scheduler for observability and retry logic. Migrated credentials from hardcoded scripts to Secret Manager. Built the 3-layer agentic framework architecture — Directives, Orchestration, Execution — that serves as the operating model for AI agent deployment on top of the existing data infrastructure.
Career History
20 years across media, agencies, enterprise, and fintech
Built SYW Analytics from scratch → AI-native data platform
KPI frameworks, reporting automation, Tableau standardization
Built Snowflake DW; supported $22M national media buy
SEO, media & creative analytics for major brand accounts
GA360 migration across 1,400 affiliates; 2x eComm growth via A/B testing
Earlier Agency & Media Experience
BBA, Advertising & Promotions
Western Michigan University
Google Analytics (GAIQ) · Google Tag Manager · DePaul CIMA · Python for Data Science
Get In Touch
Open to conversations about analytics leadership, AI-native data infrastructure, MCP architecture, or building measurement systems for complex platform transformations.
The best way to reach me is directly through LinkedIn. Feel free to send me a connection request or a direct message!
Connect on LinkedIn