Sugar : Italy

Sugar Project has been a terrific project since I have been able to work on the entire process of collecting requirement, developing and deploying the solution. Sugar is a music company (both recording and editorial) in Italy that represents one of the most important italian authors and singer (Andrea Bocelli just to name one). We have been asked to implement with new technology part of their information system (from contracts to royalty distribution). During the first part of the project I have been involved in the detail requirement collection, and I was responsible of the formalism used, that was, of course UML. After almost four months of collecting the requirements we built a team to implement the solution. We have chosen to implement everything in Java technology (as front layer and business layer) and we have used Oracle database as the data repository. We have also investigating the possibility to use Oracle Portal Framework as a front end application, but after two months of developing and testing we have decided that the technology was not mature yet for our needs. We have used Oracle Application Server (and OC4J) as the Application Server for the entire solution. For the royalty distribution process we have developed a lot of PL/SQL code for performance reason.