José Henrique Sant'ana De Barros

José Henrique Sant'ana De Barros

Followers of José Henrique Sant'ana De Barros247 followers
location of José Henrique Sant'ana De BarrosSão Paulo, São Paulo, Brazil

Connect with José Henrique Sant'ana De Barros to Send Message

Connect

Connect with José Henrique Sant'ana De Barros to Send Message

Connect
  • Timeline

  • About me

    Data Engineer | ETL Developer | SQL | Azure | Microsoft Fabric | Python | Spark

  • Education

    • Serviço Nacional de Aprendizagem Industrial

      2019 - 2020
      Curso Técnico Administrative Assistant and Secretarial Science, General
    • Cruzeiro do Sul Virtual

      2023 - 2025
      Tecnólogo em Ciência de Dados Information Technology
  • 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
  • Licenses & Certifications