Jaime Mercado, Developer in Cochabamba, Cochabamba Department, Bolivia
Jaime is available for hire
Hire Jaime

Jaime Mercado

Verified Expert  in Engineering

Data Engineer and Database Developer

Cochabamba, Cochabamba Department, Bolivia

Toptal member since March 9, 2021

Bio

Jaime is obsessed with data in all forms, including databases, ETL, data warehouses, analytics, visualization, and algorithms. He has worked on projects in the banking industry, customer behavior models, market segmentation, default probability, credit risk models, and report/dashboard design. Jaime excels at collaborating with executives to solve problems, understand the data, and communicate conclusions. Regarding tools, Jaime is an expert in SQL, R, Python, Excel, Power BI, and Tableau.

Portfolio

Latch Systems, Inc.
SQL, Snowflake, Python, Tableau, Looker, APIs
Banco Nacional de Bolivia
R, Microsoft Power BI, Microsoft Excel, Microsoft SQL Server, Python, SQL...
Water UX, Inc
Data Engineering, BigQuery, Redshift, Amazon Athena, Data Pipelines, ETL...

Experience

  • Business Intelligence (BI) - 15 years
  • Databases - 15 years
  • Microsoft Power BI - 10 years
  • Data Engineering - 10 years
  • Analytics - 5 years
  • Tableau - 2 years
  • Snowflake - 2 years
  • Python - 2 years

Availability

Full-time

Preferred Environment

Python, Databases, SQL, Excel 365, Snowflake, PostgreSQL, Apache Airflow, Data Build Tool (dbt), ETL, Analytics

The most amazing...

...thing I've made was a data mart, which included dashboards that obtained marketing insights, performed simulations, and generated market predictions in banking.

Work Experience

Data Engineer (via Toptal)

2024 - 2024
Latch Systems, Inc.
  • Migrated dashboards from Looker to Tableau and built data sources and database models.
  • Developed dbt models to transform, clean, and present data to final users, including tests and data validation.
  • Collected metadata from Fivetran, dbt, and Tableau using their APIs. Analyzed data pipelines, transformations, and dashboard usage. Provided insights into data costs, usage patterns, and optimization opportunities.
Technologies: SQL, Snowflake, Python, Tableau, Looker, APIs

Risks Analytics Assistant Manager

2016 - 2024
Banco Nacional de Bolivia
  • Developed an early warning system for credit risk and operational risk.
  • Created an algorithm to calculate expected and unexpected losses for credit risk.
  • Developed predictive models, Monte Carlo simulations, and stress tests.
  • Constructed a multidimensional cohort analysis tool.
  • Developed Power BI reports presenting results and findings for the end user.
  • Designed dynamic visualization tools implementing complex DAX formulas in Power BI.
Technologies: R, Microsoft Power BI, Microsoft Excel, Microsoft SQL Server, Python, SQL, Data Visualization, Visual Basic, Excel Macros

Data Engineer (via Toptal)

2022 - 2023
Water UX, Inc
  • Developed Airflow DAGs, ETL, and pipelines to collect advanced metering infrastructure (AMI) data.
  • Architected Python scripts to collect data from the Beacon API data provider.
  • Designed database architecture in Snowflake and PostgreSQL.
Technologies: Data Engineering, BigQuery, Redshift, Amazon Athena, Data Pipelines, ETL, Apache Airflow, Snowflake

Tableau Developer (via Toptal)

2022 - 2022
Vella Bioscience, Inc
  • Architected sales and customer analytics dashboards using Tableau.
  • Developed ETLs between the Shopify API and PostgreSQL database.
  • Focused on Amazon EC2 and RDS management and configuration.
Technologies: Tableau, Data Visualization, Python, PostgreSQL, APIs

Data Engineer

2021 - 2022
StackBoost LLC
  • Developed a system to collect data from data sources, such as CSV, XLS, and PDF, shared over the cloud. I used APIs to extract data.
  • Coded the system in Python and PostgreSQL, developed the ETLs, and designed data structures and databases.
  • Created automation integrating services from many data providers, such as Dropbox, Docparser, and Retool.
  • Developed dashboards using Tableau, the final output for the end-user.
Technologies: Python, PostgreSQL, Tableau, Databases, APIs, ETL, Data Engineering, Pandas

Business Intelligence Assistant Manager

2014 - 2016
Banco de Crédito de Bolivia
  • Developed predictive models to estimate people's salaries.
  • Optimized marketing campaigns through the integration of CRM and databases.
  • Increased loan sales by performing strategies through the CRM and sales team.
  • Developed sales funnel and performance KPIs dashboards in Power BI.
