Aaron Gunter - App Support Analyst / Report Developer - K-VA-T Food Stores (Food City)

Summary

Report Developer and Application Analyst with 3+ years of experience designing ETL processes, optimizing SQL queries against large datasets, and delivering enterprise reporting solutions. Partner with cross-functional stakeholders to translate business needs into actionable insights. Proven track record of data validation, workflow automation, and process improvement. Self-directed learner actively expanding Power BI expertise.

Overview

4

years of professional experience

Work History

App Support Analyst / Report Developer

K-VA-T Food Stores (Food City)

Abingdon, VA

05.2022 - Current

ETL Development & Data Integration
Designed and maintained 10+ SSIS packages to move, transform and validate data to help with reporting processing 100,000+ records to deliver reporting data with 99% accuracy
Partnered with database administrators to validate data architecture decisions and ensure ETL solutions support enterprise reporting performance requirements.
SQL Development & Query Optimization
Write and optimize complex T-SQL queries against multi-million row datasets, consistently delivering sub-10-second performance for enterprise level reports
Manipulate and parse large datasets (up to 3M+ records) to support ad-hoc analysis for accounting, sales, and operations stakeholders
Reporting & Dashboard Development
Designed and deployed 20+ SSRS reports and Power BI dashboards tracking inventory data discrepancies, missing invoice data, supporting PO Printing, and outlining store totals for known and unknown suppliers.
Automated manual reporting processes, reducing weekly reporting effort from 10+ hours to under 1 hour for the accounting team
Transferred cross system reports to interactive Power BI Dashboards saving end users 3 hrs of work and reducing development times by utilizing power BI data sets.
Stakeholder Collaboration & Requirements Gathering
Partnered with 10+ business stakeholders across accounting, sales, and operations to translate vague requests into specific, actionable reporting requirements
Participate in daily Agile stand-ups, reporting progress on BI work items and collaborating with cross-functional teams on sprint priorities.
Data Validation & Quality Assurance
Led data validation for 5+ major accounting system integrations, identifying data discrepancies early and trimming 3-7 days from each project timeline while ensuring zero data loss during transitions.

Education

Associate of Applied Science - Programming

Northeast State Community College

Blountville, TN

01-2022

Skills

SQL & Data Manipulation: Advanced T-SQL, Query Optimization, Stored Procedures, Complex Joins, Window Functions
ETL & Integration: SSIS Package Development, Data Validation, Workflow Automation, System Integration
BI & Visualization: Power BI (Dashboard Development), SSRS, Excel

Data Architecture: Data Warehouse Concepts, Data Modeling
Tools & Methodologies: ServiceNow, Azure DevOps, Source Control, Technical Documentation
Soft Skills: Stakeholder Collaboration, Requirements Gathering, Cross-Functional Communication, Process Improvement, Root Cause Analysis

Timeline

App Support Analyst / Report Developer

K-VA-T Food Stores (Food City)

05.2022 - Current

Associate of Applied Science - Programming

Northeast State Community College