Cassius Mazzo Laprano, Developer in Moncton, NB, Canada
Cassius is available for hire
Hire Cassius

Cassius Mazzo Laprano

Verified Expert  in Engineering

Data Warehousing Developer

Location
Moncton, NB, Canada
Toptal Member Since
June 18, 2020

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.

Availability

Part-time

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

2005 - PRESENT
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.
Technologies: MicroStrategy, Business, PL/SQL, Java

Electronic Engineer

2002 - 2005
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.
Technologies: Linux, Java, C, C++

The Law of Fiscal Responsibility (LRF)

This is an example of a document created by me for the Brazilian government requiring complex formatting rules defined by several laws in the National Treasure DW.

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

I created a document for the Federal Service of Data Processing, SERPRO in Portuguese, to generate a cash flow document in the National Treasure DW for the board of directors.

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

I created a dashboard created by me for the Federal Service of Data Processing (SERPRO) to show financial information.

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 project shows the steps executed daily before the start of the ETL process of the Federal Service of Data Processing Financial DW.

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

This project shows the procedures executed daily in the ETL process of the Federal Service of Data Processing Financial DW. This part of the process is responsible for updating the database using the files extracted from several OLTP systems.

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.

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

2005 - 2007

Master's Degree in Telecommunications and Computer Network Engineering

Federal University of Ceará - Fortaleza, Ceará, Brazil

1997 - 2002

Bachelor's Degree in Electrical Engineering (Specialization: Industrial Computer Information Science Engineering)

Federal University of Ceará - Fortaleza, Ceará, Brazil

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring