Aaron Smith Email & Phone Number

Orpington, Gb

London Area, United Kingdom

London, England, United Kingdom

London, England, United Kingdom

Senior Commercial Analyst in Business Development Team at Canon EMEA- Creation of reports to track Sales, Forecast, Budget, Stock, Allocation and Investment Data- PBD Lead for Budget Process- Creation and implementation of Commercial Models- Strategic Agreement process owner

London, United Kingdom

Roles and Responsibilities- Management of Retrospective Rebates through Investment Management system (Demantra) for EU18 Countries. This includes checking contracts for DoS/SGA terms and ensuring they are correctly entered into the system to build the appropriate accruals.-Management of Payment Exceptions to ensure partners are paid via the correct financial journals.- Calculation of different Advertising and Marketing Funds during Budgeting rounds (2 rounds a year).- Maximising channel margin contribution by making Canon's investments transparent and creating insights from the data. - Enforcing Commercial Model for different product groups and advising Product Managers on changes to the model. - Creation of Ad-Hoc reports and data to be used to make important decisions on investments. - Communicating updates and changes within Commercial Operations Team through weekly calls with EU18 users. - Working with Internal and External auditors on compliance audit.Gained Experience and Achievements- Working with Excel, Power Point, Outlook, Microsoft Teams, Oracle and Demantra weekly- Working with Reporting, Sales and Finance teams to create transparency surrounding key investments such as Strategic and Pan European Agreements, as well as the effect they have had on sales- Working with the auditing teams, we were able to reduce 7 deficiencies in 2019 to 0 deficiencies in 2020. Done through improving and adjusting business processes such as adding a contract check into the Rebate process- Assisted in communicating big changes to Projector and Pro Video commercial models, creating documentation and supporting users through the change process of setups in our Investment Management system.- Harmonising process between Demantra and Oracle, 2 systems used to set up different rebates.- Creation of a Margin Contribution report, breaking down different investment types and how they have contributed to Sales. This visibility previously did not exist in the business.

London, United Kingdom

Roles and Responsibilities- Managing and maintaining relationship with data provider (CONTEXT) for smooth transition of Sales and Stock data, primarily from EU18 Countries, into Canon Europe. Est. 700 partners data is collected, both from Retailers and Distributors.- Quality Checking to ensure correctness and completeness of the data. Examples include checking for large jumps in sales figures, exclusion of reported sales of used, second hand and "grey" products, and accuracy of product/customer information. - Creating business requirements for improvements in reports and processes, and working with data provider to ensure these are delivered in a timely manner. Improvements were both for personal ideas of improvement and business needs.- Working with data users from around Europe on various queries concerning the data and updating of the Customer Database in Canon. - Providing training and general updates to users on any changes/improvements taking place in the data and reporting systems. This was done usually face to face or through Skype Meetings and Newsletter Emails. Gained Experience and Achievements- Working with Excel, Power Point, Qlikview, Oracle, Sharepoint, Sway and Outlook on a regular basis.- Occasionally using SQL Management Studio to extract information- Improvement of organisation and communication skills- Worked with CONTEXT to create a new report specifically to allow Account Managers to measure the quality of the reporting of their partners, and worked with them to improve overall data quality.- Orchestrated improvements to Canon's Customer Database to make it more user friendly and relevant for data users. - Created lots of documentation to empower the business through knowledge and ensure smooth transition when moving roles.

London, United Kingdom

Customer Assurance Manager on Market Intelligence side of the business.- Answering a range of enquiries from subscribers of CONTEXT products, primarily IT vendors looking at Enterprise products. Enquiries include questions on channels, changes in the market, data within the reports, methodology and other areas.- Maintaining client relationships through regular communication of changes and CONTEXT news.- Handling various User Access requests.-Liaising with different teams within CONTEXT to discuss requests and changes which will effect clients as well as changes which will have an internal effect.- Logging requests using OpenCRM.

London, United Kingdom

Project Manager in a Data Channel Management Role, delivering a service to an IT Vendor Client.- Main point of contact for client and internally for project- Overseeing and assisting in all activities related to the project- Regularly communicating with the client to discuss the progress of the project, new requirements and agree on timelines for completion- Translating client requirements into tasks and allocating these tasks to project team- Discussing internally the progress of the project and providing updates to Executive team members- Collaborating with other Project Managers to discuss common affairs and solutions to problems- Answering enquiries received from the client and the users of the project data

London, United Kingdom

Assistant Project Manager in a Data Channel Management Role.- Maintaining a close relationship with IT vendor client- Assisting Project Manager in the coordination and collection of data from around 200 distributors of client for deliver in customised reports- Regular contact with client to give updates on existing requests, communicate progress and discuss new requests- Assisting with the answering of enquiries and solving of problems - Checking the quality of the data which is delivered to the client- Creation of Excel documents to communicate KPI progress to client- Management of users access to the data and Excel documents

London, United Kingdom

Junior Project Manager in a Data Channel Manager Role- Assist the project team behind the scenes in any tasks- Contacting distributors to enquire about missing data and communicating this to Project Manager- Quality checking client reports to check for any errors which may be present- Creation of Excel documents used to communicate updates to client

London, United Kingdom

Leading the customer service/checkout department. Day to day activities included: - Continuously setting an example to be followed by members of staff- Queue management, customer assistance and employee break management - Keeping Checkout team up to date with company news and changes to procedure- Ensuring Checkouts were ready for trade before and after trade hours, as well as ensuring they are kept tidy during trade hours- Cash handling and reporting- Communicating the condition of department to line manager. Maintaining employee satisfaction, as well as maintaining professionalism and organisation was key to ensure things ran smoothly.

London, United Kingdom

Part-Time weekend role whilst studying at university. Day to day activities included:- Serving customers on the Checkouts, Kiosk, Customer Service desk and self-scan machines- Ensuring there is a sufficient amount of baskets at the front of the store and Assisting in returning unwanted products to their aisles- Occasionally helping other departments in the store when they are short staffed- Maintaining a high standard of customer service throughout the day whilst working with efficiency