Juan D.
Data Engineer

Skills

Sql

Advpl

Oracle Database

Juan is available for hire

Hire Juan D.

All Howdy Candidates are vetted for skills and english proficiency.

Bio

A business and requirements analyst possessing advanced expertise in SQL language and database management. Demonstrates a robust capacity to conduct training sessions, underpinned by effective teaching skills. Holds a comprehensive understanding of the Protheus system and its various modules.

Systems Analyst
4/1/2022 - Present

Developed proficiency in PL/SQL and business analysis, focusing on implementing improvements to meet ANS regulations. Performed data extractions and report creation in PL/SQL, including the creation of automated jobs and procedures such as the approval and cancellation of orders to enable system adjustments without human intervention. Conducted extensive data manipulation through scripts involving inserts, deletes, and updates, as well as the creation and modeling of data structures for system enhancements. Provided technical support to customers, addressing system-related issues and inquiries to ensure customer retention. Contributed to team meetings to analyze requirements and discuss solutions, aiding in the creation of strategies for task execution. Conducted functional testing on the system to detect interface, behavior, and performance issues, ensuring the proper functioning of specific commands. Participated in alignment meetings utilizing the Scrum methodology to enhance the efficiency of deliverables.
Systems Analyst
12/1/2020 - 8/1/2021

Monitored systems, executed complex queries in SQL Server and Oracle, and contributed to the creation and refinement of processes. Gathered requirements, tested, and validated new systems, ensuring optimal performance and reliability. Improved execution of systems in production environments and played a crucial role in the process team, enhancing new functionalities. Demonstrated extensive involvement with databases and Power BI, facilitating data analysis and visualization to support business decision-making.
Systems Analyst
10/2/2019 - 4/1/2022

Proficiency developed in Protheus system support, including the application of patches and sources in production environments. Gained extensive experience in data modification using the Oracle database and making minor changes to customized sources. Demonstrated capability in report development using ADVPL. Achieved greater mastery of Protheus, encompassing understanding of its functions, basic uses, and entire infrastructure. Expertise extended to correcting menus, managing system services, and modifying folders integral to its structure.