Data Engineer Power Bi
Resume:
J Ricardo C Teixeira
DATA ANALIST > DATA SCIENTIST
I am passionate about data structures and simple visualization to users that engage users. I like agile/scrum as work management methodology. I'm a detail-oriented person that like the challenge of complex problems.
CONTACT
ad4007@r.postjobfree.com
www.linkedin.com
WerderStrße, 6,
68165 Mannheim, Germany
WORK EXPERIENCE
EDUCATION
University of Madeira, Master of Telecommunications and Energy Networks Engineering, concluded in December 2012
Engineering Faculty at University of Porto (FEUP, Portugal), Electrical and Computer Engineering: Automation, Control and Instrumentation concluded in September 1995
SENIOR PHARMACOVIGILANCE SYSTEMS MANAGER
ICON plc / PRA health sciences
Jul 2021 – Current Mannheim, Germany
I manage the Spotfire Server, reports deployment and security in DEV UAT and PRD with more than 100 reports and versions.
I developed reports for Signal detection & data Analysis for more than 10 projects. I implemented only the more complexes reports.
I designed and supervised technically the data warehouse implementation for FAERs WhoDrugs and MedDRA in Oracle with ingestion layer, a Data Vault to the business layer and DataMart's to the presentation layer.
Training my colleague to be my backup.
Developed and maintain Power BI dashboards for Compliance, Productivity Metrics, Aggregate KPI, Process Dashboards, Management, Data quality Monitoring, Risk Management, Safety Data.
For Power BI dashboards I have used AGILE approach and collect data from multiple data sources as ORACLE, SQL, Salesforce, Excel, SharePoint Lists, integrate them in combined metrics, and implement automatic updates in DEV and PRD with more than 30 reports and versions.
I introduce AI / python advance analytics over power BI dashboards.
I made process documentation with BPM, task scripts, and management documentation.
SKILLS
Python for AI,
SQL,
DAX,
MDX,
Microsoft SQL Server,
power BI,
Tibco Spotfire,
Jupiter notebooks,
Python scripts,
Excel,
SAP HANA DB engine,
Oracle
Analysis services,
Integration services,
Reporting Services,
GitHub,
Microsoft Visual studio (SSAS, SSIS, SSRS, SQL),
Visio Pro,
Project management
Mentoring and Coach juniors
Process BPM definition and documentation.
EXPERT DATA ENGINEER
OMV
Set 2019 – Jun 2021 Vienna, Austria
I have design and implement the T-SQL database to support sales data analysis. That includes the entire ingestion process. It uses SSIS and Python scripts to read Rest APIs. Technologies ERWIN, SSIS and T-SQL.
Developed and Implement Power BI and SSRS reports, Mentoring Power bi key users. It gets data from 5 different databases, with surrogate keys, data historization, dimensions reconciliation, and presentation layer (DataMart).
The Data Lake Azure POC project is long-term solution to support a data lake. I design and implement the ingestion pipe on Azure data factory.
Implementing Power BI reports with data transformation from OLTP to OLAP model.
PERSONAL DEVELOPMENT / INTERESTS
Statistical analysis and advance analysis techniques.
Data models.
Python for Data science.
Data visualization
Data warehouse
Data cube
Data pipes automation
DATA ENGINEER - SENIOR DEVELOPER
Global Blue -Tax refund
Jul 2018 – Ago 2019 Vienna, Austria
ETL Batch base to feed Data Warehouse, maintenance and debugging and process Design to a Big Data System (2M Rows/day, fact table 75G rows 170 columns, ingestion until 4M/h).
In this project I improve processing layer performance by a factor of 5 single thread, 13 times multithread (same Hardware). That performance was archived splitting the fact-table calculations in multiples smaller SP that work in distributed in multiple tread concurrency and with adaptive performance to react to the server capacity.
Automatic process to read 4 different databases CDC wise and reconcile data.
Reports to monitor the process of 48K rows per day in a 370M rows DB (18 months fact table).
MS Analysis with data warehouse technologies and SSIS
BI- DATA ANALYTICS SPECIALIST
PDS - Petrotechnical Data Systems
Nov 2015 - May 2018 Rijswijk, Netherland
Production Enterprise is a software platform for developing Oil- and Gas data analytics and production optimization applications. I was responsible for the database design (cloud-based). The design had to comply to an Industry Standard (Seabed Open Data Model).
I worked in a Scrum team that followed CI method using Jira and Git
Wellvantage Analytics was a project that present KPIs and statics analysis over the well drill process. It collects data from different data bases and provide information on Spotfire and power BI reports.
Created a high performance SSIS 2008 and 2014 versions for two different servers, ETL process.
Mentoring a junior IT coworker in BI analysis, SQL design and implementation.
TEAM LEADER OF EXPLORATION DIVISION
Madeira public administration
Apr 2014 - Oct 2015 Madeira, Portugal
Support team IT management project was mainly to introduce management techniques and help the development of the team. Manage the work of the team.
Implement ITIL and documenting management process for the maintenance team.
Define and implement a dashboard system in SSRS and MS Analysis Services in a multidimensional CUBE to control the data quality and KPI.
Garage management project has a dashboard implementation. The KPIs data came from a Baan ERP data base.
Define a data warehouse with SSAS CUBE based an ERP data with history in the OLAP structure.
Make all ETL processes to transform data and incrementally.
Coach a junior IT coworker in BI analysis.
IT ENGINEER
Madeira public administration
Feb 2012-Mar 2014 Madeira, Portugal
Developing database for central disk share occupation management.
Compiles normalize and geo-reference Madeira governmental data about all networks links, computers, and software to make a database and build reports to support major planning decisions.
Integrating data in SQL server with integration Server, Reporting Server and .Net technologies.
Make a salaries data warehouse with ETL process and BI as a proof-of-concept for government administration.
Analyze agile/scrum methodologies, document, plan and make a proposal to adopt these techniques across the department.
TEAM LEADER OF SOFTWARE PRODUCTION DIVISION
Madeira public administration, Department of Information Systems - Education and Culture Regional Secretary (SREC)
Nov 2008 - Feb 2012 Madeira, Portugal
Team manager
Provide an analysis and response to the external audit report on the corporate network
Technical support in the analysis of large amounts of information to financial management.
Instigation of innovative technical management teams.
IT ENGINEER
IGA – Investimentos e Gestão da Agua S.A. (Institute of Water Management)
May 1996- Nov 2008 Madeira, Portugal
Participate in SQL data definition and software requirements for a water quality database and laboratory management.
Make a software module to export data in XML format regarding water quality results.
Administration and maintenance of the database in SQL server.
Develop an ETL process do transfer data from Baan ERP to ESRI GIS Database and create the alphanumeric data model to work in GIS
Contact this candidate