Guillermo Arango Mesa

Experience

• 

  Cueros Vélez

  Oct 2018 - Jul 2019

  Inventory analyst

  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.

• 

  Tennis S. A.

  Jul 2019 - Aug 2023

  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. Show less 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. Show less

  • Front end developer

    Feb 2022 - Aug 2023

  • BI Analyst

    Jul 2019 - Feb 2022
• 

  ST. EVEN

  Apr 2024 - Nov 2024

  Web developer

  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. Show less

• 

  Equielect

  Nov 2024 - now

  Development analyst

  Responsibilities:-Develop the internal web application, writing backend code using: NodeJS, Express, Router, MVC Model, and MongoDB; and the frontend using: JavaScript, React, NextJS, HTML, and CSS to improve internal processes such as Human resource, purchasing and administrative processes.-Create and develop a refreshed version of the company's webpage writing code using: writing backend code using: NodeJS, Express, Router, MVC Model, and MongoDB.-Create and define the structure and schema of databases, optimizing query performance for the backend and the deployment and retrieval of data using MongoDB.Achievements: -Create a purchase module for users to query and download information regarding orders that otherwise would take them up to one minute to query each. They can also keep track of issues of each order and give feedback of the overall process.-Develop a Human resources module for users to download their pay slips and certificates. In this module, users can also inform the reasons why they are asking for days off and ask for loans. Show less