Vlada

Vlada Skulska
Data Analyst
Ternopil, Ukraine | Remote | [open contact info](look above in the "contact info" section)
[open contact info](look above in the "contact info" section) https://github.com/VladaSkulska
Analytical and results-driven Junior Data Analyst with a solid background in Software Engineering. Proficient in
extracting, transforming, and visualizing data to drive informed business decisions. Skilled in writing optimized
SQL queries, building comprehensive dashboards in Tableau. Seeking an opportunity to deliver meaningful
business value and optimization through data-driven insights.
SKILLS
Databases & Warehouses: SQL (CTEs, Window Functions, Joins, Aggregations), PostgreSQL,
Google BigQuery
BI & Analysis: Tableau, Excel / Google Sheets (Pivot Tables, Advanced Formulas), Data
Cleansing, Exploratory Data Analysis (EDA)
Product Metrics: LTV, CAC, Retention, Churn, ROAS, ROI, Funnel Analysis
● Development Tools & Technical Tools: Jira, Postman, REST APIs, Git, GitHub, VS Code
● Methodologies: Agile, Scrum
● Languages: English (C1 – Advanced), Ukrainian (Native)
EXPERIENCE
E-Commerce & Financial Data Pipeline (Data Analytics) | August 2026
Tech Stack: PostgreSQL, SQL, Google Sheets / MS Excel (XLOOKUP, Pivot Tables, Heatmaps), AI
Data Analysis, Tableau Public, Git, GitHub
Cleaned and validated transactional data in PostgreSQL using SQL (CTEs, aggregations,
joins), isolating net sales, filtering null IDs, and handling return anomalies.
Engineered data enrichment models in MS Excel using XLOOKUP with a custom region-
mapping dictionary, dynamic KPI calculations (ROUND, SUM), and multi-level Pivot Tables
(Region –> Country -> Year-Month).
Applied Heatmaps and LLM-assisted data analysis to identify seasonal sales spikes and high-risk
return markets.
Designed and published an interactive Tableau dashboard visualizing core KPIs (Net Revenue,
Average Order Value, Regional Performance, Country Drill-Downs) for executive reporting.

LexiContext | Full-Stack Developer (Data & Backend Focus) | January 2026 - Present
Tech Stack: .NET 8, ASP.NET Core, EF Core, PostgreSQL, FluentValidation, xUnit, Moq, Git
Architected and optimized a PostgreSQL database schema for a multi-language vocabulary
system, ensuring data integrity, strict validation (FluentValidation), and optimized querying.
Designed RESTful APIs & Data Access Layer using .NET 8 and Repository Pattern to securely
handle client-database transactions and data transformations.
Integrated LLM APIs for automated contextual data generation and analytics tracking.

CERTIFICATIONS
Google Data Analytics Professional Certificate Coursera (In Progress)
Intermediate SQL (joins, aggregations), data cleansing, and Tableau dashboards.
General QA Course TechMagic Academy
Full-cycle manual testing, test design techniques, API testing, and bug tracking.

EDUCATION
IGOR SIKORSKY KYIV POLYTECHNIC INSTITUTE (KPI) Kyiv, Ukraine
Faculty of Program Systems and Applied Mathematics
Master of Software Engineering | 2026 – 2028 (Expected)
Bachelor of Software Engineering | 2022 - 2026