
Jaime Mercado
Verified Expert in Engineering
Data Engineer and Database Developer
Cochabamba, Cochabamba Department, Bolivia
Toptal member since March 9, 2021
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
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
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)
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.
Risks Analytics Assistant Manager
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.
Data Engineer (via Toptal)
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.
Tableau Developer (via Toptal)
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.
Data Engineer
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.
Business Intelligence Assistant Manager
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.
Business Intelligence Executive
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.
Business Intelligence Analyst
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.
Experience
Cohort Analysis to Estimate the Default and Churn in a Bank
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
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
Education
Course in Economics
Private University of Bolivia - La Paz, Bolivia
Master's Degree in Information Systems
Catholic University of Bolivia - La Paz, Bolivia
Specialization in Information Technologies
Catholic University of Bolivia - La Paz, Bolivia
Bachelor's Degree in Systems Engineering
Catholic University of Bolivia - La Paz, Bolivia
Certifications
DAX Functions on Power BI
Datacamp
Python Toolbox
Datacamp
Time Series Analysis
Datacamp
Python Data Science Toolbox
Datacamp
Intermediate Python
Datacamp
Forecasting in R
Datacamp
Unsupervised Learning in R
DataCamp
Cluster Analysis
DataCamp
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
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