Power Bi Data Quality

Ricardo Teixeira **********@*****.*** • +351-*********

Head of Data Analytics Profile Personal Details: LinkedIn

Funchal, Portugal 1971-10-17

Experienced professional with track record of driving data-driven strategies and leading crossfunctional teams to enhance business performance. Excel in implementing advanced analytics solutions, including ETL pipelines, data warehousing, and dashboard reporting tools, such as Power BI and AI. Capable of managing large-scale data projects, leveraging cloud platforms like Azure, and integrating diverse data sources to deliver actionable insights. Adept at mentoring teams, streamlining processes, and fostering collaboration across departments. Demonstrated success in improving data quality, optimising performance, and automating complex data workflows, resulting in enhanced decision-making, operational efficiency, and cost savings.

Areas of Expertise

Team Training & Leadership Data Quality Management Strategic Planning & Execution Dashboard Development Agile Methodologies Compliance Tracking Report Automation Data Warehousing Data Analysis Customer Relationship Management Cross-functional Collaboration Financial Data Reconciliation Data scientist

Professional Experience

Public Administration, Funchal, Portugal

Technical Lead – BI, DWH & AI Project

2025 – Present

•Technical coordination of the Artificial Intelligence (AI), Data Warehouse (DWH), and Business Intelligence (BI) Project. Promoted the requirements survey and respective data model, and elaborated the details of use cases with stakeholders.

•Design of the AI/DWH/BI project architecture, study of technological solutions.

•Proposal of AGIL methodology for coordinating the team's work.

ICON PLC/PRA Health Sciences, Mannheim, Germany

Senior Pharmacovigilance Systems Manager (Data Analyst)

2021 – 2024

•Led rollout of Spotfire Server reports and developed detailed signal detection and data analysis reports for over 10 projects; expedited delivery to Safety Scientists by two weeks through use of Agile methodologies.

•Designed and managed technical implementation of FAERs WhoDrugs and MedDRA data warehouse in Oracle with Data Vault approach; automated database updates, decreasing error rate by 15% and enhancing ingestion speed by 40%.

•Developed extensive Power BI dashboards to track data quality and compliance; provided real-time insights to facilitate prompt corrective actions and cut manual reporting time by 80%.

OMV, Vienna, Austria

Expert Data Engineer 2019 – 2021

•Provided mentorship to junior engineer at OMV on database management, and trained colleague in SQL Server, Visual Studio for database development, and SSIS, leading to 80% improvement in deployment performance.

•Designed and implemented T-SQL database solution for sales data analysis, integrating SSIS and Python scripts to automate REST API data retrieval, resulting in 25% improvement in data accuracy.

•Led Data Lake Azure proof-of-concept project, executing ingestion pipelines using Azure Data Factory, resulting in improved data management capabilities and reduced processing time by 10%.

•Created and deployed Power BI and SSRS reports to integrate data from five distinct databases into consolidated data mart; improved reporting speed by 50% and enabled daily sales analysis.

Global Blue - Tax Refund, Vienna, Austria

Data Engineer - Senior Developer 2018 – 2019

•Designed and implemented ETL (Extract, Transform, Load) pipelines to integrate various data sources and ensure accurate data flow. Created and optimised database schemas to support complex queries and data storage requirements, ensuring data integrity and performance.

•Transformed ETL batch processing for financial data reconciliation, processing 2M rows per day into data warehouse; enhanced performance by 13 times through implementation of multi-threaded calculations. .

PDS - Petrotechnical Data Systems, Rijswijk, Netherlands

BI - Data Analytics Specialist 2015-2018

•Conceived a robust cloud-based database for Oil & Gas analytic s on Production Enterprise, adhering to Seabed Open Data Model, and delivered a fully functional application with CI/CD, reducing the deployment time by 40%.

•Consolidated KPIs and statistics analysis over the well drill process. It provide information on Spotfire and power BI reports, reducing the reporting time more than 30%.

Madeira Public Administration, Madeira, Portugal

Exploration Division Team lead 2014 – 2015

•Executed ITIL and documentation management processes for maintenance team, resulting in 20% reduction in support time.

•Designed and deployed multidimensional CUBE-based dashboard to monitor data quality and KPIs, cutting time required to generate monthly reports by 50%.

•Secured funding for certified internal IT training team, enhancing IT skills for over 60 end users and 12 IT technicians.

Madeira Public Administration, Madeira, Portugal

IT Engineer, 2012-2014

•To promote data accessibility was introduce one data warehouse in the machinery maintenance, the data driven decisions on machinery maintenance improve more than 50%.

•Orchestrated a comprehensive evaluation of the entire Geo-reference data infrastructure for Madeira Public Administration, resulting in the transformation of the Georeferenced database into a regional benchmark in IT process documentation.

Madeira Public Administration (SREC), Madeira, Portugal

Software Production Team Lead, 2008-2012

•Empowered team members by delegating according each individual strength, facilitating coaching sessions and monitoring process and provide feedback, improving team performance by 45%, boosting IT service quality perceived by the users.

IGA – Institute of Water Management, Madeira, Portugal

IT Engineer, 1996-2008

•A small company IT department on hands management and team coordination, allow to archive a functional Datacenter wit IT services to support IT infrastructure and users support

a small company that grows more 10+ times during that period.

Aditional Experience

Universidade da Madeira, Madeira, Portugal

Invited external professor assistant, 1996-2013

• Conducted comprehensive classes: Automation and control, Introduction to computation, Electric Installations, Instrumentation and Measures, Digital systems, …, including academic Final Project Orientation on engineering courses.

Freelance, Madeira, Portugal

2007- Specialized training in data analysis, statistical analysis

2007 - Reverse engineering of "database" and reporting the regional database of water quality,. for the Regional Environmental (DRAmb)

2005 - Training in data analysis company “SOSAmbiente”.

Education & Certifications

•Post-graduation on Leadership and Team Management, University NOVA School of Business and Economics, Executive Education, Lisbon, 2025

•Data Scientist Certification, University La Sorbonne/DataScientest, DST Germany GmbH,

2024, Project: Convolutional Neural Network to classify lung illnesses using X-ray images

•Master in Telecommunications & Energy Networks Engineering, University of Madeira, 2012, Project in data analysis of weather sensors Degree in Electronics & Computer Engineering,

•University of Porto (FEUP), Electronics and computer engineering, Specialization in Automation, Control & Instrumentation, 1995

Languages

Portuguese – Native

English – Proficional

French – Basic

Technical Proficiencies

SQL Server Full Stack (SSAS/SSIS/SSRS) (19 years) Oracle PL/SQL (5 years) Data Warehouse

& ETL/ELT Pipes (7 years) Data Reconciliation (3 years) AGILE/Scrum (4 years) Jupiter

Notebooks, Python (2 years) Excel (20 years) GitHub (3 years) ERWIN Data Models (3 years)

Visual tools (Tableau, Qlik Sense, Spotfire) (3 years) Power BI, DAX, MDX (11 years), ERP Baan

Contact this candidate