Mateus L.Data Engineer
Skills
An aspiring IT professional, presently engaged in an internship, is dedicated to expanding knowledge and skills through a combination of hands-on experience and rigorous academic pursuits. This individual is actively immersed in college education and supplementary courses, with a strong focus on acquiring comprehensive insights into the IT field and market trends.
Java Developer – Jr.
10/1/2023 - Present
Assigned the responsibility for implementing and maintaining messaging integrations based on Event Driven Architecture (EDA) and employing REST and SOAP standards using Domain-Driven Design (DDD). This role required the use of Java Quarkus for application development, Azure Cosmos DB and Redis for database management, and Apache Camel and Apache Kafka for messaging and integration. Developed comprehensive documentation and architectural software models leveraging Low-Level Design (LLD) and C4 models to present technological choices and system flows effectively. Created and executed a suite of unit, integration, and regression tests to ensure robustness and reliability of code. Established continuous integration and delivery pipelines using OpenShift in alignment with DevOps principles. Engaged in requirement gathering and provided support by applying Scrum methodology to achieve alignment and prioritization of tasks effectively.Data Engineer – Pl.
8/1/2023 - 9/1/2023
Developed proficiency in constructing BI, Dashboards, and Reports through ERP Sankhya and Power BI. Solid experience in data modeling and building data dictionaries was achieved. Crafted complex queries, functions, stored procedures, views, materialized views, triggers, and jobs, ensuring optimal database performance. Applied advanced partitioning and indexing techniques for efficient table management, alongside executing robust query tuning practices. Managed the tuning and configuration of OLAP and OLTP databases to enhance system performance.
Automated various tasks within ERP Sankhya using SQL, Java 8, PL/SQL, and Oracle/MySQL triggers, streamlining processes significantly. Orchestrated ETL processes for diverse data sources, including spreadsheets, data lakes (Oracle, MySQL, MongoDB, AWS S3), and external APIs utilizing Java 8, Python/Pandas, and Pentaho. Proficient in modeling and constructing comprehensive data warehouses and data marts, supporting data-driven decision-making.
Built a strong support system for managers by assisting in the construction of KPIs, leveraging deep insights into operational data. Implemented and maintained CronJobs on Windows Virtual Machines, ensuring seamless task scheduling and execution. Facilitated seamless integration and maintenance of CRM Bitrix for the commercial sector and TMS Cobli for logistics, efficiently managing their respective pipelines.
Expertly gathered requirements and provided support using Scrum methodology for efficient alignment and task prioritization. Created and maintained UML and C4 system manuals, ensuring up-to-date documentation for system processes. Provided user support for ERP Sankhya, ensuring smooth operations and quick resolution of issues.Systems Analyst – Jr.
3/1/2022 - 8/1/2023
Supported various activities for Purchasing, Commercial, Logistics, and Board departments with a focus on data and software areas. Developed comprehensive BI solutions including dashboards and reports, coupled with constructing data models and data dictionaries. Proficient in creating database queries, functions, stored procedures, views, materialized views, triggers, and jobs, along with partitioning and indexing tables for optimal performance. Specialized in query tuning and configuring OLAP and OLTP databases, and automating tasks via ERP Sankhya using SQL, Java 8, PL/SQL, and MySQL triggers. Orchestrated ETL processes for diverse data sources like spreadsheets, data lakes (Oracle, MySQL, MongoDB, AWS S3), and external APIs employing Java 8, Python/Pandas, and Pentaho. Demonstrated expertise in modeling and building data warehouses and data marts, and supported managers in KPI construction.
In the software domain, created and maintained Java 8 (Domain Driven) applications within ERP systems and Java 11 + SpringBoot 2.0 (REST MVC) applications hosted on Heroku and Localweb platforms. Integrated and maintained CRM Bitrix to streamline commercial operations and TMS Cobli for logistics management. Implemented unit, integration, and regression testing using JUnit, and employed Infrastructure as Code (IaC) practices with Terraform. Engaged in requirement gathering and alignment with company needs through Scrum methodology for task prioritization and alignment. Authored and updated UML and C4 systems documentation and provided comprehensive ERP Sankhya user support.Systems Analyst - Internship
8/1/2021 - 3/1/2022
Contributed to the Commercial area by constructing BI systems, dashboards, and comprehensive reports. Demonstrated expertise in data modeling and creating detailed data dictionaries. Developed and optimized queries, functions, stored procedures, views, materialized views, triggers, and jobs, focusing on query tuning for optimal performance. Automated various tasks in ERP Sankhya using a combination of SQL, Java 8, and PL/SQL or ORACLE Triggers. Extracted and processed data from spreadsheets and external APIs using Java 8 and Pentaho, supporting managers in building effective KPIs.
In the software domain, developed and maintained Java 8 applications within the ERP framework and used Java 11 with SpringBoot 2.0 (REST MVC) on the Heroku platform. Ensured application quality by creating unit, integration, and regression tests using JUnit. Facilitated requirements gathering and task prioritization through the Scrum methodology, and developed and updated system documentation, including manuals, UML diagrams, and C4 diagrams. Provided user support for ERP Sankhya, ensuring smooth operations and user satisfaction.Database Administrator – Internship
2/1/2021 - 8/1/2021
Responsible for constructing Business Intelligence (BI) solutions, dashboards, and reports, showcasing extensive expertise in data modeling and developing comprehensive data dictionaries. Proficiency in creating queries, functions, stored procedures, views, triggers, and jobs was demonstrated, along with advanced skills in query tuning to optimize performance. Successfully automated tasks using ERP Sankhya with SQL and Oracle PL/SQL, and provided strategic support to sector managers by assisting in the construction of Key Performance Indicators (KPIs).
Software Architecture and Solutions at Institute of Management and Information Technology (IGTI)
2023 - 2024Computer Science at UniCarioca University Center
2019 - 2022
Spring Boot, Hibernate, REST, Ionic, JWT, S3, MySQL, MongoDB at Udemy Brasil
12/1/2022Microservices from Zero with Spring Cloud, Spring Boot, and Docker at Udemy Brasil
12/1/2022Java Microservices with Spring Boot and Spring Cloud at Udemy Brasil
12/1/2022Complete Java Object-Oriented Programming + Projects at Udemy Brasil
12/1/2022
Mateus is available for hire
Hire Mateus L.
All Howdy Candidates are vetted for skills and english proficiency.
