Overview
This is a Foodservice Analyst role for all contract setups and payments (current, renewal and new contracts). Role will include contract management, expired tactics and all payments. Creating a strong relationship with Sales (KAM / FSRs) and Finance. This role requires analytical thinking, flexibility to adapt to changes, proactiveness and relationship-building skills.
Responsibilities
Ensure accurate and timely delivery of tasks outlined below
- Build a working relationship with division teams and understand the work to be completed
- Work closely with the current HBS West Division FS team as well as with PBNA Division SMEs to learn the contracts, payments and legal processes and details
- Request, review and maintain files
CONTRACT SET UP & MAINTAINENCE (process steps may vary by Division based on Finance requirements)
Review BAM vs ContractContact the contract owner / FSR with a list of items that do not align with the BAMUsing Finance approval email, setup contract as writtenSetup the contract's tactics in TPMEstimate combined DSD & PDP annual rebate payments per Sales Location based on BAMAdd FOBO information in the tactics to include their portion of the payment(s)Verify if there is OTS funding supporting this contractEnsure documentation is saved for all fundingAdd the supplier number to the tactics and roll all tactics for the term of the contractSend email confirmation to contract owner of completed TPM setupCONTRACT SET UP & MAINTAINCE- 3POs or Third-Party Operators (process steps may vary by Division based on Finance requirements)
Setup 4 quarterly BASE tactics for all B&C set at a rate determined by FinanceWeekly reports are sent to the Sales Team with performance status and SKU requirementsThe accrual rate is adjusted based on performance and forecast 2-3 days before quarter-endA final report for the quarter is distributed to Sales and TPM TeamsDid the customer have net revenue growth to earn a paymentDid the customer meet all the SKU requirementsContact Sales Team to inform them that SKUs were missedPayment is denied and tactic moves to Completed statusPrint a pdf of the Finance report and attach as backup to the payment in TPMAdjust the amount to match the report from Finance and approve the paymentSend email confirmation to contract owner and Channel Manager of approved paymentCONTRACT ROLL OVER (process steps may vary by Division based on Finance requirements)
Quarterly check whether customer contract has a VTH (Volume Threshold) or auto renewal clauseIs VTH (Volume Threshold) met by the customerThe backup report is attached based on which the rollover period is determinedRollover is created in the TPM for all the rebates tacticPAYMENTS (process steps may vary by Division based on Finance requirements)
Monitor all pending payments in TPM. Manual and volume based Payment require Hub to interact for payment.What is the payment type? (PDP or Dual DSD & PDP)Lookup the distributor name by pulling a PDP report in ERTRequest a volume report from the KAM providing the COF, delivery address, distributor name and specific timeframeThe report is formatted and the payment calculations are added for backupRun a DSD volume report and add volume to payment calculations if neededIs a volume or net revenue report needed to validate the payment? (adjustable lump sum or rebates)Assigned to Sales Team runs the DSD ERT report, formats it and calculates the paymentRequest a volume report from the contract owner providing the FOBO name, delivery address and specific timeframeThe report is formatted and the payment calculations are added for backupThe FOBO payment request is adjusted and completed in TPM with a new payment dropping the next dayDoes the automatic payment (Advance and EOY) in TPM need to be adjustedContractual lump sum payments not tied to performance requirements are moved to KAM Manager Review statusStandard in arrears payments (typically EOY) are adjusted based on the backup report and moved to KAM Manager Review statusThe backup report is attached to the payment and it's moved to KAM Manager Review statusThe SPA-Finance Team creates the manual payment, attaches the invoice ( Marketing fund) and moves the payment to KAM Manager Review statusEmail is sent to contract owner and Channel Manager with any backup documents and confirmation of approved paymentNotes are added to the LTA or tactic to avoid accidental approval until the payment is ready forReminder emails are sent to the contract owner and Channel Manager on a Period basis asking for status of payment until completedIf the payment will never be paid, the payment is denied and the tactic is closedQualifications
Bachelors in finance or economicsStrong knowledge of MS Office programs specifically ExcelHave 1+ years’ experience using SAP & Oracle platformsPropensity to learn PepsiCo software systemsHighly organized and responsive, with ability to work to SLAs and tight deadlinesBest-in-class time management skills, ability to multitask, set priorities and planExcellent written and oral communication skills; proactively communicates using appropriate methods for situation and audience in clear, concise and professional mannerAbility to provide superior customer serviceLanguage Skills – Fluent English