Leandro Akira Oyadomari Data Analyst | Business Intelligence | Power BI | SQL |

G

Data Analyst

G4F

Aug 2024 - Current (1 year 10 months)

PETROBRAS: • Construction/maintenance of Query for data extraction from SAP BW and SAP ECC • Perform data collection, • Model the query in SAP BW, Query Designer or in ABAP query in SAP ECC • Perform query validation tests • Creation, maintenance and modification of Script • Use of automation libraries for solutions related to data manipulation and analysis. • Creation, maintenance and modification of flows in power automate and tools in power apps

S

Data Analyst

Singulare

Apr 2024 - Jul 2024 (4 months)

• Creation and publication of dashboards for data visualization, using Power BI; • Participate in the mapping of needs; • Creation and maintenance of the data model; • AWS and Azure; • Power Automate; • Data extraction and processing.

O

Data Analyst

Opice Blum Advogados Associados

May 2023 - Apr 2024 (1 year)

• End to end in the development of new dashboards; • Creation of tables and data modeling; • Connection with several sources; • Analysis and improvements of dashboards in production; • REST and GRAPHQL APIs; • Interface with all areas of the company to gather requirements and needs; • Ad hoc analysis for the areas; • Collaboration in FP&A; • Financial reports for senior management and other stakeholders; • Provide financial information to support senior management decision-making; • Fully automated P&L in Power BI; • Profitability analysis by area and subarea; • Profitability analysis of contracts

E

Data Analyst

Eleflow Big Data

Mar 2022 - May 2023 (1 year 3 months)

AME Digital: • Member of the BI Chapter; • Direct participation in the development of dashboards for Black Friday 2022; • Creation of SQL tables with automation for Azure Data Lake Storage Gen2; • End-to-end participation in the elaboration of tables and dashboards; • Ad hoc analyses for client areas; • Advanced knowledge in DAX (Data Analysis Expressions); • Advanced SQL for building queries in databases; • Data modeling focused on BI, with a focus on report performance; • Development of metrics and KPIs that translate the needs of business areas; • Understanding of business rules in order to propose BI solutions; • Good practices related to UX;

E

Data Analyst

Expresso Rio Vermelho Transportes

Nov 2020 - Feb 2022 (1 year 4 months)

• Development of dashboards, integrating information from various sources; • Support to managers in analyzing KPIs and business performance insights, through reports and presentations in meetings; • Work together with Operations and Sales to identify improvement points and new opportunities; • Use of languages used in Data Analytics, such as: SQL, VBA, DAX and M; • Use of Power BI, Azure and SharePoint for greater integration and sharing of data and information; • Creator of the dashboard that measures the time cargo stays in the warehouse, transfer time and distribution time, in addition to highlighting operational process errors; • Co-creation of the Freight Simulator (automation in the preparation of freight tables, weighing between carg

T

Administrative and Financial Analyst

Triunfo Trading

May 2019 - Oct 2020 (1 year 6 months)

• Accounts payable; • Generate and control collection guides; monitoring shipments and sending documents to the customs broker; • Monitoring of originals for air and sea shipments (AWB, BL, DI, Invoice and Packing List); empty container return; • Control of NFe's and CTe's; administrative routines.

g

Administrative and Financial Assistant

grupo moura

Jan 2019 - Mar 2019 (3 months)

• Processing of remittance and return of bank collection files; • Collections. • Monitoring and control of protested securities. • Reconciliation of bank deposits, returned checks, advance receipts, refunds and various credits. • Analysis and Billing of sales orders. • Control and file of documents.

I

Controllership and Finance Intern

INB

Mar 2015 - Mar 2017 (2 years 1 month)

• Monitoring of budgetary execution of the areas; • Monthly forecast; • Expense classification; • Actual vs. Budgeted; • Preparation of financial and economic reports for managers. • Forecasting and evaluation of results. Database manipulation. • Preparation of physical-financial schedules. • Budget execution control; • Continuous use of dynamic tables and graphs.

Production Leader

Nissan Motor Corporation

Aug 2013 - Jun 2014 (11 months)

• Responsible for managing production activities: monitoring operational results and performance indicators; • Conducting Kaizen events; • Preparation of standardized work documentation; • Use of problem-solving tools and service to internal customers; • Working with foreign employees on improvements and implementation of the assembly line. Results: Implementation of several improvements in the door line together with Japanese employees, reducing rework and decreasing cycle time. Presentation, together with Japanese employees, to supervisors, managers and production director on the methodology and thoughts of Nissan headquarters on the occurrence of production anomalies.

Machine Operator

DENSO

Jan 2008 - Dec 2008 (1 year)

• Machine operator in the manufacture of electric motors; • Responsible for the operation and basic maintenance of the machines; • Occasionally acted as an interpreter - Japanese/Portuguese.

Y

Assembly Line Operator

Yamaha Motor Co Ltd

Jan 2007 - Dec 2007 (1 year)

• Assembly line operator for jet ski engines; • Kaizen events; • Occasionally acted as an interpreter - Japanese/Portuguese.

Leandro Akira Oyadomari

About

Detail

Timeline

Résumé