John Mcfadden Email & Phone Number

Toronto, Ontario, Canada

Toronto, Canada Area

• Reporting to the Finance Director and Vice President, Sales, produce gross and net forecasts for all physical and digital video accounts (including Amazon.ca, Wal-Mart, Apple, Google). Responsible for Canada forecast.
• Successfully implemented the U.S. team’s account planning process in Canada as part of a high-profile Canadian restructure, including coaching, mentoring, and training a newly assigned team member.
• Created regression models with key driver smoothing to forecast with a +/-5% error for 2019 digital sales.
• Facilitated (identifying opportunity, analysis, influencing) a re-price of 10% of the theatrical catalog segment at Apple resulting in 47% base growth over 8 weeks compared to 10% base growth for non-re-price SKUs.
• Calculated new net margins for sales goals and financial budget after significant catalogue re-price (1,000+ SKUs) to reflect the new gross revenue, returns, and trade spend required to achieve net revenue targets.
• Directed and created quarterly business reviews for sales team and management, increasing the effectiveness and accuracy of reporting on Canadian business, thereby instilling confidence in U.S. executive team.

Toronto, Canada Area

• Reporting to the Vice President and Director, Sales, accountable to provide management with accurate sales team forecasts and reporting and to determine sales goal by customer to minimize achievement % standard.
• Automated the forecasting process for the sales executive team by implementing user-friendly excel models, increasing forecasting accuracy and leadership confidence in quantitative skills of the sales department.
• Developed a statistical forecast model, in collaboration with a cross-functional team including marketing and finance, to accurately predict theatrical new release sales for budget and decrease achievement variances.
• Optimized use of business objects and data warehouse by the sales, marketing and finance teams through group and individual training, increasing reporting effectiveness of new and existing employees.

Toronto, Canada Area

Handled by-title DVD forecast using Excel models. As Essbase administrator, reported monthly P&L statements to home office. Coordinated DVD unit, revenue, product cost actual and forecast spreadsheets. Engaged in various analysis as required.

Toronto

Played a key role working with financial planner by creating Excel file to produce DVD budget units and revenue. Oversaw A/R for Zellers, Costco and Loblaws. Managed budget and sales analysis spreadsheets for controller and senior financial analyst.

Bachelor Of Commerce (B.Com.), Honours Business Administration, Graduated With Distinction

One of four students to graduate with distinction in a graduating class of 92 students.

Bachelor Of Science (B.Sc.), Chemistry