Warda Alhumaidi
Carrollton,TX
Summary
FP&A Analyst specializing in PBM economics, commercial underwriting, and portfolio forecasting for multi‑billion‑dollar books of business. Translate rebate, guarantee, and utilization changes into portfolio‑level P&L insights through advanced financial modeling, pricing analysis, scenario planning, and process automation. Drove near‑100% data accuracy in MCIS while auditing hundreds of manufacturer contracts and built Power BI dashboards to track underwriting workload and turnaround for executive visibility. Advanced Excel/VBA and Power BI.
Overview
4
4
years of professional experience
Work History
FP&A Analyst - Commercial Underwriting
CVS Caremark
Irving, Texas
10.2024 - Current
- Conduct underwriting and financial analyses for PBM pharmaceutical contracts valued at $1B+, assessing pricing structures, rebate economics, utilization trends, and overall profitability.
- Quantify financial impact of rate and contract changes through detailed variance and scenario analysis.
- Supported client and broker negotiations by delivering data-backed financial insights on pricing concessions, rate adjustments, guarantees, and contract terms, enhancing decision-making.
- Partnered with negotiators and contract analysts to validate assumptions and ensure financial accuracy, contributing to contract integrity.
- Refined Power BI tracking system to monitor underwriting progress, workload, and turnaround times, improving visibility into operational metrics.
FP&A Analyst - Manufacturer Contract Information S
CVS Caremark
Irving, Texas
09.2022 - 09.2024
- Contributed to launching MCIS by entering and auditing hundreds of manufacturer rebate and bid contracts to ensure compliance and accuracy.
- Led large-scale remediation of legacy data, establishing MCIS as a single source of truth with near-100% accuracy
- Collaborated with engineers in daily stand-ups to identify and implement enhancements in system functionality and usability.
- Completed project management training and applied methodologies to drive effective system enhancements.
- Owned monthly reporting after team restructuring, delivering six reports across three lines of business.
Finance Intern
Provision Capital
Dallas, Texas
01.2022 - 05.2022
- Evaluated 100+ properties, conducting market comps to support investment decisions.
- Detected financial discrepancies, resulting in $30K+ savings through data validation and audits.
- Streamlined record-keeping by integrating investor data into management software and assisting in month-end close for accurate financial reporting.
Education
Bachelor of Science - Finance
The University of Texas At Dallas
Richardson, TX05-2022
Skills
- Financial modeling, forecasting, and analysis
- Commercial underwriting, pricing strategy, and rate impact analysis
- PBM and healthcare economics (rebates, utilization, guarantees)
- Advanced Excel (macros/VBA, complex lookups, scenario modeling)
- Process improvement, automation, and scalability
Timeline
FP&A Analyst - Commercial Underwriting
CVS Caremark
10.2024 - Current
FP&A Analyst - Manufacturer Contract Information S
CVS Caremark
09.2022 - 09.2024
Finance Intern
Provision Capital
01.2022 - 05.2022
Bachelor of Science - Finance
The University of Texas At Dallas