João Raposo Email & Phone Number

Porto, Portugal

Porto, Portugal

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.

Sintra, Lisbon, Portugal

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

Lisboa, Portugal

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

Algés

-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.

Lisbon Area, Portugal

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

Lisbon Area, Portugal

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;

Lisbon Area, Portugal

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

Master'S Degree, Information Management, With A Specialization In Knowledge Management And Business Intelligence

The master degree has enabled me to work with high end software for data analysis and Business Intelligence problems. Regarding.

Data Scientist With Python, Business Statistics, Https://Www.Datacamp.Com/Profile/Joaocastroraposo

Data Science career track in DataCamp: -Data manipulation with Pandas -Data Cleaning with Python: - Record linkage - Working with dates.

Advanced Course In Laboratory Animal Sciences - Accredited Felasa C Course, Laboratory Animal Sciences, Felasa C Accredited

Activities and Societies: Science, Laboratory animal sciences 80 h course that follows the recommendations of FELASA for laboratory animal.

Master'S Degree, Pharmaceutical Sciences

12Th Grade, Sciences And Technology, 82,5