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.

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.

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