# Juan Pablo Lamas Vera Tudela

Juan Pablo Lamas Vera Tudela is a remote worker on Himalayas, PM Intern at Samsung, based in Peru.

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

```text
PM Intern at SAMSUNG, building SQL Server pricing data pipelines and dashboards for competitive price tracking.
```

| Detail | Value |
| --- | --- |
| Availability | Looking for a job |
| Location | Peru |
| Authorized to work in | Peru, Italy |
| Salary expectations | 60k+ USD |
| Job categories | Business Analyst, Data Analyst, Business Intelligence Analyst, Pricing Analyst |
| Skills | Business Analytics, Pricing Operations, Competitive Intelligence, Marketing Sensing, Trade Promotion Management, Data Governance, Data Quality, Data Pipelines, Data Cleaning, Data Modeling, Business Intelligence, Revenue Analytics, Product Lifecycle Analysis, Sales Reporting, KPI Reporting |

## About

```text
At SAMSUNG, I create SQL Server queries, dictionary tables, and custom views to clean and standardize large pricing datasets. I also develop dashboards that track competitive prices by account and product transitions.

My work at SAMSUNG includes weekly competitive market reports for regional and global headquarters, covering prices, product launches, promotions, and import volumes. I also manage price updates and approvals, and adjust volume-based trade incentives against actual sales.

At GAMMAVET, I designed automated Excel quotation tools and developed commercial reports and dashboards to monitor sales KPIs. I also led the cleaning and standardization of commercial databases for demand analysis.

At FERREYCORP, I automated control and audit reporting and deployed Power BI dashboards using data from Google Cloud Platform. I studied Industrial and Systems Engineering at Universidad de Piura and work with Excel, SQL Server, Power BI, and Python.
```

## Experience

### PM Intern (current)

[Samsung](https://himalayas.app/companies/samsung-electronics). Jan 2026 - Present

```text
Elaborated weekly competitive monitoring reports for regional and global HQ, consolidating price, product launch, and promotional analysis. Designed SQL Server queries and views for data cleaning and standardization, and developed dynamic dashboards for price competitiveness tracking.
```

Skills: SQL-Server, Power-BI, Excel, Python, Pandas, Competitive-Intelligence, Pricing, Data-Governance, Business-Intelligence

### Operator Sales Intern

[Samsung](https://himalayas.app/companies/samsung-electronics). Jan 2025 - Dec 2025

```text
Managed mass pricing loads and updates for all portfolio accounts, ensuring correct discount application through internal approvals. Adjusted trade promotions and audited actual vs. projected units for financial settlement.
```

Skills: Pricing, Trade-Promotion-Management, Data-Quality, SQL, Excel

### Practicante Comercial

Gammavet. Dec 2023 - Nov 2024

```text
Designed automated Excel tools to streamline quotation processes, reducing response times. Led data standardization and cleaning of commercial databases, and developed dynamic reports and dashboards for KPI monitoring.
```

Skills: Excel, Power-BI, Data-Cleaning, KPI-Tracking, Sales-Reporting

### Practicante de Auditoría Interna

Ferreycorp. Dec 2022 - May 2023

```text
Automated control and audit systems for sales, inventory, and overtime areas, drastically reducing report generation times. Deployed Power BI dashboards with data from Google Cloud Platform and trained internal teams on tool usage.
```

Skills: Power-BI, Google-Cloud-Platform, Data-Modeling, Automation, Training

### Practicante Pre-Profesional R.R.H.H.

P.R.C.P. Abogados. Jan 2020 - Apr 2021

```text
Designed a document classification system ensuring 100% traceability in personnel file audits. Developed Excel control matrices for tracking hires, departures, vacations, and internship agreements, and synthesized legal publications for internal newsletters.
```

Skills: Excel, Document-Management, Data-Analysis, Reporting

## Education

### Universidad de Piura

Bachiller en Ingeniería Industrial y de Sistemas, Industrial and Systems Engineering. 2018 - 2025

```text
Pursued a Bachelor's degree in Industrial and Systems Engineering, with relevant coursework in database design, operations design, and quality management.
```

## Tech stack

- Google Cloud Platform
- Pandas
- Python
- Microsoft Excel
- SQL
- Power BI
- Power Query
- SQL Server

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

## People also viewed

- [Sebastián Minaya](https://himalayas.app/@sebastinminaya): Product Analytics Lead, Alegra
- [Adriana Garcia](https://himalayas.app/@adrianagarcia): Semi Senior Business Analyst, Intelica Consulting
- [Pedro TR](https://himalayas.app/@pedrotr): Data Analysis & Business Intelligence Consultant, Resultados Visibles
- [Diana Rojas Romaní](https://himalayas.app/@dianarojasroman): Especialización en Power BI, DMC Perú
- [Rixer Vargas](https://himalayas.app/@rixervargas): Analysta de Data, AFP Integra
- [Nicolas Rodriguez](https://himalayas.app/@nicolasrodriguez2): Practicante Comercial y Operaciones, Prodimin S.A.C.
- [JULIO MENDOZA](https://himalayas.app/@juliomendoza2): Senior BI Developer, MenquisBI
- [Gianmarco Cuneo](https://himalayas.app/@gianmarcocuneo): Data Analyst, Llamabara Tech
- [rick vp](https://himalayas.app/@rickvp): Marketing & Business Analyst, Technova Engineering
- [Marcelo Moreno](https://himalayas.app/@marcelomoreno): Analista de Inteligencia de Negocios, M&M Repuestos y Servicios
