Guillermo Arango Mesa Email & Phone Number

Medellín, Departamento Antioquia, Colômbia

Medellín, Antioquia, Colombia

Responsibilities:-Develop the web application for the mass consumption sector, writing backend code using: NodeJS, Express, ExpressJS, Router, MVC Model, and MySQL; and the frontend using: JavaScript, React, HTML, and CSS, to automate inventory traceability between stores.-Create and develop new frontend components using tools such as: JavaScript, React, Liquid, Shopify, HTML, and CSS, creating new functionalities that improve the product list page, registration forms, interactive games, and new landing pages to enhance user experience.-Create and define the structure and schema of databases, optimizing query performance for the backend and the deployment and retrieval of data using MySQL.Achievements:-Increased sales by 60% through the creation and redesign of the website frontend.-Automated the a manual inventory transfer process, reducing the time per request from 5 minutes to 5 seconds.-Automated the inventory transferring process within stores using Python, reducing the process time from 2 hours to 10 seconds.

Medellín, Antioquia, Colombia

Responsibilities:-Develop new functionalities for the website: size availability on the product list page, auctions, site navigability, SEO structure, among others, using JavaScript, React, HTML, CSS, jQuery, Google Tag Manager, VTEX Legacy, and API calls, to increase the conversion rate.-Create and define API calls to the VTEX database to connect with the frontend using JavaScript, impacting customer experience and automating the process of price updates and live processes on the website.-Optimize back-office processes using Power BI and Power Pivot to create automated reports that generate relevant insights about sales and e-commerce inventory.Achievements:-Increased the brand's sales, generating up to 200 million pesos in daily revenue by developing new functionalities for the e-commerce platform.-Boosted sales revenue by 150% by implementing an auction campaign to improve product positioning on the e-commerce site.-Built from scratch the dashboard that identified sales and inventory behavior, leading to the creation of new KPIs.

Medellín, Antioquia, Colombia

Responsibilities:-Automate reports and dashboard-building processes in Power BI and Power Pivot, allowing data extraction and loading into the final model to identify relevant insights on KPIs for the sales and planning areas.-Generate ETL processes to analyze behavior and comparisons of various variables: price, costs, margin, units per ticket, average ticket, among others, with the aim of identifying relevant insights for business improvement.-Automate processes for the commercial and back-office areas, enabling real-time observation of store movements, inventory tracking, among others, using Python and Visual Basic for Applications, impacting the creation of new indicators and improving the performance of existing ones.Achievements:-Reduced inventory transfer process by 81% by implementing automation processes in Python.

Medellín, Antioquia, Colombia

Responsible for dispatching merchandise to stores from the Outlet channel. Simultaneously, in charge of automating processes with Visual Basic for Applications and generating reports with Power query, Power pivot and Power Bi for the correct inventory administration.

Education record

Carrera De Desarrollo De Aplicaciones, Web/Multimedia Management And Webmaster

Frontend Specialist, Computational Science