Devan Duncan Email & Phone Number

Grand Ledge, Mi, Us

Schaumburg, Illinois, Us

Developed and maintained custom General Ledger (GL) reports in CSV, XLS, and PDF formats using MSSQL Server queries, XML, and RDL.Collaborated directly with clients to gather requirements and implement solutions for allocating payroll earnings, taxes, and deductions to individual GL accounts.Designed and automated technical file imports to meet client-specific needs, ensuring accuracy and compliance.Streamlined workflows using advanced Excel functions, VBA, and complex GUI-driven AutoHotkey scripting, achieving significant efficiency gains.Managed end-to-end project lifecycles using Salesforce TaskRay, including workflow design and automation in Lightning Web Components (LWC).Delivered high-quality solutions by prioritizing customer satisfaction, technical excellence, and process optimization.

Austin, Texas, Us

Performed core Accounts Payable functions, including statement reconciliations, reporting, and invoice processing.Promoted to E-Invoicing Specialist to lead the global onboarding of Tesla vendors to electronic invoicing systems as part of a company-wide initiative to phase out PDF invoices.Conducted end-to-end transitions for Tesla vendors worldwide to electronic invoicing, including training sessions on the Tesla Supplier Portal, and implementation of EDI (810/850/862) and cXML connections.Achieved a substantial increase in electronic invoicing adoption:North America: 20% in 2020 to 90% in 2022.EMEA: <5% in 2020 to >80% in 2022.Maintained and updated training materials for vendors, provided UAT support through JIRA, and contributed actionable feedback to Tesla developers to enhance system functionality.Designed and implemented automation tools and macros using AutoHotkey and JavaScript to optimize workflows:Automated email communications in Outlook.Streamlined template-based responses for ticket resolution in Chrome.Integrated real-time updates for Excel tracking sheets.Successfully maintained high performance as a one-person team while the scope of the role expanded, using automation to increase productivity and efficiency.

Cottonwood Heights, Utah, Us

Managed comprehensive accounting functions, including timecard/shift entry, payment batch generation in Microsoft Dynamics Great Plains, and full Accounts Payable (A/P) and Accounts Receivable (A/R) tracking.Maintained detailed aging reports and conducted monthly account reconciliations to ensure accuracy and compliance.Handled daily communications with vendors and clients to resolve inquiries, address discrepancies, and maintain strong professional relationships.Coded checks, processed payments, and ensured all financial records were up-to-date and aligned with company policies.Streamlined workflows and enhanced accuracy by implementing best practices in reporting and reconciliation processes.

Murray, Utah, Us

Verified loan closing documents for accuracy and compliance with regulatory and internal standards.Maintained an organized and efficient filing system to ensure timely retrieval and secure storage of loan documentation.Oversaw the preparation and shipping of loan packages to banking institutions, ensuring all required materials were complete and accurate.Provided training and direction to coworkers, delegating tasks to streamline processes and improve team efficiency.Assisted with various loan processing responsibilities as needed, demonstrating adaptability and a proactive approach to meeting deadlines.

Lindon, Utah, Us

Managed full-cycle corporate accounting operations, including Accounts Payable (A/P), Accounts Receivable (A/R), payroll, budgets, taxes, and financial reporting, primarily using QuickBooks.Spearheaded the implementation of a system to directly import customer orders into QuickBooks using a third-party integration tool and custom formulaic spreadsheets, streamlining order processing and data accuracy.Collaborated with the Director of Operations and Office Manager to design and implement productivity-enhancing systems, including task management in Asana and company-wide communications in Slack.Contributed to the rollout of a company-wide inventory management system using Fishbowl, as well as the development of advanced tracking tools in Google Sheets and Oracle databases.Transitioned to an iOS Technician role during the final four months, leveraging a passion for technology to perform hardware restoration and testing for Apple devices, including iPhones, iPads, Apple Watches, and Apple TVs.Demonstrated adaptability and technical acumen by taking on a dual-focus role, excelling in both administrative and technical capacities to meet evolving company needs.

Managed all aspects of store operations, including supervising staff, scheduling, correspondence, and financial management, utilizing QuickBooks for Accounts Payable (A/P), Accounts Receivable (A/R), and bookkeeping.Collaborated with the CEO to develop financial statements, business plans, market studies, projections, and budget forecasts to support strategic planning and growth initiatives.Designed and implemented a comprehensive, database-driven employee management system in ColdFusion, integrating the following functionalities:- Inventory management and order tracking.- Point of Sale (POS) system for seamless transactions.- Employee clock-in/out and scheduling tools tied to a custom payroll system.- Nightly cash reconciliations and shipping workflows.Monitored, maintained, and upgraded secure LAN networks, integrating security systems into the management platform to enhance data protection and operational efficiency.Assisted with marketing efforts, including the creation of promotional materials and the execution of targeted marketing strategies to increase visibility and drive sales.Developed training materials, including detailed assembly diagrams and user manuals for 3D printer production, ensuring consistent quality and employee proficiency.

Performed regular maintenance and repair of office computers and equipment, including copiers, fax machines, printers, and cameras.Installed, repaired, and maintained secure LAN networks in both office and theater locations to ensure reliable connectivity.Supported the Owner directly with administrative tasks, including appointment tracking, dictation transcription, filing, payroll, and organization of daily operations.Created and managed complex Excel spreadsheets for handling large datasets, such as invoices, purchase orders, reconciliations, profit and loss (P&L) statements, and financial reports.Implemented and managed a project task management system, improving productivity and communication across multiple projects, businesses, and teams.Assisted in the launch and daily management of theater websites, ensuring accuracy and consistency in online advertising and promotional content.Contributed to the opening of a new movie theater, with responsibilities including:- Tracking inventories through Excel.- Organizing and reviewing applicant resumes.- Conducting phone pre-screening interviews.- Coordinating appointments for services and repairs.- Performing light labor tasks to prepare the facility for operations.