Scroll To View More
Cassius Mazzo Laprano, SQL Developer in Moncton, NB, Canada
Cassius Mazzo Laprano

SQL Developer in Moncton, NB, Canada

Member since September 3, 2016
Cassius is now available for hire
Cassius Mazzo Laprano, SQL Developer in Moncton, NB, Canada
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.
Cassius is now available for hire

Portfolio

Experience

  • Business Intelligence (BI), 10 years
  • Data Warehouse (DW) Requirements, 10 years
  • Data Warehouse Design, 10 years
  • MicroStrategy, 10 years
  • Dimensional Modeling, 10 years
  • PL/SQL, 7 years
  • SQL, 7 years
  • Oracle Database, 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

    Data Warehouse Design, Business Intelligence (BI), MicroStrategy, Data Warehouse (DW) Requirements
  • Languages

    SQL, Java
  • Platforms

    Oracle Database
  • Storage

    Multi-dimensional Databases, PL/SQL, 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