Parcourir les catégories
Explorer
Fiverr Pro
Français
$
USD
Julian Lopez
@julian_1127
Analytics Engineer
Colombie
Espagnol, Anglais
À propos de moi
I automate financial reconciliation for e-commerce businesses: Stripe, Shopify, PayPal, bank statements and your accounting system, matched automatically with a clear report of every discrepancy. I lead finance and data at a US–Colombia e-commerce company, where I built a system that reconciles 7 sources and thousands of transactions a month, and I have delivered 50+ Power BI and Streamlit dashboards for a major LatAm retailer. Economist by training: I understand the accounting behind the numbers, not just the code. Send me a sample file and I will tell you in 24 hours what can be automated.
Compétences
Julian Lopez
hors ligne •
Voir mes services
Automatisations
I will automate payment reconciliation for stripe, shopify, paypal and your bank
Expérience professionnelle
Ecommerce
Temps plein • 2 yrs 11 mos
Head of Finance & Data
Feb 2026 - Present • 7 mos
Lead the finance and data function of a US–Colombia e-commerce and package-forwarding company. Built from scratch the company's financial reconciliation system: it ingests bank, payment-gateway and carrier data daily, matches it against e-commerce transactions using Python and fuzzy matching, and flags every discrepancy. Reconciles 7 data sources and thousands of movements a month, integrated with the ERP for invoicing. Also built the ETL pipelines, the Streamlit and Looker Studio dashboards, and the P&L model the business runs on.
Data Analyst, Digital Payments
Oct 2023 - Feb 2026 • 2 yrs 4 mos
Owned analytics for the digital-payments unit of one of Latin America's largest retailers: data quality, reconciliations, BI and decision support. Built 50+ Power BI dashboards in daily use across Payments, Operations, Viajes Éxito and Móvil Éxito, automated consolidation pipelines integrating sales, payment gateways and risk engines with discrepancy alerts, and sales and provision forecasting models used in financial planning.
Compliance Associate
Finance, • Temps plein
Jan 2023 - Oct 2023 • 9 mos
Built AI-based segmentation models to monitor the behavior of 6M+ customers under Colombia's SAGRILAFT anti-money-laundering framework, with BI dashboards for daily traceability of alerts and risk.
