Eric A. Palmer
Chanhassen,MN
Summary
Creative Analytics Manager keen to expand beyond traditional tools and techniques to advance both internal business goals and data analytics pursuits. Derives excellence from personnel by providing exemplary leadership and technical expertise. Skilled creator of cohesive, productive teams exploiting every bit of available data.
Overview
13
13
years of professional experience
Work History
Pharmacy RFP Analytics Manager
RxConnection
Greater Twin Cities, Remote
07.2024 - Current
- Implement and lead RFP process improvement initiative, incorporating advanced analytics techniques to streamline and scale new product(s)
- Write custom SQL programs from scratch to performance advanced analytic modeling & reporting
- Manage a full team of RFP analysts, providing mentorship and teaching SQL techniques to create efficiencies in day-to-day job functions
- Provide recommendations to leadership to incorporate process improvement initiatives and strategic roadmap to success
- Manage & market RFP product in conjunction with sales team
- Create job aids and SOPs for newly created processes, sharing knowledge of new processes across the organization
- Explore AI initiatives internally and externally to continue to enhance revenue and gain new business
- Created custom dashboards and interfaces designed specifically to suit customer needs and priorities for optimal performance.
- Mentored junior analysts in the application of statistical methods, elevating their analytical skills and contributing to team success.
Healthcare & Pharmacy Advanced Analytic & Financial Consultant
Quantive Analytics LLC
Greater Twin Cities, Remote
10.2021 - 07.2024
- Leverage various analytic methods, MS SQL Server, Python, SAS, PowerBI, Snowflake and identify the best path forward to automate analytics that are conceptualized for the client to use in the future
- Extrapolating medical/pharmacy/clinical data and navigating cloud platforms (i.e., Snowflake, Databricks, Azure, etc.), writing advanced SQL within each one
- Build custom financial/analytic models and help executive leadership make informative data-driven decisions that enhance savings/margin, estimate ROI, generate new business, consolidate IT infrastructure (i.e., claims platforms), etc
- Building data views within cloud platforms to run analytics and joining various views together, based on specified analytic requests
- Administrator role of schemas/views to provide access to other users to run analytics/data visualization
- Provide analytic & financial solutions to Health Plans, PBMs, Brokers/Consultants, other employer groups
- Quote projects based on customers’ needs and outline scopes, costs, additional resources needed to complete said project
- Meet regularly with executive leadership to provide project updates and present financial modeling/analytic findings
- Built strong relationships with clients through consistent communication and exceptional customer service.
- Analyzed market trends and identified investment opportunities, resulting in enhanced portfolio performance.
Pharmacy Data Analytics Consultant
RxBenefits
National (Remote)
04.2022 - 08.2023
- Support senior leadership business decisions with data-driven financial analysis / analytics
- Build end-to-end processes, working with vendors, internal partners to gather information / collaborate, level-set requirements and execute
- Writing advanced SQL in SAS / MS SQL Server from scratch, and adjusting as needed to fulfill various requests from stakeholders
- Building SOPs for various dashboards and creating procedures to enhance efficiencies
- Creating client-friendly reporting and consulting account team, so they can understand the data we provide and be able to clearly explain it to clients / internal stakeholders
- Conceptualize and collaborate with other analytics partners to develop new/custom reporting, thinking outside the scope of the general PBM reporting
- Lead meetings and assign roles/responsibilities for projects, ensuring various partners meet deadlines
- Conceptualizing and constructing clinical analytic models / visualizations for stakeholders and clients
- Championed a data-driven culture within the organization by promoting awareness of analytics tools and techniques among non-technical stakeholders.
- Standardized reporting processes across departments to ensure consistent measurement, analysis, and presentation of key performance metrics.
Senior Financial & Analytics Analyst
Medica
Wayzata, MN
05.2019 - 10.2021
- Complete quarterly QBRs for business segments (Commercial, Exchange, Government) and identify trends and solid stories that support financials
- Present QBRs to each segment and perform additional ad hoc analyses as necessary
- Create Qlik and Excel dashboards for various pharmacy functions (i.e
- Reconciliation), by using SQL in order to combine and manipulate large datasets in order to produce manageable data within our models
- Manage and house pharmacy claims data (PBM CET file), also combining other data sources (provider, prescriber, LOB, etc.) to our data in order to have additional information within pharmacy claims data
- Support our Commercial, IFB, Underwriting, Government, pharmacy ops teams via ad hoc analyses as needed
- Understanding PBM pharmacy contract, ability to analyze financials and determine value, work with PBM on a regular basis and work to create/maintain partnership
- Collaborated with cross-functional teams to identify opportunities for process improvement and increased efficiency.
- Improved internal knowledge sharing by developing comprehensive documentation outlining standard operating procedures for various tasks.
Lead Associate (Senior Financial Analyst / Project Manager) – Pharmacy Benefits
Willis Towers Watson
Bloomington, MN
05.2015 - 04.2019
- Perform financial analysis of current and proposed pricing deals from Pharmaceutical Benefit Management companies for employer groups/clients on a national practice level for various projects which consist of:
- Procurements/RFPs
- Audits
- Market Checks/Benchmarking projects
- Renewals/Contract Extensions
- Specialty Drug Diagnostics
- Present the above listed projects to our clients and advise them of which steps to take, according to our analyses/findings
- Work cooperatively with health and benefits group in order to complete a broad spectrum of projects for our clients in order to successfully consult them of the best direction to go in terms of evaluating overall health care benefits
- Build Statements of Work (SOWs) and budgets and assist in the selling process of the above listed projects to our current clients, along with prospective clients
- Manage and oversee the projects listed above to ensure each project stays on track, meets specified deadlines/milestones, follows the applicable timeline, and is completed in accordance to the set budget/scope
- Self-performance is tracked through an annual 1,400 – 1,500 billable hours, as well as a predetermined annual sales goal
- Enhanced client satisfaction with effective communication, regular progress updates, and prompt resolution of concerns.
- Evaluated team member performance regularly, providing constructive feedback for continuous improvement.
Financial Analyst – Trade Relations
Prime Therapeutics
Bloomington, MN
03.2012 - 05.2015
- Perform detailed contract analysis and offer a financial perspective of current drug manufacturer agreements and forthcoming amendments in order to provide maximum rebates to our Blue Cross Blue Shield clients
- Construct therapeutic class models in order to provide insight to which drugs to add/remove to formulary in specific drug classes in order to maximize possible rebates
- Provide pharmaceutical and therapeutic class net cost tables (P&T) for our quarterly P&T sessions for each BCBS owner client
- Manually price new drugs to the market using a specific formula based on average wholesale price, ingredient cost, and wholesale acquisition cost
- Provide rebate estimates to specific groups of BCBS clients, using a Microsoft Excel template that factors in generic dates, new rebates, inflation, etc
- Of specific products
- Use Microsoft Access on a regular basis to create queries, link data tables, and manage our quarterly data within the database
Education
Bachelor of Business Administration - Health Care Management
University of Minnesota
Duluth01.2011
Skills
- Writing advanced SQL
- Leadership
- Mentorship
- Advanced Data manipulation/configuration
- Contract Negotiation
- KPI Dashboards
- Data Modeling
- Product Innovation
- Process Efficiency
- Organization Skills
- Business Analysis
- Communication
- Data Analytics
- Strategy
- Consulting
- Teamwork
- Microsoft SQL Server
- Data Visualization
- Snowflake
- Financial Reporting & Analysis
- Process Improvement
- Client-facing
- Technical analysis
- Advanced Excel
Timeline
Pharmacy RFP Analytics Manager
RxConnection
07.2024 - Current
Pharmacy Data Analytics Consultant
RxBenefits
04.2022 - 08.2023
Healthcare & Pharmacy Advanced Analytic & Financial Consultant
Quantive Analytics LLC
10.2021 - 07.2024
Senior Financial & Analytics Analyst
Medica
05.2019 - 10.2021
Lead Associate (Senior Financial Analyst / Project Manager) – Pharmacy Benefits
Willis Towers Watson
05.2015 - 04.2019
Financial Analyst – Trade Relations
Prime Therapeutics
03.2012 - 05.2015
Bachelor of Business Administration - Health Care Management
University of Minnesota