José Henrique Sant'ana De Barros

Experience

• 

  Allnex

  Feb 2019 - Aug 2020

  Material import and export, contact with forwarding agents, ports and foreign sources for issuing and receiving documents, process follow-up, control of costs and orders spreadsheet, forward freight and invoice to finance. Stock couting, order reporting, system entry and exit control.

  • Import Apprentice

    Jan 2020 - Aug 2020

  • Logistics Apprentice

    Feb 2019 - Dec 2019
• 

  Expresso Princesa dos Campos

  Dec 2020 - Mar 2023

  Development and creation of optimized queries in SQL Server (SSMS), MySQL and Oracle, views creation and ETL processes; dashboards and flows maintenance and development by Power Platform, gateways and integration management.Projects I've been involved:- Queries and views otimization, automation and transformation using SQL Server, Oracle DB and MySQL- Guidance and support in development of data pipelines using Airflow with interns and managers- Data governance Development, creation, maintenance, integration, data analysis and Power BI dashboard improvements; projects and process elaboration and automatizing with forms and intern flows by Power Platform. Virtual and physical archives control, tachographs, breathalyzers, AQR's, CRLVs, certificates, fleet maintenance, training worksheet and equipment control, graphics, deadlines, additional support. Customer service, complaints record, bus ticket information, prices, suport to sales with other agencies, material tracking, costs spreadsheet control.

  • Jr Data Analyst

    Jul 2022 - Mar 2023

  • IT Assistant

    Feb 2022 - Jun 2022

  • Operational Intelligence Center Assistant

    Nov 2021 - Jan 2022

  • Telephone Operator

    Dec 2020 - Oct 2021
• 

  Nexer Enterprise Applications

  Apr 2023 - now

  Acting as a data engineer, optimizing processes both for customers and internal areas, development of ETL flows with PySpark, Python, Microsoft Fabric, Azure DF, and playing around with new technologies in my spare time.Currently I'm working with internal cases like:- Data extraction from Microsoft platforms (Partner Center, Dynamics 365 F&O/BC) through API using PySpark/Python notebooks (Microsoft Fabric).- Working on ETL processes development to extract data from Dynamics 365 F&O and ingest into Microsoft Fabric service, creating a warehouse medallion and structuring data for consumption.Customers projects I'm working or have done:- Implementation of Microsoft Fabric to extract data from D365 F&O, creation of data warehouses and migration of old Azure SQL database for a USA customer.- Implementation of ETL processes to extract data from Dynamics systems (F&O, CRM, BC and Ax), Salesforce and other ones through Microsoft Fabric (using pipelines, dataflows, notebooks with PySpark) and structuring lakehouses and warehouses. Show less Development of end-to-end internal and external projects, from mapping the current state of the customer/area, raising requirements and needs, defining scope and estimated time for development, integrating services and tables from Dynamics 365 and Dataverse, starting and learning about Azure Data Factory, improving existing queries, adopting best practices for data ETL.Internal projects in which I've been involved:- Development of an application for HR requests, featuring automated workflows for vacation requests and chain approvals. Additionaly, there's an application for Support team control (Power Apps | Power Automate)- Revamping, standartization of old reports, and development of new reports for the company's departments.- Optimization and development of queries, views and tables- Development of ETL process for internal data- Instruction for colleagues on Power BI, SQL Server, ETLExternal projects in which I've been involved:- Revamping and development of reports of various types (HR, Finance, Operations, Support, Management)- Data migration among systems/databases/storages with workflows and pipelines (Data Factory | Microsoft Fabric)- Training on tools and best practices (Power BI)- Documentation of processes, projects and activities Show less

  • Data Consultant

    Feb 2024 - now

  • Jr Power BI Consultant

    Apr 2023 - Jan 2024