Data Analyst University Park
Resume:
PAUL THEM
Data Analyst
+1-610-***-**** *******@*****.*** linkedin.com/in/paulthem Bryn Mawr, PA
SUMMARY
Award-winning data analyst, storyteller, and strategic thinker with nearly a decade of experience synthesizing large amounts of data into graphics, presentations, and insights. Skilled at working with cross-functional teams to bolster creativity and ensure accuracy. Excited to build innovative solutions to complex problems.
EDUCATION
Bachelor of Science: Mathematics (Systems Analysis) Penn State
08/2009 - 05/2013 University Park, PA
Bachelor of Science: Economics
Penn State
08/2009 - 05/2013 University Park, PA
EXPERIENCE
Manager – Market Economics
Cencora
08/2024 - 03/2025 Conshohocken, PA
Built a 5-year forecast tool in Excel from scratch to support the business case for a successful $4.6 billion acquisition
Led a two-person team to develop actionable market forecasts Developed methodology to identify 505(b)(2) and competitor products, improving market insights for strategic decision-making Modeled customer program to mitigate generic drug shortages, presenting to internal and external leadership teams for successful program launch Senior Analyst – Market Economics
Cencora
08/2023 - 08/2024 Conshohocken, PA
Synthesized data from the FDA and other industry sources to forecast which drugs Medicare will select for negotiation per the Inflation Reduction Act (IRA) to prepare teams for contract negotiation discussions with manufacturers Created financial risk models related to policy and regulatory activity, such as state importation of drugs and the removal of the Medicaid rebate cap Analyzed potential financial programs to determine potential internal and customer benefits of alternate pricing strategies
Built dashboards to provide visibility of profit by various business segments Market Data Analyst
Essity
01/2020 - 11/2021 Philadelphia, United States
Created quarterly reporting based on internal and external data to detail current market performance and position
Wrote a Visual Basic macro to transform Excel data tables into insightful, detailed PowerPoint presentations
Worked with internal teams to develop marketing and business development strategies and objectives
SKILLS
SQL PowerPoint Microsoft Access
Microsoft Excel (including VBA and advanced
functions)
SAP Power BI DAX Power Query
Business Warehouse Business Objects
Collaboration Public Speaking
PROJECTS
Five-Year Forecast Tool
10/2024 - 11/2024 Cencora
Built an Excel tool from scratch to support the
business case of a $4.6 billion acquisition
Excel tool captured various teams' inputs for
relevant products, unit and price growth,
distribution share, and customer uptake
Modeled profits for relevant market stakeholders,
with safeguards in the model to ensure that 100%
of the market units were accounted for with no
double-counting or errors
Efficiently delivered a reliable business case and led to deal approval
Medicare Negotiated Product Report
08/2022 - 12/2024 Cencora
Built an Excel tool from scratch to forecast drugs receiving a Medicare maximum fair price (MFP)
Used Data Connections and advanced functions to
synthesize data from the FDA, Medicare, Evaluate
Pharma, IPD Analytics, and various teams' internal forecasts
Created an algorithm to identify drugs eligible for MFP selection, based on criteria specified in the
Inflation Reduction Act
Estimated likely price reduction after MFP
introduction
Presented detailed risk forecasts to executive
leadership and developed profit mitigation
strategies
Successfully predicted 8 of 10 drugs selected for
2026 and 9 of 15 drugs selected for 2027,
adequately preparing contracting teams to
mitigate risks
AWARDS
Pursuit of Purpose
Cencora 2022
Special Recognition
Essity 2017
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
E q
)
)
Contact this candidate