Андрій

ANDRII MAGERA
DATA ANALYST
Telegram WhatsApp GitHub Signal Linkedin

[відкрити контакти](див. вище в блоці «контактна інформація») [відкрити контакти](див. вище в блоці «контактна інформація») Kyiv, Ukraine, remote, hybrid

ABOUT ME

Data Analyst holding a degree in Finance and Banking, with a strong cross-functional background in
procurement, logistics, the beauty industry, and medicine. Experienced as a manager, technologist, service
trainer, and business consultant for entrepreneurs. Focused on finding effective solutions through deep research
and data analysis. Successfully represented company interests before the AMCU. Delivered end-to-end projects
from data collection, source integration, data cleaning, and table normalization to dashboard visualizations for
analytics departments and top management, final insights, and actionable business recommendations. Creative,
disciplined, and adaptable, eager to join a fast-growing company and a team where my work and analytical
approach have a real impact on business decisions and the product, while actively growing professionally and
building my career.

EDUCATION
Master'sDegreein Banking Sep 2007 - Jul 2012
Ternopil National Economic University

Bachelor's Degree in Hair Design Sep 2010 - May 2014
Kyiv University of Culture & Arts
Specialist in General Medicine Sep 2003 - May 2007
Chemerivtsi Medical College

TECHNICAL SKILLS
Spreadsheets: Pivot Tables, Data Cleaning, Visualization
SQL: Advanced Queries, Window Functions, Query Optimization, Common Table Expressions (CTE), PostgreSQL, BigQuery
Python: Pandas, NumPy, Matplotlib, Seaborn, Exploratory Data Analysis (EDA)
Tableau: Interactive Dashboards, Data Storytelling, Publishing
Statistics: Sampling, Hypothesis Testing, Correlation, Statistical Significance
A/B Testing: Planning, Analysis, Reporting
Other Tools: Jupyter Notebooks, Google Analytics, Excel, Git
Languages: English( Intermediate), Italian( Intermediate)

PROFESSIONAL EXPERIENCE PORTFOLIO
Data Analyst Dec 2025 – Present

Analyzed business data using SQL (window functions, CTEs, JOINs) to extract actionable insights and calculate key
performance metrics.
Developed interactive dashboards in Tableau to visualize data trends, sales performance, and key business indicators.
Conducted Exploratory Data Analysis (EDA) and statistical analysis using Python (Pandas, NumPy, Matplotlib, Seaborn).
Formulated product hypotheses, performed A/B testing, and evaluated statistical significance (p-values, conversion
metrics).
Documented analytical workflows and presented data-driven recommendations for business decision-making.

PORTFOLIO

Project 1 (E-commerce Sales Analytics)
• Developed an end-to-end sales analytics project for an online store. Performed data processing and analysis
using SQL and Python (Google Colab), documented analytical steps, and integrated an interactive Tableau
dashboard.
• GitHub Project: E-commerce Sales Analytics

Project 2 (A/B Testing & Statistical Analysis)

• Analyzed A/B testing results using statistical methods in Python (Google Colab) to evaluate conversion metrics, p-
values, and statistical significance. Integrated findings into an interactive Tableau dashboard to visualize key
performance indicators and test results
• GitHub Project: A/B Testing & Statistical Analysis

Mar 2025 - Dec 2025
Procurement & Project Manager
Technologies or Tools: CRM Systems, Advanced Excel/Google Sheets, Procurement & Logistics Analytics,
Negotiation, Vendor Management, Anti-Monopoly Dispute Resolution
Managed end-to-end procurement and logistics operations, conducting detailed market analysis and vendor
evaluations to optimize procurement budgets and supply chain routes.
Represented company interests before the Anti-Monopoly Committee (AMCU), successfully defending
positions and winning procurement disputes.
Administered customer relationships and sales funnels in CRM systems, tracking conversion rates, customer
retention, and service metrics.
Led complex parallel projects and cross-functional workflows, ensuring strict adherence to project deadlines
and high quality standards.
Negotiated contracts and international supply agreements, successfully improving commercial terms and
building long-term vendor partnerships.

Beauty Industry Professional (Hair Stylist, Lead Technical Trainer, Technical Educator) Jan 2012 - Dec 2024

Kika Style, Backstage, Bereshnaya & Beauty Academy / Professional Haircare Brand
Haute Couture
Training & Education: Developed and delivered full-course training programs on coloristics, techniques, and
salon management for stylists and business owners.
Project & Event Management: Organized photo shoots, media projects, and model castings, including
collaboration with Ukrainian Fashion Week.
Client Service & Operations: Provided high-end services, maintained quality standards, and managed
marketing materials for partner salons.

ACHIEVEMENTS

Completed a 1 000 km running challenge during the summer, demonstrating high self-discipline, endurance,
and goal-oriented focus.
Created and maintained an extensive indoor home garden of 20+ plants, reflecting patience, systematic care,
and dedication to multi-year personal projects.
Proven track record of managing parallel projects (up to 3 projects simultaneously) with effective time
managing.
Featured in a top Hollywood hairdressing magazine with a 5-page article about my work.
Analyzed markets and successfully negotiated with up to 80 vendors, optimizing supply chain processes.
International professional diplomas from Riga Academy of Coloristics and Chicago Pivot Point Academy.
Completed an international internship at a professional salon in Italy, enhancing cross-cultural communication
and service standards.