John Wilkinson Email & Phone Number

New York, New York, United States

• Responsible for all aspects of the Certified Pre-Owned business from beginning to end. Present analyses and business plans to C-level management. Expert in analyzing processes and using technological solutions to.
• Created a distribution tool using a combination of Crystal reports and Excel macros, reducing time spent on distribution by 75%, from over 4 hours to under 1 hour per week. This efficiency gain enabled the VP to focus.
• Developed a VBA-based tool for specification entry, cutting data entry time by 50% and reducing errors by 99%. The improved accuracy and efficiency resulted in a 30% decrease in customer callouts due to website.
• Created a dashboard to track daily sales and inventory, providing real-time insights to the CMO. This tool allowed the department to swiftly identify when sales of a specific brand took a downturn, enabling the.
• Constructed accurate monthly forecasts to drive strategic buying decisions and developed a budgeting tool in conjunction with the CFO, basing target inventory on projected sales forecasts. Since its implementation.

New York, NY

• Responsible for all digital aspects of the Certified Pre-Owned business, including sales and merchandising on Tourneau.com, content for various social media platforms, operations, and managing the Sell Your Watch.
• Created and automated a Cost/Margin report using Crystal Reports, enabling management to make informed decisions remotely via mobile devices. This enhancement empowered store management to close more sales by providing.
• Developed a method to convert a single product attribute spreadsheet in Excel into uploadable data for two disparate platforms during a website platform transition, reducing employee workload by 50%. This process.
• Conducted an in-depth analysis of competing watch buying websites, presenting the findings in an easy-to-read report, and crafted suggested copy for the webpage. This analysis informed strategic content creation.
• Introduced multiple efficiencies to the Sell Your Watch process, reducing data entry time by 83% and improving customer payment processing time by 13%. These optimizations resulted in a 21% increase in customer.

New York, NY

• Responsible for a diverse range of projects aimed at improving all aspects of back office operations at Tourneau. This included testing and documenting POS updates, creating and automating numerous Crystal reports.
• Mapped external data from RGIS into internal data, enabling internal auditors to perform spot checks for inventory accuracy. This integration reduced the time required for inventory audits by 30%, allowing auditors to.
• Created a custom database using Microsoft Access to track special order errors. Reporting based on this database enabled the operations team to target underperforming stores and focus on key issues, resulting in a 22%.
• Trained store management on a mobile POS system in a 'train the trainer' session, then created reporting to track adoption of the new procedure. This initiative led to a 90% adoption rate within three months and.

New York, NY

• One of two merchandisers responsible for the intake, pricing, and distribution of pre-owned goods to over thirty stores nationwide.
• Initiated a better distribution procedure by analyzing current stock in each location, sales by brand and model, seasonality of certain items and locations, and making projections based on this data. This data-driven.
• Standardized the pricing procedure to take into account a number of different online retailers and auction sites, along with previous sales data and rate of turn, to maximize profit. This standardization increased.

Bachelor Of Science, Applied Mathematics

Certificate, Consumer Science And Merchandising