Ігор

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

LinkedIn GitHub Telegram
Can work during blackouts (inverter, battery, generator backup)

Summary
Data Analyst with a background in engineering and scientific research. Over 15 years of experience in
mathematical modeling, experimental data analysis, and developing decision-support systems, including 9+ years
of collaboration with international teams and research partners. Developed four analytics projects using SQL,
BigQuery, Python, Excel / Google Sheets, Tableau, and Power BI. Practical experience includes statistical analysis,
A/B testing, data visualization, and dashboard development.

Skills
SQL Python BI Tools
Joins, CTEs, Window Functions, Pandas, NumPy, Matplotlib, Power BI (Data Modeling, DAX),
Aggregations, BigQuery Seaborn, EDA Tableau, Looker Studio

Excel / Google Sheets Statistics A/B Testing
Pivot Tables, Data Cleaning, Data Hypothesis Testing, Correlation, Planning, Analysis, Conversion
Visualization, ABC Analysis Statistical Significance Rate, Lift, Segmentation

Other Tools Languages
Jira, Git/GitHub, REST API, Google English (Upper-Intermediate / B2)
Analytics 4

Experience
04/2026 – Present Self-employed
Data Analyst
Cleaned, transformed, and validated data from multiple sources using SQL, BigQuery,
•

Python, and Excel / Google Sheets.
Built Power BI and Tableau dashboards to visualize key business metrics and
•

performance trends.
Analyzed A/B test results and performed statistical analysis and segmentation to
•

evaluate business performance.

Portfolio
AI Beauty Platform — Team Project / Team Lead
Designed and populated the SQL database; integrated React/TypeScript interfaces with REST APIs.
•

Built a three-page Power BI report covering revenue, customer behavior, and GA4 analytics.
•

Coordinated team development and API requirements as Team Lead.
•

Beauty AI | Admin Panel | Power BI Dashboard
Sales Performance Analysis
Built a 12-sheet Google Sheets workbook from 1,328 EU orders (2010–2017), including data cleaning, pivot tables,
•

KPI dashboard, and revenue and profit reports.
Performed ABC segmentation and analyzed performance by category, country, sales channel, and delivery time.
•

Google Sheets
A/B Testing Statistical Analysis
Analyzed multiple experiments with 800K+ user events using Two-Proportion Z-tests, conversion rates, lift, p-
•

values, and segmentation.
Visualized experiment results and provided recommendations based on statistically significant findings.
•

Colab | Tableau
E-commerce Sales Analytics
Built an end-to-end analytics workflow using BigQuery, SQL, and Python EDA, with two Tableau dashboards
•

covering sales, revenue trends, and customer behavior.
Colab | Tableau

Previous Experience
03/2011 – Present E.O. Paton Electric Welding Institute of the NAS of Ukraine
Researcher (Part-time)
Developed a decision-support application with a structured database for managing and
•

analyzing technical data.
Processed and analyzed experimental and simulation data to validate results and
•

support data-driven engineering decisions.
Built mathematical models of complex physical and technological processes to simulate
•

system behavior and predict outcomes.
08/2016 – 12/2024 Thermo Fisher Scientific
Clinical Relations Specialist
Managed long-term relationships with healthcare stakeholders, coordinating clinical
•

trial partnerships, contractual processes, and ongoing communication.
Maintained and updated physician records, cooperation statuses, and operational
•

documentation, ensuring data accuracy and consistency.
Explained complex clinical trial protocols in clear, accessible terms to healthcare
•

professionals and collaborated with international teams.

Education
2011 – 2015 Postgraduate Studies (PhD Candidate)
E. O. Paton Electric Welding Institute of the NAS of Ukraine
2006 – 2011 Master's Degree, Welding Technology and Equipment
Igor Sikorsky Kyiv Polytechnic Institute
2002 – 2006 Junior Specialist, Welding Production
Kyiv Mechanical and Technological Professional College

Additional Education
Data Analyst Program
Mate Academy
SQL, BigQuery, Python, Tableau, Power BI, Statistics, A/B Testing
Certificate

Achievements
Co-authored peer-reviewed scientific publications and presented research at Ukrainian and international
•

conferences.
Participated in the EU-funded INNOPIPES project (FP7, Marie Curie Actions, 2013–2016), collaborating with
•

European research institutions.
Co-developed a commercial Intelligent Decision Support System for engineering process optimization.
•