Luis Bardalez Garcia
Verified Expert in Engineering
Software Developer
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.
Portfolio
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
Work Experience
Technology Project Developer
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.
Applications Engineer
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.
Internship Trainee - Junior Engineer
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.
Project History
IoT Platform
Complex ETL Pipeline
Database Migration from On-premise to The Cloud
Education
Master's Degree in Big Data and Bussiness Intelligence
EADIC - Madrid, Spain
Master's Degree in Automation and Control Engineering
Pontifical Catholic University of Peru - Lima, Peru
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
Languages
Python, JavaScript, SQL, C++, Python 3, Transact-SQL (T-SQL), Excel VBA
Paradigms
Database Design, ETL
Storage
Microsoft SQL Server, Databases, SQL Server 2016, MongoDB, MySQL, Oracle SQL, Azure SQL, Google Cloud SQL, On-premise, Google Cloud Storage
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
Frameworks
Android SDK
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
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