Hi, I'm Abel Tavares.

A
Data-driven, quick starter, passionate developer with a curious mind who enjoys solving complex and challenging real-world problems.

About

I'm a DevOps Engineer with a strong foundation in software development and data engineering. I have over 2 years of professional experience, during which I've had the opportunity to work on a variety of projects that have allowed me to strengthen my skills. I've developed an interest in designing, developing, and maintaining software systems. As I continue to grow in my career, I'm excited about the opportunity to develop complex applications that leverage data software to drive business value. I'm always eager to learn new technologies and methodologies, and I strive to bring 100% effort into every project I undertake.

  • Software Development: Python, Bash, Object-Oriented Programming, Unit Testing, CI/CD (Continuous Integration/Continuous Deployment), Spark, Kafka, Hadoop, Docker, Terraform, Git, Linux, Agile
  • Databases: PostgreSQL, MongoDB
  • Data Engineering: PySpark, pandas, NumPy
  • Data Analysis and Reporting: Tableau, Power BI
  • Process Automation: VBA Programming, Microsoft Excel Macros
  • Cloud Services: AWS, Azure

Looking for an opportunity to work in a challenging position combining my skills in Software Engineering with business needs, which provides professional development, interesting experiences and personal growth.

Experience

DevOps Data Engineer
  • Develop software systems following Object-Oriented Programming principles and unittest framework, while integrating DevOps practices for streamlined operations.
  • Develop a Python Wrapper for Terraform, simplifying architecture development and deployment, with a focus on data architectures, using JSON files.
  • Build an advanced data platform with event-driven pipelines using Python, Apache Spark, and AWS services.
  • Data cleaning, preparation, transformation, and encryption using pandas and pyspark.
  • Implement test automation and streamline CI/CD pipelines with Github Actions.
  • Streamline automation by containerizing solutions with Docker.
  • Write and maintain Python and Bash scripts to automate tasks.
  • Agile scrum methodology for collaboration and delivering improvements through code reviews and discussions every sprint.
  • Skills: Python, Bash, OOP, Unit Testing, CI/CD, Databases, SQL, Spark, AWS, Terraform, Docker, Git, Linux, Jira, Agile
Nov 2023 - Now | Porto, Portugal
Data Analytics Developer
  • Designed and implemented Python-based automated solutions, streamlining data collection, cleaning, transformation, and reporting processes.
  • Created and maintained reports, Tableau dashboards, and visualizations to facilitate data-driven decision-making and effectively communicate insights and trends.
  • Supported technical implementations, access management, and optimizing data architecture.
  • Improved performance analysis by defining and modeling Key Performance Indicators (KPIs) for multiple functional areas and verifying KPI reporting with SAP Analysis for Office from BW/4HANA queries.
  • Streamlined processes by analyzing and reporting on variances for key activities.
  • Skills: Python, Functional Programming, BI, Tableau, Jira, Process Automation, KPI modeling, Reporting, Data Analytics, Agile
Fev 2023 - Nov 2023 | Porto, Portugal
Master Data Specialist
  • Monitored and analyzed SAP master data ensuring integrity and accuracy, maintaining high data quality standards.
  • Improved operational efficiency by creating advanced macros for data extraction, reporting, and validation, streamlining tasks.
  • Automated SAP maintenance processes with VBA programming, optimizing system functionality.
  • Designed and implemented test cases for Finance Master Data processes, ensuring smooth transitions and accuracy.
  • Conducted internal controls and generated monthly reports for effective financial management and compliance.
  • Facilitated cross-functional communication among IT, accounting, controlling, and treasury teams, ensuring alignment with master data rules and application operations.
  • Skills: VBA Programming, Microsoft Excel Macros, Process Automation, SAP MDM, Jira, Reporting, Financial Analysis
Nov 2021 - Fev 2023 | Porto, Portugal
Business Analyst Intern
  • Implemented BI solution for tracking financial and operational performance.
  • Tools: BI, Power BI, SQL, Excel, VBA, Data Analysis, Reporting, Financial Analysis
Mar 2021 - Aug 2021 | Porto, Portugal

Projects

music streaming app
PostQL

Python library and command-line interface tool for interacting with PostgreSQL.

Accomplishments
  • Installation: pip install postql
  • Simplified database management.
  • Query execution with python code.
  • Data result export functionalities.
quiz app
MarketTrackPipe

Containerized Airflow data pipeline.

Accomplishments
  • MarketDataEngine to collect and store stock and cypto data
  • Airflow Dags to create and manage workflows
  • Object-Oriented Programming
  • Unit Testing
  • Docker compose for containerization
  • CI/CD
Screenshot of web app
FinStockDash

Streamlit Python-based web application.

Accomplishments
  • Streamlit web app for data retrieval and visualization.
  • User can enter a stock ticker symbol to retrieve and anlyse relevant financial information.
music streaming app
Stock Tracker

A Django-based web application for real-time stock tracking which uses a PostgreSQL database.

Accomplishments
  • User Registration and Authentication.
  • Stock Tracking.
  • Database Management.
  • Web Development.
  • Security.
Screenshot of  web app
Healthcare NPS Analysis

Analyzing and monitoring Net Promoter Score (NPS) performance.

Accomplishments
  • Power BI dashboard for visualizing NPS performance metrics.
  • SQL query to calculate NPS metrics with optimization suggestions.
Screenshot of  web app
SAPCCMass

Excel tool for automating mass maintenance of cost centers in SAP.

Accomplishments
  • Automation of Mass Maintenance in SAP.
  • Integration with SAP GUI Scripting and VBA.
  • Customizable Excel Interface.
Screenshot of  web app
RoboDodge

A Scratch-based action game.

Accomplishments
  • Fast-paced action game.
  • Score tracking and best score saved.
  • Background music can be muted.
  • Try again feature.
  • Easy to pick up and play, but challenging to master.

Skills

Languages and Databases

Python
SQL
PostgreSQL
MongoDB
Django
Shell Scripting
VBA
Front-end

Data Processing

Spark
Kafka
NumPy
Pandas
PySpark
dbt

Data Visualization

Power BI
Tableau

Other

AWS
Terraform
Docker
Github
Git
Jira

AI Productivity Tools

ChatGPT
Phind
Github Copilot

Certifications

Education

ISEP - Porto School of Engineering

Porto, Portugal

Degree: Postgraduate Degree in Big Data Engineering
Grade: 15/20

Relevant Courseworks:

  • Big Data Analytics
  • Big Data Architecture
  • Big Data Tools
  • Cloud Computing
  • Business Intelligence
  • Data Mining
  • Data Security & Privacy
  • Data Warehousing

Harvard School of Engineering and Applied Sciences

Degree: CS50, Computer Science
Grade: Completed

Relevant Courseworks:

  • Abstraction
  • Algorithms
  • Data structures
  • Encapsulation
  • Resource management
  • Security
  • Software engineering
  • Web development

ISCAP - Porto Accounting and Business School

Porto, Portugal

Degree: Master's Specialization in Corporate Finance
CGPA: 15/20

Relevant Courseworks:

  • Quantitative Methods for Finance
  • DMonetary Economics, Financing and Financial Institutions
  • Risk Management
  • Investment Analysis
  • Advanced Management Control

UPT - Portucalense University

Porto, Portugal

Degree: Bachelor's degree in Business Management
Grade: 15/20

Relevant Courseworks:

  • Business Intelligence
  • Technology and Information Systems
  • Quantitative Methods and Statistics
  • Economics
  • Finance
  • Business Strategy

Contact