Analysis of a controversial decision process: the case of the pumped hydro storage power plant Atdorf in Germany

Based on the report for the unit “Métodos Interactivos de Participação e Decisão A” (Interactive methods of participation and decision A), coordinated by Prof. Lia Maldonado Teles de Vasconcelos and Prof. Nuno Miguel Ribeiro Videira Costa. This unit was provided for the PhD Program in Technology Assessment in 2015/2016.

Consulting project for the marketing oil department of Galp Energia evaluation of marketing campaigns

Field lab: Consulting lab

NSP work project investment styles

This paper analyzes the Nova Student Portfolio (NSP) with the objective to understand performances of the fund. Each investment style has been analyzed (growth, value and momentum) in order to highlight what style allocation contributed positively and which had a negative impact. The results show that the team mainly invested in value stocks, which contributed positively but that its growth investments had a negative impact on the stock picking performance. The stock selection shows a major influence of the value investment style. A statistical approach shows that the market factor was the one explaining the most the NSP returns.

Economics consulting project for the Iberian Marketing Oil department of Galp Energia: Strategy and Marketing guidelines for Galp Energia’sconvenience business in the Iberian market

Field lab: Consulting lab

Consulting project for the Iberian marketing Oil department of Galp Energia: Strategy and marketing guidelines for Galp Energia's convenience business in the Iberian market

Field lab: Consulting lab

Consulting project for Câmara Municipal de Cascais street vending in Portugal- creation and development of a new sales channel

Field lab: Consulting lab

An essay on agile project management practices

The main goals for the current dissertation is to research on how practices and concepts from Agile Project Management can be applied in a non-IT context and to discover which aspects should be considered when deciding if whether an Agile approach should be implemented or not. Previous studies reflect on the adoption for the identified context. However, the recognition of these practices and concepts by the Project Management field of studies still remains unresolved. The adoption of Agile Project Management emerges as a manifestation against traditional approaches, mainly due to their inability of accepting requirements’ changes. Therefore, these practices and concepts can be considered in order to reduce the risks concerning the increase of competition and innovation – which does not apply to the IT sector solely. The current study reviews the literature on Agile Project Management and its adoption across different sectors in order to assess which practices and concepts can be applied on a non-IT context. Nine different methods are reviewed, where two of these show a higher relevance – Scrum and Extreme Programming. The identified practices and concepts can be separated into four different groups: Cultural and Organizational Structures, Process, Practices, and Artefacts. A framework based on the work by Boehm & Turner in 2004 is developed in order to support the decision of adopting agile methods. A survey intended for project managers was carried in order to assess the implementation of the identified practices and concepts and to evaluate which variables have the highest importance on the developed decision support framework. It is concluded that New Product Development is the project type with the highest potential to implement an agile approach and that the Project Final Product’s Innovativeness, Competitiveness, and the Project Member’s Experience and Autonomy are the most important aspects to consider an implementation of an Agile approach.

Scaling In-Memory databases on multicores

Current computer systems have evolved from featuring only a single processing unit and limited RAM, in the order of kilobytes or few megabytes, to include several multicore processors, o↵ering in the order of several tens of concurrent execution contexts, and have main memory in the order of several tens to hundreds of gigabytes. This allows to keep all data of many applications in the main memory, leading to the development of inmemory databases. Compared to disk-backed databases, in-memory databases (IMDBs) are expected to provide better performance by incurring in less I/O overhead. In this dissertation, we present a scalability study of two general purpose IMDBs on multicore systems. The results show that current general purpose IMDBs do not scale on multicores, due to contention among threads running concurrent transactions. In this work, we explore di↵erent direction to overcome the scalability issues of IMDBs in multicores, while enforcing strong isolation semantics. First, we present a solution that requires no modification to either database systems or to the applications, called MacroDB. MacroDB replicates the database among several engines, using a master-slave replication scheme, where update transactions execute on the master, while read-only transactions execute on slaves. This reduces contention, allowing MacroDB to o↵er scalable performance under read-only workloads, while updateintensive workloads su↵er from performance loss, when compared to the standalone engine. Second, we delve into the database engine and identify the concurrency control mechanism used by the storage sub-component as a scalability bottleneck. We then propose a new locking scheme that allows the removal of such mechanisms from the storage sub-component. This modification o↵ers performance improvement under all workloads, when compared to the standalone engine, while scalability is limited to read-only workloads. Next we addressed the scalability limitations for update-intensive workloads, and propose the reduction of locking granularity from the table level to the attribute level. This further improved performance for intensive and moderate update workloads, at a slight cost for read-only workloads. Scalability is limited to intensive-read and read-only workloads. Finally, we investigate the impact applications have on the performance of database systems, by studying how operation order inside transactions influences the database performance. We then propose a Read before Write (RbW) interaction pattern, under which transaction perform all read operations before executing write operations. The RbW pattern allowed TPC-C to achieve scalable performance on our modified engine for all workloads. Additionally, the RbW pattern allowed our modified engine to achieve scalable performance on multicores, almost up to the total number of cores, while enforcing strong isolation.

