The company is an IT Consulting firm around the world.
I contributed to two main projects:
Internal BI Team project:
Working side by side with other Business Intelligence colleagues, Functional Analysts, and other departments.
Reducing complexity and performance of SQL Queries to speed up dashboard loading.
Creating PowerBI dashboard for the Purchase Management team to get insights about purchases around the world, their status, and delays.
Improving manual tasks to fully automate them via Power Automate. RPA (Robot Process Automation) helped me to achieve this milestone.
Creating ETLs to build Dimensional Modelling in the Data Warehouse to support Back-End Dashboards.
Refactoring ETLs/ELTs pipelines to meet performance and reusability specifications using Pentaho Data Integration and SQL to extract, transform and load into the Data Warehouse.
Giving workshops to the client to give guidance on how to build PowerBI dashboards using the Self-Service Principle.
Google Internal Project: Working on a Supply chain project for Google as part of their team:
Giving insights about errors in the system through SQL.
Creating a dashboard to explore and analyze data formats in columns to help the Google team to make decisions to improve validations rules.
Developing workflow to execute SQL Script and populate temporary tables to serve dashboards.
- Pentaho Data Integration
- Power Automate