Sebastian López Medina

Sebastian López Medina

Data Strategist.
Turning complex data into stories that drive decisions.

Lima, Peru

Open to roles and startup ventures, let's talk

A bit about me

I'm a Data Strategist with a thing for turning messy, complex data into something that actually moves the needle. My work spans the full data lifecycle: from building automated ETL pipelines to crafting analytical platforms that help teams make smarter calls.

I've had the chance to work across both Energy and CPG (currently at Nestle), where I've gotten pretty good at bridging the gap between what the business needs and what the tech can deliver. Along the way, I've automated market intelligence workflows processing over 150 million records and built platforms that cut strategic analysis time by 90%.

Right now I'm wrapping up my MSc in Data Science & AI at UTEC and applying my skills in Python, cloud platforms (Azure, Databricks, Snowflake, AWS, GCP), and the whole Power Platform ecosystem. I genuinely enjoy cracking hard problems and helping teams get to the insights that matter.

My Journey

MIT GTL AI
Jan 2026
1st Place

MIT Global Teaching Labs (GTL) AI Workshop

MIT MISTI & UTEC

  • "Qhali Ayllu" Project: Multimodal Android platform for Anemia and Tuberculosis triage in rural Peru, combining a two-stage computer vision pipeline (EfficientNetB0 + DenseNet121) with cough audio analysis (Librosa, MFCC). Selected as the top project among 9 teams and pitched to MIT instructors and industry professionals.
Nestle
Aug 2025 - Present

Data Strategy Analyst

Nestle - Lima, Peru

  • M&A Analytical Strategy (Nestle to Froneri): Technical Advisor leading analytical support during the transnational carve-out, ensuring system integrity, data mapping, and redesign of historical sales KPIs.
  • Field Execution Digitalization: Built 70+ scalable KPIs optimizing DAX/M code for 15M+ records with dynamic security (RLS, Entra ID), empowering 35+ distributors, 100+ supervisors, 70+ analysts.
  • Geo-matching: Engineered a Python algorithm (Databricks) for bidirectional matching between 70k+ prospects and 150k+ census of trade stores. Automated 60+ KML renders.
  • ETL Pipeline Optimization: Designed Snowflake-to-BI connection strategies, decreasing load times by 85% across 15M+ records.
MSc in Data Science & Artificial Intelligence
Aug 2024 - Aug 2026

MSc in Data Science & Artificial Intelligence

UTEC

  • Top 10% (Ranked 2nd).
Origination Analyst at Celepsa
Apr 2025 - Aug 2025

Origination Analyst

Celepsa - Lima, Peru

  • Orchestrated 12 ETL pipelines (Python, SQL Server, Airflow) automating 150M+ records from industry regulators, feeding 40 market intelligence processes.
  • Built predictive energy demand models achieving 92% accuracy for industrial clients.
  • Pitched business cases directly to commercial management for origination strategy.
Back-Office Analyst at Celepsa
Oct 2023 - Apr 2025

Back-Office Analyst

Celepsa - Lima, Peru

  • Developed analytical platform for free market clients (SEIN), reducing analysis time by 90%. Enabled 200+ new PPAs. Awarded Innovation Recognition.
  • Automated regulatory reports (SICLI, FOSE, FISE) with Airflow + Python, cutting operational times by 95%.
  • Built hybrid monitoring platform for 90+ monthly cross-departmental processes.
Customer Solutions Trainee at Celepsa
Dec 2022 - Oct 2023

Customer Solutions Trainee

Celepsa - Lima, Peru

  • Prepared 52 analysis reports on potential clients for PPAs and energy solutions (BESS, PV, Active Demand Management, Peak Shaving).
BSc in Energy Engineering at UTEC
Graduated

BSc in Energy Engineering

UTEC

  • Top 10% (Ranked 4th). Double Specialization in Renewable Energies and Electrical Systems.

Things I've built

A few projects I'm proud of, spanning MSc capstone work and enterprise platforms shipped in production.

Capstone · 20/20 Nov 2025 - Present

GeoMinder: Agentic RAG for Mining Consulting

Architected and deployed an agentic RAG system on GCP for technical document retrieval over unstructured engineering corpora (EIAs, ITS, design memorandums). Reached TRL 6 with an end-to-end pipeline validated against real mining consulting queries, plus a Streamlit UI with full source traceability.

GCPTerraformVertex AI RAGSpannerGoogle ADKGemini 2.5 FlashStreamlitPython
View on GitHub →
Big Data · 20/20 Feb 2026 - Apr 2026

Lumina Bank: Enterprise Big Data on GCP

Designed and deployed a multi-tenant data platform for a 12-entity banking federation (~9M client scenario), sustaining 5K+ TPS with sub-200ms p95 fraud scoring. Six Terraform modules cover network, ingestion, streaming, batch, serving, and warehouse layers end to end.

GCPTerraformCloud RunPub/SubDataflow + BeamDataproc + Spark MLlibBigQueryBigtableMemorystoreVertex AI
View on GitHub →
1st Place · MIT GTL AI Workshop Jan 2026

