j
julian_1127

Julian Lopez

@julian_1127

Analytics Engineer

Colombia
Spanish, English
About me
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.... Read more

Skills

j
julian_1127
Julian Lopez
Offline • 

See my services

Automations
I will automate payment reconciliation for stripe, shopify, paypal and your bank
From$75 / projectMore details

Work experience

Ecommerce

Full-time • 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.

Finance,

Compliance Associate

Finance, • Full-time

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.