Lucas Barten
Ankeny,United States
Summary
Experienced in data analysis, market research, and pricing strategy. Leveraging analytical skills to forecast pricing trends and optimize revenue. Strong background in financial modeling and competitive analysis, providing valuable insights and supporting business goals. Expertise in making data-driven decisions that drive success and growth for organizations.
Overview
6
6
years of professional experience
Work History
Pricing Analyst
American Packaging Corporation
07.2023 - Current
- Determined pricing levels that meet agreed-upon margin guidelines and/or pricing strategy for the specific situation/market
- Developed Escalator/De-Escalator to validate price adjustments
- Balanced customer needs and values with expected product demand to meet customer quoting and cost estimate needs
- Created pricing tools to more accurately represent manufacturing costs
- Managed 40+ customers
Demand Planning Analyst
Best Buy
05.2022 - 07.2023
- Leveraged technical proficiency and strategic insights to drive financial forecasts, pricing, and assortment planning
- Fostered strong collaboration with vendors, optimizing inventory health and supporting future planning, analysis, and process implementation
- Delivered daily reports, effectively highlighting critical information for informed decision-making
- Execution of inventory purchasing strategies, ensuring alignment with demand forecasts
- Directed forecasting efforts for a diverse portfolio of 500+ SKUs, resulting in a 10% improvement in forecast accuracy and inventory turnover
- Streamlined operations and increased productivity by leveraging Oracle systems for inventory management, resulting in a 20% reduction in processing time
- Built warehouse split tool by subclass to properly divide inventory
- Trained incoming analysts on industry trends
Category Analyst Intern
Best Buy
06.2021 - 06.2022
- Explored each function of Category Management Analyst Roles - Merchandising, E-commerce, and Demand Planning
- Learned how to evaluate inventory health and determine how a SKU is productive or underperforming through use of Power BI
- Studied pricing and margin structure
- Used data to provide assortment recommendations
- Presented overall findings to peers, mentors, and leaders
Inventory and Scheduling Intern
V&H Automotive
06.2019 - 05.2021
- Identified opportunities for system and process improvements, troubleshooting issues, and implementing enhancements
- Focused on KPI's across different subclasses of vehicles to maintain competitive inventory
- Assisted in coordinating transportation issues
- Sent reporting to upper management on market trends
- Submitted purchase orders of vehicles for fleet and personal use
- Collaborated with sales to deliver customer feedback to management
Education
University of St. Thomas - Logistics, Materials, and Supply Chain Management, Data Analytics
University of St. Thomas
05.2022
Skills
- Data Analysis
- Data Entry
- Microsoft Excel
- Microsoft Power BI
- Inventory Management
- Purchasing
- SAP
- SKU Management
Timeline
Pricing Analyst
American Packaging Corporation
07.2023 - Current
Demand Planning Analyst
Best Buy
05.2022 - 07.2023
Category Analyst Intern
Best Buy
06.2021 - 06.2022
Inventory and Scheduling Intern
V&H Automotive
06.2019 - 05.2021
University of St. Thomas - Logistics, Materials, and Supply Chain Management, Data Analytics
University of St. Thomas
Similar Profiles
Jessica KingJessica King
Accounts Payable Intern at American Packaging CorporationAccounts Payable Intern at American Packaging Corporation
Steven DrozSteven Droz
Ink Department Supervisor at American Packaging CorporationInk Department Supervisor at American Packaging Corporation
Delores HoustonDelores Houston
Utility Operator at American Packaging CorporationUtility Operator at American Packaging Corporation
Aammin HassanAammin Hassan
Babysitter at Various ParentsBabysitter at Various Parents
Logan MaxwellLogan Maxwell
Assistant Principal at Ankeny Community School DistrictAssistant Principal at Ankeny Community School District