Rodrigo D.
Data Analyst

Skills

Airflow

Google Analytics

Google Bigquery

Databricks

Oracle Database

Microsoft Azure

Amazon Aws

Google Cloud

Rodrigo is available for hire

Hire Rodrigo D.

All Howdy Candidates are vetted for skills and english proficiency.

Bio

A seasoned technology professional with 23 years of experience in the tech industry, concentrated over the past 18 years in Business Intelligence (BI) and Data Analytics. Specializes in architecting BI projects, data engineering, and transactional projects with a proficiency in multidimensional modeling including Stage Area, Operational Data Store (ODS), and Data Warehousing (DW) frameworks. Experienced in utilizing tools such as Sybase Power Designer and Oracle Data Modeler. Demonstrates expertise in managing and maintaining both Azure and AWS cloud environments, along with advanced abilities in Microsoft Azure technologies, including Power BI (Pro, Premium, Embedded), Data Factory, Databricks, virtual machines (VMs), Azure Monitor, Azure Machine Learning, SQL Server Azure, Azure DevOps, DataLake, and DeltaLake creation. Shows proficiency in Google Cloud Platform (GCP) technologies such as BigQuery, Airflow (Composer), Looker, Compute Engine VMs, Cloud Run, Data Storage, and Python. Adept in AWS services including Airflow, IAM, Glue Pipeline, CodeCommit, S3 Buckets, Kubernetes, CloudWatch, and Python. Additionally, possesses substantial knowledge in Oracle technologies including Oracle Data Integrator (ODI), Oracle Business Intelligence Enterprise Edition (OBIEE), Oracle Transactional Business Intelligence (OTBI), Oracle Application Express (APEX), and Oracle Cloud Enterprise Resource Planning (ERP).

Business Intelligence/Analytics Analyst
3/1/2020 - 6/1/2020

Developed proficiency in multidimensional and transactional modeling. Specialized in the development of high-performance data loads on the Oracle platform utilizing Oracle Data Integrator (ODI). Excelled in creating insightful dashboards, performing data analysis, and generating actionable business intelligence using MicroStrategy and Power BI.
Senior Business Intelligence Analyst
12/1/2019 - 2/1/2020

Developed expertise in multidimensional and transactional modeling. Executed high-performance data loads utilizing Microsoft SSIS, Oracle ODI, and IBM DataStage platforms. Created dashboards incorporating predictive data analysis using Microsoft PowerBI, Oracle OBIEE, and IBM Cognos.
Business Intelligence/Analytics Analyst
8/1/2021 - 4/1/2022

Developed key performance indicators (KPIs) for areas focusing on assets and government finances of Angola. Engaged in data modeling using Star Schema (STG, ODS, and DW) and transactional schemas in 3NF. Created and maintained efficient extract, transform, load (ETL) processes, ensuring optimization and performance of these load processes and data models. Demonstrated expertise in developing dashboards using OBIEE, including the creation of the semantic layer, hierarchy, and publication of the RPD. Showcased proficiency in Oracle APEX through the development of systems tailored for asset management and the financial oversight of the Angolan government.
Business Intelligence/Analytics Analyst
6/1/2020 - 11/1/2021

Migrated the entire database and dashboard tools (Spotfire and PowerBI) into the CGD's Data Warehouse. Created a normalized ODS layer and a denormalized Data Mart to receive information from corporate and personal proposals, implementing load processes in ODI and custom packages. Developed KPIs, analyses, and dashboards for all involved areas using Microstrategy.
Business Intelligence/Analytics Analyst
3/1/2016 - 2/1/2024

Defined and implemented multidimensional and transactional modeling. Developed high-performance loads using SSIS and ODI. Created dashboards with predictive data analysis in PowerBI and OBIEE. Configured and maintained Azure services, including managing Azure Data Factory, creating Windows virtual machines, administering SQL Server databases, and overseeing Integration Service load processes. Facilitated access to MySQL through Azure and automated data scheduling using the Gateway. Managed PowerBI Premium, specifically focusing on pipeline management.
Business Intelligence/Analytics Analyst
3/1/2016 - 6/1/2018

Defined BI process and architecture for multidimensional databases. Engaged in strategic meetings with business areas and specified functional and non-functional requirements. Conducted multidimensional modeling (DW) and developed technical specifications for load processes (ETL), STG, ODS, and DW. Created and managed load processes using Oracle ODI and PL/SQL, activated through Database JOBs (Exadata). Enhanced load tuning, achieving significant reduction in processing time for large data volumes.
Business Intelligence/Analytics Analyst
8/1/2015 - 3/1/2016

Served as the technical leader and architect for a business intelligence project, conducting strategic meetings and providing status updates. Specialized in multidimensional modeling for 1G (First Level), 2G (Second Level), and CR (Recourse College) processes. Prepared technical specifications for ETL load processes, Stage (STG), Operational Data Store (ODS), and Data Warehouse (DW). Provided detailed specifications for creating dashboards for the Supply Secretary (SAB) and Budget and Finance Secretary (SOF). Automated data import processes using Oracle APEX technology for the Budget and Finance Secretary. Conducted a platform migration from Oracle to Microsoft databases.
Business Intelligence/Analytics Analyst
12/1/2013 - 7/1/2015

Led a team of six BI professionals in architecting transactional and BI systems for a governmental institution. Demonstrated expertise in multidimensional modeling and provided technical specifications for ETL processes, as well as STG, ODS, and DW layers, specifically focusing on urban mobility BI. Utilized Oracle ODI to create data loads from diverse sources and developed sophisticated analyses and panels using Oracle OBIEE. This included defining the semantic layer, establishing parent-child hierarchies, and configuring the RPD. Specified the requirements for creating dashboards aimed at enhancing urban mobility insights and ensuring transparency for government operations.
Business Intelligence/Cloud Services Analyst
4/1/2013 - 11/1/2013

Configured the first Oracle Business Intelligence Cloud Service (BICS) in Brazil in collaboration with Oracle's team. Acted as the technical lead and architect for the BI project, overseeing a team of two additional resources. Developed proficiency in multidimensional star-schema modeling for Data Warehousing (DW), transactional Third Normal Form (3NF) for Operational Data Store (ODS), and definitions for Staging (STG). Provided technical definitions for Extract, Transform, Load (ETL) processes, STG, ODS, and DW. Created analyses and dashboards for management and business areas, and automated the data import process from the network to the cloud.
Business Intelligence/ETL Analyst
2/1/2012 - 4/1/2013

Migrated over 200 ETLs from Microsoft SQL Server 2000 (DTS) to Microsoft SQL Server 2008 (SSIS). Created 50 load processes in Microsoft SQL Server 2008 (SSIS), incorporating and defining rules for load processes using SAP ERP as the source. Engaged in multidimensional modeling to address business area demands, while defining strategic indicators in collaboration with the business area.