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.

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.

Effectiveness of a drug dosing service provided by community pharmacists in polymedicated elderly patients with renal impairment a comparative study

Background: Drug dosing errors are common in renal-impaired patients. Appropriate dosing adjustment and drug selection is important to ensure patients" safety and to avoid adverse drug effects and poor outcomes. There are few studies on this issue in community pharmacies. The aims of this study were, firstly, to determine the prevalence of dosing inadequacy as a consequence of renal impairment in patients over 65 taking 3 or more drug products who were being attended in community pharmacies and, secondly, to evaluate the effectiveness of the community pharmacist"s intervention in improving dosing inadequacy in these patients when compared with usual care. Methods: The study was carried out in 40 Spanish community pharmacies. The study had two phases: the first, with an observational, multicentre, cross sectional design, served to determine the dosing inadequacy, the drug-related problems per patient and to obtain the control group. The second phase, with a controlled study with historical control group, was the intervention phase. When dosing adjustments were needed, the pharmacists made recommendations to the physicians. A comparison was made between the control and the intervention group regarding the prevalence of drug dosing inadequacy and the mean number of drug-related problems per patient. Results: The mean of the prevalence of drug dosing inadequacy was 17.5% [95% CI 14.6-21.5] in phase 1 and 15.5% [95% CI 14.5-16.6] in phase 2. The mean number of drug-related problems per patient was 0.7 [95% CI 0.5-0.8] in phase 1 and 0.50 [95% CI 0.4-0.6] in phase 2. The difference in the prevalence of dosing inadequacy between the control and intervention group before the pharmacists" intervention was 0.73% [95% CI (−6.0) - 7.5] and after the pharmacists" intervention it was 13.5% [95% CI 8.0 - 19.5] (p < 0.001) while the difference in the mean of drug-related problems per patient before the pharmacists" intervention was 0.05 [95% CI( -0.2) - 0.3] and following the intervention it was 0.5 [95% CI 0.3 - 0.7] (p < 0.001). Conclusion: A drug dosing adjustment service for elderly patients with renal impairment in community pharmacies can increase the proportion of adequate drug dosing, and improve the drug-related problems per patient. Collaborative practice with physicians can improve these results.

Political economy of municipal water service privatization in Spain: a duration model analysis

This empirical work applies a duration model to the study of factors determining privatization of local water services. I assess how factors determining privatization decision evolve as time goes by. A sample of 133 Spanish municipalities during the six terms of office taken place during the 1980-2002 period is analyzed. A dynamic neighboring effect is hypothesized and successfully tested. In a first stage, private water supply firms may try to expand to regions where there is no service privatized, in order to spread over this region after having being installed thanks to its scale advantages. Other factors influencing privatization decision evolve during the two decades under study, from the priority to fix old infrastructures to the concern about service efficiency. Some complementary results regarding political and budgetary factors are also obtained

Effectiveness of a drug dosing service provided by community pharmacists in polymedicated elderly patients with renal impairment a comparative study

Background: Drug dosing errors are common in renal-impaired patients. Appropriate dosing adjustment and drug selection is important to ensure patients" safety and to avoid adverse drug effects and poor outcomes. There are few studies on this issue in community pharmacies. The aims of this study were, firstly, to determine the prevalence of dosing inadequacy as a consequence of renal impairment in patients over 65 taking 3 or more drug products who were being attended in community pharmacies and, secondly, to evaluate the effectiveness of the community pharmacist"s intervention in improving dosing inadequacy in these patients when compared with usual care. Methods: The study was carried out in 40 Spanish community pharmacies. The study had two phases: the first, with an observational, multicentre, cross sectional design, served to determine the dosing inadequacy, the drug-related problems per patient and to obtain the control group. The second phase, with a controlled study with historical control group, was the intervention phase. When dosing adjustments were needed, the pharmacists made recommendations to the physicians. A comparison was made between the control and the intervention group regarding the prevalence of drug dosing inadequacy and the mean number of drug-related problems per patient. Results: The mean of the prevalence of drug dosing inadequacy was 17.5% [95% CI 14.6-21.5] in phase 1 and 15.5% [95% CI 14.5-16.6] in phase 2. The mean number of drug-related problems per patient was 0.7 [95% CI 0.5-0.8] in phase 1 and 0.50 [95% CI 0.4-0.6] in phase 2. The difference in the prevalence of dosing inadequacy between the control and intervention group before the pharmacists" intervention was 0.73% [95% CI (−6.0) - 7.5] and after the pharmacists" intervention it was 13.5% [95% CI 8.0 - 19.5] (p < 0.001) while the difference in the mean of drug-related problems per patient before the pharmacists" intervention was 0.05 [95% CI( -0.2) - 0.3] and following the intervention it was 0.5 [95% CI 0.3 - 0.7] (p < 0.001). Conclusion: A drug dosing adjustment service for elderly patients with renal impairment in community pharmacies can increase the proportion of adequate drug dosing, and improve the drug-related problems per patient. Collaborative practice with physicians can improve these results.

Effectiveness of a drug dosing service provided by community pharmacists in polymedicated elderly patients with renal impairment a comparative study

Background: Drug dosing errors are common in renal-impaired patients. Appropriate dosing adjustment and drug selection is important to ensure patients" safety and to avoid adverse drug effects and poor outcomes. There are few studies on this issue in community pharmacies. The aims of this study were, firstly, to determine the prevalence of dosing inadequacy as a consequence of renal impairment in patients over 65 taking 3 or more drug products who were being attended in community pharmacies and, secondly, to evaluate the effectiveness of the community pharmacist"s intervention in improving dosing inadequacy in these patients when compared with usual care. Methods: The study was carried out in 40 Spanish community pharmacies. The study had two phases: the first, with an observational, multicentre, cross sectional design, served to determine the dosing inadequacy, the drug-related problems per patient and to obtain the control group. The second phase, with a controlled study with historical control group, was the intervention phase. When dosing adjustments were needed, the pharmacists made recommendations to the physicians. A comparison was made between the control and the intervention group regarding the prevalence of drug dosing inadequacy and the mean number of drug-related problems per patient. Results: The mean of the prevalence of drug dosing inadequacy was 17.5% [95% CI 14.6-21.5] in phase 1 and 15.5% [95% CI 14.5-16.6] in phase 2. The mean number of drug-related problems per patient was 0.7 [95% CI 0.5-0.8] in phase 1 and 0.50 [95% CI 0.4-0.6] in phase 2. The difference in the prevalence of dosing inadequacy between the control and intervention group before the pharmacists" intervention was 0.73% [95% CI (−6.0) - 7.5] and after the pharmacists" intervention it was 13.5% [95% CI 8.0 - 19.5] (p < 0.001) while the difference in the mean of drug-related problems per patient before the pharmacists" intervention was 0.05 [95% CI( -0.2) - 0.3] and following the intervention it was 0.5 [95% CI 0.3 - 0.7] (p < 0.001). Conclusion: A drug dosing adjustment service for elderly patients with renal impairment in community pharmacies can increase the proportion of adequate drug dosing, and improve the drug-related problems per patient. Collaborative practice with physicians can improve these results.