SAP MS Outlook
Adept at leveraging strong computer skills and data analytics, I significantly enhanced label compliance and pricing accuracy at IFCO and Coca-Cola. Specializing in audit planning and internal controls evaluation, I streamlined processes, ensuring accuracy and efficiency. My proactive approach and ability to resolve discrepancies underscore my commitment to excellence and continuous improvement.
I monitor customer label compliance, making sure they correctly label each crate (so that they are correctly billed), and fined if they aren't compliant. I work with the service centers for internal audits to help improve the process.
In December I was responsible for updating contracts for 2019
I run various Inventory SAP reports daily
I monitor customer label compliance, making sure they correctly label each crate (so that they are correctly billed), and fined if they aren't compliant
Responsible for the extraction and loading of all on-invoice pricing data from BASIS to SAP; facilitate the onboarding of New Independent Bottlers; conduct comprehensive data analysis of current and future state pricing utilizing Microsoft Excel, MS Access, BASIS (AS/400), CONA (SAP), Achieve continual compliance with Coca-Cola's accounting practices, pricing policy, and SOX controls. Perform data integrity queries and reporting using Access and MS Excel.
- Serve as the point-of-contact for Account Managers, District Sales Managersand Sales Managers to expedite the resolution of pricing issues; identify, troubleshoot and resolve financial-related issues
-Quickly and accurately verify and enter on-invoice promotional pricing into SAP. - Perform validation and audits of work completed using RPA (Robotic Process Automation).
Performs analysis and prepares reports on Promotional exceptions to includeSarbanes Oxley requirements.
- Synthesize information from numerous perpetual inventory reports utilizing Excel
and Access. Including importing files from Access into Excel and running reports from them.
- Balance data reports running different queries from Access to do a dailybalance of the different reason codes. When I do the month end Journal entry, everything will be accurate.
- Send out weekly estimates using Access and Excel so that everyone knowswhere we stand for month end
-Research and resolve report discrepancies
- Produce month-end journal entries for accounting activity related to bothperpetual inventory and dropship division including using a pivot table. - Reconcile general ledger accounts affected by report adjustments (accounts include purchases, Price protection, Cost Adjustment, Wrong Product cost differential , perpetual quantity adjustments, cost of sales, and cost of returns, cost of sales promo adjustments)
- Reconcile inventory with claims of shortages or returns working with inventorycontrol
- Review POD's for claims of returns or not receiving the package.
- Utilize MS Access to record, track and balance daily totals of credits and debits
Strong computer skills
SAP MS Outlook
AS/400
Magic
Platinum
MS Excel
MS Access
MS Powerpoint
RLS (Returns locator systems)