Zac Iles
Centerton,AR
Summary
Analytical professional with a focus on process automation and financial risk mitigation within Operational Accounting. Expert in leveraging Excel VBA and macro development to streamline high-volume datasets, recently engineering a solution that de-duplicated 20,000+ tasks and safeguarded a $145k quarterly SLO penalty. Proven ability to translate complex business requirements into technical tools that drive departmental efficiency.
Overview
7
7
years of professional experience
Work History
Account Adjustment Specialist
Central Research Inc.
Centerton, AR
10.2025 - Current
- Mitigated financial risk of a $145k quarterly penalty by creating a proactive SLA tracking tool that flags aging accounts at the 30-day mark to ensure compliance with 45-day SLO requirements.
- Developed and implemented an automated "IC Scrubber" macro using VBA to identify and eliminate duplicate data from unapplied reports, preventing over 20,000 "junk" tasks and increasing departmental efficiency.
- Developed training materials for new team members, enhancing work flow and time management process efficiency.
- Collaborated cross-departmentally with Inventory Control (IC) management to re-engineer daily reporting workflows, replacing manual filtering processes with automated Treasury ID "fingerprinting" logic.
- Utilize advanced Excel techniques (Pivot Tables, Power Query, and Macros) to audit high-volume datasets and provide executive-level reporting for leadership.
Capacity Procurement Representative
J.B. Hunt
Lowell, Arkansas
05.2022 - 08.2025
- Managed procurement requests and acted as point-person for customers on logistics, hardware and software needs.
- Collected data to complete detailed financial reports for management.
- Maintained up-to-date database of suppliers, vendors and contracts to support accurate recordkeeping
Driver Recruiter
JB Hunt Transportation
Lowell, Arkansas
07.2021 - 05.2022
- Completed human resource operational requirements by scheduling and assigning employees.
- Collected and analyzed information to monitor compliance outcomes and identify and address trends of non-compliant behavior.
- Partnered with departmental managers to ascertain hiring needs and subsequently provide candidate recommendations.
Onboarding Specialist
JB Hunt Transportation
Lowell, Arkansas
03.2021 - 07.2021
- Eliminated downtime and maximized schedule to hire ratio by providing top quality control and time management.
- Analyzed and modified compensation and benefits policies to establish competitive programs and comply with legal requirements.
- Prepared monthly, weekly and daily logs using Microsoft Office Suite.
Resolution Specialist III Health and Wellness
Walmart Home Office
Bentonville, Arkansas
04.2019 - 05.2020
- Used Microsoft 365 and other software tools to create documents and other communications and analyzed data to identify opportunities for improvement.
- Promoted from Resolution Specialist II to III within the span of three months.
- Established a role as a Subject Matter Expert who assists management and performs in difficult situations along with difficult questions or concerns.
Education
Associate of Science - Psychology
NorthWest Arkansas Community College
Bentonville, ARHigh School Diploma -
Har-Ber High School
Springdale, AR05.2016
Skills
- Data Automation
- Analytical Tools
- Risk Management
- Critical thinking
- Communication
- Ability to work under pressure
- Decision making
- Adaptability
- Computer programming
- Problem-Solving
- Leadership
- Microsoft Office
- Organization and Time management
- Billing Systems and Software
- HTML5
- CSS
- JavaScript
- Git
Timeline
Account Adjustment Specialist
Central Research Inc.
10.2025 - Current
Capacity Procurement Representative
J.B. Hunt
05.2022 - 08.2025
Driver Recruiter
JB Hunt Transportation
07.2021 - 05.2022
Onboarding Specialist
JB Hunt Transportation
03.2021 - 07.2021
Resolution Specialist III Health and Wellness
Walmart Home Office
04.2019 - 05.2020
Associate of Science - Psychology
NorthWest Arkansas Community College
High School Diploma -
Har-Ber High School