10/03/2023 updated

**** ******** ****
100 % available

Data Architect, Data Management Consultant, Data Analyst, Data Warehouse Consultant

Poland
Worldwide
Poland
Worldwide

Profile attachments

Syrokosz CV.docx

Apache AirflowAmazon Web ServicesData AnalysisArchitectureMicrosoft AzureC Sharp (Programming Language)CommunicationData ArchitectureInformation EngineeringExtract Transform Load (ETL)Data ManagementData ModelingData QualityData Vault ModelingData WarehousingDialectical Behavior TherapyGovernanceJinja (Template Engine)Python (Programming Language)Physical LayersMicrosoft SQL ServersMicroStrategyOracle ApplicationsWindows PowerShellSAP ApplicationsSAP HANASemanticsStored ProcedureSQL DatabasesStakeholder ManagementStock ControlTeradata SQLTestingData ScienceInformatica PowercenterDashboardsEr-WinStar SchemaRestful ApiLegacy SystemsDatabricksControl M
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

Azure, Snowflake, Teradata, AbInitio, ActiveBatch, MicroStrategy, Confluence, JIRA, SQL, BTEQ, Python

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

Astronomer

2023

Teradata 12 Certified Professional

Teradata

2011


Contact form

Log in to get in touch

You need to be logged in to use the contact form.

Sign upLog in