Mar 2024 – Oct 2024 · 7 mos · Remote · Remote

Dec 2021 – Jul 2022 · 7 mos · Remoto · Remote

• As Head of Data Engineering at Meru.com (YC W21), I led a team of three data engineers and one data scientist (two in Mexico and two in Ningbo, China) in optimizing and refactoring algorithms for selecting profitable products and forecasting product prices. I used tools such as Python, SQL, Metabase, and Snowflake to guide category managers in Mexico and China towards their next recommended purchases. I migrated the pricing algorithms (in Python and AWS Lambda) to Airflow to maintain their stability and keep the prices of goods shipments up to date throughout their lifecycle in predictable time cycles, from manufacturing costs in China, shipping through a customs agent to the Ningbo port, international shipping costs, customs costs, and finally, last mile costs. I also migrated Python web scraping tools scripts (Scrapy.py and Selenium) to Airflow to understand market prices for products (web scraping of Amazon.mx, Mercado Libre), international shipping rates (web scraping of icontainers.com, searates.com), and other relevant data sources (web scraping of Shanghai Shipping Exchange). In addition, I developed a self-service architecture in Snowflake that facilitated data and analytics access across the company. I taught SQL and provided basic tools to lower the time-to-pie of all employees across the company while reducing the workload of the data engineering team.
• Developed and deployed production systems and prototypes using Python, Spark, and SQL on AWS and DataBricks.
• Led the "Data Champions" initiative, establishing development standards and enabling data self-service.
• Designed and implemented centralized data pipeline management systems using Python, Kedro, Flask, and FastAPI.
• Utilized OpenAPI for API documentation and integration, facilitating seamless communication between services.

Apr 2021 – Dec 2021 · 8 mos · Bogotá D.C. Metropolitan Area

• Decameron data assessment and cloud migration from Firebird 2 to Azure Databases (Postgresql)
• Conceptualized, developed, and launched a Buy Now Pay Later MVP. (MaterialUI)
• Enjoy Flowers data delivery and Klaviyo integration
• Build, keep and maintain all the data ingestion, and data delivery for the Decameron hotels group.
• Use A/B testing in order to select the best forecasting model for EnjoyFlowers comunications.
• Use A/B testing in order to select the best warehouse management model for Laika.
• Refactor and deliver to the production environment the data pipelines previously built in Kedro framework to the Azure infrastructure of the Decameron hotels.
• Developed forecasting capabilities for the Laika app
• (ABFS, Databricks, Datalake, Spark / Databricks) solution built in Kedro/Python.
• Keep and maintain the Klaviyo-Models integration for 'Enjoy Flowers' (Google Cloud Platform App engine), and deliver it to google cloud composer. solution built in Kedro/Python. part of the products were based on microservices architectures.
• Implemented a Machine Learning model predicting article success for Colombia's third most-read newspaper, resulting in a 32% increase in website traffic and USD 1.4M NPV profit.
• Applied a demand forecasting model, reducing lost sales due to stockouts by 30% for Colombia's largest pet supplies e-commerce, generating a USD 2.9M profit increase in NPV.
• Reduced churn rate by 5% for a flower subscription e-commerce in the US using Machine Learning models.

Jun 2020 – Jan 2024 · 3 yrs 7 mos · Bogota, D.C. · Remote

• Led the design and development of advanced AI applications, enhancing user interaction and financial management capabilities using Python.
• Directed a team of over 8 professionals through all phases of SDLC and STLC on core product initiatives and innovative backend solutions.
• Implemented and managed multiple Python-based backend services using FastAPI, SQLAlchemy, and Django.
• Developed and maintained analytics and event tracking systems using SQL, Kedro, and Airflow.
• Designed and implemented ETLT processes and personal financial assistance applications, improving the performance of Python applications through profiling and monitoring tools.
• Also, lead a team of 8 (engineers, designers and lawyers) in Americas and Europe in all the software development process.

Apr 2019 – Mar 2021 · 1 yr 11 mos · Remote · Remote

• Created the first version of Torre's internal ORM using Python, facilitating data analysis through the Gallifrey platform.
• Developed and managed ETL pipelines for delivering important data to C-level executives, which enhanced decision-making processes.
• Implemented operational dashboards using Python and related tools to improve data visualization and insights.
• Led the standardization of data definitions across the organization, resulting in a custom ORM and optimized data queries using AWS services.
• Keep and mantain the data infraestructure (S2 + Metabase instance built on docker and deployed over EBS)

Nov 2017 – Oct 2019 · 1 yr 11 mos · Bogotá D.C. Area, Colombia

• I Co-Founded the "CEDEX-Estudiantes" with Cinthya Carolina Sanchez Osorio, actual CIO of the Universidad de los Andes. At this time, we tried to implement an Artificial Intelligence that helped students with some of the most boring administrative tasks around the university, among other projects related to BPMN.

Jul 2017 – Nov 2017 · 4 mos · Bogotá D.C. Area, Colombia

• I made some presentations and helped to the development of the Facebook Developer Circles community in Bogotá during the second semester of 2017

May 2017 – Jun 2020 · 3 yrs 1 mo · Bogotá D.C. Area, Colombia

