Trevor Forrest

ERP Administrator / Business Systems Analyst with extensive experience in accounting operations, ERP administration, business process automation, and systems integration. Skilled in Accounts Receivable, reconciliations, journal entries, SQL Server development, PowerShell automation, REST API integrations, and custom reporting. Proven track record of designing automated solutions that eliminate manual work, improve data accuracy, and streamline manufacturing and accounting processes across multiple departments.

Strong analytical problem solver with expertise in Plex ERP, Microsoft SQL Server, and workflow automation.

Business Systems Analyst at Aalberts Surface Technologies (2026-04 – Present)

• Develop and maintain ERP integrations using Plex Web Service and Developer REST APIs.
• Design and implement Process Flow automations to eliminate manual business processes and improve operational efficiency.
• Develop PowerShell automation scripts for ERP integrations, data validation, scheduled processes, and mass updates.
• Design and maintain Microsoft SQL Server databases, custom tables, stored procedures, and reporting solutions.
• Build custom operational and management reports using SQL Server and ERP data.
• Create API-driven data synchronization between Plex ERP and SQL Server to improve reporting accuracy and reduce manual effort.
• Collaborate with accounting, operations, quality, engineering, and IT teams to identify and implement automation opportunities.
• Troubleshoot ERP integrations and optimize business processes across multiple manufacturing locations.

ERP Administrator / Accounting Support at Variety Die & Stamping (2017-10 – 2026)

• Reconcile consignment inventory and customer usage to ensure accurate invoicing and account balances.
• Post customer deposits, apply cash receipts, and maintain AR subledger accuracy.
• Prepare and post journal entries to support month-end close and financial reporting.
• Investigate and resolve customer account discrepancies and payment issues.
• Design and maintain ERP-integrated reporting tools to automate reconciliations and improve data accuracy, saving time and reducing errors.
• Collaborate cross-departmentally to streamline invoicing, shipping, and production reporting processes.
• Provide ongoing ERP support, training, and workflow optimization across multiple departments.

Co-Manager at Little Caesars (2013-08 – 2017-10)

• Managed daily operations and staff training across four franchise locations.
• Oversaw cash handling, sales reporting, and inventory control to ensure operational accuracy.

Associate in Applied Science in Accounting – Washtenaw Community College

Certificate in Accounting for Business – Washtenaw Community College