Development of Cognos Analytics Data Modules, Datasets and Reports.
Business: Banking.
Development of Cognos Analytics Data Modules, Datasets and Reports.
Analysis and implementation of Reporting Data Modules and Datasets.
System environment: Cognos Analytics, Oracle, Toad, Azure, Confluence.
Apr 2023 - Present
2 years 4 months
Analyst / Consultant
Freelancer
Migration of Cognos Powercubes to Cognos Dynamic Cubes.
Business: Public Sector.
Migration of Cognos Powercubes to Cognos Dynamic Cubes.
Data Analysis.
Cube Administration with Rest-API.
System environment: Cognos Analytics, Oracle, Jira, Confluence.
Feb 2023 - Jul 2023
6 months
Analyst / Consultant
Freelancer
Migration of Cognos Analytics & Planning Analytics Environment.
Business: Automotive.
Installation, Migration, Patching, Deployment.
Set up interconnectivity for (and between) Cognos Analytics incl. Dynamic Cubes with multiple dispatcher and environment, Planning Analytics and DB2.
System environment: Cognos Analytics, DB2, Planning Analytics, Jira, Confluence.
Apr 2022 - Nov 2022
8 months
Analyst / Consultant
Freelancer
Implementing a DataVault 2.0 DWH for an international Reporting environment for Health data.
Business: Public Sector.
Business Analysis and coordination with Business.
Modelling of DataVaults and Information DataMart’s.
Implementing ETL Packages (PL/SQL) and SAP Data Services.
System environment: Oracle, PL/SQL, SAP Data Services, Confluence, Jira, GIT.
Aug 2021 - Dec 2021
5 months
Analyst / Consultant
Freelancer
Supporting Go-Live DWH and Reporting Environment.
Business: Information Technology / Industry.
Supporting the Go-Lives of a DWH and BI Environment, which are rolled out as an add-on to an ERP Software.
Adjust and harmonize the DWH and Reporting Environment to meet requirements and roll out to clients.
System environment: SQL Server, IBM Cognos Analytics.
Jul 2021 - Present
4 years 1 month
Analyst / Consultant
Freelancer
Administration of Risk Reporting Environment.
Business: Banking.
Monitoring.
Service Reliability.
Work on Incidents.
Patching.
System environment: Cognos Analytics, Oracle, Service Now, Linux.
Jul 2021 - Sep 2022
1 year 3 months
Analyst / Consultant
Freelancer
Implementing Risk Reporting Modell.
Business: Banking.
Implementing Reporting Model (Cognos Framework Manager).
Business and technical Requirement-Analysis and coordination with Business.
System environment: Cognos Analytics, Oracle, Jira.
Jun 2021 - Mar 2022
10 months
Analyst / Consultant
Freelancer
Implementing a DataVault 2.0 DWH, Raw and Information Data Marts, creating PowerBI Reports.
Business: Industry.
Business Requirements analysis and coordination with Business.
Modelling DataVault, Raw and Information Marts.
Implementing ETL Packages in Visual Studio (Stored Procedures, Tables, Views, Jobs).
Creating PowerBI Datasets (incl. DAX) and Reports.
System environment: SQL Server, Visual Studio, GIT, PowerBI.
Apr 2021 - Jul 2021
4 months
Analyst / Consultant
Freelancer
Implementing Market Analysis Tool.
Business: Fintech.
Loading Data into Snowflake-DB via Python and automated Data-analysis.
System environment: Python, Snowflake, AWS.
Mar 2021 - Aug 2021
6 months
Analyst / Consultant
Freelancer
Implementing a management-reporting-systems.
Business: Information Technology.
Implementing a reporting DataMart (Postgre) and a reporting environment (PowerBI).
Enablement of the client.
Business and technical requirement analysis.
System environment: PowerBI, Postgre, Jira.
Nov 2020 - Mar 2021
5 months
Analyst / Consultant
Freelancer
Implementing a reporting DataMart and a reporting model.
Business: Banking.
Implementing a reporting DataMart (sql etl).
Source and target analysis.
Implementing a reporting model (Cognos Framework Manager).
Performance tuning on both ETL and reporting.
Enablement of client.
System environment: IBM Cognos Analytics, Oracle.
Jun 2019 - Feb 2021
1 year 9 months
Analyst / Consultant
Freelancer
Migration of Cognos 10 Reporting Application to Cognos Analytics.
Business: Insurance.
Migration of Cognos 10 Reporting Application to Cognos Analytics due to Migration of underlying DWH (Data Sources and Data structure, incl. Migration of TM1 Reporting Cubes and Sources to Planning Analyics).
Implementing Cubes according to new Datasource.
System environment: IBM Cognos Analytics, Cognos TM1, Planning Analytics, Planning Analytics Architect, Planning Analytics Perspectives, Oracle, ALM Octane, IBM Cognos 10, SAP Insurance Analyzer.
Implementing DataStage ETL Jobs for DataVault 2.0 DWH.
Modelling DataVault Datamart and Cognos-Framework Manager (Rolap, Relational).
Planning Environment (TM1 Planning Workflows).
Analysis.
Developing Cognos Analytics Reports and Dashboards.
System environment: IBM Cognos Analytics, Cognos TM1, IBM DataStage, Oracle, MSSQL Server.
Dec 2016 - Present
8 years 8 months
Analyst / Consultant
Freelancer
Implementing a Datawarehouse for controlling with various DataMart’s, reporting and ad-hoc reporting interfaces, training for clients.
Business: Mechanics, Industry.
Analysis and implementation of SSIS-ETL-Jobs DWH-Load.
Analysis and implementation of controlling-reports and dashboards.
Performance tuning of SSIS packages and reports.
Modelling of DataMart’s and Cognos-Rolap-Layer.
System environment: IBM Cognos BI, SSIS, MSSQL Server, Navision.
Sep 2016 - Nov 2016
3 months
Analyst / Consultant
Freelancer
Analysis and implementation of management-reports and dashboards.
Business: Banking.
Analysis implementation of management-reports and dashboards.
Modelling of DataMart’s and Cognos-Rolap-Layer.
Enablement / training.
System environment: IBM Cognos BI, Cloudera Impala.
May 2016 - Aug 2016
4 months
Analyst / Consultant
Freelancer
Implementing a planning and reporting environment, modelling DWH, loading data from SAP to Oracle DWH with DataStage and loading into TM1-Cubes.
Business: Public sector.
Analysis and development of TM1-cubes and reports.
Modelling DWH.
Development of DataStage-jobs.
Business Analysis.
Requirements Engineering.
Create authorization concept.
Training.
Prepare testing plans and detailed test cases incl. generation of test data to depict business requirements.
System environment: SAP-BW, IBM DataStage, Oracle DB, IBM Cognos TM1, IBM Cognos BI.
Oct 2014 - Mar 2016
1 year 6 months
Vienna, Austria
Inhouse Analyst / Consultant
Allgemeine Unfallversicherungsveranstalt
Business Intelligence and Datawarehouse.
Reporting.
Olap.
DWH and DB modelling.
ETL.
DataMarts for Self-Service-Reporting.
Performance tuning of Reports and Databases.
Business Analysis.
Requirements Engineering.
Training and user-enablement.
Oct 2013 - Aug 2014
11 months
Vienna, Austria
Analyst / Consultant
Imposult Gmbh & Co Kg
Implementing mapping and ETL from operational database to DWH, build DataMarts, cubes and reports.
Business: Transporting, Supply Chain.
Analysis and developing the mappings from the data sources of the client to DWH.
Customizing DataMarts.
Implementing Dynamic Cubes via Cube Designer.
Implement and schedule Reports for Cache-generation.
Developing controlling-reports.
System environment: AS400, DB2, IBM Cognos, IBM Cognos Dynamic Cubes, IBM Infosphere Warehouse.
Sep 2013 - May 2014
9 months
Vienna, Austria
Analyst / Consultant
Imposult Gmbh & Co Kg
Implementing a reporting environment of information of sales division of clients, contacting’s, dialogues, etc.
Business: Banking.
Developing the reporting DataMart’s.
Report Implementation.
Business Analysis.
Requirements Engineering.
Enablement of the Client.
System environment: Oracle DB, IBM Cognos TM1, IBM Cognos BI.
Sep 2013 - Mar 2014
7 months
Vienna, Austria
Analyst / Consultant
Imposult Gmbh & Co Kg
Implementing a Data-Quality-Management-Engine for monitoring daily loads of the CRM-DWH and visualize results of the engine.
Business: Banking.
Business Analysis.
Implementing pixel-perfect reports and burst the results of the data-quality-checks.
System environment: Oracle DB, IBM Cognos BI.
Nov 2012 - Aug 2013
10 months
Vienna, Austria
Analyst / Consultant
Imposult Gmbh & Co Kg
Implementing a traceability-reporting-engine and DWH.
Business: Industry.
Business Analysis.
Requirements Engineering.
Development the DataMart’s corresponding traceability 2 and 4 standards.
Analysis and implementing user-reporting-portal, including dashboards and UI-enhancements.
System environment: MS SQL-Server, SSIS, SSAS, IBM Cognos BI, IBM WebSphere Portal Services.
May 2012 - Aug 2012
4 months
Vienna, Austria
Analyst / Consultant
Imposult Gmbh & Co Kg
Implementing the ETL-interface between MS-SQL-Server and ORACLE-DWH.
Business: Transporting.
Analysis and development of ETL-jobs and scheduling’s.
System environment: MS-SQL-Server, ORACLE-DB, IBM DataStage.
Nov 2010 - Apr 2012
1 year 6 months
Vienna, Austria
Analyst / Consultant
Imposult Gmbh & Co Kg
Implementing a finance-Datawarehouse and loading into DataMart’s and reporting interfaces.
Business: Banking.
Business Analysis.
Development of DataStage and SQL-script-jobs for loading the DWH and the DataMart’s.
Implementing and analysis of change-requests.
Prepare testing plans and detailed test cases incl. generation of test data to depict business requirements.
System environment: Teradata DB, IBM DataStage, HP Quality Center, Tortoise SVN.
Feb 2010 - May 2010
4 months
Vienna, Austria
Analyst / Consultant
Imposult Gmbh & Co Kg
Implementing a Cognos TM1 Budget Planning Application PoT.
Business: Industry.
Set up a TM1 Budget Planning Application including Workflows, Actual vs. Budget Comparison, TM1 Cubes, Rules, Planning Calculations.
System environment: MS SQL Server, Cognos TM1.
May 2009 - Sep 2014
5 years 5 months
Vienna, Austria
Analyst / Consultant
Imposult Gmbh & Co Kg
Implementing a Business-Intelligence reporting-tool and DWH, loaded with XML-data-extracts of the association members.
Business: Insurance.
Creation of XML-interface to the DWH including business analysis.
Creation of source-to-target-mappings.
Design of a relational-OLAP-data source.
Creation of standard-reports including calculated measures and members, corporate identity and performance enhancement.
System environment: AIX, MS Windows 2003 Server, IBM DB2, Cognos BI 10.
Nov 2008 - Apr 2009
6 months
Vienna, Austria
Analyst / Consultant
Imposult Gmbh & Co Kg
Migration of present DWH-solution to IBM DWE 9.5 replacing Perl-ETL-scripts with SQW for DB2 Warehouse.
Business: Trading.
Analysis, creation and developing ETL jobs and packages.
System environment: IBM AIX, DWE 9.5.
Jun 2006 - Aug 2008
2 years 3 months
Pressbaum, Austria
IT Systems and Database Responsible / Project Manager
Brajlovic GmbH
IT-infrastructure und database.
Responsible for IT-Systems and databases.
Backing of controlling.
Reporting Intrastat.
Project manager: implementing a system for the goods movement in the warehouse.
Project manager: implementing a mobile Point-of-Sale application.
Summary
Technical overview: MS SQL Server, DB2, Oracle, Postgre, Cloudera Impala, Oracle Exadata, Teradata, MS Access
OLAP-Database-systems MS SQL Server Analysis Services, IBM Cognos TM1, IBM Planning Analytics, IBM Cognos Dynamic Cubes, IBM Cognos Powercubes, Cognos DMR
Business experience: Health-Care, Insurance, Trade, Information Technology, Banking, Transportation, Public Sector, Mechanics, Industry, Automotive
BI / DWH Tools: IBM Cognos Analytics, IBM Cognos BI, IBM Planning Analytics, IBM Cognos TM1, IBM DataStage, IBM DB2 Warehouse, Power BI, MS SQL Analysis Services, MS SQL Integration Services, Confluence, Jira, Oracle BI, Oracle Data Integrator, Tortoise SVN, HP Quality Center, Bugzilla, GIT
New Technologies: Snowflake, Cognos Mobile, Cloudera Impala, Big Data, Google Analytics, Google Looker
Languages
German
Native
Hungarian
Native
English
Advanced
Certifications & licenses
BI0-112 IBM Cognos 8 BI Author
IBM
COG-300 IBM Cognos TM1 Analyst
IBM
COG-310 IBM Cognos TM1 Developer
IBM
COG-612 IBM Cognos 10 BI Author
IBM
COG-622 IBM Cognos 10 BI Administrator
IBM
COG-625 IBM Cognos 10 BI Data Warehouse Developer
IBM
P2090-032 IBM Big Data Fundamentals Technical Master
IBM
Similar Freelancers
Discover other experts with similar qualifications and experience