Особисті дані приховані

Roman Muzyka

Data Analyst

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

Summary of With over two years of experience as a Data Analyst, I specialise in roles such as Data Engineer and
Qualifications Data Analyst. At blackthorn.ai from 2022 to 2024, I assumed the role of a Data Engineer, handling
tasks such as ETL configuration, migration from Talend to SSIS, and database schema development. I
also crafted views and procedures for data generalisation, developed Jet Reports, and constructed
OLAP cubes to optimise report generation. Furthermore, I enhanced workflows in SSIS and provided
technical support to clients. My expertise spans database architecture, SQL, OLTP, OLAP, ETL
processes, and business intelligence, while my Agile methodologies proficiency includes Scrum in Jira
and Kanban in Notion. Additionally, I created views in Microsoft SQL Server DB and configured data
flows for visualization in Tableau. In 2021, I joined PwC as a Data Analyst, contributing to a range of
projects focused on audit analytics. I used SQL, Excel, and Python, along with tools such as Microsoft
SQL Server, Alteryx, and Adobe Pro, to interact with databases and execute tasks within the Scrum
methodology. In my role as KYC Analyst, I participated in projects aimed at regulating the work of
global financial crimes professionals, ensuring compliance and efficiency by gathering and analysing
documentation, and reviewing client accounting procedures. My professional journey is complemented
by a Master's degree in Artificial Intelligence, which has fostered advanced analytical skills that drive
my passion for problem-solving and collaborative work environments.

Skills
Programming Languages/Technologies Operating Systems
 Python3  Microsoft Windows 7/10
 Numpy/Pandas/Seaborn/Matplotlib/Keras  Ubuntu16 (on VM)
 SQL
 SSIS
 HTML/CSS/JS (basic) Frameworks/Libraries
 Software Architecture Design / UML / Design Patterns  Flask
/ SOLID  Django
 Technical Documentation/Architecture/CRC
 CSV/XML/JSON/YAML
Development Tools
RDBMS  Tableau
 MySQL  PyCharm
 PostgreSQL  VS/VScode
 Microsoft SQL  Alteryx
 SQLite3  Jet Reports
 GitHub
 DMS (Digital Management System)
Methodologies (PwC developed Jira analog)
 Agile, Scrum, Kanban  Fenergo
 Pair Programming  Orange
 Waterfall

Experience

blackthorn.ai
 Roman Muzyka
Data Analyst

Project The primary objective of the project is to overhaul the data management infrastructure, encompassing
Description the migration and processing of data while preserving business rules and reporting formats. This entails
transferring data and ETL logic from Talend to SSIS, alongside the development of strategies to
optimise data ingestion workflows. Additionally, the project involves creating a JetReports distribution
system and OLAP data cubes for web form creation, aiming to streamline data processing processes.
Furthermore, the project aims to adapt workflows to accommodate changes in data sources for accurate
statistics display in Tableau. Overall, the project will enhance data management efficiency, facilitate
better decision-making processes, and improve reporting capabilities.
Customer Health Care American company

Involvement 1,6 years
Duration
Project Role Data Engineer

Responsibilities  Configuration of ETL processes to optimize data extraction, transformation, and loading
 Development of database schemas tailored to project requirements, including architecture design and
schema creation
 Creation of Jet Reports to facilitate data analysis and reporting
 Design and implementation of OLAP cubes to enhance report generation and analytical capabilities
 Improvement of workflow within SSIS (SQL Server Integration Services) to streamline data
pipelines and enhance automation
 Proficiency in SQL for database querying and manipulation
 Creation of database views in Microsoft SQL Server to provide customized data perspectives
 Configuration of data flows for visualization in Tableau to facilitate data-driven decision-making
processes
 Collaboration with clients to refine and implement new ideas aimed at enhancing project outcomes
and meeting business objectives
 Conducting online meetings with clients to discuss project progress, gather feedback, and align on
