João Raposo Email and Phone Number

Human Resources Project - Data Modeling Meetings with the client to assess the needs of the businessFinding the tables to import from SAPDevelopment of data models according to business needs using star schema.Development of SQL scripts (in SQL SERVER and Databricks) with the data transformations needed for the model.Development of simple PowerBI reports to ensure data consistency.

Health Market Research Project - Data AnalysisDevelopment of tailored projects using KNIME and Python for Data MiningUse of Excel to manipulate data (Xlookup, pivot tables...)

Industry project - Data engineeringUse of Azure Data Factory to create data pipelinesDevelopment of stored procedures in SSMS to implementnew measures for analytical reports.

-Citotoxic prescription validation;-Development of dozens chemotherapy protocols, in most areas of oncology-Backup Pharmacist for 15 clinical trials;-Development of internal procedures for 10 clinical trials;-Development of internal procedure relative to the stability of multi-dose packages (ointments, creams, gels, disinfectants, anti-spetics…).-Pharmacist in charge of the controlled substances (i.e.:narcotics).

-Responsible for the controlled substances-Drug purchasing and stock management;-Preparation of daily dose for hospital patients.

Attended Faculdade de Farmácia da Universidade de Lisboa (Faculty of Pharmaceutical Sciences) and collaborated with the Pharmacology & Translational Research Group

Attended an internship at IPO Lisboa as part of my course's curriculum. The hospital as various services related to the pharmaceutical area, including: - Dispensation of medicines to ambulatory patients;- Non sterile product compounding laboratory;- Cytostatic drug preparation unit;- P&T committee;

I was a trainee for 4 months in Imperial Pharmacy as part of my course curriculum.