Grzegorz Jura

Grzegorz Jura

senior IT spec. of BI/ETL
Wadowice, małopolskie

Języki

polski
ojczysty
angielski
dobry

Doświadczenie zawodowe

Synthos SA
Spec. Of Reporting and Analyst IT
Synthos SA
 Preparing data Warehouse (from SQL Server, Oracle, Excel) using IBM DataStage (ETL)
 Analyzing IFS database
 Integration IFS with PI OsiSoft using IBM DataBus
 Preparing reports for users and management in MicroStrategy (WEB, Developer).
 Administrating of DB2 server, DataStage Server and MicroStrategy Server
 Help in resolving Oracle and DB2 SQL problems
 Administrating IBM DataBus and PI OsiSoft Server
 Participate in making decisions about new IT solutions and new systems to support the work
 Training new user to work with MicroStrategy
 IBM BigFix an ILMT still learning
OKNOPLAST Sp. z o.o.
Computers Systems Analyst
OKNOPLAST Sp. z o.o.
 ERP administration program (training users and collecting information on the business requirements for the program) (Simple.ERP, Simple.Okna, Simple.CRM)
 Coordinating, implementing new software solutions (work well in a group)
 First line support to end-users in the use of the ERP system and the locally installed programs
 Creation of analytical reports based on SQL Reporting Services,
 Support for the database in SQL (modification, improvement, optimization, control operation, creating procedures),
 Preparing documentations of realized projects
 Helpdesk program management - ServiceDesk Plus
 Administration email accounts
 The creation of technical documentation of implemented projects and instructions
 SQLSERVER server support
 Create database In MS Access
 Preparing databases integration between different applications.
 Assign permissions to the database
 Training users in SQL and Reports Server
Drewex
IT Specialist
Drewex S.A.
 Administration and initiate program REKORD.ERP for management company.
 Acquired experience in Sphere of coordination documents and book accounts in program units like Store House (Magazine) Sale, Production, Orders etc.
 Network cabling, hardware and software configuration (TCP/IP, Router, Cabling).
 Create technical documentation and instruction 3D for use to products (Inventor 3D),
 Working with terminal server (Win2003) and database server (Firebird, Interbase) in Linux,.
 Database service in SQL language (modification, rationalization, control of correctness working, creating procedures, triggers, reports and views ).

Edukacja

Logo
Engineering Mechanical and Robotics, inżynierskie
Akademia Górniczo-Hutnicza im. Stanisława Staszica w Krakowie
Logo
electrical machinery and apparatus, średnie
Technical College of Electricity

Specjalizacje

IT - Administracja
Administrowanie bazami danych i storage
IT - Administracja
Administrowanie systemami
IT - Administracja
Wdrożenia ERP
IT - Administracja
Wsparcie techniczne/Helpdesk
IT - Rozwój oprogramowania
Inne

Zainteresowania

photography, active football, rollers, bike

Inne

 Very good knowledge of ETL: IBM DataStage
 Very good knowledge of reporting system: MicroStrategy WEB and Developer, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS)
 Operating Systems: Win 9X, 2000, XP, Vista, Win Server 2003, Win 2008, Linux (Red Heat)
 MS Office Pack, Microsoft SQL Server (configuring, preparing backup, configuring security, linked server and etc) /Interbase/Firebird, (configuring, preparing backup, configuring security, linked server and etc), DB2 (configuring in AIX system), Oracle
 Network cabling, hardware and software configuration (TCP/IP, Router, Cabling, desktop system), WiFi Router and AccesPoint (configuring and preparing to work)
 Very good knowledge of computer hardware (structure, building, repairing).
 Back-up Data Operator of Windows Servers and users computer
 Preparing integration between different databases (integration using text files and exchange table)
 Higher level knowledge of SQL language (T-SQL, Firebirs SQL, Oracle, DB2) (triggers, procedures, views, functions …) , basic level of XML.
 Applications: Simple.ERP, Simple.CRM, Rekord.erp, IFS, IBM Maximo, ManageEngine ServiceDesk Plus, Microsoft Access, Subiekt, VNC, PC Anywhere, Radmin, Paint Shop Pro, Symantec Ghost, Partition Magic, PhotoShop, Corel, VMware, Virtual PC, basic level of Catia 3D, Autocad 3D, Unigraphics 3D, Matlab, Matcad, higher level Inventor 3D, Mechanical Desktop 3D etc.

Grupy

Akademia Górniczo-Hutnicza im. Stanisława Staszica w Krakowie
Akademia Górniczo-Hutnicza im. Stanisława Staszica w Krakowie
Akademia Górniczo-Hutnicza to jedna z najlepszych i najbardziej renomowanych polskich uczelni, od lat zajmująca czołowe miejsca w rankingach szkół wyższych. Przoduje w dziedzinie nowocze
Pokaż więcej