Ing. Milan Novotny

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

Fähigkeiten und Kenntnisse

Oracle database
datawarehouse
banking
telekommunikations

Werdegang

Berufserfahrung von Milan Novotny

  • Current 27 years and 7 months, since Nov 1998

    Freelancer

    Ing. Milan Novotny

  • 3 years and 9 months, Oct 2019 - Jun 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 months, Dec 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 year and 11 months, 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 year and 6 months, Jul 2015 - Dec 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 months, Feb 2015 - Jun 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 year, Nov 2013 - Oct 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 year and 5 months, Jul 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 months, Jul 2013 - Oct 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 months, 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 months, Mar 2012 - Jun 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 years and 10 months, Sep 1984 - Jun 1990

    Faculty of Chemical Technology

    Chemical University of Prague

    Glass technology

Sprachen

  • German

    A1-A2 (Grundkenntnisse)

  • English

    B1-B2 (Gute Kenntnisse)

  • Russian

    B1-B2 (Gute Kenntnisse)

  • Czech

    C2 (Verhandlungssicher / Muttersprachlich)

XING – Das Jobs-Netzwerk

  • Über eine Million Jobs

    Entdecke mit XING genau den Job, der wirklich zu Dir passt.

  • Persönliche Job-Angebote

    Lass Dich finden von Arbeitgebern und über 20.000 Recruiter·innen.

  • 21 Mio. Mitglieder

    Knüpf neue Kontakte und erhalte Impulse für ein besseres Job-Leben.

  • Kostenlos profitieren

    Schon als Basis-Mitglied kannst Du Deine Job-Suche deutlich optimieren.

21 Mio. XING Mitglieder, von A bis Z