John Nestor
Sales Operations Coordinator at Lahaina Galleries · Gray Collectables
Orange County, California, CA
In My Own Words
Detail-oriented Analyst who leverages a unique understanding of finance, sales, and business intelligence to provide robust modeling and reporting that supports high-level decision-making and organizational achievement. Skilled with identifying, analyzing, and reconciling data obtained from a variety of complex sources, both domestic and international. Expertise in the development and enhancement of existing processes and methods to support both internal and external analysis and decision-making. Rapidly adapts to new technologies and shifting requirements.
Work Experience
Consultant
Gray Collectables2014 – Present
Project manager, Business Analyst, cataloging and maintenance of estate collection. Pricing, marketing, and sales of antiques. Part-time project based position.
Senior Sales Data Analyst
Corbis/Branded Entertainment Network2011 – 2012
Design, maintain and deliver sales reporting supporting Executive Team and sales offices in the US, EMEA, and Australia. Customer reporting provides sales teams in 6 countries summary and/or detailed data on what products customers buy, seasonal spending patterns and increase/decline over time (KPI reporting). • Designed and developed automated daily, weekly, and month reporting saving Sales Operations personnel +20 hours in manual work weekly. Streamlined reconciliation between Sales and Finance on a monthly basis. • Set up and maintained flexible standard reporting allowing decision-makers easy access to multiple KPIs from a single data set. • Created method for defining products and customer relationships using SAP Business Objects variables and MS Excel. • Managed Sales performance reporting, calculated and tracked commission payout for the organization. • Designed self-serve analytics packages for sales personnel.
Sales Operations Specialist
Corbis/Branded Entertainment Network2005 – 2011
Organized, managed, and delivered daily updates of worldwide sales team achievement towards monthly and quarterly quotas. Analytical support and business partnering. • Subject Matter Expert supporting sales teams and sales operations personnel with issues involving order system, CRM, external website, and Microsoft Office products. • Built commission payout calculator enabling the early retirement of an outdated system that was costly to maintain. • Tracked salesperson interaction with customers and delivered summary reporting to Sales managers.
Education
Bachelor of Science
San Diego State University1989 – 1993
Bachelor of Science