• The project "Agent Owl" was acquired by Universidad de Los Andes. It was a personal AI assistant that helped students across different matters. The project then became the "CEDEX-Estudiantes" or Students Innovation Excellence Center. My duties were to keep different projects and the team going until the different MVPs were ready.

Jul 2016 – Jul 2016 · 0 mo · Guadalajara Area, Mexico

• Guest speaker on FinTech, my speak "Beyound 1%" is about how to improve the User Experience of FinTech, Services and LaaS building on top of the existing social services and bleding edge APIs and services.
• This was also the first experience talking about conversational commerce in all americas.

Jul 2015 – Apr 2017 · 1 yr 9 mos · San Francisco Bay Area

• My duties consisted of Identifying, specifying and quantifying the current market opportunities for the application of Spontime, as well as for future products and services.
• Involve other departments of the company in the conception of a product that satisfies users in all its dimensions.
• Develop and present pre-launch tests (product, brand, etc.) for study by management.
• Prepare detailed user and technical specifications.
• Plan and execute the product development program as the project manager.
• Develop an attractive product offer to the customer with an important differentiation characteristic.
• Develop and manage the launch of the product to the market, including the orchestration of various sections of the company (product design and technical team).

Nov 2014 – Jun 2017 · 2 yrs 7 mos · Bogotá - Colombia

• On LaunchZap we used to connect technology when the internet fails through USSD modified protocols.

Jun 2014 – Jun 2014 · 0 mo · Cali, Colombia

• In PayRocket we were using Google Design Sprint methodologies in every step we take. We was invited to the Campus Party as Speakers for introduce new people to this methodologies. the keynote turned in a 40 hours workshop that helped to build some companies like EnLaTienda.co, and some others..

Nov 2013 – Jul 2014 · 8 mos

• TrackingMovil was a web-based optimization software to schedule and track deliveries or services in the road. It allows to efficiently manage fleets, supporting vehicle routing decisions, eassy communication between the fleet and the rout admin and route planning through new innovative algorithms.

Jul 2013 – Oct 2013 · 3 mos

• I have meet this group in the Startup Weekend English Edition, then, we bought this startup.

Oct 2012 – Dec 2013 · 1 yr 2 mos

• Reach Product-Market-Fit
• Product Design
• Sales
• Recruiting

Sep 2011 – Dec 2013 · 2 yrs 3 mos

• It’s a fact that in the construction industry, the early stages of a project include getting customers and funding. Drawings and models are very usefull tools to show and give an approximation of the final result of the project . The main objective of using tools is getting the feel of being inside the project and having a full experience of how it looks. When floor plans, drawings and models are combined with live photos and virtual tours they have reached their goal.
• Indeed, behind the plans and virtual tour demonstration of a project there is a long , tedious and expensive process of design that unfortunately does not communicates the scope and details of the project and leaves many details to imagination. Although these tools are helpful, not everyone can properly interpret a plane and a virtual tour, leaving at the end limitations, questions and unexplained details of the project. All the previous limitations create a difficult environment to make a decision or to accelerate any process of the project you are looking (house, apartment building, office).
• Glive is an online service that allows to create, publish, share and embed interactive 3D models online in real-time without plugin; created to overcome these drawbacks and provide virtual tours in the Internet, available and compatible with all browsers without installing additional software. Using WebGL technology is becoming the standard for online graphics rendering high quality and complexity. In addition to this, Glive provides interaction analysis to determine trends, tastes and impact areas of the project .

Nov 2013 – Jun 2020 · 6 yrs 7 mos · Colombia

• Acompañamiento estratégico a empresas incubadas dentro de Startup weekend, en las areas de desarrollo de producto, marketing digital, y estrategia.

Jul 2011 – Jun 2012 · 11 mos · San Juan de Pasto

• My work was to create, consolidate, and grouth the digital presence of one of the regionals of Rotary International in Internet.

Jun 2011 – Jul 2013 · 2 yrs 1 mo · Bogota

• Rotaract brings together people ages 18-30 in universities and communities worldwide to organize service activities, develop leadership and professional skills, and have fun. Rotary clubs sponsor them, but Rotaract members manage and fund their clubs independently. Rotaract members work closely with their local Rotary club, and may join after their Rotaract membership ends.

Sep 2010 – Apr 2017 · 6 yrs 7 mos · Bogotá D.C. Area, Colombia

• As Consultant and UX Designer I have worked with some high level companies, working on product design for new products and services, and modifying the user-product interaction of the old products.
• I have optimized, as design exercise, all the existing strategy for Onpage and Offpage SEO and SEM, redefined the strategy for search engine keywords and register process for MasterCard Developers Zone, with lab testing of 60% less churn rate.

Feb 2010 – Jun 2012 · 2 yrs 4 mos · San Juan de Pasto

• I've done field research about Architectonic typologies in the the "Qhapaq Ñan" i've work in the identification and georeferenciation of 5 types of Architectonic Typos in the rural zone of the Rumichaca-Pasto "QhapaqÑan" road, a ancient road that comunicates all of the most influential pre-hipanical cities in South America with Cusco. Part of my work (with close to 200 people) contributed to the world heritage nomination of the QÑ.