Senior Sales Planning Analyst
Sony
Total years of experience :16 years, 4 Months
• Analysis of Weekly Branch performance report and highlighting areas of improvement
• Analysis of Channel weekly Sell thru report
• Analysis of Area weekly Sell thru report
• Competitors and market wide analysis reports
• Preparing Weekly Sell in Reports by Channel, Category and Customer using SAP BW reporting
• Creation of Quarterly Branches sell through targets and tracking them on a weekly basis
• Assisting Branch Head in preparing Quarterly branch plans
• Optimisation of SDF expenditure
• Driving SDF including ensuring appropriate ROI and approval processes
• Monitoring Branch Expense Budget and communicate with stakeholders on a monthly basis
• Monitoring Stock levels of products and highlights any shortfalls.
• Monitoring online Prices of Key channels and communicating with Sales Team
• Reporting on Promotional activity results and Highlights wins and losses
• Reporting weekly on Actual Sales vs Budget
• Reporting Monthly on Actual Sales vs Budget
• Tracking Daily volume against Budget and Forecasted Volume
• Quarterly Tracking account managers KPI targets using CRM
• Provide detailed reporting and assistance to deliver annual sales budgets
• Reporting monthly on PEP (Profit Enhancement Program) targets for business
• Monthly Rebates report
• Reporting weekly on Inventory position
• New products Setup
• Monthly Customer service workflow report
• Reporting Monthly on all Complaints
• Provide timely sales support to all sales staff internal and external
• Maintain system pricing
• Enter all customer contracts and update pricing when required
• Analyzing Customer’s Current Pricing vs Volume
• Manage Pricing contract expiry dates and update them where necessary
• Manage Price Increase and update system as required
• Manage PVA and CVA reporting daily
• Investigating Pricing Credits
• Ad-hoc administration
Sales Administrator Apr 2011 - June 2012
• Monitoring and reconciling rebate claims and accruals
• Creating Rebate ID relating to specific customer
• Scan data & promo verification: checking promo scan data and merchandising pricing
• Reporting- monthly, Quarterly, weekly reviews
• Investigating and verifying credit payments
• Completing New Customer Forms
• Creating and distributing relevant reports to various departments
• Handling customer and branch enquiries
• Ad-hoc administration
• Price list maintenance and price changes
• Maintenance of GS1 database
• Dispatching samples as needed
Private and Confidential
Pricing & Sales Support Officer Jan 2008 - Mar 2011
• Build key relationships with internal and external stake holders
• Raising Pricing Inquires in SAP
• Raising quotations and PPC in CRM
• Tracking and managing the notification list (complaints) in SAP
• Extracting pricing data for specific customers in SAP
• Maintenance of the pricing file
• Rebate report for Whole Qld Customers
• Reports for Sales team using Data Warehouse & Excel
• Preparing Gyprock and Fibre Cement warranties when required
• Preparing Relationship Agreements specific to customer rebates
• Setting up rebate Claims and organising payments
• Actioning Credits and Returns on customer accounts
Bachelor of Science (Computer Science)
GRADE 12