Marcello Otsuka

Data Engineer / Business Intelligence Specialist at Trigg Brasil
  • Claim this Profile
Contact Information
Location
São Paulo, São Paulo, Brazil, BR

Topline Score

Bio

Generated by
Topline AI

0

/5.0
/ Based on 0 ratings
  • (0)
  • (0)
  • (0)
  • (0)
  • (0)

Filter reviews by:

No reviews to display There are currently no reviews available.

0

/5.0
/ Based on 0 ratings
  • (0)
  • (0)
  • (0)
  • (0)
  • (0)

Filter reviews by:

No reviews to display There are currently no reviews available.
You need to have a working account to view this content. Click here to join now

Experience

    • Brazil
    • Financial Services
    • 1 - 100 Employee
    • Data Engineer / Business Intelligence Specialist
      • Aug 2021 - Present

      Created and maintained:- ETL process using AWS Glue Job (PySpark), Crawler and Lambda (Python), to get a lot of types of files from S3 to Redshift;- Datamarts using Pandas on SageMaker and procedures on Redshift;- Dashboards using QuickSight;- Automation of extractions using AWS Lambda to make reports available on Ondrive.

    • Business Intelligence Specialist
      • May 2021 - Jul 2021

    • Senior Business Intelligence Analyst
      • Nov 2019 - Apr 2021

      - ETL process using ShellScript (EC2) to get csv files from S3 to RDS;- Datamarts using procedures on MySQL;- Dashboards using QuickSight.

    • Brazil
    • Financial Services
    • 700 & Above Employee
    • Business Intelligence Analyst
      • Mar 2014 - Nov 2019

      - Created and maintained queries, procedures and functions using PL/SQL and SQLServer to create reports; - Created data marts and maintained of the Data Warehouse; - Development of ETL processes using PL/SQL; - Using Microstrategy as a front-end tool. Administration, architecture and development of reports and dashboards; - Creation and treatment of databases using SQL to provide mailings; - Creation of dashboards using Table, Microstrategy, and Excel. - Created and maintained queries, procedures and functions using PL/SQL and SQLServer to create reports; - Created data marts and maintained of the Data Warehouse; - Development of ETL processes using PL/SQL; - Using Microstrategy as a front-end tool. Administration, architecture and development of reports and dashboards; - Creation and treatment of databases using SQL to provide mailings; - Creation of dashboards using Table, Microstrategy, and Excel.

    • Ireland
    • Business Consulting and Services
    • 700 & Above Employee
    • System Analyst
      • Jan 2011 - Feb 2014

      - Data extraction using PL/SQL and SQLServer; - Root cause analysis of incidents in Natura systems applications; - Making service requests in database to enable activities not available in the system of Natura; - Creation of functional specification and realization of approval tests. - Data extraction using PL/SQL and SQLServer; - Root cause analysis of incidents in Natura systems applications; - Making service requests in database to enable activities not available in the system of Natura; - Creation of functional specification and realization of approval tests.

Education

  • Faculdade de Tecnologia Zona Sul
    Technology for business management
    2009 - 2012

Community

You need to have a working account to view this content. Click here to join now