Michał Marciniak

OBIEE, Informatica, Oracle Databases,MDM, AS/400, MS SQL Server, Unix
Masovian District, zagranica

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

Webellian Poland Sp. z o.o.
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
Hewlett-Packard Polska Sp. z o.o.
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 )
GlaxoSmithKline
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
Logo
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
Generali Group
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.
Logo
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.
Logo
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.

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

Edukacja

Logo
Information Technology, średnie
Mila College

Specjalizacje

IT - Administracja
Administrowanie bazami danych i storage
IT - Administracja
Administrowanie systemami
IT - Administracja
Zarządzanie usługami

Zainteresowania

Photography, music and travels