Paweł Białecki

Migrated data warehouse from SQL Server to Snowflake, resulting in increased operational efficiency.
Converted SSIS packages into Snowflake procedures to modernise data workflows.
Designed and executed data model implementations for better analytics support.
Implemented ETL processes in the data warehouse, ensuring effective data flow.
Developed PowerBI semantic models and tailored reports to facilitate business insights.
Conducted OLAP and Tabular migrations to Snowflake, advancing analytical performance.

• Snowflake
• SQL Server
• Microsoft SQL Server Integration Services (SSIS)
• Microsoft Transact-SQL (T-SQL)
• Azure Data Factory
• PowerBI
• Data modelling and design
• Kimball, Inmon methodolody
• Extract, transform, and load (ETL)
• Scrum

Main responsibilities: Migrate data warehouse from SQL Server to Snowflake. Migrate SSIS packages to Snowflake procedures. Data model design and implementation. Data warehouse ETL processes implementation. Create PowerBI semantic models and reports. OLAP and Tabular migration to Snowflake.

• SQL Server
• Snowflake
• Microsoft SQL Server Integration Services (SSIS)
• Microsoft Transact-SQL (T-SQL)
• PowerBI
• Data modelling and design
• Kimball, Inmon methodology
• Extract, transform, and load (ETL)
• Scrum

Main responsibilities: Data modeling with Data Vault 2.0. Delivering automated ETL solutions based on BIML and SSIS. Developing SQL ETL procedures in T-SQL. Optimization of Data Vault access layer views.

• SQL Server
• Microsoft SQL Server Integration Services (SSIS)
• Microsoft Transact-SQL (T-SQL)
• Power Designer
• Data modelling and design
• Data Vault 2.0
• BIML
• Extract, transform, and load (ETL)
• Scrum

• Main responsibilities: design data model in Kimball and Inmon methodology, developing ETL processes with Azure Data Factory, T-SQL, and Azure Synapse Analytics.
• SQL Server
• Azure Synapse Analytics
• Microsoft Transact-SQL (T-SQL)
• Azure Data Factory
• Data modelling and design
• Kimball, Inmon methodology
• Extract, transform, and load (ETL)
• Scrum

• My main responsibilities as a ETL Developer are creating, modeling and design data model in Kimball and Inmon methodology and developing ETL processes loading data to data warehouse. I was involved in every phase of data processing. From processes loading data from source systems to Stage area, transformation data in NDS and DDS layer as far to implementing data sharing to Cognos through databases views.
• During the last two years while working in PGE I have taken a part in following ETL projects:
• - DWH SAP data integration. Modules FI, CO and MM
• - Project BRI. Processing data from project management system
• - Billing system data loading to DWH area
• - Implementing sourcing system model and processes
• - Implementing HPSM data model and processes
• During my work on these projects I was in charge of creating data model and data processes in Enterprise Architect, implementing SSIS packages with data flows, T-SQL scripts and automation using a BIML scripts.
• I have implemented the automated tests to check data quality after area data loading.
• I am also responsible for deploying projects to production and testing environments.
• Microsoft SQL Server 2017
• Microsoft SQL Server 2014
• Microsoft Transact-SQL (T-SQL)
• Microsoft SQL Server Integration Services (SSIS)
• Enterprise Architect
• Data modelling and design
• Kimball, Inmon methodology
• Extract, transform, and load (ETL)
• BIML
• Scrum

• Managing the migration team in e-Podatki project at the Ministry of Finance.
• - Design and implementation of data conversion of tax systems of the Ministry of Finance to new systems (SQL Server 2012, Oracle) including migration from old data model to new data model.
• - Optimization of the database conversion process (SQL Server 2012), including the design of optimal structures (selection of appropriate field types, partitions, cluster and non-clustered indexes), optimization of queries by analyzing SQL query code and creating and selecting appropriate index types.
• - Administration and management of the SQL Server 2012 conversion database.
• - Planning database solutions based on structures related to migration.
• Additionally, running the team in the Scrum method. Planning, implementation and review of sprints.
• Assigning tasks to team members. Technical and analytical support for team members.
• Microsoft SQL Server 2012
• Microsoft SQL Server Integration Services (SSIS)
• Leadership
• Oracle
• Microsoft VB.NET
• Scrum

