Juan Botero

eCommerce PM

Yara

Mar 2021 - Current (4 years 3 months)

● Lead agile project teams in strategies throughout all the customer journey and creation of reporting models for constant monitoring in the different digital innovation products. ● Perform and facilitate workshops driven by customer journeys, pain points, estimating product lifecycle and establishing priorities according to the vision strategy. ● Modeled business cases – business plans, with expected sales volumes and cash, pricing models, inventories, forecasting EBITDA, NPV and other financial indicators. ● Managed Adobe Commerce platform, stakeholder communications, budget control, negotiation with external providers of new capabilities, payment gateways, commercial activities, and digital marketing solutions. ● Drive eCommerce sales t

Digital marketing coordinator

Inalde Business School

Jul 2019 - Mar 2021 (1 year 9 months)

- I framed and unified all the databases and client segmentations to establish a more efficient multichannel inbound marketing strategy, as well as the creation of the growth hacking strategy in LinkedIn and WhatsApp - I settled in my team the reporting “culture” as a way of tracking the strategy, analytics, and the performance of digital initiatives - I renegotiated the inbound marketing tool (HubSpot) achieving a 25% save on the monthly fee - General admin of the inbound marketing tool - Management of digital strategy among the different platforms and channels comprising the digital inbound marketing strategy for contents, ads, email marketing, SMS, and workflow automation (Oracle Eloqua – HubSpot) - Lead of reporting and business intelli

Digital Lead

Brands Holding

Jun 2018 - Jul 2019 (1 year 2 months)

- Along with the CEO, I created the cost and time structure to plan duration, resource use, and project prices offered by the company - Via Facebook networking, I managed to attract 10% of the company’s clients - I structured the company CRM, HubSpot, and with it I created follow up sales and marketing reports in Power BI - Along with the CEO, I created the complete structure of the digital project path, from ideation design and development, marketing strategy, and tracking analytics with business intelligence processes, to finalize with the investor approach strategy - Direction of the digital area; management of web projects, e-commerce (WooCommerce, Magento), mobile apps, cloud solutions, digital analytics, organic marketing strategies,

E-commerce & marketing economist

Chef

Dec 2017 - Jun 2018 (7 months)

- I formulated the data mining structure and data collection to know the ice cream flavor of the new milkshake of one of the most popular fast food chains of Colombia - With the connection to data of several e-commerce, I created the reporting structure to identify the best sellers on the e-commerce - Created a predictive model according to user behavior while shopping, while abandoning the cart and with integration of weather data to identify trends and patterns according to the model - E-commerce follow up through data mining, database modeling in Power BI and Excel to reach relevant insights that allowed the strategic decision making - Database integration of the VTEX e-commerce and Google Analytics to compare the digital strategy with t

Digital analyst - Project manager

avianca

Aug 2016 - Dec 2017 (1 year 5 months)

- Along with the consultant, I created the reporting model and tracking of the PMO where times, resources and efficiencies were monitored. With this model we managed to reach a more efficient and Dynamic process within task assignation and execution - I created with the designer, the Avianca Corporate roadmap for the digital transformation of the brand, with the UX and web development design strategy, as well as the marketing strategy with a strong buyer persona identification - Management and development of digital transformation projects, updates, or creation of new ones, in the eBusiness Digital Experience area of Avianca (revenue / e-commerce, UX, social media and e-com operations) - Identification of patterns in several touch-points of

Project manager

avianca

Aug 2016 - Dec 2017 (1 year 5 months)

B

Co-founder, board member

Big Bang Labs

Oct 2015 - Dec 2018 (3 years 3 months)

- Design of the digital strategy for social media, website lead acquisition and creation of the service offering and work methodologies for the implementation of management and control solutions with audits and continuous improvement processes - Digital transformation of learning processes with games (gamification)

S

Strategic planning manager

Servigenerales S.A. E.S.P.

Aug 2012 - Sep 2014 (2 years 2 months)

- I implemented the Balanced Scorecard of the 25 company's agencies. The cube build-up was a joint project by Strategic Planning Office and IT Office, which had as a result, a software that collects all cubes in one senior management interface - While building this interface, the Strategic Planning Office made audits and data evaluations to guarantee the correct collection of information - Along this, the corrective actions started to be generated in order to accomplish goals the organization previously set - At the same time, through the corrective actions, it was evidenced that the information was not totally reliable, the reason why multiple audits where made - Afterwards, with the collaboration of the IT department, the information was

Intern

Caldas Government

Sep 2008 - Jan 2009 (5 months)

- Obtaining approved contracts for the entrepreneurs in the region, by internal paperwork management inside the Government, following the project's approval and finishing with the financial aid for the start of their project - Support in the process of contracts and project execution for entrepreneurship for persons and small and medium sized enterprises in Caldas, Colombia - Support in managing entrepreneur's applications of the region by giving advise of the viability of their projects according to the approved budget for entrepreneurship in Caldas

A

Economic assistant

Alberto Botero Castro

May 2005 - Aug 2016 (11 years 4 months)

- Link the Historical Value Matrix with each settlement table of the mortgage or credit, obtaining particular values according to each settlement due to the uniqueness of each client's debt - With the linkage between formulae, databases, and sheets, the time saving in typing increases drastically and by that means, the analysis of each debt is done within shorter periods increasing effectiveness in the process - Definition and creation of formulae (in Microsoft Excel) to digitalize and calculate the financial settlements and executions of mortgages and/or credits for free investment - Technical support to the elaboration of the database for managing Colombian macroeconomic parameters (UVR - IPC - UPAC)

About

Detail

Contact Juan regarding:

Timeline

Résumé

Languages:

Juan's behavioral traits
Juan's likely patterns of behavior, thought, values, and emotion. Based on the HEXACO model, OCP instrument, and Torre’s own research.