Ekaterina Abramova Email & Phone Number

- Developed a comprehensive database from scratch used by the department and management to track restaurant performance and rent ratios, improving data accessibility and decision-making processes.- Initiated and streamlined P&L analysis for the department, reducing dependency on other departments and accelerating the reporting process.- Collaborated with a business analyst to create a dynamic forecast table system, automating the calculation of rent changes based on sales fluctuations, leading to more accurate and timely financial planning.- Produced ad-hoc reports for both local and international management, delivering critical insights and supporting strategic decision-making.- Leveraged Power BI to analyse restaurant performance metrics (sales channels, AGC, peak hours, etc.), filling a crucial skill gap within the department and enhancing analytical capabilities.- Successfully prepared the Annual Operating Plan (AOP) for three consecutive years, completing the process efficiently and without any remarks, demonstrating exceptional planning and organisational skills.

- Conducted SWOT analysis of new locations, providing a realistic assessment and identifying opportunities and threats, which informed strategic decisions for opening new restaurants.- Developed presentations, effectively showcasing new locations with detailed maps, surroundings, traffic generators, and other critical information, facilitating informed decision-making.- Calculated CapEx for new potential locations, ensuring accurate budgeting and financial planning for future investments.

- Successfully reviewed and improved course material, ensuring it met high standards of accuracy and clarity.- Identified and reported over 100 errors in course tasks and Python code, directly contributing to course improvement.- Played a key role in debugging and enhancing Python scripts used in the course.- Contributed to the development of a robust curriculum by providing critical feedback on course structure and content.

- Created a comprehensive database utilised by an AI chatbot to provide personalised restaurant recommendations in various cities based on user preferences.- Tested and updated the AI chatbot, ensuring accurate responses and functionality, and resolving issues identified during testing to improve user experience.- Maintained and enriched the database with up-to-date information about restaurants, enhancing the chatbot’s ability to offer reliable and current recommendations.