Profilbild von Jnos Kurics External Data Expert aus Budapest

János Kurics

nicht verfügbar bis 31.12.2024

Letztes Update: 17.03.2024

External Data Expert

Abschluss: Pannon University
Stunden-/Tagessatz: anzeigen
Sprachkenntnisse: deutsch (verhandlungssicher) | englisch (verhandlungssicher) | ungarisch (Muttersprache)

Dateianlagen

CV-Janos-Kurics_241123.docx

Skills

202210-202305 Magyar Olaj (BUX: MOL) : Azure Synapse, dataframework, Power BI, Power Designer - Data Modelling /* Data Vault */
202112-now Foxpost Hungary Plc. : Power BI develop, Postgres, airflow
2022.04-2022.05 Viva Media GmbH : Consulting about Postgres Optimization
2020.09-2021.03 Generalli Insurer Data Vault Model Implementation, Modell Migration, ODI, Oracle
2019.10 - 2020.06 Wienenergie independent MDM, Data Vault, Oracle 19, reverse eng, fix legacy
2018.08 – 2019.09 Nordea Bank SE independent Decommission legacy model, Aptitude ETL to DataStage 11.3, massive SQL opt, Teradata 16
2018.02 – 2018.05 Bank of Ireland independentSQL optimization, Informatica
2017.06 – 2017.11 Bank of Austria independentcoordinate, develop, STM, requirements gathering
2016.08 – 2017.03 Lidl Deutschland independentrestructure presentation layer, support, SQL opt
2013.10 – 2015.12 Deutsche Telekom ITSH develop modules on a given Ab initio framework project lang: only German
2013.04 – 2013.10 Arkon Zrt.BIconsulting build DWH from sketch, PoC with Greenplum
2012.01 – 2012.12 Volksbank HU (Sberbank HU)employeeBA activity in MNB reports (ALM), design DM, DataStage dev, design, adm, revise vendors delivery, src from AS400, Mainframe (midas)
2011.07 – 2011.12 Nordea Bank DK Teradata Design DM, Initial and daily load impl scripts
2011.05 – 2011.06 EADS - AirbusTeradata PoC winning new Teradata client. Role: senior TD consultant.
2010.12 – 2011.06 Kesko Teradata PoC winning new TD client, tech demonstration
2010.04 – 2010.12 Nokia FI Teradata PoC of 1600, Informatica, OVI store, omniture
2009.11 – 2010.03 DHL CZ Teradata deputy of ETL lead, Teradata DB, DataStage 7.51
2009.06 – 2009.11 Vodafone SP Teradata migration from Sybase & Oracle to Teradata
2006.10 – 2007.03 Barclays UK SatyamTeradata acquisition sourcing from Mainframe,  Multiload, Fastload, Unix shell script, JCL
2005.10 – 2006.04 British Petrol SatyamReplanting from Oracle Financial to SAP

Projekthistorie

12/2021 - 06/2023
BI Entwickler - Beratung
Foxpost PLc

- Business requirements gathering
- Architecture design
- Modell database
- SQL develop
- design BI layer
- develop Power BI
- b2b consulting

10/2022 - 05/2023
Senior BI Architekt
MOL - Magyar Olaj

External Sr. BI Architect

Activities:
  • model data marts
  • Power BI report develop
  • design sql patterns (eg hist)
  • implementation in datalake, 3nf, star schema layer
  • identify KPIs
  • data cube calculations
  • business analytics
  • coordinate activity

Location: Budapest, Hungary
Microsoft Azure Synapse Cloud, Power BI, MSSQL on premise source, DataLake, Python Data Framework, Power Designer, SQL scripts, data marts, reporting layer

09/2020 - 03/2021
Oracle backend developer

Activities:

 

- legacy SQL code reverse engineering

- legacy business analyses correction

- SQL coding for Data Vault Model

 


10/2019 - 06/2020
Oracle Developer
Wienenergie / Simplity (Energie, Wasser und Umwelt, 500-1000 Mitarbeiter)

master data management project

-data vault V2.0 model
-significantly push forward a Proof of Concept from idle state
-reverse engineering legacy broken structure
-add new PL/SQL packages
-SQL optimization
-ETL develop (scd1, scd2)

08/2018 - 09/2019
Teradata Developer
Nordea Bank (Banken und Finanzdienstleistungen, 500-1000 Mitarbeiter)

Teradata 15 ->16 Intelliflex
Datastage 11.3, xsd services
Python scripting
Entire BI batch reports (Rubix, IRB) SQL optimization
Data lineage creation from exported sql ddl text files with own written python script.
simplify legacy Aptitude ETL tool's steps into one SQL view logic

02/2018 - 05/2018
Data SME
Bank of Ireland (Banken und Finanzdienstleistungen, 500-1000 Mitarbeiter)

DWH consulting
Teradata
Informatica
sql optimization

06/2017 - 11/2017
Stream Lead
Unicredit Bank (Banken und Finanzdienstleistungen, 500-1000 Mitarbeiter)

UniCredit Business Integrated Solutions Austria
on behalf of Teradata Austria

-stream leader, technical analyst
-requirements gathering
-check necessary prerequisites
-create stm
-implementation

FSLDM environment
Teradata 15

08/2016 - 03/2017
Teradata Developer
Lidl (Konsumgüter und Handel, 500-1000 Mitarbeiter)

Lidl Dienstleistung GmbH & Co. KG
via Teradata Deutschland GmbH
consulting, developer

10/2013 - 12/2015
Sr. Active Warehouse Developer
Deutsche Telekom (50-250 Mitarbeiter)

EKO project: I was improving dwh quality, SQL performance, created mat views

 

Location: Neckarsulm

Teradata 15, Viewpoint, SQL Scripts, Active Batch, SVN

Project language: English / German

(some emails, meetings were in German)

Onsite

04/2013 - 10/2013
DWH/BI Consultant
Arkon Zrt. (Sonstiges, 50-250 Mitarbeiter)

http://biconsulting.hu/
Complete DWH build up from sratch. Oracle solution adoption into postgres/Greenplum DB


01/2012 - 11/2012
Sr. Datawarehouse Developer
Sberbank

I worked in the IT HQ of the bank where a small DWH team needed to do many things.

Tasks:
Design Datamarts
Analyst the business (source and dwh)
Create mapping, design and implementation
DataStage ETL Developing (SCD jobs)
Datastage Administration
Revise vendors delivery
Investigation of the complete dwh etl system
Manage and reconfigurate datastage settings in server level
Support the service if it was needed

09/2008 - 12/2011
Consultant
Teradata (Internet und Informationstechnologie, 500-1000 Mitarbeiter)

Main activities:
Internal Teradata consultant for the local PS Teradata organisations.

PoC project wining new TD client: EADS, Kesko, Nokia
PoC project in Nokia the first 1600 series lead in EMEA Ovi Store
ETL coordinator activity in DHL CZ
Database design and develop
Teradata database and tools
Multiple projects handling in the same time
Held trainings about teradata tech & practical project experience
for new collagues 3 times for 3-4 days.

Reisebereitschaft

Verfügbar in den Ländern Ungarn
Profilbild von Jnos Kurics External Data Expert aus Budapest External Data Expert
Registrieren