Cassius Mazzo Laprano
SQL Developer in Moncton, NB, Canada
Member since September 3, 2016
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.
Systems Analyst2005 - PRESENTFederal Service of Data Processing (SERPRO)
Technologies: Java, PL/SQL, Business Intelligence, MicroStrategy
- 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 Engineer2002 - 2005Atlantic Institute
Technologies: C/C++, Java, Linux customization
- 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.
OtherData Warehouse Design, Business Intelligence (BI), MicroStrategy, Data Warehouse (DW) Requirements
StorageMulti-dimensional Databases, PL/SQL, Teradata
- Master's degree in Telecommunications and Computer Network Engineering2005 - 2007Federal University of Ceará - Fortaleza, Ceará, Brazil
- Bachelor's degree in Electrical Engineering (Specialization: Industrial Computer Information Science Engineering)1997 - 2002Federal University of Ceará - Fortaleza, Ceará, Brazil