Iluminare

Portfolio

What we've built for our clients.

24+ years of data and software projects across Europe and Brazil — for banks, enterprises and public institutions. Here's what was done in each.

Database · BPO Process
FIOCRUZ — Fundação Oswaldo Cruz
  • Administration of 1,100 database projects.
  • Installation, configuration and support for SQL Server, PostgreSQL, MySQL, MariaDB, Oracle and MongoDB.
  • Created a process to organize databases and improve working practices.
ETL · Development · BI · DW
Banco do Brasil
  • Created new statistical charts and graphs for reports reviewed by the CEO.
  • Mediated meetings between IT and the insurance company's CEO to develop data structures.
  • Analyzed the insurance market.
ETL · Integration · Development · BI · DW
Bradesco
  • Created and developed a control system (PHP, HTML, CSS, JavaScript, jQuery).
  • Developed the whole BI system from the ground up (SSIS, Informatica, Excel, T-SQL, PL-SQL, stored procedures).
  • Identified gaps and issues in existing jobs/workflows and proposed solid solutions.
  • Designed data modeling for better performance (transactional / dimensional).
  • Developed a large-scale DWH project (200 tables).
ETL · Integration
Susquehanna
  • Developed and coordinated ETL projects for a better financial point of view.
  • Modeled end-to-end workflows meeting data management requirements.
  • Normalized all types of data source structures for easier consumption.
  • Production support against critical issues.
ETL · Integration
Mastercard
  • Migration of the integration system from Informatica PowerCenter to SSIS.
  • Engineered end-to-end structures from business strategy to technical execution.
  • Translated complex business requirements into computational tasks.
Database · Data Model
Grupo Brisa
  • Re-modeling of system and database structures to improve performance.
  • Analysis and improvement of queries for performance.
  • Creation of tests of data structures.
BI · DW
TAP Air Portugal
  • Support team for BI structures.
  • Analysis and correction of SSIS packages.
  • Analysis of DW databases and data loads.
Database
BNP Paribas
  • SQL Server and Oracle.
  • Administration, analysis, performance and T-SQL.
  • Installation and configuration.
  • Report Server and SSIS.
  • Clustering, Mirror and Always-On.
  • Backup, PowerShell and Shell scripts.
Database
VIASOFT
  • Oracle Exadata consulting.
  • Analyzed system structure and correlated parameters.
  • Cost-reduction project (~1M/year saved).
  • Identified KPIs to optimize onboarding and performance.
  • Trained the sales team for assertive, client-specific selling.
BI · DW
RSM
  • Requirements gathering.
  • Analysis of structure.
  • Development and design of BI dashboards.
Start a conversation →