• Working on two database warehouse for two business clients one in telecom industry and one for huge taxi corporation in Poland.
• - Collecting functional requirements for new functionalities of database warehouse including operational reports, analytical reports and analytical OLAP cubes.
• - Design data model in Kimball and Inmon methodology
• - Maintenance and development of ETL process powering database warehouses in Pentaho Data Integration technology.
• - Maintenance and development BI tools based on Pentaho Community platform used in clients database warehouses including analytical and operational reports.
• - Maintenance, architecture creation and development of multidimensional OLAP data structure used for business analysis.
• - Maintenance and administration of PostgreSQL database incl. version 9.2 and version 9.4.
• - Programmers support in database design and optimization area.
• PostgreSQL
• Online Analytical Processing (OLAP)
• SQL Database Administration or SQL Server Administration
• Data modelling and design
• Kimball, Inmon methodology
• Extract, transform, and load (ETL)
• Data analysis
• Pentaho

• - Design and development of system Concret - data warehouse that stores the data of all the services provided by Bauer New Media. Technology used: J2EE and PostgreSQL database.
• - Implementation of MAP System - analytical system used for customer segmentation services company Bauer New Media and marketing mailings.
• - Creation and maintenance of Premium SMS services in J2EE, Pearl, PHP with application server Jboss.
• - Preparing analyzes and statistics reports for the marketing department.
• - Design and optimization of database PostgreSQL v8.3 and 8.4.
• PostgreSQL
• Java
• Java EE
• Java SE
• Hibernate
• MySQL
• Perl

• Work on maintenance and development of the Teradata data warehouse in Ponkomtel.
• - Design and implementation of warehouse conciliation processes.
• - Design and performance of the software to handle dwh meta data.
• - Work on the data mart calculates ARP'u services pre-paid customers.
• - Work on the implementation of a new billing system to analyze pre-paid customer services processes.
• - Optimization of processes running on the warehouse in terms of execution speed analytical queries.
• NCR Teradata
• SQL
• Extract, transform, and load (ETL)
• Database Designer/Programmer. BI Developer.
• Perl

• - Maintaining Postgres databases, query optimization, index creation, standardization and creating procedures in PL / pgSQL.
• - Database Management MS SQL Server 7.0 used for IVR and RADIUS
• - Management and development of database applications based on databases PostgreSQL, MySQL.
• - Perl - programming network applications operating system Premium SMS to the Polish market and partners in the USA. Creation, development and maintenance of applications and server system Premium SMS - SMS Chat.
• - PHP, Smarty - web applications for reporting and service management Premium SMS and SMS Chat.
• - Java - development and maintenance of client software SMS Chat.
• - ASP.Net - programming and application maintenance reporting settlements operators SMS Chat.
• - Preparing analyzes and reports for the marketing department.
• - Project management using the system trac and svn.
• - Working with partners from the US.
• - Contact partners in technical matters.
• PostgreSQL
• Microsoft SQL Server
• Perl
• Java SE
• Swing
• PHP
• C++
• C#
• WinAPI

• - Work on creating a system Inflection Point Systems, BI applications based on multidimensional databases (Analysis Services, Essbase), and .NET in C #.
• - Creation and development of common controls api used in applications to create reports.
• - Creating dimension selector – tool to select dimensions from OLAP cubes.
• - Creating calculate members calculator – tool to calculate calculate members on OLAP cubes measures.
• - Developing a database application of MS SQL Server 2000.
• .NET Framework
• Microsoft ASP.NET
• C#
• Microsoft SQL Server 2005
• SQL Server Analysis Services (SSAS)
• Microsoft SQL Server