Cassius Mazzo Laprano
Verified Expert in Engineering
Data Warehousing Developer
Cassius worked for three years at the Atlantic Institute developing embedded applications in C/C++ for Point-of-Sale equipment and Java for Brazilian Digital TV. Since 2005, he's worked in the Federal Service of Data Processing, defining and developing business intelligence applications for the Brazilian government from the requirements elicitation process to the implementation of the reports, documents, and dashboards.
Portfolio
Experience
Availability
Preferred Environment
MicroStrategy, SQL
The most amazing...
...project I've built is the National Treasure Data Warehouse, with more than 450 tables updated and more than 15,000 reports executed every day.
Work Experience
Systems Analyst
Federal Service of Data Processing (SERPRO)
- Utilized SQL to create Oracle dimensional databases.
- Employed PL/SQL to create the Oracle load routines of the extraction, transformation and load (ETL) process.
- Programmed in Java to control the daily ETL workflow.
- Gathered requirements for business intelligence projects, definition, and documentation of ETL business rules.
- Defined, documented, and constructed dimensional and database models.
- Built specifications and developed OLAP projects with MicroStrategy.
- Implemented reports, documents, and dashboards with MicroStrategy.
- Utilized SQL to create Teradata dimensional databases.
- Developed basic PL/SQL code to create Teradata routines for the ETL process.
- Optimized Teradata databases.
Electronic Engineer
Atlantic Institute
- Utilized C/C++ for point of sales equipment.
- Customized a Linux distribution for routers.
- Created automatic position and connection software with Java using distance algorithms.
- Embedded Java for Brazilian TV Set-top boxes.
Experience
The Law of Fiscal Responsibility (LRF)
The law of fiscal responsibility, or LRF in Portuguese, is one of the modules of the National Treasure DW and is among the most important laws of Brazil.
Because of its rigid format, the report's information used by this document was generated by data mart reports using several filter rules, as shown by the custom group image on the right. This is just a small part of the necessary information required. All the documents use the same concept, and the module contains hundreds of reports, filters, and custom groups.
In the top-left corner is an example of the filled document presented to the user after the execution, and in the bottom-left corner is the design mode of the same document, showing some of the reports and metrics necessary to generate the desired information.
I was part of the team defining both dimensional and database models, creating the Teradata database and the MicroStrategy OLAP project, and maintaining and evolving all the modules of this system.
Federal Service of Data Processing | Cash Flow
Because the SERPRO has to follow specific rules, this document requires several filters and custom groups to generate the desired information from the management information module. The management information module is the main module of the system, containing hundreds of thousands of reports of all entities of the federal administration.
The upper part of the image is an example of the filled document presented to the user after the execution, and the bottom part is the design mode of the same document, showing some of the reports and metrics necessary to generate the desired information.
I was part of the team that defined both dimensional and database models, creating the Teradata database and the MicroStrategy OLAP project and maintaining and evolving all the modules of this system.
Federal Service of Data Processing | Director's Dashboard
This dashboard contains all the financial information of the company since 2005 updated daily, allowing the board of directors to monitor the financial performance of the company. It is an interactive dashboard where it is possible to analyze the information over several years to forecast revenue and payment flow.
The upper left part of the image shows the annual revenue of the company, a comparison between the selected and the previous year, the growth percentage, the monthly revenue from both the selected and last year, and the distribution of the revenue by the units. The upper right part compares revenue and payment, payments past due, the percentage of payments past due, more detailed information about the costs past due, the percentage between revenue and payment, and the percentage of the previous year payments past due received. The bottom left part is the design mode of this document.
I helped define both dimensional and database models as wel as create the database and the MicroStrategy OLAP project.
Federal Service of Data Processing | Financial DW Workflow
This part of the workflow is responsible for validating all the necessary files, extracting from several OLTP systems present in the stage folder, backing them up in the history folder so the process can be re-executed if needed, executing some content validation to assure consistency of the files, and moving them to the load folder to be processed.
This part of the workflow was coded in Java, with several jar files being created to execute the whole process and its features, if necessary. A Java program was also designed to re-execute the ETL process getting the files from the historic folder allowing the re-execution of several days in a single command line.
The upper part of the image shows the TIBCO diagram of this part of the workflow, where each lane represents one folder, and each box is a part of the process used in this folder. The bottom part is a small piece of the Java code created to implement this process.
I helped define and create the TIBCO diagrams and the Java programs.
Federal Service of Data Processing | Financial DW ETL
These procedures were written in Oracle PL/SQL and contained all the load business rules necessary to provide accurate information. The files were mapped in the database using Oracle external tables, allowing easy data validation if needed. This process has been executed for several years with minimal human interference when some infrastructure problem occurs, and a manual re-execution is required and easily done with the Java programs created.
The upper part of the image shows the TIBCO diagram of the procedures dependencies and execution order, where each box represents a PL/SQL program. The bottom part is a small piece of a procedure code created to implement the load process.
I helped define and create the TIBCO diagrams and the Java programs.
Skills
Paradigms
Dimensional Modeling, Business Intelligence (BI)
Other
Data Warehouse Design, MicroStrategy, Requirements & Specifications, Data Warehousing, Business, TIBCO
Languages
SQL, C++, C, Java
Platforms
Oracle Database, Linux
Storage
Multi-dimensional Databases, PL/SQL, Teradata, Databases, Oracle PL/SQL, OLTP
Education
Master's Degree in Telecommunications and Computer Network Engineering
Federal University of Ceará - Fortaleza, Ceará, Brazil
Bachelor's Degree in Electrical Engineering (Specialization: Industrial Computer Information Science Engineering)
Federal University of Ceará - Fortaleza, Ceará, Brazil
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring