Summary
Overview
Work History
Education
Skills
Interests
Mentor of the Month for Universal Educational Center
Timeline
Generic

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
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
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
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

Interests

  • Volunteering
  • Gym Workouts
  • Strategy Games

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 -

Similar Profiles

CREATE PROFILE
Ky FarrarArea Merchandise Analyst