👋 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 — Projects
Projects
Personal and lab projects, built on my own time with public or synthetic data.
Bitcoin Buy Signals Dashboard
Personal project in progress: a Power BI dashboard that combines Bitcoin valuation signals — Meyer Multiple, RSI, drawdown from peak, 200-week trend and the Fear & Greed Index — into a single composite score. Click the image to see the full dashboard.
05 — Contact
Let's Connect
Have a project in mind or want to discuss an opportunity? I'd love to hear from you.