Dipl.-Ing. Juraj Ivanega

Database Architecture / Database Development / Data Warehouse / ETL (Extract, Transform, Load) •• (Oracle) Database architecture: logical and physical database design (relational and DWH) •• Database development (Oracle SQL and PL/SQL, Oracle Forms, Oracle Reports) •• ETL Design and Development (Informatica Powermart) •• Business requirements and impact analysis

• to design and development ETL end-to-end solution • to write PL/SQL procedures/packages • to update logical and physical database model (using ERwin) and to keep it synchronized with database • to analyze specific reporting features and to implement them into new DWH solution and BI reporting

Working in Global Product Lifecycle Management System - Oracle upgrade from 10g to 11gR2-technical planning and execution - system environments reorganization-technical design and execution - new integrations and new requirements analysis (System Design, Development and Testing); working with Scrum Master on release plan [detailed list of project available per request]

Working in Global Product Lifecycle Management System (based on Oracle db) - analysis of business needs/requirements, consideration of implementation - functional and technical database design documents (to be used and implemented by developers) - effort estimation - leading/supporting/supervising team of developers - keeping related documentation up to date - responsibility for Technical Roadmap - in case of new requirements assuring to follow the Nokia enterprise architecture framework

Working in Global Product Lifecycle Management System (based on Oracle db) - development Oracle SQL and PL/SQL - design, development and maintenance of front-end application based on Oracle Forms and Reports (ver. 6.0) - utilizing Case Tool (Oracle Designer) to support design and development - Informatica Powermart development (mappings, worklets, workflows, sessions) - creating test cases; supporting unit and integration testing; deployment of new releases - post-delivery support

Oracle SQL and PL/SQL development - design, development and maintenance of front-end application based on Oracle Forms and Reports - utilizing Case Tool (Oracle Designer) for design and development - test cases, unit and integration testing, deployment - Informatica Powermart development - post-delivery support - advanced application support - monitoring data load and Oracle replication - training material and trainings for support - coordinating support activities with T3 and T2 support layer

PL/SQL and SQL developer - Oracle Forms developer (Oracle Forms 4.5) - Oracle Reports developer (Oracle Reports 2.5) - using Oracle Designer for development and design - leading small team of developers