Looking for a job

Mario Plascencia

@marioplascencia

Senior Analyst at Mercado Libre optimizing dedicated-fleet planning and automating comparisons that cut scenario analysis to about five minutes.

Mexico

Message

At Mercado Libre, I work on dedicated-fleet planning analytics, using a Python-based solution to automate Input vs. Output comparisons. It reduced manual analysis from 30–60 minutes to about five minutes per scenario.

I also developed validation processes that reduced services without system-generated assignments to zero, and I analyze fleet utilization, capacity, and profiles to support operational decisions. In specific cases, fleet profile changes reduced the previous scheme cost by about 40%.

Before Mercado Libre, I developed Oracle/PLSQL solutions at BBVA and Grupo Salinas, and worked on data centralization and governance at MEJOREDU. My experience also includes data modeling, analytics, process automation, and cross-functional work with operations and technology teams.

Experience

Work history, roles, and key accomplishments

Current

Senior Analyst - Line Haul, Shipping

Current

Mercado Libre

Oct 2024 - Present (2 years)

Responsible for analytics and dedicated fleet planning optimization across a large operation. Led development of Python-based automation, reduced manual analysis time, and drove validation processes to eliminate service assignment incidents.

SQL BigQuery Python Looker HTML Data Analysis Process Automation Fleet Planning Logistics Data Quality

Oracle Specialist Developer - Insurance

BBVA

Nov 2023 - Oct 2024 (11 months)

Designed and developed the first product in the area supporting two payment methods, enabling individual and bulk policy issuance. Modeled product logic and optimized queries, reducing execution time from ~6-7 minutes to ~2 minutes.

Oracle Pl SQL Data Modeling Query Optimization Batch Processing Procedures Functions

Oracle Specialist Developer - Employee Well-being

Grupo Salinas

Jan 2022 - Dec 2023 (1 year 11 months)

Contributed to replacing a manual process handling ~2,000-3,000 monthly tickets with a centralized solution by developing data structures and integrations through APIs/Web Services. Standardized information and optimized queries, reducing times from ~10 minutes to 2-3 minutes.

Oracle Pl SQL APIs Web Services Data Modeling Query Optimization Master Data

Department Head - Data & Data Governance

Mejoredu

Jan 2021 - Dec 2022 (1 year 11 months)

Owned national education data centralization, quality, and governance initiatives, defining business rules and validations to reduce duplication and improve consistency. Designed data models and led migration activities from MySQL to PostgreSQL.

Data Governance Data Quality Data Modeling MySQL PostgreSQL Relational Databases Star Schemas Dimensional Modeling (Star And Snowflake Schemas)Constellation Schema

Software Engineer - Private Banking

BBVA

Jan 2017 - Dec 2021 (4 years 11 months)

Designed data structures and models for investment products serving clients based in Houston. Participated in end-to-end development and validation of financial products, coordinating functional testing with users and central teams.

Data Modeling Software Development Financial Products Functional Testing Stakeholder Coordination