Sales Coordinator and Administrator

The main purpose of this position is to provide administration support to the Sales Team, including support on all sales processes in a manner that promotes excellent customer service contributing to customer retention and growth.

Processing of applications/requests
Assist with required documentation (i.e. traveling, de-installations, re-installations, repairs, new installations and after hour work, etc.)
Generate CCP quote on CCP and do the pro-forma invoice to accompany the CCP quote (when SR/AM is out of office)
Report required for processing of transfer of ownerships
Manual Quoting
Creation and updating of the costing modules to calculate correctly.
Creation of quote in Microsoft Word
Crucial for Costing and layout of the Word doc to be correct and layout to be professional and consistent.
Generate Pro-forma invoices.
Assist clients with queries where possible and liaise with relevant departments to resolve, provide feedback to account manager and client.
Identify and resolve customer issues where required.
Collaborate with internal company departments (e.g. sales, finance, technical, operations and senior management)
Update customer data base and customer information CRM database
End of term reports generation from business systems
Pre-billing reports generation from business systems
National Pipeline Consolidation
Pipeline creation/updates with advanced excel formulas and formatting.
Preparing of data for seamless import into Microsoft Power BI
Maintain National Call Cycles
Creation of Fitment Schedule
Business target calculation on products sold into the market (Nested IF + Lookup combination formula)
Data reconciliation for use by Senior Management
Database
Preparation of datasets for further recon in excel, which includes functions such as pivot tables, nested IF formulas, appendment of data, pivot charts/graphs, conditional formatting with the use of formulas, data validation & form controls
Comparison of Sales Leads vs. LTV
Lookup formulas for various data
Stock forecast based on pipeline
PowerPoint presentations - assistance and creation thereof
Costing calculations and sheets
Creation of Leave schedule
AR document creation
Giving training on internal processes and procedures
To adhere to all Departmental and Company Policies, Procedures and SOP's.
To complete any other task or duty management may reasonably expect of you.