Technologies: R, Microsoft Dynamics, Microsoft Excel, Microsoft SQL Server, Excel VBA, SQL, Data Visualization, Visual Basic, Excel Macros, Data Modeling, Business Intelligence (BI), Microsoft Power BI

Business Intelligence Executive

2010 - 2014
Banco Nacional de Bolivia
  • Developed KPIs for sales and loans and designed Power BI dashboards to present the KPIs' evolution and forecast.
  • Automated reports and dashboards to be emailed regularly.
  • Redesigned the ETLs by improving processing time and data quality.
Technologies: Microsoft SQL Server, Microsoft Excel, Excel VBA, SQL, Data Visualization, Visual Basic, Excel Macros, Data Modeling, Business Intelligence (BI), Microsoft Power BI

Business Intelligence Analyst

2006 - 2010
Banco de Crédito de Bolivia
  • Designed marketing data mart models, ETL process cubes, and reports, including dashboards and visualizations for decision support.
  • Created an algorithm for clients segmentation, as result of this the bank was capable to identify profitable segments for targeted marketing campaigns.
  • Automated the process for the CRM administration, connecting many databases and other non-structured data to finally consolidate customers and sales data in one, making the process twice faster.
Technologies: Microsoft SQL Server, Microsoft Excel, Excel VBA, SQL, ETL, Data Visualization, Visual Basic, Excel Macros, Data Modeling, Databases, Business Intelligence (BI), Data Warehousing

Experience

Cohort Analysis to Estimate the Default and Churn in a Bank

A multidimensional model to evaluate the behavior of the default and churn in the past years, grouping clients from different years, segments, and products and the result was a dashboard showing different plots to have a better understanding of the cohorts and their evolution over time.

By implementing this model the bank could estimate profitability for all segments and products, also this produces inputs for the other predictive models.

Bussines Intelligence and Data Mart for Marketing

I implemented the whole business intelligence process, including data collection, data mart modeling, reports, and dashboards. The main objective was to generate targeted campaigns for the sales teams, including lists of potential clients. I also created reports and dashboards for the managers to monitor the sales team's achievements.
For the end user, I developed many reports showing the main KPIs and sales funnel and providing aggregated and detailed views.

Models for Expected and Unexpected Losses Applied to Banks

I developed two models to calculate a bank's expected and unexpected losses: a logistic regression model and a Monte Carlo simulation model and by implementing two different approaches, we could validate and compare the results of each model, which were presented in a Power BI visualization.

Education

2014 - 2015

Course in Economics

Private University of Bolivia - La Paz, Bolivia

2012 - 2013

Master's Degree in Information Systems

Catholic University of Bolivia - La Paz, Bolivia

2010 - 2011

Specialization in Information Technologies

Catholic University of Bolivia - La Paz, Bolivia

2000 - 2005

Bachelor's Degree in Systems Engineering

Catholic University of Bolivia - La Paz, Bolivia

Certifications

JUNE 2023 - PRESENT

DAX Functions on Power BI

Datacamp

SEPTEMBER 2022 - PRESENT

Python Toolbox

Datacamp

FEBRUARY 2021 - PRESENT

Time Series Analysis

Datacamp

DECEMBER 2020 - PRESENT

Python Data Science Toolbox

Datacamp

OCTOBER 2020 - PRESENT

Intermediate Python

Datacamp

SEPTEMBER 2020 - PRESENT

Forecasting in R

Datacamp

JANUARY 2020 - PRESENT

Unsupervised Learning in R

DataCamp

MARCH 2018 - PRESENT

Cluster Analysis

DataCamp

JANUARY 2018 - PRESENT

Credit Risk Modeling in R

DataCamp

Skills

Libraries/APIs

Pandas

Tools

Microsoft Excel, Power Query, Microsoft Power BI, Tableau, ARIMA, Microsoft Dynamics, Apache Airflow, Looker, BigQuery, Amazon Athena

Languages

Excel VBA, SQL, Visual Basic, R, Snowflake, Python

Paradigms

Business Intelligence (BI), ETL

Storage

Microsoft SQL Server, Databases, PostgreSQL, Redshift, Data Pipelines

Platforms

Windows, RStudio

Industry Expertise

Marketing

Other

Reporting, Cohort Analysis, Data, Excel Macros, DAX, Data Warehouse Design, Visualization, Analytics, Risk Models, Data Architecture, Data Visualization, Data Modeling, Data Warehousing, Engineering Software, Algorithms, Data Mining, Team Management, Finance, Econometrics, Monte Carlo Simulations, Forecasting, Statistics, Time Series, Autoregressive Models, APIs, Data Engineering, Excel 365, Data Build Tool (dbt), Product Management

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