Keywords
Skills
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
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
Project history
12/2021
-
Present
BI Entwickler - Beratung
Foxpost PLc
- Business requirements gathering
- Architecture design
- Modell database
- SQL develop
- design BI layer
- develop Power BI
- b2b consulting
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
(500-1000 employees)
Energy, water and environment
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)
-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
(500-1000 employees)
Banks and financial services
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
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
(500-1000 employees)
Banks and financial services
DWH consulting
Teradata
Informatica
sql optimization
Teradata
Informatica
sql optimization
06/2017
-
11/2017
Stream Lead
Unicredit Bank
(500-1000 employees)
Banks and financial services
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
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
(500-1000 employees)
Consumer goods and retail
Lidl Dienstleistung GmbH & Co. KG
via Teradata Deutschland GmbH
consulting, developer
via Teradata Deutschland GmbH
consulting, developer
10/2013
-
12/2015
Sr. Active Warehouse Developer
Deutsche Telekom
(50-250 employees)
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.
(50-250 employees)
Other
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
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
(500-1000 employees)
Internet and Information Technology
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.
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.
Local Availability
Only available for the countries
Hungary
