Franklin Wheeler

Financial Analyst

Merck

2025 — Present

• Supported the delivery of FP&A activities (Monthly Close and Reporting, Budget, Long Range Operating Plan, and other forecasts) for the diverse portfolio of Pharma BU, including evaluation of performance relative to forecast in close partnership with marketing, contracting, and manufacturing. • Maintained strict focus on compliance, ensuring integrity of reported financial results and forward-looking estimates by leveraging analytical models and research tools, contributing to an effective transition and ongoing support of forecast automation. • Tracked and analyzed drivers of product performance (e.g. customer inventory and market demand assessments, market share, sales performance on a customer segment level basis). Assisted with presentations of revenue results and forecasts. • Partnered with the demand planning COE to submit and present accurate demand plans, a critical stewardship activity. • Supported implementation of best practices to ensure forecasting accuracy and contribute to the standardization and simplification of portfolio-wide processes where possible.

Contract Analyst

Merck

2022 — 2025

• Managed the Caremark GOVT CML and ReUnite Rx LLC contracts. • Accountable for contract adjudication, analysis, and customer interaction in support of Merck managed care agreements. • Supported internal stakeholders and provided a strong partnership with Merck external managed care customers in the administration, performance reporting, and analysis of all HP/PBM agreements involving discounts, rebates, and other payments based on the purchase and use of Merck products. • Advised and consulted with key internal stakeholders regarding contract terms and conditions. • Provided analytical and reporting support for the HP/PBM customer segment, leveraging in-depth knowledge of customer data, trends, and contract performance. • Built and developed internal and external customer relationships, including engaging in discussions to resolve issues and maintain and grow access to Merck products.

Distribution Services Analyst

Merck

2020 — 2022

• Analyzed, processed, validated, and resolved chargeback claims to ensure appropriate credit issuance within contractual requirements through extensive research of chargeback claim submissions to resolve discrepancies. • Performed trend analysis on wholesaler accounts over prior submission periods and sales history. • Analyzed and reconciled chargeback deductions for key accounts in ModelN and SAP, resulting in additional credits or recovery of payback. • Assisted in accrual reports and internal and external audits for the Finance Department. • Interacted with IT to create, design, redesign, and improve standard management sales reports. • Acted as Subject Matter Expert (SME) for the Model N system, providing training, problem-solving, and department expertise. • Negotiated to ensure Wholesaler/Distributor paybacks were agreed to and paid in a timely manner as they relate to ineligible claims and to resolve unjustified deductions. • Developed and maintained strong collaborative result-oriented working relationships with internal and external partners through excellent verbal and written communication skills. • Worked collectively with the team in identifying new process and system improvements and identified, resolved, or escalated repetitive or complex discrepancies. • Ensured SOPs were up to date. Ensured the team maintained a thorough understanding of chargeback processes and policies. • Analyzed large data files to provide accurate and meaningful information upon request.