I have been working for more than 15 years in international data engineering, warehousing and analytics projects (both on-prem and cloud-Azure or AWS). Over this time I have hold various roles like data and analytics engineer, data modeler or data architect. I used to interact with business and very technical stakeholders. In my work I always want to understand 'as-is' and 'to-be' solution for effective and high quality delivery of a solution or end product. Therefore, I put a lot of focus on effective communication and interaction with co-workers (very important for remote work scheme) or data analysis. I also like to deep dive into technology used during projects to get the best out of them.
As a data and analytics engineer I worked with various dwh technologies (Snowflake, Teradata, SAP Hana, SQL Server, Oracle), ETL/ELT pipelines languages (like SQL, Python, Bteq, Stored Procedures, C#, PowerShell, REST API, Jinja recently), and ETL/ELT tools (DBT, Data Stage, AbInitio, Informatica PowerCenter, getting familiar with Databricks and Coalesce). I have also performed many optimizations for SQL code, physical/logical data model, or load sequence. I have also trained and lead a group of data engineers. In the analytics environment I am skilled in tools like MicroStrategy or Metabase.
As a data modeler I worked with Erwin and SAP Power designer for modeling semantic/business logical and physical layers for BI or data science usage. I have good knowledge of Kimball, Inmon or Data Vault modeling techniques, and follow new trends like Unified Star Schema.
As a data architect I took part of re-designing of a data warehouse for Data Vault architecture, worked with various scheduling tools (like ActiveBatch, AbInitio, Control-M, recently getting familiar with Airflow), implemented Data Quality Governance end-to-end (testing, DQ dashboard, Monitoring), or supported migration projects from legacy systems to new platforms.
Experience
Professional experience10+ years
Freelancer since2012
Languages
EnglishGoodPolishGoodSpanishGood
Project history
Data Analytics Engineer
Lidl (Schwarz IT KG)
- Delivery of performance-optimized construction in data marts
- Conception, modeling, implementation, and further development of data warehouse
- SQL development for Teradata and Snowflake.
- Support of the business consultants with technical questions
Data Quality Governance Consultant, Data Warehouse Consultant
VTB Capital Bank Europe
1. DWH Efficiency Project
- Various architecture and design improvements
- Redesign ActiveBatch implementation
- Support work on new DWH architecture
2. Implementation of Data Quality Governance for Business Intelligence organization
- Implement Data Quality Management process
- Setup and configure data quality monitoring tool (BigEval)
- Setup analytical reports and data quality metrics
BiGeval, MS SQL Server (SSMS), Cognos Apparo Fast Edit, Power BI, Metabase, C#, PowerShell, Rest API, ActiveBatch, JIRA, Confluence
Data Modeler, Data Analytics Engineer, Tech Lead
Schwarz IT KG (Lidl)
Building a new business integration data layer to support more flexible, better and faster data
analytics and reporting.
Main tasks:
* data analysis and business documentation
* data modelling and mapping
* SQL coding
Teradata, MicroStrategy, AbInitio, SAP Power Designer, Jira
Data Warehouse Analyst
AIB Bank
Delivery of data quality framework to measure consistency and accuracy across all levels of
transformations for given metrics. This was a European Central Bank requirement.
Teradata, Statistics
Data Architect, Data Modeler, Data Analytics Engineer, Tech Lead, Senior Data Engineer
Nordea Bank AB
During various projects at Nordea I have gained business knowledge about credit risk (like Basel or
Nordea internal regulations), regulatory (like FinRep, or IFRS9), and management reporting (like
Customer Profitability or Management KPIs) data aspects. I have also accomplished many optimization
tasks for SQL and Teradata technology usage.
My positive attitude, good communication and friendly personality allowed me to created good
relationship during projects to many co-workers and client employees. The good relationship was very
important for me, as most of the time I worked remotely.
* Delivered end-to-end architecture solution proposal for credit risk analysis tools
* Provided deep data analysis at all data warehouse layers (stage, integration, access) for new
reporting tools and migration projects
* Managed team of 5-10 off-shore ETL developers
* Mentored junior consultants
* Designed and modeled access layers
* Created data mapping documents to be used by ETL developers
* Technology Advisor for developing Semantic Layers
* Optimized SQL code, load procedures, physical data model, logical data model, space consumptions
using various techniques and technology features.
* Developed various load procedures for Shared Business Semantic Layer (Star data model) from
Teradata LDM (3NF model)
Teradata, Essbase, Business Objects, SAP Hana, Data Stage, Jira, MS Office tools
Data Warehouse Consultant
Teradata Corporation
* Financial Services Industry expertise
* DW Architecture for BI applications
* SQL development
* Semantic Layer/Application LDM and PDM design
Business Intelligence Consultant
Microstrategy
Project delivery work such as: reports development, upgrades, migrations, testing, pre-sales,
project planning.
* Provided for Microstrategy product suite and its underlying technologies.
* Developed relationships with Microstrategy customers and partners
* Solved problems reported while using Microstrategy product suite through analytical
troubleshooting abilities.
* Prioritized and communicated product defects and enhancements to development teams
Business Intelligence Consultant
Hewlett-Packard
Technology Consultant for Business Intelligence and Data Warehouse technologies, such as Siebel
Analytics, Oracle Business Intelligence, Bea WebLogic, Oracle WebLogic, Fast Radar, Control-M,
Informatica PowerCenter.
* Managed communication between all projects' stakeholders
* Created and improved Change and Release Management processes for BI technologies
* Coordinated Change and Release Management procedures based on ITIL methodology
Security specialist
Orange - France Telecom Group
Certificates
Microsoft Certified: Azure Data Fundamentals
Microsoft
2023
SnowPro Core Certification
Snowflake
2023
dbt Developer
dbt Labs
2023
Astronomer Certification for Apache Airflow Fundamentals