John Nestor Email & Phone Number

Newport Beach, California, United States

Orange County, California Area

Project Manager, Business Analyst, Sales and maintenance of estate collection.

Orange County, California Area

Seasonal employment with the County of Orange during the 2018 mid-term elections. Support Registrar operations and educate voters on the registration process and voting options.

Greater Los Angeles Area

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).• Refined Sales Operation processes and workflows using Business Objects automation and MS Excel to deliver accurate daily, weekly, and monthly revenue reports and media… Show more 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).• Refined Sales Operation processes and workflows using Business Objects automation and MS Excel to deliver accurate daily, weekly, and monthly revenue reports and media analytics.• Designed and maintained +100 ad hoc reports supporting Sales, Sales Management, Finance, Research, and channel partner data request.• Managed sales targets achievement tracking and commission payout calculations of a complicated sales compensation plan involving tiered customers and variable account assignments.• Created master budget workbook, and other essential tools used by the organization.• Developed an off-line database tracking customer sales history from two CRMs enabling trending, seasonality (buying patterns), and customer/client analysis of both brands from a single source file.• Designed and developed automated daily, weekly, and month reporting saving Sales Operations personnel +20 hours in manual work weekly.• 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.• Developed MS Access database for managing unstructured data from multiple source systems.• Liaised between Sales, Finance and Business Intelligence (BI) translating the needs of the business into technical terms enabling the development of custom objects in the data warehouse. Show less

Organized, managed and delivered daily updates of worldwide sales team achievement towards monthly and quarterly quotas.• 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… Show more Organized, managed and delivered daily updates of worldwide sales team achievement towards monthly and quarterly quotas.• 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. Show less