Brian Wagner

Data-driven Operations & Accounting Professional with a Master of Science in Information Technology (3.92 GPA) and 20+ years of dedicated experience in route settlements, financial validation, and high-volume data verification. Proven track record of maintaining absolute data integrity inside enterprise environments, including 6 months of direct hands-on proficiency coding and verifying AP invoices using Microsoft Dynamics 365. Expert at utilizing advanced Microsoft Excel analytics and database principles to streamline processing workflows, eliminate reconciliation bottlenecks, and maintain an audit-ready zero-error threshold.

Route Settlement Associate – Data Analysis & AP Operations at G&J Pepsi-Cola (2005-07 – Present)

• AP Invoice Management: Exclusively code, verify, and process high-volume supplier and vendor accounts payable invoices using Microsoft Dynamics 365 to capture metadata accurately into internal enterprise databases.
• Financial Auditing: Analyze daily financial, distribution, and transactional reports across regional hubs using advanced Excel functions (pivot tables, VLOOKUP, conditional formulas) to eliminate calculation friction.
• Discrepancy Reconciliation: Cross-reference complex route settlement logs, audit card and C.O.D. transaction sheets, and resolve entry errors under strict, time-sensitive daily production deadlines.
• Information Security & Governance: Enforce rigorous data entry, digital document scanning, and electronic ledger-keeping practices to guarantee instant, audit-ready document retrieval.

Founder, Platform Operator & Program Director at KDUB Radio (Internet Radio Station) (2016-01 – Present)

• Systems Management: Architected and self-operated a digital streaming media network from the ground up, managing remote cloud infrastructure, digital audio pipelines, and data delivery feeds.
• Workflow Automation: Structured and automated multi-platform RSS content distribution grids, metadata scheduling networks, and file indexing matrix configurations to run on automated schedules.

Podcast Producer & Audio Engineer at Freelance (2021-09 – Present)

• Data Quality Control: Audit, process, and optimize large-scale digital master files for client networks, ensuring structural consistency, exact data flow synchronization, and compliance parameters.
• Metadata Optimization: Write and organize SEO-aligned data tables, categorical tags, and distribution schedules to ensure maximum visibility across global digital platforms.

Instructor – Radio Broadcasting & Audio Production at Ohio Media School (2018-06 – 2019-10)

• Technical Training: Developed and delivered specialized instructional frameworks focused on technical database tooling, software tool chains, and modern digital asset management interfaces.

Master of Science in Information Technology – Southern New Hampshire University (2022-11)

Bachelor of Science in Audio Production – Full Sail University (2018-06)