👋 Hey there
I'm Leo, I love finding hidden issues, helping teams avoid surprises, improving product quality, and learning new things. Check out my portfolio in the table below and the special project in the Pins. Feel free to write to me on LinkedIn or email. Thank you for stopping by!
📍 Open to job offers
| Expertise | Description | Stack | Link |
|---|---|---|---|
| API Testing | Postman Test Collection. Demonstrates practical skills in API testing using Postman and JSON Server. Includes automated checks for response structure, data validation, CRUD operations, and edge cases such as invalid inputs and cascading deletes. Highlights understanding of HTTP methods, status codes, and test coverage documentation. | Postman, REST API, JavaScript, JSON, HTTP | GitHub |
| Smart Contract Testing | Solidity Contracts and Foundry Tests. A subscription-based system implemented with Solidity and tested using Foundry. The project includes smart contracts for payment processing, access control, and subscription tracking. | Solidity, Foundry, Blockchain, Web3 | GitHub |
| HTML/CSS | Layout and UI Components. Several projects demonstrating an understanding of UI behavior and front-end mechanics for more effective testing. Focused on building interactive and visually appealing web elements, including a drag-and-drop interface, two types of image sliders, and a personal resume page. | HTML, CSS, JavaScript | Drag_and_drop Slider_cafe Slider_jarritos Resume |
| JavaScript | UI Interaction. Developed small interactive games focusing on event handling, dynamic DOM manipulation, and game logic. These projects explore key JavaScript concepts such as timers, element creation, and user interaction to create engaging experiences. | JavaScript, DOM Manipulation, Event Handling, Timers, Dynamic Elements, CSS Animations. | Game_colors Game_circles |
| SQL | Basic Queries. Contains a collection of fundamental SQL queries, demonstrating key data extraction, transformation, and aggregation techniques for working with relational databases. | MySQL, Selection, Aggregation, Joins, Subqueries, Data Filtering. | GitHub |
| SQL Python |
Managing Tables and Views. Data Encryption. Contains a collection of SQL queries and Python notebook that demonstrate creating and managing tables, establishing relationships, and ensuring data integrity. Covers a variety of tasks such as preprocessing data, data encryption, handling data updates and deletions, managing database views, and step-by-step manual. It is accompanied by documentation describing the development process. | MySQL, Python Scripting, Data Transformation, Indexing, Views, Managing Tables, Transactions, Data Encryption. | GitHub |
| SQL | Managing Database. Contains the design and creation of a star schema database based on CSV files and specific data selection requirements, integrating new tables with data parsing, and a collection of queries designed for efficient data retrieval and analysis within the star schema model. It includes documentation with the development process. | Database Design, Star Schema, Foreign and Primary Keys, SQL Data Types, Data Parsing | GitHub |
| Python | Data and Control Structures. Solutions to real-world problems using Python’s data structures and control flow mechanisms. The exercises focus on implementing small yet practical programs, such as a Body Mass Index calculator, Temperature converter, Word counter etc, while following best coding practices (PEP 8, PEP 257, Google style for docstrings). | Functions, Input Validation, Conditional Statements, Exception Handling, Loops, Lists, Dictionaries, Tuples, JSON, File Handling. | GitHub |
| Python SQL Power BI |
Data Visualization. Complete Analytics Workflow. Data visualization using Python while integrating with MySQL databases and Power BI reporting. It covers data extraction, transformation, and uncovering insights with advanced visualization tools in Python. | Pandas, NumPy, SQLAlchemy, Matplotlib, Seaborn, ETL-like process, MySQL Workbench and Python, and Power BI Integration. | GitHub |
| Python EDA |
Statistical hypothesis testing. Exploratory Data Analysis of Energy Balance and Greenhouse Gases Emissions in Catalonia for 1990-2022 with forecasting the achievement of government goals in several ways by building models of Simple and Multiple Linear Regression. | Pandas, NumPy, Matplotlib, SciPy, Scikit-learn, Statsmodels, Correlation Analysis, Regression Analysis, ETL, Power BI. | GitHub |
| Power BI | KPI Analysis and Data Visualization. Reports for analyzing key performance indicators (KPIs), including project metrics, employee workload, sales dynamics, and geographic client distribution etc. All reports are designed following UX/UI best practices, ensuring clear and efficient data interpretation. Accompanied by documentation detailing the development process, results, conclusions, and recommendations. | UX/UI Design, MySQL Integration, ETL-like process, Data Modeling, Data Processing, DAX, Measures Calculation, Visualization Techniques, Advanced Analytics. | GitHub GitHub GitHub |