# Enrique Lopez Zatarain

Enrique Lopez Zatarain is a remote worker on Himalayas, Financial Analyst at HP Inc., based in Mexico.

Source: https://himalayas.app/@enriquelopezzatarain

```text
Financial Analyst at HP Inc. who automated LATAM close reporting and supported the global Purple / CASApp finance transformation.
```

| Detail | Value |
| --- | --- |
| Availability | Looking for a job |
| Location | Mexico |
| Authorized to work in | Mexico |
| Salary expectations | 872k+ MXN |
| Job categories | Financial Analyst, FP&A Analyst |
| Skills | Financial Planning And Analysis, Month End Closing, Month Quarter Year End Close, Accruals, SGA Reserves, MDF Reserves, P&L Analysis, Variance Analysis, Forecasting, Budget Tracking, Account Reconciliation, Internal Controls, Executive Reporting, Data Storytelling, Process documentation |
| LinkedIn | https://linkedin.com/in/enrique-lopez-zatarain |

## About

```text
At HP Inc., I rebuilt reporting packages for three LATAM sub-regions using Power Query and Power Pivot, cutting the month-end reporting cycle. I also automated recurring close reports with VBA macros and refreshable models that became the team standard.

I calculate and reconcile SGA and MDF reserves, analyze P&L variances, and present cost exposure to Finance managers and directors. I also supported the global Purple / CASApp finance transformation by translating requirements into test scenarios and validating calculation logic.
```

## Experience

### Financial Analyst (current)

[HP Inc.](https://himalayas.app/companies/hp). Nov 2024 - Present

```text
Owned month-end close, SGA/MDF reserve calculations, and P&L analysis across 3 LATAM sub-regions. Automated reporting with Power Query, Power Pivot, and Power BI, cutting reporting cycle time and manual hours.
```

Skills: FP&A, Month-End-Closing, SGA, MDF, P&L-Analysis, Power-Query, Power-Pivot, Power-BI, VBA, SAP, Business-Objects-Web-Intelligence, Excel, DAX, Python, SQL

### Finance Intern

[HP Inc.](https://himalayas.app/companies/hp). Nov 2023 - Oct 2024

```text
Standardized Excel templates and SAP refresh routines for Peripherals P&L, improving on-time delivery of reporting packages. Automated data pulls with Power Query to reduce errors and rework.
```

Skills: Excel, SAP, Power-Query, P&L-Analysis, Report-Automation

### Data & Administrative Analyst

CIADES – CUCEA, Universidad de Guadalajara. Sep 2022 - Apr 2023

```text
Designed Excel and Google Sheets databases to cut manual consolidation time and presented statistical results supporting unit-level decisions.
```

Skills: Excel, Google-Sheets, Data-Analysis, Statistical-Analysis

## Education

### Universidad de Guadalajara

Bachelor of Science, Financial Management and Systems. Grade: 4.0/4.0

```text
Bachelor of Science in Financial Management and Systems with a perfect GPA of 4.0/4.0.
```

## Tech stack

- Pandas
- Python
- Google Sheets
- SQL
- Power BI

To contact Enrique, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [OSCAR ALVARADO](https://himalayas.app/@oscaralvarado): FP&A Analyst, Johnson Controls
- [Diego Puga](https://himalayas.app/@diegopuga): Finance Analyst, Altimetrik
- [Jose Rey](https://himalayas.app/@joserey): FP&A Supervisor, Victaulic
- [Erick Zavala](https://himalayas.app/@erickzavala): Accountant / Audit, Paradigm Mexico
- [Eduardo Villalobos](https://himalayas.app/@eduardovillalobos): Business Planning Analyst, Philip Morris International
- [Emilio Gutiérrez](https://himalayas.app/@emiliogutirrez): Financial Analyst, Kiewit Mexico
- [Diego Sanchez](https://himalayas.app/@diegosanchez): RTR Accountant , IFF
- [eric serafin](https://himalayas.app/@ericserafin): FP&A Specialist – Financial Controlling, CADU Inmobiliaria
- [Edson Navarro](https://himalayas.app/@edsonnavarro): Finance Analyst Europe, FRAM Group Services de México S.A. de C.V.
- [Erendira Marin](https://himalayas.app/@erendiramarin1): Senior Financial & Risk Analyst, HP Inc.
