JOHN TUFTS

*** **** *****

Old Hickory, TN *****

Phone: 615-***-****

Cell: 615-***-****

E-mail: ady4vc@r.postjobfree.com

https://www.linkedin.com/in/john-tufts-b2631144/

Operations / Data Analyst / Demand Chain Analyst / Logistics / Transportation

PROFILE

I managed an independent office supply dealership during the entry of the big box stores (Office Depot, Staples). I was responsible for: computer network, accounting, accruals, financial analysis, project cost, purchasing, inventory control, retail operations, warehouse, shipping and receiving, mergers and acquisitions, marketing, sales management and human resources. Under my direction, using aggressive door to door marketing, the corporation grew from $2 million to $5 million in three years.

My expertise is in detailed analysis: cost justification, projections, cash flow, customer retention, sales forecasting, sales quotas, compensation programs, man-power demands, and capital expenditures. I have done all business analysis from AR to warehouse performance and everything in-between. I enjoy inventory management, warehousing, order fulfillment processes, and operation efficiency.

COMPUTER SKILLS

45 wpm, 10,000 kph, Microsoft Windows, Word, Excel (pivot tables, VLOOKUP), Teams, Smart Sheets, PowerPoint, Outlook, Goldmine, NetSuite, Oracle, Platform Science and the Internet

EDUCATION

BS Degree in Business Administration, Minor in Computer Science. Graduated May 1990, San Jose State University, California.

OVERVIEW

My background is extensive. I have learned everything about business from the ground up at our family business doing virtually every job there was to be done and eventually taking over the leadership role. I have a strong work ethic that is based on a family business background. It shows in everything that I do.

EMPLOYMENT BACKGROUND

DOLLAR GENERAL (CONTRACT POSITION - Softworld)

DATA MANAGEMENT (July 2021 – July 2023)

Container Maintenance

* Manually processed receiving data from inbound containers to get inventory into the system.

* Tracked data errors and submitted tickets for resolution

* Processed information for outbound containers by pulling inventory from the system and submitting the container for pickup and delivery.

Import Center Data Maintenance

* Daily collected, scrubbed for errors and reported 200 to 400 lines of data problems from 6 import centers to the Demand team to write reference purchase orders.

* Used VLOOKUP to reduce time to verify the reported data items and make corrections

* Tracked the data errors and submitted tickets for resolution

* Resolved completed items and reported them back to the import centers.

Receiving Problem Portal

* Monitored, worked, and resolved receiving problems being reported by the distribution centers.

Authorization Codes

* Processed authorization requests for additional payments from carriers and import centers.

* Used pivot tables to summarize the lines and add authorization codes for the vendors to use when submitting payment requests.

TRACTOR SUPPLY (CONTRACT POSITION - Vaco)

DATA MANAGEMENT (July-November 2020)

Website Data Maintenance

* Imported and uploaded JPG and PDF files into the system

* Resolved conflicting image naming problems.

* Removed duplicate images

Mailbox Management

* Responded to all incoming vendor emails

* Verified spreadsheets that were sent, made corrections, and requested vendor assistance for problems.

* Resolved undeliverable emails from email blasts.

* Posted completed spreadsheets to data team for processing.

* Recorded all email correspondence in activity tracker for 700 vendors that were contacted and categorized the activities so we could easily determine if the vendor had completed the assigned project.

Vendor Calls

* Called all vendors that had not responded to request for information.

* Found initial request, found vendor contact information, called the vendor, communicated, and resent request.

* Logged all communications in the activity tracker.

P&E DISTRIBUTORS

DATA 2018-2020

The Returns Section – first three months

* Quickly and efficiently processed manufacturer returns of the largest and bulkiest items and gained work space.

* Created a plan of attack to balance returning highest dollar vendors and highest space taking vendors.

* Labeled all shelving units and assigned places for primary vendors that have regular returns.

The New B2B Website

* Upload data and images for 300,000 items.

* Maintain database and add new items weekly.

* Manage integrity of data and images imported by 3rd party vendor.

* Audit website functionality and correct errors that are found.

GENESCO 2014-2018

REPORT ANALYST

In charge of data entry and data integrity for all call center statistics.

* Created and maintained sixteen dashboards that track and report statistics for management including: Employee Master List, Employee Turn Over, Attendance, Payroll, Official Schedule, Chat ROI, Percentage of Contacts, Sales, and Trend analysis.

* Tracked down numerous Oracle report problems and the data that is coming out now is clean and accurate.

* Cleaned up all bad data entry back to beginning of 2013.

* Implemented Auto reporting from approximately 30 spread sheets into three primary summary spread sheets for the three internal call center companies that are represented.

* Reduced data input from 5 days a week to 1 day a week.

* Created procedure manual for the data entry.

* Increased my Excel skill set through hands on training. Using VLOOKUP, Pivot tables, Conditional Formatting, Freeze Panes, Data Validation, Filters, and Workbook Protection.

ARMOR CONCEPTS 2013

LOGISTICS MANAGER

In charge of releasing order fulfillments, purchasing, inventory control and overseeing the third-party logistics.

* Immediately did full cycle count on inventory and removed phantom inventory and bogus inventory locations and found lost inventory.

* Made immediate recommendations to eliminated dead inventory that was costing $800 a month to carry.

* Implemented Min Max system on all inventory items including parts, sub-assemblies and final assemblies. The computer system NetSuite could not do a usage full drill down on all parts and sub-assemblies. I created an Excel spread sheet using VLOOKUP and a Pivot table that allowed monthly sales to be input and would show usage down to the very last screw for all inventory usage.

SPHERION / Dell 2009-2011

MATERIAL HANDLER

You may ask why I was a material handler. This was the first job I could find when I moved from California to Tennessee. The job market was bad and there was nothing to be found and I wanted to work.

Accomplishments:

I was the shift lead in charge of 4 other people and managed the work flow. We scanned pallet loads of laptops, desktops, flat screens and servers. Properly labeled them with export stickers and loaded trucks. All items were scanned with RF scanner into Excel spreadsheet with shipping order number and serial number. The spreadsheets were emailed off to the supervisor with total counts and trailer number and license plate.

TUFTS CONSULTING LLC 2005-2009

CONSULTANT

Accomplishments:

My target market was independent office supply dealerships generating 1 to 5 million dollars in annual revenue. As a consultant, I examine how the client is using the back-end computer system currently and make recommendations for procedural improvements in every area of the business: AR, AP, Payroll, Purchasing, Inventory, and Order Entry. I perform a detailed walk through of the warehouse, and make recommendations regarding layout, picking manifests, shipping manifests, stocking and RMA procedures. The final step is a detailed examination of customer retention and implementing retention and growth programs.

TUFTS OFFICE SUPPLIES, INC.

OPERATIONS MANAGER 1986-2005

This is where my business background comes from.

Started as a stock boy and janitor at 12 years old.

Worked in the warehouse as order puller in high school.

Worked as a part time driver when I got my driver’s license.

Worked as accounting, purchasing and warehouse when I started college.

Was point person that brought in computer system and took accounting, inventory, purchasing and order entry live.

Implemented matrix pricing when the Big Box stores entered the market.

Implemented aggressive zip code marketing program that helped double the business in three years.

Warehouse Management

* Implemented a cycle count system. Eliminated inventory on hand errors and flagged problem filling items which reduced filling errors by 90%.

* Reorganized inventory in the warehouse by top hits and researched and implemented a picking manifest system. This increased order pulling by 300%.

* Researched and implemented ticket bar coding, scanning system, and shipping manifests. This reduced the time to get the trucks out the door by 50%.

* Introduced an automated routing system eliminating the need to route orders every day. This eliminated a full hour of routing every day.

* Devised a vehicle maintenance tracking system to ensure vehicles were maintained on time preventing costly repairs associated with deferred maintenance.

Retail Operations Manager

* Conducted market research on the competition and implemented a matrix pricing on all the items shown in the front room. This stabilized our position in the market and kept us from closing the business by the emergence of big box dealers in the market.

Purchasing

* Effectively increased the direct buy vs. wholesaler ratio from 25% direct to 50% direct, increasing the bottom line gross profit by 5%.

* Developed and implemented an automated low-stock report using a min/max system. Reduced on hand inventory so that it was closer to “just-in-time”, reducing the time spent stocking inventory. Result was releasing 30% of inventory in the form of cash.

Accounting & Financial

* A/R. We had 1600 active customers. I did weekly billing and sent monthly statements. I posted payments and made collection calls.

* A/P. We had 40 vendors and 1200 daily lines of purchasing. Verified purchase orders against vendor invoices, scheduled payments, and tracked returns to make sure we received our credits.

* Created detailed reports on customers, inventory, financial data, sales reports, and commission reports.

* Implemented rolling 12 month P & L spreadsheet to track expenses and check coding errors.

* Created a 5-year business plan emphasizing growth. The business plan marked all key points. Sales generated, sources of the revenue stream including existing trends, sources for new business and projected capital expenditures. Resulting in a 100% increase in sales.

Computer system

* Implemented a new back-end computer system. This process included 1) transferring all paper records of customers, vendors, and inventory, AR, and AP, 2) training all employees on how to use the system, and 3) taking the system live.

* Managed back-end system change-over from DOS base system to Windows based system. This allowed for report printing to text files so the data could be opened in Excel and analyzed in detail. This revolutionized customer retention and inventory control.

* Researched, learned and implemented an automated report generating system resulting in a 35% weekly time savings.

Mergers and Acquisitions

* Approached local dealers and negotiated buyout offers.

* When selling the corporation, I was in charge of providing all items related to Due Diligence

Operations Manager and Director

* Under my direction, using aggressive door to door marketing, the corporation grew from $2 million to $5 million in three years.

* Implemented margin controls in the computer system that raised overall sales margins by 3%.

* Steered the corporation to a heavier direct buy stocking position that raised the overall sales margin by 5%. This also increased the back-end rebate dollars by 100%.

Sales Management

* Oversaw the creation of an aggressive marketing program. This program allowed the company to more than double in three years.

* Conducted market research and adjusted sales commissions to the current market levels. This allowed us to retain our sales force and ward off head hunters.

* Oversaw the implement an account retention program. Using the Goldmine system, we scheduled regular calls and faxes to existing customers. We also set up a call schedule for customers that have not purchased from us to regain their business. Account retention increased 100%.

* Implemented an account penetration program. Using customer data analysis, we were able to determine what categories the customers were not buying from us and were able to target those markets to increase sales. This program increased sales by 25%.

Contact this candidate