Portuguese Tax Authority (TA) - Tax Inspection Planning and Control Department:
Took part in a software development project for organized fraud schemes detection.
Portuguese Tax Authority (AT) - Risk Management Department:
Construction of risk models for tax non-compliance detection, namely in the areas of local accommodation and VAT refunds.
Collaborates in all stages of the projects, from the planning, extraction, cleaning, and processing of the data from Oracle databases, to the development of the risk models.
North Region Health Administration (NRHA) - Studies and Planning Department:
Took part in the development of a Bussiness Intelligence solution to monitor hospital emergencies admissions, hospitalizations (GDH), specialty and surgery waiting list, of all the Northern Region hospitals.
Took part in the Development of ARSN's Business Intelligence tool - ARS Information System (SIARS), to support the activities of Primary Health Care.
This BI solution uses, at the database level, ORACLE technology, and Microstrategy technology in the reporting area. Has collaborated in all phases of the project since the dimensional design and ETL definition. Has carried out an exhaustive quality control, validating the information contained in SIARS against the extracted from the transactional systems.
In 2009, this tool was extended to users of Northern Region Primary Health Care, being responsible for all the development of the reporting area for this profile, which corresponds to more than sixty users and more than a hundred reports and dashboards.
Provided annually training in the Business Intelligence platform, SIARS, to the
new users (Directors, Coordinators of the Board and Management Units Technicians) due to the
vast knowledge of the application.
The success of this project led to its implementation at national level.
Has developed studies of hospital morbidity, working the information contained in databases of
Diagnoses Related Groups (DRG’s) of public hospitals in the northern region, to aid the
decision of strategic planning, including:
- Support for regional health programs
- Implementation of coronary and stroke fast-track system
- Oncology Referral Network
- Identification of the North Rehabilitation Center care profile
- Disabilities associated with diabetes
- Evolution of ambulatory surgical procedures.
- Support to the Commission for the Reduction of the rate of Caesarean sections.
Has Participated in the implementation of breast, cervical and colorectal cancer screening
programs:
- target population for screening programs
- age group selection
- forecast models to estimate costs and health needs
- study the effectiveness and efficiency of an opportunistic screening system, and compare this
with what could be achieved through an organized program. The analysis of costs, coverage
and characteristics of opportunistic screening, involves complex searches in large historical
databases.
In 2007, developed the research project "Cancer of the cervix, which screening?", In cooperation with Minho University.
This study aimed to support decisions of the North Region Oncology Screening Programs Commission, regarding the most controversial aspects of cervical cancer screenings: age limit of screened women, the interval between examinations and method used. A mathematical model was developed with the purpose of simulating the economic and health impacts of the combinations of the various screening alternatives, and a cost-benefit analysis of the solutions found was elaborated.
The data that served as the basis for the analysis were obtained from the Regional Cancer Registry of the North (RORENO) of 1999, and population data were provided by the National Statistics Institute (INE). The model involves probability functions and multi-objective optimization techniques.
In October 2008 this work was presented and published by the 16th Annual Congress of the Portuguese Statistical Society.
Collaborated with the Cancer Screening Program Coordination Team in the development of the study "Cost-effectiveness evaluation of different screening strategies for colorectal cancer over ten years."
The objective of this study was to compare four different screening strategies, using a simulation model. In this model, a hypothetical population of 100,000 inhabitants between the ages of 50 and 74, asymptomatic and with no known risk factors, would be invited to participate in a screening program for colon and rectum cancer using the annual PSOF test (immunochemical), a colonoscopy every 5 years or a colonoscopy every 10 years.
In 2008 collaborated on the project of the National Commission for the Development of
Ambulatory Surgery, being involved in the following phases:
- Construction, collection, compilation and analysis of questioners for the national survey on the
practice of outpatient surgery in NHS hospitals, including 61 hospital institutions.
- Analysis of the evolution of ambulatory surgery, using two different sources: information
provided by ACSS and information contained in SIGLIC, provided by the Central Management
Subscribers to surgery.
- Conducting statistical tests in order to verify the existence of a relationship between higher
rates of outpatient surgery and lower waiting time to complete surgery. For this, we analyzed,
for the 22 hospitals in the northern region, rates for outpatient hospital and their median waiting
times.
In the same year, has collaborated with the regional working group to implement the Integrated
Emergency Pediatric of Porto (UPIP). In this context, has participated in the design,
implementation and statistical analysis of a questionnaire to evaluate satisfaction of care of
children with acute illness and the age of 13 years.
Participated in international project "ISARE - Health Indicators for European Regions",
funded by the European Community (integrated into the Health Monitoring Programme) and
proposed by FNORS (Fédération Nationale des observatoires Régionaux de la Santé).
(Ext. )
CV Summary

Português