Qhali Ayllu: Multimodal Health Triage for Rural Peru

Multimodal Android app for early Anemia and Tuberculosis screening in rural Peru using only a smartphone, with no internet or lab equipment required. Combined a two-stage computer vision pipeline (EfficientNetB0 segmentation + DenseNet121 classification on conjunctival pallor) with a Librosa-based audio pipeline (MFCC, ZCR) on cough recordings, tuned via SVM, Logistic Regression, and Decision Trees for safe clinical triage. Selected as the top project among 9 teams at the MIT Global Teaching Labs AI Workshop (MIT MISTI · UTEC).

AndroidEfficientNetB0DenseNet121LibrosaMFCCZero Crossing RateSVMLogistic RegressionDecision TreesPython
Competition project, no public repo

Selected Earlier Work (2022 - 2025)

Earlier production platforms I built at previous companies, kept here for context on past delivery.

SEIN Free Client Analysis Platform

Celepsa · Dec 2022 - Nov 2023

Analytical platform for ~2,000 SEIN free-market clients that cut information-gathering time by 90% and supported 200+ PPA offers. Earned the Innovation Recognition by Celepsa and Termochilca.

MS SQL ServerPythonPower BIPower Automate

Customer Analytics Platform

Celepsa · Nov 2023 - Apr 2024

Centralized consumption, billing, contract, and commercial-margin analytics for 85 free and regulated clients across Celepsa, Celepsa Renovables, and Termochilca. Integrated automatically with the customer billing system and historized since 2020.

MS SQL ServerSIFACPythonPower BI

Regulatory Report Automation

Celepsa · Apr 2024 - Apr 2025

End-to-end automation of SICLI, SILIPEST, FOSE, and FISE regulatory reports for Celepsa, Celepsa Renovables, and Termochilca, reducing report generation and submission time by 95%.

Apache AirflowMS SQL ServerSIFACPythonPower BIPower Automate

Integrated Back-Office Task Management

Celepsa · Apr 2024 - Apr 2025

Automated platform centralizing 90+ monthly Back-Office processes and team workload monitoring, with a mobile companion view so staff could track indicators on the go.

MS PlannerPower AutomatePower BIMS CalendarOutlook

What I work with

Programming & ML

PythonPandasScikit-learnPyTorchTensorFlowPySparkSpark MLlibEfficientNetDenseNetLibrosaStreamlitAndroidSQLT-SQLPostgreSQLSparkSQLRTypeScript

Cloud, BI & Big Data

AzureDatabricksData FactorySnowflakeAWSS3SageMakerGCPBigQueryVertex AICloud RunPub/SubDataflowDataprocSpannerBigtableApache BeamPower BIPower AutomateAirflowKafka

Engineering & DevOps

GitDockerTerraformLinuxSSHPostmanQGISSAPMS Project

Languages

Spanish (Native)English (Advanced)Quechua (Basic)

Giving back

Community has always been a big part of who I am. Here are some of the ways I've tried to contribute.

Career Mentor

UTEC

Mar 2026 - Present

Advised graduating students to help them with their career path.

Peer Mentor

UTEC

Mar 2019 - Dec 2023

Advised incoming students to help them adapt to university life during their first term.

Director of Social Responsibility

Tinku UTEC

Mar 2022 - Jun 2023

Directed an organization encouraging physical activities for UTEC students.

Mental Health Support Advisor

Felizmente UTEC

Mar 2022 - Aug 2022

Participated in the Felizmente UTEC Support Network, helping students with their mental health.

Peer Coach

UTEC

Mar 2022 - Aug 2022

Offered opportunities for personal growth through self-awareness and goal-setting.

Academic Counselor

UTEC

Mar 2019 - Aug 2021

Advised people on course enrollment, taking into account abilities and time requirements.

Online Tutor

Encuentra tu sentido

Mar 2021 - May 2021

Tutored low-income children in math and English courses.

Catechist & Community Volunteer

Colegio Nuestra Señora Del Consuelo

2016 - 2020

Helped low-income families with meal preparation and supported children in coursework.

When I'm not crunching data

Outside of work, you'll probably find me shooting analog film, digging through vinyl crates, catching live shows (and yes, I collect setlists), lifting at the gym, or getting my hands dirty with some light gardening.

Analog PhotographyConcerts & SetlistsVinyl CollectingGymGardening
Photo

Ginyu Force!

Photo

Cusco Trip

Photo

Posing with Geordie Greep! One of my favourite artists

Photo

Lovely picture with Bôa!

Photo

Halloween time

Photo

Bouldering with my friends

What I've been building

My GitHub contributions (including private repos).

GitHub Contributions Chart
View my GitHub profile
Let's build something

Open to roles and startup ventures

If you are hiring for data, AI, or analytics roles, or building a startup that needs a data strategist who can ship end to end, I'd love to hear from you. The fastest way is to grab a slot directly on my calendar.

Book a 30 min chat Email me LinkedIn WhatsApp