Power Bi Data Quality

Ricardo Teixeira

Head of Data Analytics Profile

**********@*****.*** • +351-*********

LinkedIn • Mannheim, Germany

Personal Details:

****-**-** • Funchal • Portugal

Experienced professional with track record of driving data-driven strategies and leading cross-functional teams to enhance business performance. Excel in implementing advanced analytics solutions, including ETL pipelines, data warehousing, and dashboard reporting tools, such as Power BI. 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

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

Team Training & Leadership

Professional Experience

ICON PLC/PRA Health Sciences, Mannheim, Germany 2021 – 2024 Senior Pharmacovigilance Systems Manager (Data Analytic) 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 2019 – 2021

Expert Data Engineer

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 2016 – 2018 Data Engineer - Senior Developer

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. Madeira Public Administration, Madeira, Portugal 2014 – 2015 Team Leader of Exploration Division

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

BI - Data Analytics Specialist, PDS - Petrotechnical Data Systems Team Leader of Software Production Division, Madeira Public Administration (SREC) IT Engineer, IGA – Institute of Water Management

Invited External Professor Assistant, University of Madeira Education & Certifications

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) Specialisation in Automation, Control & Instrumentation Languages

Portuguese – Native

English – Full Professional

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)

Contact this candidate