Piotr Gierlak

Development Specialist of Managerial and Planning information
Kraków, małopolskie

Języki

polski
ojczysty
angielski
biegły
rosyjski
podstawowy

Doświadczenie zawodowe

HSBC Service Delivery (Polska) sp. z o.o.
Managerial and Planning Information Developer | Department of Financial Systems Change Management
Constructing and maintaining multidimensional applications on the basis of IBM Cognos TM1 to enable robust financial analysis, reporting and data consolidations.
Programming IBM Cognos TM1 TruboIntegrator processes and cube rules.
Programming data input templates and user interfaces using: TM1 API, C#, ASP.Net and VBA.
Gathering, understanding and analyzing of business and finance requirements.
Preparing Technical specification and Management Guides for provided applications.

(IBM Cognos TM1, OLAP, MDX, ETL, VBA, ASP.Net, C#, TM1 API, SQL, ORACLE)
Electrolux Poland Sp. z o.o.
SAP BI Development and Configuration Expert | SAP Centre of Excellence
Designing, modeling and implementation changes in data flow chains and NetWeaver objects of SAP Business Warehouse 7.0.
Analysis and design of algorithms and business rules for multidimensional reports. Minimizing TCO, reducing downtimes, increasing of data security, optimizing performance, keeping the landscape in accordance with SOA (ESA) standards, compliance of rules the change management process, software development live cycle. Coordinating and changing EMEA Period End Closings on behalf of Business Intelligence team.

(SAP BI, SAP NetWeaver, OLAP, BEx Query Designer, BEx Query Analyzer, HP SM7, HPQC)
Electrolux Poland Sp. z o.o.
Database and Data Warehouse Expert | Business Intelligence Competence Center
Support, maintain and enhance the data warehouse for Central European Reporting System which produces critical financial reports namely Integrated profitability report and Account-Cost bucket reports for Europe, Middle East and Africa. Understanding the financial accounting structure, business requirements and customers needs. Proposing best practices and processes in order to realize requests of changes in specified time. Designing the solution, developing and implementing the requested changes in dataflow and data calculation in layer of business rules concerning process of cost allocation and calculation of profitability.

(IBM Cognos 8 BI, MS SQL 2005 Server, Visual Studio 2008, T-SQL, C#, ASP.Net, ETL, DB2/400, IBM Cognos 8 Data Manager, SSIS, Excel, VBA, ADO.Net)
Armatura Kraków SA
Analyst Programmer
Developing and improving software tools for analysis and business processes. Preparing reports with features leveraging the users with multidimensional analysis for production, business and finance decision making.

(Microsoft Office SharePoint Server, MS SQL Server 2000 Analysis Services, MS SQL Server 2000, DTS, IFS, Oracle, C#, ASP.Net, OWC, COM, DLL, OLEDB, ODBC)
Logo
Databases Programmer
LS Dialogmarketing GmBH & Co. KG
Preparing database to impose personalized mails in accordance with the national mail standards' in different countries. Implementing a process which will receive the data files from customers in various file formats and then to convert and standardize to store the information. Also implemented standards to improve data quality, eliminate redundant data, data proofing and postal optimization. It also included programming the layout of letters and implementing the respective algorithms for optimization of mailing in accordance to national standards of postal services. Also assured the processes to maintain data confidentiality.

(ETL, DTS, MS SQL 2005 Server, Visual FoxPro 9, C#, COM, DLL, ADO.Net, PReS)
RR Donnelley Europe Sp. z o. o.
Assistant of Subscription System Coordinator
Coordinated administration and data processing for print customization and configuration as per Business requirements. Also mentored administration and maintenance of computer networks and implemented processing algorithms to achieve quality package delivery in terms of national standard for postal services. Also worked as technical assistant for internal and external customers. Additionally, coordinated in purchasing and putting into practice of the right machines, technology and processing devices. Successfully carried out the national and foreign post office couriers firms with on time delivery of data for printing personalization.

(Microsoft Windows Server 2003, LAN, DHCP, DNS, WINS, IPSec, VPN, Active Directory, TCP/IP, MS SQL 2000 Server, EDP, Videojet VIP-NT, C#, ADO.Net, DTS, COM, Lotus Notes, Lotus Domino, MS Excel, MS Access)
Logo
Owner
FHUP Pasja - wholesale of FMCG
Logo
Lead Computer Scientist
Żywiec Trade Sp. z o.o. (holding Grupa Żywiec S.A. connected to the Heineken Corporate N.V.)
Administering a network of operating systems based on the MS Windows Server NT 4.0/2000 and database servers - MS SQL 6,5/7/2000. Administering and maintaining ERP system, the GPS DyNAMICS CS+. Also coordinated technical and content-related support for all users of an IT infrastructure. Developed several user tools for operations to achieve efficient work and process. Successfully implemented new technologies and various enhancements to the existing software tools. Drawing up statistics, analyses and reports, concerning operational activity of the firm. Successfully handled supervision and controlled the data flowing and document circulations. Successfully maintained systematic backup of the system and user data and maintained a virus and hacker free security systems.

(MS Windows NT 4.0, DHCP, DNS, WINS, RRAS, TCP/IP, MS SQL Server 6.5, Citrix MetaFrame Server, Dynamics, ERP, CRM, Visual Basic, vfp, dbf, COM, DLL, ODBC, LAN, WAN)
Logo
Junior Customs Controller, employee of IT department.
Customs Office in Przemyśl
Administering a Novel NetWare 4.11 LAN network and maintaining database dictionary. Designing and developed a database application for needs of operational departments. Drawing up reports for statistics and analysis needs. Making a systematic backup of system and users data. Determining and using method of viruses and hackers attacks security. Cooperating with IT department in Customs Office headquarter.

(Novel NetWare 4.11, FoxPro, dbf, LAN)
Logo
Teacher (work during studies).
Technical College of Energy in Cracow

Edukacja

Logo
Individual studies at the Mathematic-Physics-Technical department, major – physics, specialty - computer science., magisterskie
Akademia Pedagogiczna im. Komisji Edukacji Narodowej w Krakowie

Inne

Optional classes at the AGH University of Science and Technology and at the Jagiellonian University. M.A. thesis written at the Institute of Nuclear Physics Polish Academy of Science in Cracow.

Certificates:

■ IBM Certified Developer - Cognos TM1
■ IBM Certified Specialist - Cognos TM1 Data Analysis

Trainings:
■ BW310 SAP BW Enterprise Data Warehousing
■ BW305 SAP BW Query Design and Analysis
■ Cognos 8 Data Manager (V8.3), Electrolux – Italy
■ 2792 Implementing and Maintaining Microsoft SQL Server 2005 Integration Services
■ 867 System administration for MS SQL Server 6.5
■ 1134 Microsoft SQL Server 7.0 – System administration
■ 1303A Mastering Microsoft Visual Basic 6.0 Fundamentals
■ 1013AC Mastering Microsoft Visual Basic 6.0 Development
■ 2276 Implementing a Microsoft Windows Server 2003 Network Infrastructure: Network Hosts
■ 2277 Implementing, Managing, and Maintaining a Microsoft Windows Server 2003 Network Infrastructure: Network Services
■ 803 Administering MS Windows 4.0
■ 1330 Supporting MS Windows NT 4.0 Core Technologies
■ Notes Basics and Beyond Basics v. 4x fundamentals
■ Developing IBM Lotus Domino 6 Application
■ System administration for MS SQL Server 2000, technical training – Browary Żywiec S.A.
■ Citrix MetaFrame Server, technical training – Browary Żywiec S.A.
■ Printing personalization system Videojet VIP-NT – technical training RR Donnelley – USA

Grupy

Uniwersytet Pedagogiczny
Uniwersytet Pedagogiczny
Uniwersytet Pedagogiczny
Administratorzy Windows
Administratorzy Windows
Grupa dla administratorów pracujących z systemami Windows
Afrykańskie bębny Djembe
Afrykańskie bębny Djembe
Celem grupy jest popularyzowanie korzyści płynących z gry na tradycyjnych bębnach afrykańskich djembe.
Agile
Agile
Agile - project management
Bazy Danych
Bazy Danych
Zagadnienia bazodanowe: SQL99 i jego implementacje w popularnych systemach RDBMS: Oracle, MySQL, PostgreSQL, MSSQL, IBM DB2 i inne.
Business Intelligence
Business Intelligence
Business Intelligence
Business IT
Business IT
Grupa firm branży IT / INTERNET. Liderzy i Eksperci. Wydarzenia branżowe rynku IT (B2B). Zarządzanie IT, badanie IT, startupy IT, technologia IT, internet IT, ebiznes IT.
Cognos Business Intelligence and Performance Management Software Solutions
Cognos Business Intelligence and Performance Management Software Solutions
SeeBusiness. ShareBusiness. UniteBusiness. SeeCognos.
Data Mining w biznesie
Data Mining w biznesie
Zapraszam wszystkich światłych i kreatywnych ceniących POSTĘP. Data Mining: chyba nie trzeba przedstawiać
Data Warehouse IT
Data Warehouse IT
Zagadnienia data warehousingu. Data mart, modele data warehouse, narzędzia, ETL - wymiana doświadczeń i wiedzy
Djembe, Congi i inne bębny...
Djembe, Congi i inne bębny...
Dla miłośników gry na bebnach różnorakich...:) (Wszelkie informacje nie dotyczące bębnów będą usuwane)
Excel VBA
Excel VBA
zastosowanie Excel'a i 'Visual Basic for Applications' w biznesie