Loren Cooper
Abingdon
Summary
Data-driven System Analyst with experience supporting warehouse and supply chain operations through SQL development, ETL processes, and operational data analysis. Skilled in transforming structured datasets into actionable insights that improve reporting accuracy and support business decision-making. Strong background in production support, data integrity troubleshooting, and cross-functional collaboration.
Overview
5
5
years of professional experience
1
1
Certification
Work History
System Analyst – Supply Chain
KVaT Food Stores.
10.2023 - Current
- Develop and maintain SQL queries and stored procedures to support warehouse and supply chain operations.
- Build and maintain SSIS packages to extract, transform, and load operational data.
- Analyze structured datasets to identify discrepancies, improve reporting accuracy, and support leadership decision-making.
- Support WMS and related operational systems across warehouse environments.
- Troubleshoot production issues, including invoice discrepancies, duplicate records, and data integrity problems.
- Lead and support system upgrades and new application implementations within warehouse operations.
- Collaborate cross-functionally with IT, operations, and finance teams to resolve data and process issues.
Bulk Merchandiser
Coca-Cola Consolidated
02.2021 - Current
- Merchandised cases from back room to sales floor, filling display units or shelves with products.
- Tidied up shelves and displays, knocking down boxes and disposing of waste.
- Assembled and disassembled promotional materials such as signs, banners and cardboard displays.
- Rotated products and removed defective and out-of-date products.
Developer
East Tennessee State University
08.2022 - 12.2022
- Part of 3 man team that developed a monitoringAPI and database to store data being collected sent too us from another team.
- Introduced automated diagnostics for sensor data collection and processing.
- Introduced agile methodologies and development best practices to division to enhance product development.
- Collaborated on stages of systems development lifecycle from requirement gathering to production releases.
- Work successfully with my team to received an B plus bonus points for being the most complete.
Education
Bachelor of Science - Information Technologhy
East Tennessee State University
Johnson City, TN12.2022
Associate of Science - General Studies
Virginia Highlands Community College
Abingdon, VA05.2019
Skills
- SQL (T-SQL)
- SSIS
- Data Analysis
- WMS Systems
- ETL Processes
- Microsoft Excel
- Production Support
- Process Improvement
Certification
SAP University Alliances
Personal Information
Title: Information Technology
Timeline
System Analyst – Supply Chain
KVaT Food Stores.
10.2023 - Current
Developer
East Tennessee State University
08.2022 - 12.2022
Bulk Merchandiser
Coca-Cola Consolidated
02.2021 - Current
Associate of Science - General Studies
Virginia Highlands Community College
Bachelor of Science - Information Technologhy
East Tennessee State University