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 increase efficiency. Expert in creating reporting and tools in order to make informed business decisions.● 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 on strategic planning and direct engagement with store managers, leading to a 19% increase in sales year over year.● 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 mistakes, reducing customer service costs and improving overall customer satisfaction.● 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 creation of a targeted contest that improved the brand’s sales performance from -22% vs LY to +1% vs LY.● 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, this collaboration has resulted in a 20% increase in year-over-year sales and a 9% reduction in average inventory costs.

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 program.● 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 real-time access to margin information, resulting in an 7% increase in sales conversion rates.● 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 optimization saved approximately 20 hours of manual work per week, improving overall efficiency and freeing up resources for strategic initiatives.● 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, leading to a 13% increase in webpage engagement and a 6% increase in conversion rates.● 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 satisfaction scores and a 9% reduction in processing costs.

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, writing additions to the Standard Operating Procedure manual, and training staff on new procedures.● 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 conduct more frequent and efficient spot checks, thereby improving overall inventory management.● 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% reduction in special order errors over six months.● 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 improved transaction efficiency by 18%.

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 approach improved inventory turnover by 6% within the first year.● 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 average profit margins by 1% and reduced pricing discrepancies by 4%.

Bachelor Of Science, Applied Mathematics

Certificate, Consumer Science And Merchandising