Howdy Logo
Image of Lucas F.

Lucas F.
Data Analyst

Microsoft Sql Server
Html
Javascript
Php
Mysql
Bio

A professional journey characterized by a diverse range of technical skills acquired through both self-directed learning and formal education, responding effectively to complex and evolving demands across various sectors. Specialization includes system development, data pipeline creation, advanced database management, and analysis, showcasing notable adaptability and innovation in addressing professional challenges.

In Data Analysis and Data Engineering, expertise encompasses the monitoring and maintenance of data pipelines using Python and PySpark within ETL processes. This includes validating diverse data sets, ensuring information integrity, and analyzing various data attributes such as columns, rows, data types, and formats. Development of integrated data architecture spans from collection to processing, utilizing tools like Airflow, Jupyter Notebook, Portainer, Postgres, MySQL, and enabling comprehensive analysis through visualization tools such as Metabase, Excel, and Power BI. Additional experience includes creating data extraction bots using technologies like Selenium, Java, and Excel VBA, coupled with a robust knowledge of SQL data modeling and structuring, demonstrating versatility in information analysis and manipulation.

Web Development capabilities include proficiency in HTML, JavaScript, PHP, MySQL, and Postgres, with substantial experience in developing and managing web systems and websites along with their hosting and domain management.

In IT Infrastructure Management, there is expertise in managing Dell servers and VMware ESXi environments, overseeing complex on-premises infrastructure comprising multiple Docker containers running on Linux CentOS. These containers support a wide variety of services, with critical proficiency in ensuring secure and uninterrupted system operations through rigorous backup and maintenance practices utilizing technologies such as Acronis, TrueNAS, and Kerio firewall with VPN.

Additionally, extensive experience in providing comprehensive technical support and maintenance covers general computer upkeep, broadband, telephony, and TV installations and repairs in both corporate and freelance contexts. This breadth of experience underscores an ability to offer effective solutions across diverse technology domains, ensuring user satisfaction through ongoing support.

The overall career is marked by a blend of technical expertise, project leadership, and a collaborative approach, all sustained by a continuous pursuit of knowledge.

  • Programmer Analyst
    5/2/2019 - Present

    Developed expertise in monitoring and maintaining data pipelines using Python and PySpark for ETL processes. Executed comprehensive validation of various file formats, ensuring accuracy in CPF/CNPJ, column, and data type checks. Architected data integration, ingestion, orchestration, storage, and processing workflows, using tools like Metabase, Excel, and Power BI, to visualize the financial results of funds. Utilized a Linux CentOS and Docker-based on-premises infrastructure, deploying containers with PySpark, Airflow, RabbitMQ, Portainer, ReactJS, and NodeJS for frontend and backend operations, along with Postgres and MySQL databases for efficient processing. Managed an auxiliary server hosting containers with Airflow, Jupyter, Postgres, MySQL, and Metabase to support the main pipeline with additional tests and operations.

    Collaborated with third-party partners to oversee IT infrastructure across three Dell servers equipped with VMware ESXi hypervisors, supporting a diverse array of virtual machines, including Windows Server, Kerio VPN Firewall, legacy systems, and TrueNAS for effective data storage and backup management. Implemented FileAudit for network activity monitoring and managed Acronis for backup processes, ensuring the proper maintenance and monitoring of virtual machines, databases, and general file backups.

    In web development, leveraged HTML, CSS, JavaScript, and PHP to create and maintain the corporate website, managing hosting and domain services. Developed new functionalities and implemented financial reports to enhance investor communications. Additionally, executed the development of a time control system within a short timeframe.

    Supported data analysis efforts by performing detailed checks on calculations and graphs, working closely with risk analysts to identify and correct inaccuracies and errors, ensuring data integrity and reliability.

  • Computer Engineering at Eniac University Center
    2014 - 2019

  • Big Data Analysis 'Data Engineering' at Fia School Business
    2022 - 2024

  • Courses - Totaling the estimated workload of 222 hours at Alura
    11/2/2019

Lucas is available for hire

Hire Lucas F.
Check icon

All Howdy Candidates are vetted for skills and english proficiency.