Federico Raul Diaz
Verified Expert in Engineering
Database Developer
Córdoba, Cordoba, Argentina
Toptal member since March 11, 2022
Federico is a database specialist with over 17 years of experience developing different databases, mainly using Oracle PL/SQL, Microsoft SQL Server, and MySQL. He worked with various business intelligence tools and ETL process design and has experience using Agile methodologies and Scrum in teams of people from many countries. Federico has a broad knowledge of programming gained while managing database teams.
Portfolio
Experience
- SQL - 17 years
- Microsoft SQL Server - 17 years
- SQL Stored Procedures - 17 years
- Oracle PL/SQL - 14 years
- MySQL - 10 years
- Microsoft Power BI - 6 years
- Python 3 - 5 years
Availability
Preferred Environment
Windows, SQL, SQL Server Management Studio (SSMS), Microsoft SQL Server, MySQL, Oracle SQL Developer, Microsoft Power BI, GitHub, SQL Stored Procedures, PL/SQL Tuning
The most amazing...
...thing I've done is a reduction of the report's response time to 10% of the original value in a real-time system to show results uninterruptedly.
Work Experience
SQL Server Expert
Tienda Amiga ER S.A.
- Analyzed the most executed queries, like the ones that took the longest to choose and which ones needed to be optimized in the production database.
- Used different strategies to optimize the performance of the different queries that needed to be optimized.
- Generated reports on each improvement made, explaining the reasons for the changes, and showing the results of the improvements in performance.
Senior Full-stack Developer
3XM Group
- Developed a website using C# with ASP.NET MVC, Entity Framework, and Azure SQL Server database.
- Built the database structure and logic by creating tables, views, triggers, and stored procedures.
- Contributed to improving the query performance in Microsoft SQL Server.
- Designed Microsoft Power BI dashboards using several data sources.
Senior Database Developer
Band of Coders
- Developed ETL processes with MySQL and TypeScript.
- Created database structure, logic, tables, views, triggers, and stored procedures.
- Improved query performance using MySQL as a database management system.
Senior Database Developer
3XM Group
- Developed the ETL processes with Microsoft SQL Server, MySQL, and SSIS.
- Created the structure, logic, tables, views, triggers, and stored procedures of a database and worked on query performance improvement in several databases.
- Developed reports in a real-time reporting app using a MySQL database.
Senior Developer
Calden S.R.L.
- Built the ETL processes with Oracle, Microsoft SQL Server, MySQL, and PostgreSQL.
- Developed the database structure and logic and created tables, views, and stored procedures.
- Conducted geographical data analysis with Python, QGIS, and other tools. Improved query performance in all databases.
- Developed web and desktop applications with VB.NET, ASP.NET, Oracle, Microsoft SQL Server, MySQL, and Python.
- Designed dashboards using Microsoft Power BI with several data sources.
Database Technical Leader
Nexius Wireless
- Used Oracle, Microsoft SQL Server, and Vertica databases to develop ETL processes.
- Built database structure and logic and created tables, views, triggers, packages, and stored procedures.
- Improved query performance and configured reports.
- Reviewed all database team members' codes and assigned tasks to all team members.
- Divided tasks by splitting business stories into technical ones.
- Used Microsoft Power BI with several data sources to design dashboards.
Project Leader
TEKHNE
- Performed code reviews of all team members and assigned tasks to them.
- Developed applications using GeneXus 8.0, Java, and Oracle database.
- Managed the customer interaction and development team.
Technical Leader
Goldis S.A
- Developed applications with VB.NET, ASP.NET, JavaScript, and Oracle Database.
- Managed the development team and reviewed the code changes.
- Defined the tasks and assigned them to the developers.
Oracle and SQL Server Database Developer
Vates S.A.–Motorola and Invel Latinoamericana
- Developed applications using Oracle PL/SQL and SQL Server.
- Created compatible applications using Oracle and SQL Server.
- Helped the development team with database-related tasks.
Project Leader
Córdoba Software
- Developed administrative applications using Visual Basic 6.0 and SQL Server.
- Managed the development team that was working on the Zeus application.
- Performed code reviews of all team members related to the Zeus application.
- Divided tasks and assigned them to the team members.
Data Warehouse Analyst
Provencred Credit Card
- Developed ETLs using IBM Informix-4GL and IBM Informix database.
- Created reports using IBM Informix Metacube for data visualization.
- Participated in the design of the data warehouse model.
Experience
VIRT Project
The project consisted of leaving a vehicle in an unknown place to explore and move towards a new point relative to the one the vehicle was in. To achieve this, a remote control vehicle was used, where the remote control was modified so that a computer could operate it. The vehicle had several sensors on it—on one of its wheels to measure progress, another to measure the distance from the vehicle to possible objects in its path, and one mounted on a stepper motor to be able to turn it and have a vision of 360 degrees around it. The vehicle also had a PIC microprocessor mounted on it that operated all the sensors and transmitted the information obtained.
The application used for receiving data, making calculations to decide how to proceed without colliding with the objects on the route, and ordering the vehicle to move in the desired direction, was developed in C++ for DOS. A computer with an Intel 386 processor was enough for it to work.
Administrative and Accounting System for Small and Medium-sized Business
This system is currently working in more than 50 companies in Argentina.
VB.NET and ASP.NET Libraries to Speed Up Development
The components of the library were classes that dynamically generated the HTML pages in the browser, the JavaScript code for the client, the classes to access the database, and many classes to perform other tasks such as reports and pivot tables.
The code generator built the interface and business classes and stored procedures to access data from the database.
Education
Professional Degree in Data Science
Universidad Nacional de Córdoba - Cordoba, Argentida
Specialization in Software Engineering
Universidad Nacional de Córdoba - Cordoba, Argentina
Professional Degree in Project Management
Universidad Católica de Córdoba - Cordoba, Argentina
Engineer's Degree in System Engineering
Universidad Católica de Córdoba - Cordoba, Argentina
Certifications
Python Best Practices for Code Quality
Pluralsight
Big Data on AWS: The Big Picture
Pluralsight
Building Your First Python Analytics Solution
Pluralsight
Flask: Getting Started
Pluralsight
Managing Python Packages and Virtual Environments
Pluralsight
Introduction to MongoDB
Pluralsight
Designing RESTful Web APIs
Pluralsight
Managing SQL Server Database Maintenance
Pluralsight
Serverless Analytics on AWS
Pluralsight
Python for Data Analysts
Pluralsight
Unit Testing with Python
Pluralsight
Python: Beyond the Basics
Pluralsight
Core Python: Getting Started
Pluralsight
Python: The Big Picture
Pluralsight
Python 3 Tutorial Course
Solo Learn
C# Tutorial Course
Solo Learn
Curso de Portugués Online A2
www.portuguesonline.com
Curso de Portugues Online A1
www.portuguesonline.com
Skills
Libraries/APIs
Liquibase, Node.js, jQuery
Tools
HeidiSQL, Microsoft Power BI, Jira, Microsoft Visual Studio, GitHub, Microsoft Project, IBM Informix-4GL, Toad, Git, Subversion (SVN), Docker Hub, Jupyter
Languages
SQL, Visual Basic 6 (VB6), Python 3, Visual Basic .NET (VB.NET), Python, VB.NET, C#, SQL DML, JavaScript, TypeScript, C++, Stored Procedure, T-SQL (Transact-SQL)
Storage
Microsoft SQL Server, Relational Databases, Oracle PL/SQL, PL/SQL, SQL Stored Procedures, Database Modeling, SQL Server Management Studio (SSMS), MySQL, Oracle SQL Developer, PostgreSQL, Azure SQL, IBM Informix, Vertica, PostGIS, SQL Server Integration Services (SSIS), Azure Websites, SQL Server DBA, MongoDB, SQL Performance, Databases, Database Structure, Database Transactions
Frameworks
ASP.NET, ASP.NET MVC, AngularJS, Flask
Paradigms
ETL, OLAP, Unit Testing, REST, Database Design
Platforms
Windows, Oracle, Jupyter Notebook, Linux, Google Cloud Platform (GCP), AWS Lambda, Amazon Web Services (AWS), Azure
Other
Data Modeling, Systems Engineering, Programming, Program Design, GeneXus, Data Visualization, Data Engineering, Migration, Real-time Computing, Compilers, IT Project Management, Distributed Systems, Distributed Software, Machine Learning, Neural Networks, Data Cleaning, K-means Clustering, QGIS, Electronics, Electricity, Microprocessors, Harvest, Communication, Portuguese, Big Data, PL/SQL Tuning, Data Warehousing, Data Cleansing, Data Transformation, Statistics, SAP Business One
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring