Juan Mayo Email & Phone Number

Vancouver, Washington, United States

Clackamas County, Oregon, United States

Fort Lauderdale, Florida

Financial Reporting, Budgeting, and manage Inventory. Oversee consignments and external audit reconciliations.● Revamp and automate reporting system using a combination of Excel and Power BI to reduce time and increase accuracy.● Build financial reporting for a new 300 million joint venture program, compiling inventory, sales, consignments, and valuations for reporting to senior management.● Implemented a system of analysis and reconciliation to reduce time spent on reconciling inventory from days to hours.● Developed Inventory Deck to review aging inventory in lot accounting and thus improving inventory rollover and increasing ROI often by 15-20 percent.● Lead LEAN initiatives to standardize processes within department increasing efficiency to allow a 3-day close from a 6-day close.● Lead SLRP planning and long-term budgeting, achieving a goal set by the company a year before arriving in the position.

Miami/Fort Lauderdale Area

Manage Revenue and Cost of Sales, Cashflow, Accounts Receivables, monthly reconciliation of most Balance sheet and P&L accounts, and Internal Audits.● Improved Collections via automated systems and reduced average days past due to under 7 days.Authored a spreadsheet for analyzing freight, which was able to identify needed chargebacks, saving fifteen thousand dollars since inception.Designed a system for creating journal entries that consolidated a process from 13 steps to 3 steps.Prepared an AR dashboard to show pertinent metrics to facilitate management review and reporting, adopted as a corporate system for all units.Created an auto calculating variance analysis spreadsheet to compare the P&L accounts based on the budget and last year’s actuals.Developed a cash flow system that automatically ages AR and AP based on variables, that reduced the forecasting process to 2 hours from 2 days.

Weston, Fl

Administer and record financial transactions, generate and deliver financial reports to CPA and owners, create client-side reporting.● Build an accounting system for small business from the ground up using excel.● Managed successful marketing campaigns that increased revenue by 45 percent.

Master'S Degree, Accounting, 3.7

Bachelor’S Degree, Restaurant/Food Services Management