An Open Source BI Approach: Concept Proof Tracking Fleet

É possível assistir nos dias de hoje, a um processo tecnológico evolutivo acentuado por toda a parte do globo. No caso das empresas, quer as pequenas, médias ou de grandes dimensões, estão cada vez mais dependentes dos sistemas informatizados para realizar os seus processos de negócio, e consequentemente à geração de informação referente aos negócios e onde, muitas das vezes, os dados não têm qualquer relacionamento entre si. A maioria dos sistemas convencionais informáticos não são projetados para gerir e armazenar informações estratégicas, impossibilitando assim que esta sirva de apoio como recurso estratégico. Portanto, as decisões são tomadas com base na experiência dos administradores, quando poderiam serem baseadas em factos históricos armazenados pelos diversos sistemas. Genericamente, as organizações possuem muitos dados, mas na maioria dos casos extraem pouca informação, o que é um problema em termos de mercados competitivos. Como as organizações procuram evoluir e superar a concorrência nas tomadas de decisão, surge neste contexto o termo Business Intelligence(BI). A GisGeo Information Systems é uma empresa que desenvolve software baseado em SIG (sistemas de informação geográfica) recorrendo a uma filosofia de ferramentas open-source. O seu principal produto baseia-se na localização geográfica dos vários tipos de viaturas, na recolha de dados, e consequentemente a sua análise (quilómetros percorridos, duração de uma viagem entre dois pontos definidos, consumo de combustível, etc.). Neste âmbito surge o tema deste projeto que tem objetivo de dar uma perspetiva diferente aos dados existentes, cruzando os conceitos BI com o sistema implementado na empresa de acordo com a sua filosofia. Neste projeto são abordados alguns dos conceitos mais importantes adjacentes a BI como, por exemplo, modelo dimensional, data Warehouse, o processo ETL e OLAP, seguindo a metodologia de Ralph Kimball. São também estudadas algumas das principais ferramentas open-source existentes no mercado, assim como quais as suas vantagens/desvantagens relativamente entre elas. Em conclusão, é então apresentada a solução desenvolvida de acordo com os critérios enumerados pela empresa como prova de conceito da aplicabilidade da área Business Intelligence ao ramo de Sistemas de informação Geográfica (SIG), recorrendo a uma ferramenta open-source que suporte visualização dos dados através de dashboards.

Information flow analysis using data-dependent logical propositions

Dissertação para obtenção do Grau de Mestre em Engenharia Informática

Long-Term and Concentration-Dependent Beneficial Effect of Efavirenz on HDL-Cholesterol in HIV-Infected Patients

AIMS: To investigate the long-term effects of efavirenz on cholesterol (TC), high-density lipoprotein cholesterol (HDL-C), low-density lipoprotein (LDL-C) and triglycerides (TG). METHODS: Thirty-four HIV-infected patients who commenced efavirenz therapy were monitored for 36 months. RESULTS: In patients with baseline HDL-C<40 mg.dL-1 an increase in HDL-C from 31+/-1 mg.dL-1 to 44+/-2 mg.dL-1 (95% confidence interval 5.9, 21.9, P<0.01) was observed and remained throughout the follow-up period. Median efavirenz plasma concentration was 1.98 mg.L-1 and a direct correlation between percentage of HDL-C variation or TC/HDL-C ratio and efavirenz plasma concentrations was found. CONCLUSIONS: There is evidence of a long-term and concentration-dependent beneficial effect of efavirenz on HDL-C in HIV-infected patients.

The mechanism of formate oxidation by metal-dependent formate dehydrogenases

J Biol Inorg Chem (2011) 16:1255–1268 DOI 10.1007/s00775-011-0813-8

Development of integrated separation processes with green solvents

Dissertação para obtenção do Grau de Doutor em Química Sustentável

Caracterização de um mamógrafo Senographe 600T Senix da GE com ânodo de Mo. dosimetria das qualidades de radiação

Dissertação para obtenção do Grau de Mestre em Engenharia Biomédica

Alternative solvents in separation processes

Dissertation presented to obtain the Ph.D degree in Sustainable Chemistry

Triple Regimen with Rituximab, Plasmapheresis and Intravenous Immunoglobulin in the Treatment of Dialysis Dependent Acute Humoral-Mediated Rejection in Kidney Grafts

Introduction: The clinical importance of humoral-mediated acute rejection has been progressively recognised. Early recognition and treatment with plasmapheresis and intravenous immunoglobulin have recently improved short term prognosis. Case report: In this report we describe the clinical features of three 2nd transplant patients developing severe acute humoral rejection during the first week post-transplant while on anti-thymocyte globulin therapy. Treatment with plasmapheresis/ intravenous immunoglobulin/rituximab resulted in rapid reversal of oliguria,and recovery of renal function within the 1st week of treatment in 2/3 patients. Diagnosis was confirmed by graft biopsies revealing peritubular neutrophiles and C4d deposits. Sequential graft biopsies in all three patients revealed complete histological recovery within two weeks. One patient never recovered renal function, and one patient lost his graft at three months following hemorrhagic shock. After 2 years follow up, the remaining patient maintains a serum creatinine of 1.1mg/dl. Conclusion: The regimen using plasmapheresis plus intravenous immunoglobulin and rituximab was effective in rapidly reversing severe acute humoral rejection.

Differences in Nevirapine Biotransformation as a Factor for its Sex-Dependent Dimorphic Profile of Adverse Drug Reactions

