
Jaime Mercado
Verified Expert in Engineering
Database Developer
Jaime is obsessed with data in all forms, including databases, ETL, data warehouses, analytics, and algorithms. He's worked on projects in the banking industry, customer behavior models, market segmentation, default probability, credit risk models, and the design of reports/dashboards. Jaime excels at collaborating with executives to solve problems, understand the data, and communicate conclusions. Concerning tools, Jaime is an expert in SQL, R, Python, Excel, Power BI, and Tableau.
Portfolio
Experience
Availability
Preferred Environment
Windows, Microsoft SQL Server, Microsoft Excel, Excel VBA, Microsoft Power BI, Tableau, R, Python, Databases, Business Intelligence (BI)
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
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.
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.
Business Intelligence Executive
Banco Nacional de Bolivia
- Developed KPIs for sales and loans and designed 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
Models for Expected and Unexpected Losses Applied to Banks
Skills
Languages
Excel VBA, SQL, Visual Basic, R, Snowflake, Python
Tools
Microsoft Excel, Microsoft Power BI, Tableau, Microsoft Dynamics
Paradigms
Business Intelligence (BI), ETL
Storage
Microsoft SQL Server, Databases, PostgreSQL
Other
Reporting, Cohort Analysis, Data, Excel Macros, 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, ARIMA, Autoregressive Models, APIs, Data Engineering
Libraries/APIs
Pandas
Platforms
Windows, RStudio
Industry Expertise
Marketing
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
Time Series Analysis
Datacamp
Python Data Science Toolbox
Datacamp
Intermediate Python
Datacamp
Introduction to Python
Datacamp
Forecasting in R
Datacamp
Unsupervised Learning in R
DataCamp
Cluster Analysis
DataCamp
Introduction to Data in R
DataCamp
Foundations of Probability in R
DataCamp
Credit Risk Modeling in R
DataCamp
Intermediate R
DataCamp
Introduction to R
DataCamp
Data Manipulation in R with Dplyr
DataCamp