Оксана

Experience

Data Engineer 2018 - now
Conscensia - SparNord
Tasks performed:
Developed and maintained robust ETL pipelines using
Informatica PowerCenter, ensuring efficient data
integration across various enterprise systems.
Worked extensively with Netezza for data warehousing
and optimized large-scale data processing.
Designed and executed data transformations, quality

Oksana checks, and performance-tuned SQL queries to support
complex business logic.

Hoshman Migrated legacy ETL workflows to modern cloud
platforms such as Databricks, improving scalability and
Data/BI Engineer runtime performance.

Technologies:
Netezza, Informatica PWC, SAS, SAP BO, Databricks, GIT
Contact
ETL Developer 2017 - 2018
[відкрити контакти](див. вище в блоці «контактна інформація») EPAM - Chevron
Tasks performed:
[відкрити контакти](див. вище в блоці «контактна інформація»)
Design and develop SSIS packages, stored procedures,
configuration files, tables, views, and functions;
Lviv, Ukraine
implement best practices to maintain optimal
performance.
About Me Optimized performance of the queries running against
the data mart by creation of Table Partitions, Indexes
Detail-oriented and results-driven and Indexed Views.
ETL/DWBI Developer with over 9 Analyzed physical data model for ETL mapping.
years of experience in data Implemented ETL process using SSIS packages with
different data sources.
integration, performance tuning,
Created dimensions, measure groups, built a SSAS cube,
ETL/ELT pipeline development, and
performed analysis based on a datafrom cube.
production support across various
Made reverse engineering of SSRS reports, analyzed old
sectors. Strong analytical and reports and provided documentation on it.
problem-solving skills, capable of
optimizing SQL queries, enhancing Environment:
system performance, and developing MS SQL 2012, Oracle
innovative ETL solutions to meet SQL Server Management Studio (SSMS); SQL Server Data
complex data integration needs. Tools, TFS
Transact-SQL, SQL Server Integration Services (SSIS)

Technical skills
DWBI developer 2016- 2017
Business Intelligence: SSIS, SSAS,
EPAM - GoEasy
SSRS, Informatica PWC 10.5.4, SAS,
SAP BO Tasks performed:
DB: Microsoft SQL Server, Netezza Designed and supported ETL processes using SSIS and
MS SQL Server
Cloud Data Platform: Databricks
Created SSIS ETL packages based on business
Software Construction: C++, C#,
requirements
SQL, XML, Powershell
Spoken Languages: English,
Ukrainian.
 Provided L2 support for production issues and
collaborated with third-party vendors
Analyzed recurring issues and documented resolutions
Created data profiling reports using SSDT

Environment: MS SQL Server 2012, SSMS, SSDT, TFS,
Transact-SQL, SSIS

Education

Master’s Degree in Applied Mathematics 2011-2016
State University 'Lviv Polytechnics'