- Volunteering
- Gym Workouts
- Strategy Games
Ky Farrar
Area Merchandise Analyst
Orlando,FL
Summary
Results-driven Area Merchandise Analyst at Universal Studio Orlando with expertise in data analysis and financial reporting. Proficient in Power BI and SQL, I enhance decision-making through actionable insights. A collaborative team player, I successfully implemented strategies that improved operational efficiency and drove sales growth, fostering a culture of continuous improvement.
Overview
11
11
years of professional experience
1
1
Language
Work History
Area Merchandise Analyst
Universal Studio Orlando
Orlando, FL
11.2024 - Current
- Performed statistical analyses and shared results with manager to support informed decision-making.
- Used MS Excel, Power BI, JDA and MDW to analyze sales and inventory data for all Universal Orlando locations.
- Acts as a liaison between the Merchandise warehouse, Area Merchandise and operations team to ensure product orders are placed in a timely manner and delivered in the requested timeframe.
- Develop reports in Power BI, showcasing business results and opportunities with interactive reporting.
- Develop tools and reports in Excel using VBA to create connections to our databases and format.
- Used SQL code to query in the databases JDA and MDW.
Assistant Merchandise Manager
Universal Studio Orlando
Orlando, FL
02.2020 - 11.2024
- Implemented loss prevention strategies to minimize shrinkage rates and protect company assets.
- Championed cross-functional communication between departments, streamlining operations and improving overall store performance.
- Increased sales by implementing strategic merchandise displays and product placements.
- Analyzed sales data to identify trends and optimize product assortments, maximizing revenue potential.
- Managed visual merchandising standards across the store, creating an appealing shopping environment that drove sales growth.
- Oversaw regular inventory audits to maintain accurate records of stock levels throughout the store.
- Motivated and mentored merchandise team to achieve high performance and job satisfaction.
- Developed SOP rewrites and updates for training material.
Area Manager / Project Lead
Colorvision International Inc
Orlando, FL
03.2014 - 02.2020
- Improved overall efficiency by identifying areas in need of improvement and implementing necessary changes.
- Coordinated with various departments to facilitate smooth communication, enhancing operational effectiveness.
- Led a team to achieve company goals and exceed targets consistently, fostering a positive work environment.
- Managed daily operations for optimal performance, ensuring timely completion of tasks and projects.
- Facilitated conflict resolution among team members, promoting open communication and fostering a positive workplace culture.
- Mentored junior staff members, providing guidance on best practices and professional development opportunities.
- Assessed reports to evaluate performance, develop targeted improvements, and implement changes.
- Established clear objectives for each project, setting expectations and assigning appropriate resources as needed.
Education
Associate of Science - Computer Programming And Analystics
Valencia College
Orlando, FL 05.2001 -
Skills
Experienced in data analysis using Excel
Proficient in Power BI
Data-driven decision making
Data analysis
Financial data analysis
SQL data analysis
VBA programming
Collaborative teamwork
Customer service
Problem-solving abilities
Efficient time management
Interests
Mentor of the Month for Universal Educational Center
Was awarded Mentor of the Month with the Universal Educations Center in February of 2024. In UEC I worked with a high school junior to mentor him through his learning and his experiences while working at Universal Orlando Resort.
Timeline
Area Merchandise Analyst
Universal Studio Orlando
11.2024 - Current
Assistant Merchandise Manager
Universal Studio Orlando
02.2020 - 11.2024
Area Manager / Project Lead
Colorvision International Inc
03.2014 - 02.2020
Associate of Science - Computer Programming And Analystics
Valencia College
05.2001 -