Skip to main content
JT
Looking for a job

Juan Pablo Lamas Vera Tudela

@juanpablolamasveratu

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

Peru
Message

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

Work history, roles, and key accomplishments

Samsung logoSA

Operator Sales Intern

Jan 2025 - Dec 2025 (11 months)

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.

Pricing
Trade Promotion Management
Data QualitySQLExcel
GA

Practicante Comercial

Gammavet

Dec 2023 - Nov 2024 (11 months)

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.

Ferreycorp logoFE

Practicante de Auditoría Interna

Ferreycorp

Dec 2022 - May 2023 (5 months)

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.

PA

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

P.R.C.P. Abogados

Jan 2020 - Apr 2021 (1 year 3 months)

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.

ExcelDocument Management
Data Analysis
Reporting

Education

Degrees, certifications, and relevant coursework

Universidad de Piura logoUP

Universidad de Piura

Bachiller en Ingeniería Industrial y de Sistemas, Industrial and Systems Engineering

2018 - 2025

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

Availability

Looking for a job

Location

Peru

Authorized to work in

Salary expectations

60k+ USD

Interested in hiring Juan Pablo?

You can contact Juan Pablo and 600K+ other talented remote workers on Himalayas.

Message Juan Pablo

People also viewed

View all talent

Get matched with your dream remote job

Sign up now and join over 1,000,000+ remote workers who receive personalized job alerts, curated job matches, and more for free!

Sign up
Himalayas profile for an example user named Frankie Sullivan