Сергій

Serhii Marynokha

Location: Lviv, Ukraine | Phone: [відкрити контакти](див. вище в блоці «контактна інформація») | Email: [відкрити контакти](див. вище в блоці «контактна інформація»)

LinkedIn: [відкрити контакти](див. вище в блоці «контактна інформація»)

English Level: Upper-Intermediate (B2+)

SUMMARY
Detail-oriented and quantitative-driven System Analysis student at Lviv Polytechnic with practical
experience in data processing, reporting automation, and database management. Advanced
proficiency in MS Excel (Pivot Tables, Power Query, macros/VBA basics), SQL, and Tableau, with
a strong foundation in Mathematical Statistics and Probability Theory. Proven ability to extract,
clean, and structure datasets from multiple sources to build accurate financial and operational
reports. Highly motivated to apply problem-solving skills and technical expertise in an international
audit and financial consulting environment (Big 4).

TECHNICAL SKILLS
• Spreadsheets & Data Processing: Advanced MS Excel (Pivot Tables, Power Query,
complex formulas, VLOOKUP/XLOOKUP, VBA/Macros basics), Google Sheets, Data
Cleaning & Preprocessing.

• Databases & SQL: Confident SQL (PostgreSQL, MySQL, BigQuery) — Complex Joins,
Window Functions, Aggregations, Database Schema Design, Data Extraction from multiple
sources.

• BI Tools & Visualization: Tableau (Certified: LOD Expressions, Set Actions, Interactive
Reporting), Power BI, Looker Studio (Data Studio).

• Programming & ETL: Python (Pandas, NumPy for data manipulation and automated ETL
pipelines), basic understanding of Alteryx workflow concepts.

• Tools & Methodologies: Jira, Confluence, Trello, Git, Data Integrity & Quality Assurance,
Financial & Operational KPI Tracking (ROI, LTV).

WORK EXPERIENCE

Win Win Travel | Junior Data Analyst (June 2026 – Present)

• Data Pipeline & Reporting Integrity: Maintained and optimized data pipelines to process
structured datasets from multiple sources into BigQuery and Looker Studio for operational
and financial reporting.

• Data Quality & Discrepancy Resolution: Proactively identified and troubleshot
discrepancies in data collection layers, resolving critical tracking inconsistencies to ensure
100% accuracy for stakeholder decision-making.

• Automated KPI Dashboarding: Built and maintained automated, real-time reporting
dashboards to visualize core business and financial KPIs (ROI, conversion costs, operational
metrics).
• Cross-Platform Data Integration: Engineered seamless data integration between tracking
platforms (GA4, Microsoft Clarity), structuring raw data for deep analytical queries.
PROJECTS & ACADEMIC EXPERIENCE

End-to-End Chess Data Analytics & ETL Pipeline (Python, SQL, PostgreSQL)

• ETL & Data Architecture: Developed a full ETL pipeline using Python (berserk) to extract
200+ raw records via API, cleaning and structuring the data into a custom-designed
PostgreSQL database.

• Statistical Analysis: Conducted exploratory data analysis and feature engineering using
Pandas and NumPy, analyzing rating differentials and time-series performance metrics.

• Data Visualization: Created detailed statistical reports and visualizations using Matplotlib
and Seaborn to uncover growth patterns and performance correlations. (Published on
LinkedIn).
University Project: "Silify!" (App Development) | Analyst

• Designed database schemas and structured data flows to ensure reporting consistency.

• Managed team tasks and workflow documentation using Agile tools (Trello/Jira concepts).

EDUCATION & CERTIFICATIONS

Lviv Polytechnic National University — Bachelor in System Analysis (2024 – Present)

• Core coursework: Mathematical Statistics, Probability Theory, Operations Research,
Predictive Modeling, Systems Architecture.

• Basic Financial Acumen: Strong quantitative background with an understanding of core
business, operational, and financial KPIs.

Relevant Certifications:

• Microsoft Excel — from Beginner to Advanced (Udemy) — Focused on data processing,
Pivot Tables, Power Query, complex analytical formulas, and introduction to Macros/VBA.

• The Complete SQL Bootcamp (Udemy) — Advanced querying, analytical functions,
complex joins, and database optimization.

• The Complete Tableau Bootcamp (Udemy) — Building interactive business and financial
reporting dashboards.

PERSONAL QUALITIES

• Analytical & Detail-Oriented: Exceptional focus on numbers, data accuracy, and
identifying anomalies in complex datasets.

• Fast Learner & Adaptable: Thrives in dynamic, structured environments; eager to quickly
master new audit tools, workflow systems (Jira/Confluence), and advanced ETL platforms
(Alteryx).
• Team Player: Proven ability to collaborate effectively across technical and business teams,
ensuring on-time delivery of reporting requirements.