JLGet in touch

Puebla, MexicoData analytics & automation

JaretLópez Sánchez

I turn complex operational data into reliable reports and faster decisions.

See the work

Open to analytics and automation opportunities

3regions in rollout reporting
2G–5Gtechnologies in the RAN audit
100+sites per inventory review batch
↓

Selected work

Built around real operational problems.

Five projects. Each with the workflow, technical decisions, and a result you can explore.

DESIGN / CURRENT STATEIllustration
2G3G4G5G
One join key.
Every parameter.
SITE ID + CELL + TECHNOLOGY
ParameterDesignInstalled
Transmit power4045 · Alarm
Electrical tilt4NULL · Warning
SectorAA · Match

02 / Telecom data quality

Find the cell. Fix the mismatch.

A bulk audit of client designs against current configurations from Master MAE. Separate checks for 2G, 3G, 4G, and 5G, with the exact parameter behind each alarm.

From fragmented files to cell-level findings
NULL stays distinct from zero and generates a warning.
PythonSQLPandas
View case study Open demo ↗
MASTERTABLE / EXTRACT_INVSample data
100sites compared
9need attention
AU7001 / ReuseDesignInventory
RRU590432 · Review
UBBPd622 · Match
UMPTb111 · Match
Map models → count serials → review differences

03 / Inventory reconciliation

A design is only as good as its inventory.

Reconcile installed equipment with the modernization design. Map model descriptions, deduplicate serial numbers, and focus on differences in reuse, recovery, and scrap.

100+ sites reviewed in a couple of minutes
Reported time for extraction and batch comparison.
ExcelVBALookup formulas
View case study Open demo ↗

Interactive demos use synthetic data. Project notes describe my actual work; customer source files remain private.

About

Engineering discipline.
Applied to data.

Puebla, Mexico · Open to relocation
Advanced English · Native Spanish

I’m a mechatronics engineer working at Huawei México, where operations, data quality, and automation meet.

I graduated from Instituto Politécnico Nacional in 2024. My work starts with understanding a manual process, finding the useful signals in its data, and building a workflow people can rely on.

I’m interested in Data Analyst, Operations Analyst, and Analytics Engineering roles.

Huawei México / Project AssistantIPN / Mechatronics Engineering
AnalysisSQL · Python · Pandas · NumPy
AutomationExcel · VBA · PDF extraction
DomainTelecom operations · RAN · Data quality

Further explorations

Working with AI.

Workflow design

Specialized agents & reusable skills

Role-specific instructions and reusable workflows for technical research, code generation, and quality checks.

LLMs · Python · Custom skills
Proof of concept

A technical knowledge assistant

A natural-language interface for curated SAP and cloud documentation, with source references and implementation guidance.

Python · REST APIs · Knowledge retrieval

Let's connect

Make data
useful.

I’m open to analytics and automation opportunities in Mexico and beyond.

jlopezsan2001@gmail.com