BI and Planning Consultant IBM and SAP

3/2017 – 1/2018

Providing consultancy services for PGE Systemy
- Migrate data for business review process from SAP Finance to TM1,
- Develop business review reports in IBM Cognos BI based on TM1 cubes,
- Design and develop system for planning strategic initiatives across all companies in PGE,
- Reports and dashboards development in Cognos BI showing strategic initiatives from TM1,
- Development of interactive dashboards and active reports,
- Providing best practice workshops how to build reports in Cognos BI based on TM1 cubes,
- Support of Cognos BI software upgrade from 10.2.2 to Cognos Analytics 11.0.7

Used tools: IBM Cognos BI 10.2.2, IBM Cognos Analytics 11, TM1 10.2.2 including Architect and Perspectives, MS SQL Server

Cognos (IBM)

4/2016 – 2/2017

Providing consultancy services for Vattenfall GmbH
- Development of ETL processes in Cognos Data Manager,
- Development of self service models in Cognos Framework Manager,
- Re-design reporting layer to fit Dynamic Cubes,
- Development of Dynamic Cubes,
- Development of interactive dashboards and active reports,
- Providing best practice workshops in report development area, including relational and OLAP sources,
- Support of Cognos software upgrade from 10.2.1 to 10.2.2

Used tools: Cognos BI 10.2.2 suite including Report Studio, Framework Manager, Data Manager
Data sources: Relational database based on Oracle 11g

Cognos (IBM)

12/2015 – 3/2016

Providing consultancy services for PGE Systemy
- Advising in data modeling, preparing structures for reporting models and dynamic cubes,
- Improving reports performance, aggregations on database layer, changing logic in reports design,
- Defining corporate report templates for reports development, defining color palette, preparing visualizations in Visualization Customizer, proper sizing for different display devices,
- Development of interactive dashboards and active reports,
- Providing best practice workshops in report development area, including relational and OLAP sources,
- Providing training sessions about Workspace and Workspace Advanced for business users,
- Supporting other developers and analysts in their daily report development work,
Used tools: Cognos BI 10.2.2 suite including Report Studio, Workspace, Framework Manager, Cube Designer,
Data sources: Relational database based on SQL Server 2012, MSAS cubes, Cognos dynamic cubes

Cognos (IBM)

6/2015 – 11/2015

Providing consultancy services for DNV GL

- Assisting in migration of Cognos data source from SQL Server to Netezza
- Recreating Cognos Framework Manager models and reports
- Implementing enterprise structure for metadata modeling, Boeing solution
- Development of Workspaces and Active reports

Used tools: Cognos BI 10.2.2 suite, SQL Server 2008, Aginity Workbench for PureData System for Analytics

IBM Cognos

10/2014 – 5/2015

Providing consultancy services for Franke AG

- Building interactive dashboards in Report Studio and Workspace using OLAP TM1 cubes as a data source
- Performance tuning, cache sharing in Dynamic Query Mode, queries improvement
- Bursting Cognos BI reports
- Providing end user trainings of Cognos Workspace
- Active Reports development in Cognos TM1

Used tools: Cognos BI 10.2.1 suite, Cognos TM1 10.2

IBM Cognos

3/2012 – 6/2014

Providing consultancy services for UBS AG Firm Wide-Risk IT

- Relational and dimensional metadata modeling in Framework Manager, including parameterized queries,
- Building advanced dynamic and interactive reports in Report Studio including Active Reports,
- OLAP cubes development in Transformer,
- Building cube views in Power Play Studio and Analysis Studio,
- OLAP cubes development in TM1,
- Development of Cognos TM1 reports in Perspectives for MS Excel,
- Writing cube rules and development of Turbo Integrator processes in Cognos TM1,
- 2nd level support of Cognos BI and TM1 environment, using ServiceNow and JIRA,
- Administration of Cognos BI environment including security, job scheduling and monitoring
- OLAP cubes migration from Cognos series 7.3 to Cognos 8.4,
- Integration testing, functional, performance, usability tests (test cases with HP Quality Center)

Used tools: Cognos BI 8 suite, Cognos TM1 9.5, Toad for Oracle, Toad Data Point, HP Quality Center, Jira

IBM Cognos, Oracle-Anwendungen, Testen

6/2010 – 2/2012

Member of Business Intelligence Competency Center for EMEA

- Responsible for requirements gathering, development, company support and continuous improvement,
- Dimensional modeling in Framework Manager,
- Design and development of ad-hoc reporting models,
- Multilingual reports and dashboards development in Report Studio and Workspace Advanced, including cascading prompts, master detail relationships, page sets, conditional rendering and formatting, drill-through functionality
- Distributing reports using bursting functionality,
- Creating database tables, views, procedures in Toad for Oracle,
- Attendance in Cognos 8 to Cognos 10 migration,
- Providing end users trainings of Report Studio, Analysis Studio and Workspace Studio,
- Writing documentations,

IBM Cognos, Oracle-Anwendungen, SQL

3/2008 – 5/2010

IBM Cognos BI reporting solution for Dobrowolscy Sp. z o.o. Polen/Warschau

- Create dynamic and complex multilingual reports based on relational meta data models, including cascading prompts, page sets, conditional rendering and formatting,
- Maintenance of Cognos BI reporting environment,
- Bursting reports,
- Scheduling jobs, monitoring jobs using events in Event Studio,
- Creating tables, views and procedures using SQL Server Management Studio,
- 2nd level support of Cognos BI environment,
- Integration and functional tests,


IBM Cognos BI reporting and forecasting solution for SC Johnson Family Company GB/Slough

- Development of ETL processes using IBM Cognos Data Manager,
- Creating tables, views, procedures using SQL Server Management Studio,
- Development of relational and dimensional meta data models in Framework Manager,
- Dashboards development in Report Studio,
- Maintenance of Cognos BI 8 environment, including job monitoring, security setup,
- End user training, preparing presentations, writing documentations


IBM Cognos BI report authoring Polen/Warschau
- Providing certified trainings for external clients:
Cognos 8 BI Report Authoring Part 1 and 2,
IBM Cognos 8 BI Framework Manager: Design Metadata Models,
IBM Cognos Transformer: Design OLAP Models

IBM Cognos, Transact-Sql, Microsoft SQL-Server (MS SQL)

6/2007 – 2/2008

Data Quality improvement in Data Warehouse for Raiffeisen Bank Poland

- Development of ETL processes using IBM Data Stage,
- Data Quality improvement, using address dictionaries,
- Data extract processes automation, job scheduling and monitoring,
- Creating tables, views, procedures in PLSQL Developer,
- Data Warehouse technical support in terms of IBM Data Stage processes,

Oracle-Anwendungen, ETL, PL/SQL

12/2006 – 5/2007

Technical support of low fare booking engine and system for Partners Software GmbH.

Main duties:
- 2nd level technical support of low fare booking engine,
- Writing SQL queries,
- Update of “Partners Software” applications, including operating system from Windows 2002 server,
- Development and Attendance of Integration Testing,
- Writing user guides and documentations,

Microsoft SQL-Server (MS SQL), Windows Server 2003