Osvaldo Miranda
Implementing the Data Engineering Lifecycle with Python and AWS
GitHub |
Website |
[email protected] |
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.