Summary
Overview
Work History
Education
Skills
Certification
Websites
Awards
Timeline
Generic

Dean Elliott

Pickering,ON

Summary

Results-driven Sales Operations Analyst at HMFT Inc. with expertise in data analysis and customer service. Proven track record in optimizing CRM systems and generating actionable insights through Power BI. Skilled in pricing analysis and report writing, enhancing sales strategies to drive revenue growth. Adept at leveraging research skills to identify key opportunities.

Overview

12
12
years of professional experience
1
1
Certification

Work History

Sales Operations Analyst

HMFT Inc.
Pickering, Canada
04.2023 - Current
  • Reviewing daily MSIs (Meaningful Selling Interactions) and attend daily MSI meetings that are held by sales management.
  • Doing bottom-up research by digging into the following types of accounts: Dormant - those who used to buy more and have decreased their spending either in total or for specific product lines. Key Accounts - looking at large accounts that have been designated key and looking for more opportunities. Target Accounts - looking at large potential accounts both with small accounts that are underrepresented from a revenue perspective, and also looking at 'like' accounts to current large customers.
  • Setting up opportunities based on the research in Netsuite: Dormant opportunities - what to go back after very clearly outlined and provided to the sales team through the CRM system. Target opportunities - newly identified account that should be buying certain products or more. Void Matrix opportunities - what product line to sell to existing customers that they should be buying but currently are not.
  • Creating research summaries on Dormant Accounts, Key Accounts and Target accounts that summarize all the relevant data from our CRM/ERP for the sales representatives to be as effective as possible.
  • Being part of the regular meetings around Dormant Accounts, Key Accounts and Target Accounts, providing feedback and adjusting from outcome of meetings accordingly.
  • Ultimate responsibility for a clean CRM i.e. categorization of customers, reporting, contacts, cleaning out old quotes and opportunities etc.
  • Handling case requests from the sales team about research of contacts by using ZoomInfo and LinkedIn Sales Navigator.
  • Creating data visuals in Power BI to identify and analyze sales trends and insights.

Pricing Analyst

Malpack
Ajax, Canada
06.2021 - 04.2023
  • Updating product pricing based on monthly changes to Resin Indices, such as CDI and IHS
  • Conducting daily price deviations from index pricing to increase business volume
  • Conducting weekly and monthly sales reports of products shipped and ordered for all salespersons in Canada and the United States
  • Conducting weekly and monthly price audits to account for price deviations and investigating discrepancies.
  • Performing pricing and sales analysis through the extensive use of Pivot Tables and VLOOKUP in Microsoft Excel

Sales, Data Entry, Office Administrator

All Steel Doors
Toronto, Canada
05.2019 - 06.2021
  • Processing and preparing complex work orders for steel doors, frames, and parts from customers.
  • Answering customer phone calls and emails about orders
  • Calculating prices for customer orders
  • Processing Accounts Receivables and Payables
  • Sending acknowledgements of orders to customers
  • Preparing and sending invoices to customers for payment
  • Preparing door and frame labels for manufacturing department
  • Calculating complex machine cut sizes for the manufacturing department for frame orders
  • Scheduling shipments and preparing bills of lading for shipping
  • Count and maintain inventory of all supplies and equipment
  • Ordering supplies for office and manufacturing departments
  • Conducting research and development for company
  • Assisting General Manager wherever required

Sales Associate/Clerk

Sears Canada
Pickering, Canada
02.2014 - 01.2018
  • Greeting customers, responding to questions, improving engagement with merchandise and providing outstanding customer service.
  • Operating cash registers, managing financial transactions, and balancing drawers.
  • Maintaining store inventory and achieving established goals.
  • Directing customers to merchandise within the store.
  • Maintaining superior product knowledge.
  • Maintaining an orderly appearance throughout the sales floor.
  • Introducing promotions and opportunities to customers.
  • Cross-selling products to increase purchase amounts.

Education

Diploma with Honours - Business Administration and Management, General

Durham College
Oshawa, ON
05.2015

Bachelor of Arts - BA - Geography/History

University of Toronto
Toronto, ON
05.2012

High School Diploma - Business, Math, Geography and History

Dunbarton High School
Pickering, ON
06.2007

Skills

  • Analysis
  • Customer Service
  • Data Analysis
  • Mathematics
  • Microsoft Excel
  • Microsoft Power BI
  • Microsoft Word
  • NetSuite
  • Office Administration
  • Pricing Analysis
  • Report Writing
  • Research Skills
  • Sales Administration
  • Sales Analysis
  • Tableau
  • Vlookup

Certification

Certified Scrum Product Owner (CSPO) - Scrum Alliance

IBM Business Intelligence Analyst Certificate

Tableau Certified - TestDome

Websites

Awards

  • Honor's Roll, 05/01/15, Durham College
  • Dean's List, 05/01/09, University of Toronto
  • Dean's List, 05/01/08, University of Toronto
  • Ontario Scholar, 06/01/07, Dunbarton High School
  • Honor's Roll, 06/01/07, Dunbarton High School

Timeline

Sales Operations Analyst

HMFT Inc.
04.2023 - Current

Pricing Analyst

Malpack
06.2021 - 04.2023

Sales, Data Entry, Office Administrator

All Steel Doors
05.2019 - 06.2021

Sales Associate/Clerk

Sears Canada
02.2014 - 01.2018

Diploma with Honours - Business Administration and Management, General

Durham College

Bachelor of Arts - BA - Geography/History

University of Toronto

High School Diploma - Business, Math, Geography and History

Dunbarton High School

Similar Profiles

CREATE PROFILE
Dean Elliott