Kategorien durchsuchen
Entdecken
Fiverr Pro
Deutsch
$
USD
Julian Lopez
@julian_1127
Analytics Engineer
Kolumbien
Spanisch, Englisch
Über mich
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.
Kompetenzen
Julian Lopez
offline •
Meine Dienstleistungen
Automatisierungen
I will automate payment reconciliation for stripe, shopify, paypal and your bank
Arbeitserfahrung
Ecommerce
Vollzeit • 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, • Vollzeit
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.
