Alvaro is available for hire
Hire AlvaroAlvaro Parra
Verified Expert in Engineering
Data Engineer and Developer
La Paz, La Paz Department, Bolivia
Toptal member since July 16, 2021
Bio
Alvaro is a data engineer with over seven years of experience working on ETL pipelines and databases. He is a certified MCSA SQL database developer with expertise in Azure, Databricks, Python, Airflow, and Snowflake. Alvaro has engineered data solutions for banking, credit card, pharmaceutical marketing, and oil companies. His work has significantly increased revenue, cut expenses, and reduced processing times.
Portfolio
Precision Drilling
Python, SQL, ETL, Snowflake, Azure Kubernetes Service (AKS), Data Warehousing...
PROS
Azure, Databricks, Data Engineering, SQL, Reports, Data Analysis, Data Modeling...
Banco FIE
Microsoft Power BI, SQL, Data Engineering, Python, Reports, Data Modeling...
Experience
- Data Engineering - 6 years
- Python - 5 years
- Snowflake - 5 years
- Data Migration - 5 years
- Data Modeling - 4 years
- Apache Airflow - 4 years
- Data Build Tool (dbt) - 3 years
- Database Migration - 3 years
Availability
Part-time
Preferred Environment
Azure Data Factory, Azure, Snowflake, Apache Airflow, Data Build Tool (dbt), Python, Azure SQL
The most amazing...
...project I've worked on processes credit and debit card use at a bank's ATMs. It has enabled the company to gain a competitive advantage.
Work Experience
Data Engineer
2021 - 2023
Precision Drilling
- Implemented data quality pipelines for detecting, fixing, and alerting possible issues, reducing data anomalies by 20% using Azure, Snowflake and Apache Airflow.
- Automated backfill pipelines on Snowflake, Python, and dbt for solving data streaming-related issues. This pipeline reduced manual workload by 30% per month.
- Designed a pipeline infrastructure on Snowflake, Python, and Apache Airflow for extracting and ingesting SAP API information. This improved upload time by 20%.
- Deployed an ETL pipeline on Python, Snowflake, and Azure for cleaning duplicate table records. This process runs monthly, and it usually affects 2-5% of the totality of records.
- Optimized five source data pipeline architectures on Python, Snowflake, and Apache Airflow to yield a 30% improvement in data processing speed.
Technologies: Python, SQL, ETL, Snowflake, Azure Kubernetes Service (AKS), Data Warehousing, Azure, Microsoft Excel, APIs, Business Intelligence Consultant, Star Schema, SQL Stored Procedures, SQL Performance, Apache Airflow, Data Engineering, Amazon Web Services (AWS), Stored Procedure, ELT, CSV, CSV Export, Data Extraction, Scripting, Data Build Tool (dbt), Database Design, Data Integration, Data Migration, Performance Tuning, ETL Tools, Data Governance, Database Security, Data Validation, Data Structures, Automated Data Flows, Cloud Migration, Solution Architecture, Data Pipelines, Pipelines
Data Engineer
2019 - 2021
PROS
- Worked with 30+ customers on designing and implementing pipelines for transforming customer information into XML that could be digested by the PROS system by using Azure Data Factory, Databricks, Pyspark, and Python.
- Ingested data from multiple data sources using a combination of AWS, SQL, Salesforce API, and Python to create data views to be used in Power BI and SSRS.
- Automated data extraction using Azure, Apache Airflow, Snowflake, and Python solution for a PROS customer that required integration of his system with PROS data. This reduced manual workload by 20% monthly.
- Created a Python/Pyspark library to reformat and export data from external customers to fit the PROS system format. This saved five hours of coding time per new pipeline.
- Improved and maintained 20% of data infrastructure for different PROS customers in Azure.
Technologies: Azure, Databricks, Data Engineering, SQL, Reports, Data Analysis, Data Modeling, Data Warehousing, Data Analytics, Snowflake, ETL, Microsoft Power BI, Azure Data Factory, Azure SQL, Microsoft SQL Server, Python, Data Pipelines, Web Scraping, Databases, Pipelines, Pandas, Apache Spark, Big Data, PySpark, Azure Data Lake, Microsoft Excel, APIs, Business Intelligence Consultant, Star Schema, SQL Stored Procedures, SQL Performance, MySQL Server, Stored Procedure, ELT, CSV, CSV Export, Data Extraction, Scripting, Data Build Tool (dbt), Database Design, Data Integration, Data Migration, Performance Tuning, Dynamic SQL, T-SQL (Transact-SQL), ETL Tools, Oracle PL/SQL, Entity Relationships, Data Governance, Database Security, Data Validation, Data Structures, Automated Data Flows, Data Architecture, Architecture, Data Lakes, Solution Architecture, Amazon S3 (AWS S3), Redshift, AWS Glue, AWS Lambda
Data Management Analyst
2016 - 2019
Banco FIE
- Automated marketing ETL pipelines by using Python and Microsoft SQL Server and saved 30% of the manual effort.
- Deployed an ETL pipeline to scrape data from a weather API using Python and join it with data from bank branches to help discover branch transactions relative to weather. The bank saved 12% in operating costs by changing the number of cashiers.
- Collaborated with consultants to Rabobank (a Dutch bank) in segmentation and high-value customer and mobile app usability projects by creating Python and Microsoft SQL Server ETL pipelines to extract and process customer data.
- Deployed an ETL pipeline on Python and Microsoft SQL Server that processed debit card information to help discover the bank’s ATM usage and saved 10% on ATM maintenance costs by relocating unused ATMs.
- Automated data pipelines in Python and SQL to process customers' financial information for selling credit cards, resulting in a 35% increase in credit card sales in the first month.
Technologies: Microsoft Power BI, SQL, Data Engineering, Python, Reports, Data Modeling, Data Warehousing, Data Analytics, ETL, Data Marts, Microsoft SQL Server, Business Intelligence (BI), Data Analysis, Data Pipelines, Web Scraping, Databases, Pipelines, Pandas, PostgreSQL, Microsoft Excel, APIs, Business Intelligence Consultant, Data Management, Data Analysis Consultant, Star Schema, SQL Triggers, SQL Stored Procedures, SQL Performance, MySQL Server, Stored Procedure, CSV, CSV Export, Data Extraction, Scripting, Database Design, Data Integration, Data Migration, Performance Tuning, Dynamic SQL, T-SQL (Transact-SQL), ETL Tools, Oracle PL/SQL, Entity Relationships, Data Governance, Database Security, Data Validation, Data Structures, Data Entry, Automated Data Flows
Database Administrator
2015 - 2016
Administradora de Tarjetas de Credito ATC
- Developed and designed ETL pipelines on SSIS to help reduce debit and credit card fraud, increasing fraudulent debit card detection by 7%.
- Deployed an ETL using Python for processing monthly debit and credit card information sent to affiliated banks and reduced processing time by 30%.
- Migrated a 250GB data warehouse, including stored procedures and ETLs, from Microsoft SQL Server to Azure SQL.
Technologies: SQL Server Reporting Services (SSRS), MySQL, SQL, Data Modeling, Databases, Python, ETL, Data Marts, Microsoft SQL Server, Business Intelligence (BI), Data Engineering, Data Pipelines, Data Analytics, Pipelines, Pandas, Microsoft Excel, APIs, Star Schema, SQL Triggers, SQL Stored Procedures, SQL Performance, MySQL Server, Stored Procedure, PL/SQL, CSV, CSV Export, Data Extraction, Scripting, Database Design, Data Integration, Data Migration, Performance Tuning, Dynamic SQL, T-SQL (Transact-SQL), ETL Tools, Entity Relationships, Database Security, Data Validation, Data Structures, Automated Data Flows
Business Intelligence Developer
2014 - 2015
Grupo Alcos
- Deployed marketing ETL on SSIS that processes information from OLTP databases to analyze product consumption, resulting in a 15% increase in top product sales.
- Developed and migrated multiple dashboards from Excel to QlikView and reduced manual effort by 50%.
- Migrated a 100GB data warehouse including stored procedures and ETLs from Informix to Microsoft SQL Server.
Technologies: MySQL, SQL, Business Intelligence (BI), Data Modeling, Data Warehousing, Databases, Data Analytics, Data Engineering, Pipelines, ETL, Data Marts, Microsoft SQL Server, Python, Data Analysis, Data Pipelines, Database Migration, Dashboards, Microsoft Excel, APIs, Business Intelligence Consultant, Data Management, Data Analysis Consultant, Star Schema, SQL Triggers, SQL Stored Procedures, SQL Performance, MySQL Server, Stored Procedure, PL/SQL, CSV, CSV Export, Data Extraction, Scripting, Database Design, Data Integration, Data Migration, Performance Tuning, Dynamic SQL, T-SQL (Transact-SQL), ETL Tools, Entity Relationships, Data Structures, Automated Data Flows
Experience
Dashboard for Pharmaceutical Marketing Department
I collaborated with the marketing team in a pharmaceutical company to extract information and build a dashboard to visualize, analyze, and increase sales.
PROBLEM
Employees were trying to process and analyze millions of sales on Excel spreadsheets, which was time-consuming and error-prone. The marketing manager requested a solution that could optimize and improve the process.
SOLUTION
We started by designing a data warehouse to extract information from the company's selling system. To store that information, we bought a server and installed a Microsoft SQL Server database. Next, we installed Pentaho Kitchen on another server and developed ETL pipelines to process information.
Once the design was stable, we began work on the visualization tool. We had QlikView at that time, so that's how we started developing the visualization portion. The new dashboard had a significant impact, as processes that had taken hours were done in a matter of minutes. It allowed us to measure each agency's sales and provide information to improve overall company sales.
PROBLEM
Employees were trying to process and analyze millions of sales on Excel spreadsheets, which was time-consuming and error-prone. The marketing manager requested a solution that could optimize and improve the process.
SOLUTION
We started by designing a data warehouse to extract information from the company's selling system. To store that information, we bought a server and installed a Microsoft SQL Server database. Next, we installed Pentaho Kitchen on another server and developed ETL pipelines to process information.
Once the design was stable, we began work on the visualization tool. We had QlikView at that time, so that's how we started developing the visualization portion. The new dashboard had a significant impact, as processes that had taken hours were done in a matter of minutes. It allowed us to measure each agency's sales and provide information to improve overall company sales.
Airgas | Multiple Reports for PROS
I assisted in building financial reports for customer consumption. The reports were simple, but most had heavy queries behind them. I solved many issues related to the query logic and built financial reports based on that logic.
Union Pacific | Complex SSRS Reports for PROS
I built complex reports, including one that would be exported from SSRS into Excel to generate multiple Excel spreadsheets. I developed the report structure, created the queries that would extract the data, and collaborated with the customer to follow up and add last-minute updates.
Education
2008 - 2013
Bachelor's Degree in Computer Science
Universidad Mayor de San Andrés - La Paz, Bolivia
Certifications
MAY 2022 - PRESENT
Azure Data Engineer Associate
Microsoft
SEPTEMBER 2021 - PRESENT
DP-900: Microsoft Azure Data Fundamentals
Microsoft
NOVEMBER 2019 - PRESENT
MCSA: SQL 2016 Database Development
Microsoft
Skills
Libraries/APIs
PySpark, Pandas
Tools
Apache Airflow, Microsoft Excel, Microsoft Power BI, Azure Kubernetes Service (AKS), AWS Glue
Languages
SQL, Python, Snowflake, Stored Procedure, T-SQL (Transact-SQL)
Paradigms
ETL, Business Intelligence (BI), Database Design
Storage
Databases, SQL Stored Procedures, Data Validation, SQL Server Reporting Services (SSRS), Microsoft SQL Server, Data Pipelines, Database Migration, PostgreSQL, SQL Triggers, SQL Performance, MySQL Server, Data Integration, Dynamic SQL, Oracle PL/SQL, Data Lakes, Amazon S3 (AWS S3), Azure SQL, MySQL, PL/SQL, Database Security, Redshift
Platforms
Databricks, Azure, Azure Synapse, Amazon Web Services (AWS), AWS Lambda
Frameworks
Apache Spark
Other
Data Engineering, Data Analysis, Data Warehousing, Business Intelligence Consultant, Data Management, Star Schema, CSV, CSV Export, Data Extraction, Automated Data Flows, Reports, Data Modeling, Data Analytics, Pipelines, APIs, Azure Data Lake, Data Analysis Consultant, ELT, Scripting, Data Build Tool (dbt), Data Migration, Performance Tuning, ETL Tools, Entity Relationships, Data Governance, Data Structures, Data Entry, Architecture, Cloud Migration, Solution Architecture, Azure Data Factory, Data Marts, Web Scraping, Big Data, Dashboards, Data Visualization, Financial Reporting, Data Queries, Azure Databricks, Data Architecture
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.
1
Share your needs
Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2
Choose your talent
Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3
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