Piotr Gierlak, TM1 Application Owner, TM1 Consultant, TM1 Architect on www.freelancermap.com

TM1 Senior Consultant

IKEA

Goods & Retail

>10.000 team member

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

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.

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.

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

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.

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)

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.

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.

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

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+.

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.

TM1 Application Owner, TM1 Consultant, TM1 Architect

Profile attachments

Languages

Project history