Marcello Otsuka
Data Engineer / Business Intelligence Specialist at Trigg Brasil- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
0
/5.0 / Based on 0 ratingsFilter reviews by:
Experience
-
Trigg Brasil
-
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.
-
-
-
Crefisa
-
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.
-
-
-
Accenture
-
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