Luis is available for hire

Luis Bardalez Garcia

Verified Expert in Engineering

Software Developer

Location

Lima District, Lima Region, Peru

Toptal Member Since

May 4, 2022

Luis has excellent experience working with ETL, SQL, Python, and Node.js. He mainly focuses on complete internet of things (IoT) data pipeline projects, including protocol development, architecture design, deployment, and cloud services on the Google cloud platform (GCP) platform. Luis also works with back-end service development for data consumption, SQL database administration, design, deployment, background data processing, business intelligence, and data analysis.

Data Engineering Microsoft SQL Server Database Design Python Software Development SSH Data Queries Databases SQL Linux ETL Node.js JavaScript REST APIs Microsoft Power BI Windows 7 Minitab PLC

Portfolio

Ferreyros S.A.

Microsoft Power BI, Oracle SQL, Microsoft SQL Server, SQL Server 2016, Node.js...

Modular Mining Systems S.C.R.L.

Microsoft SQL Server, CSV File Processing, CSV Export, CSV Import...

Sociedad Minera Cerro Verde S.A.A.

Excel 2010, Android SDK, Microsoft SQL Server, C++, Excel VBA, Linux, Windows 7...

Experience

Databases - 10 years Microsoft SQL Server - 10 years Linux - 7 years Python 3 - 7 years Database Design - 6 years Node.js - 4 years JavaScript - 4 years

Availability

Part-time

Preferred Environment

Windows 10, Microsoft SQL Server, Visual Studio Code (VS Code), GitHub, ClickUp

The most amazing...

...IoT platform I've created included architecture design and development for an IoT gateway, an IoT cloud gateway, database storage, and ETL to data marts.

Work Experience

Technology Project Developer

2018 - PRESENT

Ferreyros S.A.

Developed an IoT platform for mining equipment from data acquisition to data exploitation.
Developed dashboards for data analysis and insight generation.
Developed an ETL for mining equipment to report consumption from different systems to data marts.
Migrated SQL databases from on-premise servers to cloud providers, including Azure and GCP.

Technologies: Microsoft Power BI, Oracle SQL, Microsoft SQL Server, SQL Server 2016, Node.js, Node-RED, Python 3, Cloud Computing, Azure SQL, Google Cloud SQL, On-premise, Ubuntu Server, Linux CentOS 7, Windows 10, Windows Server 2016, MQTT, Internet of Things (IoT), Google Cloud Platform (GCP), Databases, Database Design, Software Development, Software Architecture, JavaScript, Python, Data Queries, Reporting, APIs, Dashboards, REST APIs, SSH

Applications Engineer

2016 - 2017

Modular Mining Systems S.C.R.L.

Developed data integration pipelines from and to different third-party products, including CSV and SQL sources and sinks, enabling users to have all their information on the same data marts.
Developed graphical user interfaces for user interaction with information of its requirements, allowing the client to save time in queries and data entry.
Provided technical support related to currently installed systems.

Technologies: Microsoft SQL Server, CSV File Processing, CSV Export, CSV Import, Red Hat Linux, Windows 7, IT Helpdesk, ETL, Zendesk, SSH

Internship Trainee - Junior Engineer

2013 - 2014

Sociedad Minera Cerro Verde S.A.A.

Developed reports on excel using data from an SQL server to reduce querying time from 20 minutes to 2 minutes on average.
Developed custom software to automate repetitive tasks, reducing task time by 50% on average.
Analyzed data supported on different tools like Excel, SQL, Minitab, and MATLAB.

Technologies: Excel 2010, Android SDK, Microsoft SQL Server, C++, Excel VBA, Linux, Windows 7, Data Queries

Experience

IoT Platform

Created a fully functional IoT platform. My involvement was designing the software architecture, developing the running software on both types of equipment and servers, and integrating the information into the business data marts using an ETL.

Complex ETL Pipeline

Orchestrated a complex pipeline to integrate information between different products into business data marts. I was involved in analyzing the source databases and tables, understanding and implementing business logic, ensuring data consistency between other databases, and developing the ETL pipeline using cloud components.

Database Migration from On-premise to The Cloud

Implemented a database migration from On-premise servers running with Oracle SQL to cloud servers running Microsoft SQL Server. My involvement was validating query changes between different databases, database modeling on the destination database, script migration, and solution deployment in cooperation with other teams.

Education

2018 - 2019

Master's Degree in Big Data and Bussiness Intelligence

EADIC - Madrid, Spain

2014 - 2016

Master's Degree in Automation and Control Engineering

Pontifical Catholic University of Peru - Lima, Peru

2007 - 2011

Bachelor's Degree in Mechatronics Engineering

National University of Engineering - Lima, Peru

Skills

Libraries/APIs

Node.js, REST APIs

Tools

Microsoft Power BI, Vim Text Editor, Excel 2010, Node-RED, MQTT, PM2, GitHub

Paradigms

Database Design, ETL

Languages

Python, JavaScript, SQL, C++, Python 3, T-SQL (Transact-SQL), Excel VBA

Storage

Microsoft SQL Server, Databases, SQL Server 2016, MongoDB, MySQL, Oracle SQL, Azure SQL, Google Cloud SQL, On-premise, Google Cloud Storage

Frameworks

Android SDK

Platforms

Linux, Google Cloud Platform (GCP), Visual Studio Code (VS Code), Linux CentOS 7, Red Hat Linux, Windows 7, Windows Server 2016, Raspberry Pi, Arduino, Zendesk, Google Cloud Engine, Windows Server 2012

Other

Data Engineering, Software Development, ETL Development, Data Queries, APIs, Dashboards, SSH, Engineering, Programming, Microcontroller Programming, Mechanics, Modeling, Data Modeling, Control Systems, Adaptive Control Systems, Linear Control Systems, Big Data, Big Data Architecture, Internet of Things (IoT), Microsoft Azure, Google BigQuery, Windows 10, Ubuntu Server, CSV File Processing, CSV Export, CSV Import, IT Helpdesk, Cloud Computing, Software Architecture, PLC, ClickUp, Google Cloud Functions, Reporting

Collaboration That Works

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

Discuss your requirements and refine your scope in a call with a Toptal domain expert.

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring