TM1 Senior Consultant
IKEA
(Consumer goods and retail, >10.000 employees)
Keywords
Skills
data structures, IBM TM1/Planning Analytics, MS SQL, SAP BW, Programming, ETL packages, data flows, IBM Cognos, TM1 TurboIntegrator, IBM Cognos DataManager, TM1 Package Connector, MS SSIS, SAP NetWeaver, TM1 ActiveForms, IBM, Cognos, TM1, Web, PAX, PAW, MS SQL Server, SAP BEx Query Designer, SAP BEx Query Analyzer, programming languages, C#, T-SQL, VBA, MS, Excel, TM1 REST API, PRINCE2, Agile, SCRUM, algorithms, Analytics, Cognos TM1, data processing, Cognos BI, SQL, MDX, MS Excel, data security, data storage, ORACLE, VB, Modeler, IBM Cognos Insight, Microsoft Excel VBA, Microsoft, ASP.net, metadata, SAP, NetWeaver, SAP Business Warehouse 7.0, BEx Query Designer, BEx Query Analyzer, Database, Data Warehouse, Cognos 8, Microsoft SQL Server 2005, SSIS, IBM Cognos Data Manager, VB Scripts, Visual Basic, data migration, IBM DB2/400, ETL, SOX, Peregrine ServiceCenter, HP SM7, versioning, Microsoft Visual Source Save, software tools, SQL Server 2000, Crystal Reports XI, ERP, Oracle RDBMS, databases, ETL tools, Visual Fox Pro, Microsoft Windows Servers 2003, Microsoft SQL Server 2000, Interface, MS SQL Server 2000, DTS packages, Visual Studio 2005, SQL Server environment, GPS, Dynamics, operating system, Novel NetWare 4.11, IBM Cognos TM1 10.1, Cognos TM1 API, IBM Cognos TM1, IBM Cognos TM1 API, PL/SQL
Project history
08/2016
-
12/2020
02/2016
-
08/2016
TM1 Application Owner
UCB Pharma
Allée de la Recherche 60, 1070 Anderlecht, Belgium
Key responsibilities:
* Supervising and coordinating tasks of the offshore support and onshore project team.
* Optimizing system performance and data flow between source (SAP BW) and reporting systems
(IBM Cognos BI, IBM CAFÉ, IBM Cognos TM1 10.2.2)
* Reviewing data processing algorithms and KPIs calculation rules
* Analyzing business requirement and verifying technical specifications for change requests
* Monitoring and optimizing performance of TM1 server environment.
* Reducing Total Cost of the Ownership
Key responsibilities:
* Supervising and coordinating tasks of the offshore support and onshore project team.
* Optimizing system performance and data flow between source (SAP BW) and reporting systems
(IBM Cognos BI, IBM CAFÉ, IBM Cognos TM1 10.2.2)
* Reviewing data processing algorithms and KPIs calculation rules
* Analyzing business requirement and verifying technical specifications for change requests
* Monitoring and optimizing performance of TM1 server environment.
* Reducing Total Cost of the Ownership
07/2015
-
11/2015
TM1 Consultant
Vattenfall AB
Sweden, Denmark, Finland, Germany, Netherlands, Poland, United Kingdom
Key responsibilities:
* Extract, transform and data load form internal and external data sources by programming
advanced IBM Cognos TM1 TruboIntegrator processes including injection SQL and MDX
statements.
* Writing complex cube rules and improving calculation performance with skipcheck and feeders.
* Providing third line support and answering business change request related to the VBA code and
MS Excel data input templates.
* Monitoring and optimizing performance of TM1 server environment.
* Gathering and analyzing business requirement, delivery expertise of best possible solution.
Key responsibilities:
* Extract, transform and data load form internal and external data sources by programming
advanced IBM Cognos TM1 TruboIntegrator processes including injection SQL and MDX
statements.
* Writing complex cube rules and improving calculation performance with skipcheck and feeders.
* Providing third line support and answering business change request related to the VBA code and
MS Excel data input templates.
* Monitoring and optimizing performance of TM1 server environment.
* Gathering and analyzing business requirement, delivery expertise of best possible solution.
09/2014
-
06/2015
TM1 Architect
UBS AG
Europaalle 23, Zurich, Switzerland
Key responsibilities:
* Designing architecture and delivery technical documentation of most optimal and scalable solution
of multidimensional analysis as an answer for business requirement.
* Providing third line support and answering business change request related to delivered projects.
* Maintaining user access, data security, data controlling and entry approval path.
* Programming advanced IBM Cognos TM1 TruboIntegrator processes and cube rules.
* Utilizing multidimensional TM1 data storage with other technologies: TM1, ORACLE, SQL, VB.
Key responsibilities:
* Designing architecture and delivery technical documentation of most optimal and scalable solution
of multidimensional analysis as an answer for business requirement.
* Providing third line support and answering business change request related to delivered projects.
* Maintaining user access, data security, data controlling and entry approval path.
* Programming advanced IBM Cognos TM1 TruboIntegrator processes and cube rules.
* Utilizing multidimensional TM1 data storage with other technologies: TM1, ORACLE, SQL, VB.
04/2011
-
09/2014
TM1 Developer
HSBC Service Delivery (Polska) Sp. z o o
HSBC Service Delivery (Polska) Sp. z o o, Zabierzów, Poland
Key responsibilities:
* Constructing and maintaining multidimensional analysis for planning, budgeting, forecasting,
data consolidation and business profitability calculation on the basis of IBM Cognos TM1.
* Designing data input templates and application front-end with usage of: IBM Cognos TM1, IBM
Cognos Performance Modeler, IBM Cognos Insight, Microsoft Excel VBA, Microsoft C# and
ASP.net.
* Designing data processing infrastructure in the TM1 multi instance environment
* Maintaining distribution of metadata and security access across the farm of TM1 servers
Key responsibilities:
* Constructing and maintaining multidimensional analysis for planning, budgeting, forecasting,
data consolidation and business profitability calculation on the basis of IBM Cognos TM1.
* Designing data input templates and application front-end with usage of: IBM Cognos TM1, IBM
Cognos Performance Modeler, IBM Cognos Insight, Microsoft Excel VBA, Microsoft C# and
ASP.net.
* Designing data processing infrastructure in the TM1 multi instance environment
* Maintaining distribution of metadata and security access across the farm of TM1 servers
06/2010
-
04/2011
SAP Development and Configuration Expert
SAP Centre of Excellence; Electrolux Poland Sp. z o o, Global Shared Service Centre
Electrolux Poland Sp. z o o, Global Shared Service Centre, Cracow, Poland.
Key responsibilities:
* Designing, modeling and implementation changes in data flow chains and NetWeaver objects of
SAP Business Warehouse 7.0.
* Analyzing and designing algorithms and business rules for multidimensional reports (BEx Query
Designer, BEx Query Analyzer).
* Coordinating and changing EMEA Period End Closings on behalf of Business Intelligence team.
Key responsibilities:
* Designing, modeling and implementation changes in data flow chains and NetWeaver objects of
SAP Business Warehouse 7.0.
* Analyzing and designing algorithms and business rules for multidimensional reports (BEx Query
Designer, BEx Query Analyzer).
* Coordinating and changing EMEA Period End Closings on behalf of Business Intelligence team.
05/2007
-
06/2010
Database and Data Warehouse Expert
Electrolux Poland Sp. z o o, Global Shared Service Centre
Electrolux Poland Sp. z o o, Global Shared Service Centre, Cracow, Poland.
Key responsibilities:
* Maintaining and enhance a data warehouse system for Central European Reporting System build
on the basis of technologies IBM Cognos 8 BI and clustered Microsoft SQL Server 2005
* Analyzing and designing algorithms and business rules for cost allocation process and calculation
of profitability (T-SQL, SSIS, IBM Cognos Data Manager, VB Scripts).
* Implementing changes in data flow and calculation layer (IBM Cognos Data Manager, T-SQL, C#,
ASP.Net, Visual Basic, SSIS).
* Planning support activities for data migration from external data sources (IBM DB2/400) and
development of process control sequences in ETL processing (IBM Cognos 8 Data Manager).
* Compliance of rules the change management process, software development life cycle and SOX
safety requirement (Peregrine ServiceCenter, HP SM7).
* Code versioning (Microsoft Visual Source Save)
Key responsibilities:
* Maintaining and enhance a data warehouse system for Central European Reporting System build
on the basis of technologies IBM Cognos 8 BI and clustered Microsoft SQL Server 2005
* Analyzing and designing algorithms and business rules for cost allocation process and calculation
of profitability (T-SQL, SSIS, IBM Cognos Data Manager, VB Scripts).
* Implementing changes in data flow and calculation layer (IBM Cognos Data Manager, T-SQL, C#,
ASP.Net, Visual Basic, SSIS).
* Planning support activities for data migration from external data sources (IBM DB2/400) and
development of process control sequences in ETL processing (IBM Cognos 8 Data Manager).
* Compliance of rules the change management process, software development life cycle and SOX
safety requirement (Peregrine ServiceCenter, HP SM7).
* Code versioning (Microsoft Visual Source Save)
01/2007
-
03/2007
Analyst and Programmer
ARMATURA Kraków SA
ARMATURA Kraków SA, Cracow, Poland.
Key responsibilities:
* Developing and improve software tools for analysis and business processes. Preparing reports
with features leveraging the users with multidimensional analysis for production, business and
finance (SQL Server 2000 Analysis Services, Data Transformation Services, T-SQL, Crystal
Reports XI).
* Designing objects for data storage and develop T-SQL routines for data migration from ERP
system (IFS) on the basis of Oracle RDBMS.
* Understanding the financial Accounting structure and business requirement.
Key responsibilities:
* Developing and improve software tools for analysis and business processes. Preparing reports
with features leveraging the users with multidimensional analysis for production, business and
finance (SQL Server 2000 Analysis Services, Data Transformation Services, T-SQL, Crystal
Reports XI).
* Designing objects for data storage and develop T-SQL routines for data migration from ERP
system (IFS) on the basis of Oracle RDBMS.
* Understanding the financial Accounting structure and business requirement.
12/2005
-
11/2006
Database Programmer
LS Dialogmarketing GmBH & Co. KG
LS Dialogmarketing GmBH & Co. KG, Cracow, Poland .
Key responsibilities:
* Preparing databases for mailing personalization in accordance with the national mail standards of
customers' countries using dedicated and in-house developed ETL tools (Visual Fox Pro, C#).
* Implementation of algorithms for searching duplicates, data proofing and postal optimization
processing.
* Assurance of data confidential and security.
Key responsibilities:
* Preparing databases for mailing personalization in accordance with the national mail standards of
customers' countries using dedicated and in-house developed ETL tools (Visual Fox Pro, C#).
* Implementation of algorithms for searching duplicates, data proofing and postal optimization
processing.
* Assurance of data confidential and security.
11/2004
-
12/2005
Assistant of Subscription System Coordinator | Printing Personalization
RR Donnelley Europe Sp z o o
RR Donnelley Europe Sp z o o, Cracow, Poland.
Key responsibilities:
* Coordination the Electronic Data Processing team to prepare data for printing personalization.
* Administration and maintenance of computer network build on the basis of Microsoft Windows
Servers 2003 and Microsoft SQL Server 2000 dedicated for printing personalization services.
* Developing an ETL application the Common Interface of Data Processing for customize running
of MS SQL Server 2000 DTS packages (Visual Studio 2005, C#).
* Technical assessment for inside and outside customers.
* Cooperating of national and foreign post offices and courier companies
Key responsibilities:
* Coordination the Electronic Data Processing team to prepare data for printing personalization.
* Administration and maintenance of computer network build on the basis of Microsoft Windows
Servers 2003 and Microsoft SQL Server 2000 dedicated for printing personalization services.
* Developing an ETL application the Common Interface of Data Processing for customize running
of MS SQL Server 2000 DTS packages (Visual Studio 2005, C#).
* Technical assessment for inside and outside customers.
* Cooperating of national and foreign post offices and courier companies
09/1998
-
12/2003
Lead Computer Scientist
Żywiec Trade Sp. z o o
Żywiec Trade Sp. z o o, (holding of the Grupa Żywiec S.A. a part of the Heineken Corporate N.V.)
Cracow, Poland
Key responsibilities:
* Coordination the local IT team and external vendors to resolve problems with the proper
functioning of the IT infrastructure and systems.
* Working together with other members of the managerial staff to provide appropriate solutions.
3
* Coordinate of trainings to handle applications supporting business operations in headquarter and
sales branches.
* Day-to-day administration of large scale SQL Server environment - 9 database servers with data
replication between headquarter and local divisions.
* Administering, maintenance and enhance an ERP system the GPS Dynamics CS+.
Cracow, Poland
Key responsibilities:
* Coordination the local IT team and external vendors to resolve problems with the proper
functioning of the IT infrastructure and systems.
* Working together with other members of the managerial staff to provide appropriate solutions.
3
* Coordinate of trainings to handle applications supporting business operations in headquarter and
sales branches.
* Day-to-day administration of large scale SQL Server environment - 9 database servers with data
replication between headquarter and local divisions.
* Administering, maintenance and enhance an ERP system the GPS Dynamics CS+.
09/1997
-
08/1998
Junior Customs Controller
IT Department; Customs Office
Customs Office, Przemyśl, Poland.
Key responsibilities:
* Administering network operating system on the basis of Novel NetWare 4.11.
* Actualizing dictionary databases and maintenance Customs registers and records.
* Designing and developing a database application for needs of operational departments.
* Cooperating with IT department in Custom Office headquarter.
Key responsibilities:
* Administering network operating system on the basis of Novel NetWare 4.11.
* Actualizing dictionary databases and maintenance Customs registers and records.
* Designing and developing a database application for needs of operational departments.
* Cooperating with IT department in Custom Office headquarter.
Local Availability
Open to travel worldwide