OBJECTIVES: Nevirapine is widely used for the treatment of HIV-1 infection; however, its chronic use has been associated with severe liver and skin toxicity. Women are at increased risk for these toxic events, but the reasons for the sex-related differences are unclear. Disparities in the biotransformation of nevirapine and the generation of toxic metabolites between men and women might be the underlying cause. The present work aimed to explore sex differences in nevirapine biotransformation as a potential factor in nevirapine-induced toxicity. METHODS: All included subjects were adults who had been receiving 400 mg of nevirapine once daily for at least 1 month. Blood samples were collected and the levels of nevirapine and its phase I metabolites were quantified by HPLC. Anthropometric and clinical data, and nevirapine metabolite profiles, were assessed for sex-related differences. RESULTS: A total of 52 patients were included (63% were men). Body weight was lower in women (P = 0.028) and female sex was associated with higher alkaline phosphatase (P = 0.036) and lactate dehydrogenase (P = 0.037) levels. The plasma concentrations of nevirapine (P = 0.030) and the metabolite 3-hydroxy-nevirapine (P = 0.035), as well as the proportions of the metabolites 12-hydroxy-nevirapine (P = 0.037) and 3-hydroxy-nevirapine (P = 0.001), were higher in women, when adjusted for body weight. CONCLUSIONS: There was a sex-dependent variation in nevirapine biotransformation, particularly in the generation of the 12-hydroxy-nevirapine and 3-hydroxy-nevirapine metabolites. These data are consistent with the sex-dependent formation of toxic reactive metabolites, which may contribute to the sex-dependent dimorphic profile of nevirapine toxicity.

Gestão de infra-estruturas e avaliação de equipamentos laboratoriais

RESUMO: A confiabilidade e qualidade dos resultados clínicos de um laboratório, estão dependentes da qualidade do equipamento onde estes são processados. A qualidade de um equipamento consiste em apresentar resultados com uma confiabilidade metrológica de acordo com os processos de medição realizados. Desta forma, os equipamentos de medição devem conter características metrológicas de acordo com os requisitos dos processos que estão inseridos, tais como: erro máximo, incerteza, resolução… Todos os equipamentos por muito bons que sejam, apresentam perdas das suas características metrológicas ao longo do tempo, o que se torna importante a determinação periódica das suas calibrações, manutenções e o seu respectivo ajuste. A periodicidade das calibrações, devem ser baseadas, em critérios bem estabelecidos de modo a evitar a ocorrência da não conformidade, devido às medições com os equipamentos fora das suas especificações, garantindo-se assim, a confiabilidade metrológica e o aumento da produtividade devido ao controlo dos processos, evitando-se desta forma qualquer tipo de avaria por parte destes. Os normativos de Qualidade e Certificação estabelecem como requisito a calibração dos equipamentos de medição em intervalos adequados, mas não definem claramente qual o intervalo adequado. O importante é gerir as etapas de calibração e manutenção de acordo com os equipamentos de modo a garantir que os resultados emitidos por estes sejam mantidos em condições confiáveis, dentro do período entre calibrações e manutenções, de modo a que nãoocorra uma condição de falha, e por conseguinte, medições com grande quantidade de erros.------------ ABSTRACT: The reliability and quality of the results of a clinical laboratory, are dependent on the quality of the equipment where they are processed. The quality of a product is to present results with a metrological reliability according to the measuring processes carried out. Thus, measuring equipment must contain metrological characteristics according to the requirements of the processes that are included, such as: maximum error, uncertainty, resolution ... All equipment for very good they are, show losses of its metrological characteristics over time, it becomes important to determine its periodic calibrations, maintenance and its adjustment. The frequency of calibrations should be based on well-established criteria in order to avoid the occurrence of non-compliance due to the measurements with the equipment beyond its specifications, thus ensuring the metrological reliability and increased productivity due to the control of processes, thus avoiding any kind of damage on the part thereof. The normative and Quality Certification as a requirement to establish calibration of measuring equipment at appropriate intervals, but not clearly stipulate the proper range. It is important to manage the steps of calibration and maintenance equipment according to ensure that the results emitted by these conditions are maintained in trusted within the period between calibrations and maintenance, sothat there occurs a fault condition, and therefore, large amount of measurements with errors.

Financial crisis spillovers to the corporate sector: Bank-dependent borrowers versus bond market paticipants

A Work Project, presented as part of the requirements for the Award of a Masters Degree in Finance from the NOVA – School of Business and Economics

T cell-dependent immunodepression in vivo in Schistosoma mansoni infected patients

T-cell function was evaluated in 29 patients with either hepatointestinal or hepatosplenic schistosomiasis by intradermal tests to recall antigens. Immunodepression was detected in 26% of the subjects with hepatointestinal schistosomiasis and in 50% of those with the hepatosplenic form. Cellular immunodepression was related to worm load and spleen size. This non specific T-cell immunodepression may represent a serious constraint to the elimination of intracellular pathogens both in hepatosplenic or hepatointestinal schistosomiasis.

Procurement strategies in the health sector: How advanced are procurement processes in Portuguese hospitals

A Work Project, presented as part of the requirements for the Award of a Masters Degree in Management from the NOVA – School of Business and Economics

Cell division and chromosome segregation in Staphylococcus aureus

Dissertação para a obtenção do grau de doutor em Biologia pelo Instituto de Tecnologia Química e Biológica. Universidade Nova de Lisboa

Enhancing physical activity coaching through personalized motivational strategies and self-adaptive goal-setting: development of self-adaptive processes in a monitoring and coaching smartphone application

Dissertação para obtenção do Grau de Mestre em Engenharia Biomédica