Alvaro Parra, Developer in La Paz, La Paz Department, Bolivia
Alvaro is available for hire
Hire Alvaro

Alvaro 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 Warehouse...
PROS
Azure Design, Databricks, Data Engineering, SQL, Reports, Data Analysis...
Banco FIE
Business Intelligence Development, SQL, Data Engineering, Python, Reports...

Experience

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 Warehouse, Azure Design, Excel Development, APIs, Business Intelligence Consultant, Star Schema, SQL, SQL, Apache Airflow, Data Engineering, 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 Science, Database, Data Validation, Data Structures, Automated Data Flows, Cloud Migration, Solution Architecture, Database, 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 Design, Databricks, Data Engineering, SQL, Reports, Data Analysis, Data Modeling, Data Warehouse, Data Science, Snowflake, ETL, Business Intelligence Development, Azure Data Factory, SQL, SQL Server, Python, Database, Web Scraping, Database, Pipelines, Pandas, Big Data Architecture, Big Data Architecture, PySpark, Azure, Excel Development, APIs, Business Intelligence Consultant, Star Schema, SQL, SQL, MySQL, Stored Procedure, ELT, CSV, CSV Export, Data Extraction, Scripting, Data Build Tool (dbt), Database Design, Data Integration, Data Migration, Performance Tuning, SQL, T-SQL, ETL Tools, Oracle Development, Entity Relationships, Data Science, Database, Data Validation, Data Structures, Automated Data Flows, Data Architecture, Architecture, Data Lakes, Solution Architecture, Amazon 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: Business Intelligence Development, SQL, Data Engineering, Python, Reports, Data Modeling, Data Warehouse, Data Science, ETL, Data Marts, SQL Server, Business Intelligence Development, Data Analysis, Database, Web Scraping, Database, Pipelines, Pandas, PostgreSQL, Excel Development, APIs, Business Intelligence Consultant, Data Management, Data Analysis Consulting, Star Schema, SQL, SQL, SQL, MySQL, Stored Procedure, CSV, CSV Export, Data Extraction, Scripting, Database Design, Data Integration, Data Migration, Performance Tuning, SQL, T-SQL, ETL Tools, Oracle Development, Entity Relationships, Data Science, Database, 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, MySQL, SQL, Data Modeling, Database, Python, ETL, Data Marts, SQL Server, Business Intelligence Development, Data Engineering, Database, Data Science, Pipelines, Pandas, Excel Development, APIs, Star Schema, SQL, SQL, SQL, MySQL, Stored Procedure, PL/SQL, CSV, CSV Export, Data Extraction, Scripting, Database Design, Data Integration, Data Migration, Performance Tuning, SQL, T-SQL, ETL Tools, Entity Relationships, Database, 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 Development, Data Modeling, Data Warehouse, Database, Data Science, Data Engineering, Pipelines, ETL, Data Marts, SQL Server, Python, Data Analysis, Database, Database Migration, Dashboard, Excel Development, APIs, Business Intelligence Consultant, Data Management, Data Analysis Consulting, Star Schema, SQL, SQL, SQL, MySQL, Stored Procedure, PL/SQL, CSV, CSV Export, Data Extraction, Scripting, Database Design, Data Integration, Data Migration, Performance Tuning, SQL, T-SQL, ETL Tools, Entity Relationships, Data Structures, Automated Data Flows

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.

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.
2008 - 2013

Bachelor's Degree in Computer Science

Universidad Mayor de San Andrés - La Paz, Bolivia

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

Libraries/APIs

PySpark, Pandas

Tools

Apache Airflow, Excel Development, Business Intelligence Development, Azure Kubernetes Service (AKS), AWS Glue

Languages

SQL, Python, Snowflake, Stored Procedure, T-SQL

Paradigms

ETL, Business Intelligence Development, Database Design

Storage

Database, SQL, Data Validation, SQL Server, SQL Server, Database, Database Migration, PostgreSQL, SQL, SQL, MySQL, Data Integration, SQL, Oracle Development, Data Lakes, Amazon S3, SQL, MySQL, PL/SQL, Database, Redshift

Platforms

Databricks, Azure Design, Azure Synapse, AWS, AWS Lambda

Frameworks

Big Data Architecture

Other

Data Engineering, Data Analysis, Data Warehouse, Business Intelligence Consultant, Data Management, Star Schema, CSV, CSV Export, Data Extraction, Automated Data Flows, Reports, Data Modeling, Data Science, Pipelines, APIs, Azure, Data Analysis Consulting, ELT, Scripting, Data Build Tool (dbt), Data Migration, Performance Tuning, ETL Tools, Entity Relationships, Data Science, Data Structures, Data Entry, Architecture, Cloud Migration, Solution Architecture, Azure Data Factory, Data Marts, Web Scraping, Big Data Architecture, Dashboard, Data Visualization, Financial Reporting, Database, 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