Umiejętności
Application Support
Control-M
Sprawdzanie poprawności danych
DB2
ETL
Git
IBM AS/400
Kalido
Microsoft SQL Server
Microstrategy
Midas
OBIEE
Oracle
Oracle Warehouse Builder
OS/400
PLC Ladder Logic
PowerCenter
Project Management
Siebel
SQL
Tableau
Unix
Weblogic
WebSphere MQ
Analiza danych
Analiza
MDM
Administracja systemami
Certyfikat ITIL v3
SAP BO
OBIEE 11g
administracja aplikacjami
APEX
Shell Scripts
Oracle RUEI
Disaster Recovery (DR)
Busines Intelligence
Języki
polski
ojczysty
angielski
biegły
Doświadczenie zawodowe
Senior BI Administrator
- Tableau
* Server Installation / Maintenance / Migration
* Report creation and performance fixing
* Performing tests and analysis with business teams
- SQL scripting
* Writing SQL scripts
* Improving query performance
* Data validation on database side
- Semanta ( Data Governance Application )
* Installation / Maintenance
* Data loads
* Cooperation with business customer and supplier
- Data loading processes execution
* Preparing and validating data
* Running Kettle ETL processes
* Reviewing logs and fixing issues during the process flow
- Microstrategy - Knowlege of environment, tools and raport creation
- Support for many global applications and business portals used by the client
- Windows scripting - Preparing application and administrative scripts
- Git version control system - Installation / Maintenance / Migration
- Work on preparing and checking mappings in a Data Warehouse
- Cooperation with French and Thailand teams
- Coordination of external teams regarding business and technical processes
- Maintaining contacts with the application vendors
- Creating technical documentation and reviewing existing one
* Server Installation / Maintenance / Migration
* Report creation and performance fixing
* Performing tests and analysis with business teams
- SQL scripting
* Writing SQL scripts
* Improving query performance
* Data validation on database side
- Semanta ( Data Governance Application )
* Installation / Maintenance
* Data loads
* Cooperation with business customer and supplier
- Data loading processes execution
* Preparing and validating data
* Running Kettle ETL processes
* Reviewing logs and fixing issues during the process flow
- Microstrategy - Knowlege of environment, tools and raport creation
- Support for many global applications and business portals used by the client
- Windows scripting - Preparing application and administrative scripts
- Git version control system - Installation / Maintenance / Migration
- Work on preparing and checking mappings in a Data Warehouse
- Cooperation with French and Thailand teams
- Coordination of external teams regarding business and technical processes
- Maintaining contacts with the application vendors
- Creating technical documentation and reviewing existing one
Business Intelligence Application Specialist
Hewlett-Packard Polska Sp. z o.o.
- L3 Applications support for main HP customer
- Performing changes and fixes complying with the ITIL rules
- Cooperation with application vendors and other development and tech teams
- Supporting applications based on Oracle 11g, Unix, APEX and Informatica Power Center platforms
- Reviewing and fixing SQL or PL/SQL code on Oracle platform
- Analyzing and fixing problems with data flow also from performance perspective
- Cooperation with Philippines support team and other HP teams
- Preparing technical documentation ( knowledge base )
- Work in a project team in order to improve service and create good practices
- Short period – about 4 months in supporting SAP BO 3.1 and 4.1 env. versions and Oracle Warehouse Builder ( business flow and processes )
- Performing changes and fixes complying with the ITIL rules
- Cooperation with application vendors and other development and tech teams
- Supporting applications based on Oracle 11g, Unix, APEX and Informatica Power Center platforms
- Reviewing and fixing SQL or PL/SQL code on Oracle platform
- Analyzing and fixing problems with data flow also from performance perspective
- Cooperation with Philippines support team and other HP teams
- Preparing technical documentation ( knowledge base )
- Work in a project team in order to improve service and create good practices
- Short period – about 4 months in supporting SAP BO 3.1 and 4.1 env. versions and Oracle Warehouse Builder ( business flow and processes )
IT Service Consultant, BI Tech
- Supporting Oracle Business Intelligence 10/11g (Asia / America / Middle East / Africa and Europe)
- Supporting ETL (Informatica Power Center 8/9) processes and solving problems.
- Administering Oracle WebLogic Server
- Solving performance problems in OBIEE, Informatica and Oracle database area.
- Supporting master data management system MDM Kalido
- Preparing Availability & Performance reports for international environments.
- Executing deployments , dry runs, tests for OBIEE and ETL environments ( production and support )
- Supporting strategic global business applications and GSK processes
- Supporting alert/monitoring systems ( Application Manager, Mercury Business Availability Center and Oracle RUEI )
- Performing IMS data loads
- Installations, upgrades and patching ( OBIEE, Informatica and MDM ) environments
- Maintaining the Siebel CRM systems.
- Preparing and executing disaster recovery tests for global GSK environment
- Supporting ETL (Informatica Power Center 8/9) processes and solving problems.
- Administering Oracle WebLogic Server
- Solving performance problems in OBIEE, Informatica and Oracle database area.
- Supporting master data management system MDM Kalido
- Preparing Availability & Performance reports for international environments.
- Executing deployments , dry runs, tests for OBIEE and ETL environments ( production and support )
- Supporting strategic global business applications and GSK processes
- Supporting alert/monitoring systems ( Application Manager, Mercury Business Availability Center and Oracle RUEI )
- Performing IMS data loads
- Installations, upgrades and patching ( OBIEE, Informatica and MDM ) environments
- Maintaining the Siebel CRM systems.
- Preparing and executing disaster recovery tests for global GSK environment
Owner
MMA-iTECH
- Outsourcing IT
- Consulting and supporting for companies
- Databases : MS SQL, Oracle, DB2
- Systems : UNIX, WINDOWS, OS/400
- Support IT infrastructure ( hardware and software )
- Recovery of lost data
- Training for companies and individuals in the field of IT
- Security and Data Archiving
- Cooperation with companies from the IT sector
- Consulting and supporting for companies
- Databases : MS SQL, Oracle, DB2
- Systems : UNIX, WINDOWS, OS/400
- Support IT infrastructure ( hardware and software )
- Recovery of lost data
- Training for companies and individuals in the field of IT
- Security and Data Archiving
- Cooperation with companies from the IT sector
Administrator AS/400, SQL Server, Oracle and Applications
Generali T.U. S.A.
- Performing admin work on systems such as UNIX and AS/400.
- Administering of databases Oracle, MS SQL, DB2 and Universe in various server environment.
- Performing backups of databases and applications (RMAN, Tivoli TSM, BRMS and others) and protecting stored backups.
- Creating administrative scripts for UNIX and OS/400.
- Preparing and administrating the test environments for analysts and programmers.
- Preparing Disaster Recovery procedures and testing.
- Working with MQ Series - to enable communication between applications and servers.
- Administering the main insurance application of the company.
- Managing permissions systems, databases and applications - providing an appropriate security architecture.
- Managing the software and hardware - offering new solutions.
- Leading or participating in implementation projects (systems, databases or applications)
- Carrying out installation of specialized software, software upgrades, hardware, systems and databases tuning.
- Preparing technical documentation and procedures.
- Cooperation on the company merger project.
- Cooperation with external companies - suppliers of hardware and software.
- Working with application analysts and developers in creating and implementing new solutions.
- Cooperation with Help Desk - joint problem solving.
- Administering of databases Oracle, MS SQL, DB2 and Universe in various server environment.
- Performing backups of databases and applications (RMAN, Tivoli TSM, BRMS and others) and protecting stored backups.
- Creating administrative scripts for UNIX and OS/400.
- Preparing and administrating the test environments for analysts and programmers.
- Preparing Disaster Recovery procedures and testing.
- Working with MQ Series - to enable communication between applications and servers.
- Administering the main insurance application of the company.
- Managing permissions systems, databases and applications - providing an appropriate security architecture.
- Managing the software and hardware - offering new solutions.
- Leading or participating in implementation projects (systems, databases or applications)
- Carrying out installation of specialized software, software upgrades, hardware, systems and databases tuning.
- Preparing technical documentation and procedures.
- Cooperation on the company merger project.
- Cooperation with external companies - suppliers of hardware and software.
- Working with application analysts and developers in creating and implementing new solutions.
- Cooperation with Help Desk - joint problem solving.
Administrator AS/400 and Bank Applications
HypoVereinsbank Polska S.A.
- Administering the banking system MIDAS on AS/400 platform.
- Performing tasks associated with OS/400 and banking applications.
- Preparing reports and banking system backups.
- Administering AS/400 machine and Novell network.
- Supporting telephone exchange system Hicom 300.
- Taking care of mass printing environment and prints .
- Installing and upgrading software and hardware of the company.
- Participation in the bank merger project.
- Work as a Help Desk for company workers.
- Performing tasks associated with OS/400 and banking applications.
- Preparing reports and banking system backups.
- Administering AS/400 machine and Novell network.
- Supporting telephone exchange system Hicom 300.
- Taking care of mass printing environment and prints .
- Installing and upgrading software and hardware of the company.
- Participation in the bank merger project.
- Work as a Help Desk for company workers.
Designer, Developer
MERAWAY Sp. z o.o.
- Designing and implementing industrial automation, monitoring and control of water and sewage facilities.
- Programming PLC controllers MODICON, produced by AEG.
- Programming PLC controllers MERAWAY SP-51.
- Developing application visualization on individual objects and specific guidelines for a client.
- Performing tasks related to service on customer side.
- Dealing with the help desk for company workers.
- Programming PLC controllers MODICON, produced by AEG.
- Programming PLC controllers MERAWAY SP-51.
- Developing application visualization on individual objects and specific guidelines for a client.
- Performing tasks related to service on customer side.
- Dealing with the help desk for company workers.
Szkolenia i kursy
Completed trainings/certificates during professional career :
Hewlett-Packard
• Oracle Database SQL Expert (certificate)
GlaxoSmithKline
• UX01 - Administracja systemami rodziny Unix cz. I
• UX02 - Administracja systemami rodziny Unix cz. II
• Siebel 8.1.x BI Publisher Reports” and “Integrating Siebel 8.0 Applications
• Siebel 8.1.x Business Automation” and “Siebel 8.0 New Features
• ITIL Fundamentals (certificate)
• PowerCenter 9 Upgrade
• Performance Tuning Workshop – PowerCenter 9
• Oracle WebLogic Server 11g: Administration Essentials
• Oracle Database 11g - SQL Tuning Workshop
• Oracle WebLogic Server 11g: Diagnostics and Troubleshooting
• Oracle Database 11g: Administer a Data Warehouse
Generali T.U. S.A.
• AS/400 System Tuning
• IBM UniVerse Administration
• AS/400 Control Language Programming
• MQ30 MQseries Advanced Administration
• SQL Server Administration
• Administracja bazą ORACLE
• Archiwizacja i odtwarzanie bazy danych Oracle
• Administracja SQL Server 2005
HypoVereinsbank Polska S.A.
• AS/400 System Facilities
• AS/400 System Administration and Control
Hewlett-Packard
• Oracle Database SQL Expert (certificate)
GlaxoSmithKline
• UX01 - Administracja systemami rodziny Unix cz. I
• UX02 - Administracja systemami rodziny Unix cz. II
• Siebel 8.1.x BI Publisher Reports” and “Integrating Siebel 8.0 Applications
• Siebel 8.1.x Business Automation” and “Siebel 8.0 New Features
• ITIL Fundamentals (certificate)
• PowerCenter 9 Upgrade
• Performance Tuning Workshop – PowerCenter 9
• Oracle WebLogic Server 11g: Administration Essentials
• Oracle Database 11g - SQL Tuning Workshop
• Oracle WebLogic Server 11g: Diagnostics and Troubleshooting
• Oracle Database 11g: Administer a Data Warehouse
Generali T.U. S.A.
• AS/400 System Tuning
• IBM UniVerse Administration
• AS/400 Control Language Programming
• MQ30 MQseries Advanced Administration
• SQL Server Administration
• Administracja bazą ORACLE
• Archiwizacja i odtwarzanie bazy danych Oracle
• Administracja SQL Server 2005
HypoVereinsbank Polska S.A.
• AS/400 System Facilities
• AS/400 System Administration and Control
Specjalizacje
IT - Administracja
Administrowanie bazami danych i storage
IT - Administracja
Administrowanie systemami
IT - Administracja
Zarządzanie usługami
Zainteresowania
Photography, music and travels