JUANITO ULANDAY

RETAIL BUSINESS ANALYST/ Data Analyst at Qatar Airways

• Qatar - Doha
• My current job since April 2014

Member of Finance Business Intelligence Team Space Planning and Basket Analysis Project on Category/ Merchandising &
Promotion & Planogramming. (Range evaluation methodology, Space Productivity Reports & Strategies)
•
Provided actionable business insights to Senior Leadership Team that influences a better strategic decision-making, improved
operational efficiency, competitive advantage, increased revenues and reduced cost.
•
Transforms raw data into meaningful and useful information enabling user access to immediate information and to a one single
source of truth by way of dashboard reporting and automated reports. Ensures delivery of automated Key Performance Drivers
to all relevant stakeholders (Margins, Average Transaction Value, Unit per Transaction Count and Penetration Rates)
•
Responsible for conducting quantitative and qualitative business performance analysis and merchandising recommendations in
retail department thru in-depth research on financials, passenger/consumer behaviour, space utilization, sales history, feedback,
to help Operations Team create, communicate and complete approaches to increase retail income and profits.
•
Project Consumer Behaviour Dashboard detailing purchases made per Nationality/Passenger Country Destination /Shop Name
against Retail Category Sales Demands alongside linking the Airport Peak Hours to Manpower Requirements to support sales
achievements.
•
Sales Trend Analysis by detailing Item wise Best Sellers by Category related to Historical Passenger Buying Patterns.
•
Yearly Audit, Evaluation and Recommendation for Cost Management Committee (CMC) Finished Projects of Qatar Duty Free
•
Support Procurement Team with Category Assortment and assessment to ensure product turnover, inventory kept at minimum,
ageing stocks and margins are monitored in addressing performance issues, trading decisions and project initiatives.
•
Key support for Senior Retail Operations Manager, Business Finance Manager, Budget & Planning Strategy Manager, Airport
Duty Managers by ensuring timely, accurate Presentation Sales Reports & Dashboards.
•
Customer Profiling, Basket & Spend Analysis, Promotion Impact Analytics, Heat Map Tracing, Loss prevention, Data Cleansing.
•
Produce Adhoc reports for timely distribution with short notice and deadlines. Ensures validity & accuracy of repository of data