Expert Oracle Java Developer
Last active: 1 day ago
I started my professional career in Vodafone as Software Engineer. My team developed and maintained projects for the Vodafone’s network. We worked with SQL loader to load data in Oracle 8i. Within Oracle database i developed procedures and packages to create statistics for the traffic of Vodafone’s network at PL/SQL. Moreover one major fact was the development of the payroll application for the Greek public sector using Oracle 8i as database and Oracle Forms and Reports 6i for the presentation of the data. Additionally one major fact was the development of a new project in Intrasoft International for OLAF. The project manipulated the information provided by OLAF officers and the aim of the project was the calculation of the risks for the vessels and containers approaching the European coasts or passing the European borders.
The database was Oracle 9i and ColdFusion was the Software for displaying data in Screens. At the second stage the application server was BEA Web logic 6 and Java (bean and servlet) to promote the data on the screens.
I was the designer of the database using 3NF model designing index strategy,
triggers using high SQL performance tuning. Also i was the developer of the project using PL/SQL Coldfusion and i assisted the implementation in Java.
Also i developed projects using Java in Mediation system to implement the traffic going to Billing system. There were complicated rules for the billing system, selecting the correct data according to some characteristics receiving the correct tariffs.
Also I had used retention policy in some cases to give priority in selection queries to create statistics (use of database as data ware house and business intelligence) and sometimes I gave priority in the completeness of the billing cycle (used as OLTP database) and in transactions.
Another project I was involved was the reception of Web Services (concerning
network results) transforming data using Json objects and passing them in jsp using Ajax. We used jQuery to display the data on screens (div, css and other html elements). During this implementation i solved problems concerning the various browsers and especially Internet Explorer (i have downloaded Development tools to have in screens all Internet explorer versions) and for this reason i used jQuery which gives the opportunity to work all the html elements in all browsers including Internet Explorer. Nevertheless to face all problems i used special features in css only for Internet explorer 7 and 8. In addition i have worked in a project for the Greek customs. I am responsible to deliver some parts to the client. These parts concern all the major software components started from JSF, Java, JPA Workflow Spring MVC and at the end Oracle 11g.
I have installed Oracle 11g in Linux environment using OFA (Oracle Flexible Architecture). I am responsible for monthly backup (consistent full backup). I also faced problems concerning all database problems (for example problem with tables, synonyms, and users’ quota in table spaces).
Moreover i have developed rules with Java for the business of the project. The functionality of the project is the exchange messages xml using JMS and checking the integrity using xsd files. The data of the message are being transformed in objects passing validation according to some rules and then are loaded at Oracle 11g database. The framework used to load data is JPA using JPQL language. Within project i use Spring Webflow MVC for the dynamic navigation decision. In addition I use Oracle Enterprise Manager to change initialization parameters like the archiving of the database (set in archive log mode the database) memory (maximum and target memory) check the performance of the database using the advisors like memory advisors, sql advisors from
which I can find database problems like bad writing queries and index missing.
Moreover I have created a prototype using JSF 2 with rich faces 4 and Spring Web flow MVC 3.1. After the creation of the prototype we have implemented the screens at JSF. The screens have been accepted by the client. At the second stage we have implemented the validation, submission and the search results using JPQL. The configuration has been implemented using JTA and the provider for the JPA is OpenJPA . At the search i have proposed to use dynamic SQL using JPQL. In addition i have created the database Oracle 11g 2.0.3 at Linux Red Hat using Optimal Flexible Architecture.
After the creation i have changed database settings to suit to our needs.
This prototype includes the configuration of Eclipse Juno, Apache Tomcat 7 as Application Server and maven. In addition i have a knowledge of IBM Rup disciplines methodologies and UML diagrams. In Analysis we retrieve the requirements we fix class diagrams then the use cases from use cases the sequence diagrams.