Ing. Milan Novotny

Bis 2023, Consultant Datawarehouse, Homecredit International a.s. Prague, Czech Republic

Benešov, Tschechische Republik

Fähigkeiten und Kenntnisse

Oracle database
datawarehouse
banking
telekommunikations

Werdegang

Berufserfahrung von Milan Novotny

  • Bis heute 25 Jahre und 8 Monate, seit Nov. 1998

    Freelancer

    Ing. Milan Novotny

  • 3 Jahre und 9 Monate, Okt. 2019 - Juni 2023

    Consultant Datawarehouse

    Homecredit International a.s. Prague, Czech Republic

    working as a developer and analyst on new db procedures and changing of existing functionalities on Oracle DB 11g, 12c, 19c, Snowflake, Hadoop. responsibility for: implementation and deploying changes, creating analytic specification, database tunning, creating new database procedures and packages. Key technologies used on the project: PL/SQL Developer, Enterprise Architect, SQLdeveloper, Oracle SQL, MS Office 2016, SVN version tool, POWER-BI, Python, Hadoop, Snowflake, Keboole, Dbeaver.

  • 10 Monate, Dez. 2018 - Sep. 2019

    Oracle Database Developer

    Česká spořitelna, a.s.

    developer on new db procedures and changing of existing functionalities on Oracle DB 12C. responsibility for: -implementation and deploying changes described by analytic specification, database tunning, creating new database procedures and packages. Key technologies used on the project: PL/SQL Developer, Enterprise Architect, SQLdeveloper, Oracle SQL, MS Office 2016, GIT.

  • 1 Jahr und 11 Monate, Jan. 2017 - Nov. 2018

    Informix database developer

    CSOB

    DB developer on IBM Informix 12.1. responsibility for: -implementation and deploying changes described by analytic specification, shell scripting, bugfixing, creating new procedures, changing of existing procedures, scripts, testing functionalities. Key technologies used on project: Squirrel Developer, Power designer, Informix DBACCESS, MSSQL Datamanagemet Studio, MS Office 2016, Atlasian JIRA, Confluence, SVN repository version tool

  • 1 Jahr und 6 Monate, Juli 2015 - Dez. 2016

    Oracle Software Developer

    Raiffeisen bank a.s. Praha

    Milan was working as a senior developer on the creating new db packages and on the changing of existing modules of transactional system on Oracle 12c platform. Milan was responsible for: -implementation and deploying changes described by analytic specification -reviewing other member’s code Key technologies used by Milan on project: PL/SQL Developer, Enterprise Architect, Perforce, Oracle SQL, MS Office 2010

  • 5 Monate, Feb. 2015 - Juni 2015

    DWH Developer

    Orange Slovakia a.s.

    Development of the new DWH for Orange Slovakia a.s. Using Sybase PowerDesigner, PL/SQL Developer, XML, Xpath, XSLT transformation, SVN, HP ALM, MS Office 2010

  • 1 Jahr, Nov. 2013 - Okt. 2014

    Datawarehouse specialist

    IBM Slovakia s.r.o

    Datawarehouse specialist - I was responible for - creating mapping of datastructures from old version of DWH to the new system - development and testing of ETL. - creating PL/SQL packages and procedures for data maining from transaction systems - reviewing other member’s code - repairs and adjustments to the program code

  • 1 Jahr und 5 Monate, Juli 2012 - Nov. 2013

    Oracle senior db developer

    CSOB a.s. Czech republic

    I was working as senior Oracle DB Developer ( back-end) on the ODS ETL modules. Operational Data Store is DWH application developed mainly in Oracle technologies. Projects adopted Agile methodology and TDD. I was responsible for: Writing design specification and UML diagrams Developing code in the presentation, business and database layer Creating ETL mofules for DWH Unit and Integration testing of the code Reviewing other member’s code

  • 4 Monate, Juli 2013 - Okt. 2013

    Oracle senior developer, Finance & Bank

    Homecredit International a.s.

    I was working as senior Oracle db developer on the migration legacy systems Homer to the new system HOSEL2.0 in Vietnam branch. I was was responsible for: - creating mapping of datastructures from legacy systems to the new system - development and testing of migration engine - creating reconciliation report about migration based on PL/SQL procedures and export to Excels sheets - reviewing other member’s code - repairs and adjustments to the program code

  • 4 Monate, Nov. 2012 - Feb. 2013

    Oracle senior database developer

    Homecredit International a.s.

    I was working as senior Oracle db developer( back-end) on the Datawarehouse for Homecredit International a.s. Datawarehouse is developed mainly in Oracle technologies. I was responisible for: - Developing ETL code for minning data from legacy systems based on PL/SQL procedures. - Unit and integration testing of the code - Reviewing other member's code - Repairs and adjustments to the program code

  • 4 Monate, März 2012 - Juni 2012

    Oracle senior db developer, Telecomunication

    Telefonica O2 a.s. Czech republic

    I was working as an Analyst and DB Developer for new features on Claudia project which is a part of the DWH. The system consists of Oracle CRM Siebel server and Oracle 11g database. I was responsible for: Writing design specifications, UML diagrams, and analysis flow of business logic Developing db packages, EIM Siebel scripts, SQL*Loader scripts, shell scripting Unit and Integration testing of developed code in continues integration environment Code review,

Ausbildung von Milan Novotny

  • 5 Jahre und 10 Monate, Sep. 1984 - Juni 1990

    Faculty of Chemical Technology

    Chemical University of Prague

    Glass technology

Sprachen

  • Deutsch

    Grundlagen

  • Englisch

    Gut

  • Russisch

    Gut

  • Tschechisch

    Muttersprache

Interessen

Rock climbing
Scuba diving
Skiing
Cycling

21 Mio. XING Mitglieder, von A bis Z