Ing. Milan Novotny
Bis 2023, Consultant Datawarehouse, Homecredit International a.s. Prague, Czech Republic
Benešov, Tschechische Republik
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