On project finance and the first road concession in Portugal

In broad sense, Project Financing1 as a mean of financing large scale infrastructural projects worldwide has had a steady growth in popularity for the last 20 years. This growth has been relatively unscathed from most economic cycles. However in the wake of the 2007 systemic Financial Crisis, Project Financing was also in trouble. The liquidity freeze and credit crunch that ensued affected all parties involved. Traditional Lenders, of this type of financial instrument, locked-in long-term contractual obligations, were severely hit with scarcity of funding compounded by rapidly increasing cost of funding. All the while, Banks were “rescued” by the concerted actions of Central Banks and other Multi-Lateral Agencies around the world but at the same time “stressed” by upcoming regulatory effort (Basel Committee). This impact resulted in specific changes to this type of long-term financing. Changes such as Commercial Banks’ increased risk aversion; pricing increase and maturities decrease of credit facilities; enforcement of Market Disruption Event clauses; partial responsibility for project risk by Multilateral Agencies; and adoption of utility-like availability payments in other industrial sectors such as transportation and even social infrastructure. To the extent possible, this report is then divided in three parts. First, it begins with a more instructional part, touching academic literature (theory) and giving the Banks perspective (practice), but mostly as an overview of Project Finance for awareness’ sake. The renowned Harvard Business School professor – Benjamin Esty, states2 that Project Finance is a “relatively unexplored territory for both empirical and theoretical research” which means that academic research efforts are lagging the practice of Project Finance. Second, the report presents a practical case regarding the first Road Concession in Portugal in 1998 ending with the lessons learned 10 years after Financial Close. Lastly, the report concludes with the analysis of the current trends and changes to the industry post Financial Crisis of the late 2000’s. To achieve this I’ll reference relevant papers, books on the subject, online articles and my own experience in the Project Finance Department at a major Portuguese Investment Bank. Regarding the latter, with the signing of a confidentiality agreement, I’m duly omitting sensitive and proprietary bank information.

Valuing an offshore exploration project through real options analysis

This thesis applied real options analysis to the valuation of an offshore oil exploration project, taking into consideration the several options typically faced by the management team of these projects. The real options process is developed under technical and price uncertainties, where it is considered that the mean reversion stochastic process is more adequate to describe the movement of oil price throught time. The valuation is realized to two case scenarios, being the first a simplified approach to develop the intuition of the used concepts, and the later a more complete cases that is resolved using both the binomial and trinomial processes to describe oil price movement. Real options methodology demonstrated to be capable of assessing and valuing the projects options, and of overcoming common capital budgeting methodologies flexibility limitation. The added value of the application of real options is evident, but so is the method's increased complexity, which adversely influence its widespread implementation.

Should my company use Bitcoin?

This work project analyses the possibility for a company to trade their goods and services for bitcoins, by joining the Bitcoin network. It analyses the technological and business requirements to join the Bitcoin Network by looking at Bitcoin’s potential to act as a mean of exchange for trade, unit of account and store of value. The analysis points to the motives, benefits and risks for investors to use the Bitcoin as a traditional currency and recommends on strategies for addressing those risks and maximizing benefits. Other than companies this report, to a lesser extent, will also analyse the Bitcoin from an investor’s point of view, this is, should an investor buy bitcoins for trade and make savings on a regular and everyday basis? A major finding in this work project is that companies could start using the Bitcoin system as a legit form of payment since the benefits of using this technology outweigh the costs and risks, given the right approach. This form of payment will contribute for the upgrade of a company’s business’ image, attract a new pool of consumers and businesses that already trade in bitcoins and pressure existing financial institutions and electronic payment vendors to upgrade their service levels.

Finding the hidden influencers

This thesis is a first step in the search for the characteristics of funders, and the underlying motivation that drives them to participate in crowdfunding. The purpose of the study is to identify demographics and psychographics that influence a funder’s willingness to financially support a crowdfunding project (WFS). Crowdfunding, crowdsourcing and donation literature are combined to create a conceptual model in which age, gender, altruism and income, together with several control variables, are expected to have an influence on a funder’s WFS. Primary data collection was conducted using a survey, and a dataset of 175 potential crowdfunders was created. The data is analysed using a multiple regression and provided several interesting results. First of all, age and gender have a significant effect on WFS, males and young adults until the age of 30 have a higher intention to give money to crowdfunding projects. Second, altruism is significantly positively related to WFS, meaning that the funders do not just care about the potential rewards they could receive, but also about the benefits that they create for the entrepreneur and the people affected by the crowdfunding project. Third, the moderation effect of income was found to be insignificant in this model. It shows that income does not affect the strength of the relationship between the age, gender and altruism, and WFS. This study provides important theoretical contributions by, to the best of my knowledge, being the first study to quantitatively investigate the characteristics of funders and using the funder as the unit of analysis. Moreover, the study provides important insights for entrepreneurs who wish to target the crowd better in order to attract and retain more funders, thereby increasing the chance of success of their project.