Scroll To View More
Cassius Mazzo Laprano

Cassius Mazzo Laprano

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.
Cassius is now available for hire
Portfolio
Experience
  • Business Intelligence (BI), 10 years
  • Dimensional Modeling, 10 years
  • MicroStrategy, 10 years
  • Data Warehouse Design, 10 years
  • Data Warehouse (DW) Requirements, 10 years
  • SQL, 7 years
  • Oracle Database, 7 years
  • PL/SQL, 7 years
Moncton, NB, Canada
Availability
Part-time
Preferred Environment
SQL Developer, SQL Power Architect, MicroStrategy
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.
Employment
  • 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: Java, PL/SQL, Business Intelligence, MicroStrategy
  • 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: C/C++, Java, Linux customization
Skills
  • Paradigms
    Dimensional Modeling
  • Other
    Business Intelligence (BI), Data Warehouse Design, MicroStrategy, Data Warehouse (DW) Requirements
  • Languages
    SQL, Java
  • Platforms
    Oracle Database
  • Storage
    PL/SQL, Multi-dimensional Databases, Teradata
Education
  • Master's degree in Telecommunications and Computer Network Engineering
    2005 - 2007
    Federal University of Ceará - Fortaleza, Ceará, Brazil
  • Bachelor's degree in Electrical Engineering (Specialization: Industrial Computer Information Science Engineering)
    1997 - 2002
    Federal University of Ceará - Fortaleza, Ceará, Brazil
I really like this profile
Share it with others