freiberufler BI and Planning Consultant IBM and SAP auf freelance.de

BI and Planning Consultant IBM and SAP

zuletzt online vor 1 Tagen
  • auf Anfrage
  • 03-733 Warschau
  • Europa
  • pl  |  en  |  de
  • 05.11.2022

Kurzvorstellung

I am Business Intelligence consultant with 12 years experience gained in FCMG, energy and finance sectors. I offer BI services using two vendors IBM and SAP.
These are IBM Cognos Analytics, IBM Planing Analytics, SAP BW/4HANA and SAP Analytics Cloud.

Qualifikationen

  • Cognos (IBM)
  • IBM Cognos
  • SAP Analytics Cloud
  • SAP BW/4HANA

Projekt‐ & Berufserfahrung

SAP Analytics Consultant (Festanstellung)
Franke AG, Aarburg/Remote, Aarburg
1/2020 – offen (4 Jahre, 3 Monate)
Großhandel
Tätigkeitszeitraum

1/2020 – offen

Tätigkeitsbeschreibung

Supporting migration of the reporting system from IBM Planning Analytics (TM1) to SAP Analytics Cloud based on SAP BW/4HANA.

This includes stories development in SAP Analytics Cloud.
Query and Composite Providers development including DSO, sources, chains.

Eingesetzte Qualifikationen

SAP Analytics Cloud, SAP BW/4HANA

IBM Cognos and Planning Analytics (BI & TM1) Experte
Roche Holding AG, Rotkreuz/Remote
2/2019 – 12/2019 (11 Monate)
Gesundheitswesen
Tätigkeitszeitraum

2/2019 – 12/2019

Tätigkeitsbeschreibung

Providing consultancy services for Roche Diagnostics

- TM1 cubes development including load processes development in Turbo Integrator, writing rules,
- Reports development in Prespectives and PAW
- Support of IBM TM1 environment

Used tools: TM1 10.2.2 including Architect, Perspectives and PAW

Eingesetzte Qualifikationen

IBM Cognos

IBM Cognos and Planning Analytics (BI & TM1) Experte
Franke AG, Aarburg
2/2018 – 1/2019 (1 Jahr)
Konsumgüterindustrie
Tätigkeitszeitraum

2/2018 – 1/2019

Tätigkeitsbeschreibung

- migration of dashboards and reports from Cognos BI to IBM Planning Analytics in PAW, source cubes were in TM1.
- cooperate with business site to improve reports during the migration in terms of funcionality and design

Tools: IBM Cognos 10.2, TM1 10.2.2

Eingesetzte Qualifikationen

IBM Cognos

Cognos BI & TM1 Consultant
PGE Systemy, Warschau
3/2017 – 1/2018 (11 Monate)
Energiewirtschaft
Tätigkeitszeitraum

3/2017 – 1/2018

Tätigkeitsbeschreibung

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

Eingesetzte Qualifikationen

Cognos (IBM)

Cognos BI Consultant
Vattenfall GmbH, Hamburg
4/2016 – 2/2017 (11 Monate)
Energiewirtschaft
Tätigkeitszeitraum

4/2016 – 2/2017

Tätigkeitsbeschreibung

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

Eingesetzte Qualifikationen

Cognos (IBM)

Cognos BI Consultant
PGE Systemy, Warschau
12/2015 – 3/2016 (4 Monate)
Energiewirtschaft
Tätigkeitszeitraum

12/2015 – 3/2016

Tätigkeitsbeschreibung

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

Eingesetzte Qualifikationen

Cognos (IBM)

Cognos BI Consultant
DNV GL, Gdingen
6/2015 – 11/2015 (6 Monate)
certification body and classification society
Tätigkeitszeitraum

6/2015 – 11/2015

Tätigkeitsbeschreibung

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

Eingesetzte Qualifikationen

IBM Cognos

Cognos BI and TM1 Consultant
Franke, Aarburg
10/2014 – 5/2015 (8 Monate)
Industrieproduktion
Tätigkeitszeitraum

10/2014 – 5/2015

Tätigkeitsbeschreibung

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

Eingesetzte Qualifikationen

IBM Cognos

Cognos Senior Designer
Wipro LTD, Zürich
3/2012 – 6/2014 (2 Jahre, 4 Monate)
IT Consulting
Tätigkeitszeitraum

3/2012 – 6/2014

Tätigkeitsbeschreibung

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

Eingesetzte Qualifikationen

IBM Cognos, Oracle (allg.), Testing (IT)

Cognos BI Developer
Oriflame Poland Sp. z o.o., Warschau
6/2010 – 2/2012 (1 Jahr, 9 Monate)
Konsumgüterindustrie
Tätigkeitszeitraum

6/2010 – 2/2012

Tätigkeitsbeschreibung

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,

Eingesetzte Qualifikationen

IBM Cognos, Oracle (allg.), SQL

Cognos BI Consultant
Mineral Midrange SA, Warschau
3/2008 – 5/2010 (2 Jahre, 3 Monate)
IT Consulting
Tätigkeitszeitraum

3/2008 – 5/2010

Tätigkeitsbeschreibung

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

Eingesetzte Qualifikationen

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

Technical Consultant
Ascen Sp z o.o., Warschau
6/2007 – 2/2008 (9 Monate)
IT Consulting
Tätigkeitszeitraum

6/2007 – 2/2008

Tätigkeitsbeschreibung

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,

Eingesetzte Qualifikationen

Oracle (allg.), ETL, PL/SQL

Technical Support
Partners-Solutions GmbH, Bremen
12/2006 – 5/2007 (6 Monate)
Luft- und Raumfahrtindustrie
Tätigkeitszeitraum

12/2006 – 5/2007

Tätigkeitsbeschreibung

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,

Eingesetzte Qualifikationen

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

Zertifikate

IBM Cognos TM1 10 Developer
2014
IBM Cognos BI Professional
2013
IBM Certified Developer – Cognos 10 BI Metadata Models
2010
IBM Certified Designer - Cognos 10 BI Reports
2009
IBM Certified Developer – Cognos 10 BI Data Warehouses
2009
1Z0-007 Introduction to Oracle9i SQL
2007

Ausbildung

Telekommunikation und Elektronik
Ingenieur
2006
Bydgoszcz

Über mich

I am IBM Cognos Analytics and IBM Planning Analytics certified consultant with over 12 years experience in Business Intelligence and Planning solution. I deliver also solution in SAP Analytics Cloud and SAP BW/4HANA.

I have deep knowledge of IBM Cognos Analytics and Planning Analytics solution. I have solid experience in designing and developing OLAP cubes, ROLAP models, dashboards and reports. Certifications gained in reports, metadata models, data warehouses and also in planning, budgeting and forecasting solutions proof my my knowladge in these areas.


IBM Cognos Analytics Report Studio,
IBM Cognos Analytics Dashboard,
IBM Cognos Analytics Framework Manager,
IBM Planning Analytics (Architect, Turbo Integrator)
IBM Planning Analytics Workspace

SAP Analytics Cloud
SAP BW/4HANA.

Full projects life cycle in FMCG, energy and finance sectors.

Weitere Kenntnisse

IBM Cognos Analytics
IBM Planning Analytics TM1
SAP Analytics Cloud
SAP BW/4HANA
Jira
HP Quality Center

Persönliche Daten

Sprache
  • Englisch (Fließend)
  • Polnisch (Muttersprache)
  • Deutsch (Gut)
Reisebereitschaft
Europa
Arbeitserlaubnis
  • Europäische Union
  • Schweiz
Home-Office
bevorzugt
Profilaufrufe
3378
Alter
42
Berufserfahrung
25 Jahre und 11 Monate (seit 04/1998)

Kontaktdaten

Nur registrierte PREMIUM-Mitglieder von freelance.de können Kontaktdaten einsehen.

Jetzt Mitglied werden