Kateryna

Kateryna Zakharchenko
[open contact info](look above in the "contact info" section) | LinkedIn | [open contact info](look above in the "contact info" section) | Kyiv, Ukraine

WORK EXPERIENCE
Data Analyst, Kyiv, Ukraine
Business Intelligence, Kasta Mar 2026 – Present
• Develop Power BI dashboards from the engineering data model to a user-friendly design
• Prepare scheduled ETL data pipelines for regular data-feed reports and dashboards
• Write and optimize SQL stored procedures and CTEs for data processing
• Web scraping prices and availability
• Work with server-side web events
• Hypothesis testing

Data Modeler, Kyiv, Ukraine
Data Insights & Analytics, Philip Morris Sales and Distribution Jan 2026 – Mar 2026
• Design and maintain Power BI dashboards for commercial analytics
• Develop and maintain ETL pipelines for national IMS, offtake, and stock data
• Manage data ingestion processes and related reference dictionaries
• Write and optimize SQL stored procedures for data processing

Commercial Systems Analyst, Kyiv, Ukraine
Business Intelligence, Philip Morris Sales and Distribution Jun 2024 – Jan 2026
• Reduced data preparation time by 83% by developing data processing pipelines in Python
• Increased product name matching speed and accuracy by building RegEx–based algorithm
• Automated national reporting processes, reducing manual effort by 75% using SQL and Python
• Performed database profiling and validation; created business specifications for data migration projects
• Developed a data validation pipeline to ensure quality of migrated data
• Built VBA-based data upload tools with validation logic for cross-functional stakeholders
• Designed data structures for offtake datasets

Business Intelligence Intern Kyiv, Ukraine
Inkompass, Philip Morris Ukraine Jun 2023 – Jun 2024
• Prepared weekly and monthly commercial reports
• Developed SQL and Python scripts for regular data monitoring
• Cleaned and clustered POS universe coordinates data
• Worked on image segmentation and product visual recognition models

SKILLS
• Excel, Postgres SQL, Clickhouse, Transact-SQL, Snowflake SQL, Jupyter, iPython, VS Code, LaTeX Markdown, GitHub
• Python (Pandas, Numpy, xlwings, Plotly, scikit-learn, geoPy, OpenCV, ydata-profiling, seaborn, Matplotlib), bash scripting
• RegEx Context Matching with fuzzy-search, Web scraping with Selenium
• English: B2 - Upper Intermediate
• Claude Code, Claude Cowork, MCP for Power BI using pbip format

EDUCATION
Bachelor of Applied Mathematics Kyiv, Ukraine
National Technical University of Ukraine “Igor Sikorsky Kyiv Polytechnic Institute”, 2018 – 2022
department of Mathematical Modelling and Data Analysis,
• Specialization: “Mathematical Modelling, Pattern Recognition, and Computer Vision”
L3 Internship, research project in computer vision Paris, France
Université Paris Cité, May 2022 – Aug 2022
• Eulerian Video Magnification computer vision algorithm implementation
• Built the general architecture of a learning algorithm using Gaussian and Laplacian pyramids for making temporal and
spatial video processing.
Université Paris Cité Paris, France
• L3 Mathématiques et Applications Sep 2022 – Jan 2023
Courses
• Introduction to Model Context Protocol from Anthropic Academy Mar 2026
• Data Science School 2021 by Kyiv Academic University, Feb – Mar 2021
• Information security by CRDF Global Dec 2020