Functional Skills

Project Management
Change Management / Org Design
Market Research
Data Visualization / Reports
Competitive Landscaping
Agile Software Development
Budgeting
Business Analytics
Business Intelligence
Communications
Data Engineering
Data Governance
Data Science
Leadership Development
Product Data Management

Software Skills

Azure
Cloud computing
Snowflake
SQL
Tableau
Database migration
AWS
Alteryx
Asana
Data visualization
Jira
PowerBI

Sector Experience

Business Services
Healthcare
Life Sciences & Pharma
Social & Public Sector
Technology

Languages

English
Case Study
Delete

Note: After you save your new Case Study, you'll be able to upload / attach work deliverable files by editing it!

Case Studies

dataScienceAnalytics
Data lakehouse migration at leading life sciences company
Life Sciences & Pharma Data Strategy Master Data Management Project Management
dataScienceAnalytics
Interim analytics leadership at F500 life sciences company
Life Sciences & Pharma Data Strategy Data Analysis Organizational Leadership

Notable Clients

F200 life sciences company
F500 life sciences company
Federal healthcare agency

Experience

JWS ANALYTICS LLC Management Consulting
Independent Consultant
1/2020 - Present
Founded my own independent analytics consultancy (JWS Analytics LLC).
▪ Served as interim director for a 15-person business analytics team for a $4B line of business at an F200 life sciences company. Restructured the team, hired new talent, implemented a task management system, instituted best practices, and aligned expectations with stakeholders. Contract extended three times.
▪ Guided the implementation and adoption of Databricks on AWS for a $4B line of business at a separate F500 pharmaceutical company, accelerating user acceptance of the new platform and enabling advanced modeling. Established data governance and advised on architecture.
▪ Led a cloud migration from an on-prem MS SQL data warehouse with thousands of tables to Azure Databricks lakehouse while concurrently migrating hundreds of ETL jobs from multiple Alteryx instances to Azure Data Factory (ADF). Mapped the architecture and implemented data lineage.

athenahealth Data Science / Analytics
Analytics Manager
6/2017 - 12/2019
Led analytics projects, gaining first-hand experience in digital health analytics at an electronic health record company during a private-equity-led takeover of the company.
- Managed data science project critical to athenahealth's value prop, coordinating across analytics, marketing, and customer success divisions to generate deep understanding of user behavior, culminating in identification of $100M+ in potential cost savings for athenahealth's 8,000+ clients.
- Streamlined and standardized a fragmented reporting and analytics process by utilizing SQL, Informatica, Snowflake, and Tableau in a hybrid/multi-cloud environment, reducing the internal burden to produce, access, and interpret revenue cycle performance analysis for the $30B+ in payments received by athenahealth clients every year.
- Supervised engagement with an outside consulting firm to collect data on client workflows, working directly with key clients; analyzed and distilled insights for senior leadership.

South Carolina Medicaid Program Product Management / Strategy
Director of Price Transparency and Project Manager
7/2013 - 8/2015
Developed vision, built consensus, and managed project objectives, timelines, and communications for cross-departmental teams with 15+ members on high-visibility projects for a state agency with $7B+ in annual expenditures.Interfaced directly with the agency head and C-suite.
- Identified root causes of decreased productivity in a 150-person organizational unit, instituted workflow changes to narrow workers' focus to core duties, created an 8-person administrative team to handle specialized duties, and overhauled contractual relationships with 85 hospitals and clinics that interacted with the workers.
- Implemented an accountability program for 60 hospitals by working directly with hospital CEOs/CFOs under legislatively mandated deadlines, ensuring that Medicaid was the payer of last resort for $504M in annual expenditures.
- Served as product manager, leading scrum team to build a public website to democratize access to complex CMS hospital cost report data.

South Carolina Attorney General's Office Legal
Director of Consumer Protection and Antitrust
5/2005 - 7/2013
Built and managed a team of attorneys, analysts, and contractors to initiate, execute, and resolve high-stakes pharmaceutical litigation.Interfaced directly with the Attorney General and other senior leaders.
- Joined as intern; received multiple promotions up to Director level, becoming the only non-attorney in the United States to lead a state's Consumer Protection and Antitrust Division.
- Designed and implemented strategy to maximize settlement value while minimizing budget impact, integrating analytical, strategic, political, and legal considerations while operating in a complex national litigation landscape.
- Achieved over $100M in settlements in first calendar year as Director, objectively superior results compared to other states.
- Recruited, supervised, and mentored staff including JDs and PhDs, growing the division from 1 attorney and 1 staffer to 5 attorneys, 4 staffers, and 20+ outside contractors.