Open to opportunities

Theodore Sheehan

@theodoresheehan

Message

I’m a senior data analyst building trusted Power BI analytics teams actually use.

United States

Message

What I'm looking for

I’m looking to lead analytics and reporting that teams actually use—governing reliable Power BI solutions, automating manual workflows, and partnering cross-functionally to define KPIs, improve adoption, and turn data into confident business decisions.

I’m a senior data analyst with deep experience building and governing reporting solutions that support $6B+ in business. I specialize in process automation, cross-functional analytics, and translating unstructured data into clear, actionable insights.

At McCormick & Company / FONA International, I managed enterprise sales reporting for $500M+ in annual revenue, delivering budgets, actuals, and forecasts across territories, product lines, and customer segments. I engineered and governed Power BI reporting solutions using SAP, TM1, AX, and Salesforce data—improving data consistency, performance, and trust across the organization.

I also owned Power BI datasets end-to-end, including Row Level Security, refresh logic, and user access—so thousands of users could securely and reliably use analytics. I led the design and rollout of an enterprise Power BI reporting suite used by 2,000+ stakeholders, reducing manual reporting effort and accelerating self-service adoption.

Earlier in my career, I led pricing and reporting initiatives that generated $25M+ in annual revenue at CDK Global, and I restructured reporting services at Syncreon to save $300K+ annually in salary expense. Across roles, I’ve consistently partnered with business teams to define KPIs, improve adoption, and deliver solutions people actually use—backed by requirements gathering, UAT, training, and post-launch monitoring.

Experience

Work history, roles, and key accomplishments

Current

Sr. Data Analyst / BI Manager

Current

McCormick & Company (FONA)

May 2018 - Present (8 years 1 month)

Managed enterprise sales reporting for $500M+ in annual revenue, delivering budgets, actuals, and forecasts across territories, product lines, and customer segments. Engineered and governed Power BI solutions using SAP/TM1/AX/Salesforce data to improve consistency, performance, and adoption across 2,000+ stakeholders.

Power BI DAX Data Modeling SAP TM1 Salesforce Administration Data Governance

Sr. Pricing Analyst

CDK Global

Jun 2015 - May 2018 (2 years 11 months)

Led companywide pricing initiatives generating $25M+ in annual revenue by developing data-driven methodologies and rollout plans across business platforms. Built forecasting models and reporting to support price increase planning, reduce revenue leakage from discounting, and improve contract renewal outcomes.

Pricing Strategy Revenue Forecasting Discount Analytics Contract Renewal Deal Level Reporting Stakeholder Management Process Improvement Excel

Business Reporting Analyst / Manager

Syncreon

Jun 2014 - Jun 2015 (1 year)

Led financial and operational reporting for a $250M business unit, delivering insights to senior leadership and customers. Restructured the reporting services team, improved productivity, and saved $300K+ annually by redesigning workflows and deploying automated, standardized dashboards.

Report Automation Dashboard Development Data Standardization Financial Reporting Workflow Optimization Team Leadership KPI Reporting

Purchasing Business Analyst

Syncreon

Jan 2013 - Jun 2014 (1 year 5 months)

Designed and implemented an interactive dashboard to track a $1.2M cost savings target for purchasing. Produced executive-level board reporting and supported savings strategies through supplier analysis, pricing review, and risk assessment.

Executive Reporting Dashboarding Price Reviews Risk Assessment Data Analysis Process Standardization

Purchasing Manager

Dock and Door National

Sep 2012 - Jan 2013 (4 months)

Improved operational efficiency and reduced costs by identifying gaps across internal systems, procedures, and purchasing workflows. Managed parts purchasing and inventory replenishment and implemented standardized client pricing to improve margin visibility and response times.

Purchasing Management Standard Price Operational Analytics Cross Functional Collaboration Vendor Support

Cost Manager

Navistar Inc.

Jun 2011 - Sep 2012 (1 year 3 months)

Led target cost, product cost, and tooling estimates for major program changes across a matrix organization. Partnered with engineering, manufacturing, purchasing, finance, and program teams to package design concepts, validate costs, and maintain program cost/tooling accountability.

Target Costing Product Costing Program Cost Management Cross Functional Collaboration Financial Analysis

Military Pricing Analyst

Navistar Inc.

Jan 2010 - Jun 2011 (1 year 5 months)

Supported $600M+ long-term military contract pricing by partnering with business development, contracts, and finance teams. Built and maintained pricing systems and models, including a defense price book for 70,000+ parts, while standardizing government and military pricing submissions.

Government Contract Pricing Defense Supply Center Columbus (DSCC)Pricing Models Pricing Book Management Process Standardization

Military Sales Analyst

Navistar Inc.

Sep 2008 - Jan 2010 (1 year 4 months)

Managed and tracked 2,000+ military orders for the Defense Logistics Agency, ensuring accurate and timely fulfillment. Developed tracking systems to improve order visibility and coordination and expedited high-priority orders in support of deployed warfighters.

Order Management Logistics Coordination Expediting Research And Analysis

Field Service Manager Intern

Navistar Inc.

Jan 2008 - Sep 2008 (8 months)

Developed training materials and documentation for prototype diesel engines and assisted in validating vehicle electronic controls. Helped resolve customer-reported engine issues through technical validation and documentation.

Technical Documentation Training Materials Customization Prototypes Electronic Controls Validation Technical Reporting