new ideas for project improvement
Project Team Usually 5, occasionally more as needed
Size
Tools & Microsoft SQL Server, MySQL, Visual Studio, SQL Server Integration Services (SSIS), Tableau,
Technologies Microsoft Excel, Microsoft Teams, Jet Reports, Python3, Sharepoint, PowerShell, Scrum, Kanban.

Financial crime unit assistance (Know your client cases)
Project The project main task is to investigate and regulate the work of over 2,000 global financial crimes
Description professionals in cybersecurity, anti-money laundering, sanctions, fraud, and anti-bribery/anti-corruption
to create an adaptive, comprehensive approach that reflects that of major financial institutions and
government agencies.

Customer PwC potential clients

Involvement 4 months
Duration
Project Role Junior Data Analyst

Responsibilities  Gather and analyse documentation in accordance with regulatory requirements
 Review client accounting and operating procedures and systems of internal control and conduct audit
procedures (testing of internal controls, reviewing supporting documents, performing substantive
analytical procedures)
 Dealing with Sharepoint and Google Drive
 Technical communication
 Requirements analysis and clarification
 Estimation of tasks
2
 Roman Muzyka
Data Analyst

 Knowledge sharing

Project Team Size 10 team members

Tools & Adobe Pro, DMS, Google Search Engine, Fenergo, Sharepoint, PowerShell, Scrum.
Technologies

Assurance cases
Project Project committed to deliver quality in assurance, consulting, tax and legal services. We participate in
Description audit and other engagements for commercial banks, insurance companies, financial companies.
Customer PwC clients

Involvement 6 months
Duration
Project Role Junior Data Analyst

Responsibilities  Interaction with clients to discuss field audit issues
 Review client accounting and operating procedures and systems of internal control and conduct audit
procedures (testing of internal controls, reviewing supporting documents, performing substantive
analytical procedures)
 Participate in analysis of financial statements and preparation of reports
 Perform analytical reviews of financial information and preparing documentation supporting audit
opinions
 Utilizing specialized software to process and analyze big data sets
 Development of industry awareness, development of client relationships

Project Team Size 8 team members

Tools & Microsoft SQL Server, MySQL, Alteryx, Orange, VScode, MS Office, Klik Portal, Python, Scrum.
Technologies

“Syntext-UA”
Project The idea is to create the set of tools to process Ukrainian language using a computer (like “nltk”
Description framework for English). Our goal is the parser, which will allow recognizing POS of a given word and
its morphological properties, such as gender, tense, etc. The next stage is a syntax parser, which will
recognize the syntactic relation between words using both grammars of productions and dependency
grammar.

Customer SoftServe & LPNU

Involvement 4 months
Duration
Project Role Beginner analyst and full-stack developer

Responsibilities  Ideas analyzing and choosing the best one with team approvements
 Dividing project tasks into chunks
 Python 3 for back-end solutions
 MongoDB as the database for trained data
 Flask as the framework for WEB GUI
 HTML/CSS + JS for WEB GUI

Project Team Size 3 team members

3
 Roman Muzyka
Data Analyst

Tools & Python 3, MongoDB, Flask, HTML/CSS + JS, Pair Programming, Waterfall, PyCharm.
Technologies

Certifications Data Science Summer Course
August-September 2020
Coursera - Databases and SQL for Data Science with Python [IBM]
2020
Many other online courses, trainings, workshops and webinars

Education Master’s Degree
Lviv Polytechnic National University, Computer Science, Artificial Intelligence Systems
Graduated in 2023
Bachelor’s Degree
Lviv Polytechnic National University, Computer Science, Artificial Intelligence Systems
Graduated in 2022

Languages Ukrainian (Native)
English (B2) (Upper-Intermediate) [FCE]
German (Elementary)
Polish (Elementary)

Hobbies Theatre acting, detectives reading, problem solving, events organization, business, sport, music,
psychology, volunteering, gaining new experiences.

4