Roman

ROMAN PASTERNAK
Madrid, Spain|[открыть контакты](см. выше в блоке «контактная информация») | [открыть контакты](см. выше в блоке «контактная информация»)|Linkedin

PROFESSIONAL SUMMARY​

Eager and detail-oriented Junior Business Analyst with a robust foundation in Computer Science, System Analysis, and Data
Science. Proficient in business process modeling, requirements gathering, and data-driven problem-solving. Adept at translating
complex data into actionable insights, fostering stakeholder collaboration, and delivering high-quality project outcomes. Skilled in
SQL, data analysis, and visualization, with hands-on experience in .NET development and database management. Passionate
about leveraging analytical and technical expertise to support dynamic business environments.

Technical Skills
●​ Programming Languages: Python, SQL, R (Intermediate), C#/.NET (Basics)
●​ Business Analysis & Requirements Management:Stakeholder Interviews, User Stories, Use Cases, Business
Requirement Documents (BRDs), Scope Definition, Functional & Non-functional Requirements, Acceptance Criteria
●​ Modeling & Process Design: BPMN (Business Process Model and Notation), UML (Use Case, Class, Sequence, State
Diagrams), Context Diagram, Entity-Relationship Diagram (ERD), Data Flow Diagram (DFD), Wireframing
●​ Data Analysis & Visualization: SQL (Advanced), Python (Pandas, NumPy), R (Intermediate), Data Cleaning &
Transformation
●​ Databases & Data Management: MongoDB, Neo4j, NoSQL, Relational & Non-relational Database Design, Data
Normalization, Constraints & Triggers
●​ Version Control & Collaboration:Git, GitHub, Documentation, Code Review, GitFlow Workflow

EDUCATION​
University of Carlos III de Madrid​ Madrid, Spain
Bachelor of Engineering​ 09/2023 – 06/2027
Major in Data Science and Computer Engineering
GPA: First Class Honours
Relevant Coursework: Database Management, Computer Structure, Automata Theory and Compilers
Key Projects:
●​ Designed a chess database using SQL and MongoDB for efficient data handling.
●​ Solved complex mathematical problems using Assembly language
●​ Built automata models (PDA, Turing Machine, DFA/NFA) for computational tasks.

Lviv Polytechnic National University​ Lviv, Ukraine
Bachelor of Science​ 2020 – 2024
Major in Computer Science
GPA: First Class Honours
Relevant Coursework: Data Structures and Algorithms, Object-Oriented Programming, Web-Techs and Web-design​

SoftServe courses​ Lviv, Ukraine
Foundation Business Analysis​ 07/2024 – 10/2024
Hours of professional development: 35
Key Topics Covered:
●​ Requirement Elicitation
●​ Process Modeling
●​ Stakeholder Analysis
●​ User Stories
●​ Scope Definition

LATEST PROJECTS​
SWIM TIMING MEASUREMENT SYSTEM​ 2022
Personal Business Analysis Project
Performed comprehensive business analysis and system design for an automated swimmer time-tracking solution, applying
industry-standard modeling techniques and best practices.
●​ Created a Context Diagram to define system boundaries and external actors (coaches, swimmers, timing sensors).
●​ Modeled swim event workflows using BPMN (Basic & Advanced) to capture time capture, ranking, and result validation.
●​ Developed Use Case Diagram and described key user interactions with the system.
●​ Designed ERD for swimmers, events, results, and timing devices.
●​ Built Class, Sequence, State, and Data Flow Diagrams to describe system logic and lifecycle.
●​ Applied Agile mindset with incremental modeling and stakeholder feedback loop.

RELATIONAL DATABASE DESIGN FOR ONLINE CHESS PLATFORM [GitHub]​ 2024
Coursework | Grade: 9.5/10
Designed and implemented a relational database to manage players, tournaments, clubs, and rewards for an online chess
platform. Achieved a 10/10 mark for the project, showcasing excellence in SQL development and database design.
●​ Created a normalized database schema with primary, foreign, and alternative keys to ensure data integrity and scalability.
●​ Developed advanced SQL queries for analytics, including player rankings, tournament statistics, and reward tracking.
●​ Implemented triggers to automate processes like rating updates, gift stock adjustments, and rule enforcement.
●​ Utilized CHECK constraints and domain validations to maintain data accuracy and enforce business logic.
●​ Delivered complete SQL scripts for schema creation, deletion, and data manipulation, optimized for performance.

MongoDB DATABASE DESIGN FOR CHESS RESULTS AND SALES PLATFORMS [GitHub]​ ​ 2024
Coursework | Grade: 9/10
Designed and managed a MongoDB-based sales database to organize and analyze business data effectively.
●​ Imported and normalized JSON sales data into MongoDB collections, ensuring structured and accurate data
representation.
●​ Developed advanced queries to filter sales by location, purchase method, and customer demographics.
●​ Implemented aggregation pipelines to calculate total sales by location, purchase method, and customer satisfaction.
●​ Performed update operations to modify records, correct anomalies, and standardize data attributes.
●​ Created text indexes to enable efficient keyword-based searches for customer feedback analysis.