Business Intelligence / Data Warehouse developer

CURRICULUM VITAE

Piotr Przybyłek

Address:

**-*** ****** (Danzig)

Poland

Birth date: 13th August 1985

+485********

Phone:

acanl2@r.postjobfree.com

E-mail:

EDUCATION:

October 2004 – September 2009

Gdańsk University of Technology, Faculty of Electronics,

Telecommunications and Informatics, specialization: Information

Technology – Software Engineering and Databases (Master’s degree

thesis – Comparing OLAP engines: Oracle OLAP option and SQL

Server 2005 Analysis Services (Business Intelligence solution for the

faculty implemented in SSAS/SSIS 2005 and Oracle OLAP

technologies was a major part of the thesis)

February 2007 - January 2010

Gdańsk University of Technology, Faculty of Management and

Economics; specialization: Small Business Economics and

Management (Master’s degree studies)

PROFESSINAL EXPERIENCE:

July 2007- August 2007 (Comarch SA)

Practice in Comarch SA (focused on Business Intelligence techniques

– Microsoft BI stack (SSIS,SSAS,DTS))

July 2008 –May 2009 (own company)

Running own company established with a colleague (mainly Web

projects based on PHP + MySQL – Code Igniter/Kohana framework)

January 2010 – June 2013 (Nordea Bank)

Position: Data Warehouse developer in Oracle technologies

Permanent work in Nordea Bank Poland (a subsidiary of Nordea

Bank AB – one of the biggest Scandinavian bank). Job position

1

description:

- main, leading designer and implementer of Data Mart for

Management Information System for 4 countries (Poland, Latvia,

Lithuania and Estonia). The system has been created from scratch

based on Oracle Business Intelligence tools – mainly Oracle OLAP

option (using AWM), Oracle RDBMS and OBIEE. The MIS system

leverages extensively the best of Oracle RDBMS and Oracle OLAP

technologies. Complex meta-data driven PL/SQL was used in

implementation of ETL processes.

June 2013 - till now (Infoprojekt)

Position: Data Warehouse / Business Intelligence developer in

Microsoft technologies. Contract based work at Infoprojekt. To main

duties belong: designing Data Mart / Data Warehouse schema;

shaping and implementing ETL processes in SSIS (SQL Server

Integration Services and SQL Server); creating and feeding OLAP

structures in SSAS (SQL Server Analysis Services).

ACTIVITIES OUTSIDE UNIVERSITY AND WORK:

March 2006- February 2007

Activity in Erasmus Student Network at Gdańsk University of

Technology (During this time I was a mentor of a student from

Germany)

SKILLS:

• Business Intelligence:

• Oracle 11g:

• Oracle 11g OLAP Option

• Oracle Warehouse Builder 11g

• AWM 11g (Analytic Workspace Manager

11g) (designing cubes, dimensions and

hierarchies, designing data mappings)

• Oracle Business Intelligence Enterprise

Edition 11g –OBIEE (creating repositories,

dashboards based on multidimensional data

model (star schema, OLAP cubes))

• Ability to create complicated measures in

analytical languages like Oracle OLAP

Expressions, Oracle OLAP DML

• SQL Server:

• Analysis Services - SSAS (creating ROLAP

and MOLAP cubes and dimensions,

Multidimensional & Tabular model)

• Integration Services – SSIS (designing ETL

processes)

• Ability to create complicated measures in

analytical languages like MDX, DAX

2

• Data Warehouses:

• Deep understanding of star/snowflake data model

• Multidimensional / 3NF design concepts

• Ability to create efficient ETL processes based on

PL/SQL or Transact-SQL or specific ETL tools (like

SSIS, OWB)

• Advanced handling of SCD2, backdate loading of

Data Warehouse

• Databases:

• MySQL (good level)

• MS SQL, (advanced level - advanced T-SQL

programming)

• Oracle (advanced level - advanced SQL and PL/SQL

programming)

• dBase (medium level)

• Other: networks(LAN, WLAN, TCP-IP); Matlab;

OTHER SKILLS:

• Ability to work alone and in a team

• Communication skills

FOREIGN LANGUAGES:

• English (Management studies in English; used on daily basis at

current employer)

• German – high school exam from German (9 years ago good oral

and written communications skills – now reminding is needed)

PROFESSIONAL INTERESTS:

• Statistics, Data Mining, Neural networks,

• Business Intelligence

• Forex

ANOTHER INTERESTS:

• Football (as player and viewer)

• F1 (only as viewer ;) )

• Sailing (yacht navigator)

3

Contact this candidate