Simera Professional Key (SPK)

Juan Sebastián O

Colombia

Business & E-Commerce Advisor

$ 1,600/month

7 yrs exp

Skills

  • Business Intelligence
  • Data & Analytics
  • Data Analysis
  • Data Analytics
  • Digital Analytics
  • Event Management
  • Market Research
  • Procurement
  • Resource Management
  • Supply Chain
  • 3PL
  • CargoWise
  • Freight Tracking
  • HR Analysis
  • KPI Analysis
  • Meta Analytics
  • Power BI
  • Queue Management
  • Sales Analysis
  • SAP MM
  • SAP PM
  • Cost Control
  • Renewal Management
  • Business Intelligence Tools
  • PESTLE Analysis
  • PowerBI
  • Marketing Research
  • Process Optmization
  • customs clearance
  • Revenue management
  • Log Analysis
  • eProcurement
  • FTL
  • Process Automation
  • Advanced excel
  • incoterms 2020
  • Copilot
  • advance excel
  • trade compliance
  • Data Analysis,
  • • Data analysis
  • Grant Compliance
  • Business Intelligence (BI)
  • Advanced Excel
  • Release Management
  • Revenue Cycle Management
  • SAP DM
  • market reserch
  • Advanced Excel (MCP)

Juan Sebastián O

Colombia

Business & E-Commerce Advisor

$ 1,600 /month

7 yrs exp

Skills

  • Business Intelligence
  • Data & Analytics
  • Data Analysis
  • Data Analytics
  • Digital Analytics
  • Event Management
  • Market Research
  • Procurement
  • Resource Management
  • Supply Chain
  • 3PL
  • CargoWise
  • Freight Tracking
  • HR Analysis
  • KPI Analysis
  • Meta Analytics
  • Power BI
  • Queue Management
  • Sales Analysis
  • SAP MM
  • SAP PM
  • Cost Control
  • Renewal Management
  • Business Intelligence Tools
  • PESTLE Analysis
  • PowerBI
  • Marketing Research
  • Process Optmization
  • customs clearance
  • Revenue management
  • Log Analysis
  • eProcurement
  • FTL
  • Process Automation
  • Advanced excel
  • incoterms 2020
  • Copilot
  • advance excel
  • trade compliance
  • Data Analysis,
  • • Data analysis
  • Grant Compliance
  • Business Intelligence (BI)
  • Advanced Excel
  • Release Management
  • Revenue Cycle Management
  • SAP DM
  • market reserch
  • Advanced Excel (MCP)

Business & E-Commerce Advisor

All Road Electrónica Automotriz
January 2026 - present

Designed and implemented an e-commerce website for the commercialization of imported auto parts, integrating the product catalog directly with the import supply chain from the USA, ensuring real-time inventory availability and total stock visibility. Structured the end-to-end import supply chain (supplier-origin-freight-customs-inventory-sales), negotiating rates with multiple forwarders and optimizing FCL/LCL and air consolidations to reduce logistics costs without compromising delivery times. Developed a pricing strategy for the digital channel, aligned with the import cost structure, Incoterms, and competitive market analysis, achieving an increase in gross margin and differentiated positioning in the auto parts segment. Managed end-to-end import operations (origin-customs-last mile) with customs documentation free of observations, coordinating each stage of the logistics chain with US suppliers and local freight agents.

Ocean Revenue Care Specialist

Kuehne + Nagel
June 2025 - December 2025

Reduced billing discrepancies in FCL/LCL import operations to the USA by implementing cross-controls between operations and accounting in CargoWise. Identified revenue leaks in import shipments, recovering unfactored amounts through systematic margin analysis per shipment. Optimized the financial closing cycle by coordinating operations, accounting, and customer service, improving the area's cash flow.

Business & E-Commerce Advisor

Tecno Jeep
January 2023 - June 2025

Designed and implemented an e-commerce website for the commercialization of imported auto parts, integrating the product catalog with the import supply chain from the USA to maintain real-time inventory availability. Structured the end-to-end import supply chain (supplier-origin-freight-customs-inventory-sales), negotiating rates with multiple forwarders and optimizing FCL/LCL and air consolidations. Developed a pricing strategy for the digital channel, articulated with the import cost structure, Incoterms, and competitive analysis, increasing the gross margin and consolidating market positioning. Managed end-to-end import operations with customs documentation free of observations and zero retention incidents during the period.

Pricing Analyst – Procurement

Global Logistical Connections INC
November 2021 - November 2022

Quoted international routes with high tariff accuracy, improving the commercial closing rate and the competitiveness of proposals in the market. Coordinated with freight agents and international suppliers, achieving savings in logistics costs on priority routes using SAP MM.

Cargo Agent – Air Operations

Avianca Cargo
February 2021 - August 2021

Supervised air cargo operations in the warehouse with zero errors in the issuance of export documentation during the period.

Customer Service Advisor

DHL Express
January 2020 - August 2020

Advised B2B clients on import/export processes, tariffs, and customs regulations, achieving a high retention rate in the assigned portfolio. Resolved most cases on first contact by applying knowledge of Incoterms and DHL routes, reducing operational escalations.

International Trade Consultant

Incodepf SA
May 2018 - January 2020

Structured logistics costs for exporting clients, reducing operational costs through analysis of Incoterms, optimal routes, and negotiation with operators. Acquired new international clients by managing complete origin-destination logistics operations with a high rate of delivery compliance.

Smart Scores

Communication
80
Role Fit
90
Adaptability
80
Problem-solving
90

Smart Skills

beta