Osvaldo Miranda

Implementing the Data Engineering Lifecycle¹ with Python and AWS

GitHub | Website | contacto@omiranda.dev | LinkedIn | 📍Mérida, Yucatán - México 🇲🇽

👨‍💻 Experience

Senior Data Engineer at Clip (August 2023 - Present)
Mexican fintech that provides businesses with a full suite of payment solutions.

• Led a project aimed at reducing computation costs, achieving a 40% reduction in average daily expenses by taking action on three main axes:
  • Reconfigure compute clusters to optimize the query load metric.
  • Redistribute the query load to different compute clusters according to compute power requirements.
  • Perform extensive housekeeping tasks on the data platform to reduce the impact of heavy processes.
• Main technologies used: Python, Snowflake, AWS Databricks, GitHub.

Data Engineer at Clip (Apr 2022 - July 2023)

• In a team effort, reduced computation related costs by ~65% through heavy refactoring of internal processes.
• Led the effort to automate key regulatory reports, saving ~5 person-hours a month.
• Implemented a table to showcase the relationship between movements of a ledger book using a FIFO approach.
• Extensive support to data analysts to help them automate key processes, saving ~25 person-hours a month.
• Develop and monitor data pipelines to support the OLAP environment.
• Refactored three steps of the CI/CD (GitHub Actions), achieving a reduction in execution time from ~5 min to ~40 sec each.
• Develop and improve internal Python tools to reduce boilerplate.
• Main technologies used: Python, Snowflake, AWS Databricks, GitHub.

Data Analyst at Clip (Aug 2021 - Apr 2022)

• R-to-Python translation of key processes of the Growth team. Automation saved ~30 person-hours a month.
• Collaborated in a BI platform switch effort by taking ownership over 15 dashboards.
• Occasionally helped the Data Engineering team with no critical coding tasks.
• Main technologies used: R, Python, Snowflake, Looker, Sisense.

Technical-financial at HDI Seguros México (Jan 2021 - Aug 2021)
Insurance company part of Talanx Group.

• Data extraction and wrangling to perform ad-hoc analysis for the daily operation of the area.
• Automation of BAU processes, saving ~8 hours a month.
• Main technologies used: R, Microsoft Excel.

Statistician consultant at Secretariat of Culture (Jan 2020 - Dec 2020)
A Mexican government branch in charge of implementing public policies regarding arts and culture.

• Computation of metrics used to gain insights of the situation of cultural agents.
• Design and delivery of internal courses to improve the tech skills of the personnel.
• Main technologies used: R, Microsoft Excel.

Data Science Intern at Nielsen México (Jan 2019 - Dec 2019)
Firm focused on market measurement.

• Monthly reporting on key metrics owned by the team.
• Automation with R of data analysis processes.
• Main technologies used: R, Microsoft Excel, Google Data Studio.

Deductions & Disputes Intern at Henkel México (Feb 2017 - Feb 2018)
Consumer goods company.

• Automation with VBA of BAU processes, saving ~50 person-hours a month.
• Owned the BAU processes of the area related to credit disputes.
• Main technologies used: VBA, Microsoft Excel.

💬 Languages

🇪🇸 Spanish: Native
🇺🇸 English: Proficient
🧏 Mexican Sign Language: Conversational

🎓 Education

Universidad Nacional Autónoma de México
Actuary.

Footnotes

1. I'm borrowing the term from Fundamentals of Data Engineering. Plan and Build Robust Data Systems, by Joe Reis & Matt Housley. ↩