Michael Plunkett
About Me
I'm a Director of Analytics with 10+ years leading data, marketing analytics, and business intelligence — and 3.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 5321 Visa card program from Citi to a new issuer — maintaining analytics continuity across both without a gap.
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 Citi → Aress LCCAAS 5321 Visa card migration, 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 EMOB next-best-action attribution for early card member onboarding.
In 110 days, the team went from first Claude AI access to a production-grade AI analytics platform recognized in a Board of Directors update. Deployed 3 MCP servers connecting Claude to live BigQuery and Snowflake. Eliminated manual PGP/SFTP workflows through end-to-end automation (0 manual steps). Built the LCCAAS Command Center dashboard. Integrated Dataplex + Gemini for self-documenting data infrastructure.
What Changed
110 days. 14 milestones. One AI-native analytics platform.
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.
Home Services Analytics Partnership
First Strategic Partner Integration
Established Sears Home Services as the analytics team's first formal partner business unit. Built weekly Snowflake-to-BigQuery marketing pipelines that have run consistently for over two years. Deployed two dedicated MCP connections (BigQuery + Snowflake) making it the first partner fully integrated into the AI analytics stack — enabling real-time cross-sell analytics without manual reporting. Leading dataset strategy for a predictive member engagement scoring model.
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.