Financial Reporting - Month End Close Process - Adherence to closing agenda timeline - Prepare the monthly inventory physical count procedures across all locations Ø Follow-up with plant controllers to resolve all issues that may rise during the count process.
Ensure that the count is performed according to Pepsico's policies and procedures Ø Communicate/analyze physical count results and provide justification to management regarding the count differences.
Get the approval of management as per the SOA on the count differences and reflect such differences on SAP - Conduct monthly detailed Balance Sheet review for all Inventory levels together with the necessary aging and COC - Highlight of any balance sheet risks - Prepare the inventory reserve analysis, secure needed approvals and ensure proper recording.This reserve analysis consist of
Finished goods
Raw materials
Spare parts. - Monitor the inventory in transit between all locations and warehouses. Investigate for any up normal activities in the transit areas - Check the unit price per category in B/S vs. COGs - Update the FG auxiliary report with the PBI variance capitalization manual entry (Beverages Only) - Check the ending balances on Inventory GL accounts are reconciled with the Auxiliary reports for each inventory category - Ensures no negative inventory stocks at month-end - Update the supplier allocation sheet: R&P ending stock from auxiliary report, receipts from MB51, PO price/unit t-code ME2N
Monthly tracking for breakage, damaged products and expired products by; (Beverages Only) Ø DC Ø Price point Ø SKU
Prepares monthly inventory deck comparing actual vs. previous month and last year Issue monthly Operations Deck Write-off process; Ø Responsible for the write off process across all locations Ø Prepares the write off analysis and secure the needed approvals BSR preparation on a quarterly basis Monitor the implementation of the policies and procedures. This include the followings:
Enforce execution of approved local SoA
Enforce execution of Inventory process and procedures
Report any violations/exceptions to OPS controller
Identify any process gap and enhance the workflow to optimization and share the results with the OPS director
Partner with SC director to conduct annual MIM routine risk assessment workshop
Conduct the annual fraud risk assessment with SC Sr. director
Follow-up to close all internal audit points, Corporate audit points as per the recommended deadline
Ensure proper execution of COSO controls
Ensure timely GCS testing (Quarterly)
Support the OPS controller in the Preparation of the audit committee
Perform sudden visits to all warehouses to perform sudden counts
Manages KPMG requirements for Supply chain (should be monthly process going forward)
Review all SC contracts and evaluate costs
Attend S&OP meetings and engage to enhance MRP process
Manages WC initiatives, DII and forecast accuracy
Qualifications
Finance / Economics degree from an accredited school
Minimum 2 years of experience.
Ability to work on own initiative and within a pressurized environment.
Excellent customer service, interpersonal and communication skills.
Excellent command of Arabic and English language.
Problem solving skills.
Ability to adapt to change and work with different stakeholders coming from different backgrounds
Proficiency in Microsoft office, numerical & analytical skills, presentation skills, high level of communication skills, and ability to work under pressure.
