NELSON LÓPEZ PACHECO
Carolina
Summary
Results-driven Senior Economist with 20+ years of experience at the Puerto Rico Department of Treasury, specializing in economic forecasting, fiscal policy analysis, and financial data management. Expert in extracting and modeling large-scale datasets using SQL and BI tools (QlikView, Power BI, Tableau), with a strong record of translating complex data into clear, actionable insights for senior decision-makers. Bilingual (English/Spanish), highly analytical, and committed to continuous innovation in data-driven environments.
Overview
27
27
years of professional experience
1
1
Certification
Work History
Economic & Financial Affairs — Principal Economist
Department of Treasury of Puerto Rico
San Juan, PR
09.2006 - Current
- Spearheaded development of economic forecasting models for Puerto Rico's Sales & Use Tax (IVU), leveraging macroeconomic indicators and consumption data to improve revenue prediction accuracy.
- Engineered and maintained advanced SQL scripts for large-scale financial database processing and validation, ensuring data integrity across critical fiscal systems.
- Built perpetual inventory models to estimate capital stock and depreciation, integrating national accounts and survey data into official statistical frameworks.
- Conducted fiscal impact analyses on legislative tax proposals, delivering economic advisories that directly informed senior government officials' decisions.
- Designed interactive QlikView dashboards and visual reports, enabling real-time tracking of key fiscal indicators for executive leadership.
- Authored official revenue reports by NAICS classification and statistical publications on taxation and financial performance.
- Coordinated cross-agency databases with the Planning Board, Department of Labor, and DDEC to consolidate and maintain national-level economic data.
- Drafted technical reports documenting methodologies, assumptions, and sensitivity analyses for fiscal policy evaluation.
Economist
Department of Treasury of Puerto Rico
San Juan, PR
04.1999 - 09.2006
- Managed routine cash flow and debt data to support budget forecasting and liquidity planning for the Commonwealth.
- Conducted macroeconomic and fiscal analyses to support public revenue tracking and strategic planning initiatives.
- Assisted senior economists in trend analysis, tax collection modeling, and policy evaluation.
- Prepared reports and presentations for legislative and executive audiences, enhancing communication of complex economic findings.
Student Teacher — Economics
University of Puerto Rico
San Juan, PR
02.1999 - 05.1999
- Tutored undergraduate students in economic theory, quantitative methods, and data interpretation.
Education
M.A. - Economics
University of Puerto Rico
San Juan, PRB.A. - Economics
University of Puerto Rico
San Juan, PRundefined
Illinois State University
Skills
- SQL (Advanced Querying)
- Economic Forecasting
- Fiscal Impact Analysis
- Economic Modeling
- Statistical Analysis
- R Stata Excel
- Data Visualization
- QlikView Power BI
- Tableau
- Data Management & Warehousing
- Econometric Modeling
- Market Monitoring
- Policy Analysis
- Stakeholder Engagement
- Executive Reporting
Certification
- 21 Day Course in Emotional Intelligence
- Business Intelligence with QlikView – 0 to Full Sales App
- Fundamentals of Business Analysis
- Introduction to Microsoft Excel 2010
- Microsoft Excel – Formulas and Advanced Functions in Excel
- Microsoft Excel Applied to Finance / Financial Excel
- Microsoft Excel Pivot Tables – Beginner to Advanced
- MO-210 Prep: Microsoft Excel (Beginner to Intermediate)
- Excel Course – Formulas, Pivot Tables and Dashboards
- Optimization with SQL & Tableau
- Power BI Masterclass from Scratch in 90 Minutes (2025)
- B.A. & M.A. Full Academic Transcript – University of Puerto Rico
- Exchange Program in Economics Transcript – Illinois State University
LANGUAGES
English — Fluent
Spanish — Native
Timeline
Economic & Financial Affairs — Principal Economist
Department of Treasury of Puerto Rico
09.2006 - Current
Economist
Department of Treasury of Puerto Rico
04.1999 - 09.2006
Student Teacher — Economics
University of Puerto Rico
02.1999 - 05.1999
B.A. - Economics
University of Puerto Rico
undefined
Illinois State University
M.A. - Economics
University of Puerto Rico
PUBLICATION
López Pacheco, N. (2007). Estimation of a Money Demand Equation for Puerto Rico.
KEY STRENGTHS
- Problem Solving
- Leadership & Mentorship
- Adaptability
- Continuous Learning
- Integrity & Professionalism
KEY ACHIEVEMENTS
- 20+ years at Puerto Rico Treasury
- Advanced SQL expertise large financial databases
- QlikView dashboards for executive decision-making
- Published economist M.A. thesis — UPR honors