Roman

ROMAN PASTERNAK
Barcelona, Spain|[відкрити контакти](див. вище в блоці «контактна інформація») | [відкрити контакти](див. вище в блоці «контактна інформація»)|Linkedin

PROFESSIONAL SUMMARY

Operations & Data Analyst with experience supporting EU logistics and Quick Commerce operations at Amazon.
Skilled in SQL, Python, automation, and operational analytics with a focus on process optimization, risk monitoring, and
scalable workflow improvement across fast-paced operational environments.

Technical Skills

● Data Analysis & Automation: SQL, Python (Pandas, NumPy), Data Cleaning, Automation Scripts, Reporting, API
Integration
● Analytics & Visualization: Power BI, Excel, Data Interpretation, KPI Tracking, Operational Analytics
● Databases: PostgreSQL, MySQL, MongoDB, Neo4j, Relational & Non-relational Databases
● Business & Operations: Process Optimization, SOP Development, Risk Monitoring, Capacity Planning, Stakeholder
Coordination
● Programming & Tools: Git, GitHub, C#/.NET (Basics), R (Intermediate)

EXPERIENCE

Operations & Data Analyst – EU CO Risk & Flow Barcelona,
Spain
Amazon 08/2025-12/2025

Supported network-wide sorting and logistics planning operations across Europe and the UK, driving performance
tracking, risk monitoring, and process optimization to align station plans with operational capacity and demand forecasts.

● Supported planning operations across 100+ EU delivery stations.
● Performed operational analysis and capacity validation using large-scale logistics datasets to identify bottlenecks,
operational risks, and throughput constraints.
● Built internal automation tools to streamline station-data retrieval workflows, reducing manual planning and lookup time
from approximately 1 hour to under 10 minutes.
● Monitored transportation and inbound logistics performance, proactively escalating risks related to delayed trucks and
unprocessed package volume.
● Improved operational visibility and workflow efficiency through standardized reporting and tracking processes.

Operations Analyst – EU Quick Commerce Barcelona,
Spain
Amazon 12/2025-Present

Supporting EU Quick Commerce operations for Amazon Fresh and rapid-delivery services, ensuring operational
readiness, delivery-performance compliance, and scalable expansion across fast-paced live operations.

● Supported live EU Quick Commerce operations, ensuring compliance with 30-minute delivery performance targets.
● Developed SOPs, onboarding documentation, and standardized operational processes to support scalable team growth and
operational consistency.
● Conducted real-time operational monitoring and risk assessment, proactively identifying delivery disruptions and
coordinating mitigation actions.
● Collaborated directly with Delivery Partners and cross-functional stakeholders to resolve operational issues and maintain
service-level performance.
● Produced operational performance reports and participated in planning discussions for new station launches and
operational expansion initiatives.

EDUCATION

University of Carlos III de Madrid Madrid,
Spain
Bachelor of Engineering 09/2023 – 06/2027
Major in Data Science and Computer Engineering
Relevant Areas:
● Data Analysis
● Database Systems
● Algorithms & Data Structures
● Computer Systems
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.
● Designed a business and system analysis solution for automated swim timing and event tracking.
● Modeled operational workflows, system interactions, and database structure using BPMN, UML, and ERD methodologies.
● Defined system requirements and stakeholder interactions for coaches, swimmers, and timing devices.
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.
● Designed and implemented a relational database system for managing players, tournaments, rankings, and rewards.
● Developed analytical SQL queries for ranking analysis, tournament statistics, and reward tracking.
● Implemented triggers, constraints, and validation logic to automate operational processes and ensure data integrity.
● Optimized relational schema design for scalability and 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.
● Built and managed a MongoDB database for sales and customer analytics.
● Developed aggregation pipelines and advanced queries to analyze customer behavior, sales trends, and purchasing
patterns.
● Performed data normalization, update operations, and indexing optimization to improve query efficiency.