Gestión postventa

Proyecto final de carrera en el que una empresa, especializada en el segmento de los electrodomésticos, se ve en la necesidad de cambiar el sistema que tiene para gestionar la postventa de sus productos. Se han analizado los requerimientos del nuevo sistema, así como implementado la base de datos que satisface estos requerimientos junto con los procedimientos necesarios para la gestión que proporcionaran el único método de acceso. A parte de la gestión diaria de las incidencias, se han consolidado datos para generar estadísticas que permitan mejorar la eficiencia de la empresa.

Disseny i implementació d'un sistema per a gestionar la postvenda d'electrodomèstics

Treball centrat en el disseny i implementació d'una base de dades relacional (BD) per a la gestió d'incidències d'electrodomèstics, atenent als requeriments inicialment establerts. Inclou els procediments emmagatzemats, els sistema de diari (log). També es crea un magatzem de dades (DWH) i el procés d'extracció, transformació i càrrega (ETL) entre la BD i el DWH. Finalment es creen unes consultes específiques del DWH i una interfície HTML per a realitzar-les des d'un navegador i un servidor web.

Disseny i implementació d'una base de dades relacional per a la gestió d'incidències de productes

Treball Final de Grau l'objectiu del qual és proporcionar les eines de programari necessàries, implementades com procediments emmagatzemats, per a poder realitzar totes les tasques relacionades amb les incidències d'un servei post venta.

GAST (Gestio Averies Servei Tecnic) : aplicació J2EE

Aplicació per a la gestió de les averies d'un servei tècnic, i de l'equipament informàtic de l'empresa.

Sequencing lifeline repairs after an earthquake: an economic approach

Recoveries after recent earthquakes in the U.S. and Japan have shown that large welfare gains can be achieved by reshaping current emergency plans as incentive-compatible contracts. We apply tools from the mechanisms design literature to show ways to integrate economic incentives into the management of natural disasters and discuss issues related to the application to seismic event recovery. The focus is on restoring lifeline services such as the water, gas, transportation, and electric power networks. We put forward decisional procedures that an uninformed planner could employ to set repair priorities and help to coordinate lifeline firms in the post-earthquake reconstruction.

Reprisals remembered: German-Greek conflict and car sales during the Euro crisis

During the Greek debt crisis after 2010, the German government insisted on harshausterity measures. This led to a rapid cooling of relations between the Greekand German governments. We compile a new index of public acrimony betweenGermany and Greece based on newspaper reports and internet search terms. Thisinformation is combined with historical maps on German war crimes during theoccupation between 1941 and 1944. During months of open conflict between Germanand Greek politicians, German car sales fell markedly more than those of cars fromother countries. This was especially true in areas affected by German reprisals duringWorldWar II: areas where German troops committed massacres and destroyed entirevillages curtailed their purchases of German cars to a greater extent during conflictmonths than other parts of Greece. We conclude that cultural aversion was a keydeterminant of purchasing behavior, and that memories of past conflict can affecteconomic choices in a time-varying fashion. These findings are compatible withbehavioral models emphasizing the importance of salience for individual decision-making.

Preliminary results of the Social Impact Research Group of MEDEX: the request database (2000-2002) of two Meteorological Services

One of the aims of the MEDEX project is to improve the knowledge of high-impact weather events in the Mediterranean. According to the guidelines of this project, a pilot study was carried out in two regions of Spain (the Balearic Islands and Catalonia) by the Social Impact Research group of MEDEX. The main goal is to suggest some general and suitable criteria about how to analyse requests received in Meteorological Services arising out of the damage caused by weather events. Thus, all the requests received between 2000 and 2002 at the Servei Meteorològic de Catalunya as well as at the Division of AEMET in the Balearic Islands were analysed. Firstly, the proposed criteria in order to build the database are defined and discussed. Secondly, the temporal distribution of the requests for damage claims is analysed. On average, almost half of them were received during the first month after the event happened. During the first six months, the percentage increases by 90%. Thirdly, various factors are taken into account to determine the impact of specific events on society. It is remarkable that the greatest number of requests is for those episodes with simultaneous heavy rain and strong wind, and finally, those that are linked to high population density.

Biblioteca universitaria, CRAI y alfabetización informacional (María Pinto, Dora Sales y Pilar Osorio)

DURANTE LA CELEBRACIÓN EN LA UNIVERSITAT DE BARCELONA (marzo de 2008) de la Conferencia de primavera de la EUA (European University Association), se ha definido la estrategia a seguir para consolidar los retos del EEES (Espacio Europeo de Educación Superior) y del EEI (Espacio Europeo de Investigación).

Emergency hospital services utilization in Lleida (Spain): a cross-sectional study of immigrant and Spanish-born populations

Background: The use of emergency hospital services (EHS) has increased steadily in Spain in the last decade while the number of immigrants has increased dramatically. Studies show that immigrants use EHS differently than native-born individuals, and this work investigates demographics, diagnoses and utilization rates of EHS in Lleida (Spain). Methods: Cross-sectional study of all the 96,916 EHS visits by patients 15 to 64 years old, attended during the years 2004 and 2005 in a public teaching hospital. Demographic data, diagnoses of the EHS visits, frequency of hospital admissions, mortality and diagnoses at hospital discharge were obtained. Utilization rates were estimated by group of origin. Poisson regression was used to estimate the rate ratios of being visited in the EHS with respect to the Spanish-born population. Results: Immigrants from low-income countries use EHS services more than the Spanish-born population. Differences in utilization patterns are particularly marked for Maghrebi men and women and sub-Saharan women. Immigrant males are at lower risk of being admitted to the hospital, as compared with Spanish-born males. On the other hand, immigrant women are at higher risk of being admitted. After excluding the visits with gynecologic and obstetric diagnoses, women from sub-Saharan Africa and the Maghreb are still at a higher risk of being admitted than their Spanish-born counterparts. Conclusion: In Lleida (Spain), immigrants use more EHS than the Spanish born population. Future research should indicate whether the same pattern is found in other areas of Spain and whether EHS use is attributable to health needs, barriers to access to the primary care services or similarities in the way immigrants access health care in their countries of origin.

Prescription in the proposal for a common european sales law

The rules on prescription in Part VIII, Chapter 18, of the Proposal for a Common European Sales Law (CESL) follow the provisions of the Principles of European Contract Law (PECL) and the Draft Common Frame of Reference (DCFR), which, in general, have deserved favourable comments. Yet, a number of rules contained in those texts have been omitted. It is necessary to ascertain whether the CESL rules only apply to provisions on rights and claims resulting from sales or related services contracts, or whether they are also applicable to any other contractual right or claim and also to rights or claims of non-contractual origin. One of the most problematic issues concerns general prescription periods: firstly, because there are two general periods, a short one and a long one, without any specification about the claims or rights covered by each one of them; secondly, because neither period is suitable in case of non-conformity. There are also some interpretation problems due to missing, ambiguous or defective definitions. The systematic approach demands clarification too.