Programmer / analyst
Main projects :
- Data Migration - ETL
- Customer: Hewlett Packard Enterprise/Ministerstvo práce a sociálních věcí
- Role: analyst/ solution architech of migrating to ESSL.
The main part was the preparation of migration data from the client's original source systems into the structure defined by the new ISZAM developer. Part of the project was the analysis of migration data requirements, creation of a physical model based on the logical, reverse analysis of existing applications and database models and creation of a transformation process to create the required migration data. An integral part of the project was the creation of a mechanism for loading data from Oracle databases of original systems into the central migration database in MS SQL. With this mechanism, about 8000 tables, of which about 2,000 from each of the 270 decentralized databases were transferred.
Another part was migrating all appropriate documents from MPSV original system into Electronic file system ArsysX.
- Technology: Oracle DB, SQL Server, DISL, EA, Java, Groovy