👋 Hello, I'm
Patrick Williams
Manager & Strategist — Sales & Marketing Analytics
Turning complex data into clear, compelling decisions that drive commercial growth.
01 — About
Who I Am
Seasoned data leader with 15+ years of success enhancing commercial, marketing, and sales operations at companies of all sizes and growth stages — spanning retail, e-commerce, pharmaceutical, and medical device.
I excel as both a builder and leader of advanced analytics teams and as a hands-on analyst who can dive in and add immediate value. My work sits at the intersection of rigorous data analysis and strategic business thinking, translating complex datasets into clear stories that executives and field teams can act on.
Strong executive presence and holistic business acumen refined through entrepreneurial ventures, consulting engagements, and formal MBA and MSA training from UNC Chapel Hill and NC State University.
02 — Experience
Work History
Senior Manager, Marketing Analytics
Solta Medical (Bausch Health)
- Built a Power BI reporting suite of 15+ interactive dashboards covering weekly sales performance, customer churn, reorder rates, and key activity metrics — ranked 5th most utilized package across the entire Bausch Health Power BI server.
- Designed and launched a subscription sales model for the consumables business; 105 accounts enrolled in year one (25% of total sales), growing 2.5× faster than non-subscription accounts.
- Automated real-time territory reporting by partnering with Bausch IT to build a SQL database from Salesforce data, replacing error-prone manual Excel processes for ~80 field reps.
- Developed systematic bottom-up forecasting techniques that improved accuracy of forecasts produced by finance teams.
Sales Analytics Manager, Respiratory Biologics
GlaxoSmithKline (GSK)
- Developed an interactive Tableau dashboard that standardized and automated a weekly diagnostic process, summarizing performance toward reach, frequency, Rx volume, and writer count goals in a $300M business unit.
- Led implementation of 10+ IQ20/20 software enhancements that increased precision of sales tracking and created visibility into the specialty pharmacy channel.
- Improved field sales recruitment targeting by identifying 6,000 healthcare providers with a strong propensity to attend live speaker programs.
Advanced Analytics Analyst, Primary Care
GlaxoSmithKline (GSK)
- Co-built and deployed a marketing mix model with Tableau dashboards featuring response curves representing incremental profit from investment across marketing channels and geographies.
- Automated a physician-level prescribing behavior aggregation program using R statistical analysis, sending weekly performance reports to 2,000+ sales reps.
- Built a Tableau tracking template that isolated the performance impact of sales pilot programs at a regional level.
Senior Marketing Analyst, Web Analytics
Hanesbrands
- Managed all data collection, reporting, and analysis for four e-commerce sites in partnership with BI, marketing leadership, and executive stakeholders.
- Led a data warehousing initiative to consolidate keyword-level data into a single SQL + Tableau reporting stack, dramatically expanding SEO analysis granularity.
- Implemented an automated cross-sell engine across all websites, driving a 500% increase in cross-sell buyers.
03 — Skills
Professional Abilities
Data Visualization
- Microsoft Power BI
- Tableau
- DAX & Power Query (M)
- Python (Pandas)
Data & Languages
- SQL
- Python
- DAX
- R (Statistical Analysis)
- Salesforce CRM
Analytics & Strategy
- Revenue Forecasting
- Marketing Mix Modeling
- Market Research
- Sales Incentive Compensation
- Predictive & Regression Modeling
Leadership & Process
- Analytics Team Leadership
- Process Automation
- Executive Storytelling
- Vendor Management
- Coaching & Mentoring
04 — Portfolio
Power BI Work
A selection of dashboards and reports built to support real business decisions.
Field Sales Reporting Suite
Designed 15 Power BI reports from scratch for Solta Medical field reps — covering territory performance, cold account identification, promo utilization, and forecasting. Ranked 5th most-utilized package on the Bausch Health server out of thousands.
Executive Performance Dashboard
Built 15+ interactive Power BI dashboards for senior leadership tracking weekly sales performance, customer churn, reorder rates, and key activity metrics across a $75M North American business unit.
Subscription Sales Model Analysis
Analyzed feasibility and designed a new subscription pricing model for consumables. In year one, 105 accounts enrolled — 25% of total sales — growing 2.5× faster than standard accounts.
05 — Contact
Let's Connect
Have a project in mind or want to discuss an opportunity? I'd love to hear from you.