Ганна

Hanna Makarova
[открыть контакты](см. выше в блоке «контактная информация»)
[открыть контакты](см. выше в блоке «контактная информация»)
LinkedIn /hanna-m-779899153/
DATA ANALYST
Aberdeen, United Kingdom

SUMMARY

A results-driven and detail-oriented Data Analyst with strong academic credentials and a diverse range of practical
experiences in data analysis, project management, and cross-functional collaboration. Skilled in leveraging advanced data
analytics tools, including Python, SQL, Power BI, and Tableau, to uncover valuable insights and drive data-informed
decision-making. Adept at building data visualizations, performing statistical testing, and optimizing business processes
through data-driven strategies. Passionate about continuous learning and using data to solve complex problems.

SKILLS

● Spreadsheets: Pivot Tables, Data Cleaning, Visualization
● Excel: Advanced Functions, Data Analysis, Automation
● SQL: Advanced Queries, Window Functions, Query Optimization, Common Table Expressions (CTE)
● Python: Pandas, NumPy, Matplotlib, Seaborn, Exploratory Data Analysis (EDA)
● Tableau: Interactive Dashboards, Data Storytelling, Publishing
● Power BI: Data Modeling, Interactive Dashboards, Data Visualizations, Reporting
● Statistics: Sampling, Hypothesis Testing, Correlation, Statistical Significance
● A/B Testing: Planning, Analysis, Reporting
● Other Tools: Jupyter Notebooks, Google Analytics, Git
● Languages: English (proficient), Ukrainian, Russian, German (beginner), Chinese (beginner)

EXPERIENCE

Data Analyst | Freelance Projects Aug 2024 - present
● Developed interactive dashboards and reports using Tableau, Power BI, and Looker Studio, enabling data-driven
decision-making.
● Conducted A/B testing to evaluate marketing effectiveness, using statistical methods (Z-tests, p-values).
● Designed and optimized SQL queries to extract and analyze large datasets, improving reporting efficiency.
● Built Python-based data pipelines to clean, analyze, and visualize sales and customer behavior data.
● Automated data aggregation and reporting in Excel, Google Spreadsheets and Python, reducing manual effort by
40%.
Portfolio:
Project 1: Python and Tableau project analyzing A/B test results, with Z-tests to assess conversion rates.
● Link to review
Project 2: Power BI and Excel project analyzing AI development and its impact on job markets and public opinion.
● Link to review
Project 3: Python, SQL, and Tableau project on e-commerce sales data, evaluating user behavior and marketing
effectiveness.
● Link to review
Project 4: SQL and Looker Studio project analyzing user behavior and account activity in an e-commerce database.
● Link to review
Project 5: Python-based sales analysis project, providing insights into global sales performance and regional profitability.
● Link to review
Project 6: Sales analysis project using spreadsheets to visualize trends across 46 countries.
● Link to review
/PREVIOUS EXPERIENCE/

Customer Service | Harvey Nichols, Edinburgh May 2023 – Present

● Ensured seamless customer experiences in a luxury retail environment.
● Managed multiple tasks efficiently, contributing to customer satisfaction.

Supervisor | Laila's, Edinburgh May 2022 – Apr 2023

● Promoted to supervisor for outstanding performance and leadership.
● Improved customer satisfaction and financial performance via strategic upselling.

Supply chain manager | Vist Group, Ukraine Sep 2022 – Feb 2022

● Pro-actively communicated with and coordinated global manufacturers, carriers and clients ensuring smooth
operations.
● Effectively overseeing the end-to-end logistics process and managing the timely delivery of goods..
● Accurately generating contracts, raising invoices, and preparing a wide range of documentation.

EDUCATION

Institution Edinburgh College
Qualification and Degree Data and Digital Innovation (PDA Data Science Level 7)
Dates Attended Aug 2024- Jan 2025

Institution Kyiv National University of Trade Economics
Qualification and Degree Master's degree in International Economic Relations
Dates Attended 2023-2024

Institution Kyiv National University of Trade Economics
Qualification and Degree Bachelor's degree with honors in Management of Foreign Activity
Dates Attended 2019-2023

ADDITIONAL EDUCATION

● Data Analyst Course at Mate Academy Link to review
● Foundations of Project Management at Coursera Link to review
● Agile Project Management at Coursera Link to review
● Introduction to Software Engineering at Coursera Link to review
● IELTS Official Link to review

ACHIEVEMENTS

● Wrote a dissertation: "Export Strategy of a Company in the Dairy Product Market (Based on the Materials of LLC
'MK 'Halychyna', Lviv)" 2024
● Wrote a dissertation: "Management of Dairy Product Exports to the United Kingdom (Based on the Materials of
LLC 'MK 'Halychyna', Lviv)" 2023
● Successfully organized and coordinated university events for 100+ attendees