Maciej Lipski

BI consultant, Volkswagen Group Polska
Warszawa, mazowieckie

Umiejętności

Business Intelligence Business Objects ETL Linux Microsoft Excel Microsoft Office Microsoft SQL Server Oracle SQL T-SQL VBA Adobe Photoshop Zbieranie wymagań Analiza biznesowa Analiza danych Bazy danych Analiza Hurtownie danych Prawo jazdy kat B Umiejętności analityczne praca w zespole projektowanie komunikatywność SQL Server Reporting Services (SSRS) SQL Server Analysis Services (SSAS) Integration Services (SSIS) System Mac OS X Raportowanie i analizy

Języki

angielski
biegły
rosyjski
podstawowy

Doświadczenie zawodowe

7N Sp. z o. o.
BI Developer
Grupa Cyfrowy Polsat
SQL Specialist
Grupa Cyfrowy Polsat
Developing and maintaining sales system.

Duties:
- tuning and optimizing SQL queries (MS SQL Server 2000, 2005, 2008)
- designing and developing data structures
- creating interfaces between systems
- participating in tests and deployments
- coordinating tasks in small teams
- requirements gathering
- creating technical documentation
Infinite Sp. z o.o.
Java Developer
Developing procurement system.

Duties:
- programming in SEAM (JBoss, JSF, EJB, Hibernate, Oracle)
- designing and implementation of database solutions
- adjusting existing functionalities to clients requirements
- testing code according to TDD
- creating technical documentation

Projekty

PFA Pension
Concordia Ubezpieczenia
Developing reporting system based on OLAP cubes and SSRS.

Duties:
- creating reports with SSRS 2016
- writing queries in MDX
- building OLAP cubes with SSAS
Volkswagen Group Polska
Designing and developing a data warehouse.

Duties:
- designing solution’s layers and data structures
- creating SSIS packages feeding STAGE, data warehouse and DM
- developing T-SQL scripts to import data from JSON files (SQL Server 2016)
- working in a SCRUM team
SAS Institute
Creating database of customers and interface between main campaign management system and local systems.
Duties:
- Designing data marts (SQL Server 2012)
- Creating ETL processes (SAS DI, SAS EG)
- Developing process of automatic campaign creation (SAS Marketing Automation) calling web service in SAS DI.
Volkswagen Group Polska
Data warehouse and reporting system.

Duties:
- designing and implementation of data structures (MS SQL Serer 2008R2)
- creating ETL processes (MS SSIS)
- designing and developing reports and universes in SAP Business Objects
- creating and maintaining reports publications using SAP BO
- requirements gathering
- creating technical documentation

Edukacja

Logo
Informatyka, magisterskie
Uniwersytet Marii Curie-Skłodowskiej w Lublinie

Specjalizacje

Badania i rozwój
Business Intelligence/Data Warehouse
IT - Rozwój oprogramowania
Inne