Віталій

Vitalii Simakhin
Junior Data Analyst
[открыть контакты](см. выше в блоке «контактная информация») [открыть контакты](см. выше в блоке «контактная информация») Lutsk, Ukraine 08.10.2002

Profile
Junior Data Analyst with hands-on experience in SQL, BigQuery, Power BI and Python. Processed
•

US financial data, Google Trends around a world, automated reports, built dashboards and
extracted insights from 100M+ rows datasets.

Technical Skills
SQL (MySQL, MSSQL) C#
data extraction, JOINs, subqueries basic scripting for automation, LinQ, OOP, Clean
Code
PowerBI
DAX, dashboard building, report automation, MS Excel
also had some experience with Looker Studio PivotTables, Power Query, VLOOKUP, formulas

Python BigQuery
Selenium, Beautiful Soup, Pandas, data scraping Hands-on experience with Google BigQuery for
querying large-scale datasets (100M+ rows)
Git
Basic experience with Git: creating repositories,
working with branches, committing and pushing
changes to GitHub. Version Control with Git for
managing code changes and tracking project
history.

Professional Experience
Zoral Labs 07/2023 – present
Operations Agent Remote
Processed and verified high-volume U.S. financial documentation, ensuring
•

98%+ accuracy.
Used Excel (COUNTIF, VLOOKUP, PivotTables) to improve validation
•

speed by 30%
Supported operational teams by identifying inconsistencies in incoming
•

data and suggesting process improvements.
Collaborated remotely with cross-functional teams to meet project goals
•

and timelines.
Analyzed US financial forms and reduced manual error rate through
•

structured workflows.
Suggested process improvements that were implemented across the team.
•
Languages
English Ukranian
Upper Intermediate, could write, speak and Native Speaker, could write, speak and read
read documentation

Projects
Crypto Market Analyzer
• Used Python (API requests + pandas) to fetch top-10 cryptocurrencies via API
• Built CSV report + streamlit dashboard to explore trends over time
• Practiced BigQuery by joining Ethereum blockchain data with token metadata

Rozetka Price Tracker
Tools: Python, Selenium, Pandas, CSV, Web scraping
Developed a tool that allows users to search for any product on Rozetka.ua and returns a
•

structured table of results
Parsed product names, prices, and links using Selenium and dynamic selectors (bypassing bot
•

protection)
Results automatically saved into a pandas DataFrame and exported to CSV and MySQL Database
•

for further analysis
Implemented user input (query + number of results) for flexible product tracking
•

Useful for market monitoring, price comparison, and demand estimation
•

Education
KHAI 09/2019 – 12/2024
Master of System Analysis Kharkiv, Ukraine